diff options
Diffstat (limited to 'src/fcontest.php')
| -rw-r--r-- | src/fcontest.php | 31 |
1 files changed, 31 insertions, 0 deletions
diff --git a/src/fcontest.php b/src/fcontest.php index 8f636f7..fae2a74 100644 --- a/src/fcontest.php +++ b/src/fcontest.php @@ -547,6 +547,37 @@ function DBSiteDeleteAllRuns ($contest, $site, $user, $usersite,$c=null) { } return true; } +function DBUpdateSiteTime($contest,$param,$dodelete=false,$c=null) { + $ac=array('sitenumber','sitestartdate','siteenddate','updatetime'); + $type['sitenumber']=1; + $type['updatetime']=1; + $type['sitestartdate']=1; + $type['siteenddate']=1; + foreach($ac as $key) { + if(!isset($param[$key])) { + LOGError("DBUpdateSiteTime param error: $key is not set"); + return false; + } + $$key = sanitizeText($param[$key]); + if(isset($type[$key]) && !is_numeric($param[$key])) { + LOGError("DBUpdateSiteTime param error: $key is not numeric"); + return false; + } + } + if($c==null) { + $c = DBConnect(); + DBExec($c, "begin work", "DBUpdateSiteTime(begin)"); + $docommit=true; + } + if($dodelete) + DBExec($c, "delete from sitetimetable where contestnumber=$contest and sitenumber=$sitenumber", "DBUpdateSiteTime(delete)"); + DBExec($c, "insert into sitetimetable (contestnumber, sitenumber, sitestartdate, siteenddate, updatetime) ". + "values ($contest,$sitenumber,$sitestartdate,$siteenddate,$updatetime)", "DBRenewSiteTime(insert)"); + if($docommit) + DBExec($c, "commit work", "DBUpdateSiteTime(commit-noupdate)"); + return true; +} + function DBUpdateSite ($param,$c=null) { $ac=array('contestnumber','sitenumber','sitename','sitepermitlogins','sitescorelevel'); $ac1=array('updatetime','siteautoend','siteglobalscore','siteip','siteactive','siteduration','sitelastmileanswer','sitelastmilescore', |