<tr class="row"> <th class="padLeft" width="32">#</th> <th width="32">GameID</th> <th width="120" class="padLeft">Game Time</th> <th>Log Data</th> </tr> <?php require_once '../inc/live_games_functions.php'; while ($row = $sth->fetch(PDO::FETCH_ASSOC)) { $log_time = date(OS_DATE_FORMAT, strtotime($row["log_time"])); $log_data = OS_ParseGameLog($row["log_data"]); if (isset($_GET["show"]) and $_GET["show"] == "unparsed" or isset($_GET["sort"]) and $_GET["sort"] == "pm") { $log_data = str_replace("\n", "<br />", $row["log_data"]); $log_data = str_replace("\t", " ", $log_data); $log_data .= '<div><a href="javascript:;" onclick="showhide(\'g' . $row["id"] . '\')">[Show]</a></div>'; $log_data .= '<div id="g' . $row["id"] . '" style="display:none;">' . OS_ParseGameLog($row["log_data"]) . '</div>'; } $ID = $row["id"]; ?> <tr class="row"> <td><?php echo $ID; ?> </td> <td><?php echo $row["gameid"]; ?> </td> <td><?php echo $log_time; ?>
$sth2 = $db->prepare("SELECT * FROM `" . OSDB_GAMELOG . "` \n\tWHERE gameid = {$chatID} \n\tAND log_data LIKE ('%\tpl\t%')\n\tORDER BY id DESC, log_time DESC \n\tLIMIT 1"); $result = $sth2->execute(); $row2 = $sth2->fetch(PDO::FETCH_ASSOC); $PlayerListDataArray = array_reverse(explode("\n", $row2["log_data"])); } while ($row = $sth->fetch(PDO::FETCH_ASSOC)) { $log_time = date("d.m.Y, H:i:s", strtotime($row["log_time"])); //$log_type = $row["log_type"]; $log_data = $row["log_data"]; $ID = $row["id"]; //Reverse array to sort new logs on top $DataArray = array_reverse(explode("\n", $log_data)); if (!isset($PlayerListDataArray)) { $PlayerListDataArray = $DataArray; } echo OS_ParseGameLog($log_data); } ?> |split|<?php echo $ID; ?> |split|<?php echo OS_GetPlayerList($PlayerListDataArray, $chatID, $lastID, $click); } else { if (isset($_POST["winchance"]) and is_numeric($_POST["winchance"])) { //WINCHANCE $gameid = (int) $_POST["winchance"]; if (file_exists("inc/geoip/geoip.inc")) { include "inc/geoip/geoip.inc"; $GeoIPDatabase = geoip_open("inc/geoip/GeoIP.dat", GEOIP_STANDARD); $GeoIP = 1;