sql_query($sql))
{
message_die(GENERAL_ERROR, 'Could not select group data', '', __LINE__, __FILE__, $sql);
}
$group_list = '';
if($db->sql_numrows($result) != 0)
{
$template->assign_block_vars('groups_exist', array());
while($row = $db->sql_fetchrow($result))
{
$group_list .= '';
}
}
$language_list = language_select('', 'language_type');
$timezone_list = tz_select('', 'timezone_type');
$sql = "SELECT f.forum_id, f.forum_name, c.cat_id, c.cat_title
FROM ( ". FORUMS_TABLE ." AS f INNER JOIN ". CATEGORIES_TABLE ." AS c ON c.cat_id = f.cat_id )
ORDER BY c.cat_order, f.forum_order ASC";
if(!$result = $db->sql_query($sql))
{
message_die(GENERAL_ERROR, 'Could not select forum data', '', __LINE__, __FILE__, $sql);
}
$forums = array();
if($db->sql_numrows($result) != 0)
{
$template->assign_block_vars('forums_exist', array());
$last_cat_id = -1;
$forums_list = '';
while($row = $db->sql_fetchrow($result))
{
if($row['cat_id'] != $last_cat_id)
{
$forums_list .= '