-
Notifications
You must be signed in to change notification settings - Fork 0
/
updateprocess.php
114 lines (103 loc) · 3.4 KB
/
updateprocess.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
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
<?php session_start(); ?>
<?php
$dname1 = $_POST['dname1'];
$score1 = $_POST['score1'];
$score2 = $_POST['score2'];
$dname2 = $_POST['dname2'];
$conf = parse_ini_file("config.ini");
$con = mysqli_connect($conf['host'] , $conf['user'] , $conf['password'] , $conf['database']);
$result = mysqli_query($con , "SELECT * FROM central");
// Home team wins
if($score1 > $score2)
{
while($row = mysqli_fetch_array($result)) {
if($row['dname'] == $dname1)
{
$g = $row['grp'];
$tplayed = $row['played'] + 1;
$twon = $row['won'] + 1;
$tgf = $row['gf'] + $score1;
$tga = $row['ga'] + $score2;
$tgd = $row['gd'] + $score1 - $score2;
$tpoints = $row['points'] + 3;
//Update
mysqli_query($con ,"UPDATE central SET played='$tplayed' , won = '$twon' , gf = '$tgf' , ga='$tga' , gd='$tgd' , points='$tpoints' WHERE dname = '$dname1'");
}
if($row['dname'] == $dname2)
{
$tplayed = $row['played'] + 1;
$tlost = $row['lost'] + 1;
$tgf = $row['gf'] + $score2;
$tgfa = $row['gfa'] + $score2;
$tga = $row['ga'] + $score1;
$tgd = $row['gd'] + $score2 - $score1;
//update
mysqli_query($con ,"UPDATE central SET played='$tplayed' , lost = '$tlost' , gf = '$tgf' , gfa='$tgfa' , ga='$tga' , gd='$tgd' WHERE dname = '$dname2'");
}
}
}
//Away Team Wins
if($score1 < $score2)
{
while($row = mysqli_fetch_array($result)) {
if($row['dname'] == $dname1)
{
$tplayed = $row['played'] + 1;
$tlost = $row['lost'] + 1;
$tgf = $row['gf'] + $score1;
$tga = $row['ga'] + $score2;
$tgd = $row['gd'] + $score1 - $score2;
//Update
mysqli_query($con ,"UPDATE central SET played='$tplayed' , lost = '$tlost' , gf = '$tgf' , ga='$tga' , gd='$tgd' WHERE dname = '$dname1'");
}
if($row['dname'] == $dname2)
{
$g = $row['grp'];
$tplayed = $row['played'] + 1;
$twon = $row['won'] + 1;
$tgf = $row['gf'] + $score2;
$tgfa = $row['gfa'] + $score2;
$tga = $row['ga'] + $score1;
$tgd = $row['gd'] + $score2 - $score1;
$tpoints = $row['points'] + 3;
//update
mysqli_query($con ,"UPDATE central SET played='$tplayed' , won = '$twon' , gf = '$tgf' , gfa='$tgfa' , ga='$tga' , gd='$tgd' , points='$tpoints' WHERE dname = '$dname2'");
}
}
}
// Teams draw
if($score1 == $score2)
{
while($row = mysqli_fetch_array($result)) {
if($row['dname'] == $dname1)
{
$g = $row['grp'];
$tplayed = $row['played'] + 1;
$tdrew = $row['drew'] + 1;
$tgf = $row['gf'] + $score1;
$tga = $row['ga'] + $score2;
$tpoints = $row['points'] + 1;
//Update
mysqli_query($con ,"UPDATE central SET played='$tplayed' , drew = '$tdrew' , gf = '$tgf' , ga='$tga' , points='$tpoints' WHERE dname = '$dname1'");
}
if($row['dname'] == $dname2)
{
$tplayed = $row['played'] + 1;
$tdrew = $row['drew'] + 1;
$tgf = $row['gf'] + $score2;
$tgfa = $row['gfa'] + $score2;
$tga = $row['ga'] + $score1;
$tpoints = $row['points'] + 1;
//update
mysqli_query($con ,"UPDATE central SET played='$tplayed' , drew = '$tdrew' , gf = '$tgf' , gfa='$tgfa' , ga='$tga' , points='$tpoints' WHERE dname = '$dname2'");
}
}
}
$sql = mysqli_query($con , "INSERT INTO results (hdname , hscore , ascore , adname , grp) VALUES ('$dname1' , '$score1' , '$score2' , '$dname2' , '$g')");
?>
<html>
<script>
window.alert("Score Updated Successfully");
window.location.replace("update.php");
</script>
</html>