function showLatestTopics()
{
require './variables.php';
$forum_exclude = "(12, 15, 97)";
//admin and mod forums
$PREFIX = "phpbb3_";
$TOPICS_TABLE = $PREFIX . "topics";
$FORUMS_TABLE = $PREFIX . "forums";
$POSTS_TABLE = $PREFIX . "posts";
$USERS_TABLE = $PREFIX . "users";
$forum_path = "/forum/";
$topics = 10;
$sql_topics = "SELECT topic from " . $topicstable . " where active ='Y' ORDER BY prio DESC";
$result = mysql_query($sql_topics);
$in_topics = "";
$not_in_topics = "";
$num = mysql_num_rows($result);
$count = 0;
$topicsExclude = "";
$inline = "";
if ($num > 0) {
$inline = "";
while ($row = mysql_fetch_array($result)) {
$count++;
$inline .= $row[0];
if ($count < $num) {
$inline .= ", ";
}
}
$in_topics = " AND t.topic_id in (" . $inline . ") ";
$sql_sticky = "SELECT t.forum_id, t.topic_id, t.topic_last_post_id, t.topic_title, p.post_text, p.post_time, u.username \r\n FROM phpbb3_topics t, phpbb3_posts p, phpbb3_users u, " . $topicstable . " tt\r\n WHERE t.topic_approved='1' \r\n AND tt.active='Y' \r\n AND tt.topic=t.topic_id\r\n AND t.forum_id NOT IN " . $forum_exclude . " \r\n AND t.topic_last_post_id=p.post_id \r\n AND p.poster_id = u.user_id " . "ORDER BY tt.prio DESC, t.topic_last_post_time DESC limit 0," . $topics;
$result = mysql_query($sql_sticky);
while ($row = mysql_fetch_array($result)) {
$mar_title = $row["topic_title"];
$mar_url = $forum_path . 'viewtopic.php?t=' . $row["topic_id"];
$mar_user = $row["username"];
$topic_link = '<a href="' . $mar_url . '">' . $mar_title . '</a>';
$post_time = formatAgoSpan($row["post_time"]) . " ago";
$topic_user = '******' . " (by <b>{$mar_user}</b>, {$post_time})" . '</span>';
$line = $topic_link . $topic_user;
$title = htmlentities(escapePostText($row["post_text"]));
echo '<tr title="' . $title . '">';
if ($row['prio'] >= 1000) {
echo '<td class="link-stickytopic-hot" colspan="3">';
} else {
echo '<td class="link-stickytopic" colspan="3">';
}
echo $line;
echo "</td>";
echo "</tr>";
$topics--;
}
}
if (!empty($inline)) {
$topicsExclude = "AND t.topic_id NOT IN (" . $inline . ") ";
}
$sql = "SELECT t.forum_id, t.topic_id, t.topic_last_post_id, t.topic_title, p.post_text, p.post_time, u.username \r\n FROM phpbb3_topics t, phpbb3_posts p, phpbb3_users u \r\n WHERE t.topic_approved='1' \r\n AND t.forum_id NOT IN " . $forum_exclude . " \r\n " . $topicsExclude . "\r\n AND t.topic_last_post_id=p.post_id \r\n AND p.poster_id = u.user_id ORDER BY t.topic_last_post_time DESC limit 0," . $topics;
$result = mysql_query($sql);
while ($row = mysql_fetch_array($result)) {
$mar_title = $row["topic_title"];
$mar_url = $forum_path . 'viewtopic.php?p=' . $row["topic_last_post_id"] . '#p' . $row["topic_last_post_id"];
$mar_user = $row["username"];
$topic_link = '<a href="' . $mar_url . '">' . $mar_title . '</a>';
$post_time = formatAgoSpan($row["post_time"]) . " ago";
$topic_user = '******' . " (by <b>{$mar_user}</b>, {$post_time})" . '</span>';
$line = $topic_link . $topic_user;
$title = htmlentities(escapePostText($row["post_text"]));
echo '<tr title="' . $title . '">';
echo '<td colspan="3">';
echo $line;
echo "</td>";
echo "</tr>";
}
}
}
if ($draws != 1) {
$s_draw = "s";
}
if ($wins > 0 || $losses > 0 || $draws > 0) {
$msg = "You're currently ranked <b>{$positionPlayer}</b> on the {$ladder} ladder " . "with <b>{$points}</b> points, <b>{$wins}</b> win{$s_win}, <b>{$draws}</b> draw{$s_draw} and <b>{$losses}</b> defeat{$s_loss}";
}
$sql = "SELECT name, UNIX_TIMESTAMP(lastUpdated) AS lastUpdatedTS FROM weblm_donations order by lastUpdated desc limit 0,1";
$result = mysql_query($sql);
if (mysql_num_rows($result) > 0) {
if (strlen($msg) > 0) {
$msg .= "<br>";
}
$rowDonator = mysql_fetch_array($result);
$donatorName = $rowDonator['name'];
$donatedAgo = formatAgoSpan($rowDonator['lastUpdatedTS']);
$sql = "SELECT player_id from weblm_players WHERE name='" . $donatorName . "'";
$result = mysql_query($sql);
if (mysql_num_rows($result) > 0) {
$donatorName = '<a href="/profile.php?name=' . $rowDonator['name'] . '">' . $rowDonator['name'] . "</a>";
} else {
$donatorName = '<b>' . $rowDonator['name'] . "</b>";
}
$msg .= '<table align="center"><tr>' . '<td><img style="vertical-align:middle;" src="/gfx/awards/donator.gif" /></td>' . '<td class="darkgrey-small"><a href="/donate.php">Latest donation</a> by <b>' . $donatorName . '</b> (' . $donatedAgo . ' ago)</td>' . '</tr></table>';
}
$approved = $row['approved'];
$nameClass = colorNameClass($cookie_name, $approved);
if ($approved == 'no') {
$inactive = true;
$sql = "SELECT * FROM {$playerstatustable} WHERE type = 'B' and active = 'Y' and userName = '******'";
$result = mysql_query($sql);
}
if (($winnerresult == $loserresult) && !$drawOverride) {
// check for double reports
$sql = "SELECT * FROM $gamestable ".
"where ((winner = '$losername' or loser = '$losername' or winner2 = '$losername' or loser2 = '$losername') ".
"AND (winner = '$winnername' or loser = '$winnername' or winner2 = '$winnername' or loser2 = '$winnername')) ".
"and winnerresult = '$winnerresult' and loserresult = '$loserresult' ".
"and ((winnerteam = '$winnerteamId' and loserteam = '$loserteamId') or (winnerteam = '$loserteamId' and loserteam = '$winnerteamId')) ".
"and dateday = '$dateday' ".
"order by game_id desc limit 0,1";
$result = mysql_query($sql);
if (mysql_num_rows($result) > 0) {
$row = mysql_fetch_array($result);
$gameid = $row['game_id'];
$timeago = formatAgoSpan($row['date']);
$error.= "<p>A similar draw with the same teams was reported ".$timeago.' ago. Please check <b><a href="/games.php?gameId='.$gameid.
'" target="_blank">Game #'.$gameid.'</a></b> to check if your report is correct, then submit again.</p>';
$drawOverride = true;
}
}
if (empty($error)) {
$replayname = '';
if ($approvegames != "yes") {
$rec = 'no';
$gameid = 'null';
$report = ReportGame($winnername, $winnername2, $losername, $losername2, $date, $comment,
$gameid, $winnerresult, $loserresult, $host,
$fairness, $version, $winnerteamId, $loserteamId, NULL);
