Cyberbyte-Studios / CyberWorks

views/core/logs.php

Spacing +13 added lines, -13 removed lines

@@ -1,16 +1,16 @@ 
 <?php
 $db_link = serverConnect();
 
-$max = 'LIMIT ' . ($pageNum - 1) * $_SESSION['items'] . ',' . $_SESSION['items'];
+$max = 'LIMIT '.($pageNum - 1) * $_SESSION['items'].','.$_SESSION['items'];
 
 if (isset($search)) {
-    $sql = "SELECT count(`logid`) FROM `logs` WHERE `logid` LIKE '" . $search . "' OR `user` LIKE '%" . $search . "%' OR `action` LIKE '%" . $search . "%' OR `level` LIKE '" . $search . "';";
+    $sql = "SELECT count(`logid`) FROM `logs` WHERE `logid` LIKE '".$search."' OR `user` LIKE '%".$search."%' OR `action` LIKE '%".$search."%' OR `level` LIKE '".$search."';";
     $total_records = $db_link->query($sql);
     if ($pageNum > $total_records) {
         $pageNum = $total_records;
     }
-    $sql = "SELECT `logid`,`date_time`,`user`,`action`,`level` FROM `logs` WHERE `logid` LIKE '" . $search . "' OR `user` LIKE '%" . $search . "%' OR `action` LIKE '%" . $search . "%' OR `level` LIKE '" . $search . "' ORDER BY `logid` DESC " . $max . " ;";
-    logAction($_SESSION['user_name'], $lang['searched'] . ' (' . $search . ') ' . $lang['in'] . ' ' . $lang['logs'], 2);
+    $sql = "SELECT `logid`,`date_time`,`user`,`action`,`level` FROM `logs` WHERE `logid` LIKE '".$search."' OR `user` LIKE '%".$search."%' OR `action` LIKE '%".$search."%' OR `level` LIKE '".$search."' ORDER BY `logid` DESC ".$max." ;";
+    logAction($_SESSION['user_name'], $lang['searched'].' ('.$search.') '.$lang['in'].' '.$lang['logs'], 2);
 } else {
     $sql = "SELECT `logid` FROM `logs`;";
     $result_of_query = $db_link->query($sql);
@@ -18,7 +18,7 @@ 
     if ($pageNum > $total_records) {
         $pageNum = $total_records;
     }
-    $sql = "SELECT `logid`,`date_time`,`user`,`action`,`level` FROM `logs` ORDER BY `logid` DESC " . $max . " ;";
+    $sql = "SELECT `logid`,`date_time`,`user`,`action`,`level` FROM `logs` ORDER BY `logid` DESC ".$max." ;";
 }
 $result_of_query = $db_connection->query($sql);
 if ($result_of_query->num_rows > 0) {
@@ -28,7 +28,7 @@ 
         <div class="col-lg-12">
             <h1 class="page-header">
                 <?php echo $lang['logs']; ?>
-                <small><?php echo " " . $lang['overview']; ?></small>
+                <small><?php echo " ".$lang['overview']; ?></small>
             </h1>
         </div>
     </div>
@@ -37,7 +37,7 @@ 
         <div class="content-panel">
             <h4>
                 <i class="fa fa-edit"></i>
-                <?php echo " " . $lang['logs'];
+                <?php echo " ".$lang['logs'];
                 include("views/templates/search.php"); ?>
             </h4>
             <hr class="hidden-xs">
@@ -45,7 +45,7 @@ 
                 <thead>
                 <tr>
                     <th class="hidden-xs"><i
-                            class="fa fa-pencil-square-o"></i> <?php echo $lang['log'] . ' ' . $lang['id'] ?>
+                            class="fa fa-pencil-square-o"></i> <?php echo $lang['log'].' '.$lang['id'] ?>
                     </th>
                     <th class="hidden-xs"><i class="fa fa-calendar"></i>  <?php echo $lang['time']; ?></th>
                     <th class="hidden-xs"><i class="fa fa-user"></i> <?php echo $lang['user']; ?></th>
@@ -57,11 +57,11 @@ 
                 <?php
                 while ($row = mysqli_fetch_assoc($result_of_query)) {
                     echo "<tr>";
-                    echo "<td class='hidden-xs'>" . $row["logid"] . "</td>";
-                    echo "<td class='hidden-xs'>" . $row["date_time"] . "</td>";
-                    echo "<td class='hidden-xs'>" . $row["user"] . "</td>";
-                    echo "<td>" . $row["action"] . "</td>";
-                    echo "<td class='hidden-xs'>" . $row["level"] . "</td>";
+                    echo "<td class='hidden-xs'>".$row["logid"]."</td>";
+                    echo "<td class='hidden-xs'>".$row["date_time"]."</td>";
+                    echo "<td class='hidden-xs'>".$row["user"]."</td>";
+                    echo "<td>".$row["action"]."</td>";
+                    echo "<td class='hidden-xs'>".$row["level"]."</td>";
                     echo "</tr>";
                 };
                 echo "</tbody></table>";

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