| 2 |
- |
1 |
#!/usr/bin/perl
|
|
|
2 |
|
|
|
3 |
#if ($ENV{SHELL}) { die "This script shouldn't be executed from the command line!\n"; }
|
|
|
4 |
|
| 8 |
- |
5 |
use cPanelUserConfig;
|
| 2 |
- |
6 |
use CGI qw/:standard/;
|
|
|
7 |
use scanFunctions;
|
|
|
8 |
use RollerCon;
|
|
|
9 |
use Spreadsheet::WriteExcel;
|
|
|
10 |
use DateTime;
|
|
|
11 |
use DateTime::Duration;
|
|
|
12 |
|
|
|
13 |
my $cookie_string = authenticate(2) || die;
|
|
|
14 |
my ($EML, $PWD, $LVL) = split /&/, $cookie_string;
|
|
|
15 |
my $user = getUser($EML);
|
|
|
16 |
my $username = $user->{derby_name};
|
|
|
17 |
my $RCid = $user->{RCid};
|
|
|
18 |
my $RCAUTH_cookie = CGI::Cookie->new(-name=>'RCAUTH',-value=>"$cookie_string",-expires=>"+30m");
|
|
|
19 |
|
|
|
20 |
my $GID = param('GID');
|
|
|
21 |
my $T1 = param('T1');
|
|
|
22 |
my $T2 = param('T2');
|
|
|
23 |
my $action = param('action');
|
|
|
24 |
|
|
|
25 |
die unless $GID;
|
|
|
26 |
|
|
|
27 |
my $dbh = getDBConnection();
|
|
|
28 |
my $gethan = $dbh->prepare("select * from v_scores where id = ?");
|
|
|
29 |
my $puthan = $dbh->prepare("replace into score (gid, team1_score, team2_score) values (?, ?, ?)");
|
|
|
30 |
|
|
|
31 |
my $savestatus = "";
|
|
|
32 |
my $reload = "";
|
|
|
33 |
if ($action eq "Save") {
|
|
|
34 |
if ($T1 eq '' or $T2 eq '') {
|
|
|
35 |
$savestatus = "<font color=red><b>ERROR:</b> Missing Score!</font>";
|
|
|
36 |
} else {
|
|
|
37 |
$savestatus = "Saved!";
|
|
|
38 |
$reload = 'onload="reloadParent()"';
|
|
|
39 |
$puthan->execute($GID, $T1, $T2) or $savestatus="<font color=red><b>ERROR:</b> Error Saving!</font>";
|
|
|
40 |
}
|
|
|
41 |
}
|
|
|
42 |
|
|
|
43 |
$gethan->execute($GID);
|
|
|
44 |
my ($game) = $gethan->fetchrow_hashref();
|
|
|
45 |
|
|
|
46 |
print CGI::header(-cookie=>$RCAUTH_cookie);
|
|
|
47 |
|
|
|
48 |
print<<page1;
|
|
|
49 |
<HTML><HEAD>
|
|
|
50 |
<TITLE>RC17 Game Score Recorder</TITLE>
|
|
|
51 |
<link rel="stylesheet" type="text/css" href="/rollercon.css">
|
|
|
52 |
</HEAD>
|
|
|
53 |
<body text="#000000" bgcolor="#FFFFFF" link="#000000" vlink="#000000" alink="#FF0000" $reload>
|
|
|
54 |
|
|
|
55 |
<form action="update_score.pl" method=GET name=ScoreUpdate>
|
|
|
56 |
$savestatus
|
|
|
57 |
<table>
|
|
|
58 |
<tr>
|
|
|
59 |
<td colspan=2>Game: $game->{id}<input type=hidden name=GID value=$game->{id}> - $game->{dayofweek} - $game->{track} - $game->{time}</TD>
|
|
|
60 |
</tr><tr>
|
|
|
61 |
<td>$game->{team1}</td><td><input type=text name=T1 size=4 value=$game->{team1_score}></td>
|
|
|
62 |
</tr><tr>
|
|
|
63 |
<td>$game->{team2}</td><td><input type=text name=T2 size=4 value=$game->{team2_score}></td>
|
|
|
64 |
</tr><tr>
|
|
|
65 |
<td colspan=2><input type=Submit name=action value=Reset> <input type=Submit name=action value=Save> <input type=Reset value=Cancel onClick=window.close();></td>
|
|
|
66 |
</tr>
|
|
|
67 |
</table>
|
|
|
68 |
</form>
|
|
|
69 |
|
|
|
70 |
page1
|
|
|
71 |
|
|
|
72 |
if ($savestatus ne '') {
|
|
|
73 |
print<<refresh;
|
|
|
74 |
<SCRIPT language="JavaScript">
|
|
|
75 |
<!--
|
|
|
76 |
function sleep(milliseconds) {
|
|
|
77 |
var start = new Date().getTime();
|
|
|
78 |
for (var i = 0; i < 1e7; i++) {
|
|
|
79 |
if ((new Date().getTime() - start) > milliseconds){
|
|
|
80 |
break;
|
|
|
81 |
}
|
|
|
82 |
}
|
|
|
83 |
}
|
|
|
84 |
|
|
|
85 |
function reloadParent() {
|
|
|
86 |
window.opener.document.Scores.submit();
|
|
|
87 |
sleep(5000);
|
|
|
88 |
//window.close();
|
|
|
89 |
}
|
|
|
90 |
|
|
|
91 |
//-->
|
|
|
92 |
</SCRIPT>
|
|
|
93 |
|
|
|
94 |
refresh
|
|
|
95 |
}
|
|
|
96 |
|
|
|
97 |
print "</BODY></HTML>\n";
|