Počínaje pátkem 1. června a konče sobotou 30. června se na všech našich NVIDIA serverech začnou započítávat registrovaným týmům statistiky, jež třem nejlepším vynesou pěkné ceny. Ty do soutěže věnovali sponzoři eSubaWear, FakaHeda, SCORE a konkrétně se jedná o:
- místo - 5 x Battlefield 3 tričko od eSubaWear.eu
- místo - public server pro 16 hráčů od FakaHeda.eu
- místo - 5 x herní magazín SCORE
Důležité je ale zmínit, že statistiky se nezapočítávají automaticky, nýbrž pouze hráčům z registrovaných týmů. Pokud se tedy chcete zúčastnit, musíte svůj tým nahlásit na emailové adrese nax@battlefield-3.cz, jako předmět uvést "BF3 PZ Cup" a do zprávy napsat název týmu + herní nicky z Battlelogu všech pěti hráčů.
A co že se vlastně do statistik započítává? Dohromady u všech pěti hráčů celkové nahrané body, headshoty a všechna zabití, z nichž se pak udělá průměr a vyhlásí vítězové. A jak se to celé bude bodovat? Velmi jednoduše. V těchto třech disciplínách (body, headshoty, zabití) budou ohodnoceny vždy tři nejlepší týmy. První získá tři body, druhý dva body, třetí jeden bod. Poté se body sečtou a vytvoří se pořadí.
Aktuálni pořadí:
short_name] = $row->fid; } $flags["--"] = 4; // nastaveni aktivni BF3 DB (bf3db - live, bf3dbtest - test) db_set_active('bf3db'); $res11 = db_query("SELECT tbl_team_data.teamid AS NAZEV_TEAMU, SUM( tbl_playerstats.Score ) AS TEAMSCORE FROM tbl_playerstats, tbl_team_data, tbl_server_player, tbl_playerdata WHERE tbl_playerdata.playerID = tbl_team_data.playerID AND tbl_playerstats.StatsID = tbl_server_player.StatsID AND tbl_server_player.ServerID >0 AND tbl_team_data.soldiername = tbl_playerdata.soldiername AND tbl_team_data.playerID = tbl_server_player.playerId GROUP BY NAZEV_TEAMU ORDER BY TEAMSCORE DESC LIMIT 0 , 100"); $res12 = db_query("SELECT tbl_team_data.teamid AS NAZEV_TEAMU, SUM( tbl_playerstats.Headshots ) AS HEADSHOT FROM tbl_playerstats, tbl_team_data, tbl_server_player, tbl_playerdata WHERE tbl_playerdata.playerID = tbl_team_data.playerID AND tbl_playerstats.StatsID = tbl_server_player.StatsID AND tbl_server_player.ServerID >0 AND tbl_team_data.soldiername = tbl_playerdata.soldiername AND tbl_team_data.playerID = tbl_server_player.playerId GROUP BY NAZEV_TEAMU ORDER BY HEADSHOT DESC LIMIT 0 , 100"); $res13 = db_query("SELECT tbl_team_data.teamid AS NAZEV_TEAMU, SUM( tbl_playerstats.Kills ) AS ZABITYCH FROM tbl_playerstats, tbl_team_data, tbl_server_player, tbl_playerdata WHERE tbl_playerdata.playerID = tbl_team_data.playerID AND tbl_playerstats.StatsID = tbl_server_player.StatsID AND tbl_server_player.ServerID >0 AND tbl_team_data.soldiername = tbl_playerdata.soldiername AND tbl_team_data.playerID = tbl_server_player.playerId GROUP BY NAZEV_TEAMU ORDER BY ZABITYCH DESC LIMIT 0 , 100"); $res2map = db_query("SELECT tbl_team_data.teamID AS NAZEV_TEAMU, tbl_team_data.soldiername AS JMENO_HRACE FROM `tbl_team_data` WHERE `PLAYERID` >0 ORDER BY TEAMID DESC LIMIT 0 , 200"); $res2 = db_query("SELECT tbl_team_data.teamid AS NAZEV_TEAMU, SUM( tbl_playerstats.Score ) AS TEAMSCORE, SUM( tbl_playerstats.Kills ) AS ZABITYCH, SUM( tbl_playerstats.Headshots ) AS ZABITI_DO_HLAVY FROM tbl_playerstats, tbl_team_data, tbl_server_player, tbl_playerdata WHERE tbl_playerdata.playerID = tbl_team_data.playerID AND tbl_playerstats.StatsID = tbl_server_player.StatsID AND tbl_server_player.ServerID >0 AND tbl_team_data.soldiername = tbl_playerdata.soldiername AND tbl_team_data.playerID = tbl_server_player.playerId GROUP BY NAZEV_TEAMU ORDER BY TEAMSCORE DESC LIMIT 0 , 200"); // vraceni aktivni PZ DB db_set_active('default'); $i = 1; while($row = db_fetch_object($res11)) { $trows11[] = array( array("data" => ($i++) . ".", "class" => "w_5p"), $row->NAZEV_TEAMU, array("data" => $row->TEAMSCORE, "class" => "w_20p"), ); } $i = 1; while($row = db_fetch_object($res12)) { $trows12[] = array( array("data" => ($i++) . ".", "class" => "w_5p"), $row->NAZEV_TEAMU, array("data" => $row->HEADSHOT, "class" => "w_20p"), ); } $i = 1; while($row = db_fetch_object($res13)) { $trows13[] = array( array("data" => ($i++) . ".", "class" => "w_5p"), $row->NAZEV_TEAMU, array("data" => $row->ZABITYCH, "class" => "w_20p"), ); } $map = array(); while($row = db_fetch_object($res2map)) { $map[$row->NAZEV_TEAMU][$row->JMENO_HRACE] = $row->JMENO_HRACE; } $i = 1; while($row = db_fetch_object($res2)) { $uid = db_result(db_query("SELECT uid FROM {games_gameid} WHERE gid = %d AND LOWER(gameid) = LOWER('%s')", 1586, $row->Nick)); $trows2[] = array( 'data' => array( array("data" => "".$i++.".", "class" => "w_5p"), array("data" => "".$row->NAZEV_TEAMU.""), array("data" => $row->TEAMSCORE, "class" => "w_15p"), array("data" => $row->ZABITYCH, "class" => "w_15p"), array("data" => $row->ZABITI_DO_HLAVY, "class" => "w_15p"), ), "class" => "split-down" ); $trows2[] = array( array("data" => implode($map[$row->NAZEV_TEAMU], ", "), "colspan" => "5") ); $lastTeamName = $row->NAZEV_TEAMU; } $thead11 = array("#", "Název týmu", "Skóre týmu"); $thead12 = array("#", "Název týmu", "Počet headshotů"); $thead13 = array("#", "Název týmu", "Počet zabitých"); $thead2 = array("#", "Název týmu / hráči", "Skóre", "Zabitých", "Headshotů"); ?>
