atari-legend / legacy

public/php/main/games/db_games_comment_main.php

Spacing +7 added lines, -7 removed lines

@@ -18,7 +18,7 @@ 
 require "../../config/admin.php";
 
 if (isset($action)) {
-    if ($action=='delete_comment') {
+    if ($action == 'delete_comment') {
         create_log_entry('Games', $comment_id, 'Comment', $comment_id, 'Delete', $_SESSION['user_id']);
 
         $sql = $mysqli->query("DELETE FROM game_user_comments WHERE comment_id = '$comment_id'")
@@ -65,8 +65,8 @@ 
                     LEFT JOIN comments ON ( game_user_comments.comment_id = comments.comments_id )
                     LEFT JOIN users ON ( comments.user_id = users.user_id )
                     LEFT JOIN game ON ( game_user_comments.game_id = game.game_id )
-                     " . $where_clause . "
-                    ORDER BY comments.timestamp DESC LIMIT  " . $v_counter . ", 5";
+                     " . $where_clause."
+                    ORDER BY comments.timestamp DESC LIMIT  " . $v_counter.", 5";
 
     $sql_comment = $mysqli->query($sql_build);
 
@@ -144,7 +144,7 @@ 
         //(instead of a post with pure HTML) The translation of the 'enter' breaks is different in JS, so in JS I do
         // a conversion to a <br>. However, when we edit a comment, this <br> should not be
         //visible to the user, hence again, now this conversion in php
-        $breaks = array("<br />","<br>","<br/>");
+        $breaks = array("<br />", "<br>", "<br/>");
         $comment = str_ireplace($breaks, "\r\n", $comment);
 
         if ($query_comment['join_date'] == "") {
@@ -193,13 +193,13 @@ 
     //Check if back arrow is needed
     if ($v_counter > 0) {
         // Build the link
-        $v_linkback = ('?v_counter=' . ($v_counter - 5 . $users_comments));
+        $v_linkback = ('?v_counter='.($v_counter - 5.$users_comments));
     }
 
     //Check if we need to place a next arrow
     if ($v_rows > ($v_counter + 15)) {
         //Build the link
-        $v_linknext = ('?v_counter=' . ($v_counter + 5 . $users_comments));
+        $v_linknext = ('?v_counter='.($v_counter + 5.$users_comments));
     }
 
     if (empty($c_counter)) {
@@ -224,5 +224,5 @@ 
     );
 
     $smarty->assign('smarty_action', 'delete_comment');
-    $smarty->display("file:" . $mainsite_template_folder. "games/ajax_games_comment_main.html");
+    $smarty->display("file:".$mainsite_template_folder."games/ajax_games_comment_main.html");
 }

public/php/main/games/games_reviews_main.php

Spacing +9 added lines, -9 removed lines

@@ -50,7 +50,7 @@ 
                                 LEFT JOIN users on (review_main.user_id = users.user_id)
                                 LEFT JOIN game on (review_game.game_id = game.game_id)
                                 WHERE review_main.review_edit = '0'
-                                ORDER BY review_main.review_date DESC LIMIT  " . $v_counter . ", 5"
+                                ORDER BY review_main.review_date DESC LIMIT  " . $v_counter.", 5"
         ) or die("couldn't get the reviews - search all");
 
         // count number of interviews
@@ -74,7 +74,7 @@ 
                                 LEFT JOIN users on (review_main.user_id = users.user_id)
                                 LEFT JOIN game on (review_game.game_id = game.game_id)
                                 WHERE review_main.review_edit = '0' AND review_main.user_id = '$author_id'
-                                ORDER BY review_main.review_date DESC LIMIT  " . $v_counter . ", 5"
+                                ORDER BY review_main.review_date DESC LIMIT  ".$v_counter.", 5"
         ) or die("couldn't get the reviews  - search");
 
         // count number of interviews
@@ -104,7 +104,7 @@ 
                         LEFT JOIN users on (review_main.user_id = users.user_id)
 						LEFT JOIN game on (review_game.game_id = game.game_id)
 						WHERE review_main.review_edit = '0'
-						ORDER BY review_main.review_date DESC LIMIT  " . $v_counter . ", 5"
+						ORDER BY review_main.review_date DESC LIMIT  " . $v_counter.", 5"
     ) or die("couldn't get the reviews");
 
     // count number of interviews
@@ -121,7 +121,7 @@ 
     $pos_end = strpos($review_text, '[/frontpage]');
     $nr_char = $pos_end - $pos_start;
 
-    $review_text  = substr($review_text, $pos_start, $nr_char);
+    $review_text = substr($review_text, $pos_start, $nr_char);
 
     //$review_text = str_replace("[i][b]Comments[/b][/i]", "",$review_text);
     //$review_text = str_replace("[i][b]Intro[/b][/i]", "",$review_text);
@@ -189,10 +189,10 @@ 
 //Check if back arrow is needed
 if ($v_counter > 0) {
     // Build the link
-    $v_linkback = ('?v_counter=' . ($v_counter - 5));
+    $v_linkback = ('?v_counter='.($v_counter - 5));
     if (isset($action) and $action == 'search') {
         if ($author_id != '-') {
-            $v_linkback .= '&author_id=' . $author_id . '&action=search';
+            $v_linkback .= '&author_id='.$author_id.'&action=search';
         }
     }
 }
@@ -200,10 +200,10 @@ 
 //Check if we need to place a next arrow
 if ($v_rows > ($v_counter + 5)) {
     //Build the link
-    $v_linknext = ('?v_counter=' . ($v_counter + 5));
+    $v_linknext = ('?v_counter='.($v_counter + 5));
     if (isset($action) and $action == 'search') {
         if ($author_id != '-') {
-            $v_linknext .= '&author_id=' . $author_id . '&action=search';
+            $v_linknext .= '&author_id='.$author_id.'&action=search';
         }
     }
 }
@@ -228,7 +228,7 @@ 
 );
 
 //Send all smarty variables to the templates
-$smarty->display("file:" . $mainsite_template_folder . "games/games_reviews_main.html");
+$smarty->display("file:".$mainsite_template_folder."games/games_reviews_main.html");
 
 //close the connection
 mysqli_close($mysqli);

public/php/main/games/db_games_reviews_detail.php

Spacing +4 added lines, -4 removed lines

@@ -17,14 +17,14 @@ 
 require "../../config/admin.php";
 
 if (isset($action)) {
-    if ($action=='delete_comment') {
+    if ($action == 'delete_comment') {
         create_log_entry('Reviews', $comment_id, 'Comment', $comment_id, 'Delete', $_SESSION['user_id']);
 
         $sql = $mysqli->query("DELETE FROM review_user_comments WHERE comment_id = '$comment_id'")
             or die("couldn't delete game_comment quote");
         $sql = $mysqli->query("DELETE FROM comments WHERE comments_id = '$comment_id'")
             or die("couldn't delete comment quote");
-    } elseif ($action=="save_comment") {
+    } elseif ($action == "save_comment") {
         //$data = $_POST['data'];
         $data = $mysqli->real_escape_string($data);
 
@@ -75,7 +75,7 @@ 
         //(instead of a post with pure HTML) The translation of the 'enter' breaks is different in JS, so in JS I do
         //a conversion to a <br>. However, when we edit a comment, this <br> should not be
         //visible to the user, hence again, now this conversion in php
-        $breaks = array("<br />","<br>","<br/>");
+        $breaks = array("<br />", "<br>", "<br/>");
         $comment = str_ireplace($breaks, "\r\n", $comment);
 
         $date = date("d/m/y", $query_comment['timestamp']);
@@ -102,5 +102,5 @@ 
     $smarty->assign('review_id', $review_id);
 
     //Send all smarty variables to the templates
-    $smarty->display("file:" . $mainsite_template_folder . "games/ajax_games_reviews_detail_comments.html");
+    $smarty->display("file:".$mainsite_template_folder."games/ajax_games_reviews_detail_comments.html");
 }

public/php/main/games/db_games_main_detail.php

Spacing +10 added lines, -10 removed lines

@@ -18,14 +18,14 @@ 
 require "../../config/admin.php";
 
 if (isset($action)) {
-    if ($action=='delete_comment') {
+    if ($action == 'delete_comment') {
         create_log_entry('Games', $comment_id, 'Comment', $comment_id, 'Delete', $_SESSION['user_id']);
 
         $sql = $mysqli->query("DELETE FROM game_user_comments WHERE comment_id = '$comment_id'")
             or die("couldn't delete game_comment quote");
         $sql = $mysqli->query("DELETE FROM comments WHERE comments_id = '$comment_id'")
             or die("couldn't delete comment quote");
-    } elseif ($action=="save_comment") {
+    } elseif ($action == "save_comment") {
         //$data = $_POST['data'];
         $data = $mysqli->real_escape_string($data);
 
@@ -33,15 +33,15 @@ 
             or die("couldn't update comments table");
 
         create_log_entry('Games', $comment_id, 'Comment', $comment_id, 'Update', $_SESSION['user_id']);
-    } elseif ($action=="submit_info") {
+    } elseif ($action == "submit_info") {
         if (isset($subtype) and $subtype == 'medium') {
-            if ($textfield_medium == '' or  $textfield_medium == 'Game info') {
+            if ($textfield_medium == '' or $textfield_medium == 'Game info') {
                 $_SESSION['edit_message'] = "Please add some info in the game info field";
                 header("Location: ../games/games_detail.php?game_id=$game_id");
                 die();
             } else {
                 $timestamp = time();
-                $maxsize    = 10000000; //10mb
+                $maxsize = 10000000; //10mb
                 $mysqli->query(
                     "INSERT INTO game_submitinfo (game_id, user_id, timestamp, submit_text, game_done ) "
                     ."VALUES ('$game_id', '$_SESSION[user_id]', '$timestamp', '$textfield_medium', '2')"
@@ -122,13 +122,13 @@ 
                 die();
             }
         } else {
-            if ($textfield == '' or  $textfield == 'Game info') {
+            if ($textfield == '' or $textfield == 'Game info') {
                 $_SESSION['edit_message'] = "Please add some info in the game info field";
                 header("Location: ../games/games_detail.php?game_id=$game_id");
                 die();
             } else {
                 $timestamp = time();
-                $maxsize    = 10000000; //10mb
+                $maxsize = 10000000; //10mb
                 $mysqli->query(
                     "INSERT INTO game_submitinfo (game_id, user_id, timestamp, submit_text, game_done ) "
                     ."VALUES ('$game_id', '$_SESSION[user_id]', '$timestamp', '$textfield', '2')"
@@ -147,7 +147,7 @@ 
 
                         $ext        = "";
                         $type_image = $image['type'][$key];
-                        $size_image  = $image['size'][$key];
+                        $size_image = $image['size'][$key];
 
                         // set extension
                         if ($type_image == 'image/png') {
@@ -257,7 +257,7 @@ 
         //(instead of a post with pure HTML) The translation of the 'enter' breaks is different in JS, so in JS I do
         //a conversion to a <br>. However, when we edit a comment, this <br> should not be
         //visible to the user, hence again, now this conversion in php
-        $breaks = array("<br />","<br>","<br/>");
+        $breaks = array("<br />", "<br>", "<br/>");
         $comment = str_ireplace($breaks, "\r\n", $comment);
 
         $date = date("F j, Y", $query_comment['timestamp']);
@@ -289,5 +289,5 @@ 
     $smarty->assign('user_avatar_path', $user_avatar_path);
 
     //Send all smarty variables to the templates
-    $smarty->display("file:" . $mainsite_template_folder . "games/ajax_games_main_detail_comments.html");
+    $smarty->display("file:".$mainsite_template_folder."games/ajax_games_main_detail_comments.html");
 }

public/php/main/games/games_reviews_add.php

Spacing +1 added lines, -1 removed lines

@@ -114,7 +114,7 @@
 $smarty->assign("game_id", $game_id);
 
 //Send all smarty variables to the templates
-$smarty->display("file:" . $mainsite_template_folder . "games/games_reviews_add.html");
+$smarty->display("file:".$mainsite_template_folder."games/games_reviews_add.html");
 
 //close the connection
 mysqli_close($mysqli);

public/php/main/games/games_detail.php

Spacing +9 added lines, -9 removed lines

@@ -93,7 +93,7 @@ 
     if ($game_genres) {
         for ($i = 0; $i < count($game_genres); $i++) {
             $desc .= strtolower($game_genres[$i]->getName());
-            if ($i+1 < count($game_genres)) {
+            if ($i + 1 < count($game_genres)) {
                 $desc .= ", ";
             }
         }
@@ -372,7 +372,7 @@ 
             if ($v_ind_image != 'none') {
                 $smarty->append(
                     'interviews',
-                    array( 'ind_id' => $game_individual['id'],
+                    array('ind_id' => $game_individual['id'],
                            'ind_name' => $game_individual['ind_name'],
                            'ind_img' => $v_ind_image,
                            'int_id' => $interview['interview_id'],
@@ -555,7 +555,7 @@ 
 // if no boxscans are attached
 $smarty->assign('numberscans', $imagenum_rows);
 
-$front=0;
+$front = 0;
 
 $game_boxscans_count = 0;
 
@@ -581,7 +581,7 @@ 
                 ."WHERE game_boxscan_cross=$rowimage[game_boxscan_id]"
             )
                 or die("Database error - selecting gamebox scan");
-            $couplerow        = $couple->fetch_row();
+            $couplerow = $couple->fetch_row();
 
             $back_image_filename = "$game_boxscan_save_path$rowimage[game_boxscan_id].$rowimage[imgext]";
             $back_image_pop_filename = "$game_boxscan_path$rowimage[game_boxscan_id].$rowimage[imgext]";
@@ -602,7 +602,7 @@ 
 
 // Get box scans for all release
 // This is temporary until we revamp the games/relase details page
-$nr_of_release_scans=0;
+$nr_of_release_scans = 0;
 
 $smarty->assign('release_scans', []);
 foreach ($releases as $release) {
@@ -647,7 +647,7 @@ 
     //(instead of a post with pure HTML) The translation of the 'enter' breaks is different in JS, so in JS I do
     //a conversion to a <br>. However, when we edit a comment, this <br> should not be
     //visible to the user, hence again, now this conversion in php
-    $breaks = array("<br />","<br>","<br/>");
+    $breaks = array("<br />", "<br>", "<br/>");
     $comment = str_ireplace($breaks, "\r\n", $comment);
 
     $date = date("d/m/y", $query_comment['timestamp']);
@@ -699,7 +699,7 @@ 
     $pos_end = strpos($review_text, '[/frontpage]');
     $nr_char = $pos_end - $pos_start;
 
-    $review_text  = substr($review_text, $pos_start, $nr_char);
+    $review_text = substr($review_text, $pos_start, $nr_char);
     $review_text = nl2br($review_text);
     $review_text = InsertALCode($review_text); // disabled this as it wrecked the design.
     $review_text = trim($review_text);
@@ -875,9 +875,9 @@ 
 
 //Send all smarty variables to the templates
 if (isset($use_new_layout)) {
-    $smarty->display("file:" . $mainsite_template_folder . "games/games_detail.new.html");
+    $smarty->display("file:".$mainsite_template_folder."games/games_detail.new.html");
 } else {
-    $smarty->display("file:" . $mainsite_template_folder . "games/games_detail.html");
+    $smarty->display("file:".$mainsite_template_folder."games/games_detail.html");
 }
 
 //close the connection

public/php/main/games/games_comment_main.php

Spacing +6 added lines, -6 removed lines

@@ -56,8 +56,8 @@ 
                 LEFT JOIN comments ON ( game_user_comments.comment_id = comments.comments_id )
                 LEFT JOIN users ON ( comments.user_id = users.user_id )
                 LEFT JOIN game ON ( game_user_comments.game_id = game.game_id )
-                 " . $where_clause . "
-                ORDER BY comments.timestamp DESC LIMIT  " . $v_counter . ", 5";
+                 " . $where_clause."
+                ORDER BY comments.timestamp DESC LIMIT  " . $v_counter.", 5";
 
 $sql_comment = $mysqli->query($sql_build);
 
@@ -135,7 +135,7 @@ 
     //(instead of a post with pure HTML) The translation of the 'enter' breaks is different in JS, so in JS I do
     //a conversion to a <br>. However, when we edit a comment, this <br> should not be
     //visible to the user, hence again, now this conversion in php
-    $breaks = array("<br />","<br>","<br/>");
+    $breaks = array("<br />", "<br>", "<br/>");
     $comment = str_ireplace($breaks, "\r\n", $comment);
 
     if ($query_comment['join_date'] == "") {
@@ -184,13 +184,13 @@ 
 //Check if back arrow is needed
 if ($v_counter > 0) {
     // Build the link
-    $v_linkback = ('?v_counter=' . ($v_counter - 5 . $users_comments));
+    $v_linkback = ('?v_counter='.($v_counter - 5.$users_comments));
 }
 
 //Check if we need to place a next arrow
 if ($v_rows > ($v_counter + 5)) {
     //Build the link
-    $v_linknext = ('?v_counter=' . ($v_counter + 5 . $users_comments));
+    $v_linknext = ('?v_counter='.($v_counter + 5.$users_comments));
 }
 
 if (empty($c_counter)) {
@@ -215,4 +215,4 @@ 
 );
 
 //Send all smarty variables to the templates
-$smarty->display("file:" . $mainsite_template_folder . "games/games_comment_main.html");
+$smarty->display("file:".$mainsite_template_folder."games/games_comment_main.html");

public/php/main/games/games_release_main.php

Spacing +3 added lines, -3 removed lines

@@ -60,7 +60,7 @@ 
         $desc[] = "in ".join(
             ", ",
             array_map(
-                function ($location) {
+                function($location) {
                     return $location->getName();
                 },
                 $release_locations
@@ -78,7 +78,7 @@ 
     }
 
     if (count($dumps) > 0) {
-        $items[] = count($dumps). " downloads";
+        $items[] = count($dumps)." downloads";
     }
 
     $description = join(" ", $desc);
@@ -135,4 +135,4 @@ 
     $dumps
 ));
 
-$smarty->display("file:" . $mainsite_template_folder. "games/games_release_main.html");
+$smarty->display("file:".$mainsite_template_folder."games/games_release_main.html");

public/php/main/games/games_main_list.php

Spacing +6 added lines, -6 removed lines

@@ -577,7 +577,7 @@ 
                                 )
                                 or die("Database error - selecting screenshots");
 
-                                while ($screenshot_result =  $sql_screenshots->fetch_array(MYSQLI_BOTH)) {
+                                while ($screenshot_result = $sql_screenshots->fetch_array(MYSQLI_BOTH)) {
                                     //Ready screenshots path and filename
                                     $screenshot_image = $game_boxscan_path;
                                     $screenshot_image .= $screenshot_result['game_boxscan_id'];
@@ -596,7 +596,7 @@ 
                                     ORDER BY RAND() LIMIT 1"
                                 ) or die("Database error - selecting screenshots");
 
-                                while ($screenshot_result =  $sql_screenshots->fetch_array(MYSQLI_BOTH)) {
+                                while ($screenshot_result = $sql_screenshots->fetch_array(MYSQLI_BOTH)) {
                                     //Ready screenshots path and filename
                                     $screenshot_image = $game_screenshot_path;
                                     $screenshot_image .= $screenshot_result['screenshot_id'];
@@ -651,19 +651,19 @@ 
                         header("Location: ../games/games_detail.php?game_id=$game_id_1_result");
                     }
 
-                    $rest4 = $i%4;
+                    $rest4 = $i % 4;
                     $smarty->assign("rest4", $rest4);
 
-                    $rest3 = $i%3;
+                    $rest3 = $i % 3;
                     $smarty->assign("rest3", $rest3);
 
-                    $rest2 = $i%2;
+                    $rest2 = $i % 2;
                     $smarty->assign("rest2", $rest2);
 
                     $smarty->assign("query_time", $time_elapsed_secs);
 
                     //Send all smarty variables to the templates
-                    $smarty->display("file:" . $mainsite_template_folder . "games/games_main_list.html");
+                    $smarty->display("file:".$mainsite_template_folder."games/games_main_list.html");
                 }
             } else {
                 $edit_message             = "No entries found for your selection";