Rev 119 | Rev 188 | Go to most recent revision | Show entire file | Regard whitespace | Details | Blame | Last modification | View Log | RSS feed
Rev 119 | Rev 150 | ||
---|---|---|---|
Line 107... | Line 107... | ||
107 | } |
107 | } |
108 | } |
108 | } |
109 | 109 | ||
110 | // Now write the log message |
110 | // Now write the log message |
111 | 111 | ||
112 | $addr = isset($_SERVER['REMOTE_ADDR']) ? "'".OIDplus::db()->real_escape_string($_SERVER['REMOTE_ADDR'])."'" : "null"; |
112 | $addr = isset($_SERVER['REMOTE_ADDR']) ? $_SERVER['REMOTE_ADDR'] : null; |
113 | OIDplus::db()->query("insert into ".OIDPLUS_TABLENAME_PREFIX."log (addr, unix_ts, event) values ($addr, UNIX_TIMESTAMP(), '".OIDplus::db()->real_escape_string($event)."')"); |
113 | OIDplus::db()->query("insert into ".OIDPLUS_TABLENAME_PREFIX."log (addr, unix_ts, event) values (?, UNIX_TIMESTAMP(), ?)", array($addr, $event)); |
114 | $log_id = OIDplus::db()->insert_id(); |
114 | $log_id = OIDplus::db()->insert_id(); |
- | 115 | if ($log_id === false) { |
|
- | 116 | $res = OIDplus::db()->query("select max(id) as last_id from ".OIDPLUS_TABLENAME_PREFIX."log"); |
|
- | 117 | $row = OIDplus::db()->fetch_array($res); |
|
- | 118 | $log_id = $row['last_id']; |
|
- | 119 | } |
|
115 | 120 | ||
116 | foreach ($objects as $object) { |
121 | foreach ($objects as $object) { |
117 | OIDplus::db()->query("insert into ".OIDPLUS_TABLENAME_PREFIX."log_object (log_id, object) values ($log_id, '".OIDplus::db()->real_escape_string($object)."')"); |
122 | OIDplus::db()->query("insert into ".OIDPLUS_TABLENAME_PREFIX."log_object (log_id, object) values (?, ?)", array($log_id, $object)); |
118 | } |
123 | } |
119 | 124 | ||
120 | foreach ($users as $user) { |
125 | foreach ($users as $user) { |
121 | OIDplus::db()->query("insert into ".OIDPLUS_TABLENAME_PREFIX."log_user (log_id, user) values ($log_id, '".OIDplus::db()->real_escape_string($user)."')"); |
126 | OIDplus::db()->query("insert into ".OIDPLUS_TABLENAME_PREFIX."log_user (log_id, user) values (?, ?)", array($log_id, $user)); |
122 | } |
127 | } |
123 | 128 | ||
124 | } |
129 | } |
125 | } |
130 | } |