aboutsummaryrefslogtreecommitdiff
path: root/boca-1.5.1/src/fextdata.php
diff options
context:
space:
mode:
Diffstat (limited to 'boca-1.5.1/src/fextdata.php')
-rw-r--r--boca-1.5.1/src/fextdata.php580
1 files changed, 0 insertions, 580 deletions
diff --git a/boca-1.5.1/src/fextdata.php b/boca-1.5.1/src/fextdata.php
deleted file mode 100644
index 2799bec..0000000
--- a/boca-1.5.1/src/fextdata.php
+++ /dev/null
@@ -1,580 +0,0 @@
-<?php
-////////////////////////////////////////////////////////////////////////////////
-//BOCA Online Contest Administrator
-// Copyright (C) 2003-2012 by BOCA Development Team (bocasystem@gmail.com)
-//
-// This program is free software: you can redistribute it and/or modify
-// it under the terms of the GNU General Public License as published by
-// the Free Software Foundation, either version 3 of the License, or
-// (at your option) any later version.
-//
-// This program is distributed in the hope that it will be useful,
-// but WITHOUT ANY WARRANTY; without even the implied warranty of
-// MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
-// GNU General Public License for more details.
-// You should have received a copy of the GNU General Public License
-// along with this program. If not, see <http://www.gnu.org/licenses/>.
-////////////////////////////////////////////////////////////////////////////////
-// Last modified 21/jul/2012 by cassio@ime.usp.br
-
-function getMainXML($username,$sess,$pass,$pass2) {
- $c = DBConnect();
- if ($c==null) return array(false,"");
- $contest = $_SESSION["usertable"]["contestnumber"];
- $r = DBExec($c, "select * from contesttable where contestnumber=$contest");
- if (DBnLines($r)==0) {
- echo "Unable to find the contest $contest in the database.\n";
- exit;
- }
- $ct = DBRow($r,0);
- $localsite = $ct["contestlocalsite"];
- $mainsite = $ct["contestmainsite"];
- $siteurl = $ct['contestmainsiteurl'] . '/site/get.php';
-// if ($mainsite==$localsite) return array(true,"");
-/*
- $r = DBExec($c, "select * from sitetable where sitenumber=".$mainsite." and contestnumber=$contest");
- if (DBnLines($r)==0) {
- echo "Unable to find the main site in the database (site=$mainsite, contest=$contest).\n";
- exit;
- }
- $st = DBRow($r,0);
- $siteurl = $st["siteip"] . '/site/get.php';
-*/
- if(substr($siteurl,0,7) != 'http://')
- $siteurl = 'http://' . $siteurl;
- if($sess == '') {
-// MSGError('session empty');
- $s = file_get_contents($siteurl);
- if($s === false) return array(false,'','');
-// MSGError($s);
- $t = strtok($s," \t");
- while($t !== false && substr($t,0,8) != '<SESSION' && substr($t,0,6) != '<ERROR' && $t != '<OK>' && $t != '<NOTOK>') {
- echo $t . " ";
- $t = strtok(" \t");
- }
- if($t === false) return array(false,'','');
- echo $t . " -->\n";
- if(substr($t,0,8) == '<SESSION') {
- $id = strtok(" \t");
- return array(false,$id,$id);
- }
- else
- return array(false,'','');
- }
- if($pass == $pass2) {
-// MSGError('equal');
- $opts = array(
- 'http' => array(
- 'method' => 'GET',
- 'header' => 'Cookie: PHPSESSID=' . $sess
- )
- );
- $context = stream_context_create($opts);
- $s = file_get_contents($siteurl . '?name='. $username . '&password=' .
- $pass . '&check=nocheck', 0, $context);
- } else {
- $data = encryptData(generateXML($contest),myhash($pass2));
- $data_url = http_build_query(array('xml' => $data,
- 'name' => $username,
- 'password' => $pass,
- 'check' => myhash($pass . $pass2)
- ));
- $opts = array(
- 'http' => array(
- 'method' => 'POST',
- 'header' => 'Cookie: PHPSESSID=' . $sess . "\r\nContent-Type: application/x-www-form-urlencoded",
- 'content' => $data_url
- ));
- $context = stream_context_create($opts);
- $s = file_get_contents($siteurl, 0, $context);
- }
- if($s === false) return array(false,"",'');
-// MSGError('OPA1: ' . $s);
- $t = strtok($s," \t");
- while($t !== false && substr($t,0,8) != '<SESSION' && substr($t,0,6) != '<ERROR' && $t != '<OK>' && $t != '<NOTOK>') {
- echo $t . " ";
- $t = strtok(" \t");
- }
- if($t === false) return array(false,'','');
- echo $t . " -->\n";
- if(substr($t,0,6) == "<ERROR") {
- $id = strtok(" \t");
- if($id === false) return array(false,'','');
- return array(false,$id,"");
- }
- if(substr($t,0,8) == "<SESSION") {
- $id = strtok(" \t");
- if($id === false) return array(false,'','');
- $idextra = strtok(" \t");
- if($idextra === false) return array(false,'','');
-// MSGError("id=$id idextra=$idextra");
- return array(false,$id,$idextra);
- }
- $id = strtok(" \t");
- if($id === false) return array(false,'','');
-//MSGError('OPA2: ' . $s);
- if($pass2 != '')
- $s = decryptData($id,myhash($pass2));
- if(strtoupper(substr($s,0,5)) != "<XML>") {
- return array(false,'',$t);
- }
- return array(true,$s,$t);
-}
-
-function importFromXML($ar,$acr,$contest=0,$localsite=0) {
- $data = implode("",explode("\n",$ar));
- $parser = xml_parser_create();
- xml_parser_set_option($parser, XML_OPTION_CASE_FOLDING, 1);
- xml_parser_set_option($parser, XML_OPTION_SKIP_WHITE, 1);
- xml_parse_into_struct($parser, $data, $values, $tags);
- xml_parser_free($parser);
-// print_r($tags);
-// print_r($values);
-
- $orderkeys=array('CONTESTREC','SITETIME','SITEREC','USERREC','ANSWERREC','LANGUAGEREC','PROBLEMREC','CLARREC','RUNREC','TASKREC');
- $norderkeys=10;
- $nc=0;
- unset($sitetime);
- unset($nsitetime);
- $conn = DBConnect();
- if ($conn==null) return false;
-// DBExec($conn,"begin work","importFromXML(begin)");
-// DBExec($conn,"lock","importFromXML(lock)");
- if($contest != 0) {
- $r = DBExec($conn, "select * from contesttable where contestnumber=$contest");
- if (DBnLines($r)==0) {
- echo "Unable to find the contest $contest in the database.\n";
- DBExec($conn,"rollback work");
- return false;
- }
- $ct = DBRow($r,0);
- if($localsite==0)
- $localsite = $ct["contestlocalsite"];
- } else if($localsite==0) $localsite=1;
-// $mainsite = $ct["contestmainsite"];
- DBClose($conn);
- $conn=null;
-
- for($keyindex=0; $keyindex < $norderkeys; $keyindex++) {
- foreach($tags as $key=>$val) {
- if($values[$val[0]]['type'] != 'open') continue;
- if($key == "XML") continue;
- if($key != $orderkeys[$keyindex]) continue;
- if(isset($acr[$key]))
- $ac = $acr[$key];
- else
- continue;
- foreach($val as $k=>$v) {
- if($values[$v]['type'] != 'open') continue;
- if(count($val) > $k+1) {
- $param = array();
- if(isset($ac['site'])) {
- for($i=$v; $i < $val[$k+1]; $i++) {
- $p = strtolower($values[$i]["tag"]);
- if($p=='site') {
- if($values[$i]["type"]=="complete" && isset($values[$i]["value"])) {
- $tmp = sanitizeText(trim(implode('',explode('\n',$values[$i]["value"]))));
- if(is_array($ac['site']) && in_array($tmp,$ac['site'])) {
- $param['site'] = $tmp;
- } else {
- if($ac['site']==-1 || ($ac['site']==-2 && $tmp==$localsite) || ($ac['site']==-3 && $tmp!=$localsite) ||
- ($ac['site']>0 && $ac['site']==$tmp))
- $param['site'] = $tmp;
- }
- }
- }
- }
- }
- for($i=$v; $i < $val[$k+1]; $i++) {
- $p = strtolower($values[$i]["tag"]);
- if(isset($ac[$p]) && $p != 'site') {
- if($values[$i]["type"]=="complete" && isset($values[$i]["value"])) {
- if(is_string($ac[$p])) $param[$p] = $ac[$p];
- else {
- $tmp = sanitizeText(trim(implode('',explode('\n',$values[$i]["value"]))));
- if(is_array($ac[$p]) && in_array($tmp,$ac[$p])) {
- $param[$p] = $tmp;
- } else {
- if($ac[$p]==-1 || ($ac[$p]==-2 && $tmp==$localsite) || ($ac[$p]==-3 && $tmp!=$localsite) ||
- ($ac[$p]==0 && isset($param['site'])) || ($ac[$p]>0 && $ac[$p]==$tmp))
- $param[$p] = $tmp;
- }
- }
- }
- }
- }
-// echo "\nKEY KEY KEY\n";
-// print_r($key);
-// echo "\nVAL VAL VAL\n";
-// print_r($val);
-// echo "\n";
-// print_r($param);
- $param['contestnumber'] = $contest;
- if($key == "CONTESTREC") {
- $param['number'] = $contest;
- if($contest == 0) {
- $nc=1;
- $contest = DBNewContest($param, $conn);
- if($contest > 0)
- echo "<br><u>Contest $contest created</u> (not active by default)<br>";
- else {
- echo "<br>Error creating contest<br>";
- if($conn != null)
- DBExec($conn,"rollback work");
- return false;
- }
- }
- $param['number'] = $contest;
- $param['contestnumber'] = $contest;
- if(($ret=DBUpdateContest($param, $conn))) {
- if($ret==2)
- echo "<br>Contest $contest updated<br>";
- }
- else {
- if($conn != null)
- DBExec($conn,"rollback work");
- return false;
- }
- }
- if(!isset($param['number']) || count($param) < 2) continue;
- if($key == "SITEREC") {
- if(!DBNewSite($contest, $conn, $param)) {
- if($conn != null)
- DBExec($conn,"rollback work");
- return false;
- }
- if(($ret=DBUpdateSite($param, $conn))) {
- if($ret==2) {
- echo "Site " . $param["number"] . " updated<br>";
- }
- } else {
- if($conn != null)
- DBExec($conn,"rollback work");
- return false;
- }
- if(isset($nsitetime[$param["number"]])) {
- if(($qtd=DBRenewSiteTime($sitetime[$param["number"]], $conn))) {
- if($qtd==2) {
- echo "Time for site " . $param["number"] . " updated<br>";
- }
- } else {
- if($conn != null)
- DBExec($conn,"rollback work");
- return false;
- }
- }
- }
- if($key == "SITETIME") {
- if(isset($param['site']) && is_numeric($param['site'])) {
- $s = $param['site'];
- if(!isset($nsitetime[$s])) $nsitetime[$s]=0;
- $sitetime[$s][$nsitetime[$s]] = $param;
- $nsitetime[$s]++;
- }
- }
- if($key == "USERREC") {
- if(($ret=DBNewUser($param, $conn))) {
- if($ret==2) {
- echo "User " . $param["number"]."/".$param['site']. " updated<br>";
- }
- } else {
- if($conn != null)
- DBExec($conn,"rollback work");
- return false;
- }
- }
- if($key == "ANSWERREC") {
- if(($ret=DBNewAnswer ($contest, $param, $conn))) {
- if($ret==2) {
- echo "Answer " . $param["number"] . " updated<br>";
- }
- }
- else {
- if($conn != null)
- DBExec($conn,"rollback work");
- return false;
- }
- }
- if($key == "LANGUAGEREC") {
- if(($ret=DBNewLanguage ($contest,$param, $conn))) {
- if($ret==2) {
- echo "Language " . $param['number'] ." updated<br>";
- }
- }
- else {
- if($conn != null)
- DBExec($conn,"rollback work");
- return false;
- }
- }
- if($key == "PROBLEMREC") {
- if(($ret=DBNewProblem ($contest,$param, $conn))) {
- if($ret==2)
- echo "Problem " . $param['number'] ." updated<br>";
- }
- else {
- if($conn != null)
- DBExec($conn,"rollback work");
- return false;
- }
- }
- if($key == "TASKREC") {
- if(($ret=DBNewTask ($param, $conn))) {
- if($ret==2)
- echo "Task " . $param['number']."/".$param['site']." updated<br>";
- }
- else {
- if($conn != null)
- DBExec($conn,"rollback work");
- return false;
- }
- }
- if($key == "CLARREC") {
- if(($ret=DBNewClar ($param, $conn))) {
- if($ret==2)
- echo "Clarification " . $param['number']."/".$param['site'] ." updated<br>";
- }
- else {
- if($conn != null)
- DBExec($conn,"rollback work");
- return false;
- }
- }
- if($key == "RUNREC") {
- if(($ret=DBNewRun ($param, $conn))) {
- if($ret==2)
- echo "Run " . $param['number'] ."/".$param['site']." updated<br>";
- }
- else {
- if($conn != null)
- DBExec($conn,"rollback work");
- return false;
- }
- }
- }
- }
- }
- }
-// DBExec($conn,"commit work","importFromXML(commit)");
- return true;
-}
-
-
-function generateXML($contest,$localsite=0,$sites=null,$reduced=false) {
- $str = "<XML>\n";
- $ac['CONTESTREC']=array('number'=>'contestnumber',
- 'name'=>'contestname',
- 'startdate'=>'conteststartdate',
- 'duration'=>'contestduration',
- 'lastmileanswer'=>'contestlastmileanswer',
- 'lastmilescore'=>'contestlastmilescore',
- 'penalty'=>'contestpenalty',
- 'maxfilesize'=>'contestmaxfilesize',
- 'updatetime'=>'updatetime',
- 'mainsite'=>'contestmainsite',
- 'mainsiteurl'=>'contestmainsiteurl',
- 'keys'=>'contestkeys',
- 'unlockkey'=>'contestunlockkey',
- 'updatetime'=>'updatetime');
- if($localsite > 0)
- $ac['CONTESTREC']['localsite'] = array($localsite,2);
- $sql['CONTESTREC']="select * from contesttable where contestnumber=$contest";
- $ac['ANSWERREC']=array('number'=>'answernumber',
- 'name'=>'runanswer',
- 'yes'=>'yes',
- 'updatetime'=>'updatetime');
- $sql['ANSWERREC']="select * from answertable where contestnumber=$contest and fake='f'";
-
- $ac['LANGUAGEREC']=array('number'=>'langnumber',
- 'name'=>'langname',
- 'updatetime'=>'updatetime');
- $sql['LANGUAGEREC']="select * from langtable where contestnumber=$contest";
-
- $ac['PROBLEMREC']=array('number'=>'problemnumber',
- 'name'=>'problemname',
- 'fullname'=>'problemfullname',
- 'basename'=>'problembasefilename',
- 'inputfilename'=>'probleminputfilename',
- 'inputfilepath'=>array('probleminputfile',1),
- 'solfilename'=>'problemsolfilename',
- 'solfilepath'=>array('problemsolfile',1),
- 'descfilename'=>'problemdescfilename',
- 'descfilepath'=>array('problemdescfile',1),
- 'tl'=>'problemtimelimit',
- 'colorname'=>'problemcolorname',
- 'color'=>'problemcolor',
- 'fake'=>'fake',
- 'updatetime'=>'updatetime');
- $sql['PROBLEMREC']="select * from problemtable where contestnumber=$contest and fake='f'";
-
- $sql['SITEREC']="select * from sitetable where contestnumber=$contest";
- $ac['SITEREC']=array('sitenumber'=>'sitenumber',
- 'site'=>'sitenumber',
- 'number'=>'sitenumber',
- 'sitename'=>'sitename',
- 'siteip'=>'siteip',
- 'siteduration'=>'siteduration',
- 'sitelastmileanswer'=>'sitelastmileanswer',
- 'sitelastmilescore'=>'sitelastmilescore',
- 'sitejudging'=>'sitejudging',
- 'sitetasking'=>'sitetasking',
- 'siteautoend'=>'siteautoend',
- 'siteglobalscore'=>'siteglobalscore',
- 'siteactive'=>'siteactive',
- 'sitescorelevel'=>'sitescorelevel',
- 'sitepermitlogins'=>'sitepermitlogins',
- 'siteautojudge'=>'siteautojudge',
- 'sitenextuser'=>'sitenextuser',
- 'sitenextclar'=>'sitenextclar',
- 'sitenextrun'=>'sitenextrun',
- 'sitenexttask'=>'sitenexttask',
- 'sitemaxtask'=>'sitemaxtask',
- 'sitechiefname'=>'sitechiefname',
- 'updatetime'=>'updatetime');
- $sql['SITETIME']="select * from sitetimetable where contestnumber=$contest";
- $ac['SITETIME']=array('site'=>'sitenumber',
- 'number'=>'sitenumber',
- 'start'=>'sitestartdate',
- 'enddate'=>'siteenddate',
- 'updatetime'=>'updatetime');
-
- $sql['USERREC']="select * from usertable where contestnumber=$contest";
- $ac['USERREC']=array('site'=>'usersitenumber',
- 'user'=>'usernumber',
- 'number'=>'usernumber',
- 'username'=>'username',
- 'updatetime'=>'updatetime',
- 'usericpcid'=>'usericpcid',
- 'userfull'=>'userfullname',
- 'userdesc'=>'userdesc',
- 'type'=>'usertype',
- 'enabled'=>'userenabled',
- 'multilogin'=>'usermultilogin',
-// 'pass'=>'userpassword',
-// 'usersession'=>'usersession',
- 'userip'=>'userip',
- 'userlastlogin'=>'userlastlogin',
- 'userlastlogout'=>'userlastlogout',
- 'permitip'=>'userpermitip',
- 'updatetime'=>'updatetime');
-
- if(!$reduced) {
- $sql['CLARREC']="select * from clartable where contestnumber=$contest";
- $ac['CLARREC']=array('site'=>'clarsitenumber',
- 'user'=>'usernumber',
- 'number'=>'clarnumber',
- 'problem'=>'clarproblem',
- 'question'=>'clardata',
- 'clarnumber'=>'clarnumber',
- 'clardate'=>'clardate',
- 'clardatediff'=>'clardatediff',
- 'clardatediffans'=>'clardatediffans',
- 'claranswer'=>'claranswer',
- 'clarstatus'=>'clarstatus',
- 'clarjudge'=>'clarjudge',
- 'clarjudgesite'=>'clarjudgesite',
- 'updatetime'=>'updatetime');
-
- $sql['RUNREC']="select * from runtable where contestnumber=$contest";
- if(is_array($sites)) {
- $sql['RUNREC'] .= " and (1=0";
- foreach($sites as $k => $v) {
- $sql['RUNREC'] .= " or runsitenumber=$v";
- }
- $sql['RUNREC'] .= ")";
- }
- $ac['RUNREC']=array('site'=>'runsitenumber',
- 'user'=>'usernumber',
- 'number'=>'runnumber',
- 'runnumber'=>'runnumber',
- 'problem'=>'runproblem',
- 'lang'=>'runlangnumber',
- 'filename'=>'runfilename',
- 'filepath'=>array('rundata',1),
- 'rundate'=>'rundate',
- 'rundatediff'=>'rundatediff',
- 'rundatediffans'=>'rundatediffans',
- 'runanswer'=>'runanswer',
- 'runstatus'=>'runstatus',
- 'runjudge'=>'runjudge',
- 'runjudgesite'=>'runjudgesite',
- 'runjudge1'=>'runjudge1',
- 'runjudgesite1'=>'runjudgesite1',
- 'runanswer1'=>'runanswer1',
- 'runjudge2'=>'runjudge2',
- 'runjudgesite2'=>'runjudgesite2',
- 'runanswer2'=>'runanswer2',
- 'autoip'=>'autoip',
- 'autobegindate'=>'autobegindate',
- 'autoenddate'=>'autoenddate',
- 'autoanswer'=>'autoanswer',
- 'autostdout'=>array('autostdout',1),
- 'autostderr'=>array('autostderr',1),
- 'updatetime'=>'updatetime');
- $sql['TASKREC']="select * from tasktable where contestnumber=$contest";
- if(is_array($sites)) {
- $sql['TASKREC'] .= " and (1=0";
- foreach($sites as $k => $v) {
- $sql['TASKREC'] .= " or sitenumber=$v";
- }
- $sql['TASKREC'] .= ")";
- }
- $ac['TASKREC']=array(
- 'site'=>'sitenumber',
- 'user'=>'usernumber',
- 'desc'=>'taskdesc',
- 'number'=>'tasknumber',
- 'tasknumber'=>'tasknumber',
- 'color'=>'color',
- 'colorname'=>'colorname',
- 'updatetime'=>'updatetime',
- 'filename'=>'taskfilename',
- 'filepath'=>array('taskdata',1),
- 'sys'=>'tasksystem',
- 'status'=>'taskstatus',
- 'taskdate'=>'taskdate',
- 'taskdatediff'=>'taskdatediff',
- 'taskdatediffans'=>'taskdatediffans',
- 'taskstaffnumber'=>'taskstaffnumber',
- 'taskstaffsite'=>'taskstaffsite');
- }
- $c = DBConnect();
- if ($c==null) return null;
- DBExec($c, "begin work");
- foreach($ac as $kk => $vv) {
- $r = DBExec ($c, $sql[$kk], "generateXML($kk)");
- $n = DBnLines ($r);
- for($i=0; $i<$n; $i++) {
- $atual = DBRow($r,$i);
- $str .= "<" . $kk . ">\n";
- foreach($vv as $key => $val) {
- if(is_array($val)) {
- if(is_array($val[0])) {
- if(!isset($atual['site']) || in_array($atual['site'],$val[0]))
- if(isset($atual[$val[1]]))
- $str .= " <" . $key . ">" . $atual[$val[1]] . "</" . $key . ">\n";
- }
- if($val[1]==2) {
- $str .= " <" . $key . ">" . $val[0] . "</" . $key . ">\n";
- }
- if($val[1]==1) {
- if(isset($atual[$val[0]]) && $atual[$val[0]]!='') {
- if (($lo = DB_lo_open ($c, $atual[$val[0]], "r")) !== false) {
- $str .= " <" . $key . ">base64:" . base64_encode(DB_lo_read($contest,$lo)) . "</" . $key . ">\n";
- DB_lo_close($lo);
- }
- }
- }
- } else {
- if(isset($atual[$val]))
- $str .= " <" . $key . ">" . $atual[$val] . "</" . $key . ">\n";
- }
- }
- $str .= "</" . $kk . ">\n";
- }
- }
- $str .= "</XML>\n";
- DBExec($c,"commit work","generateXML(commit)");
- return $str;
-}
-?>
generated by cgit v1.2.3 (git 2.25.1) at 2026-05-24 13:59:06 +0000