if($setmodules==1)

{

}

// ------------------

// ------------------

//

//

{

}

{

switch($mode)

{

case 'addforum':

case 'editforum':

// Show form to create/modify a forum

if ($mode == 'editforum')

{

// $newmode determines if we are going to INSERT or UPDATE after posting?

$newmode = 'modforum';

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

$cat_id = $row['cat_id'];

$forumdesc = $row['forum_desc'];

$forumstatus = $row['forum_status'];

//

// start forum prune stuff.

//

{

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

$sql = "SELECT *

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

{

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

}

$pr_row = $db->sql_fetchrow($pr_result);

}

}

else

{

$newmode = 'createforum';

$forumdesc = '';

$forumstatus = FORUM_UNLOCKED;

}

$catlist = get_list('category', $cat_id, TRUE);

$template->set_filenames(array(

"body" => "admin/forum_edit_body.tpl")

);

$template->assign_vars(array(

'S_CATLIST' => $catlist,

'S_STATUSLIST' => $statuslist,

'S_FORUMID' => $forum_id,

'S_NEWMODE' => $newmode,

'L_ENABLED' => $lang['Enabled'],

'L_PRUNE_DAYS' => $lang['prune_days'],

'L_PRUNE_FREQ' => $lang['prune_freq'],

'L_DAYS' => $lang['days'],

'BUTTONVALUE' => $buttonvalue)

);

$template->pparse("body");

break;

case 'createforum':

// Create a forum in the DB

{

message_die(GENERAL_ERROR, "Can't create a forum without a name");

}

$sql = "SELECT MAX(forum_order) AS max_order

FROM " . FORUMS_TABLE . "

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

$next_order = $max_order + 1;

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

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

{

message_die(GENERAL_ERROR, "Couldn't insert row in forums table", "", __LINE__, __FILE__, $sql);

}

{

$new_forum_id = $db->sql_nextid();

if($HTTP_POST_VARS['prune_days'] == "" || $HTTP_POST_VARS['prune_freq'] == "")

{

}

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

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

{

message_die(GENERAL_ERROR, "Couldn't insert row in prune table", "", __LINE__, __FILE__, $sql);

{

$HTTP_POST_VARS['prune_enable'] = 0;

}

$sql = "UPDATE " . FORUMS_TABLE . "

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($HTTP_POST_VARS['prune_days'] == "" || $HTTP_POST_VARS['prune_freq'] == "")

{

}

$sql = "SELECT *

case 'addcat':

// Create a category in the DB

{

message_die(GENERAL_ERROR, "Can't create a category without a name");

}

$sql = "SELECT MAX(cat_order) AS max_order

FROM " . CATEGORIES_TABLE;

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

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

//

$sql = "INSERT INTO " . CATEGORIES_TABLE . " (cat_title, cat_order)

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

{

message_die(GENERAL_ERROR, "Couldn't insert row in categories table", "", __LINE__, __FILE__, $sql);

break;

case 'movedelforum':

// Move or delete a forum in the DB

// Either delete or move all posts in a forum

}

$show_index = TRUE;

break;

case 'deletecat':

// Show form to delete a category

$buttonvalue = "Move&Delete";

$newmode = 'movedelcat';

$catinfo = get_info('category', $cat_id);

}

$count = $db->sql_fetchrow($result);

$count = $count['total'];

if ($count > 0)

{

message_die(GENERAL_ERROR, "You need to delete all forums before you can delete this category");

);

$template->assign_vars(array(

'NAME' => $name,

'S_FROM_ID' => $cat_id,

'S_SELECT_TO' => $select_to,

'S_NEWMODE' => $newmode,

break;

case 'movedelcat':

// Move or delete a category in the DB

if (isset($to_id))

{

}

$show_index = TRUE;

break;

case 'forum_order':

// Change order of forums in the DB

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

$cat_id = $forum_info['cat_id'];

$sql = "UPDATE " . FORUMS_TABLE . "

{

message_die(GENERAL_ERROR, "Couldn't change category order", "", __LINE__, __FILE__, $sql);

}

renumber_order('forum', $forum_info['cat_id']);

$show_index = TRUE;

break;

case 'cat_order':

// Change order of categories in the DB

$sql = "UPDATE " . CATEGORIES_TABLE . "

SET cat_order = cat_order + $move

{

message_die(GENERAL_ERROR, "Couldn't change category order", "", __LINE__, __FILE__, $sql);

}

renumber_order('category');

$show_index = TRUE;

break;

case 'forum_sync':

$show_index = TRUE;

break;

default:

break;

}

if ($show_index != TRUE)

// Start page proper

//

$template->set_filenames(array(

);

$sql = "SELECT cat_id, cat_title, cat_order

FROM " . CATEGORIES_TABLE . "

ORDER BY cat_order";

{

message_die(GENERAL_ERROR, "Could not query categories list", "", __LINE__, __FILE__, $sql);

}

{

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

if( !$total_forums = $db->sql_numrows($q_forums) )

{

}

$forum_rows = $db->sql_fetchrowset($q_forums);

//

//

$gen_cat = array();

for($i = 0; $i < $total_categories; $i++)

{

$cat_id = $category_rows[$i]['cat_id'];

for($j = 0; $j < $total_forums; $j++)

{

$forum_id = $forum_rows[$j]['forum_id'];

if ($forum_rows[$j]['cat_id'] == $cat_id)

{

$template->assign_block_vars("catrow.forumrow", array(

"ROW_COLOR" => $row_color,

"NUM_TOPICS" => $forum_rows[$j]['forum_topics'],

"NUM_POSTS" => $forum_rows[$j]['forum_posts'],

);

}// if ... forumid == catid

} // for ... forums

} // for ... categories

$template->pparse("body");

include('page_footer_admin.'.$phpEx);

?> \ No newline at end of file