-
Notifications
You must be signed in to change notification settings - Fork 0
/
process_scores.php
executable file
·65 lines (51 loc) · 1.83 KB
/
process_scores.php
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
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
<?php
require_once("common.php");
showHeader();
//processing data from enter_scores.php
if(isset($_POST['school1_id'])) {
$school1ID = mysql_real_escape_string($_POST['school1_id']);
$school2ID = mysql_real_escape_string($_POST['school2_id']);
for($i = 0; $i < 2; $i++) {
if($i == 0) {
$level = 'A';
} else {
$level = 'B';
}
foreach($_POST['level' . $level . '_players'] as $event=>$schools) {
//echo "<h1>$event school A gains {$_POST['level' . $level . '_points'][$event][0]}, school B gains {$_POST['levelA_points'][$event][1]}</h1>";
foreach($schools as $k=>$players) {
if($k == 0) {
$sID = $school1ID;
$oID = $school2ID;
$pts = $_POST['level' . $level . '_points'][$event][0];
} else {
$sID = $school2ID;
$oID = $school1ID;
$pts = $_POST['level' . $level . '_points'][$event][1];
}
$isInsert = true;
$rs = mysql_query("SELECT * FROM score WHERE school_id = $sID AND opponent_id=$oID AND level = '$level' AND event='$event'");
if(mysql_num_rows($rs) == 0) {
mysql_query("INSERT INTO score (school_id, opponent_id, level, event, points) VALUES ($sID, $oID, '$level', '$event', $pts)");
$scoreID = mysql_insert_id();
} else {
$score = mysql_fetch_object($rs);
$scoreID = $score->id;
mysql_query("UPDATE score SET points = $pts WHERE id=$scoreID");
$isInsert = false;
}
foreach($players as $playerID) {
//echo "<li>$playerID - $k</li>";
if($isInsert) {
mysql_query("INSERT INTO player_score (score_id, player_id) VALUES ($scoreID, $playerID)");
} else {
mysql_query("UPDATE player_score SET player_id = $playerID WHERE score_id=$scoreID");
}
}
}
}
}
echo "Scores entered successfully.";
}
showFooter();
?>