/** * Garbage Collector * @param int life time (sec.) * @return bool * @see session.gc_divisor 100 * @see session.gc_maxlifetime 1440 * @see session.gc_probability 1 * @usage execution rate 1/100 * (session.gc_probability/session.gc_divisor) */ public static function gc($max) { dbcommit("delete from sys_sessions where unix_timestamp(lastupdate) + " . $max . " < unix_timestamp(now())"); return true; $sql = sprintf("DELETE FROM `sessions` WHERE `session_expires` < '%s'", mysql_real_escape_string(time() - $max)); return mysql_query($sql, self::$_sess_db); }
function dbdelete($table, $where = [1 => 0]) { $whparts = []; foreach ($where as $k => $v) { $whparts[] = $k . ' = "' . mysqli_real_escape_string($msq, $v) . '"'; } $q = "delete from " . $table . " where " . implode(" and ", $whparts); return dbcommit($q); }