';
$table = new Table;
$table->construct_header($lang->setting_groups);
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)
WHERE g.isdefault = 1
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)
WHERE g.isdefault = 1
GROUP BY g.gid
ORDER BY g.disporder
");
}
while($group = $db->fetch_array($query))
{
$group_lang_var = "setting_group_{$group['name']}";
if(isset($lang->$group_lang_var))
{
$group_title = htmlspecialchars_uni($lang->$group_lang_var);
}
else
{
$group_title = htmlspecialchars_uni($group['title']);
}
$group_desc_lang_var = "setting_group_{$group['name']}_desc";
if(isset($lang->$group_desc_lang_var))
{
$group_desc = htmlspecialchars_uni($lang->$group_desc_lang_var);
}
else
{
$group_desc = htmlspecialchars_uni($group['description']);
}
$table->construct_cell("{$group_title} ({$group['settingcount']} {$lang->bbsettings}) {$group_desc}");
$table->construct_row();
}
$table->output("{$lang->show_all_settings}{$lang->board_settings}");
// Plugin Settings
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)
WHERE g.isdefault <> 1
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)
WHERE g.isdefault <> 1
GROUP BY g.gid
ORDER BY g.disporder
");
}
if($db->num_rows($query))
{
$table = new Table;
$table->construct_header($lang->setting_groups);
while($group = $db->fetch_array($query))
{
$group_lang_var = "setting_group_{$group['name']}";
if(isset($lang->$group_lang_var))
{
$group_title = htmlspecialchars_uni($lang->$group_lang_var);
}
else
{
$group_title = htmlspecialchars_uni($group['title']);
}
$group_desc_lang_var = "setting_group_{$group['name']}_desc";
if(isset($lang->$group_desc_lang_var))
{
$group_desc = htmlspecialchars_uni($lang->$group_desc_lang_var);
}
else
{
$group_desc = htmlspecialchars_uni($group['description']);
}
$table->construct_cell("{$group_title} ({$group['settingcount']} {$lang->bbsettings}) {$group_desc}");
$table->construct_row();
}
$table->output($lang->plugin_settings);
}
echo '