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
|
<?php
require_once('common.php');
require_once('status_submit_list.php');
require_once('square_list.php');
require_once('square_rank_list.php');
require_once('square_problem_list.php');
require_once('square_scoreboard_list.php');
require_once('problem_view.php');
set_time_limit(0);
$paramo = json_decode($_POST['param']);
if($paramo == null){
exit('Eerror');
}
$laststamp = $paramo->laststamp;
if($laststamp == null){
return 'Eerror';
}
$sqlc = pg_connect('host=localhost port=5432 dbname='.DB_NAME.' user='.DB_USER.' password='.DB_PASSWORD);
$retry = 8;
while(true){
$sqlr = pg_query($sqlc,'SELECT "timestamp",array_to_string("status",\',\') AS status FROM "submit" ORDER BY "timestamp" DESC LIMIT 1;');
$sqlo = pg_fetch_object($sqlr);
$nowstamp = $sqlo->timestamp.'_'.$sqlo->status;
pg_free_result($sqlr);
if($nowstamp != $laststamp){
break;
}
if(($retry--) > 0){
sleep(1);
}else{
pg_close($sqlc);
exit('Esame');
}
}
$ret = array(
'laststamp' => $nowstamp
);
if($paramo->status_submit_list != null){
$ret['status_submit_list'] = status_submit_list($sqlc,$paramo->status_submit_list,false);
}
if($paramo->status_submit_userlist != null){
$ret['status_submit_userlist'] = status_submit_list($sqlc,$paramo->status_submit_userlist,true);
}
if($paramo->problem_log_submit_acceptlist != null){
$ret['problem_log_submit_acceptlist'] = status_submit_list($sqlc,$paramo->problem_log_submit_acceptlist,false);
}
if($paramo->problem_log_submit_alllist != null){
$ret['problem_log_submit_alllist'] = status_submit_list($sqlc,$paramo->problem_log_submit_alllist,false);
}
if($paramo->square_list != null){
$ret['square_list'] = square_list($sqlc,$paramo->square_list);
}
if($paramo->square_rank_list != null){
$ret['square_rank_list'] = square_rank_list($sqlc,$paramo->square_rank_list);
}
if($paramo->square_problem_list != null){
$ret['square_problem_list'] = square_problem_list($sqlc,$paramo->square_problem_list);
}
if($paramo->square_scoreboard_list != null){
$ret['square_scoreboard_list'] = square_scoreboard_list($sqlc,$paramo->square_scoreboard_list);
}
if($paramo->problem_view != null){
$ret['problem_view'] = problem_view($sqlc,$paramo->problem_view);
}
pg_close($sqlc);
echo json_encode($ret);
?>
|
