{

global $db;

WHERE forum_name = '$forumname'";

$result = $db->sql_query($sql);

if( !$result )

break;

}

FROM $table";

if( $select == 0 )

{

while( $row = $db->sql_fetchrow($result) )

{

WHERE $idfield = " . $row[$idfield];

if( !$db->sql_query($sql) )

{

if( $HTTP_POST_VARS['prune_enable'] == TRUE )

{

$new_forum_id = $db->sql_nextid();

$sql = "INSERT INTO " . PRUNE_TABLE . " (forum_id, prune_days, prune_freq)

VALUES($new_forum_id, " . $HTTP_POST_VARS['prune_days'] . ", " . $HTTP_POST_VARS['prune_freq'] . ")";

{

$HTTP_POST_VARS['prune_enable'] = 0;

}

SET forum_name = '" . $HTTP_POST_VARS['forumname'] . "', cat_id = " . $HTTP_POST_VARS['cat_id'] . ", forum_desc = '" . $HTTP_POST_VARS['forumdesc'] . "', forum_status = " . $HTTP_POST_VARS['forumstatus'] . ", prune_enable = " . $HTTP_POST_VARS['prune_enable'] . "

WHERE forum_id = ".$HTTP_POST_VARS['forum_id'];

if( !$result = $db->sql_query($sql) )

if($HTTP_POST_VARS['prune_enable'] == 1)

{

FROM " . PRUNE_TABLE . "

WHERE forum_id = " . $HTTP_POST_VARS['forum_id'];

if( !$result = $db->sql_query($sql) )

if( $db->sql_numrows($result) > 0 )

{

SET prune_days = " . $HTTP_POST_VARS['prune_days'] . ", prune_freq = " . $HTTP_POST_VARS['prune_freq'] . "

WHERE forum_id = " . $HTTP_POST_VARS['forum_id'];

}

break;

case 'addcat':

FROM " . CATEGORIES_TABLE;

if( !$result = $db->sql_query($sql) )

{

//

// There is no problem having duplicate forum names so we won't check for it.

//

VALUES ('" . $HTTP_POST_VARS['catname'] . "', $next_order)";

if( !$result = $db->sql_query($sql) )

{

if( $row['prune_enable'] == 1 )

{

$prune_enabled = "checked=\"checked\"";

FROM " . PRUNE_TABLE . "

if(!$pr_result = $db->sql_query($sql))

{

message_die(GENERAL_ERROR, "Auto-Prune: Couldn't read auto_prune table.", __LINE__, __FILE__);

break;

case 'modcat':

WHERE cat_id = " . $HTTP_POST_VARS['cat_id'];

if( !$result = $db->sql_query($sql) )

{

print "move '$from_id' to '$to_id'";

WHERE forum_id IN ($from_id, $to_id)";

if( !$result = $db->sql_query($sql) )

{

}

else

{

SET forum_id = $to_id

WHERE forum_id = $from_id";

if( !$result = $db->sql_query($sql) )

{

message_die(GENERAL_ERROR, "Couldn't move topics to other forum", "", __LINE__, __FILE__, $sql);

}

SET forum_id = $to_id

WHERE forum_id = $from_id";

if( !$result = $db->sql_query($sql) )

$to_id = $HTTP_POST_VARS['to_id'];

print "move '$from_id' to '$to_id'";

WHERE cat_id IN ($from_id, $to_id)";

if( !$result = $db->sql_query($sql) )

{

message_die(GENERAL_ERROR, "Ambiguous category ID's", "", __LINE__, __FILE__);

}

SET cat_id = $to_id

WHERE cat_id = $from_id";

if( !$result = $db->sql_query($sql) )

message_die(GENERAL_ERROR, "Couldn't move forums to other category", "", __LINE__, __FILE__, $sql);

}

WHERE cat_id = $from_id";

if( !$result = $db->sql_query($sql) )

{

$move = $HTTP_GET_VARS['move'];

$cat_id = $HTTP_GET_VARS['cat_id'];

WHERE cat_id = $cat_id";

if( !$result = $db->sql_query($sql) )

{

$forum_info = get_info('forum', $forum_id);

$cat_id = $forum_info['cat_id'];

WHERE forum_id = $forum_id";

if( !$result = $db->sql_query($sql) )

{

{

$category_rows = $db->sql_fetchrowset($q_categories);

FROM " . FORUMS_TABLE . "

ORDER BY cat_id, forum_order";

if(!$q_forums = $db->sql_query($sql))

auth_votecreate tinyint(1) DEFAULT '0' NOT NULL,

auth_attachments tinyint(1) DEFAULT '0' NOT NULL,

auth_vote tinyint(1) DEFAULT '0' NOT NULL,

KEY group_id (group_id),

KEY forum_id (forum_id)

);

CREATE TABLE phpbb_user_group (

group_id int(11) DEFAULT '0' NOT NULL,

user_id int(11) DEFAULT '0' NOT NULL,

KEY group_id (group_id),

KEY user_id (user_id)

);

DROP TABLE IF EXISTS phpbb_groups;

CREATE TABLE phpbb_groups (

group_id int(11) NOT NULL auto_increment,

group_name varchar(40) NOT NULL,

group_description varchar(255) NOT NULL,

group_moderator int(11) DEFAULT '0' NOT NULL,

group_single_user tinyint(1) DEFAULT '0' NOT NULL,

KEY group_single_user (group_single_user)

);

ban_userid int(11) NOT NULL,

ban_ip char(8) NOT NULL,

ban_email varchar(255),

KEY ban_ip_user_id (ban_ip, ban_userid)

);

cat_id int(11) NOT NULL auto_increment,

cat_title varchar(100),

cat_order int(11) NOT NULL,

KEY cat_order (cat_order)

);

DROP TABLE IF EXISTS phpbb_config;

CREATE TABLE phpbb_config (

config_id int(11) NOT NULL auto_increment,

sitename varchar(100),

cookie_name char(20),

cookie_path char(25),

allow_html tinyint(1),

allow_bbcode tinyint(1),

allow_smilies tinyint(1),

allow_sig tinyint(1),

allow_namechange tinyint(1),

allow_theme_create tinyint(1),

allow_avatar_upload tinyint(1) DEFAULT '0' NOT NULL,

override_themes tinyint(3),

posts_per_page int(11),

topics_per_page int(11),

hot_threshold int(11),

email_sig varchar(255),

flood_interval int(4) NOT NULL,

avatar_filesize int(11) DEFAULT '6144' NOT NULL,

avatar_path varchar(255) DEFAULT 'images/avatars' NOT NULL,

default_theme int(11) DEFAULT '1' NOT NULL,

default_lang varchar(255),

default_dateformat varchar(14) DEFAULT 'd M Y H:i' NOT NULL,

system_timezone int(11) DEFAULT '0' NOT NULL,

sys_template varchar(100) DEFAULT 'Default' NOT NULL,

PRIMARY KEY (config_id)

);

cat_id int(11) NOT NULL,

forum_name varchar(150),

forum_desc text,

forum_order int(11) DEFAULT '1' NOT NULL,

forum_posts int(11) DEFAULT '0' NOT NULL,

forum_topics tinyint(4) DEFAULT '0' NOT NULL,

PRIMARY KEY (forum_id),

KEY forum_id (forum_id),

KEY forums_order (forum_order),

KEY forum_last_post_id (forum_last_post_id)

);

forum_id int(11) DEFAULT '0' NOT NULL,

poster_id int(11) DEFAULT '0' NOT NULL,

post_time int(11) DEFAULT '0' NOT NULL,

enable_bbcode smallint(1) DEFAULT '1' NOT NULL,

enable_html smallint(1) DEFAULT '0' NOT NULL,

enable_smilies smallint(1) DEFAULT '1' NOT NULL,

privmsgs_enable_bbcode smallint(1) DEFAULT '1' NOT NULL,

privmsgs_enable_html smallint(1) DEFAULT '0' NOT NULL,

privmsgs_enable_smilies smallint(1) DEFAULT '1' NOT NULL,

PRIMARY KEY (privmsgs_id),

KEY privmsgs_from_userid (privmsgs_from_userid),

KEY privmsgs_to_userid (privmsgs_to_userid)

rank_max int(11) DEFAULT '0' NOT NULL,

rank_special tinyint(1) DEFAULT '0',

rank_image varchar(255),

);

# this table a type HEAP. This type of table is stored

# within system memory and therefore for big busy boards

# is likely to be noticeably faster than continually

#

# I must admit I read about this type on vB's board.

# Hey, I never said you cannot get basic ideas from

user_id int(11) NOT NULL DEFAULT '0',

notify_status tinyint(1) NOT NULL default '0',

KEY topic_id (topic_id),

KEY notify_status (notify_status)

);

user_attachsig tinyint(1),

user_allowhtml tinyint(1),

user_allowbbcode tinyint(1),

user_notify tinyint(1) DEFAULT '1' NOT NULL,

user_regdate int(11) DEFAULT '0' NOT NULL,

user_rank int(11) DEFAULT '0',

user_avatar varchar(100),

smilies_path varchar(50) DEFAULT 'images/smiles' NOT NULL,

override_themes int2 NOT NULL,

flood_interval int NOT NULL,

gzip_compress int2 DEFAULT '0' NOT NULL,

CONSTRAINT phpbb_config_pkey PRIMARY KEY (config_id)

);

$lang['prune_days'] = 'Remove topics that haven\'t been posted to in';

$lang['prune_freq'] = 'Check for topic age every';

$lang['days'] = 'Days';

//

// Word censor