atari-legend / legacy

public/php/common/DAO/ControlDAO.php

Indentation +11 added lines, -11 removed lines

@@ -104,11 +104,11 @@ 
         $stmt->close();
     }
     
-     /**
-     * add a control to the database
-     *
-     * @param varchar control
-     */
+        /**
+         * add a control to the database
+         *
+         * @param varchar control
+         */
     public function addControl($control) {
         $stmt = \AL\Db\execute_query(
             "ControlDAO: addControl",
@@ -136,12 +136,12 @@ 
         $stmt->close();
     }
     
-     /**
-     * update a control
-     *
-     * @param int control_id
-     * @param varchar control_name
-     */
+        /**
+         * update a control
+         *
+         * @param int control_id
+         * @param varchar control_name
+         */
     public function updateControl($control_id, $control_name) {
         $stmt = \AL\Db\execute_query(
             "ControlDAO: updateControl",

Spacing +2 added lines, -2 removed lines

@@ -1,8 +1,8 @@
 <?php
 namespace AL\Common\DAO;
 
-require_once __DIR__."/../../lib/Db.php" ;
-require_once __DIR__."/../Model/Game/Control.php" ;
+require_once __DIR__."/../../lib/Db.php";
+require_once __DIR__."/../Model/Game/Control.php";
 
 /**
  * DAO for game controls

public/php/common/login/user_process_logout.php

Spacing +2 added lines, -2 removed lines

@@ -27,7 +27,7 @@ 
 //$params = session_get_cookie_params();
 
 // Delete the actual cookie.
-setcookie("cooksession", session_id(), time()-60*60*24*100, "/");
+setcookie("cooksession", session_id(), time() - 60 * 60 * 24 * 100, "/");
 
 // Destroy session
 session_destroy();
@@ -37,7 +37,7 @@ 
     header('Location: ../../main/front/front.php');
 } else {
     $_SESSION['edit_message'] = "Log out succesfull";
-    header('Location: ' . $_SERVER['HTTP_REFERER']);
+    header('Location: '.$_SERVER['HTTP_REFERER']);
 }
 
 mysql_close();

public/php/common/login/db_reset.php

Spacing +15 added lines, -15 removed lines

@@ -18,8 +18,8 @@ 
 
 include("../../config/common.php");
 
-require_once __DIR__."/../../common/Model/Database/ChangeLog.php" ;
-require_once __DIR__."/../../common/DAO/ChangeLogDAO.php" ;
+require_once __DIR__."/../../common/Model/Database/ChangeLog.php";
+require_once __DIR__."/../../common/DAO/ChangeLogDAO.php";
 
 use PHPMailer\PHPMailer\PHPMailer;
 
@@ -35,7 +35,7 @@ 
     } else {
         //check if the email addres is valid
         if (!filter_var($_POST["email"], FILTER_VALIDATE_EMAIL)) {
-            $_SESSION['edit_message'] =  "Invalid email format";
+            $_SESSION['edit_message'] = "Invalid email format";
             header("Location: ../../main/front/front.php?action=reset");
         } else {
             //check if email address exists in DB
@@ -43,7 +43,7 @@ 
             $number = $query_rows->num_rows;
 
             if ($number == 0) {
-                $_SESSION['edit_message'] =  "There is no user with this email address in our DB - "
+                $_SESSION['edit_message'] = "There is no user with this email address in our DB - "
                     ."Please contact the admins";
                 header("Location: ../../main/front/front.php?action=reset");
             } else { //lets create an email
@@ -100,9 +100,9 @@ 
                 $mailbody = "Dear user,\n\nIf this e-mail does not apply to you please ignore it. It appears that "
                     ."you have requested a password reset at our website www.atarilegend.com\n\nTo reset your password,"
                     ." please click the link below. If you cannot click it, please paste it into your web browser's "
-                    ."address bar.\n\n" . $pwrurl . "\n\nThanks,\nTEAM AL";
+                    ."address bar.\n\n".$pwrurl."\n\nThanks,\nTEAM AL";
 
-                $mail->Body    = $mailbody;
+                $mail->Body = $mailbody;
 
                 try {
                     $mail->send();
@@ -130,7 +130,7 @@ 
 
     //check if the email addres is valid
     if (!filter_var($_POST["email"], FILTER_VALIDATE_EMAIL)) {
-        $_SESSION['edit_message'] =  "Invalid email format";
+        $_SESSION['edit_message'] = "Invalid email format";
         header("Location: ../../main/front/front.php?action=new_pwd&q=$hash");
     } else {
         //check if email address exists in DB
@@ -138,12 +138,12 @@ 
         $number = $query_rows->num_rows;
 
         if ($number == 0) {
-            $_SESSION['edit_message'] =  "There is no user with this email address in our DB - "
+            $_SESSION['edit_message'] = "There is no user with this email address in our DB - "
                 ."Please contact the admins";
             header("Location: ../../main/front/front.php?action=new_pwd&q=$hash");
         } else {
             if ($password != $confirmpassword) {
-                $_SESSION['edit_message'] =  "The passwords you entered are not the same - please try again";
+                $_SESSION['edit_message'] = "The passwords you entered are not the same - please try again";
                 header("Location: ../../main/front/front.php?action=new_pwd&q=$hash");
             } else {
                 //get the userid
@@ -157,13 +157,13 @@ 
                 // Does the new reset key match the old one?
                 if ($resetkey == $hash) {
                     //now check if this hash exists
-                    $twentyfour_hours = time()-(60*1440);
+                    $twentyfour_hours = time() - (60 * 1440);
                     $query_time = $mysqli->query("select * from users_reset where password = '$resetkey'")
                         or die("problem getting time from the users_reset table");
                     $number_hash = $query_time->num_rows;
 
                     if ($number_hash == 0) {
-                        $_SESSION['edit_message'] =  "Something went wrong - validation not possible, contact the "
+                        $_SESSION['edit_message'] = "Something went wrong - validation not possible, contact the "
                             ."admins or try a new password request";
                         header("Location: ../../main/front/front.php");
                     } else {
@@ -176,8 +176,8 @@ 
                             $random_salt = hash(
                                 'sha512',
                                 uniqid(mt_rand(1, mt_getrandmax()), true)
-                            );//create random salt
-                            $update_password = hash('sha512', $sha512 . $random_salt); // Create salted password
+                            ); //create random salt
+                            $update_password = hash('sha512', $sha512.$random_salt); // Create salted password
                             $timestamp = time();
 
                             $sdbquery = $mysqli->query("UPDATE users SET password = '$md5pass',
@@ -213,7 +213,7 @@ 
                                 header("Location: ../../main/front/front.php");
                             }
                         } else {
-                            $_SESSION['edit_message'] =  "Something went wrong - hash password request expired, try a "
+                            $_SESSION['edit_message'] = "Something went wrong - hash password request expired, try a "
                                 ."new password request";
 
                             //delete the hash from the user_reset table so a new reset can be done
@@ -224,7 +224,7 @@ 
                         }
                     }
                 } else {
-                    $_SESSION['edit_message'] =  "Something went wrong - Did you enter the correct email addres?";
+                    $_SESSION['edit_message'] = "Something went wrong - Did you enter the correct email addres?";
                     header("Location: ../../main/front/front.php?action=new_pwd&q=$hash");
                 }
             }

public/php/common/login/user_process_login.php

Spacing +5 added lines, -5 removed lines

@@ -46,7 +46,7 @@ 
             //$params = session_get_cookie_params();
 
             // Delete the actual cookie.
-            setcookie("cooksession", session_id(), time()+60*60*24*100, "/");
+            setcookie("cooksession", session_id(), time() + 60 * 60 * 24 * 100, "/");
             $session_id = session_id();
 
             //update the table with the session id
@@ -56,7 +56,7 @@ 
         }
         //header('Location: ../../main/front/front.php');
         $_SESSION['edit_message'] = "Login successful";
-        header('Location: ' . $_SERVER['HTTP_REFERER']);
+        header('Location: '.$_SERVER['HTTP_REFERER']);
     } else {
         // Login failed
         // check the cause - is the user inactive?
@@ -65,10 +65,10 @@ 
         if ($query_inactive['inactive'] == 1) {
             //header('Location: ../../main/front/front.php?error=2');
             $_SESSION['edit_message'] = 'User is set inactive - contact admin';
-            header('Location: ' . $_SERVER['HTTP_REFERER']);
+            header('Location: '.$_SERVER['HTTP_REFERER']);
         } else {
             $_SESSION['edit_message'] = 'Usn or pwd incorrect - Please try again';
-            header('Location: ' . $_SERVER['HTTP_REFERER']);
+            header('Location: '.$_SERVER['HTTP_REFERER']);
             //header('Location: ../../main/front/front.php?error=1');
         }
     }
@@ -76,5 +76,5 @@ 
     // The correct POST variables were not sent to this page.
     //header('Location: ../../main/front/front.php?error=1');
     $_SESSION['edit_message'] = 'Usn or pwd incorrect - Please try again';
-    header('Location: ' . $_SERVER['HTTP_REFERER']);
+    header('Location: '.$_SERVER['HTTP_REFERER']);
 }

public/php/common/login/db_register.php

Spacing +8 added lines, -8 removed lines

@@ -18,8 +18,8 @@ 
 //load all common functions
 include("../../config/common.php");
 
-require_once __DIR__."/../../common/Model/Database/ChangeLog.php" ;
-require_once __DIR__."/../../common/DAO/ChangeLogDAO.php" ;
+require_once __DIR__."/../../common/Model/Database/ChangeLog.php";
+require_once __DIR__."/../../common/DAO/ChangeLogDAO.php";
 
 use PHPMailer\PHPMailer\PHPMailer;
 
@@ -36,7 +36,7 @@ 
         $query_user = $mysqli->query("SELECT * FROM users WHERE userid='$_GET[usn]'
             AND password='$_GET[pwd]'
             AND inactive='1'") or die(mysql_error());
-        $match  = $query_user->num_rows;
+        $match = $query_user->num_rows;
 
         if ($match > 0) {
             $query_update_user = $mysqli->query("UPDATE users SET inactive = '0' WHERE userid = '$_GET[usn]'")
@@ -84,7 +84,7 @@ 
                     } else {
                         //check if the email addres is valid
                         if (!filter_var($_POST["email"], FILTER_VALIDATE_EMAIL)) {
-                            $_SESSION['edit_message'] =  "Invalid email format";
+                            $_SESSION['edit_message'] = "Invalid email format";
                             header("Location: ../../main/front/front.php?action=register");
                         } else {
                             //check if the email already exists
@@ -92,7 +92,7 @@ 
                             $number = $query_rows->num_rows;
 
                             if ($number > 0) {
-                                $_SESSION['edit_message'] =  "Email address already exists in database!";
+                                $_SESSION['edit_message'] = "Email address already exists in database!";
                                 header("Location: ../../main/front/front.php?action=register");
                             } else {
                                 //Add the new account to the database but make it inactive for now
@@ -103,7 +103,7 @@ 
                                     'sha512',
                                     uniqid(mt_rand(1, mt_getrandmax()), true)
                                 ); //create random salt
-                                $update_password = hash('sha512', $sha512 . $random_salt); // Create salted password
+                                $update_password = hash('sha512', $sha512.$random_salt); // Create salted password
                                 $timestamp = time();
 
                                 $sdbquery = $mysqli->query("INSERT INTO users (
@@ -156,9 +156,9 @@ 
                                 "Dear user,\n\nIf this e-mail does not apply to you please ignore it. "
                                 ."Please activate your account at www.atarilegend.com\n\nby clicking the link below. "
                                 ."If you cannot click it, please paste it into your web browser's address bar.\n\n"
-                                . $pwrurl . "\n\nThanks,\nTEAM AL";
+                                . $pwrurl."\n\nThanks,\nTEAM AL";
 
-                                $mail->Body    = $mailbody;
+                                $mail->Body = $mailbody;
 
                                 try {
                                     $mail->send();

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");
 }