[phpbbreloaded-checkins] SF.net SVN: phpbbreloaded: [253] phpBB Reloaded 2/install
Status: Planning
Brought to you by:
tehphpmaster
Menu
▾
▴
[phpbbreloaded-checkins] SF.net SVN: phpbbreloaded: [253] phpBB Reloaded 2/install
|
From: <kla...@us...> - 2006-10-22 05:09:27
|
Revision: 253
http://svn.sourceforge.net/phpbbreloaded/?rev=253&view=rev
Author: klarinetking
Date: 2006-10-21 22:09:18 -0700 (Sat, 21 Oct 2006)
Log Message:
-----------
Fixing a few schema mistakes. (TO MODDERS: Be careful when applying changes.)
Modified Paths:
--------------
phpBB Reloaded 2/install/cookie.php
phpBB Reloaded 2/install/schemas/mysql_basic.sql
phpBB Reloaded 2/install/schemas/mysql_schema.sql
Modified: phpBB Reloaded 2/install/cookie.php
===================================================================
--- phpBB Reloaded 2/install/cookie.php 2006-09-29 03:18:48 UTC (rev 252)
+++ phpBB Reloaded 2/install/cookie.php 2006-10-22 05:09:18 UTC (rev 253)
@@ -67,67 +67,67 @@
// this is a security precaution to prevent someone
// trying to break out of a SQL statement.
//
-if( !get_magic_quotes_gpc() )
+if (!get_magic_quotes_gpc())
{
- if( is_array($HTTP_GET_VARS) )
- {
- while( list($k, $v) = each($HTTP_GET_VARS) )
- {
- if( is_array($HTTP_GET_VARS[$k]) )
- {
- while( list($k2, $v2) = each($HTTP_GET_VARS[$k]) )
- {
- $HTTP_GET_VARS[$k][$k2] = addslashes($v2);
- }
- @reset($HTTP_GET_VARS[$k]);
- }
- else
- {
- $HTTP_GET_VARS[$k] = addslashes($v);
- }
- }
- @reset($HTTP_GET_VARS);
- }
+ if (@is_array($HTTP_GET_VARS))
+ {
+ while (list($k, $v) = each($HTTP_GET_VARS))
+ {
+ if (is_array($HTTP_GET_VARS[$k]))
+ {
+ while (list($k2, $v2) = each($HTTP_GET_VARS[$k]))
+ {
+ $HTTP_GET_VARS[$k][$k2] = addslashes($v2);
+ }
+ @reset($HTTP_GET_VARS[$k]);
+ }
+ else
+ {
+ $HTTP_GET_VARS[$k] = addslashes($v);
+ }
+ }
+ @reset($HTTP_GET_VARS);
+ }
- if( is_array($HTTP_POST_VARS) )
- {
- while( list($k, $v) = each($HTTP_POST_VARS) )
- {
- if( is_array($HTTP_POST_VARS[$k]) )
- {
- while( list($k2, $v2) = each($HTTP_POST_VARS[$k]) )
- {
- $HTTP_POST_VARS[$k][$k2] = addslashes($v2);
- }
- @reset($HTTP_POST_VARS[$k]);
- }
- else
- {
- $HTTP_POST_VARS[$k] = addslashes($v);
- }
- }
- @reset($HTTP_POST_VARS);
- }
+ if (@is_array($HTTP_POST_VARS))
+ {
+ while (list($k, $v) = each($HTTP_POST_VARS))
+ {
+ if (is_array($HTTP_POST_VARS[$k]))
+ {
+ while (list($k2, $v2) = each($HTTP_POST_VARS[$k]))
+ {
+ $HTTP_POST_VARS[$k][$k2] = addslashes($v2);
+ }
+ @reset($HTTP_POST_VARS[$k]);
+ }
+ else
+ {
+ $HTTP_POST_VARS[$k] = addslashes($v);
+ }
+ }
+ @reset($HTTP_POST_VARS);
+ }
- if( is_array($HTTP_COOKIE_VARS) )
- {
- while( list($k, $v) = each($HTTP_COOKIE_VARS) )
- {
- if( is_array($HTTP_COOKIE_VARS[$k]) )
- {
- while( list($k2, $v2) = each($HTTP_COOKIE_VARS[$k]) )
- {
- $HTTP_COOKIE_VARS[$k][$k2] = addslashes($v2);
- }
- @reset($HTTP_COOKIE_VARS[$k]);
- }
- else
- {
- $HTTP_COOKIE_VARS[$k] = addslashes($v);
- }
- }
- @reset($HTTP_COOKIE_VARS);
- }
+ if (@is_array($HTTP_COOKIE_VARS))
+ {
+ while (list($k, $v) = each($HTTP_COOKIE_VARS))
+ {
+ if (is_array($HTTP_COOKIE_VARS[$k]))
+ {
+ while (list($k2, $v2) = each($HTTP_COOKIE_VARS[$k]))
+ {
+ $HTTP_COOKIE_VARS[$k][$k2] = addslashes($v2);
+ }
+ @reset($HTTP_COOKIE_VARS[$k]);
+ }
+ else
+ {
+ $HTTP_COOKIE_VARS[$k] = addslashes($v);
+ }
+ }
+ @reset($HTTP_COOKIE_VARS);
+ }
}
Modified: phpBB Reloaded 2/install/schemas/mysql_basic.sql
===================================================================
--- phpBB Reloaded 2/install/schemas/mysql_basic.sql 2006-09-29 03:18:48 UTC (rev 252)
+++ phpBB Reloaded 2/install/schemas/mysql_basic.sql 2006-10-22 05:09:18 UTC (rev 253)
@@ -7,8 +7,8 @@
-- Dumping data for table phpbb_agreement
--
-INSERT INTO phpbb_agreement (id,agreement_text) VALUES
-('1','While the administrators and moderators of this forum will attempt to remove or edit any generally objectionable material as quickly as possible, it is impossible to review every message. Therefore you acknowledge that all posts made to these forums express the views and opinions of the author and not the administrators, moderators or webmaster (except for posts by these people) and hence will not be held liable.<br /><br />You agree not to post any abusive, obscene, vulgar, slanderous, hateful, threatening, sexually-oriented or any other material that may violate any applicable laws. Doing so may lead to you being immediately and permanently banned (and your service provider being informed). The IP address of all posts is recorded to aid in enforcing these conditions. You agree that the webmaster, administrator and moderators of this forum have the right to remove, edit, move or close any topic at any time should they see fit. As a user you agree to any information you have entered above being stored in a database. While this information will not be disclosed to any third party without your consent the webmaster, administrator and moderators cannot be held responsible for any hacking attempt that may lead to the data being compromised.<br /><br />This forum system uses cookies to store information on your local computer. These cookies do not contain any of the information you have entered above; they serve only to improve your viewing pleasure. The e-mail address is used only for confirming your registration details and password (and for sending new passwords should you forget your current one).<br /><br />By clicking Register below you agree to be bound by these conditions.');
+INSERT INTO phpbb_agreement VALUES
+('1', 'While the administrators and moderators of this forum will attempt to remove or edit any generally objectionable material as quickly as possible, it is impossible to review every message. Therefore you acknowledge that all posts made to these forums express the views and opinions of the author and not the administrators, moderators or webmaster (except for posts by these people) and hence will not be held liable.<br /><br />You agree not to post any abusive, obscene, vulgar, slanderous, hateful, threatening, sexually-oriented or any other material that may violate any applicable laws. Doing so may lead to you being immediately and permanently banned (and your service provider being informed). The IP address of all posts is recorded to aid in enforcing these conditions. You agree that the webmaster, administrator and moderators of this forum have the right to remove, edit, move or close any topic at any time should they see fit. As a user you agree to any information you have entered above being stored in a database. While this information will not be disclosed to any third party without your consent the webmaster, administrator and moderators cannot be held responsible for any hacking attempt that may lead to the data being compromised.<br /><br />This forum system uses cookies to store information on your local computer. These cookies do not contain any of the information you have entered above; they serve only to improve your viewing pleasure. The e-mail address is used only for confirming your registration details and password (and for sending new passwords should you forget your current one).<br /><br />By clicking Register below you agree to be bound by these conditions.');
--
-- Dumping data for table phpbb_attachments_config
@@ -778,7 +778,7 @@
-- Dumping data for table phpbb_search_results
--
-INSERT INTO phpbb_search_results VALUES (1387010399, '92eda8dfcd3f66441e726a531ec8fa55', 'a:8:{s:14:"search_results";s:13:"2, 3, 4, 5, 6";s:17:"total_match_count";i:5;s:12:"split_search";N;s:7:"sort_by";i:0;s:8:"sort_dir";s:4:"DESC";s:12:"show_results";s:5:"posts";s:12:"return_chars";i:200;s:7:"no_subs";b:0;}');
+INSERT INTO phpbb_search_results VALUES (1387010399, '92eda8dfcd3f66441e726a531ec8fa55', 'a:8:{s:14:"search_results";s:13:"2, 3, 4, 5, 6";s:17:"total_match_count";i:5;s:12:"split_search";N;s:7:"sort_by";i:0;s:8:"sort_dir";s:4:"DESC";s:12:"show_results";s:5:"posts";s:12:"return_chars";i:200;s:7:"no_subs";b:0;}', '0');
--
-- Dumping data for table phpbb_search_wordlist
Modified: phpBB Reloaded 2/install/schemas/mysql_schema.sql
===================================================================
--- phpBB Reloaded 2/install/schemas/mysql_schema.sql 2006-09-29 03:18:48 UTC (rev 252)
+++ phpBB Reloaded 2/install/schemas/mysql_schema.sql 2006-10-22 05:09:18 UTC (rev 253)
@@ -8,8 +8,9 @@
--
CREATE TABLE phpbb_agreement (
-id int(8) not null,
-agreement_text text);
+ id int(8) NOT NULL default '',
+ agreement_text text
+) TYPE=MyISAM;
--
-- Table structure for table `phpbb_attach_quota`
@@ -575,7 +576,7 @@
search_id int(11) unsigned NOT NULL default '0',
session_id varchar(32) NOT NULL default '',
search_array text NOT NULL,
- search_time int(11) DEFAULT '0' NOT NULL;
+ search_time int(11) DEFAULT '0' NOT NULL,
PRIMARY KEY (search_id),
KEY session_id (session_id)
) TYPE=MyISAM;
This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.
|
