diff options
| author | Cassio de Campos <cassiopc@gmail.com> | 2017-11-05 14:18:14 +0000 |
|---|---|---|
| committer | Cassio de Campos <cassiopc@gmail.com> | 2017-11-05 14:18:14 +0000 |
| commit | 66aad0beeaae24f999e2544103ffe2814fb56cd3 (patch) | |
| tree | b4f0c96efb81e2f3383e5628a1bc2125ee6b7303 | |
| parent | 27e9051904e25a610d7997e1f9d525d58f9ec72f (diff) | |
| download | boca-66aad0beeaae24f999e2544103ffe2814fb56cd3.tar.gz boca-66aad0beeaae24f999e2544103ffe2814fb56cd3.zip | |
bf
| -rw-r--r-- | src/fcontest.php | 2 | ||||
| -rw-r--r-- | src/fextdata.php | 7 |
2 files changed, 5 insertions, 4 deletions
diff --git a/src/fcontest.php b/src/fcontest.php index f441c33..5c14277 100644 --- a/src/fcontest.php +++ b/src/fcontest.php @@ -1309,7 +1309,7 @@ function DBNewUser($param, $c=null) { MSGError("DBNewUser param error: site $site does not exist"); return false; } - if($pass != myhash("") && $type != "admin" && $changepass != "t") $pass='!'.$pass; + if($pass != myhash("") && $type != "admin" && $changepass != "t" && substr($pass,0,1) != "!") $pass='!'.$pass; $r = DBExec($c, "select * from usertable where username='$username' and usernumber!=$user and ". "usersitenumber=$site and contestnumber=$contest", "DBNewUser(get user)"); $n = DBnlines ($r); diff --git a/src/fextdata.php b/src/fextdata.php index 25ef1f0..2b2d007 100644 --- a/src/fextdata.php +++ b/src/fextdata.php @@ -702,10 +702,11 @@ function genSQLs($contest, $site, $updatetime, $mainsite=1) { //"problemcolor, " . "updatetime" . " from problemtable where contestnumber=$contest and fake='f' and updatetime >= $updatetime"; - } + $sql['usertable']="select * from usertable where contestnumber=$contest and usersitenumber!=$site and updatetime >= $updatetime"; + } else + $sql['usertable']="select * from usertable where contestnumber=$contest and usersitenumber=$site and updatetime >= $updatetime"; $sql['sitetimetable']="select * from sitetimetable where contestnumber=$contest and sitenumber=$site and updatetime >= $updatetime"; - $sql['usertable']="select * from usertable where contestnumber=$contest and (usersitenumber=$site or usersitenumber=$mainsite) and updatetime >= $updatetime"; - $sql['clartable']="select * from clartable where contestnumber=$contest and clarsitenumber=$site and updatetime >= $updatetime"; + $sql['clartable']="select * from clartable where contestnumber=$contest and updatetime >= $updatetime"; $sql['runtable']="select * from runtable where contestnumber=$contest and runsitenumber=$site and updatetime >= $updatetime"; $sql['tasktable']="select * from tasktable where contestnumber=$contest and sitenumber=$site and updatetime >= $updatetime"; return $sql; |