blob: 22819a149e8049f51b632ebbb59e6a8d2082f8a1 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
|
<?php
// Who did the objectives
$r_assobj = small_query("SELECT count(id) AS assobjcount FROM uts_temp_$uid WHERE col1 = 'assault_obj' AND col2 = $playerid");
$assobjcount = $r_assobj[assobjcount];
$upd_assobj = "UPDATE uts_player SET ass_obj = $assobjcount WHERE id = $playerecordid";
mysqli_query($GLOBALS["___mysqli_link"], $upd_assobj) or die(mysqli_error($GLOBALS["___mysqli_link"]));
// Get assault game code (unique code give for the 2 games played)
$r_asscode = small_query("SELECT col2 FROM uts_temp_$uid WHERE col1 = 'assault_gamecode' LIMIT 0,1");
$asscode = $r_asscode[col2];
$updateasscode = "UPDATE uts_match SET assaultid = '$asscode' WHERE id = $matchid";
mysqli_query($GLOBALS["___mysqli_link"], $updateasscode) or die(mysqli_error($GLOBALS["___mysqli_link"]));
// Get Which Teams Attacking
$r_assteam = small_query("SELECT col2 FROM uts_temp_$uid WHERE col1 = 'assault_attacker' LIMIT 0,1");
$assteam = $r_assteam[col2];
$updateassteam = "UPDATE uts_match SET ass_att = $assteam WHERE id = $matchid;";
mysqli_query($GLOBALS["___mysqli_link"], $updateassteam) or die(mysqli_error($GLOBALS["___mysqli_link"]));
// Did they do it?
$sql_asswin = "SELECT col0 FROM uts_temp_$uid WHERE col1 = 'game_end' AND col2 = 'Assault succeeded!' LIMIT 0,1";
$q_asswin = mysqli_query($GLOBALS["___mysqli_link"], $sql_asswin) or die(mysqli_error($GLOBALS["___mysqli_link"]));
$asswin = 0;
while ($r_asswin = mysqli_fetch_array($q_asswin)) {
IF ($r_asswin[col0] != NULL ) { $asswin = 1; }
}
$updateasswin = "UPDATE uts_match SET ass_win = $asswin WHERE id = $matchid;";
mysqli_query($GLOBALS["___mysqli_link"], $updateasswin) or die(mysqli_error($GLOBALS["___mysqli_link"]));
?>
|
