//$GamesData[$c]["map"] = convEnt2(substr($row["map"], strripos($row["map"], '\\')+1));
//$GamesData[$c]["map"] = reset( explode(".w", $GamesData[$c]["map"] ) );
//$GamesData[$c]["map"] = substr($GamesData[$c]["map"],0,20);
$GamesData[$c]["datetime"] = $row["datetime"];
$GamesData[$c]["gamename"] = $row["gamename"];
$GamesData[$c]["ownername"] = $row["ownername"];
$GamesData[$c]["duration"] = $row["duration"];
$GamesData[$c]["creatorname"] = $row["creatorname"];
$GamesData[$c]["flag"] = $row["flag"];
if (isset($_GET["h"]) and file_exists("img/heroes/" . $_GET["h"] . ".gif")) {
$GamesData[$c]["hero_history"] = $_GET["h"] . "";
} else {
$GamesData[$c]["hero_history"] = "";
}
$GamesData[$c]["winner"] = $row["winner"];
$GamesData[$c]["type"] = OS_GetGameState($row["type"], $lang["gamestate_pub"], $lang["gamestate_priv"]);
$GamesData[$c]["gamestate"] = $row["type"];
if (isset($row["server"])) {
$GamesData[$c]["server"] = $row["server"];
}
if (isset($row["newcolour"])) {
$GamesData[$c]["newcolour"] = $row["newcolour"];
$GamesData[$c]["win"] = 0;
if ($row["newcolour"] <= 5 and $row["winner"] == 1) {
$GamesData[$c]["win"] = 1;
} else {
if ($row["newcolour"] > 5 and $row["winner"] == 1) {
$GamesData[$c]["win"] = 2;
} else {
if ($row["newcolour"] > 5 and $row["winner"] == 2) {
$GamesData[$c]["win"] = 1;
$sth = $db->prepare("SELECT g.gamename, g.id, g.map, g.datetime, g.duration, g.gamestate, dg.winner\n\tFROM " . OSDB_GAMES . " as g\n\tLEFT JOIN " . OSDB_GP . " as gp ON gp.gameid = g.id AND gp.name=:user1 \n\tLEFT JOIN " . OSDB_GP . " as gp2 ON gp2.gameid = gp.gameid AND gp2.name=:user2\n\tLEFT JOIN " . OSDB_DG . " as dg ON dg.gameid = g.id\n\tWHERE gp.name =:user1 AND gp2.name =:user2\n\tORDER BY g.id DESC\n\tLIMIT {$offset}, {$rowsperpage}");
$sth->bindValue(':user1', $User1, PDO::PARAM_STR);
$sth->bindValue(':user2', $User2, PDO::PARAM_STR);
$result = $sth->execute();
$CommonGames = array();
$c = 0;
while ($row = $sth->fetch(PDO::FETCH_ASSOC)) {
$CommonGames[$c]["gamename"] = $row["gamename"];
$CommonGames[$c]["id"] = $row["id"];
$CommonGames[$c]["map"] = $row["map"];
$CommonGames[$c]["datetime"] = $row["datetime"];
$CommonGames[$c]["duration"] = $row["duration"];
$CommonGames[$c]["gamestate"] = $row["gamestate"];
$CommonGames[$c]["player1"] = $User1;
$CommonGames[$c]["player2"] = $User2;
$CommonGames[$c]["type"] = OS_GetGameState($row["gamestate"], $lang["gamestate_pub"], $lang["gamestate_priv"]);
$CommonGames[$c]["winner"] = $row["winner"];
//REPLAY
$duration = secondsToTime($row["duration"]);
$replayDate = strtotime($row["datetime"]);
//3*3600 = +3 HOURS, +0 minutes.
$replayDate = date("Y-m-d H:i", $replayDate);
$gametimenew = substr(str_ireplace(":", "-", date("Y-m-d H:i", strtotime($replayDate))), 0, 16);
$gid = (int) $row["id"];
$gamename = $CommonGames[$c]["gamename"];
include 'inc/get_replay.php';
if (file_exists($replayloc)) {
$CommonGames[$c]["replay"] = $replayloc;
} else {
$CommonGames[$c]["replay"] = "";
}
} else {
?>
onclick="alert('You don\'t have permission to delete the game?')"<?php
}
?>
><img src="<?php
echo OS_HOME;
?>
adm/del.png" alt="img" /></a>
</td>
<td width="80" class="font12"><?php
echo secondsToTime($row["duration"]);
?>
</td>
<td width="40" class="font12"><?php
echo OS_GetGameState($row["type"]);
?>
</td>
<td width="140" class="font12"><?php
echo date($DateFormat, strtotime($row["datetime"]));
?>
</td>
<td width="150" class="font12"><?php
echo $row["creatorname"];
?>
</td>
<td width="80" class="font12"> <?php
echo $row["views"];
?>
</td>
</tr>
