$actions = array();
// First fix all main menus (what = '')...
-$result_fix = SQL_QUERY("SELECT `id`, `action` FROM `{?_MYSQL_PREFIX?}_guest_menu` WHERE (`what`='' OR `what` IS NULL) AND `action` != 'logout' ORDER BY `sort` ASC", __FILE__, __LINE__);
+$result_fix = sqlQuery("SELECT `id`, `action` FROM `{?_MYSQL_PREFIX?}_guest_menu` WHERE (`what`='' OR `what` IS NULL) AND `action` != 'logout' ORDER BY `sort` ASC", __FILE__, __LINE__);
$count = '0'; $repairedWeights = '0';
-while ($content = SQL_FETCHARRAY($result_fix)) {
+while ($content = sqlFetchArray($result_fix)) {
// Store act value for later usage in sorting sub menus
array_push($actions, $content['action']);
// Fix weight
- $result_sort = SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_guest_menu` SET `sort`=%s WHERE `id`=%s LIMIT 1",
+ $result_sort = sqlQueryEscaped("UPDATE `{?_MYSQL_PREFIX?}_guest_menu` SET `sort`=%s WHERE `id`=%s LIMIT 1",
array($count, $content['id']), __FILE__, __LINE__);
// Get updated rows
- $repairedWeights += SQL_AFFECTEDROWS();
+ $repairedWeights += sqlAffectedRows();
// Count one up
$count++;
} // END - while
// Set logout weight to 999
-$result_sort = SQL_QUERY("UPDATE `{?_MYSQL_PREFIX?}_guest_menu` SET sort='999' WHERE `action`='logout' AND (`what`='' OR `what` IS NULL) LIMIT 1", __FILE__, __LINE__);
+$result_sort = sqlQuery("UPDATE `{?_MYSQL_PREFIX?}_guest_menu` SET sort='999' WHERE `action`='logout' AND (`what`='' OR `what` IS NULL) LIMIT 1", __FILE__, __LINE__);
// Now sort every each menu
foreach ($actions as $action) {
- $result_fix = SQL_QUERY_ESC("SELECT `id` FROM `{?_MYSQL_PREFIX?}_guest_menu` WHERE `action`='%s' AND `what` != '' AND `what` IS NOT NULL ORDER BY `sort` ASC",
+ $result_fix = sqlQueryEscaped("SELECT `id` FROM `{?_MYSQL_PREFIX?}_guest_menu` WHERE `action`='%s' AND `what` != '' AND `what` IS NOT NULL ORDER BY `sort` ASC",
array($action), __FILE__, __LINE__);
$count = 1;
- while ($content = SQL_FETCHARRAY($result_fix)) {
+ while ($content = sqlFetchArray($result_fix)) {
// Fix weight
- SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_guest_menu` SET `sort`=%s WHERE `id`=%s LIMIT 1",
+ sqlQueryEscaped("UPDATE `{?_MYSQL_PREFIX?}_guest_menu` SET `sort`=%s WHERE `id`=%s LIMIT 1",
array($count, $content['id']), __FILE__, __LINE__);
- $repairedWeights += SQL_AFFECTEDROWS();
+ $repairedWeights += sqlAffectedRows();
// Count one up
$count++;