foreach ($_POST['sel'] as $id => $sel)
{
// Load module data
- $result = SQL_QUERY_ESC("SELECT module, title, locked, hidden, admin_only, mem_only FROM `{!MYSQL_PREFIX!}_mod_reg` WHERE id=%s LIMIT 1",
+ $result = SQL_QUERY_ESC("SELECT module, title, locked, hidden, admin_only, mem_only FROM `{!_MYSQL_PREFIX!}_mod_reg` WHERE id=%s LIMIT 1",
array(bigintval($id)), __FILE__, __LINE__);
list($mod, $title, $locked, $hidden, $admin, $mem) = SQL_FETCHROW($result);
SQL_FREERESULT($result);
$id = bigintval($id);
// Update module
- SQL_QUERY_ESC("UPDATE `{!MYSQL_PREFIX!}_mod_reg` SET title='%s', locked='%s', hidden='%s', admin_only='%s', mem_only='%s' WHERE id=%s LIMIT 1",
+ SQL_QUERY_ESC("UPDATE `{!_MYSQL_PREFIX!}_mod_reg` SET title='%s', `locked`='%s', hidden='%s', admin_only='%s', mem_only='%s' WHERE id=%s LIMIT 1",
array($_POST['title'][$id], $_POST['locked'][$id], $_POST['hidden'][$id], $_POST['admin'][$id], $_POST['member'][$id], $id), __FILE__, __LINE__);
}
{
// Load module data (We do not need to check if there's at least one...)
$result = SQL_QUERY("SELECT id, module, locked, hidden, admin_only, title, mem_only, clicks
-FROM `{!MYSQL_PREFIX!}_mod_reg`
+FROM `{!_MYSQL_PREFIX!}_mod_reg`
ORDER BY module", __FILE__, __LINE__);
$OUT = ""; $SW = 2;
while (list($id, $mod, $locked, $hidden, $admin, $title, $mem) = SQL_FETCHROW($result))
if (($mod == "index") || ($mod == "login"))
{
// Add link to detail statistics
- $mod = "<strong><a href=\"".URL."/modules.php?module=admin&what=stats_mods&mod=".$mod."\">".$mod."</a></strong>";
+ $mod = "<strong><a href=\"{!URL!}/modules.php?module=admin&what=stats_mods&mod=".$mod."\">".$mod."</a></strong>";
}
// Prepare array for the template