WHERE last_game_timestamp < (SELECT last_game_timestamp FROM submissions WHERE submission_id = '$sub_id') AND status = 40 AND latest = 1"; $result = mysql_query($query); $row = mysql_fetch_assoc($result); $queue_size = $row['count(1)']; if ($queue_size > 50) { echo "<p>Most likely to play next game within the next $queue_size games.</p>"; } else { echo "<p>Next game should be played soon.</p>"; } } */ echo "<h3><span>Latest Games</span><div class=\"divider\" /></h3>"; echo getGamesTableString($user_id, true, 15, "profile_games.php?user_id={$user_id}"); echo "<p></p>"; echo "<h3><span>Recent Submissions</span><div class=\"divider\" /></h3>"; echo getSubmissionTableString($user_id, true, 10, "profile_submissions.php?user_id={$user_id}"); } //$cache->end(); //} if (logged_in_with_valid_credentials() && logged_in_as_admin()) { $username = current_username(); echo <<<EOT <form method="post" action="disable_account.php" onSubmit='return confirm("Are you sure you want do disable this account?")'> <h2>Disable Account:</h2> <p>Reason: <input name="reason" type="text" /> by {$username}.</p> <input type="submit" value="Disable Account" /> <input type="hidden" name="user_id" value="{$user_id}" />
$user_id = $_GET["user_id"]; if (!filter_var($user_id, FILTER_VALIDATE_INT)) { $user_id = NULL; } else { $user_id = intval($user_id); } $page = $_GET["page"]; if (!filter_var($page, FILTER_VALIDATE_INT)) { $page = 1; } else { $page = intval($page); } // Fetch userid's username $username_query = <<<EOT select u.username from users u where u.user_id = '{$user_id}' EOT; $username_data = mysql_query($username_query); if ($username_data) { list($username) = mysql_fetch_row($username_data); } else { $username = ""; } $username = htmlspecialchars($username); echo "<h2><a href=\"profile.php?user_id={$user_id}\">{$username}</a>'s latest submission's games</h2>"; echo getGamesTableString($user_id, false, 200, "?user_id={$user_id}&page=", $page); include 'footer.php';