X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;f=include%2Fvalidations.inc.php;h=fdd0faeac8ed2a3564ec125b15397271e827c396;hb=68a269916d88ab4f635de4c96367af1ad82ff135;hp=14553f5892aaeba2b88158728a0fe582dac06de1;hpb=0337d704b62718d7c77106c0e4c4e26fb02beacf;p=platal.git diff --git a/include/validations.inc.php b/include/validations.inc.php index 14553f5..fdd0fae 100644 --- a/include/validations.inc.php +++ b/include/validations.inc.php @@ -1,6 +1,6 @@ uid = $_uid; $this->stamp = date('YmdHis'); $this->unique = $_unique; $this->type = $_type; - $res = $globals->xdb->query( + $res = XDB::query( "SELECT u.prenom, u.nom, u.promo, a.alias, b.alias FROM auth_user_md5 AS u INNER JOIN aliases AS a ON ( u.user_id=a.id AND a.type='a_vie' ) @@ -112,13 +111,12 @@ class Validate */ function submit () { - global $globals; if ($this->unique) { - $globals->xdb->execute('DELETE FROM requests WHERE user_id={?} AND type={?}', $this->uid, $this->type); + XDB::execute('DELETE FROM requests WHERE user_id={?} AND type={?}', $this->uid, $this->type); } $this->stamp = date('YmdHis'); - $globals->xdb->execute('INSERT INTO requests (user_id, type, data, stamp) VALUES ({?}, {?}, {?}, {?})', + XDB::execute('INSERT INTO requests (user_id, type, data, stamp) VALUES ({?}, {?}, {?}, {?})', $this->uid, $this->type, $this, $this->stamp); return true; @@ -129,8 +127,7 @@ class Validate function update () { - global $globals; - $globals->xdb->execute('UPDATE requests SET data={?}, stamp=stamp + XDB::execute('UPDATE requests SET data={?}, stamp=stamp WHERE user_id={?} AND type={?} AND stamp={?}', $this, $this->uid, $this->type, $this->stamp); @@ -145,12 +142,11 @@ class Validate */ function clean () { - global $globals; if ($this->unique) { - return $globals->xdb->execute('DELETE FROM requests WHERE user_id={?} AND type={?}', + return XDB::execute('DELETE FROM requests WHERE user_id={?} AND type={?}', $this->uid, $this->type); } else { - return $globals->xdb->execute('DELETE FROM requests WHERE user_id={?} AND type={?} AND stamp={?}', + return XDB::execute('DELETE FROM requests WHERE user_id={?} AND type={?} AND stamp={?}', $this->uid, $this->type, $this->stamp); } } @@ -262,11 +258,10 @@ class Validate */ function get_request($uid, $type, $stamp = -1) { - global $globals; if ($stamp == -1) { - $res = $globals->xdb->query('SELECT data FROM requests WHERE user_id={?} and type={?}', $uid, $type); + $res = XDB::query('SELECT data FROM requests WHERE user_id={?} and type={?}', $uid, $type); } else { - $res = $globals->xdb->query("SELECT data, stamp FROM requests WHERE user_id={?} AND type={?} and stamp={?}", $uid, $type, $stamp); + $res = XDB::query("SELECT data, stamp FROM requests WHERE user_id={?} AND type={?} and stamp={?}", $uid, $type, $stamp); } if ($result = $res->fetchOneCell()) { $result = unserialize($result);