Пример #1
0
    // 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;
}
Пример #2
0
<?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);