blob: 433a6594825ca97261f230f051424ea7445026e8 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
|
<?php
$sql_killmatrix = "SELECT col2 AS killer,
col4 AS killed,
COUNT(*) AS kills
FROM uts_temp_$uid
WHERE col1 = 'kill'
OR col1 = 'teamkill'
GROUP BY col2, col4";
$q_killmatrix = mysql_query($sql_killmatrix) or die(mysql_error());
while ($r_killmatrix = mysql_fetch_array($q_killmatrix)) {
$sql = " INSERT
INTO uts_killsmatrix
SET matchid = '$matchid',
killer = '". $r_killmatrix['killer'] ."',
victim = '". $r_killmatrix['killed'] ."',
kills = '". $r_killmatrix['kills'] ."';";
mysql_query($sql) or die(mysql_error());
}
?>
|
