boardom

mikelittle · Joined: 11 May 2002 Posts: 376 Location: UK

Hi people,
I've just released a new hack. Inspired by a conversation on IM about the recent request to be able to turn off a blog from the admin tool. I have produced a hack which will allow you to define arbitrary extra options, set their values in the admin tool and use them in your templates.

This will give you the ability to, for example, add the following to your main template:
[php:1:5029d4e098]<?php
include_once("./b2extraoptions.php");
if (get_extraoption('blog_closed') == 'true') {
die("The blog is closed, sorry.");
?>[/php:1:5029d4e098]
and be able to control the value of 'blog_closed' from the admin tool.

Or you could define a option called 'default_skin' and again administer that from the admin. The sky is the limit

This is a 0.1 release, but I think it is already useful.

You can find details, and down load it from http://zed1.com/b2extraoptions/b2extraoptions.html

Please post bug reports, fixes, comments, questions, etc. to this topic in this forum.

Enjoy,
Mike
_________________
Mike Little
http://zed1.com/journalized/
"Share what you know. Learn what you don't."

mikelittle · Joined: 11 May 2002 Posts: 376 Location: UK

It looks like there may be a problem with using this in IE 6.
Probably Javascript. I'll look into it tomorrow.

Sorry,
Mike
_________________
Mike Little
http://zed1.com/journalized/
"Share what you know. Learn what you don't."

mikelittle · Joined: 11 May 2002 Posts: 376 Location: UK

It was broken on IE5 too. So this fix for IE5 may fix it for IE 6
Update: It does indeed fix it for IE 6

At line 375 in b2extraoptionsmanager.php change to

seeya · Joined: 13 Jul 2002 Posts: 32 Location: Singapore

wat do u mean by this ???

.Chris · Joined: 30 Apr 2002 Posts: 186 Location: Hawaii

I thought I'd try it out but I can't even get it installed. I keep getting this error:

mikelittle · Joined: 11 May 2002 Posts: 376 Location: UK

I will turn the table creation into a php script.
I've been pretty much asked the same thing for another of my hacks.

I'll work on it now....
_________________
Mike Little
http://zed1.com/journalized/
"Share what you know. Learn what you don't."

mikelittle · Joined: 11 May 2002 Posts: 376 Location: UK

OK. Here is a first pass at a table creation script. Upload this to your B2 directory as b2extraoptions.install.php and 'call' it with your browser http://www.your.domain/b2extraoptions.install.php

[php:1:61f3fca75c]<?php
// $Id$
//
// B2 Extra Options
// Copyright (C) 2002 Mike Little -- [email protected]
//
// This is an add-on to b2 weblog / news publishing tool
// b2 is copyright (c)2001, 2002 by Michel Valdrighi - [email protected]
//
// **********************************************************************
// Copyright (C) 2002 Mike Little
//
// This program is free software; you can redistribute it and/or modify
// it under the terms of the GNU General Public License as published by
// the Free Software Foundation; either version 2 of the License, or
// (at your option) any later version.
//
// This program is distributed in the hope that it will be useful, but
// WITHOUT ANY WARRANTY; without even the implied warranty of
// MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
// General Public License for more details.
//
// You should have received a copy of the GNU General Public License
// along with this program; if not, write to the Free Software
// Foundation, Inc., 675 Mass Ave, Cambridge, MA 02139, USA.
//
// Mike Little ([email protected])
// *****************************************************************

// Start Connect To MYSQL
require_once("b2config.php");
include_once("$b2inc/b2vars.php");
include_once("$b2inc/b2functions.php");

$tableextraoptions = "b2extraoptions";
$tableextraoptiontypes = "b2optiontypes";

$got_options = false;
$got_types = false;

?><html>
<head>
<title>b2 > Installation</title>
</head>
<body>
Checking for tables...
<?php
$result = mysql_list_tables($dbname);
if (!$result) {
print "DB Error, could not list tables\n";
print 'MySQL Error: ' . mysql_error();
exit;
}

while ($row = mysql_fetch_row($result)) {
if ($row[0] == $tableextraoptions)
$got_options = true;
if ($row[0] == $tableextraoptiontypes)
$got_types = true;
//print "Table: $row[0] \n";
}
if (!$got_types) {
echo "Can't find table '$tableextraoptiontypes', gonna create it...\n";
$sql = "CREATE TABLE $tableextraoptiontypes ( " .
" option_id int(11) NOT NULL auto_increment, " .
" option_name tinytext NOT NULL, ".
" PRIMARY KEY (option_id) ".
") ";
$result = mysql_query($sql) or print ("Can't create the table '$tableextraoptiontypes' in the database. " . $sql . " " . mysql_error());
if ($result != false) {
echo "Table '$tableextraoptiontypes' created OK\n";
$got_types = true;
}
} else {
echo "Found table '$tableextraoptiontypes', don't need to create it...\n";
}

if (!$got_options) {
echo "Can't find '$tableextraoptions', gonna create it...\n";
$sql = "CREATE TABLE $tableextraoptions ( " .
" option_id int(11) NOT NULL auto_increment, " .
" option_name varchar(64) UNIQUE NOT NULL default '', " .
" option_type int(11) NOT NULL default 1, " .
" option_value varchar(255) NOT NULL default '', " .
" option_description varchar(255) NOT NULL default '', " .
" option_level int NOT NULL DEFAULT '1', " .
" PRIMARY KEY (option_id) " .
") ";
$result = mysql_query($sql) or print ("Can't create the table '$tableextraoptions' in the database. " . $sql . " " . mysql_error());
if ($result != false) {
echo "Table '$tableextraoptions' created OK\n";
$got_options = true;
}
} else {
echo "Found table '$tableextraoptions', don't need to create it...\n";
}

if ($got_options && $got_types) {
$got_1 = false;
$got_2 = false;
$got_3 = false;
$got_4 = false;

echo "Looking for types...\n";
$sql = "SELECT option_id, option_name FROM $tableextraoptiontypes ";
$result = mysql_query($sql) or print ("Can't query '$tableextraoptiontypes'. " . $sql . " " . mysql_error());
if ($result != false) {
while ($row = mysql_fetch_object($result)) {
if ($row->{'option_id'} == 1) {
echo "You have got type 1. Good!\n";
$got_1 = true;
}
if ($row->{'option_id'} == 2) {
echo "You have got type 2. Good!\n";
$got_2 = true;
}
if ($row->{'option_id'} == 3) {
echo "You have got type 3. Good!\n";
$got_3 = true;
}
if ($row->{'option_id'} == 4) {
echo "You have got type 4. Good!\n";
$got_4 = true;
}
}

if (!$got_1) {
echo "Gonna insert type 1...\n";
$sql = "INSERT INTO $tableextraoptiontypes (option_id, option_name) VALUES (1, 'int')";
$result = mysql_query($sql) or print ("Can't insert type. " . $sql . " " . mysql_error());
if ($result != false) {
echo "Inserted type Ok\n";
$got_1 = true;
}
}
if (!$got_2) {
echo "Gonna insert type 2...\n";
$sql = "INSERT INTO $tableextraoptiontypes (option_id, option_name) VALUES (2, 'boolean')";
$result = mysql_query($sql) or print ("Can't insert type. " . $sql . " " . mysql_error());
if ($result != false) {
echo "Inserted type Ok\n";
$got_2 = true;
}
}
if (!$got_3) {
echo "Gonna insert type 3...\n";
$sql = "INSERT INTO $tableextraoptiontypes (option_id, option_name) VALUES (3, 'string')";
$result = mysql_query($sql) or print ("Can't insert type. " . $sql . " " . mysql_error());
if ($result != false) {
echo "Inserted type Ok\n";
$got_3 = true;
}
}
if (!$got_4) {
echo "Gonna insert type 4...\n";
$sql = "INSERT INTO $tableextraoptiontypes (option_id, option_name) VALUES (4, 'date')";
$result = mysql_query($sql) or print ("Can't insert type. " . $sql . " " . mysql_error());
if ($result != false) {
echo "Inserted type Ok\n";
$got_4 = true;
}
}
} else {
echo ("No results from query '$tableextraoptiontypes'. " . $sql . " " . mysql_error());
}

$got_option_1 = false;
$got_option_2 = false;

echo "Looking for extra options...\n";
$sql = "SELECT option_name FROM $tableextraoptions ";
$result = mysql_query($sql) or print ("Can't query '$tableextraoptions'. " . $sql . " " . mysql_error());
if ($result != false) {
while ($row = mysql_fetch_object($result)) {
if ($row->{'option_name'} == 'add_options_min_level') {
echo "You have got 'add_options_min_level'. Good!\n";
$got_option_1 = true;
}
if ($row->{'option_name'} == 'blog_closed') {
echo "You have got 'blog_closed'. Good!\n";
$got_option_2 = true;
}
}

if (!$got_option_1) {
echo "Gonna insert extra option 1...\n";
$sql = "INSERT INTO $tableextraoptions " .
" (option_id, option_name, option_type, option_value, option_description, option_level) " .
" VALUES (1,'add_options_min_level', 1, '10','The minimum user level to add/edit extra options.', 10)";
$result = mysql_query($sql) or print ("Can't query extra option. " . $sql . " " . mysql_error());
if ($result != false) {
echo "Inserted extra option Ok\n";
$got_option_1 = true;
}
}
if (!$got_option_2) {
echo "Gonna insert extra option 2...\n";
$sql = "INSERT INTO $tableextraoptions " .
" (option_id, option_name, option_type, option_value, option_description, option_level) " .
" VALUES (2,'blog_closed', 2, 'false','Set this to true to temporarily close the blog.', 5)";
$result = mysql_query($sql) or print ("Can't query extra option. " . $sql . " " . mysql_error());
if ($result != false) {
echo "Inserted extra option Ok\n";
$got_option_2 = true;
}
}
}

}

if ($got_1 && $got_2 && $got_3 && $got_4 && $got_option_1 && $got_option_2) {
echo "All done.\n";
}
?>
</body>
</html>
[/php:1:61f3fca75c]

Let me know of any problems. I'll include this in the next release.

Mike
_________________
Mike Little
http://zed1.com/journalized/
"Share what you know. Learn what you don't."

mikelittle · Joined: 11 May 2002 Posts: 376 Location: UK

Folks,
There is a new version of B2 Extra Options. Version 0.2

The only new things in this version are a fix for the JavaScript problems in Internet Explorer
and the addition of the install file (posted earlier)

You can download it from the B2 Options page

Enjoy,
Mike
_________________
Mike Little
http://zed1.com/journalized/
"Share what you know. Learn what you don't."

name_me · Joined: 31 Jan 2003 Posts: 12 Location: Ukraine

name_me · Joined: 31 Jan 2003 Posts: 12 Location: Ukraine

Greetings again Smile

mikelittle, i've compared installers from b2LinkManager and b2ExtraOptions and noticed that in b2extraoptions.install.php you've forgotten to insert this lines (i got them from b2links.install.php):

[list=]$connexion = mysql_connect($server,$loginsql,$passsql) or die("Can't connect to the database ".mysql_error());
$dbconnexion = mysql_select_db($base, $connexion);[/list]

After that, all code of installer worked correctly.

mikelittle · Joined: 11 May 2002 Posts: 376 Location: UK

Hi name_me,
Glad you got it sorted. I'll have to get round to issuing a new version with the fix in. Meanwhile, I'll add something to the web page.

Thanks for working it out.

Mike
_________________
Mike Little
http://zed1.com/journalized/
"Share what you know. Learn what you don't."

xytx · Joined: 24 May 2003 Posts: 48

i did everything but i dont have a tab on my after login page? did i do something wrong?

mikelittle · Joined: 11 May 2002 Posts: 376 Location: UK

Is your account admin level 5 or above?
_________________
Mike Little
http://zed1.com/journalized/
"Share what you know. Learn what you don't."

xytx · Joined: 24 May 2003 Posts: 48

yea its 10.

mikelittle · Joined: 11 May 2002 Posts: 376 Location: UK

Sorry for the delay in replying,

When you say you "did everything" did you make sure to use real tab characters, not spaces on the line added to b2menutop.txt

Also just a check, but could it have wrapped over to the left of the page?

Mike
_________________
Mike Little
http://zed1.com/journalized/
"Share what you know. Learn what you don't."