[Shuttlebb-svn] SF.net SVN: shuttlebb: [76] branch

[<aft...@us...>]

Revision: 76
          http://svn.sourceforge.net/shuttlebb/?rev=76&view=rev
Author:   afterlife69
Date:     2006-12-04 05:29:48 -0800 (Mon, 04 Dec 2006)

Log Message:
-----------
dumb the schema in a db called "sbb" and run :)

Modified Paths:
--------------
    branch/index.php
    branch/require/configuration.php
    branch/sources/class_user.php
    branch/sources/dbal/dbal_mysql.php
    branch/sources/dbal/dbal_mysqli.php

Added Paths:
-----------
    branch/db_schema.sql

Added: branch/db_schema.sql
===================================================================
--- branch/db_schema.sql	                        (rev 0)
+++ branch/db_schema.sql	2006-12-04 13:29:48 UTC (rev 76)
@@ -0,0 +1,39 @@
+CREATE TABLE `sbb_users` (
+  `user_id` int(255) NOT NULL auto_increment,
+  `username` varchar(255) NOT NULL,
+  `password` varchar(32) NOT NULL,
+  `user_email` text NOT NULL,
+  `user_active` tinyint(1) NOT NULL,
+  `user_code` varchar(12) NOT NULL,
+  `user_msn` varchar(255) default NULL,
+  `user_icq` int(255) default NULL,
+  `user_yim` varchar(255) default NULL,
+  `user_aim` varchar(255) default NULL,
+  `user_sig` text collate latin1_general_ci,
+  `user_rank` int(255) NOT NULL,
+  `user_web` varchar(255) default NULL,
+  `user_ip` varchar(255) NOT NULL,
+  PRIMARY KEY  (`user_id`)
+);
+
+CREATE TABLE `sbb_config` (
+  `config_key` varchar(90) NOT NULL,
+  `config_value` text NOT NULL,
+  PRIMARY KEY  (`config_key`)
+);
+
+CREATE TABLE `sbb_session_keys` (
+  `key_name` varchar(16) NOT NULL,
+  `key_expire` int(90) NOT NULL,
+  `user_id` int(255) NOT NULL,
+  PRIMARY KEY  (`key_name`)
+);
+
+CREATE TABLE `sbb_sessions` (
+  `session_id` varchar(32) NOT NULL,
+  `session_ip` varchar(15) NOT NULL,
+  `session_agent` varchar(255) NOT NULL,
+  `session_time` int(20) NOT NULL,
+  `session_page` int(10) NOT NULL,
+  `user_id` int(255) NOT NULL
+);
\ No newline at end of file


Property changes on: branch/db_schema.sql
___________________________________________________________________
Name: svn:keywords
   + Author Date Id Revision
Name: svn:eol-style
   + native

Modified: branch/index.php
===================================================================
--- branch/index.php	2006-12-04 13:17:07 UTC (rev 75)
+++ branch/index.php	2006-12-04 13:29:48 UTC (rev 76)
@@ -35,6 +35,8 @@
 handler_load('class_template', 'template');
 handler_load('class_dbal', 'dbal');
 handler_load('class_module_loader', 'module_loader');
+handler_load('class_access_control', 'acl_core');
+handler_load('class_language', 'language');
 
 // Construct required objects
 

Modified: branch/require/configuration.php
===================================================================
--- branch/require/configuration.php	2006-12-04 13:17:07 UTC (rev 75)
+++ branch/require/configuration.php	2006-12-04 13:29:48 UTC (rev 76)
@@ -13,6 +13,7 @@
 define('DB_PASS', '');
 define('DB_NAME', 'sbb');
 define('DB_SERVER', 'localhost');
+define('DB_LAYER', 'mysql');
 define('DB_PERSISTANT', 1);
 define('DB_PREFIX', 'sbb_');
 

Modified: branch/sources/class_user.php
===================================================================
--- branch/sources/class_user.php	2006-12-04 13:17:07 UTC (rev 75)
+++ branch/sources/class_user.php	2006-12-04 13:29:48 UTC (rev 76)
@@ -312,7 +312,7 @@
 			$db->sql_query('DELETE FROM ' . SESSIONS_KEY_TABLE . ' WHERE user_id = ' . (int) $this->session->data['user_id']);
 		}
 		
-		return $db->sql_update(SESSIONS_TABLE, array('user_id' => UNREGISTERED), false, false, 'session_id = \'' . $db->sql_escape($this->session->sid) . '\'')	
+		return $db->sql_update(SESSIONS_TABLE, array('user_id' => UNREGISTERED), false, false, 'session_id = \'' . $db->sql_escape($this->session->sid) . '\'');
 	}
 	
 	/**

Modified: branch/sources/dbal/dbal_mysql.php
===================================================================
--- branch/sources/dbal/dbal_mysql.php	2006-12-04 13:17:07 UTC (rev 75)
+++ branch/sources/dbal/dbal_mysql.php	2006-12-04 13:29:48 UTC (rev 76)
@@ -22,6 +22,7 @@
 class dbal_mysql
 {
 	var $conn_id;
+	var $queries;
 	
 	function dbal_mysql()
 	{
@@ -31,6 +32,8 @@
 			exit;
 		}
 		
+		$this->queries = array();
+		
 		return;
 	}
 	
@@ -51,7 +54,8 @@
 	function sql_query($sql)
 	{
 		// exec sql query
-		return @mysql_query($sql, $this->conn_id);
+		$this->queries[] = @mysql_query($sql, $this->conn_id);
+		return array_pop($this->queries);
 	}
 	
 	function sql_fetchrow($result, $type)

Modified: branch/sources/dbal/dbal_mysqli.php
===================================================================
--- branch/sources/dbal/dbal_mysqli.php	2006-12-04 13:17:07 UTC (rev 75)
+++ branch/sources/dbal/dbal_mysqli.php	2006-12-04 13:29:48 UTC (rev 76)
@@ -22,6 +22,7 @@
 class dbal_mysqli
 {
 	var $conn_id;
+	var $queries;
 
 	function dbal_mysqli()
 	{
@@ -31,6 +32,9 @@
 			trigger_error('Error_DB_Extension');
 			exit;
 		}
+		
+		$this->queries = array();
+		
 		return;
 	}
 	
@@ -50,7 +54,8 @@
 	function sql_query($sql)
 	{
 		// exec sql query
-		return $this->conn_id->query($sql);
+		$this->queries[] = $this->conn_id->query($sql);
+		return array_pop($this->queries);
 	}
 	
 	function sql_fetchrow($result, $type)


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.