[phpMP-CVS] CVS: phpMP/includes auth.php,1.16,1.17 sessions.php,1.3,1.4

[Brian R. <hei...@us...>]

Update of /cvsroot/phpmp/phpMP/includes
In directory usw-pr-cvs1:/tmp/cvs-serv5237/includes

Modified Files:
	auth.php sessions.php 
Log Message:
Updated MySQL database structure.  Fixed session cleanup problem (by adding
an extra function that should work fine).

Index: auth.php
===================================================================
RCS file: /cvsroot/phpmp/phpMP/includes/auth.php,v
retrieving revision 1.16
retrieving revision 1.17
diff -C2 -r1.16 -r1.17
*** auth.php	29 Jul 2002 11:13:04 -0000	1.16
--- auth.php	31 Jul 2002 17:48:38 -0000	1.17
***************
*** 43,49 ****
--- 43,66 ----
    var $mpcookie;
  
+   function session_cleanup() {
+     
+     global $MPCONF, $DBA;
+     
+     $rand_val = rand(0, 10);
+     if($rand_val > 8) {
+       
+       $result = $DBA->query("DELETE FROM " . $MPCONF['DB']['table_prefix'] . "sessions WHERE expiretime < " . time());
+       
+       return $DBA->affected_rows();
+       
+     }
+     
+   }
+ 
    function AuthUser() {
    
      global $MPCONF, $Functions, $DBA, $HTTP_POST_VARS;
+     
+     $this->session_cleanup();
      
      if(empty($HTTP_POST_VARS['username'])) {

Index: sessions.php
===================================================================
RCS file: /cvsroot/phpmp/phpMP/includes/sessions.php,v
retrieving revision 1.3
retrieving revision 1.4
diff -C2 -r1.3 -r1.4
*** sessions.php	27 Jul 2002 12:16:00 -0000	1.3
--- sessions.php	31 Jul 2002 17:48:38 -0000	1.4
***************
*** 85,89 ****
          global $MPCONF, $DBA;
          
!         $retval = mysql_query("DELETE FROM " . $MPCONF['DB']['table_prefix'] . "sessions WHERE expiretime < " . time()); 
          
          return $DBA->affected_rows(); 
--- 85,89 ----
          global $MPCONF, $DBA;
          
!         $retval = $DBA->query("DELETE FROM " . $MPCONF['DB']['table_prefix'] . "sessions WHERE expiretime < " . time()); 
          
          return $DBA->affected_rows();