| | |
| | | if ($CACHE_KEYS[$key]) |
| | | { |
| | | $DB->query("UPDATE ".get_table_name('cache')." |
| | | SET created=NOW(), |
| | | SET created=now(), |
| | | data=? |
| | | WHERE user_id=? |
| | | AND cache_key=?", |
| | |
| | | { |
| | | $DB->query("INSERT INTO ".get_table_name('cache')." |
| | | (created, user_id, session_id, cache_key, data) |
| | | VALUES (NOW(), ?, ?, ?, ?)", |
| | | VALUES (now(), ?, ?, ?, ?)", |
| | | $_SESSION['user_id'], |
| | | $session_cache ? $sess_id : 'NULL', |
| | | $key, |
| | |
| | | |
| | | // update user's record |
| | | $DB->query("UPDATE ".get_table_name('users')." |
| | | SET last_login=NOW() |
| | | SET last_login=now() |
| | | WHERE user_id=?", |
| | | $user_id); |
| | | } |
| | |
| | | |
| | | $DB->query("INSERT INTO ".get_table_name('users')." |
| | | (created, last_login, username, mail_host, language) |
| | | VALUES (NOW(), NOW(), ?, ?, ?)", |
| | | VALUES (now(), now(), ?, ?, ?)", |
| | | $user, |
| | | $host, |
| | | $_SESSION['user_lang']); |
| | |
| | | session_decode($vars); |
| | | $DB->query("UPDATE ".get_table_name('session')." |
| | | SET vars=?, |
| | | changed=NOW() |
| | | changed=now() |
| | | WHERE sess_id=?", |
| | | $vars, |
| | | $key); |
| | |
| | | { |
| | | $DB->query("INSERT INTO ".get_table_name('session')." |
| | | (sess_id, vars, ip, created, changed) |
| | | VALUES (?, ?, ?, NOW(), NOW())", |
| | | VALUES (?, ?, ?, now(), now())", |
| | | $key, |
| | | $vars, |
| | | $_SERVER['REMOTE_ADDR']); |
| | |
| | | // get all expired sessions |
| | | $sql_result = $DB->query("SELECT sess_id |
| | | FROM ".get_table_name('session')." |
| | | WHERE ".$DB->unixtimestamp('NOW()')."-".$DB->unixtimestamp('created')." > ?", |
| | | WHERE ".$DB->unixtimestamp('now()')."-".$DB->unixtimestamp('created')." > ?", |
| | | $maxlifetime); |
| | | |
| | | $a_exp_sessions = array(); |