function build_forum_child_lists($forumid = -1)
{
global $vbulletin;
$forums = $vbulletin->db->query_read("SELECT * FROM " . TABLE_PREFIX . "forum WHERE FIND_IN_SET('{$forumid}', childlist)");
while ($forum = $vbulletin->db->fetch_array($forums)) {
$childlist = construct_child_list($forum['forumid']);
$forumdm =& datamanager_init('Forum', $vbulletin, ERRTYPE_SILENT);
$forumdm->set_existing($forum);
$forumdm->setr('childlist', $childlist);
$forumdm->save();
unset($forumdm);
}
}
global $db;
if ($forumid == -1) {
return '-1';
}
$childlist = $forumid;
$children = $db->query_read("SELECT forumid FROM " . TABLE_PREFIX . "forum WHERE parentid = " . intval($forumid));
while ($child = $db->fetch_array($children)) {
$childlist .= ',' . $child['forumid'];
}
$childlist .= ',-1';
return $childlist;
}
$forums = $db->query_read("SELECT forumid FROM " . TABLE_PREFIX . "forum WHERE childlist = ''");
$count = 0;
while ($forum = $db->fetch_array($forums)) {
$childlist = construct_child_list($forum['forumid']);
$db->query_write("\n\t\t\tUPDATE " . TABLE_PREFIX . "forum\n\t\t\tSET childlist = '{$childlist}'\n\t\t\tWHERE forumid = {$forum['forumid']}\n\t\t");
$count++;
}
build_forum_permissions();
echo "<p align=\"center\">Updated {$count} forums</p>";
define('SCRIPT_REDIRECT', true);
} else {
if ($_REQUEST['do'] == 'bbactive') {
$db->query_write("\n\t\tUPDATE " . TABLE_PREFIX . "setting\n\t\tSET value = " . ($vbulletin->options['bbactive'] ? 0 : 1) . "\n\t\tWHERE varname = 'bbactive'\n\t");
build_options();
define('SCRIPT_REDIRECT', true);
} else {
if ($_REQUEST['do'] == 'language') {
$vbulletin->input->clean_array_gpc('p', array('languageid' => TYPE_UINT));
require_once DIR . '/includes/adminfunctions_language.php';
function build_forum_child_lists()
{
global $vbulletin;
$forums = $vbulletin->db->query_read("SELECT forumid FROM " . TABLE_PREFIX . "forum");
while ($forum = $vbulletin->db->fetch_array($forums)) {
$childlist = construct_child_list($forum['forumid']);
$vbulletin->db->query_write("UPDATE " . TABLE_PREFIX . "forum SET childlist = '{$childlist}' WHERE forumid = {$forum['forumid']}");
}
}