X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;f=classes%2Fplatallogger.php;h=9ff2e612bc867899106d53fc8c021637017b0131;hb=5660032ac785d410f90e3f5b0d6948dc90b0cfea;hp=7ebdab0423080d0f8eeca8a61cf57046b001bf4e;hpb=0783a5ed4d3409bcd7a7e1d908696159999810c8;p=platal.git diff --git a/classes/platallogger.php b/classes/platallogger.php index 7ebdab0..9ff2e61 100644 --- a/classes/platallogger.php +++ b/classes/platallogger.php @@ -45,11 +45,8 @@ class PlatalLogger extends PlLogger $this->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; @@ -91,7 +88,7 @@ class PlatalLogger extends PlLogger } public function saveLastSession() { - XDB::execute('REPLACE INTO logger.last_sessions (uid, id) + XDB::execute('REPLACE INTO #logger#.last_sessions (uid, id) VALUES ({?}, {?})', $this->uid, $this->session); } @@ -109,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);