[Shuttlebb-svn] SF.net SVN: shuttlebb: [76] branch
Brought to you by:
afterlife69,
danb00
|
From: <aft...@us...> - 2006-12-04 13:29:53
|
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.
|