Changeset 647 for trunk/include/user.inc.php

Timestamp:

Dec 18, 2004, 11:05:30 PM (19 years ago)

Author:

plg

Message:

• bug fixed : in admin/cat_list, next_rank cant' be calculted and query to count sub-categories per sub-categories became false if no sub-categories

• virtual association come back in admin/infos_images (not only in admin/picture_modify)

• check_favorites function in admin section becomes check_user_favorites in public section : favorites are checked when user tries to display his favorites. Function was optimized.

• in function update_category, wrap of long queries due to many categories to update at the same time

• typo fixed in description of paginate_pages_around configuration parameter

• bug fixed in new navigation bar : no separation pipe was displayed between next and last when the page displayed was the last

• sessions.expiration changed of type from int to datetime (a lot easier to read)

• sessions.ip removed : IP address is no longer used to verify session

• $langcat_options was missing in en_UK.iso-8859-1

• typo fixed in language/en_UK.iso-8859-1/admin.lang.php on editcat_lock_info language item

File:

• trunk/include/user.inc.php (modified) (2 diffs)

trunk/include/user.inc.php

@@ -60 +60 @@
   $page['session_id'] = $session_id;
   $query = '
-SELECT user_id,expiration,ip
+SELECT user_id,expiration,NOW() AS now
   FROM '.SESSIONS_TABLE.'
   WHERE id = \''.$page['session_id'].'\'
@@ -68 +68 @@
   {
     $row = mysql_fetch_array($result);
-    if (!$user['has_cookie'])
+    if (strnatcmp($row['expiration'], $row['now']) < 0)
     {
-      if ($row['expiration'] < time())
-      {
-        // deletion of the session from the database,
-        // because it is out-of-date
-        $delete_query = 'DELETE FROM '.SESSIONS_TABLE;
-        $delete_query.= " WHERE id = '".$page['session_id']."'";
-        $delete_query.= ';';
-        pwg_query($delete_query);
-      }
-      else if ($_SERVER['REMOTE_ADDR'] == $row['ip'])
-      {
-        $query_user .= ' WHERE id = '.$row['user_id'];
-        $query_done = true;
-      }
+      // deletion of the session from the database, because it is
+      // out-of-date
+      $delete_query = '
+DELETE FROM '.SESSIONS_TABLE.'
+  WHERE id = \''.$page['session_id'].'\'
+;';
+      pwg_query($delete_query);
     }
     else