Cyberbyte-Studios / CyberWorks

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

hooks/gangActive.php

Spacing +4 added lines, -4 removed lines

@@ -11,24 +11,24 @@
         if (isset($_SESSION['dbid'])) {
             $db_link = serverConnect($_SESSION['dbid']);
 
-            $sql = "SELECT `active` FROM `gangs` WHERE `id` = '" . $_POST['gang'] . "';";
+            $sql = "SELECT `active` FROM `gangs` WHERE `id` = '".$_POST['gang']."';";
             $result = $db_link->query($sql);
             if ($result->num_rows > 0) {
                 $active = $result->fetch_object();
                 if ($active == '1') {
                     $active = '0';
                     if ($settings['logging']) {
-                        logAction($_SESSION['user_name'], $lang['edited'] . ' ' . uIDname($_POST['player'], $db_link) . ' ' . $lang['gang'] . ' ' . $lang['deactive'], 1);
+                        logAction($_SESSION['user_name'], $lang['edited'].' '.uIDname($_POST['player'], $db_link).' '.$lang['gang'].' '.$lang['deactive'], 1);
                     }
                 } elseif ($active == '0') {
                     $active = '1';
                     if ($settings['logging']) {
-                        logAction($_SESSION['user_name'], $lang['edited'] . ' ' . uIDname($_POST['player'], $db_link) . ' ' . $lang['gang'] . ' ' . $lang['active'], 1);
+                        logAction($_SESSION['user_name'], $lang['edited'].' '.uIDname($_POST['player'], $db_link).' '.$lang['gang'].' '.$lang['active'], 1);
                     }
                 } else {
                     $active = '0';
                 }
-                $sql = "UPDATE `gangs` SET `active`='$active' WHERE `id` = '" . $_POST['gang'] . "';";
+                $sql = "UPDATE `gangs` SET `active`='$active' WHERE `id` = '".$_POST['gang']."';";
                 $db_link->query($sql);
             }
         }

gfunctions.php

Doc Comments +3 added lines

@@ -286,6 +286,9 @@
     return substr(str_shuffle('abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789'), 0, $length);
 }
 
+/**
+ * @param integer $type
+ */
 function stripArray($input, $type)
 {
     switch ($type) {

Spacing +17 added lines, -17 removed lines

@@ -174,12 +174,12 @@ 
     echo "<br><div class='row'><div class='col-lg-12'>";
     echo "<div class='alert alert-danger alert-dismissable'>";
     echo "<button type='button' class='close' data-dismiss='alert' aria-hidden='true'>&times;</button>";
-    echo "<i class='fa fa-info-circle'></i> " . $text . "</div></div></div>";
+    echo "<i class='fa fa-info-circle'></i> ".$text."</div></div></div>";
 }
 
 function error($errno, $errstr, $errfile, $errline)
 {
-    echo '<h4><b>PHP ERROR ' . $errno . '</b> ' . $errstr . ' - ' . $errfile . ':' . $errline . '</h4>';
+    echo '<h4><b>PHP ERROR '.$errno.'</b> '.$errstr.' - '.$errfile.':'.$errline.'</h4>';
 }
 
 /**
@@ -226,19 +226,19 @@ 
         case 37:
             return $lang['noLic']; //No License
         case 371:
-            return $lang['no'] . ' ' . $lang['civil'] . ' ' . $lang['licenses']; //No Civillian Licenses
+            return $lang['no'].' '.$lang['civil'].' '.$lang['licenses']; //No Civillian Licenses
         case 372:
-            return $lang['no'] . ' ' . $lang['medic'] . ' ' . $lang['licenses']; //No Medic Licenses
+            return $lang['no'].' '.$lang['medic'].' '.$lang['licenses']; //No Medic Licenses
         case 373:
-            return $lang['no'] . ' ' . $lang['police'] . ' ' . $lang['licenses']; //No Police Licenses
+            return $lang['no'].' '.$lang['police'].' '.$lang['licenses']; //No Police Licenses
         case 38:
-            return $lang['no'] . ' ' . $lang['gear']; //No License
+            return $lang['no'].' '.$lang['gear']; //No License
         case 381:
-            return $lang['no'] . ' ' . $lang['civil'] . ' ' . $lang['gear']; //No Civillian Licenses
+            return $lang['no'].' '.$lang['civil'].' '.$lang['gear']; //No Civillian Licenses
         case 382:
-            return $lang['no'] . ' ' . $lang['medic'] . ' ' . $lang['gear']; //No Medic Licenses
+            return $lang['no'].' '.$lang['medic'].' '.$lang['gear']; //No Medic Licenses
         case 383:
-            return $lang['no'] . ' ' . $lang['police'] . ' ' . $lang['gear']; //No Police Licenses
+            return $lang['no'].' '.$lang['police'].' '.$lang['gear']; //No Police Licenses
     }
 }
 
@@ -247,7 +247,7 @@ 
     $max = ceil($length / 40);
     $random = '';
     for ($i = 0; $i < $max; $i++) {
-        $random .= sha1(microtime(true) . mt_rand(10000, 90000));
+        $random .= sha1(microtime(true).mt_rand(10000, 90000));
     }
     return substr($random, 0, $length);
 }
@@ -256,7 +256,7 @@ 
 {
     $settings = require('config/settings.php');
     if (!empty($settings['steamAPI'])) {
-        $api = "http://api.steampowered.com/ISteamUser/GetPlayerBans/v1/?key=" . $settings['steamAPI'] . "&steamids=" . $PID;
+        $api = "http://api.steampowered.com/ISteamUser/GetPlayerBans/v1/?key=".$settings['steamAPI']."&steamids=".$PID;
         $bans = json_decode(file_get_contents($api), true);
         if ($bans['players']['0']['VACBanned']) {
             return '<h4><span class="label label-danger" style="margin-left:3px; line-height:2;">VAC BANNED</span></h4>';
@@ -356,14 +356,14 @@ 
     }
 }
 
-function getGravatar($email, $s = 80, $d = 'mm', $r = 'x', $img = false, $atts = array() ) {
+function getGravatar($email, $s = 80, $d = 'mm', $r = 'x', $img = false, $atts = array()) {
     $url = 'https://www.gravatar.com/avatar/';
-    $url .= md5( strtolower( trim( $email ) ) );
+    $url .= md5(strtolower(trim($email)));
     $url .= "?s=$s&d=$d&r=$r";
-    if ( $img ) {
-        $url = '<img src="' . $url . '"';
-        foreach ( $atts as $key => $val )
-            $url .= ' ' . $key . '="' . $val . '"';
+    if ($img) {
+        $url = '<img src="'.$url.'"';
+        foreach ($atts as $key => $val)
+            $url .= ' '.$key.'="'.$val.'"';
         $url .= ' />';
     }
     return $url;

Braces +3 added lines, -2 removed lines

@@ -362,8 +362,9 @@
     $url .= "?s=$s&d=$d&r=$r";
     if ( $img ) {
         $url = '<img src="' . $url . '"';
-        foreach ( $atts as $key => $val )
-            $url .= ' ' . $key . '="' . $val . '"';
+        foreach ( $atts as $key => $val ) {
+                    $url .= ' ' . $key . '="' . $val . '"';
+        }
         $url .= ' />';
     }
     return $url;

views/life/police.php

Spacing +14 added lines, -14 removed lines

@@ -1,15 +1,15 @@ 
 <?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 `uid` FROM `players` WHERE `uid` LIKE '$search' OR `name` LIKE '%$search%' OR $playerIdColumn LIKE '$search' AND `coplevel` >= '1' ORDER BY `coplevel` DESC;";
     $result_of_query = $db_link->query($sql);
     $total_records = mysqli_num_rows($result_of_query);
     if ($pageNum > $total_records) $pageNum = $total_records;
-    $sql = "SELECT `name`, `coplevel`, `uid`, $playerIdColumn as `playerid` FROM `players` WHERE `uid` LIKE '" . $search . "' OR `name` LIKE '%$search%' OR $playerIdColumn LIKE '$search' AND `coplevel` >= '1' ORDER BY `coplevel` DESC  $max;";
-    logAction($_SESSION['user_name'], $lang['searched'] . ' (' . $search . ') ' . $lang['in'] . ' ' . $lang['players'], 1);
+    $sql = "SELECT `name`, `coplevel`, `uid`, $playerIdColumn as `playerid` FROM `players` WHERE `uid` LIKE '".$search."' OR `name` LIKE '%$search%' OR $playerIdColumn LIKE '$search' AND `coplevel` >= '1' ORDER BY `coplevel` DESC  $max;";
+    logAction($_SESSION['user_name'], $lang['searched'].' ('.$search.') '.$lang['in'].' '.$lang['players'], 1);
 } else {
     $sql = "SELECT `uid` FROM `players` WHERE `coplevel` >= '1' ORDER BY `coplevel` DESC;";
     $result_of_query = $db_link->query($sql);
@@ -25,7 +25,7 @@ 
     }
     $pids = implode(',', $pids);
     if ($settings['steamAPI'] && $_SESSION['permissions']['view']['steam'] && !$settings['performance'] && $settings['vacTest']) {
-        $api = "http://api.steampowered.com/ISteamUser/GetPlayerBans/v1/?key=" . $settings['steamAPI'] . "&steamids=" . $pids;
+        $api = "http://api.steampowered.com/ISteamUser/GetPlayerBans/v1/?key=".$settings['steamAPI']."&steamids=".$pids;
         $bans = get_object_vars(json_decode(file_get_contents($api)));
         $bans = $bans['players'];
         $steamPlayers = count($bans);
@@ -53,7 +53,7 @@ 
                 <th><i class="fa fa-eye"></i><?php echo $lang['playerID']; ?></th>
                 <th><i class="fa fa-user"></i><?php echo $lang['rank']; ?></th>
                 <?php if ($_SESSION['permissions']['edit']['player']) {
-                    echo '<th><i class="fa fa-pencil"></i> ' . $lang['edit'] . '</th>';
+                    echo '<th><i class="fa fa-pencil"></i> '.$lang['edit'].'</th>';
                 }
                 ?>
             </tr>
@@ -63,26 +63,26 @@ 
             while ($row = mysqli_fetch_assoc($result_of_query)) {
                 $playersID = $row["playerid"];
                 echo "<tr>";
-                echo "<td>" . $row["name"] . "</td>";
-                echo "<td>" . $row["playerid"] . "</td>";
-                echo "<td class='hidden-xs'>" . $row["coplevel"] . "</td>";
+                echo "<td>".$row["name"]."</td>";
+                echo "<td>".$row["playerid"]."</td>";
+                echo "<td class='hidden-xs'>".$row["coplevel"]."</td>";
                 if ($_SESSION['permissions']['edit']['player']) {
-                    echo "<td><a class='btn btn-primary btn-xs' href='" . $settings['url'] . "editPlayer/" . $row["uid"] . "'>";
+                    echo "<td><a class='btn btn-primary btn-xs' href='".$settings['url']."editPlayer/".$row["uid"]."'>";
                     echo "<i class='fa fa-pencil'></i></a></td>";
                 } else {
-                    echo "<td><a class='btn btn-primary btn-xs' href='" . $settings['url'] . "editPlayer/" . $row["uid"] . "'>";
+                    echo "<td><a class='btn btn-primary btn-xs' href='".$settings['url']."editPlayer/".$row["uid"]."'>";
                     echo "<i class='fa fa-eye'></i></a></td>";
                 }
                 if ($_SESSION['permissions']['view']['steam'] && $steamPlayers > 0) {
-                    echo "<td><a href='http://steamcommunity.com/profiles/" . $row["playerid"] . "' ";
+                    echo "<td><a href='http://steamcommunity.com/profiles/".$row["playerid"]."' ";
                     for ($player = 0; $player <= $steamPlayers; $player++) {
                         if ($bans[$player]->SteamId == $row['playerid']) {
                             if ($bans[$player]->VACBanned == true) {
-                                echo "<td><a href='http://steamcommunity.com/profiles/" . $row["playerid"] . "' ";
+                                echo "<td><a href='http://steamcommunity.com/profiles/".$row["playerid"]."' ";
                                 echo "class='btn btn-danger btn-xs hidden-xs' target='_blank'><i class='fa fa-steam'></i></a>";
 
                             } else {
-                                echo "<td><a href='http://steamcommunity.com/profiles/" . $row["playerid"] . "' ";
+                                echo "<td><a href='http://steamcommunity.com/profiles/".$row["playerid"]."' ";
                                 echo "class='btn btn-primary btn-xs hidden-xs' target='_blank'><i class='fa fa-steam'></i></a>"; }
                         }
                     }
@@ -95,4 +95,4 @@ 
             ?>
     </div>
     <?php
-} else echo '<h3>' . errorMessage(36, $lang) . '</h3>';
+} else echo '<h3>'.errorMessage(36, $lang).'</h3>';

Braces +9 added lines, -3 removed lines

@@ -7,14 +7,18 @@ 
     $sql = "SELECT `uid` FROM `players` WHERE `uid` LIKE '$search' OR `name` LIKE '%$search%' OR $playerIdColumn LIKE '$search' AND `coplevel` >= '1' ORDER BY `coplevel` DESC;";
     $result_of_query = $db_link->query($sql);
     $total_records = mysqli_num_rows($result_of_query);
-    if ($pageNum > $total_records) $pageNum = $total_records;
+    if ($pageNum > $total_records) {
+        $pageNum = $total_records;
+    }
     $sql = "SELECT `name`, `coplevel`, `uid`, $playerIdColumn as `playerid` FROM `players` WHERE `uid` LIKE '" . $search . "' OR `name` LIKE '%$search%' OR $playerIdColumn LIKE '$search' AND `coplevel` >= '1' ORDER BY `coplevel` DESC  $max;";
     logAction($_SESSION['user_name'], $lang['searched'] . ' (' . $search . ') ' . $lang['in'] . ' ' . $lang['players'], 1);
 } else {
     $sql = "SELECT `uid` FROM `players` WHERE `coplevel` >= '1' ORDER BY `coplevel` DESC;";
     $result_of_query = $db_link->query($sql);
     $total_records = mysqli_num_rows($result_of_query);
-    if ($pageNum > $total_records) $pageNum = $total_records;
+    if ($pageNum > $total_records) {
+        $pageNum = $total_records;
+    }
     $sql = "SELECT `name`, `coplevel`, $playerIdColumn, `uid` FROM `players` WHERE `coplevel` >= '1' ORDER BY `coplevel` DESC $max ;";
 }
 
@@ -95,4 +99,6 @@ 
             ?>
     </div>
     <?php
-} else echo '<h3>' . errorMessage(36, $lang) . '</h3>';
+} else {
+    echo '<h3>' . errorMessage(36, $lang) . '</h3>';
+}