$SEL = 0;
if (REQUEST_ISSET_POST('edit')) {
// Check if at least one module is selected
- $SEL = SELECTION_COUNT(REQUEST_POST('sel'));
+ $SEL = countPostSelection();
if ($SEL > 0) {
// Output header
$OUT = ''; $SW = 2;
// Edit selected modules
foreach (REQUEST_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",
- array(bigintval($id)), __FILE__, __LINE__);
+ $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
- ADD_SQL(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(
- REQUEST_POST('title', $id),
- REQUEST_POST('locked', $id),
- REQUEST_POST('hidden', $id),
- REQUEST_POST('admin', $id),
- REQUEST_POST('member', $id),
- $id
- ), __FILE__, __LINE__, false));
+ ADD_SQL(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(
+ REQUEST_POST('title', $id),
+ REQUEST_POST('locked', $id),
+ REQUEST_POST('hidden', $id),
+ REQUEST_POST('admin', $id),
+ REQUEST_POST('member', $id),
+ $id
+ ), __FILE__, __LINE__, false));
}
// Run all sqls
'id' => $content['id'],
'mod' => $content['module'],
'title' => $content['title'],
- 'locked' => TRANSLATE_YESNO($content['locked']),
- 'hidden' => TRANSLATE_YESNO($content['hidden']),
- 'admin' => TRANSLATE_YESNO($content['admin_only']),
- 'mem' => TRANSLATE_YESNO($content['mem_only']),
+ 'locked' => translateYesNo($content['locked']),
+ 'hidden' => translateYesNo($content['hidden']),
+ 'admin' => translateYesNo($content['admin_only']),
+ 'mem' => translateYesNo($content['mem_only']),
);
// Load row template