if ((!empty($tid)) && (!empty($fid))) {
// Sort menu
- SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_member_menu` SET `sort`='%s' WHERE ".$AND." AND id=%s LIMIT 1",
+ SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_member_menu` SET `sort`='%s' WHERE ".$AND." AND `id`=%s LIMIT 1",
array(bigintval(getRequestElement('tid')), bigintval($fid)), __FILE__, __LINE__);
- SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_member_menu` SET `sort`='%s' WHERE ".$AND." AND id=%s LIMIT 1",
+ SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_member_menu` SET `sort`='%s' WHERE ".$AND." AND `id`=%s LIMIT 1",
array(bigintval(getRequestElement('fid')), bigintval($tid)), __FILE__, __LINE__);
} // END - -fi
- }
+ } // END - if
if (!empty($SUB)) {
// Edit sub menus
$cnt++;
if (($data['sort'] == '0') || (($data['sort'] == 1) && (!empty($SUB)))) {
// Is highest position
- $data['navi'] = "<a href=\"{%url=modules.php?module=admin&what=memedit&sub=" . $content['sub'] . "&act=" . $data['action'] . "&w=" . $data['what'] . "&tid=".($data['sort']+1)."&fid=" . $data['sort'] . "%}\">{--LOWER--}</a>";
+ $data['navi'] = '<a href="{%url=modules.php?module=admin&what=adminedit&sub=' . $content['sub'] . '&act=' . $data['action'] . '&w=' . $data['what'] . '&tid=' . ($data['sort']+1) . '&fid=' . $data['sort'] . '%}">{--LOWER--}</a>';
} elseif ($cnt == $max) {
// Is lowest position
- $data['navi'] = "<a href=\"{%url=modules.php?module=admin&what=memedit&sub=" . $content['sub'] . "&act=" . $data['action'] . "&w=" . $data['what'] . "&tid=".($data['sort']-1)."&fid=" . $data['sort'] . "%}\">{--HIGHER--}</a>";
+ $data['navi'] = '<a href="{%url=modules.php?module=admin&what=adminedit&sub=' . $content['sub'] . '&act=' . $data['action'] . '&w=' . $data['what'] . '&tid=' . ($data['sort']-1) . '&fid=' . $data['sort'] . '%}">{--HIGHER--}</a>';
} elseif ($data['sort'] > 0) {
// Anything else between highest and lowest
- $data['navi'] = "<a href=\"{%url=modules.php?module=admin&what=memedit&sub=" . $content['sub'] . "&act=" . $data['action'] . "&w=" . $data['what'] . "&tid=".($data['sort']-1)."&fid=" . $data['sort'] . "%}\">{--HIGHER--}</a>/<a href=\"{%url=modules.php?module=admin&what=memedit&sub=" . $content['sub'] . "&act=" . $data['action'] . "&w=" . $data['what'] . "&tid=" . ($data['sort']+1) . "&fid=" . $data['sort'] . "%}\">{--LOWER--}</a>";
+ $data['navi'] = '<a href="{%url=modules.php?module=admin&what=adminedit&sub=' . $content['sub'] . '&act=' . $data['action'] . '&w=' . $data['what'] . '&tid=' . ($data['sort']-1) . '&fid=' . $data['sort'] . '%}">{--HIGHER--}</a>/<a href="{%url=modules.php?module=admin&what=memedit&sub=' . $content['sub'] . '&act=' . $data['action'] . '&w=' . $data['what'] . '&tid=' . ($data['sort']+1) . '&fid=' . $data['sort'] . '%}">{--LOWER--}</a>';
}
// Fix empty values for Firefox
// Load row template and switch color
$OUT .= loadTemplate('admin_menu_overview_row', true, $data);
$SW = 3 - $SW;
- }
+ } // END - while
// Free memory
SQL_FREERESULT($result);