// param7 = side // param8 = loseTime (time when player lost) // param9 = allyNumber // param10 = rank case "battle": if (!validate()) { exit("FAILED 2 auth failed"); } $id = updatePlayer($_GET['login'], -1, 0); $map = getMapId($_GET['map']); $mod = getModId($_GET['mod']); mysql_query("INSERT INTO Games (playerId, title, mapId, modId, start, duration, players) VALUES ({$id}, '{$_GET['title']}', {$map}, {$mod}, {$_GET['start']}, {$_GET['duration']}, " . count($_GET[player]) . ")"); $battle_id = mysql_insert_id(); $plcount = 0; for ($i = 0; $i < count($_GET[player]); ++$i) { $s = explode("|", $_GET['player'][$i]); $pid = updatePlayer($s[0], $s[1], $s[10]); if ($s[10] == 0 || $s[10] == "") { // doesnt have rank set in data, check database for latest rank $s[10] = mysql_result(mysql_query("SELECT rank FROM Players WHERE id = {$pid}"), 0, 0); } mysql_query("REPLACE INTO Games2players (gameId, playerId, spectator, victoryTeam, aliveTillEnd, dropTime, leaveTime, side, loseTime, allyNumber, rank) VALUES ({$battle_id}, {$pid}, {$s['2']}, {$s['3']}, {$s['4']}, {$s['5']}, {$s['6']}, '{$s['7']}', {$s['8']}, {$s['9']}, {$s['10']})"); if ($s[2] == 0) { $plcount++; } } mysql_query("UPDATE Games SET players={$plcount} WHERE id = {$battle_id}"); // player count excludes spectators calculateBattleElo($battle_id); break; }
<?php require_once "globals.php"; $p = $_GET[p]; $l = $_GET[login]; if ($_GET[elorec] == "1") { mysql_query("UPDATE Players SET elo=1500, w=1"); $r = mysql_query("SELECT gameId FROM Games2players WHERE spectator=0 GROUP BY gameId HAVING count(distinct allyNumber)>=2 ORDER BY gameId"); while ($row = mysql_fetch_array($r)) { calculateBattleElo($row[0]); echo $row[0] . " \n"; } } $getelo = $_GET[getelo]; if (isset($getelo)) { $r = mysql_query("SELECT elo FROM Players WHERE name='{$getelo}'"); if (mysql_num_rows($r) == 0) { echo "1500"; } else { echo mysql_result($r, 0, 0); } exit; } $welo = $_GET[welo]; if (isset($welo)) { global $w_max; $r = mysql_query("SELECT elo,w FROM Players WHERE name='{$welo}'"); if (mysql_num_rows($r) == 0) { echo "1500|0"; } else { echo mysql_result($r, 0, 0) . "|" . mysql_result($r, 0, 1);