[phpMP-CVS] CVS: phpMP/includes core.php,1.36,1.37 user.php,1.2,1.3

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

Update of /cvsroot/phpmp/phpMP/includes
In directory sc8-pr-cvs1:/tmp/cvs-serv12276/includes

Modified Files:
	core.php user.php 
Log Message:
Updated a bit of SQL.  Not quite complete, though (ok..no where close).
Also keeping up on the auth development.  This will be a challenge.


Index: core.php
===================================================================
RCS file: /cvsroot/phpmp/phpMP/includes/core.php,v
retrieving revision 1.36
retrieving revision 1.37
diff -C2 -r1.36 -r1.37
*** core.php	3 Dec 2002 06:37:33 -0000	1.36
--- core.php	3 Dec 2002 08:37:11 -0000	1.37
***************
*** 13,17 ****
  		define("CONFIG_TABLE", DB_NAME . '.' . DB_TABLE_PREFIX . 'config');
  		define("USERS_TABLE", DB_NAME . '.' . DB_TABLE_PREFIX . 'users');
! 		define("SESSION_TABLE", DB_NAME . '.' . DB_TABLE_PREFIX . 'sessions');
  		define("MODULES_TABLE", DB_NAME . '.' . DB_TABLE_PREFIX . 'modules');
  		define("BLOCK_TABLE", DB_NAME . '.' . DB_TABLE_PREFIX . 'blocks');
--- 13,17 ----
  		define("CONFIG_TABLE", DB_NAME . '.' . DB_TABLE_PREFIX . 'config');
  		define("USERS_TABLE", DB_NAME . '.' . DB_TABLE_PREFIX . 'users');
! 		define("SESSIONS_TABLE", DB_NAME . '.' . DB_TABLE_PREFIX . 'sessions');
  		define("MODULES_TABLE", DB_NAME . '.' . DB_TABLE_PREFIX . 'modules');
  		define("BLOCK_TABLE", DB_NAME . '.' . DB_TABLE_PREFIX . 'blocks');

Index: user.php
===================================================================
RCS file: /cvsroot/phpmp/phpMP/includes/user.php,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -r1.2 -r1.3
*** user.php	2 Dec 2002 22:21:07 -0000	1.2
--- user.php	3 Dec 2002 08:37:11 -0000	1.3
***************
*** 5,28 ****
  {
  
- 	var $array;
- 
  	function snapshot( $user )
  	{
! 	
  		global $DB;
! 		
  		$sql = "SELECT * FROM " . USERS_TABLE . " WHERE userid=$user";
! 		
  		$qry = $DB->query($sql);
! 		
! 		$this->array = $DB->fetchArray($qry);
  		
  	}
  	
  	function User()
  	{
! 	
  		// Must decide is this is an anonymous user or a registered user.
! 		
  		if( USE_PERMS == 1 )
  		{
--- 5,49 ----
  {
  
  	function snapshot( $user )
  	{
! 
  		global $DB;
! 
  		$sql = "SELECT * FROM " . USERS_TABLE . " WHERE userid=$user";
! 
  		$qry = $DB->query($sql);
! 
! 		$user_array = $DB->fetchArray($qry);
! 
! 		while( list ($key, $val) = each ($user_array) )
! 		{
! 			define( "U_" . $key, $val );
! 		}
  		
  	}
  	
+ 	function sessionClean()
+ 	{
+ 
+ 		global $DB;
+ 
+ 		$rand = rand(0,10);
+ 		if($rand >= 1)
+ 		{
+ 
+ 			$sql = "DELETE FROM " . SESSIONS_TABLE . " WHERE expiry<" . time();
+ 			$DB->query($sql);
+ 
+ 		}
+ 
+ 	}
+ 
  	function User()
  	{
! 
! 		$this->sessionClean();
! 
  		// Must decide is this is an anonymous user or a registered user.
! 
  		if( USE_PERMS == 1 )
  		{
***************
*** 32,36 ****
  			global $Auth;
  			
! 			include_once(PHPMP_ROOT . 'includes/auth.php');
  			$Auth = new Auth();
  			
--- 53,57 ----
  			global $Auth;
  			
! 			include_once( PHPMP_ROOT . 'includes/auth.php' );
  			$Auth = new Auth();
  			
***************
*** 49,51 ****
  }
  
! ?>
\ No newline at end of file
--- 70,72 ----
  }
  
! ?>