This script will remove any setting groups that do not have any settings correlated to it.
";
flush();
sleep(3);
switch($db->type)
{
case "pgsql":
$query = $db->query("
SELECT g.*, COUNT(s.sid) AS settingcount
FROM ".TABLE_PREFIX."settinggroups g
LEFT JOIN ".TABLE_PREFIX."settings s ON (s.gid=g.gid)
GROUP BY ".$db->build_fields_string("settinggroups", "g.")."
ORDER BY g.disporder
");
break;
default:
$query = $db->query("
SELECT g.*, COUNT(s.sid) AS settingcount
FROM ".TABLE_PREFIX."settinggroups g
LEFT JOIN ".TABLE_PREFIX."settings s ON (s.gid=g.gid)
GROUP BY g.gid
ORDER BY g.disporder
");
}
while($group = $db->fetch_array($query))
{
if($group['settingcount'] == 0)
{
echo "Found blank setting group {$group['title']}. Removing it... ";
$db->delete_query("settinggroups", "gid='{$group['gid']}'", 1);
echo "Done.
\n";
}
}
rebuild_settings();
echo "
Finished! Please delete this file from your MyBB installation now!.";
?>