X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;f=classes%2Fplatallogger.php;h=83cf1a6996b4e573872daa0cd68dfc664d278089;hb=a36ad458e13750b8878ae59dd678ee863b649f2b;hp=9ff2e612bc867899106d53fc8c021637017b0131;hpb=5660032ac785d410f90e3f5b0d6948dc90b0cfea;p=platal.git diff --git a/classes/platallogger.php b/classes/platallogger.php index 9ff2e61..83cf1a6 100644 --- a/classes/platallogger.php +++ b/classes/platallogger.php @@ -1,6 +1,6 @@ actions = XDB::fetchAllAssoc('text', 'SELECT id, text - FROM logger.actions'); + FROM log_actions'); } /** Creates a new session entry in database and return its ID. @@ -55,7 +55,7 @@ class PlatalLogger extends PlLogger * @param $suid the id of the administrator who has just su'd to the user * @return session the session id */ - private function writeSession($uid, $suid = 0) + private function writeSession($uid, $suid = null) { $ip = $_SERVER['REMOTE_ADDR']; $host = strtolower(gethostbyaddr($_SERVER['REMOTE_ADDR'])); @@ -71,7 +71,9 @@ class PlatalLogger extends PlLogger $proxy = 'proxy'; } - XDB::execute("INSERT INTO #logger#.sessions + $uid = ($uid == 0) ? null : $uid; + $suid = ($suid == 0) ? null : $suid; + XDB::execute("INSERT INTO log_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) { @@ -88,7 +90,7 @@ class PlatalLogger extends PlLogger } public function saveLastSession() { - XDB::execute('REPLACE INTO #logger#.last_sessions (uid, id) + XDB::execute('REPLACE INTO log_last_sessions (uid, id) VALUES ({?}, {?})', $this->uid, $this->session); } @@ -106,7 +108,7 @@ class PlatalLogger extends PlLogger public function log($action, $data = null) { if (isset($this->actions[$action])) { - XDB::execute("INSERT INTO #logger#.events + XDB::execute("INSERT INTO log_events SET session={?}, action={?}, data={?}", $this->session, $this->actions[$action], $data); } else {