Cyberbyte-Studios / CyberWorks

views/core/curPlayers.php

Spacing +4 added lines, -4 removed lines

@@ -1,12 +1,12 @@ 
 <?php
-$sql = "SELECT `sid` FROM `servers` WHERE `use_sq` = 1 AND `sid` = " . $sid . ";";
+$sql = "SELECT `sid` FROM `servers` WHERE `use_sq` = 1 AND `sid` = ".$sid.";";
 $result_of_query = $db_connection->query($sql);
 if ($result_of_query->num_rows == 1) { ?>
 <div class="row">
     <div class="col-lg-12">
         <h1 class="page-header">
             <?php echo $lang['players']; ?>
-            <small><?php echo " " . $lang['overview']; ?></small>
+            <small><?php echo " ".$lang['overview']; ?></small>
         </h1>
     </div>
 </div>
@@ -27,7 +27,7 @@ 
 }
 function getPlayers() {
     $.ajax({
-        url: "<?php echo $settings['url'] . 'hooks/rcon_players.php?sid=' . $sid ?>",
+        url: "<?php echo $settings['url'].'hooks/rcon_players.php?sid='.$sid ?>",
         dataType: 'json',
         complete: function(data) {
             console.log(data);
@@ -53,7 +53,7 @@ 
 	<div class="content-panel">
 		<table class="table table-striped table-advance table-hover">
 			<h4>
-				<i class="fa fa-child fa-fw"></i><?php echo " " . $lang['players']; ?>
+				<i class="fa fa-child fa-fw"></i><?php echo " ".$lang['players']; ?>
 				<div style="float:right; padding-right: 20px;" id="count"></div>
 			</h4>
 			<hr>

classes/csrf.php

Spacing +1 added lines, -1 removed lines

@@ -16,7 +16,7 @@
      */
     public static function getField()
     {
-        return "<input name='token' value='" . $_SESSION['formtoken'][0] . "' type='hidden' />";
+        return "<input name='token' value='".$_SESSION['formtoken'][0]."' type='hidden' />";
     }
 
         /**

classes/update.php

Spacing +3 added lines, -3 removed lines

@@ -6,7 +6,7 @@ 
     $lang = array('English', 'en');
     array_push($settings['installedLanguage'], $lang);
     $settings['version'] = 0.3;
-    file_put_contents('config/settings.php', '<?php return ' . var_export($settings, true) . ';');
+    file_put_contents('config/settings.php', '<?php return '.var_export($settings, true).';');
     $updated = true;
 }
 if ($settings['version'] < 0.4) {
@@ -17,8 +17,8 @@ 
     $settings['2factor'] = true;
     $settings['force2factor'] = 'none';
     $settings['version'] = 0.4;
-    $settings['item'] = array(5,10,15,25,50);
-    file_put_contents('config/settings.php', '<?php return ' . var_export($settings, true) . ';');
+    $settings['item'] = array(5, 10, 15, 25, 50);
+    file_put_contents('config/settings.php', '<?php return '.var_export($settings, true).';');
     $updated = true;
 }
 if (isset($updated)) {

classes/GuestReg.php

Spacing +2 added lines, -2 removed lines

@@ -95,7 +95,7 @@ 
                 $user_password_hash = password_hash($user_password, PASSWORD_DEFAULT);
 
                 // check if user or email address already exists
-                $sql = "SELECT * FROM `users` WHERE `user_name` = '" . $user_name . "' OR `user_email = '" . $user_email . "';";
+                $sql = "SELECT * FROM `users` WHERE `user_name` = '".$user_name."' OR `user_email = '".$user_email."';";
                 $query_check_user_name = $this->db_connection->query($sql);
 
                 if ($query_check_user_name->num_rows == 1) {
@@ -108,7 +108,7 @@ 
 
                     // write new user's data into database
                         $sql = "INSERT INTO `users` (`user_name`, `user_password_hash`, `user_email`, `playerid`, `user_level`, `permissions`, `user_profile`) VALUES
-                    ('" . $user_name . "', '" . $user_password_hash . "', '" . $user_email . "', '" . $_SESSION['playerid'] . "', '1', '" . $userPerms . "', '1');";
+                    ('" . $user_name."', '".$user_password_hash."', '".$user_email."', '".$_SESSION['playerid']."', '1', '".$userPerms."', '1');";
 
                     $query_new_user_insert = $this->db_connection->query($sql);
 

validators/newUser.php

Spacing +2 added lines, -2 removed lines

@@ -13,7 +13,7 @@ 
         case 'email':
             if (isset($_POST['user_email'])) {
                 $email = $_POST['user_email'];
-                $sql = "SELECT `user_id` FROM `users` WHERE `user_email` = '" . $email . "';";
+                $sql = "SELECT `user_id` FROM `users` WHERE `user_email` = '".$email."';";
                 $result_of_query = $db_connection->query($sql);
                 if (mysqli_num_rows($result_of_query) == 1) {
                     $isAvailable = false;
@@ -27,7 +27,7 @@ 
         case 'username':
             if (isset($_POST['user_name'])) {
                 $username = $_POST['user_name'];
-                $sql = "SELECT `user_id` FROM `users` WHERE `user_name` = '" . $username . "';";
+                $sql = "SELECT `user_id` FROM `users` WHERE `user_name` = '".$username."';";
                 $result_of_query = $db_connection->query($sql);
                 if (mysqli_num_rows($result_of_query) == 1) {
                     $isAvailable = false;

validators/newServer.php

Spacing +1 added lines, -1 removed lines

@@ -12,7 +12,7 @@
     switch ($_POST['type']) {
         case 'username':
             $username = clean($_POST['server_name'], 'string');
-            $sql = "SELECT `name` FROM `servers` WHERE `name` = '" . $username . "'";
+            $sql = "SELECT `name` FROM `servers` WHERE `name` = '".$username."'";
             $result_of_query = $db_connection->query($sql);
             if (mysqli_num_rows($result_of_query) == 1) {
                 $isAvailable = false;

validators/pass.php

Spacing +1 added lines, -1 removed lines

@@ -8,7 +8,7 @@
     if (isset($_POST['current_password'])) {
         $db_connection = masterConnect();
         $isAvailable = false;
-        $sql = "SELECT `user_password_hash` FROM `users` WHERE `user_name` = '" . $_SESSION['user_name'] . "' ";
+        $sql = "SELECT `user_password_hash` FROM `users` WHERE `user_name` = '".$_SESSION['user_name']."' ";
         $user = $db_connection->query($sql)->fetch_object();
         if (password_verify($_POST['current_password'], $user->user_password_hash)) {
             $isAvailable = true;

hooks/license.php

Spacing +9 added lines, -9 removed lines

@@ -3,31 +3,31 @@
 session_set_cookie_params(1209600);
 session_start();
 
-include_once( __DIR__ . '/../config/english.php');
+include_once(__DIR__.'/../config/english.php');
 
 if (isset($_SESSION['permissions']['edit']['licences'])) {
     if ($_SESSION['permissions']['edit']['licences'] && isset($_POST['player']) && isset($_POST['id'])) {
-        require_once( __DIR__ . '/../gfunctions.php');
-        require_once( __DIR__ . '/../config/license.php');
-        $settings = require( __DIR__ . '/../config/settings.php');
+        require_once(__DIR__.'/../gfunctions.php');
+        require_once(__DIR__.'/../config/license.php');
+        $settings = require(__DIR__.'/../config/settings.php');
         if (isset($_SESSION['dbid'])) {
             $db_link = serverConnect($_SESSION['dbid']);
     
             $change = explode("_", $_POST['id']);
-            $col = $change['1'] . "_licenses";
-            $sql = "SELECT `" . $col . "` FROM `players` WHERE `uid` = '" . $_POST['player'] . "';"; //todo: innerjoin
+            $col = $change['1']."_licenses";
+            $sql = "SELECT `".$col."` FROM `players` WHERE `uid` = '".$_POST['player']."';"; //todo: innerjoin
             $result = $db_link->query($sql);
             if ($result->num_rows > 0) {
                 $lic = $result->fetch_object()->$col;
                 $num = strpos($lic, $change['2']) + strlen($change['2']) + 2;
                 if ($lic[$num] == '1') {
                     $lic[$num] = '0';
-                    logAction($_SESSION['user_name'], $lang['removed'] . ' ' . uIDname($_POST['player'], $db_link) . ' ' . $lang['licenses'] . ' (has removed ' . licName($_POST['id'], $license) . ')', 2);
+                    logAction($_SESSION['user_name'], $lang['removed'].' '.uIDname($_POST['player'], $db_link).' '.$lang['licenses'].' (has removed '.licName($_POST['id'], $license).')', 2);
                 } elseif ($lic[$num] == '0') {
                     $lic[$num] = '1';
-                    logAction($_SESSION['user_name'], $lang['added'] . ' ' . uIDname($_POST['player'], $db_link) . ' ' . $lang['licenses'] . ' (has added ' . licName($_POST['id'], $license) . ')', 2);
+                    logAction($_SESSION['user_name'], $lang['added'].' '.uIDname($_POST['player'], $db_link).' '.$lang['licenses'].' (has added '.licName($_POST['id'], $license).')', 2);
                 }
-                $sql = "UPDATE `players` SET `" . $col . "`='$lic' WHERE `uid` = '" . $_POST['player'] . "';";
+                $sql = "UPDATE `players` SET `".$col."`='$lic' WHERE `uid` = '".$_POST['player']."';";
                 $db_link->query($sql);
             }
         }

hooks/arrest.php

Spacing +6 added lines, -6 removed lines

@@ -11,26 +11,26 @@
             $db_link = serverConnect($_SESSION['dbid']);
 
             if ($_POST['id'] == 'arrested') {
-                $sql = "SELECT `arrested` FROM `players` WHERE `uid` = '" . $_POST['player'] . "';";
+                $sql = "SELECT `arrested` FROM `players` WHERE `uid` = '".$_POST['player']."';";
                 $result = $db_link->query($sql);
                 if ($result->num_rows > 0) {
                     $switch = $result->fetch_object();
                     if ($switch->arrested == '1') {
-                        $sql = "UPDATE `players` SET `arrested`='0' WHERE `uid` = '" . $_POST['player'] . "';";
+                        $sql = "UPDATE `players` SET `arrested`='0' WHERE `uid` = '".$_POST['player']."';";
                     } elseif ($switch->arrested == '0') {
-                        $sql = "UPDATE `players` SET `arrested`='1' WHERE `uid` = '" . $_POST['player'] . "';";
+                        $sql = "UPDATE `players` SET `arrested`='1' WHERE `uid` = '".$_POST['player']."';";
                     }
                     $db_link->query($sql);
                 }
             } elseif ($_POST['id'] == 'blacklist') {
-                $sql = "SELECT `blacklist` FROM `players` WHERE `uid` = '" . $_POST['player'] . "';";
+                $sql = "SELECT `blacklist` FROM `players` WHERE `uid` = '".$_POST['player']."';";
                 $result = $db_link->query($sql);
                 if ($result->num_rows > 0) {
                     $switch = $result->fetch_object();
                     if ($switch->blacklist == '1') {
-                        $sql = "UPDATE `players` SET `blacklist`='0' WHERE `uid` = '" . $_POST['player'] . "';";
+                        $sql = "UPDATE `players` SET `blacklist`='0' WHERE `uid` = '".$_POST['player']."';";
                     } elseif ($switch->blacklist == '0') {
-                        $sql = "UPDATE `players` SET `blacklist`='1' WHERE `uid` = '" . $_POST['player'] . "';";
+                        $sql = "UPDATE `players` SET `blacklist`='1' WHERE `uid` = '".$_POST['player']."';";
                     }
                     $db_link->query($sql);
                 }