$isSelected = ""; if ($country == $region) { $isSelected = $selected; } echo "<option {$isSelected}>{$country}</option>"; } ?> </select> <input class="width100" type="Submit" name="submit" value="show" /></form> </td></tr></table> <br> <?php $pointsField = getPointsFieldForVersion($version); $gamesField = getGamesFieldForVersion($version); $winsField = getWinsFieldForVersion($version); $lossesField = getLossesFieldForVersion($version); $sortby = $pointsField . " DESC, percentage DESC, {$lossesField} ASC"; $cur = 0; if (in_array($region, $continentArray)) { $condition = "AND nationality IN ("; $reg_sql = "select country from {$countriestable} where continent = '{$region}'"; $reg_result = mysql_query($reg_sql); $num_rows = mysql_num_rows($reg_result); while ($cur < $num_rows) { $row = mysql_fetch_array($reg_result); $condition .= "'" . $row['country'] . "'"; $cur++; if ($cur < $num_rows) { $condition .= ", "; }
function RestoreLadderGame($restoreGameId) { $appRoot = realpath(dirname(__FILE__)) . '/'; require $appRoot . './../variables.php'; require $appRoot . './../variablesdb.php'; require_once $appRoot . './../functions.php'; $resultMsg = "Restoring Game #" . $restoreGameId . "<br>"; $sql = "select * from {$gamestable} where game_id = '{$restoreGameId}'"; $result = mysql_query($sql); $num = mysql_num_rows($result); if ($num != 1) { $resultMsg .= "Invalid query, found {$num} results for '{$sql}'"; } else { $row = mysql_fetch_array($result); $deleted = $row['deleted']; $row_season = $row['season']; $isDraw = $row['isDraw']; if ($row_season != $season) { $resultMsg .= "<p>Game #" . $restoreGameId . " is not from this season!</p>"; } else { if ($deleted == 'no') { $resultMsg .= "<p>Game #" . $restoreGameId . " is not deleted!</p>"; } else { $ratingdiff = $row['ratingdiff']; $winpoints = $row['winpoints']; $losepoints = $row['losepoints']; $losepoints2 = $row['losepoints2']; $winner = $row['winner']; $winner2 = $row['winner2']; $loser = $row['loser']; $loser2 = $row['loser2']; $teamLadder = $row['teamLadder']; $sql = "UPDATE {$gamestable} SET deleted = 'no' where game_id = '{$restoreGameId}'"; $result = mysql_query($sql); if ($result != 1) { $resultMsg .= '<p>Error updating game!</p>'; } else { $resultMsg .= "<p>Game #{$restoreGameId} restored.</p>"; } $sql = "select version from {$gamestable} where game_id ='{$restoreGameId}'"; $result = mysql_query($sql); while ($row = mysql_fetch_array($result)) { $version = $row["version"]; } if ($teamLadder == 0) { $pointsField = getPointsFieldForVersion($version); $winsField = getWinsFieldForVersion($version); $lossesField = getLossesFieldForVersion($version); $gamesField = getGamesFieldForVersion($version); $drawsField = "draws"; } else { $pointsField = "teamPoints"; $winsField = "teamWins"; $lossesField = "teamLosses"; $drawsField = "teamDraws"; $gamesField = "teamGames"; } $winner_streakArray = getStreak($winner); $winner_winstreak = $winner_streakArray[0]; $winner_losestreak = $winner_streakArray[1]; $resultMsg .= "<p>New streak for {$winner}: Won " . $winner_winstreak . ", lost " . $winner_losestreak . "</p>"; $loser_streakArray = getStreak($loser); $loser_winstreak = $loser_streakArray[0]; $loser_losestreak = $loser_streakArray[1]; $resultMsg .= "<p>New streak for {$loser}: Won " . $loser_winstreak . ", lost " . $loser_losestreak . "</p>"; $sql = "SELECT {$pointsField} from {$playerstable} where name='{$loser}'"; $result = mysql_query($sql); $row = mysql_fetch_array($result); $ra2ladder = $row[$pointsField]; $newra2ladder = $ra2ladder - $losepoints; if ($newra2ladder < 0) { $newra2ladder = 0; } if ($isDraw > 0) { $winLoss = 0; $draw = 1; } else { $winLoss = 1; $draw = 0; } $sql = "UPDATE {$playerstable} SET {$lossesField} = {$lossesField} + {$winLoss}," . "totallosses = totallosses + {$winLoss}, " . "{$drawsField}={$drawsField}+{$draw}, totaldraws = totaldraws + {$draw}, " . "{$gamesField} = {$gamesField} + 1, " . "totalgames = totalgames + 1, " . "streakwins = {$loser_winstreak}, " . "streaklosses = {$loser_losestreak}, " . "rating = rating - {$ratingdiff}, " . "{$pointsField} = {$newra2ladder} WHERE name='{$loser}'"; $result = mysql_query($sql); if ($result != 1) { $resultMsg .= '<p>Error updating loser: $result</p>'; } $sql = "UPDATE {$playerstable} " . "SET {$winsField} = {$winsField}+ {$winLoss}, " . "totalwins = totalwins + {$winLoss}, " . "{$gamesField} = {$gamesField} + 1, " . "totalgames = totalgames + 1, " . "{$drawsField}={$drawsField}+{$draw}, totaldraws = totaldraws + {$draw}, " . "streakwins = {$winner_winstreak}, " . "streaklosses = {$winner_losestreak}, " . "rating = rating + {$ratingdiff}, " . "{$pointsField} = {$pointsField} + {$winpoints} " . "WHERE name='{$winner}'"; $result = mysql_query($sql); if ($result != 1) { $resultMsg .= '<p>Error updating winner: ' . $result . '</p>'; } // Winner2 / Loser2 if (!empty($loser2)) { $loser2_streakArray = getStreak($loser2); $loser2_winstreak = $loser2_streakArray[0]; $loser2_losestreak = $loser2_streakArray[1]; $resultMsg .= "<p>New streak for {$loser2}: Won " . $loser2_winstreak . ", lost " . $loser2_losestreak . "</p>"; $sql = "SELECT {$pointsField} from {$playerstable} where name='{$loser2}'"; $result = mysql_query($sql); $row = mysql_fetch_array($result); $ra2ladder = $row[$pointsField]; $newra2ladder = $ra2ladder - $losepoints2; if ($newra2ladder < 0) { $newra2ladder = 0; } $sql = "UPDATE {$playerstable} SET {$lossesField} = {$lossesField} + {$winLoss}," . "totallosses = totallosses + {$winLoss}, " . "{$gamesField} = {$gamesField} + 1, " . "totalgames = totalgames + 1, " . "{$drawsField} = {$drawsField} + {$draw}, totaldraws = totaldraws + {$draw}, " . "streakwins = {$loser_winstreak}, " . "streaklosses = {$loser_losestreak}, " . "rating = rating - {$ratingdiff}, " . "{$pointsField} = {$newra2ladder} WHERE name='{$loser2}'"; $result = mysql_query($sql); if ($result != 1) { $resultMsg .= '<p>Error updating loser2: $result</p>'; } } if (!empty($winner2)) { $winner2_streakArray = getStreak($winner2); $winner2_winstreak = $winner2_streakArray[0]; $winner2_losestreak = $winner2_streakArray[1]; $resultMsg .= "<p>New streak for {$winner2}: Won " . $winner2_winstreak . ", lost " . $winner2_losestreak . "</p>"; $sql = "UPDATE {$playerstable} " . "SET {$winsField} = {$winsField} + {$winLoss}, " . "totalwins = totalwins + {$winLoss}, " . "{$gamesField} = {$gamesField} + 1, " . "totalgames = totalgames + 1, " . "{$drawsField} = {$drawsField} + {$draw}, totaldraws = totaldraws + {$draw}, " . "streakwins = {$winner2_winstreak}, " . "streaklosses = {$winner2_losestreak}, " . "rating = rating + {$ratingdiff}, " . "{$pointsField} = {$pointsField} + {$winpoints} " . "WHERE name='{$winner2}'"; $result = mysql_query($sql); if ($result != 1) { $resultMsg .= '<p>Error updating winner: ' . $result . '</p>'; } } } } } return $resultMsg; }
$sql = "SELECT * FROM {$playerstable} WHERE pwd='{$cookieSessionId}'"; $result = mysql_query($sql); if ($row = mysql_fetch_array($result)) { $cookie_name = $row['name']; } } } $loggedIn = $cookie_name != ""; if ($maintenance == 'yes') { die($leaguename . " down for update. We're back in a bit."); } if ($loggedIn) { $defaultversion = $row['defaultversion']; $ladder = getLadderForVersion($defaultversion); $positionPlayer = getPlayerPosition($cookie_name, $defaultversion); $wins = $row[getWinsFieldForVersion($defaultversion)]; $losses = $row[getLossesFieldForVersion($defaultversion)]; $points = $row[getPointsFieldForVersion($defaultversion)]; $draws = $row['draws']; $invalidEmail = $row['invalidEmail'] == 1; $mail = $row['mail']; $rejected = $row['rejected']; $rejectReason = $row['rejectReason']; $signup = $row['signup']; $signupSent = $row['signupSent']; $hash6 = $row['hash6']; $s_win = ""; $s_loss = ""; $s_draw = ""; if ($wins != 1) { $s_win = "s";
} else { $msnname = "$msn"; $msnpic = "<img border='1' src='gfx/msn.gif' align='absmiddle'></a>"; } $uploadSpeed = $row["uploadSpeed"]; $downloadSpeed = $row["downloadSpeed"]; $deductedPoints = $row["deductedPoints"]; $country = $row["country"]; $nationality = $row["nationality"]; $message = $row["message"]; $rating = $row["rating"]; $wins = $row[getWinsFieldForVersion('A')] + $row[getWinsFieldForVersion('D')]; $losses = $row[getLossesFieldForVersion('A')] + $row[getLossesFieldForVersion('D')]; $points = $row[getPointsFieldForVersion($version)]; $games = $row[getGamesFieldForVersion('A')] + $row[getGamesFieldForVersion('D')]; $draws = $row['draws']; $teamWinsSql = "SELECT count(*) as count from $gamestable where season = $season ". "AND deleted = 'no' AND teamLadder = 1 AND (winner = '$name' or winner2 = '$name') and isDraw = 0"; $teamWnsRow = mysql_fetch_array(mysql_query($teamWinsSql)); $teamWins = $teamWnsRow['count']; $wins += $teamWins; $teamLossesSql = "SELECT count(*) as count from $gamestable where season = $season ". "AND deleted = 'no' AND teamLadder = 1 AND (loser = '$name' or loser2 = '$name') and isDraw = 0"; $teamLossesRow = mysql_fetch_array(mysql_query($teamLossesSql)); $teamLosses = $teamLossesRow['count'];
function getRankingArray($version) { require 'variables.php'; $pointsField = getPointsFieldForVersion($version); $winsField = getWinsFieldForVersion($version); $lossesField = getLossesFieldForVersion($version); $gamesField = getGamesFieldForVersion($version); $sortby = $pointsField . " DESC, percentage DESC, {$lossesField} ASC"; $sql = "SELECT name, {$winsField}/{$gamesField} as percentage FROM {$playerstable} WHERE {$gamesField} >= 1 AND approved='yes' ORDER BY {$sortby}"; $result = mysql_query($sql); $position = 1; $positions = array(); while ($row = mysql_fetch_array($result)) { $positions[$row['name']] = $position; $position++; } return $positions; }
// the image can be referenced in the sig with sig.php?name=playername // text is written on the sig_template.png image and delivered to the calling browser. // may or may not work with your server config and forum $page = "sig"; require './variables.php'; require './variablesdb.php'; require './functions.php'; header("Content-type: image/png"); $name = mysql_real_escape_string($_GET['name']); $sql = "SELECT * from {$playerstable} where name = '{$name}'"; //echo $sql; $result = mysql_query($sql); $row = mysql_fetch_array($result); $version = $row["defaultversion"]; //echo $version; $wins = $row[getWinsFieldForVersion($version)]; $losses = $row[getLossesFieldForVersion($version)]; $draws = $row['draws']; $points = $row[getPointsFieldForVersion($version)]; $imageurl = "/var/www/yoursite/http/gfx/sig_template.png"; $font_line1 = 3; $font_line1_right = 1; $font_line2 = 2; $offset_left = 13; $offset_left_line1_right = 340; $offset_line1_right = 10; $offset_line1 = 8; $offset_line2 = 26; $string_line1 = $leaguename . ".com statistics for " . $name; $string_line1_right = "season " . $season; $string_line2 = "rank: " . getPlayerPosition($name, $version) . " points: " . $points . " Wins: " . $wins . " Draws: " . $draws . " Defeats: " . $losses;
<td valign="top"><!-- standings --> <? $standingsLinksArray[] = array ('./standings.php', 'show_standings', 'show complete standings'); // if (!stristr(getSupportedVersions(), $cookie_version)) { $showVersion = "H"; // } else { // $showVersion = $cookie_version; // } $boxTitle = "Single Standings"; echo getBoxTopImg($boxTitle, $boxheight, false, $standingsLinksArray, $box2Img, $box2Align); ?> <table> <?php $pointsField = getPointsFieldForVersion($showVersion); $winsField = getWinsFieldForVersion($showVersion); $lossesField = getLossesFieldForVersion($showVersion); $gamesField = getGamesFieldForVersion($showVersion); $sortby = $pointsField . " DESC, percentage DESC, {$lossesField} ASC"; $sql = "SELECT *, {$winsField}/{$gamesField} as percentage FROM {$playerstable} WHERE {$gamesField} >= 1 AND approved = 'yes' ORDER BY {$sortby}, {$gamesField} ASC LIMIT 0, 10"; $result = mysql_query($sql); $num = mysql_num_rows($result); $compteur = 1; $col = "color:#555555"; while (10 >= $compteur) { $row = mysql_fetch_array($result); if (!empty($row["nationality"])) { $nationality = $row["nationality"]; } else { $nationality = 'No country'; }