Thread: [phpbbreloaded-checkins] SF.net SVN: phpbbreloaded: [239] phpBB Reloaded 2/install
Status: Planning
Brought to you by:
tehphpmaster
Menu
▾
▴
phpbbreloaded-checkins
|
From: <mar...@us...> - 2006-06-20 22:11:11
|
Revision: 239 Author: markthedaemon Date: 2006-06-20 15:11:01 -0700 (Tue, 20 Jun 2006) ViewCVS: http://svn.sourceforge.net/phpbbreloaded/?rev=239&view=rev Log Message: ----------- Modified Paths: -------------- phpBB Reloaded 2/install/cookie.php phpBB Reloaded 2/install/schemas/mysql_schema.sql phpBB Reloaded 2/install/update_to_latest.php Modified: phpBB Reloaded 2/install/cookie.php =================================================================== --- phpBB Reloaded 2/install/cookie.php 2006-06-20 22:10:05 UTC (rev 238) +++ phpBB Reloaded 2/install/cookie.php 2006-06-20 22:11:01 UTC (rev 239) @@ -533,16 +533,16 @@ <meta http-equiv="Content-Type" content="text/html; charset=<?php echo $lang['ENCODING']; ?>"> <meta http-equiv="Content-Style-Type" content="text/css"> <title><?php echo $cookie_lang['Welcome_cookie'];?></title> -<link rel="stylesheet" href="../templates/subSilver/subSilver.css" type="text/css"> +<link rel="stylesheet" href="../templates/subC1/subC1.css" type="text/css"> <style type="text/css"> <!-- -th { background-image: url('../templates/subSilver/images/cellpic3.gif') } -td.cat { background-image: url('../templates/subSilver/images/cellpic1.gif') } -td.rowpic { background-image: url('../templates/subSilver/images/cellpic2.jpg'); background-repeat: repeat-y } -td.catHead,td.catSides,td.catLeft,td.catRight,td.catBottom { background-image: url('../templates/subSilver/images/cellpic1.gif') } +th { background-image: url('../templates/subC1/images/cellpic3.gif') } +td.cat { background-image: url('../templates/subC1/images/cellpic1.gif') } +td.rowpic { background-image: url('../templates/subC1/images/cellpic2.jpg'); background-repeat: repeat-y } +td.catHead,td.catSides,td.catLeft,td.catRight,td.catBottom { background-image: url('../templates/subC1/images/cellpic1.gif') } /* Import the fancy styles for IE only (NS4.x doesn't use the @import function) */ -@import url("../templates/subSilver/formIE.css"); +@import url("../templates/subC1/formIE.css"); //--> </style> </head> @@ -554,7 +554,7 @@ <tr> <td><table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> - <td><img src="../templates/subSilver/images/logo_phpBB.gif" border="0" alt="Forum Home" vspace="1" /></td> + <td><img src="../templates/subC1/images/logo_phpBB.gif" border="0" alt="Forum Home" vspace="1" /></td> <td align="center" width="100%" valign="middle"><span class="maintitle"><?php echo $cookie_lang['Welcome_cookie'];?></span></td> </tr> </table></td> Modified: phpBB Reloaded 2/install/schemas/mysql_schema.sql =================================================================== --- phpBB Reloaded 2/install/schemas/mysql_schema.sql 2006-06-20 22:10:05 UTC (rev 238) +++ phpBB Reloaded 2/install/schemas/mysql_schema.sql 2006-06-20 22:11:01 UTC (rev 239) @@ -575,6 +575,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; PRIMARY KEY (search_id), KEY session_id (session_id) ) TYPE=MyISAM; Modified: phpBB Reloaded 2/install/update_to_latest.php =================================================================== --- phpBB Reloaded 2/install/update_to_latest.php 2006-06-20 22:10:05 UTC (rev 238) +++ phpBB Reloaded 2/install/update_to_latest.php 2006-06-20 22:11:01 UTC (rev 239) @@ -207,7 +207,17 @@ VALUES ('search_min_chars', '3')"; break; } + case '.2.1': + switch (SQL_LAYER) + { + case 'mysql': + case 'mysql4': + $sql[] = "ALTER TABLE " . SEARCH_TABLE . " + ADD COLUMN search_time int(11) DEFAULT '0' NOT NULL"; + break; } + + } echo "<h2>Updating database schema</h2>\n"; echo "<p>Progress :: <b>"; flush(); This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |
|
From: <mar...@us...> - 2006-06-20 22:51:00
|
Revision: 245 Author: markthedaemon Date: 2006-06-20 15:50:51 -0700 (Tue, 20 Jun 2006) ViewCVS: http://svn.sourceforge.net/phpbbreloaded/?rev=245&view=rev Log Message: ----------- Modified Paths: -------------- phpBB Reloaded 2/install/schemas/mysql_basic.sql phpBB Reloaded 2/install/update_to_latest.php Modified: phpBB Reloaded 2/install/schemas/mysql_basic.sql =================================================================== --- phpBB Reloaded 2/install/schemas/mysql_basic.sql 2006-06-20 22:35:48 UTC (rev 244) +++ phpBB Reloaded 2/install/schemas/mysql_basic.sql 2006-06-20 22:50:51 UTC (rev 245) @@ -275,7 +275,7 @@ INSERT INTO phpbb_config VALUES ('server_name', 'localhost', 1); INSERT INTO phpbb_config VALUES ('server_port', '80', 1); INSERT INTO phpbb_config VALUES ('script_path', '/', 1); -INSERT INTO phpbb_config VALUES ('version', '.2.0', 0); +INSERT INTO phpbb_config VALUES ('version', '.2.1', 0); INSERT INTO phpbb_config VALUES ('stat_total_posts', '7', 0); INSERT INTO phpbb_config VALUES ('stat_total_topics', '5', 0); INSERT INTO phpbb_config VALUES ('stat_total_users', '1', 0); Modified: phpBB Reloaded 2/install/update_to_latest.php =================================================================== --- phpBB Reloaded 2/install/update_to_latest.php 2006-06-20 22:35:48 UTC (rev 244) +++ phpBB Reloaded 2/install/update_to_latest.php 2006-06-20 22:50:51 UTC (rev 245) @@ -59,7 +59,7 @@ // // // -$updates_to_version = '.2.0'; +$updates_to_version = '.2.1'; // // // This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |
|
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.
|
×
Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.
Thanks for helping keep SourceForge clean.
X