if (@mysqli_num_rows($Players_q) != 0) { echo ' <table class="prettytable"> <tr> <th width="5%" class="countheader">#</th> '; // player column pagination_headers('Player', $ServerID, 'leaders', '19', 'r', $rank, 'SoldierName', 'o', $order, 'ASC', $nextorder, $currentpage, '', '', ''); // score column pagination_headers('Score', $ServerID, 'leaders', '19', 'r', $rank, 'Score', 'o', $order, 'DESC', $nextorder, $currentpage, '', '', ''); // kills column pagination_headers('Kills', $ServerID, 'leaders', '19', 'r', $rank, 'Kills', 'o', $order, 'DESC', $nextorder, $currentpage, '', '', ''); // kdr column pagination_headers('Kill / Death', $ServerID, 'leaders', '19', 'r', $rank, 'KDR', 'o', $order, 'DESC', $nextorder, $currentpage, '', '', ''); // hsr column pagination_headers('Headshot / Kill', $ServerID, 'leaders', '19', 'r', $rank, 'HSR', 'o', $order, 'DESC', $nextorder, $currentpage, '', '', ''); echo ' </tr> </table> '; // while there are rows to be fetched... while ($Players_r = @mysqli_fetch_assoc($Players_q)) { $Score = $Players_r['Score']; $SoldierName = $Players_r['SoldierName']; $PlayerID = $Players_r['PlayerID']; $Kills = $Players_r['Kills']; $KDR = round($Players_r['KDR'], 2); $HSR = round($Players_r['HSR'] * 100, 2); $count++; $link = './index.php?'; if (!empty($ServerID)) {
$Suspicious_q = @mysqli_query($BF4stats, "\n\t\t\tSELECT tpd.`SoldierName`, SUM(tps.`Rounds`) AS Rounds, (SUM(tps.`Kills`)/SUM(tps.`Deaths`)) AS KDR, (SUM(tps.`Headshots`)/SUM(tps.`Kills`)) AS HSR, tpd.`PlayerID`\n\t\t\tFROM `tbl_playerstats` tps\n\t\t\tINNER JOIN `tbl_server_player` tsp ON tsp.`StatsID` = tps.`StatsID`\n\t\t\tINNER JOIN `tbl_playerdata` tpd ON tsp.`PlayerID` = tpd.`PlayerID`\n\t\t\tWHERE (((tps.`Kills`/tps.`Deaths`) > 5 AND (tps.`Headshots`/tps.`Kills`) > 0.70 AND tps.`Kills` > 30 AND tps.`Rounds` > 1) OR ((tps.`Kills`/tps.`Deaths`) > 10 AND tps.`Kills` > 50 AND tps.`Rounds` > 1))\n\t\t\tAND tpd.`GameID` = {$GameID}\n\t\t\tAND tsp.`ServerID` IN ({$valid_ids})\n\t\t\tGROUP BY tpd.`SoldierName`\n\t\t\tORDER BY {$rank} {$order}, tpd.`SoldierName` {$nextorder}\n\t\t\tLIMIT {$offset}, {$rowsperpage}\n\t\t"); } // start the table echo ' <table class="prettytable"> <tr> <th width="5%" class="countheader">#</th> '; // player column pagination_headers('Player', $ServerID, 'suspicious', '20', 'r', $rank, 'SoldierName', 'o', $order, 'ASC', $nextorder, $currentpage, '', '', ''); // kdr column pagination_headers('Kill / Death', $ServerID, 'suspicious', '20', 'r', $rank, 'KDR', 'o', $order, 'DESC', $nextorder, $currentpage, '', '', ''); // hsr column pagination_headers('Headshot / Kill', $ServerID, 'suspicious', '20', 'r', $rank, 'HSR', 'o', $order, 'DESC', $nextorder, $currentpage, '', '', ''); // rounds played column pagination_headers('Rounds Played', $ServerID, 'suspicious', '20', 'r', $rank, 'Rounds', 'o', $order, 'DESC', $nextorder, $currentpage, '', '', ''); echo ' </tr> </table> '; // offset pagination count when calculating the player's rank $count = $currentpage * 20 - 20; // while there are suspicious players, display them while ($Suspicious_r = @mysqli_fetch_assoc($Suspicious_q)) { $SoldierName = $Suspicious_r['SoldierName']; $PlayerID = $Suspicious_r['PlayerID']; $KDR = round($Suspicious_r['KDR'], 2); $HSpercent = round($Suspicious_r['HSR'] * 100, 2); $Rounds = $Suspicious_r['Rounds']; $count++; $link = './index.php?';
Here are some players with names similar to "' . $SoldierName . '". </div> </div> <br/><br/> <table class="prettytable"> <tr> <th width="5%" class="countheader">#</th> '; // player column pagination_headers('Player', $ServerID, 'player', '24', 'r', $rank, 'SoldierName', 'o', $order, 'ASC', $nextorder, $currentpage, '', $SoldierName, ''); // score column pagination_headers('Score', $ServerID, 'player', '24', 'r', $rank, 'Score', 'o', $order, 'DESC', $nextorder, $currentpage, '', $SoldierName, ''); // kills column pagination_headers('Kills', $ServerID, 'player', '24', 'r', $rank, 'Kills', 'o', $order, 'DESC', $nextorder, $currentpage, '', $SoldierName, ''); // kill / death column pagination_headers('Kill / Death', $ServerID, 'player', '24', 'r', $rank, 'KDR', 'o', $order, 'DESC', $nextorder, $currentpage, '', $SoldierName, ''); echo ' </tr> </table> '; // initialize value $count = 0; while ($PlayerMatch_r = @mysqli_fetch_assoc($PlayerMatch_q)) { $count++; $Soldier_Name = $PlayerMatch_r['SoldierName']; $Player_ID = $PlayerMatch_r['PlayerID']; $Score = $PlayerMatch_r['Score']; $Kills = $PlayerMatch_r['Kills']; $KDR = round($PlayerMatch_r['KDR'], 2); $link = './index.php?'; if (!empty($ServerID)) {
} // offset pagination count $count = $currentpage * 20 - 20; // check if chat rows were found if (@mysqli_num_rows($Messages_q) != 0) { echo ' <table class="prettytable" style="margin-top: -4px;"> <tr> <th width="5%" class="countheader">#</th> '; // date column pagination_headers('Date', $ServerID, 'chat', '15', 'r', $rank, 'logDate', 'o', $order, 'DESC', $nextorder, $currentpage, '', '', $query); // player column pagination_headers('Player', $ServerID, 'chat', '15', 'r', $rank, 'logSoldierName', 'o', $order, 'ASC', $nextorder, $currentpage, '', '', $query); // player column pagination_headers('Message', $ServerID, 'chat', '65', 'r', $rank, 'Message', 'o', $order, 'ASC', $nextorder, $currentpage, '', '', $query); echo ' </tr> </table> '; // while there are rows to be fetched... while ($Messages_r = @mysqli_fetch_assoc($Messages_q)) { // get data $logDate = date("H:i M j, Y", strtotime($Messages_r['logDate'])); $logSoldierName = textcleaner($Messages_r['logSoldierName']); $logMessage = textcleaner($Messages_r['Message']); $count++; // see if this player has server stats in this server yet // if there is a ServerID, this is a server stats page if (!empty($ServerID)) { $PlayerID_q = @mysqli_query($BF4stats, "\n\t\t\t\tSELECT tpd.`PlayerID`\n\t\t\t\tFROM `tbl_playerdata` tpd\n\t\t\t\tINNER JOIN `tbl_server_player` tsp ON tsp.`PlayerID` = tpd.`PlayerID`\n\t\t\t\tINNER JOIN `tbl_playerstats` tps ON tps.`StatsID` = tsp.`StatsID`\n\t\t\t\tWHERE tpd.`GameID` = {$GameID}\n\t\t\t\tAND tpd.`SoldierName` = '{$logSoldierName}'\n\t\t\t\tAND tsp.`ServerID` = {$ServerID}\n\t\t\t");
<td class="tablecontents" width="100%" colspan="3" style="text-align:left"><span class="teamname">' . $team_name . '</span></td> '; } else { echo ' <th width="4%" class="countheader">#</th> '; // player column pagination_headers('Player', $ServerID, 'home', '40', 'rank', $rank, 'SoldierName', 'order', $order, 'ASC', $nextorder, $currentpage, '2', '', ''); // score column pagination_headers('Score', $ServerID, 'home', '13', 'rank', $rank, 'Score', 'order', $order, 'DESC', $nextorder, $currentpage, '', '', ''); // kills column pagination_headers('Kills', $ServerID, 'home', '13', 'rank', $rank, 'Kills', 'order', $order, 'DESC', $nextorder, $currentpage, '', '', ''); // deaths column pagination_headers('Deaths', $ServerID, 'home', '13', 'rank', $rank, 'Deaths', 'order', $order, 'DESC', $nextorder, $currentpage, '', '', ''); // squad column pagination_headers('Squad', $ServerID, 'home', '17', 'rank', $rank, 'SquadID', 'order', $order, 'ASC', $nextorder, $currentpage, '', '', ''); } echo '</tr>'; // query for all players on this team $Team_q = @mysqli_query($BF4stats, "\n\t\t\t\tSELECT `Soldiername`, `Score`, `Kills`, `Deaths`, `TeamID`, `SquadID`, `CountryCode`\n\t\t\t\tFROM `tbl_currentplayers`\n\t\t\t\tWHERE `ServerID` = {$ServerID}\n\t\t\t\tAND `TeamID` = {$this_team}\n\t\t\t\tORDER BY {$rank} {$order}\n\t\t\t"); // if team query worked and players were found on this team if (@mysqli_num_rows($Team_q) != 0) { $count = 1; while ($Team_r = @mysqli_fetch_assoc($Team_q)) { $player = $Team_r['Soldiername']; // see if this player has server stats in this server yet $PlayerID_q = @mysqli_query($BF4stats, "\n\t\t\t\t\t\tSELECT tpd.`PlayerID`\n\t\t\t\t\t\tFROM `tbl_playerdata` tpd\n\t\t\t\t\t\tINNER JOIN `tbl_server_player` tsp ON tsp.`PlayerID` = tpd.`PlayerID`\n\t\t\t\t\t\tINNER JOIN `tbl_playerstats` tps ON tps.`StatsID` = tsp.`StatsID`\n\t\t\t\t\t\tWHERE tpd.`GameID` = {$GameID}\n\t\t\t\t\t\tAND tpd.`SoldierName` = '{$player}'\n\t\t\t\t\t\tAND tsp.`ServerID` = {$ServerID}\n\t\t\t\t\t"); // server stats found for this player in this server if (@mysqli_num_rows($PlayerID_q) == 1) { $PlayerID_r = @mysqli_fetch_assoc($PlayerID_q); $PlayerID = $PlayerID_r['PlayerID'];