X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;f=classes%2Fplatallogger.php;h=9ff2e612bc867899106d53fc8c021637017b0131;hb=5660032ac785d410f90e3f5b0d6948dc90b0cfea;hp=a7a8d02651ace45be714a0f3356159fdf16ea1f4;hpb=27caa1c810ffdca0b6d432f1401d33c0062cf482;p=platal.git diff --git a/classes/platallogger.php b/classes/platallogger.php index a7a8d02..9ff2e61 100644 --- a/classes/platallogger.php +++ b/classes/platallogger.php @@ -1,6 +1,6 @@ session = $this->writeSession($uid, $suid); // retrieve available actions - $res = XDB::iterRow("SELECT id, text FROM logger.actions"); - - while (list($action_id, $action_text) = $res->next()) { - $this->actions[$action_text] = $action_id; - } + $this->actions = XDB::fetchAllAssoc('text', 'SELECT id, text + FROM logger.actions'); } /** Creates a new session entry in database and return its ID. @@ -74,8 +71,8 @@ class PlatalLogger extends PlLogger $proxy = 'proxy'; } - XDB::execute("INSERT INTO logger.sessions - SET uid={?}, host={?}, ip={?}, forward_ip={?}, forward_host={?}, browser={?}, suid={?}, flags={?}", + XDB::execute("INSERT INTO #logger#.sessions + SET uid={?}, host={?}, ip={?}, forward_ip={?}, forward_host={?}, browser={?}, suid={?}, flags={?}", $uid, $host, ip_to_uint($ip), ip_to_uint($forward_ip), $forward_host, $browser, $suid, $proxy); if ($forward_ip) { $this->proxy_ip = $ip; @@ -87,15 +84,18 @@ class PlatalLogger extends PlLogger $this->host = $host; } - $id = XDB::insertId(); - if ($uid and !$suid) { - XDB::execute('REPLACE INTO logger.last_sessions (uid, id) - VALUES ({?}, {?})', - $uid, $id); - } - return $id; + return XDB::insertId(); } + public function saveLastSession() { + XDB::execute('REPLACE INTO #logger#.last_sessions (uid, id) + VALUES ({?}, {?})', + $this->uid, $this->session); + } + + public function isValid($uid) { + return $uid == $this->uid; + } /** Logs an action and its related data. * @@ -106,8 +106,8 @@ class PlatalLogger extends PlLogger public function log($action, $data = null) { if (isset($this->actions[$action])) { - XDB::execute("INSERT INTO logger.events - SET session={?}, action={?}, data={?}", + XDB::execute("INSERT INTO #logger#.events + SET session={?}, action={?}, data={?}", $this->session, $this->actions[$action], $data); } else { trigger_error("PlLogger: unknown action, $action", E_USER_WARNING);