atari-legend / legacy

public/php/admin/menus/db_menu_functions.php

Spacing +9 added lines, -9 removed lines

@@ -85,17 +85,17 @@ 
          WHERE menu_disk_title.menu_disk_id = '$menu_disk_id' AND menu_disk_title.menu_types_main_id = '3'
          ORDER BY tools.tools_name ASC";
 
-    $drop = $mysqli->query("DROP TABLE IF EXISTS temp") or die('Error: ' . mysqli_error($mysqli));
+    $drop = $mysqli->query("DROP TABLE IF EXISTS temp") or die('Error: '.mysqli_error($mysqli));
 
     $temp_query = $mysqli->query("CREATE TEMPORARY TABLE temp ENGINE=MEMORY $sql_games")
-        or die('Error: ' . mysqli_error($mysqli));
-    $temp_query = $mysqli->query("INSERT INTO temp $sql_demos") or die('Error: ' . mysqli_error($mysqli));
-    $temp_query = $mysqli->query("INSERT INTO temp $sql_tools") or die('Error: ' . mysqli_error($mysqli));
+        or die('Error: '.mysqli_error($mysqli));
+    $temp_query = $mysqli->query("INSERT INTO temp $sql_demos") or die('Error: '.mysqli_error($mysqli));
+    $temp_query = $mysqli->query("INSERT INTO temp $sql_tools") or die('Error: '.mysqli_error($mysqli));
 
     $temp_query = $mysqli->query("SELECT * FROM temp GROUP BY menu_disk_title_id ORDER BY menu_disk_title_id ASC")
-        or die('Error: ' . mysqli_error($mysqli));
+        or die('Error: '.mysqli_error($mysqli));
 
-    $drop = $mysqli->query("DROP TABLE IF EXISTS temp") or die('Error: ' . mysqli_error($mysqli));
+    $drop = $mysqli->query("DROP TABLE IF EXISTS temp") or die('Error: '.mysqli_error($mysqli));
 
     return $temp_query;
 }
@@ -151,11 +151,11 @@ 
             AND menu_disk_title.menu_types_main_id = '6' ORDER BY tools.tools_name ASC";
 
     $temp_query2 = $mysqli->query("CREATE TEMPORARY TABLE temp2 ENGINE=MEMORY $sql_doc_games")
-        or die('Error1: ' . mysqli_error($mysqli));
-    $temp_query2 = $mysqli->query("INSERT INTO temp2 $sql_doc_tools") or die('Error2: ' . mysqli_error($mysqli));
+        or die('Error1: '.mysqli_error($mysqli));
+    $temp_query2 = $mysqli->query("INSERT INTO temp2 $sql_doc_tools") or die('Error2: '.mysqli_error($mysqli));
 
     $temp_query2 = $mysqli->query("SELECT * FROM temp2 GROUP BY menu_disk_title_id ORDER BY menu_disk_title_id ASC")
-        or die('Error: ' . mysqli_error($mysqli));
+        or die('Error: '.mysqli_error($mysqli));
 
     return $temp_query2;
 }

public/php/admin/menus/menus_disk_list.php

Spacing +1 added lines, -1 removed lines

@@ -85,4 +85,4 @@
 $smarty->assign("user_id", $_SESSION['user_id']);
 
 //Send all smarty variables to the templates
-$smarty->display("file:" . $cpanel_template_folder . "menus/menus_disk_list.html");
+$smarty->display("file:".$cpanel_template_folder."menus/menus_disk_list.html");

public/php/admin/menus/menus_list.php

Spacing +1 added lines, -1 removed lines

@@ -43,4 +43,4 @@
 $smarty->assign("user_id", $_SESSION['user_id']);
 
 //Send all smarty variables to the templates
-$smarty->display("file:" . $cpanel_template_folder . "menus/menus_list.html");
+$smarty->display("file:".$cpanel_template_folder."menus/menus_list.html");

public/php/admin/menus/ajax_add_author_menutitle.php

Spacing +2 added lines, -2 removed lines

@@ -59,7 +59,7 @@ 
 
 // Get Author types for
 $sql_author_types = "SELECT * FROM author_type ORDER BY author_type_info ASC";
-$query_author = $mysqli->query($sql_author_types) or die('Error: ' . mysqli_error($mysqli));
+$query_author = $mysqli->query($sql_author_types) or die('Error: '.mysqli_error($mysqli));
 
 while ($author_ind = $query_author->fetch_array(MYSQLI_BOTH)) {
     $smarty->append('author_type', array(
@@ -79,7 +79,7 @@ 
 $smarty->assign('az_output', $az_output);
 
 //Send all smarty variables to the templates
-$smarty->display("file:" . $cpanel_template_folder . "menus/ajax_menus_add_author_title.html");
+$smarty->display("file:".$cpanel_template_folder."menus/ajax_menus_add_author_title.html");
 
 //close the connection
 mysqli_close($mysqli);

public/php/admin/menus/db_menu_disk.php

Spacing +122 added lines, -122 removed lines

@@ -49,31 +49,31 @@ 
         //first we start with if this is numbered menu disk
         if ($menu_disk_number !== '' and $menu_disk_letter == '') {
             $sql = $mysqli->query("INSERT INTO menu_disk (menu_sets_id,menu_disk_number)
-                VALUES ('$menu_sets_id','$menu_disk_number')") or die('Error: ' . mysqli_error($mysqli));
+                VALUES ('$menu_sets_id','$menu_disk_number')") or die('Error: '.mysqli_error($mysqli));
             $last_id = $mysqli->insert_id;
 
             if ($menu_disk_part !== '') {
                 $sql = $mysqli->query("UPDATE menu_disk SET menu_disk_part='$menu_disk_part'
-        WHERE menu_disk_id='$last_id'") or die('Error: ' . mysqli_error($mysqli));
+        WHERE menu_disk_id='$last_id'") or die('Error: '.mysqli_error($mysqli));
             }
             if ($menu_disk_version !== '') {
                 $sql = $mysqli->query("UPDATE menu_disk SET menu_disk_version='$menu_disk_version'
-        WHERE menu_disk_id='$last_id'") or die('Error: ' . mysqli_error($mysqli));
+        WHERE menu_disk_id='$last_id'") or die('Error: '.mysqli_error($mysqli));
             }
             $_SESSION['edit_message'] = "New Menu disk added";
             create_log_entry('Menu set', $menu_sets_id, 'Menu disk', $last_id, 'Insert', $_SESSION['user_id']);
         } elseif ($menu_disk_number == '' and $menu_disk_letter !== '') {
             //Ok, but if it is not a numbered disk but instead it is one of those horrible alphabetic disks
             $sql = $mysqli->query("INSERT INTO menu_disk (menu_sets_id,menu_disk_letter)
-                VALUES ('$menu_sets_id','$menu_disk_letter')") or die('Error: ' . mysqli_error($mysqli));
+                VALUES ('$menu_sets_id','$menu_disk_letter')") or die('Error: '.mysqli_error($mysqli));
             $last_id2 = $mysqli->insert_id;
             if ($menu_disk_part !== '') {
                 $sql = $mysqli->query("UPDATE menu_disk SET menu_disk_part='$menu_disk_part'
-        WHERE menu_disk_id='$last_id2'") or die('Error: ' . mysqli_error($mysqli));
+        WHERE menu_disk_id='$last_id2'") or die('Error: '.mysqli_error($mysqli));
             }
             if ($menu_disk_version !== '') {
                 $sql = $mysqli->query("UPDATE menu_disk SET menu_disk_version='$menu_disk_version'
-        WHERE menu_disk_id='$last_id2'") or die('Error: ' . mysqli_error($mysqli));
+        WHERE menu_disk_id='$last_id2'") or die('Error: '.mysqli_error($mysqli));
             }
             $_SESSION['edit_message'] = "New Menu disk added";
             create_log_entry('Menu set', $menu_sets_id, 'Menu disk', $last_id2, 'Insert', $_SESSION['user_id']);
@@ -97,7 +97,7 @@ 
 
             while ($i <= $last_disk) {
                 $sql = $mysqli->query("INSERT INTO menu_disk (menu_sets_id,menu_disk_number)
-                    VALUES ('$menu_sets_id','$i')") or die('Error: ' . mysqli_error($mysqli));
+                    VALUES ('$menu_sets_id','$i')") or die('Error: '.mysqli_error($mysqli));
                 $i++;
             }
         }
@@ -225,7 +225,7 @@ 
         $smarty->assign('menu_disk_id', $menu_disk_id);
 
         //Send to smarty for return value
-        $smarty->display("file:" . $cpanel_template_folder . "menus/ajax_menus_detail.html");
+        $smarty->display("file:".$cpanel_template_folder."menus/ajax_menus_detail.html");
     }
 }
 
@@ -238,22 +238,22 @@ 
             if (isset($software_type) and $software_type == "Game") {
                 //Insert new title in menu_disk_title table
                 $mysqli->query("INSERT INTO menu_disk_title (menu_disk_id,menu_types_main_id)
-                    VALUES ('$menu_disk_id','6')") or die('Error: ' . mysqli_error($mysqli));
+                    VALUES ('$menu_disk_id','6')") or die('Error: '.mysqli_error($mysqli));
                 $title_id = $mysqli->insert_id; // Get Last autoinc id
 
                 //insert the doc in the doc table first - category = doc_disk_game
                 $mysqli->query("INSERT INTO doc (doc_category_id,doc_type_id) VALUES ('1','1')")
-                    or die('Error: ' . mysqli_error($mysqli));
+                    or die('Error: '.mysqli_error($mysqli));
                 $doc_id = $mysqli->insert_id; // Get Last autoinc id
 
                 //insert in doc_disk_game
                 $mysqli->query("INSERT INTO doc_disk_game (game_id, doc_id) VALUES ('$software_id','$doc_id')")
-                    or die('Error: ' . mysqli_error($mysqli));
+                    or die('Error: '.mysqli_error($mysqli));
                 $doc_disk_game_id = $mysqli->insert_id; // Get Last autoinc id
 
                 //insert menu_disk_title_doc_games
                 $mysqli->query("INSERT INTO menu_disk_title_doc_games (menu_disk_title_id, doc_games_id)
-                    VALUES ('$title_id','$doc_disk_game_id')") or die('Error: ' . mysqli_error($mysqli));
+                    VALUES ('$title_id','$doc_disk_game_id')") or die('Error: '.mysqli_error($mysqli));
 
                 $sql           = $mysqli->query("SELECT game_name FROM game WHERE game_id = '$software_id'");
                 $row           = $sql->fetch_array(MYSQLI_BOTH);
@@ -266,23 +266,23 @@ 
             if (isset($software_type) and $software_type == "Tool") {
                 //Insert new title in menu_disk_title table
                 $mysqli->query("INSERT INTO menu_disk_title (menu_disk_id,menu_types_main_id)
-                    VALUES ('$menu_disk_id','6')") or die('Error: ' . mysqli_error($mysqli));
+                    VALUES ('$menu_disk_id','6')") or die('Error: '.mysqli_error($mysqli));
                 $title_id = $mysqli->insert_id; // Get Last autoinc id
 
                 //insert the doc in the doc table first - category = doc_disk_tool
                 $mysqli->query("INSERT INTO doc (doc_category_id) VALUES ('2')")
-                    or die('Error: ' . mysqli_error($mysqli));
+                    or die('Error: '.mysqli_error($mysqli));
                 $doc_id = $mysqli->insert_id; // Get Last autoinc id
 
                 //insert in doc_disk_tool
                 $mysqli->query("INSERT INTO doc_disk_tool (tools_id, doc_id) VALUES ('$software_id','$doc_id')")
-                    or die('Error: ' . mysqli_error($mysqli));
+                    or die('Error: '.mysqli_error($mysqli));
 
                 $doc_disk_tool_id = $mysqli->insert_id; // Get Last autoinc id
 
                 //insert menu_disk_title_doc_tools
                 $mysqli->query("INSERT INTO menu_disk_title_doc_tools (menu_disk_title_id, doc_tools_id)
-                    VALUES ('$title_id','$doc_disk_tool_id')") or die('Error: ' . mysqli_error($mysqli));
+                    VALUES ('$title_id','$doc_disk_tool_id')") or die('Error: '.mysqli_error($mysqli));
 
                 $sql           = $mysqli->query("SELECT tools_name FROM tools WHERE tools_id = '$software_id'");
                 $row           = $sql->fetch_array(MYSQLI_BOTH);
@@ -315,7 +315,7 @@ 
 
         //get the doc types
         $sql_doc_type = "SELECT * from doc_type";
-        $query_doc_type = $mysqli->query($sql_doc_type) or die('Error: ' . mysqli_error($mysqli));
+        $query_doc_type = $mysqli->query($sql_doc_type) or die('Error: '.mysqli_error($mysqli));
 
         while ($query_type = $query_doc_type->fetch_array(MYSQLI_BOTH)) {
             $smarty->append('doc_type', array(
@@ -329,7 +329,7 @@ 
         $smarty->assign('menu_disk_id', $menu_disk_id);
 
         //Send to smarty for return value
-        $smarty->display("file:" . $cpanel_template_folder . "menus/ajax_menus_detail.html");
+        $smarty->display("file:".$cpanel_template_folder."menus/ajax_menus_detail.html");
     }
 }
 
@@ -339,13 +339,13 @@ 
 if (isset($action) and $action == "delete_from_menu_disk") {
     /* let's check if the game is linked to a chain first */
     $sql = $mysqli->query("SELECT * FROM menu_disk_title_set
-        WHERE menu_disk_title_id = '$menu_disk_title_id'") or die('Error: ' . mysqli_error($mysqli));
+        WHERE menu_disk_title_id = '$menu_disk_title_id'") or die('Error: '.mysqli_error($mysqli));
     if ($sql->num_rows > 0) {
         $osd_message = "This title is still chained to another title - remove the chain first";
     } else {
         /* let's see if the title contains authors */
         $sql = $mysqli->query("SELECT * FROM menu_disk_title_author WHERE menu_disk_title_id = '$menu_disk_title_id'")
-            or die('Error: ' . mysqli_error($mysqli));
+            or die('Error: '.mysqli_error($mysqli));
         if ($sql->num_rows > 0) {
             $osd_message = "This title still contains authors - remove them first";
         } else {
@@ -398,7 +398,7 @@ 
     $smarty->assign('osd_message', $osd_message);
 
     //Send to smarty for return value
-    $smarty->display("file:" . $cpanel_template_folder . "menus/ajax_menus_detail.html");
+    $smarty->display("file:".$cpanel_template_folder."menus/ajax_menus_detail.html");
 }
 
 //****************************************************************************************
@@ -407,7 +407,7 @@ 
 if (isset($action) and $action == "delete_doc_from_menu_disk") {
     /* let's see if the title contains authors */
     $sql = $mysqli->query("SELECT * FROM menu_disk_title_author WHERE menu_disk_title_id = '$menu_disk_title_id'")
-        or die('Error: ' . mysqli_error($mysqli));
+        or die('Error: '.mysqli_error($mysqli));
     if ($sql->num_rows > 0) {
         $osd_message = "This title still contains authors - remove them first";
     } else {
@@ -417,40 +417,40 @@ 
             //get the doc cross id
             $query_doc_game_id = "SELECT doc_games_id FROM menu_disk_title_doc_games
                 WHERE menu_disk_title_id='$menu_disk_title_id'";
-            $result = $mysqli->query($query_doc_game_id) or die('Error: ' . mysqli_error($mysqli));
+            $result = $mysqli->query($query_doc_game_id) or die('Error: '.mysqli_error($mysqli));
             $query_data  = $result->fetch_array(MYSQLI_BOTH);
             $doc_game_id = $query_data['doc_games_id'];
 
             $query_doc_tool_id = "SELECT * FROM menu_disk_title_doc_tools
                 WHERE menu_disk_title_id='$menu_disk_title_id'";
-            $result = $mysqli->query($query_doc_tool_id) or die('Error: ' . mysqli_error($mysqli));
+            $result = $mysqli->query($query_doc_tool_id) or die('Error: '.mysqli_error($mysqli));
             $query_data  = $result->fetch_array(MYSQLI_BOTH);
             $doc_tool_id = $query_data['doc_tools_id'];
 
             //get the doc id
             $query_doc_id = "SELECT * FROM doc_disk_game WHERE doc_disk_game_id='$doc_game_id'";
-            $result = $mysqli->query($query_doc_id) or die('Error: ' . mysqli_error($mysqli));
+            $result = $mysqli->query($query_doc_id) or die('Error: '.mysqli_error($mysqli));
             $query_data = $result->fetch_array(MYSQLI_BOTH);
             $doc_id     = $query_data['doc_id'];
 
             if ($doc_id == '') {
                 $query_doc_id = "SELECT * FROM doc_disk_tool WHERE doc_disk_tool_id='$doc_tool_id'";
-                $result = $mysqli->query($query_doc_id) or die('Error: ' . mysqli_error($mysqli));
+                $result = $mysqli->query($query_doc_id) or die('Error: '.mysqli_error($mysqli));
                 $query_data = $result->fetch_array(MYSQLI_BOTH);
                 $doc_id     = $query_data['doc_id'];
             }
 
             $mysqli->query("DELETE FROM menu_disk_title WHERE menu_disk_title_id='$menu_disk_title_id'")
-                or die('Error: ' . mysqli_error($mysqli));
+                or die('Error: '.mysqli_error($mysqli));
             $mysqli->query("DELETE FROM doc_disk_game WHERE doc_disk_game_id='$doc_game_id'")
-                or die('Error: ' . mysqli_error($mysqli));
+                or die('Error: '.mysqli_error($mysqli));
             $mysqli->query("DELETE FROM menu_disk_title_doc_games WHERE menu_disk_title_id='$menu_disk_title_id'")
-                or die('Error: ' . mysqli_error($mysqli));
+                or die('Error: '.mysqli_error($mysqli));
             $mysqli->query("DELETE FROM doc_disk_tool WHERE doc_disk_tool_id='$doc_tool_id'")
-                or die('Error: ' . mysqli_error($mysqli));
+                or die('Error: '.mysqli_error($mysqli));
             $mysqli->query("DELETE FROM menu_disk_title_doc_tools WHERE menu_disk_title_id='$menu_disk_title_id'")
-                or die('Error: ' . mysqli_error($mysqli));
-            $mysqli->query("DELETE FROM doc WHERE doc_id='$doc_id'") or die('Error: ' . mysqli_error($mysqli));
+                or die('Error: '.mysqli_error($mysqli));
+            $mysqli->query("DELETE FROM doc WHERE doc_id='$doc_id'") or die('Error: '.mysqli_error($mysqli));
 
             $osd_message = "Game doc deleted from menu disk";
         }
@@ -480,7 +480,7 @@ 
 
     //get the doc types
     $sql_doc_type = "SELECT * from doc_type";
-    $query_doc_type = $mysqli->query($sql_doc_type) or die('Error: ' . mysqli_error($mysqli));
+    $query_doc_type = $mysqli->query($sql_doc_type) or die('Error: '.mysqli_error($mysqli));
 
     while ($query_type = $query_doc_type->fetch_array(MYSQLI_BOTH)) {
         $smarty->append('doc_type', array(
@@ -495,7 +495,7 @@ 
     $smarty->assign('osd_message', $osd_message);
 
     //Send to smarty for return value
-    $smarty->display("file:" . $cpanel_template_folder . "menus/ajax_menus_detail.html");
+    $smarty->display("file:".$cpanel_template_folder."menus/ajax_menus_detail.html");
 }
 
 //****************************************************************************************
@@ -530,13 +530,13 @@ 
                     // First we insert the directory path of where the file will be stored... this also creates an
                     // autoinc number for us.
                     $sdbquery = $mysqli->query("INSERT INTO screenshot_main (imgext) VALUES ('$ext')")
-                        or die('Error: ' . mysqli_error($mysqli));
+                        or die('Error: '.mysqli_error($mysqli));
 
                     //select the newly entered screenshot_id from the main table
                     $screenshot_id = $mysqli->insert_id;
 
                     $sdbquery = $mysqli->query("INSERT INTO screenshot_menu (menu_disk_id, screenshot_id)
-                        VALUES ($menu_disk_id, $screenshot_id)") or die('Error: ' . mysqli_error($mysqli));
+                        VALUES ($menu_disk_id, $screenshot_id)") or die('Error: '.mysqli_error($mysqli));
 
                     // Rename the uploaded file to its autoincrement number and move it to its proper place.
                     $file_data = rename($image['tmp_name'][$key], "$menu_screenshot_save_path$screenshot_id.$ext");
@@ -566,7 +566,7 @@ 
     $sql_screenshots = $mysqli->query("SELECT * FROM screenshot_menu
             LEFT JOIN screenshot_main ON (screenshot_menu.screenshot_id = screenshot_main.screenshot_id)
             WHERE screenshot_menu.menu_disk_id = '$menu_disk_id' ORDER BY screenshot_menu.screenshot_id")
-            or die('Error: ' . mysqli_error($mysqli));
+            or die('Error: '.mysqli_error($mysqli));
 
     $count         = 1;
     $v_screenshots = 0;
@@ -595,7 +595,7 @@ 
     $smarty->assign('menu_disk_id', $menu_disk_id);
 
     //Send to smarty for return value
-    $smarty->display("file:" . $cpanel_template_folder . "menus/ajax_menus_detail.html");
+    $smarty->display("file:".$cpanel_template_folder."menus/ajax_menus_detail.html");
 }
 
 //****************************************************************************************
@@ -605,20 +605,20 @@ 
     if ($_SESSION['permission'] == 1 or $_SESSION['permission'] == '1') {
         $sql_menushot = $mysqli->query("SELECT * FROM screenshot_menu
                             WHERE menu_disk_id = $menu_disk_id
-                        AND screenshot_id = $screenshot_id") or die('Error: ' . mysqli_error($mysqli));
+                        AND screenshot_id = $screenshot_id") or die('Error: '.mysqli_error($mysqli));
 
         $menushot   = $sql_menushot->fetch_row();
         $menushotid = $menushot[0];
 
         //get the extension
         $SCREENSHOT = $mysqli->query("SELECT * FROM screenshot_main
-                        WHERE screenshot_id = '$screenshot_id'") or die('Error: ' . mysqli_error($mysqli));
+                        WHERE screenshot_id = '$screenshot_id'") or die('Error: '.mysqli_error($mysqli));
 
         $screenshotrow  = $SCREENSHOT->fetch_array(MYSQLI_BOTH);
         $screenshot_ext = $screenshotrow['imgext'];
 
         $sql = $mysqli->query("DELETE FROM screenshot_main WHERE screenshot_id = '$screenshot_id' ")
-            or die('Error: ' . mysqli_error($mysqli));
+            or die('Error: '.mysqli_error($mysqli));
 
         $new_path = $menu_screenshot_save_path;
         ;
@@ -636,7 +636,7 @@ 
     $sql_screenshots = $mysqli->query("SELECT * FROM screenshot_menu
         LEFT JOIN screenshot_main ON (screenshot_menu.screenshot_id = screenshot_main.screenshot_id)
         WHERE screenshot_menu.menu_disk_id = '$menu_disk_id' ORDER BY screenshot_menu.screenshot_id")
-        or die('Error: ' . mysqli_error($mysqli));
+        or die('Error: '.mysqli_error($mysqli));
 
     $count         = 1;
     $v_screenshots = 0;
@@ -664,7 +664,7 @@ 
     $smarty->assign('menu_disk_id', $menu_disk_id);
 
     //Send to smarty for return value
-    $smarty->display("file:" . $cpanel_template_folder . "menus/ajax_menus_detail.html");
+    $smarty->display("file:".$cpanel_template_folder."menus/ajax_menus_detail.html");
 }
 
 //****************************************************************************************
@@ -685,7 +685,7 @@ 
     //************************************************************************************************
     //get the existing downloads
     $SQL_DOWNLOADS = $mysqli->query("SELECT * FROM menu_disk_download WHERE menu_disk_id='$menu_disk_id'")
-        or die('Error: ' . mysqli_error($mysqli));
+        or die('Error: '.mysqli_error($mysqli));
 
     $nr_downloads = 0;
     while ($downloads = $SQL_DOWNLOADS->fetch_array(MYSQLI_BOTH)) {
@@ -713,7 +713,7 @@ 
           LEFT JOIN menu_set ON (menu_disk.menu_sets_id = menu_set.menu_sets_id)
           WHERE menu_disk.menu_disk_id = '$menu_disk_id'";
 
-    $result_menus = $mysqli->query($sql_menus) or die('Error: ' . mysqli_error($mysqli));
+    $result_menus = $mysqli->query($sql_menus) or die('Error: '.mysqli_error($mysqli));
 
     while ($row = $result_menus->fetch_array(MYSQLI_BOTH)) {
         // Create Menu disk name
@@ -741,7 +741,7 @@ 
     $smarty->assign('menu_disk_id', $menu_disk_id);
 
     //Send to smarty for return value
-    $smarty->display("file:" . $cpanel_template_folder . "menus/ajax_menus_detail.html");
+    $smarty->display("file:".$cpanel_template_folder."menus/ajax_menus_detail.html");
 }
 
 //****************************************************************************************
@@ -761,7 +761,7 @@ 
 
             // Obtain the contentlist of the zip file.
             if (($list = $zip->listContent()) == 0) {
-                die("Error : " . $zip->errorInfo(true));
+                die("Error : ".$zip->errorInfo(true));
             }
 
             // Get the filename from the returned array
@@ -784,11 +784,11 @@ 
 
             // Insert the ext,timestamp and the menu id into the menu download table.
             $sdbquery = $mysqli->query("INSERT INTO menu_disk_download (menu_disk_id,fileext)
-                VALUES ('$menu_disk_id','$ext')") or die('Error: ' . mysqli_error($mysqli));
+                VALUES ('$menu_disk_id','$ext')") or die('Error: '.mysqli_error($mysqli));
 
             //select the newly created menu_download_id from the menu_download table
             $MENUDOWN = $mysqli->query("SELECT menu_disk_download_id FROM menu_disk_download
-                         ORDER BY menu_disk_download_id desc") or die('Error: ' . mysqli_error($mysqli));
+                         ORDER BY menu_disk_download_id desc") or die('Error: '.mysqli_error($mysqli));
 
             $menudownrow = $MENUDOWN->fetch_row();
 
@@ -796,18 +796,18 @@ 
             $archive = new PclZip("$tempfilename");
 
             if ($archive->extract(PCLZIP_OPT_PATH, "$menu_file_temp_path") == 0) {
-                die("Error : " . $archive->errorInfo(true));
+                die("Error : ".$archive->errorInfo(true));
             }
 
             // rename diskimage to increment number
             rename("$menu_file_temp_path$filename", "$menu_file_temp_path$menudownrow[0].$ext")
-                or die('Error: ' . mysqli_error($mysqli));
+                or die('Error: '.mysqli_error($mysqli));
 
             //Time to rezip file and place it in the proper location.
             $archive = new PclZip("$menu_file_path$menudownrow[0].zip");
             $v_list  = $archive->create("$menu_file_temp_path$menudownrow[0].$ext", PCLZIP_OPT_REMOVE_ALL_PATH);
             if ($v_list == 0) {
-                die("Error : " . $archive->errorInfo(true));
+                die("Error : ".$archive->errorInfo(true));
             }
 
             // Time to do the safeties, here we do a sha512 file hash that we later enter into the database, this will
@@ -818,7 +818,7 @@ 
             //$crc = md5_file ( "$game_file_path$gamedownrow[0].zip");
 
             $sdbquery = $mysqli->query("UPDATE menu_disk_download SET sha512 = '$crc'
-                WHERE menu_disk_download_id = '$menudownrow[0]'") or die('Error: ' . mysqli_error($mysqli));
+                WHERE menu_disk_download_id = '$menudownrow[0]'") or die('Error: '.mysqli_error($mysqli));
 
             // Chmod file so that we can backup/delete files through ftp.
             chmod("$menu_file_path$menudownrow[0].zip", 0777);
@@ -838,7 +838,7 @@ 
     //************************************************************************************************
     //get the existing downloads
     $SQL_DOWNLOADS = $mysqli->query("SELECT * FROM menu_disk_download WHERE menu_disk_id='$menu_disk_id'")
-        or die('Error: ' . mysqli_error($mysqli));
+        or die('Error: '.mysqli_error($mysqli));
 
     $nr_downloads = 0;
     while ($downloads = $SQL_DOWNLOADS->fetch_array(MYSQLI_BOTH)) {
@@ -866,7 +866,7 @@ 
         LEFT JOIN menu_set ON (menu_disk.menu_sets_id = menu_set.menu_sets_id)
         WHERE menu_disk.menu_disk_id = '$menu_disk_id'";
 
-    $result_menus = $mysqli->query($sql_menus) or die('Error: ' . mysqli_error($mysqli));
+    $result_menus = $mysqli->query($sql_menus) or die('Error: '.mysqli_error($mysqli));
 
     while ($row = $result_menus->fetch_array(MYSQLI_BOTH)) {
         // Create Menu disk name
@@ -893,7 +893,7 @@ 
     $smarty->assign('menu_disk_id', $menu_disk_id);
 
     //Send to smarty for return value
-    $smarty->display("file:" . $cpanel_template_folder . "menus/ajax_menus_detail.html");
+    $smarty->display("file:".$cpanel_template_folder."menus/ajax_menus_detail.html");
 }
 
 //****************************************************************************************
@@ -934,7 +934,7 @@ 
                     $nick_id = $fetch_ind_nicks['nick_id'];
 
                     $sql_nick_names = $mysqli->query("SELECT ind_name from individuals WHERE ind_id = '$nick_id'")
-                        or die('Error: ' . mysqli_error($mysqli));
+                        or die('Error: '.mysqli_error($mysqli));
 
                     while ($fetch_nick_names = $sql_nick_names->fetch_array(MYSQLI_BOTH)) {
                         $smarty->append('ind_nick', array(
@@ -961,7 +961,7 @@ 
         $smarty->assign('osd_message', $osd_message);
         $smarty->assign('smarty_action', 'update_menu_disk_credits');
         //Send to smarty for return value
-        $smarty->display("file:" . $cpanel_template_folder . "menus/ajax_menus_detail.html");
+        $smarty->display("file:".$cpanel_template_folder."menus/ajax_menus_detail.html");
     }
 }
 
@@ -1010,7 +1010,7 @@ 
                     $nick_id = $fetch_ind_nicks['nick_id'];
 
                     $sql_nick_names = $mysqli->query("SELECT ind_name from individuals WHERE ind_id = '$nick_id'")
-                        or die('Error: ' . mysqli_error($mysqli));
+                        or die('Error: '.mysqli_error($mysqli));
 
                     while ($fetch_nick_names = $sql_nick_names->fetch_array(MYSQLI_BOTH)) {
                         $smarty->append('ind_nick', array(
@@ -1037,7 +1037,7 @@ 
         $smarty->assign('osd_message', $osd_message);
         $smarty->assign('smarty_action', 'update_menu_disk_credits');
         //Send to smarty for return value
-        $smarty->display("file:" . $cpanel_template_folder . "menus/ajax_menus_detail.html");
+        $smarty->display("file:".$cpanel_template_folder."menus/ajax_menus_detail.html");
     }
 }
 
@@ -1048,19 +1048,19 @@ 
 if (isset($action) and ($action == "delete_menu_disk")) {
     // first let's check if this menu disk has user comments
     $sql = $mysqli->query("SELECT * FROM menu_user_comments WHERE menu_disk_id = '$menu_disk_id'")
-        or die('Error: ' . mysqli_error($mysqli));
+        or die('Error: '.mysqli_error($mysqli));
     if ($sql->num_rows > 0) {
         $osd_message = "This menu still has user comments, please remove them first";
     } else {
         // check for downloads
         $sql = $mysqli->query("SELECT * FROM menu_disk_download WHERE menu_disk_id='$menu_disk_id'")
-            or die('Error: ' . mysqli_error($mysqli));
+            or die('Error: '.mysqli_error($mysqli));
         if ($sql->num_rows > 0) {
             $osd_message = "This menu still has downloads, please remove them first";
         } else {
             //check for screenshots
             $sql = $mysqli->query("SELECT * FROM screenshot_menu WHERE menu_disk_id='$menu_disk_id'")
-                or die('Error: ' . mysqli_error($mysqli));
+                or die('Error: '.mysqli_error($mysqli));
             if ($sql->num_rows > 0) {
                 $osd_message = "This menu still has screenshots, please remove them first";
             } else {
@@ -1075,14 +1075,14 @@ 
 
                 //get the menu set id
                 $query_menu_sets_id = "SELECT menu_sets_id FROM menu_disk WHERE menu_disk_id = '$menu_disk_id'";
-                $result = $mysqli->query($query_menu_sets_id) or die('Error: ' . mysqli_error($mysqli));
+                $result = $mysqli->query($query_menu_sets_id) or die('Error: '.mysqli_error($mysqli));
                 $query_id     = $result->fetch_array(MYSQLI_BOTH);
                 $menu_sets_id = $query_id['menu_sets_id'];
 
                 //get the menu disk title id
                 $sql_menu_disk_title_id = "SELECT menu_disk_title_id FROM menu_disk_title
                     WHERE menu_disk_id = '$menu_disk_id'";
-                $result = $mysqli->query($sql_menu_disk_title_id) or die('Error: ' . mysqli_error($mysqli));
+                $result = $mysqli->query($sql_menu_disk_title_id) or die('Error: '.mysqli_error($mysqli));
 
                 while ($query_id = $result->fetch_array(MYSQLI_BOTH)) {
                     $menu_disk_title_id = $query_id['menu_disk_title_id'];
@@ -1090,68 +1090,68 @@ 
                     //get the doc cross id
                     $query_doc_game_id = "SELECT doc_games_id FROM menu_disk_title_doc_games
                         WHERE menu_disk_title_id='$menu_disk_title_id'";
-                    $result_doc_game = $mysqli->query($query_doc_game_id) or die('Error: ' . mysqli_error($mysqli));
+                    $result_doc_game = $mysqli->query($query_doc_game_id) or die('Error: '.mysqli_error($mysqli));
                     $query_data  = $result_doc_game->fetch_array(MYSQLI_BOTH);
                     $doc_game_id = $query_data['doc_games_id'];
 
                     $query_doc_tool_id = "SELECT * FROM menu_disk_title_doc_tools
                         WHERE menu_disk_title_id='$menu_disk_title_id'";
-                    $result_doc_tool = $mysqli->query($query_doc_tool_id) or die('Error: ' . mysqli_error($mysqli));
+                    $result_doc_tool = $mysqli->query($query_doc_tool_id) or die('Error: '.mysqli_error($mysqli));
                     $query_data  = $result_doc_tool->fetch_array(MYSQLI_BOTH);
                     $doc_tool_id = $query_data['doc_tools_id'];
 
                     //get the doc id
                     $query_doc_id = "SELECT * FROM doc_disk_game WHERE doc_disk_game_id='$doc_game_id'";
-                    $result_doc_id = $mysqli->query($query_doc_id) or die('Error: ' . mysqli_error($mysqli));
+                    $result_doc_id = $mysqli->query($query_doc_id) or die('Error: '.mysqli_error($mysqli));
                     $query_data = $result_doc_id->fetch_array(MYSQLI_BOTH);
                     $doc_id     = $query_data['doc_id'];
 
                     if ($doc_id == '') {
                         $query_doc_id = "SELECT * FROM doc_disk_tool WHERE doc_disk_tool_id='$doc_tool_id'";
-                        $result_doc_id = $mysqli->query($query_doc_id) or die('Error: ' . mysqli_error($mysqli));
+                        $result_doc_id = $mysqli->query($query_doc_id) or die('Error: '.mysqli_error($mysqli));
                         $query_data = $result_doc_id->fetch_array(MYSQLI_BOTH);
                         $doc_id     = $query_data['doc_id'];
                     }
 
                     //Lets do all the menu disk title stuff
                     $mysqli->query("DELETE from menu_disk_title WHERE menu_disk_title_id='$menu_disk_title_id'")
-                        or die('Error: ' . mysqli_error($mysqli));
+                        or die('Error: '.mysqli_error($mysqli));
                     $mysqli->query("DELETE from menu_disk_title_game WHERE menu_disk_title_id='$menu_disk_title_id'")
-                        or die('Error: ' . mysqli_error($mysqli));
+                        or die('Error: '.mysqli_error($mysqli));
                     $mysqli->query("DELETE from menu_disk_title_tools WHERE menu_disk_title_id='$menu_disk_title_id'")
-                        or die('Error: ' . mysqli_error($mysqli));
+                        or die('Error: '.mysqli_error($mysqli));
                     $mysqli->query("DELETE from menu_disk_title_demo WHERE menu_disk_title_id='$menu_disk_title_id'")
-                        or die('Error: ' . mysqli_error($mysqli));
+                        or die('Error: '.mysqli_error($mysqli));
                     $mysqli->query("DELETE from menu_disk_title_music WHERE menu_disk_title_id='$menu_disk_title_id'")
-                        or die('Error: ' . mysqli_error($mysqli));
+                        or die('Error: '.mysqli_error($mysqli));
                     $mysqli->query("DELETE from menu_disk_title_various WHERE menu_disk_title_id='$menu_disk_title_id'")
-                        or die('Error: ' . mysqli_error($mysqli));
+                        or die('Error: '.mysqli_error($mysqli));
                     $mysqli->query("DELETE from menu_disk_title_doc_games
-                        WHERE menu_disk_title_id='$menu_disk_title_id'") or die('Error: ' . mysqli_error($mysqli));
+                        WHERE menu_disk_title_id='$menu_disk_title_id'") or die('Error: '.mysqli_error($mysqli));
                     $mysqli->query("DELETE from menu_disk_title_doc_tools
-                        WHERE menu_disk_title_id='$menu_disk_title_id'") or die('Error: ' . mysqli_error($mysqli));
+                        WHERE menu_disk_title_id='$menu_disk_title_id'") or die('Error: '.mysqli_error($mysqli));
                     $mysqli->query("DELETE from menu_disk_title_set
-                        WHERE menu_disk_title_id='$menu_disk_title_id'") or die('Error: ' . mysqli_error($mysqli));
+                        WHERE menu_disk_title_id='$menu_disk_title_id'") or die('Error: '.mysqli_error($mysqli));
                     $mysqli->query("DELETE from menu_disk_title_author
-                        WHERE menu_disk_title_id='$menu_disk_title_id'") or die('Error: ' . mysqli_error($mysqli));
+                        WHERE menu_disk_title_id='$menu_disk_title_id'") or die('Error: '.mysqli_error($mysqli));
 
                     //Lets do all the doc disk stuff
                     $mysqli->query("DELETE FROM doc_disk_game WHERE doc_disk_game_id='$doc_game_id'")
-                         or die('Error: ' . mysqli_error($mysqli));
+                         or die('Error: '.mysqli_error($mysqli));
                     $mysqli->query("DELETE FROM doc_disk_tool WHERE doc_disk_tool_id='$doc_tool_id'")
-                         or die('Error: ' . mysqli_error($mysqli));
-                    $mysqli->query("DELETE FROM doc WHERE doc_id='$doc_id'") or die('Error: ' . mysqli_error($mysqli));
+                         or die('Error: '.mysqli_error($mysqli));
+                    $mysqli->query("DELETE FROM doc WHERE doc_id='$doc_id'") or die('Error: '.mysqli_error($mysqli));
                 }
 
                 // menu disk tables
                 $mysqli->query("DELETE from menu_disk_year WHERE menu_disk_id='$menu_disk_id'")
-                    or die('Error: ' . mysqli_error($mysqli));
+                    or die('Error: '.mysqli_error($mysqli));
                 $mysqli->query("DELETE from menu_disk_submenu WHERE menu_disk_id='$menu_disk_id'")
-                    or die('Error: ' . mysqli_error($mysqli));
+                    or die('Error: '.mysqli_error($mysqli));
                 $mysqli->query("DELETE from menu_disk_credits WHERE menu_disk_id='$menu_disk_id'")
-                    or die('Error: ' . mysqli_error($mysqli));
+                    or die('Error: '.mysqli_error($mysqli));
                 $mysqli->query("DELETE from menu_disk WHERE menu_disk_id='$menu_disk_id'")
-                    or die('Error: ' . mysqli_error($mysqli));
+                    or die('Error: '.mysqli_error($mysqli));
 
                 $osd_message = "Menudisk completely removed";
                 $smarty->assign('osd_message', $osd_message);
@@ -1178,28 +1178,28 @@ 
             // first check if the menu has already a parent entry
             } elseif ($action == "change_menu_disk_parent") {
                 $sql = $mysqli->query("SELECT * FROM menu_disk_submenu
-                WHERE menu_disk_id = '$menu_disk_id'") or die('Error: ' . mysqli_error($mysqli));
+                WHERE menu_disk_id = '$menu_disk_id'") or die('Error: '.mysqli_error($mysqli));
                 if ($sql->num_rows > 0) {
                     //Update state
                     $sql = $mysqli->query("UPDATE menu_disk_submenu SET parent_id='$parent_id'
                   WHERE menu_disk_id='$menu_disk_id'");
                 } else {
                     $sql_menu_parent = $mysqli->query("INSERT INTO menu_disk_submenu (parent_id, menu_disk_id)
-                        VALUES ('$parent_id','$menu_disk_id')") or die('Error: ' . mysqli_error($mysqli));
+                        VALUES ('$parent_id','$menu_disk_id')") or die('Error: '.mysqli_error($mysqli));
                 }
                 create_log_entry('Menu disk', $menu_disk_id, 'Parent', $parent_id, 'Update', $_SESSION['user_id']);
                 $osd_message = 'Parent updated';
             } else {
                 // first check if the menu has already a year entry
                 $sql = $mysqli->query("SELECT * FROM menu_disk_year
-                WHERE menu_disk_id = '$menu_disk_id'") or die('Error: ' . mysqli_error($mysqli));
+                WHERE menu_disk_id = '$menu_disk_id'") or die('Error: '.mysqli_error($mysqli));
                 if ($sql->num_rows > 0) {
                     //Update year
                     $sql = $mysqli->query("UPDATE menu_disk_year SET menu_year='$year_id'
                   WHERE menu_disk_id='$menu_disk_id'");
                 } else {
                     $sql_menu_year = $mysqli->query("INSERT INTO menu_disk_year (menu_year, menu_disk_id)
-                        VALUES ('$year_id','$menu_disk_id')") or die('Error: ' . mysqli_error($mysqli));
+                        VALUES ('$year_id','$menu_disk_id')") or die('Error: '.mysqli_error($mysqli));
                 }
                 create_log_entry('Menu disk', $menu_disk_id, 'Year', $year_id, 'Update', $_SESSION['user_id']);
                 $osd_message = 'Year updated';
@@ -1315,7 +1315,7 @@ 
 
         //get the doc types
         $sql_doc_type = "SELECT * from doc_type";
-        $query_doc_type = $mysqli->query($sql_doc_type) or die('Error: ' . mysqli_error($mysqli));
+        $query_doc_type = $mysqli->query($sql_doc_type) or die('Error: '.mysqli_error($mysqli));
 
         while ($query_type = $query_doc_type->fetch_array(MYSQLI_BOTH)) {
             $smarty->append('doc_type', array(
@@ -1336,7 +1336,7 @@ 
               WHERE menu_disk_credits.menu_disk_id = '$menu_disk_id'
               ORDER BY individuals.ind_name ASC";
 
-        $query_individual = $mysqli->query($sql_individuals) or die('Error: ' . mysqli_error($mysqli));
+        $query_individual = $mysqli->query($sql_individuals) or die('Error: '.mysqli_error($mysqli));
         ;
 
         $query_ind_id = "";
@@ -1344,14 +1344,14 @@ 
         while ($query = $query_individual->fetch_array(MYSQLI_BOTH)) {
             if ($query_ind_id != $query['ind_id']) {
                 $sql_ind_nicks = $mysqli->query("SELECT nick_id FROM individual_nicks WHERE ind_id = '$query[ind_id]'")
-                    or die('Error: ' . mysqli_error($mysqli));
+                    or die('Error: '.mysqli_error($mysqli));
                 ;
 
                 while ($fetch_ind_nicks = $sql_ind_nicks->fetch_array(MYSQLI_BOTH)) {
                     $nick_id = $fetch_ind_nicks['nick_id'];
 
                     $sql_nick_names = $mysqli->query("SELECT ind_name from individuals WHERE ind_id = '$nick_id'")
-                        or die('Error: ' . mysqli_error($mysqli));
+                        or die('Error: '.mysqli_error($mysqli));
 
                     while ($fetch_nick_names = $sql_nick_names->fetch_array(MYSQLI_BOTH)) {
                         $smarty->append('ind_nick', array(
@@ -1386,7 +1386,7 @@ 
             FROM menu_disk
             LEFT JOIN menu_set ON (menu_disk.menu_sets_id = menu_set.menu_sets_id)";
 
-        $result_parent = $mysqli->query($sql_parent) or die('Error: ' . mysqli_error($mysqli));
+        $result_parent = $mysqli->query($sql_parent) or die('Error: '.mysqli_error($mysqli));
         while ($row = $result_parent->fetch_array(MYSQLI_BOTH)) {
             // Create Menu disk name
             $menu_disk_name = "$row[menu_sets_name] ";
@@ -1427,7 +1427,7 @@ 
         $sql_screenshots = $mysqli->query("SELECT * FROM screenshot_menu
               LEFT JOIN screenshot_main ON (screenshot_menu.screenshot_id = screenshot_main.screenshot_id)
               WHERE screenshot_menu.menu_disk_id = '$menu_disk_id' ORDER BY screenshot_menu.screenshot_id")
-                or die('Error: ' . mysqli_error($mysqli));
+                or die('Error: '.mysqli_error($mysqli));
 
         $count         = 1;
         $v_screenshots = 0;
@@ -1457,7 +1457,7 @@ 
         //************************************************************************************************
         //get the existing downloads
         $SQL_DOWNLOADS = $mysqli->query("SELECT * FROM menu_disk_download WHERE menu_disk_id='$menu_disk_id'")
-            or die('Error: ' . mysqli_error($mysqli));
+            or die('Error: '.mysqli_error($mysqli));
 
         $nr_downloads = 0;
         while ($downloads = $SQL_DOWNLOADS->fetch_array(MYSQLI_BOTH)) {
@@ -1485,7 +1485,7 @@ 
             LEFT JOIN menu_set ON (menu_disk.menu_sets_id = menu_set.menu_sets_id)
             WHERE menu_disk.menu_disk_id = '$menu_disk_id'";
 
-        $result_menus = $mysqli->query($sql_menus) or die('Error: ' . mysqli_error($mysqli));
+        $result_menus = $mysqli->query($sql_menus) or die('Error: '.mysqli_error($mysqli));
 
         while ($row = $result_menus->fetch_array(MYSQLI_BOTH)) {
             // Create Menu disk name
@@ -1520,7 +1520,7 @@ 
         $smarty->assign('menu_disk_id', $menu_disk_id);
 
         //Send to smarty for return value
-        $smarty->display("file:" . $cpanel_template_folder . "menus/ajax_menus_detail.html");
+        $smarty->display("file:".$cpanel_template_folder."menus/ajax_menus_detail.html");
     }
 }
 
@@ -1532,7 +1532,7 @@ 
         if ($_SESSION['permission'] == 1 or $_SESSION['permission'] == '1') {
             //Update doc type
             $sql = $mysqli->query("UPDATE doc SET doc_type_id='$doc_type_id'
-                WHERE doc_id='$doc_id'") or die('Error: ' . mysqli_error($mysqli));
+                WHERE doc_id='$doc_id'") or die('Error: '.mysqli_error($mysqli));
 
             create_log_entry('Menu disk', $menu_disk_id, 'Doc type', $doc_type_id, 'Insert', $_SESSION['user_id']);
             $osd_message = 'doctype updated';
@@ -1561,7 +1561,7 @@ 
 
     //get the doc types
     $sql_doc_type = "SELECT * from doc_type";
-    $query_doc_type = $mysqli->query($sql_doc_type) or die('Error: ' . mysqli_error($mysqli));
+    $query_doc_type = $mysqli->query($sql_doc_type) or die('Error: '.mysqli_error($mysqli));
 
     while ($query_type = $query_doc_type->fetch_array(MYSQLI_BOTH)) {
         $smarty->append('doc_type', array(
@@ -1574,7 +1574,7 @@ 
     $smarty->assign('menu_disk_id', $menu_disk_id);
     $smarty->assign('smarty_action', 'add_doc_to_menu_return');
     //Send to smarty for return value
-    $smarty->display("file:" . $cpanel_template_folder . "menus/ajax_menus_detail.html");
+    $smarty->display("file:".$cpanel_template_folder."menus/ajax_menus_detail.html");
 }
 
 //****************************************************************************************
@@ -1587,14 +1587,14 @@ 
             if ($action == "add_set_to_menu") {
                 /* first see if this title is already chained */
                 $sql = $mysqli->query("SELECT * FROM menu_disk_title_set
-                WHERE menu_disk_title_id = '$menu_disk_title_id'") or die('Error: ' . mysqli_error($mysqli));
+                WHERE menu_disk_title_id = '$menu_disk_title_id'") or die('Error: '.mysqli_error($mysqli));
                 if ($sql->num_rows > 0) {
                     $osd_message = "This title is already chained - delete chain first";
                 } else {
                     //check if the title is already linked
                     $sql_set_nr = "SELECT menu_disk_title_set_nr FROM menu_disk_title_set
                         WHERE menu_disk_title_id = '$menu_disk_title_id'";
-                    $query_ser_nr = $mysqli->query($sql_set_nr) or die('Error: ' . mysqli_error($mysqli));
+                    $query_ser_nr = $mysqli->query($sql_set_nr) or die('Error: '.mysqli_error($mysqli));
                     $query_data = $query_ser_nr->fetch_array(MYSQLI_BOTH);
                     $set_nr     = $query_data['menu_disk_title_set_nr'];
 
@@ -1603,7 +1603,7 @@ 
                         /*We need to get the highest set nr */
                         $sql_set_nr = "SELECT menu_disk_title_set_nr FROM menu_disk_title_set
                             order by menu_disk_title_set_nr DESC";
-                        $query_set_nr = $mysqli->query($sql_set_nr) or die('Error: ' . mysqli_error($mysqli));
+                        $query_set_nr = $mysqli->query($sql_set_nr) or die('Error: '.mysqli_error($mysqli));
                         if ($query_set_nr->num_rows > 0) {
                             while ($row = $query_set_nr->fetch_array(MYSQLI_BOTH)) {
                                 $set_nr = $row['menu_disk_title_set_nr'];
@@ -1617,7 +1617,7 @@ 
 
                     $sql_menu_set = $mysqli->query("INSERT INTO menu_disk_title_set (menu_disk_title_set_nr,
                         menu_disk_title_set_chain, menu_disk_title_id) VALUES ('$set_nr','1', $menu_disk_title_id)")
-                        or die('Error: ' . mysqli_error($mysqli));
+                        or die('Error: '.mysqli_error($mysqli));
                     $osd_message = "Chain created for this title";
 
                     create_log_entry(
@@ -1637,14 +1637,14 @@ 
                 } else {
                     //check if the title is already linked
                     $sql = $mysqli->query("SELECT * FROM menu_disk_title_set
-                  WHERE menu_disk_title_id = '$menu_disk_title_id'") or die('Error: ' . mysqli_error($mysqli));
+                  WHERE menu_disk_title_id = '$menu_disk_title_id'") or die('Error: '.mysqli_error($mysqli));
                     if ($sql->num_rows > 0) {
                         $osd_message = "This title is already chained - delete chain first";
                     } else {
                         $sql_menu_set = $mysqli->query("INSERT INTO menu_disk_title_set (menu_disk_title_set_nr,
                             menu_disk_title_set_chain, menu_disk_title_id)
                             VALUES ('$chainbrowse','$menu_disk_title_set_chain', $menu_disk_title_id)")
-                            or die('Error: ' . mysqli_error($mysqli));
+                            or die('Error: '.mysqli_error($mysqli));
                         $osd_message = "Chain created for this title";
 
                         create_log_entry(
@@ -1668,7 +1668,7 @@ 
                 );
 
                 $mysqli->query("DELETE from menu_disk_title_set WHERE menu_disk_title_id='$menu_disk_title_id'")
-                    or die('Error: ' . mysqli_error($mysqli));
+                    or die('Error: '.mysqli_error($mysqli));
                 $osd_message = "Title deleted from chain";
                 $smarty->assign('title_name', $title_name);
             }
@@ -1742,11 +1742,11 @@ 
         WHERE menu_disk_title.menu_types_main_id = '3'";
 
     $temp_query = $mysqli->query("CREATE TEMPORARY TABLE temp ENGINE=MEMORY $sql_games_chain") or die(mysqli_error());
-    $temp_query = $mysqli->query("INSERT INTO temp $sql_demos_chain") or die('Error: ' . mysqli_error($mysqli));
-    $temp_query = $mysqli->query("INSERT INTO temp $sql_tools_chain") or die('Error: ' . mysqli_error($mysqli));
+    $temp_query = $mysqli->query("INSERT INTO temp $sql_demos_chain") or die('Error: '.mysqli_error($mysqli));
+    $temp_query = $mysqli->query("INSERT INTO temp $sql_tools_chain") or die('Error: '.mysqli_error($mysqli));
 
     $temp_query = $mysqli->query("SELECT * FROM temp ORDER BY menu_sets_name, menu_disk_title_id ASC")
-        or die('Error: ' . mysqli_error($mysqli));
+        or die('Error: '.mysqli_error($mysqli));
 
     $menu_disk_name_compare = "";
 
@@ -1790,7 +1790,7 @@ 
     //First get the setnr
     $sql_set_nr = "SELECT menu_disk_title_set_nr FROM menu_disk_title_set
         WHERE menu_disk_title_id = '$menu_disk_title_id'";
-    $query_ser_nr = $mysqli->query($sql_set_nr) or die('Error: ' . mysqli_error($mysqli));
+    $query_ser_nr = $mysqli->query($sql_set_nr) or die('Error: '.mysqli_error($mysqli));
     $query_data = $query_ser_nr->fetch_array(MYSQLI_BOTH);
     $set_nr     = $query_data['menu_disk_title_set_nr'];
 
@@ -1863,11 +1863,11 @@ 
 
         $temp_query = $mysqli->query("CREATE TEMPORARY TABLE temp3 ENGINE=MEMORY $sql_games_chain")
             or die(mysqli_error());
-        $temp_query = $mysqli->query("INSERT INTO temp3 $sql_demos_chain") or die('Error: ' . mysqli_error($mysqli));
-        $temp_query = $mysqli->query("INSERT INTO temp3 $sql_tools_chain") or die('Error: ' . mysqli_error($mysqli));
+        $temp_query = $mysqli->query("INSERT INTO temp3 $sql_demos_chain") or die('Error: '.mysqli_error($mysqli));
+        $temp_query = $mysqli->query("INSERT INTO temp3 $sql_tools_chain") or die('Error: '.mysqli_error($mysqli));
 
         $temp_query = $mysqli->query("SELECT * FROM temp3 ORDER BY menu_sets_name, menu_disk_title_id ASC")
-            or die('Error: ' . mysqli_error($mysqli));
+            or die('Error: '.mysqli_error($mysqli));
 
         while ($row = $temp_query->fetch_array(MYSQLI_BOTH)) {
             // Create Menu disk name
@@ -1930,7 +1930,7 @@ 
     $smarty->assign('menu_disk_title_id', $menu_disk_title_id);
 
     //Send all smarty variables to the templates
-    $smarty->display("file:" . $cpanel_template_folder . "menus/ajax_menus_detail.html");
+    $smarty->display("file:".$cpanel_template_folder."menus/ajax_menus_detail.html");
 }
 
 //****************************************************************************************
@@ -1949,7 +1949,7 @@ 
         if ($action == 'add_author') {
             //Insert author into the menu_disk_title_author table
             $mysqli->query("INSERT INTO menu_disk_title_author (menu_disk_title_id,ind_id,author_type_id)
-                VALUES ('$menu_disk_title_id','$ind_id','$author_type_id')") or die('Error: ' . mysqli_error($mysqli));
+                VALUES ('$menu_disk_title_id','$ind_id','$author_type_id')") or die('Error: '.mysqli_error($mysqli));
 
             create_log_entry(
                 'Menu disk',
@@ -1963,7 +1963,7 @@ 
         } else {
             //delete author from the menu_disk_title_author table
             $mysqli->query("DELETE FROM menu_disk_title_author WHERE menu_disk_title_id='$menu_disk_title_id'
-                and ind_id ='$ind_id' and author_type_id ='$author_type_id'") or die('Error: ' . mysqli_error($mysqli));
+                and ind_id ='$ind_id' and author_type_id ='$author_type_id'") or die('Error: '.mysqli_error($mysqli));
 
             create_log_entry(
                 'Menu disk',
@@ -2009,7 +2009,7 @@ 
             $nick_id = $fetch_ind_nicks['nick_id'];
 
             $sql_nick_names = $mysqli->query("SELECT ind_name from individuals WHERE ind_id = '$nick_id'")
-                or die('Error: ' . mysqli_error($mysqli));
+                or die('Error: '.mysqli_error($mysqli));
 
             while ($fetch_nick_names = $sql_nick_names->fetch_array(MYSQLI_BOTH)) {
                 $smarty->append('ind_nick', array(
@@ -2031,7 +2031,7 @@ 
 
     // Get Author types for
     $sql_author_types = "SELECT * FROM author_type ORDER BY author_type_info ASC";
-    $query_author = $mysqli->query($sql_author_types) or die('Error: ' . mysqli_error($mysqli));
+    $query_author = $mysqli->query($sql_author_types) or die('Error: '.mysqli_error($mysqli));
 
     while ($author_ind = $query_author->fetch_array(MYSQLI_BOTH)) {
         $smarty->append('author_type', array(
@@ -2052,5 +2052,5 @@ 
     $smarty->assign('az_output', $az_output);
 
     //Send all smarty variables to the templates
-    $smarty->display("file:" . $cpanel_template_folder . "menus/ajax_menus_detail.html");
+    $smarty->display("file:".$cpanel_template_folder."menus/ajax_menus_detail.html");
 }

public/php/admin/menus/ajax_addgames_menus.php

Spacing +1 added lines, -1 removed lines

@@ -175,4 +175,4 @@
 }
 
 //Send all smarty variables to the templates
-$smarty->display("file:" . $cpanel_template_folder . "menus/ajax_menus_add_games.html");
+$smarty->display("file:".$cpanel_template_folder."menus/ajax_menus_add_games.html");

public/php/admin/menus/menus_type.php

Spacing +1 added lines, -1 removed lines

@@ -30,7 +30,7 @@
 $smarty->assign("user_id", $_SESSION['user_id']);
 
 //Send all smarty variables to the templates
-$smarty->display("file:" . $cpanel_template_folder . "menus/menus_type.html");
+$smarty->display("file:".$cpanel_template_folder."menus/menus_type.html");
 
 //close the connection
 mysqli_free_result($result_menus_type);

public/php/admin/menus/menus_type_edit.php

Spacing +2 added lines, -2 removed lines

@@ -39,7 +39,7 @@ 
     $smarty->assign("user_id", $_SESSION['user_id']);
 
     $result_menus_type_edit = $mysqli->query("SELECT * FROM menu_types_main WHERE menu_types_main_id = $menu_type_id")
-        or die('Error: ' . mysqli_error($mysqli));
+        or die('Error: '.mysqli_error($mysqli));
 
     while ($row = $result_menus_type_edit->fetch_array(MYSQLI_BOTH)) {
         $smarty->assign('menus_type_edit', array(
@@ -49,7 +49,7 @@ 
     }
 
     //Send all smarty variables to the templates
-    $smarty->display("file:" . $cpanel_template_folder . "menus/menus_type_edit.html");
+    $smarty->display("file:".$cpanel_template_folder."menus/menus_type_edit.html");
 }
 
 //close the connection

public/php/admin/menus/db_menus_type.php

Spacing +5 added lines, -5 removed lines

@@ -17,7 +17,7 @@ 
 //update the menu type
 if (isset($menus_type_id) and isset($action) and $action == 'update') {
     $sdbquery = $mysqli->query("UPDATE menu_types_main SET menu_types_text = '$menus_type_name'
-        WHERE menu_types_main_id = $menus_type_id") or die('Error: ' . mysqli_error($mysqli));
+        WHERE menu_types_main_id = $menus_type_id") or die('Error: '.mysqli_error($mysqli));
 
     $_SESSION['edit_message'] = "Menu type succesfully updated";
 
@@ -29,19 +29,19 @@ 
 if (isset($menus_type_id) and isset($action) and $action == 'delete_menus_type') {
     // first see if this menu type is used for a menu set or menu disk
     $sql = $mysqli->query("SELECT * FROM menu_disk_title
-            WHERE menu_types_main_id = '$menus_type_id'") or die('Error: ' . mysqli_error($mysqli));
+            WHERE menu_types_main_id = '$menus_type_id'") or die('Error: '.mysqli_error($mysqli));
     if ($sql->num_rows > 0) {
         $_SESSION['edit_message'] = 'Deletion failed - This menu type is linked to menu disks';
     } else {
         $sql = $mysqli->query("SELECT * FROM menu_type
-              WHERE menu_types_main_id = '$menus_type_id'") or die('Error: ' . mysqli_error($mysqli));
+              WHERE menu_types_main_id = '$menus_type_id'") or die('Error: '.mysqli_error($mysqli));
         if ($sql->num_rows > 0) {
             $_SESSION['edit_message'] = 'Deletion failed - This menu type is linked to a menu set';
         } else {
             create_log_entry('Menu type', $menus_type_id, 'Menu type', $menus_type_id, 'Delete', $_SESSION['user_id']);
 
             $mysqli->query("DELETE FROM menu_types_main WHERE menu_types_main_id = $menus_type_id")
-                or die('Error: ' . mysqli_error($mysqli));
+                or die('Error: '.mysqli_error($mysqli));
 
             $_SESSION['edit_message'] = "Menu type succesfully deleted";
         }
@@ -55,7 +55,7 @@ 
         header("Location: ../menus/menus_type.php");
     } else {
         $sql_individuals = $mysqli->query("INSERT INTO  menu_types_main (menu_types_text) VALUES ('$type_name')")
-            or die('Error: ' . mysqli_error($mysqli));
+            or die('Error: '.mysqli_error($mysqli));
 
         $new_menu_type_id = $mysqli->insert_id;