diff options
Diffstat (limited to 'src')
| -rw-r--r-- | src/fcontest.php | 8 | ||||
| -rwxr-xr-x | src/globals.php | 7 |
2 files changed, 10 insertions, 5 deletions
diff --git a/src/fcontest.php b/src/fcontest.php index 29b5ed9..e61631b 100644 --- a/src/fcontest.php +++ b/src/fcontest.php @@ -125,6 +125,10 @@ CREATE TABLE \"sitetimetable\" ( $r = DBexec($c, "CREATE INDEX \"sitetimesite_index\" ON \"sitetimetable\" USING btree ". "(\"contestnumber\" int4_ops, \"sitenumber\" int4_ops)", "DBCreateSiteTimeTable(create site_index)"); } +// begin; update answertable set updatetime=EXTRACT(EPOCH FROM now()); +// begin; update langtable set updatetime=EXTRACT(EPOCH FROM now()); select * from langtable; +// begin; update problemtable set updatetime=EXTRACT(EPOCH FROM now()); select * from problemtable; + function DBDropUserTable() { $c = DBConnect(); $r = DBExec($c, "drop table \"usertable\"", "DBDropUserTable(drop table)"); @@ -298,8 +302,8 @@ function cleanuserdesc($a) { $inst = explode('[',$inst[1]); if(isset($inst[1])) { $inst2 = explode(',',trim($inst[1])); - $a['userflag'] = $inst2[0]; - if(isset($inst2[1])) $a['usersitename']=trim($inst2[1]); + $a['userflag'] = strtolower($inst2[0]); + if(isset($inst2[1])) $a['usersitename']=strtoupper(trim($inst2[1])); } } else { $a['userdesc']=trim($inst[1]); diff --git a/src/globals.php b/src/globals.php index 1c7fd2b..fbbecce 100755 --- a/src/globals.php +++ b/src/globals.php @@ -320,12 +320,13 @@ function ValidSession() { // $_SESSION["usertable"]["usersession"] != session_id()) return(FALSE); // } else { if($_SESSION["usertable"]["usersession"] != session_id()) return(FALSE); - // } - if($_SESSION["usertable"]["usermultilogin"] == 't') return(TRUE); - + // } $tmp = DBUserInfo($_SESSION["usertable"]["contestnumber"], $_SESSION["usertable"]["usersitenumber"], $_SESSION["usertable"]["usernumber"]); + if($tmp['usersession']=='') return(FALSE); + if($_SESSION["usertable"]["usermultilogin"] == 't') return(TRUE); + if ($tmp["userip"] != $gip) return(FALSE); //cassiopc: they may create a problem here too... return(TRUE); } |