diff options
Diffstat (limited to 'phpBB/functions')
| -rw-r--r-- | phpBB/functions/auth.php | 10 | ||||
| -rw-r--r-- | phpBB/functions/sessions.php | 18 |
2 files changed, 14 insertions, 14 deletions
diff --git a/phpBB/functions/auth.php b/phpBB/functions/auth.php index beacb39262..5d82b404f9 100644 --- a/phpBB/functions/auth.php +++ b/phpBB/functions/auth.php @@ -46,11 +46,11 @@ function auth($type, switch($type) { case 'ip ban': - $sql = "DELETE FROM banlist + $sql = "DELETE FROM $banlist_table WHERE (ban_end < ". mktime(date("H"), date("i"), date("s"), date("m"), date("d"), date("Y")).") AND (ban_end > 0)"; $db->sql_query($sql); - $sql = "SELECT ban_ip FROM banlist"; + $sql = "SELECT ban_ip FROM $banlist_table"; if($result = $db->sql_query($sql)) { if($totalrows = $db->sql_numrows()) @@ -92,11 +92,11 @@ function auth($type, return(TRUE); break; case 'username ban': - $sql = "DELETE FROM banlist + $sql = "DELETE FROM $banlist_table WHERE (ban_end < ". mktime(date("H"), date("i"), date("s"), date("m"), date("d"), date("Y")).") AND (ban_end > 0)"; $db->sql_query($sql); - $sql = "SELECT ban_userid FROM banlist WHERE ban_userid = '$user_id'"; + $sql = "SELECT ban_userid FROM $banlist_table WHERE ban_userid = '$user_id'"; if($result = $db->sql_query($sql)) { if($db->sql_numrows()) @@ -124,7 +124,7 @@ function auth($type, function get_userdata_from_id($userid, $db) { - $sql = "SELECT * FROM users WHERE user_id = $userid"; + $sql = "SELECT * FROM $users_table WHERE user_id = $userid"; if(!$result = $db->sql_query($sql)) { $userdata = array("error" => "1"); diff --git a/phpBB/functions/sessions.php b/phpBB/functions/sessions.php index 60f2ae7015..bdee756f30 100644 --- a/phpBB/functions/sessions.php +++ b/phpBB/functions/sessions.php @@ -38,7 +38,7 @@ function new_session($userid, $remote_ip, $lifespan, $db) $currtime = (string) (time()); $expirytime = (string) (time() - $lifespan); - $deleteSQL = "DELETE FROM sessions WHERE (start_time < $expirytime)"; + $deleteSQL = "DELETE FROM $sessions_tables WHERE (start_time < $expirytime)"; $delresult = $db->sql_query($deleteSQL); if (!$delresult) @@ -46,7 +46,7 @@ function new_session($userid, $remote_ip, $lifespan, $db) error_die($db, SESSION_CREATE); } - $sql = "INSERT INTO sessions (sess_id, user_id, start_time, remote_ip) VALUES ($sessid, $userid, $currtime, '$remote_ip')"; + $sql = "INSERT INTO $sessions_table (sess_id, user_id, start_time, remote_ip) VALUES ($sessid, $userid, $currtime, '$remote_ip')"; $result = $db->sql_query($sql); @@ -85,11 +85,11 @@ function set_session_cookie($sessid, $cookietime, $cookiename, $cookiepath, $coo function get_userid_from_session($sessid, $cookietime, $remote_ip, $db) { $mintime = time() - $cookietime; - $sql = "SELECT user_id - FROM sessions - WHERE (sess_id = $sessid) - AND (start_time > $mintime) - AND (remote_ip = '$remote_ip')"; + $sql = "SELECT user_id + FROM $sessions_table + WHERE (sess_id = $sessid) + AND (start_time > $mintime) + AND (remote_ip = '$remote_ip')"; $result = $db->sql_query($sql); if (!$result) { @@ -113,7 +113,7 @@ function update_session_time($sessid, $db) { $newtime = (string) time(); - $sql = "UPDATE sessions SET start_time=$newtime WHERE (sess_id = $sessid)"; + $sql = "UPDATE $sessions_table SET start_time=$newtime WHERE (sess_id = $sessid)"; $result = $db->sql_query($sql); if (!$result) { @@ -126,7 +126,7 @@ function update_session_time($sessid, $db) function end_user_session($userid, $db) { - $sql = "DELETE FROM sessions WHERE (user_id = $userid)"; + $sql = "DELETE FROM $sessions_table WHERE (user_id = $userid)"; $result = $db->sql_query($sql, $db); if (!$result) { |