diff options
| author | Paul S. Owen <psotfx@users.sourceforge.net> | 2001-02-23 00:22:10 +0000 |
|---|---|---|
| committer | Paul S. Owen <psotfx@users.sourceforge.net> | 2001-02-23 00:22:10 +0000 |
| commit | 8f193b2a39b6e8f5796ff25933440353151ef8ce (patch) | |
| tree | 5bc0c430042349ecd530f7c98fbdbf240e637143 /phpBB/functions | |
| parent | acfee8f3f16416a1e68e359eb7412dfbbc697096 (diff) | |
| download | forums-8f193b2a39b6e8f5796ff25933440353151ef8ce.tar forums-8f193b2a39b6e8f5796ff25933440353151ef8ce.tar.gz forums-8f193b2a39b6e8f5796ff25933440353151ef8ce.tar.bz2 forums-8f193b2a39b6e8f5796ff25933440353151ef8ce.tar.xz forums-8f193b2a39b6e8f5796ff25933440353151ef8ce.zip | |
Switch table naming vars to constants
git-svn-id: file:///svn/phpbb/trunk@21 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB/functions')
| -rw-r--r-- | phpBB/functions/auth.php | 10 | ||||
| -rw-r--r-- | phpBB/functions/sessions.php | 10 |
2 files changed, 10 insertions, 10 deletions
diff --git a/phpBB/functions/auth.php b/phpBB/functions/auth.php index 5d82b404f9..c1c1acc74f 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_table + $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_table"; + $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_table + $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_table 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_table 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 bdee756f30..aa3d5f0ae3 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_tables WHERE (start_time < $expirytime)"; + $deleteSQL = "DELETE FROM ".SESSIONS_TABLE." 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_table (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); @@ -86,7 +86,7 @@ function get_userid_from_session($sessid, $cookietime, $remote_ip, $db) { $mintime = time() - $cookietime; $sql = "SELECT user_id - FROM $sessions_table + FROM ".SESSIONS_TABLE." WHERE (sess_id = $sessid) AND (start_time > $mintime) AND (remote_ip = '$remote_ip')"; @@ -113,7 +113,7 @@ function update_session_time($sessid, $db) { $newtime = (string) time(); - $sql = "UPDATE $sessions_table 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_table WHERE (user_id = $userid)"; + $sql = "DELETE FROM ".SESSIONS_TABLE." WHERE (user_id = $userid)"; $result = $db->sql_query($sql, $db); if (!$result) { |