Menu
▾
▴
phpbb-checkins — If you subscribed to this list, please update: code.phpbb.com
You can subscribe to this list here.
| 2001 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
(193) |
Nov
(393) |
Dec
(347) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2002 |
Jan
(401) |
Feb
(232) |
Mar
(343) |
Apr
(129) |
May
(129) |
Jun
(116) |
Jul
(189) |
Aug
(129) |
Sep
(68) |
Oct
(172) |
Nov
(298) |
Dec
(148) |
| 2003 |
Jan
(264) |
Feb
(210) |
Mar
(322) |
Apr
(309) |
May
(234) |
Jun
(188) |
Jul
(215) |
Aug
(161) |
Sep
(234) |
Oct
(163) |
Nov
(110) |
Dec
(7) |
| 2004 |
Jan
(95) |
Feb
(107) |
Mar
(55) |
Apr
(3) |
May
(49) |
Jun
(35) |
Jul
(57) |
Aug
(43) |
Sep
(56) |
Oct
(40) |
Nov
(25) |
Dec
(21) |
| 2005 |
Jan
(93) |
Feb
(25) |
Mar
(22) |
Apr
(72) |
May
(45) |
Jun
(24) |
Jul
(29) |
Aug
(20) |
Sep
(50) |
Oct
(93) |
Nov
(69) |
Dec
(183) |
| 2006 |
Jan
(185) |
Feb
(143) |
Mar
(402) |
Apr
(260) |
May
(322) |
Jun
(367) |
Jul
(234) |
Aug
(299) |
Sep
(206) |
Oct
(288) |
Nov
(338) |
Dec
(307) |
| 2007 |
Jan
(296) |
Feb
(250) |
Mar
(261) |
Apr
(434) |
May
(539) |
Jun
(274) |
Jul
(440) |
Aug
(190) |
Sep
(128) |
Oct
(249) |
Nov
(86) |
Dec
(51) |
| 2008 |
Jan
(177) |
Feb
(67) |
Mar
(61) |
Apr
(48) |
May
(56) |
Jun
(97) |
Jul
(60) |
Aug
(64) |
Sep
(151) |
Oct
(79) |
Nov
(109) |
Dec
(123) |
| 2009 |
Jan
(70) |
Feb
(70) |
Mar
(73) |
Apr
(80) |
May
(22) |
Jun
(193) |
Jul
(191) |
Aug
(181) |
Sep
(120) |
Oct
(48) |
Nov
(24) |
Dec
|
|
From: Paul S. O. <ps...@us...> - 2002-04-19 22:34:36
|
Update of /cvsroot/phpbb/phpBB2/templates/subSilver/images/lang_hebrew In directory usw-pr-cvs1:/tmp/cvs-serv3468/lang_hebrew Log Message: Directory /cvsroot/phpbb/phpBB2/templates/subSilver/images/lang_hebrew added to the repository --> Using per-directory sticky tag `phpBB-2_0_0' |
|
From: James A. <th...@us...> - 2002-04-15 17:32:00
|
Update of /cvsroot/phpbb/phpBB2/includes
In directory usw-pr-cvs1:/tmp/cvs-serv24239/includes
Modified Files:
Tag: phpBB-2_0_0
functions.php functions_search.php
Log Message:
Fixed bug #19, simple header not showing in error messages that needed it
Index: functions.php
===================================================================
RCS file: /cvsroot/phpbb/phpBB2/includes/functions.php,v
retrieving revision 1.133
retrieving revision 1.133.2.1
diff -C2 -r1.133 -r1.133.2.1
*** functions.php 2 Apr 2002 14:02:27 -0000 1.133
--- functions.php 15 Apr 2002 14:48:41 -0000 1.133.2.1
***************
*** 492,496 ****
function message_die($msg_code, $msg_text = '', $msg_title = '', $err_line = '', $err_file = '', $sql = '')
{
! global $db, $template, $board_config, $theme, $lang, $phpEx, $phpbb_root_path, $nav_links;
global $userdata, $user_ip, $session_length;
global $starttime;
--- 492,496 ----
function message_die($msg_code, $msg_text = '', $msg_title = '', $err_line = '', $err_file = '', $sql = '')
{
! global $db, $template, $board_config, $theme, $lang, $phpEx, $phpbb_root_path, $nav_links, $gen_simple_header;
global $userdata, $user_ip, $session_length;
global $starttime;
Index: functions_search.php
===================================================================
RCS file: /cvsroot/phpbb/phpBB2/includes/functions_search.php,v
retrieving revision 1.8
retrieving revision 1.8.2.1
diff -C2 -r1.8 -r1.8.2.1
*** functions_search.php 2 Apr 2002 14:03:49 -0000 1.8
--- functions_search.php 15 Apr 2002 14:48:42 -0000 1.8.2.1
***************
*** 429,433 ****
{
global $db, $board_config, $template, $lang, $images, $theme, $phpEx, $phpbb_root_path;
! global $starttime;
$username_list = '';
--- 429,435 ----
{
global $db, $board_config, $template, $lang, $images, $theme, $phpEx, $phpbb_root_path;
! global $starttime, $gen_simple_header;
!
! $gen_simple_header = TRUE;
$username_list = '';
***************
*** 460,464 ****
}
- $gen_simple_header = TRUE;
$page_title = $lang['Search'];
include($phpbb_root_path . 'includes/page_header.'.$phpEx);
--- 462,465 ----
|
|
From: James A. <th...@us...> - 2002-04-15 14:39:59
|
Update of /cvsroot/phpbb/phpBB2/templates/subSilver/admin
In directory usw-pr-cvs1:/tmp/cvs-serv21609/templates/subSilver/admin
Modified Files:
Tag: phpBB-2_0_0
board_config_body.tpl
Log Message:
Fixed bug #144, removed unneeded span tags from admin config template
Index: board_config_body.tpl
===================================================================
RCS file: /cvsroot/phpbb/phpBB2/templates/subSilver/admin/board_config_body.tpl,v
retrieving revision 1.20
retrieving revision 1.20.2.1
diff -C2 -r1.20 -r1.20.2.1
*** board_config_body.tpl 25 Mar 2002 23:10:32 -0000 1.20
--- board_config_body.tpl 15 Apr 2002 14:39:57 -0000 1.20.2.1
***************
*** 118,130 ****
</tr>
<tr>
! <td class="row1">{L_INBOX_LIMIT}</span></td>
<td class="row2"><input type="text" maxlength="4" size="4" name="max_inbox_privmsgs" value="{INBOX_LIMIT}" /></td>
</tr>
<tr>
! <td class="row1">{L_SENTBOX_LIMIT}</span></td>
<td class="row2"><input type="text" maxlength="4" size="4" name="max_sentbox_privmsgs" value="{SENTBOX_LIMIT}" /></td>
</tr>
<tr>
! <td class="row1">{L_SAVEBOX_LIMIT}</span></td>
<td class="row2"><input type="text" maxlength="4" size="4" name="max_savebox_privmsgs" value="{SAVEBOX_LIMIT}" /></td>
</tr>
--- 118,130 ----
</tr>
<tr>
! <td class="row1">{L_INBOX_LIMIT}</td>
<td class="row2"><input type="text" maxlength="4" size="4" name="max_inbox_privmsgs" value="{INBOX_LIMIT}" /></td>
</tr>
<tr>
! <td class="row1">{L_SENTBOX_LIMIT}</td>
<td class="row2"><input type="text" maxlength="4" size="4" name="max_sentbox_privmsgs" value="{SENTBOX_LIMIT}" /></td>
</tr>
<tr>
! <td class="row1">{L_SAVEBOX_LIMIT}</td>
<td class="row2"><input type="text" maxlength="4" size="4" name="max_savebox_privmsgs" value="{SAVEBOX_LIMIT}" /></td>
</tr>
|
|
From: James A. <th...@us...> - 2002-04-15 14:35:24
|
Update of /cvsroot/phpbb/phpBB2/templates/subSilver/admin
In directory usw-pr-cvs1:/tmp/cvs-serv20265/templates/subSilver/admin
Modified Files:
Tag: phpBB-2_0_0
ranks_list_body.tpl
Log Message:
Fixed bug #143, missing closing a tag.
Index: ranks_list_body.tpl
===================================================================
RCS file: /cvsroot/phpbb/phpBB2/templates/subSilver/admin/ranks_list_body.tpl,v
retrieving revision 1.4
retrieving revision 1.4.2.1
diff -C2 -r1.4 -r1.4.2.1
*** ranks_list_body.tpl 5 Dec 2001 14:38:37 -0000 1.4
--- ranks_list_body.tpl 15 Apr 2002 14:35:17 -0000 1.4.2.1
***************
*** 17,22 ****
<td class="{ranks.ROW_CLASS}" align="center">{ranks.RANK_MIN}</td>
<td class="{ranks.ROW_CLASS}" align="center">{ranks.SPECIAL_RANK}</td>
! <td class="{ranks.ROW_CLASS}" align="center"><a href="{ranks.U_RANK_EDIT}">{L_EDIT}</td>
! <td class="{ranks.ROW_CLASS}" align="center"><a href="{ranks.U_RANK_DELETE}">{L_DELETE}</td>
</tr>
<!-- END ranks -->
--- 17,22 ----
<td class="{ranks.ROW_CLASS}" align="center">{ranks.RANK_MIN}</td>
<td class="{ranks.ROW_CLASS}" align="center">{ranks.SPECIAL_RANK}</td>
! <td class="{ranks.ROW_CLASS}" align="center"><a href="{ranks.U_RANK_EDIT}">{L_EDIT}</a></td>
! <td class="{ranks.ROW_CLASS}" align="center"><a href="{ranks.U_RANK_DELETE}">{L_DELETE}</a></td>
</tr>
<!-- END ranks -->
|
|
From: Jonathan H. <the...@us...> - 2002-04-11 17:53:45
|
Update of /cvsroot/phpbb/phpBB2/includes
In directory usw-pr-cvs1:/tmp/cvs-serv10735
Modified Files:
Tag: phpBB-2_0_0
page_header.php
Log Message:
since user_timezone is now a decimal/floating point number we have to cast it's return value as an integer to make sure it drops the .0 before using it as an array index..
Index: page_header.php
===================================================================
RCS file: /cvsroot/phpbb/phpBB2/includes/page_header.php,v
retrieving revision 1.106.2.1
retrieving revision 1.106.2.2
diff -C2 -r1.106.2.1 -r1.106.2.2
*** page_header.php 8 Apr 2002 14:37:16 -0000 1.106.2.1
--- page_header.php 11 Apr 2002 17:53:41 -0000 1.106.2.2
***************
*** 385,389 ****
'S_CONTENT_DIR_LEFT' => $lang['LEFT'],
'S_CONTENT_DIR_RIGHT' => $lang['RIGHT'],
! 'S_TIMEZONE' => sprintf($lang['All_times'], $lang[$board_config['board_timezone']]),
'S_LOGIN_ACTION' => append_sid('login.'.$phpEx),
--- 385,389 ----
'S_CONTENT_DIR_LEFT' => $lang['LEFT'],
'S_CONTENT_DIR_RIGHT' => $lang['RIGHT'],
! 'S_TIMEZONE' => sprintf($lang['All_times'], $lang[number_format($board_config['board_timezone'])]),
'S_LOGIN_ACTION' => append_sid('login.'.$phpEx),
***************
*** 453,455 ****
$template->pparse('overall_header');
! ?>
\ No newline at end of file
--- 453,455 ----
$template->pparse('overall_header');
! ?>
|
|
From: Paul S. O. <ps...@us...> - 2002-04-10 18:38:55
|
Update of /cvsroot/phpbb/phpBB2
In directory usw-pr-cvs1:/tmp/cvs-serv5353
Added Files:
Tag: phpBB-2_0_0
update_to_201.php
Log Message:
2.0.1 updater
--- NEW FILE ---
<html>
<body>
<?php
define('IN_PHPBB', 1);
$phpbb_root_path = './';
include($phpbb_root_path . 'extension.inc');
include($phpbb_root_path . 'config.'.$phpEx);
include($phpbb_root_path . 'includes/constants.'.$phpEx);
include($phpbb_root_path . 'includes/functions.'.$phpEx);
include($phpbb_root_path . 'includes/db.'.$phpEx);
$sql = "SELECT config_value
FROM " . CONFIG_TABLE . "
WHERE config_name = 'version'";
if ( !($result = $db->sql_query($sql)) )
{
die("Couldn't obtain version info");
}
if ( $row = $db->sql_fetchrow($result) )
{
if ( $row['config_value'] == 'RC-3' || $row['config_value'] == 'RC-4' || $row['config_value'] == '.0.0' )
{
if ( $row['config_value'] == 'RC-3' )
{
$sql = array();
switch ( SQL_LAYER )
{
case 'mysql':
case 'mysql4':
$sql[] = "ALTER TABLE " . USERS_TABLE . " DROP
COLUMN user_autologin_key";
break;
case 'mssql-odbc':
case 'mssql':
case 'msaccess':
$sql[] = "ALTER TABLE " . USERS_TABLE . " DROP
COLUMN user_autologin_key";
break;
case 'postgresql':
$sql[] = "ALTER TABLE " . USERS_TABLE . " ALTER
COLUMN user_autologin_key DROP";
default:
die("No DB LAYER found!");
break;
}
$errored = false;
for($i = 0; $i < count($sql); $i++)
{
echo "Running :: " . $sql[$i];
flush();
if ( !($result = $db->sql_query($sql[$i])) )
{
$errored = true;
$error = $db->sql_error();
echo " -> <b>FAILED (Ignoring)</b> ---> <u>" . $error['message'] . "</u><br /><br />\n\n";
}
else
{
echo " -> <b>COMPLETED</b><br /><br />\n\n";
}
}
}
unset($sql);
$sql = "UPDATE " . CONFIG_TABLE . "
SET config_value = '.0.1'
WHERE config_name = 'version'";
if ( !($result = $db->sql_query($sql)) )
{
die("Couldn't update version info");
}
die("UPDATING COMPLETE -> 2.0.1 Final installed");
}
}
$sql = array();
switch ( SQL_LAYER )
{
case 'mysql':
case 'mysql4':
$sql[] = "ALTER TABLE " . USERS_TABLE . " DROP
COLUMN user_autologin_key";
$sql[] = "ALTER TABLE " . RANKS_TABLE . " DROP
COLUMN rank_max";
$sql[] = "ALTER TABLE " . USERS_TABLE . "
ADD COLUMN user_session_time int(11) DEFAULT '0' NOT NULL,
ADD COLUMN user_session_page smallint(5) DEFAULT '0' NOT NULL,
ADD INDEX (user_session_time)";
$sql[] = "ALTER TABLE " . SEARCH_TABLE . "
MODIFY search_id int(11) NOT NULL";
$sql[] = "ALTER TABLE " . TOPICS_TABLE . "
MODIFY topic_moved_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
ADD COLUMN topic_first_post_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
ADD INDEX (topic_first_post_id)";
$sql[] = "ALTER TABLE " . THEMES_NAME_TABLE . "
ADD COLUMN tr_class1_name varchar(50) NULL,
ADD COLUMN tr_class2_name varchar(50) NULL,
ADD COLUMN tr_class3_name varchar(50) NULL,
ADD COLUMN th_class1_name varchar(50) NULL,
ADD COLUMN th_class2_name varchar(50) NULL,
ADD COLUMN th_class3_name varchar(50) NULL,
ADD COLUMN td_class1_name varchar(50) NULL,
ADD COLUMN td_class2_name varchar(50) NULL,
ADD COLUMN td_class3_name varchar(50) NULL,
ADD COLUMN span_class1_name varchar(50) NULL,
ADD COLUMN span_class2_name varchar(50) NULL,
ADD COLUMN span_class3_name varchar(50) NULL";
break;
case 'postgresql':
$sql[] = "ALTER TABLE " . USERS_TABLE . "
ADD COLUMN user_session_time int4";
$sql[] = "ALTER TABLE " . USERS_TABLE . "
ADD COLUMN user_session_page int2";
$sql[] = "ALTER TABLE " . USERS_TABLE . "
ALTER COLUMN user_session_time SET DEFAULT '0'";
$sql[] = "ALTER TABLE " . USERS_TABLE . "
ALTER COLUMN user_session_page SET DEFAULT '0'";
$sql[] = "CREATE INDEX user_session_time_" . $table_prefix . "users_index
ON " . USERS_TABLE . " (user_session_time)";
$sql[] = "ALTER TABLE " . TOPICS_TABLE . "
ADD COLUMN topic_first_post_id int4";
$sql[] = "CREATE INDEX topic_first_post_id_" . $table_prefix . "topics_index
ON " . TOPICS_TABLE . " (topic_first_post_id)";
$sql[] = "ALTER TABLE " . THEMES_NAME_TABLE . "
ADD COLUMN tr_class1_name varchar(50) NULL";
$sql[] = "ALTER TABLE " . THEMES_NAME_TABLE . "
ADD COLUMN tr_class2_name varchar(50) NULL";
$sql[] = "ALTER TABLE " . THEMES_NAME_TABLE . "
ADD COLUMN tr_class3_name varchar(50) NULL";
$sql[] = "ALTER TABLE " . THEMES_NAME_TABLE . "
ADD COLUMN th_class1_name varchar(50) NULL";
$sql[] = "ALTER TABLE " . THEMES_NAME_TABLE . "
ADD COLUMN th_class2_name varchar(50) NULL";
$sql[] = "ALTER TABLE " . THEMES_NAME_TABLE . "
ADD COLUMN th_class3_name varchar(50) NULL";
$sql[] = "ALTER TABLE " . THEMES_NAME_TABLE . "
ADD COLUMN td_class1_name varchar(50) NULL";
$sql[] = "ALTER TABLE " . THEMES_NAME_TABLE . "
ADD COLUMN td_class2_name varchar(50) NULL";
$sql[] = "ALTER TABLE " . THEMES_NAME_TABLE . "
ADD COLUMN td_class3_name varchar(50) NULL";
$sql[] = "ALTER TABLE " . THEMES_NAME_TABLE . "
ADD COLUMN span_class1_name varchar(50) NULL";
$sql[] = "ALTER TABLE " . THEMES_NAME_TABLE . "
ADD COLUMN span_class2_name varchar(50) NULL";
$sql[] = "ALTER TABLE " . THEMES_NAME_TABLE . "
ADD COLUMN span_class3_name varchar(50) NULL";
break;
case 'mssql-odbc':
case 'mssql':
$sql[] = "ALTER TABLE " . USERS_TABLE . " DROP
COLUMN user_autologin_key";
$sql[] = "ALTER TABLE " . USERS_TABLE . " ADD
user_session_time int NOT NULL,
user_session_page smallint NOT NULL,
CONSTRAINT [DF_" . $table_prefix . "users_user_session_time] DEFAULT (0) FOR [user_session_time],
CONSTRAINT [DF_" . $table_prefix . "users_user_session_page] DEFAULT (0) FOR [user_session_page]";
$sql[] = "CREATE INDEX [IX_" . $table_prefix . "users]
ON [" . USERS_TABLE . "]([user_session_time]) ON [PRIMARY]";
/* DROP FORUM TABLE -- if this may cause you problems you can safely
comment it out, remember to manually remove the IDENTITY setting on
the forum_id column */
$sql [] = "ALTER TABLE " . FORUMS_TABLE . " DROP
CONSTRAINT [DF_" . $table_prefix . "forums_forum_posts],
CONSTRAINT [DF_" . $table_prefix . "forums_forum_topics],
CONSTRAINT [DF_" . $table_prefix . "forums_forum_last_post_id],
CONSTRAINT [DF_" . $table_prefix . "forums_prune_enable],
CONSTRAINT [DF_" . $table_prefix . "forums_auth_view],
CONSTRAINT [DF_" . $table_prefix . "forums_auth_read],
CONSTRAINT [DF_" . $table_prefix . "forums_auth_post],
CONSTRAINT [DF_" . $table_prefix . "forums_auth_reply],
CONSTRAINT [DF_" . $table_prefix . "forums_auth_edit],
CONSTRAINT [DF_" . $table_prefix . "forums_auth_delete],
CONSTRAINT [DF_" . $table_prefix . "forums_auth_sticky],
CONSTRAINT [DF_" . $table_prefix . "forums_auth_announce],
CONSTRAINT [DF_" . $table_prefix . "forums_auth_vote],
CONSTRAINT [DF_" . $table_prefix . "forums_auth_pollcreate],
CONSTRAINT [DF_" . $table_prefix . "forums_auth_attachments]";
$sql[] = "CREATE TABLE Tmp_" . FORUMS_TABLE . "
(forum_id int NOT NULL, cat_id int NOT NULL, forum_name varchar(100) NOT NULL, forum_desc varchar(255) NULL, forum_status smallint NOT NULL, forum_order int NOT NULL, forum_posts int NOT NULL, forum_topics smallint NOT NULL, forum_last_post_id int NOT NULL, prune_next int NULL, prune_enable smallint NOT NULL, auth_view smallint NOT NULL, auth_read smallint NOT NULL, auth_post smallint NOT NULL, auth_reply smallint NOT NULL, auth_edit smallint NOT NULL, auth_delete smallint NOT NULL, auth_sticky smallint NOT NULL, auth_announce smallint NOT NULL, auth_vote smallint NOT NULL, auth_pollcreate smallint NOT NULL, auth_attachments smallint NOT NULL) ON [PRIMARY]";
$sql[] = "ALTER TABLE [Tmp_" . FORUMS_TABLE . "] WITH NOCHECK ADD
CONSTRAINT [DF_" . $table_prefix . "forums_forum_posts] DEFAULT (0) FOR [forum_posts],
CONSTRAINT [DF_" . $table_prefix . "forums_forum_topics] DEFAULT (0) FOR [forum_topics],
CONSTRAINT [DF_" . $table_prefix . "forums_forum_last_post_id] DEFAULT (0) FOR [forum_last_post_id],
CONSTRAINT [DF_" . $table_prefix . "forums_prune_enable] DEFAULT (0) FOR [prune_enable],
CONSTRAINT [DF_" . $table_prefix . "forums_auth_view] DEFAULT (0) FOR [auth_view],
CONSTRAINT [DF_" . $table_prefix . "forums_auth_read] DEFAULT (0) FOR [auth_read],
CONSTRAINT [DF_" . $table_prefix . "forums_auth_post] DEFAULT (0) FOR [auth_post],
CONSTRAINT [DF_" . $table_prefix . "forums_auth_reply] DEFAULT (0) FOR [auth_reply],
CONSTRAINT [DF_" . $table_prefix . "forums_auth_edit] DEFAULT (0) FOR [auth_edit],
CONSTRAINT [DF_" . $table_prefix . "forums_auth_delete] DEFAULT (0) FOR [auth_delete],
CONSTRAINT [DF_" . $table_prefix . "forums_auth_sticky] DEFAULT (0) FOR [auth_sticky],
CONSTRAINT [DF_" . $table_prefix . "forums_auth_announce] DEFAULT (0) FOR [auth_announce],
CONSTRAINT [DF_" . $table_prefix . "forums_auth_vote] DEFAULT (0) FOR [auth_vote],
CONSTRAINT [DF_" . $table_prefix . "forums_auth_pollcreate] DEFAULT (0) FOR [auth_pollcreate],
CONSTRAINT [DF_" . $table_prefix . "forums_auth_attachments] DEFAULT (0) FOR [auth_attachments]";
$sql[] = "INSERT INTO Tmp_" . FORUMS_TABLE . " (forum_id, cat_id, forum_name, forum_desc, forum_status, forum_order, forum_posts, forum_topics, forum_last_post_id, prune_next, prune_enable, auth_view, auth_read, auth_post, auth_reply, auth_edit, auth_delete, auth_sticky, auth_announce, auth_vote, auth_pollcreate, auth_attachments)
SELECT forum_id, cat_id, forum_name, forum_desc, forum_status, forum_order, forum_posts, forum_topics, forum_last_post_id, prune_next, prune_enable, auth_view, auth_read, auth_post, auth_reply, auth_edit, auth_delete, auth_sticky, auth_announce, auth_vote, auth_pollcreate, auth_attachments FROM " . FORUMS_TABLE . " TABLOCKX";
$sql[] = "DROP TABLE " . FORUMS_TABLE;
$sql[] = "EXECUTE sp_rename N'Tmp_" . FORUMS_TABLE . "', N'" . FORUMS_TABLE . "', 'OBJECT'";
$sql[] = "ALTER TABLE " . FORUMS_TABLE . " ADD
CONSTRAINT [PK_" . $table_prefix . "forums] PRIMARY KEY CLUSTERED (forum_id) ON [PRIMARY]";
$sql[] = "CREATE NONCLUSTERED INDEX [IX_" . $table_prefix . "forums]
ON " . FORUMS_TABLE . " (cat_id, forum_order, forum_last_post_id) ON [PRIMARY]";
/* END OF DROP FORUM -- don't remove anything after this point! */
$sql[] = "DROP INDEX " . RANKS_TABLE . ".IX_" . $table_prefix . "ranks";
$sql[] = "ALTER TABLE " . RANKS_TABLE . " DROP
COLUMN rank_max";
$sql[] = "CREATE INDEX [IX_" . $table_prefix . "ranks]
ON [" . RANKS_TABLE . "]([rank_min], [rank_special]) ON [PRIMARY]";
$sql[] = "DROP INDEX " . TOPICS_TABLE . ".IX_" . $table_prefix . "topics";
$sql[] = "ALTER TABLE " . TOPICS_TABLE . " ADD
topic_first_post_id int NULL,
CONSTRAINT [DF_" . $table_prefix . "topics_topic_first_post_id] FOR [topic_first_post_id]";
$sql[] = "CREATE INDEX [IX_" . $table_prefix . "topics]
ON [" . TOPICS_TABLE . "]([forum_id], [topic_type], [topic_first_post_id], [topic_last_post_id]) ON [PRIMARY]";
$sql[] = "ALTER TABLE " . SEARCH_WORD_TABLE . " DROP
CONSTRAINT [PK_" . $table_prefix . "search_wordlist]";
$sql[] = "CREATE UNIQUE INDEX [IX_" . $table_prefix . "search_wordlist]
ON [" . SEARCH_WORD_TABLE . "]([word_text]) WITH IGNORE_DUP_KEY ON [PRIMARY]";
$sql[] = "CREATE INDEX [IX_" . $table_prefix . "search_wordlist_1]
ON [" . SEARCH_WORD_TABLE . "]([word_common]) ON [PRIMARY]";
$sql[] = "CREATE INDEX [IX_" . $table_prefix . "search_wordmatch_1]
ON [" . SEARCH_MATCH_TABLE . "]([word_id]) ON [PRIMARY]";
$sql[] = "ALTER TABLE " . THEMES_NAME_TABLE . " ADD
tr_class1_name varchar(50) NULL,
tr_class2_name varchar(50) NULL,
tr_class3_name varchar(50) NULL,
th_class1_name varchar(50) NULL,
th_class2_name varchar(50) NULL,
th_class3_name varchar(50) NULL,
td_class1_name varchar(50) NULL,
td_class2_name varchar(50) NULL,
td_class3_name varchar(50) NULL,
span_class1_name varchar(50) NULL,
span_class2_name varchar(50) NULL,
span_class3_name varchar(50) NULL";
break;
case 'msaccess':
$sql[] = "ALTER TABLE " . USERS_TABLE . " DROP
COLUMN user_autologin_key";
$sql[] = "ALTER TABLE " . USERS_TABLE . " ADD
user_session_time int NOT NULL,
user_session_page smallint NOT NULL";
$sql[] = "CREATE INDEX user_session_time
ON " . USERS_TABLE . " (user_session_time)";
$sql[] = "ALTER TABLE " . TOPICS_TABLE . " ADD
topic_first_post_id int NULL";
$sql[] = "CREATE INDEX topic_first_post_id
ON " . TOPICS_TABLE . " (topic_first_post_id)";
$sql[] = "ALTER TABLE " . THEMES_NAME_TABLE . " ADD
tr_class1_name varchar(50) NULL,
tr_class2_name varchar(50) NULL,
tr_class3_name varchar(50) NULL,
th_class1_name varchar(50) NULL,
th_class2_name varchar(50) NULL,
th_class3_name varchar(50) NULL,
td_class1_name varchar(50) NULL,
td_class2_name varchar(50) NULL,
td_class3_name varchar(50) NULL,
span_class1_name varchar(50) NULL,
span_class2_name varchar(50) NULL,
span_class3_name varchar(50) NULL";
break;
default:
die("No DB LAYER found!");
break;
}
$errored = false;
for($i = 0; $i < count($sql); $i++)
{
echo "Running :: " . $sql[$i];
flush();
if ( !($result = $db->sql_query($sql[$i])) )
{
$errored = true;
$error = $db->sql_error();
echo " -> <b>FAILED (Ignoring)</b> ---> <u>" . $error['message'] . "</u><br /><br />\n\n";
}
else
{
echo " -> <b>COMPLETED</b><br /><br />\n\n";
}
}
if ( $errored )
{
echo "\n<br /><b>Some queries failed! This is probably nothing to worry about, update will attempt to continue. Should this fail you may need to seek help at our development board (see README)</b><br /><br />\n\n";
flush();
}
$sql = "SELECT themes_id
FROM " . THEMES_TABLE . "
WHERE template_name = 'subSilver'";
if( !($result = $db->sql_query($sql)) )
{
die("Couldn't obtain subSilver id");
}
if( $row = $db->sql_fetchrow($result) )
{
$theme_id = $row['themes_id'];
$sql = "UPDATE " . THEMES_TABLE . "
SET head_stylesheet = 'subSilver.css', body_background = '', body_bgcolor = 'E5E5E5', body_text = '000000', body_link = '006699', body_vlink = '5493B4', body_alink = '', body_hlink = 'DD6900', tr_color1 = 'EFEFEF', tr_color2 = 'DEE3E7', tr_color3 = 'D1D7DC', tr_class1 = '', tr_class2 = '', tr_class3 = '', th_color1 = '98AAB1', th_color2 = '006699', th_color3 = 'FFFFFF', th_class1 = 'cellpic1.gif', th_class2 = 'cellpic3.gif', th_class3 = 'cellpic2.jpg', td_color1 = 'FAFAFA', td_color2 = 'FFFFFF', td_color3 = '', td_class1 = 'row1', td_class2 = 'row2', td_class3 = '', fontface1 = 'Verdana, Arial, Helvetica, sans-serif', fontface2 = 'Trebuchet MS', fontface3 = 'Courier, ''Courier New'', sans-serif', fontsize1 = 10, fontsize2 = 11, fontsize3 = 12, fontcolor1 = '444444', fontcolor2 = '006600', fontcolor3 = 'FFA34F', span_class1 = '', span_class2 = '', span_class3 = ''
WHERE themes_id = $theme_id";
if ( !($result = $db->sql_query($sql)) )
{
die("Couldn't update subSilver theme");
}
$sql = "DELETE FROM " . THEMES_NAME_TABLE . "
WHERE themes_id = $theme_id";
if ( !($result = $db->sql_query($sql)) )
{
die("Couldn't delete subSilver theme names");
}
$sql = "INSERT INTO " . THEMES_NAME_TABLE . " (themes_id, tr_color1_name, tr_color2_name, tr_color3_name, tr_class1_name, tr_class2_name, tr_class3_name, th_color1_name, th_color2_name, th_color3_name, th_class1_name, th_class2_name, th_class3_name, td_color1_name, td_color2_name, td_color3_name, td_class1_name, td_class2_name, td_class3_name, fontface1_name, fontface2_name, fontface3_name, fontsize1_name, fontsize2_name, fontsize3_name, fontcolor1_name, fontcolor2_name, fontcolor3_name, span_class1_name, span_class2_name, span_class3_name)
VALUES ($theme_id, 'The lightest row colour', 'The medium row color', 'The darkest row colour', '', '', '', 'Border round the whole page', 'Outer table border', 'Inner table border', 'Silver gradient picture', 'Blue gradient picture', 'Fade-out gradient on index', 'Background for quote boxes', 'All white areas', '', 'Background for topic posts', '2nd background for topic posts', '', 'Main fonts', 'Additional topic title font', 'Form fonts', 'Smallest font size', 'Medium font size', 'Normal font size (post body etc)', 'Quote & copyright text', 'Code text colour', 'Main table header text colour', '', '', '')";
if ( !($result = $db->sql_query($sql)) )
{
echo "WARNING >> Couldn't insert subSilver name info<br />\n";
}
}
print "<br />Updating topic first post info<br />\n";
flush();
$sql = "SELECT MIN(post_id) AS first_post_id, topic_id
FROM " . POSTS_TABLE . "
GROUP BY topic_id
ORDER BY topic_id ASC";
if ( !($result = $db->sql_query($sql)) )
{
die("Couldn't obtain first post id list");
}
if ( $row = $db->sql_fetchrow($result) )
{
do
{
$post_id = $row['first_post_id'];
$topic_id = $row['topic_id'];
$sql = "UPDATE " . TOPICS_TABLE . "
SET topic_first_post_id = $post_id
WHERE topic_id = $topic_id";
if ( !$db->sql_query($sql) )
{
die("Couldn't update topic first post id in topic :: $topic_id");
}
}
while ( $row = $db->sql_fetchrow($result) );
}
print "<br />Updating moderator user_level<br />\n";
flush();
$sql = "SELECT DISTINCT u.user_id
FROM " . USERS_TABLE . " u, " . USER_GROUP_TABLE . " ug, " . AUTH_ACCESS_TABLE . " aa
WHERE aa.auth_mod = 1
AND ug.group_id = aa.group_id
AND u.user_id = ug.user_id
AND u.user_level <> " . ADMIN;
if ( !$db->sql_query($sql) )
{
die("Couldn't obtain moderator user ids");
}
$mod_user = array();
while ( $row = $db->sql_fetchrow($result) )
{
$mod_user[] = $row['user_id'];
}
if ( count($mod_user) )
{
$sql = "UPDATE " . USERS_TABLE . "
SET user_level = " . MOD . "
WHERE user_id IN (" . implode(', ', $mod_user) . ")";
if ( !$db->sql_query($sql) )
{
die("Couldn't update user level");
}
}
print "<br />Updating config settings<br />\n";
flush();
$sql = "INSERT INTO " . CONFIG_TABLE . " (config_name, config_value)
VALUES ('server_name', 'www.myserver.tld')";
if( !$db->sql_query($sql) )
{
print "Failed inserting server_name config ... probably exists already<br />\n";
}
$sql = "INSERT INTO " . CONFIG_TABLE . " (config_name, config_value)
VALUES ('script_path', '/phpBB2/')";
if( !$db->sql_query($sql) )
{
print "Failed inserting script_path config ... probably exists already<br />\n";
}
$sql = "INSERT INTO " . CONFIG_TABLE . " (config_name, config_value)
VALUES ('server_port', '80')";
if( !$db->sql_query($sql) )
{
print "Failed inserting server_port config ... probably exists already<br />\n";
}
$sql = "INSERT INTO " . CONFIG_TABLE . " (config_name, config_value)
VALUES ('version', '.0.0')";
if ( !$db->sql_query($sql) )
{
print "Failed inserting version config ... probably exists already<br />\n";
}
$sql = "INSERT INTO " . CONFIG_TABLE . " (config_name, config_value)
VALUES ('record_online_users', '1')";
if( !$db->sql_query($sql) )
{
print "Failed inserting record_online_users config ... probably exists already<br />\n";
}
$sql = "INSERT INTO " . CONFIG_TABLE . " (config_name, config_value)
VALUES ('record_online_date', '" . time() . "')";
if( !$db->sql_query($sql) )
{
print "Failed inserting record_online_date config ... probably exists already<br />\n";
}
echo "\n<br />\n<b>COMPLETE!</b><br />\n";
echo "\n<p>You should now visit the General Configuration settings page in the <a href=\"admin/\">Administration Panel</a> and update the 'Server' settings. If you do not do this emails sent from the board will contain incorrect information. Don't forget to delete this file!</p>\n";
?>
</body>
</html>
|
|
From: Paul S. O. <ps...@us...> - 2002-04-10 18:36:51
|
Update of /cvsroot/phpbb/phpBB2
In directory usw-pr-cvs1:/tmp/cvs-serv5549
Removed Files:
Tag: phpBB-2_0_0
update_to_FINAL.php
Log Message:
bye bye
--- update_to_FINAL.php DELETED ---
|
|
From: Paul S. O. <ps...@us...> - 2002-04-09 14:39:56
|
Update of /cvsroot/phpbb/phpBB2/templates/subSilver
In directory usw-pr-cvs1:/tmp/cvs-serv27623/templates/subSilver
Modified Files:
Tag: phpBB-2_0_0
posting_body.tpl
Log Message:
Missing span tag
Index: posting_body.tpl
===================================================================
RCS file: /cvsroot/phpbb/phpBB2/templates/subSilver/posting_body.tpl,v
retrieving revision 1.26
retrieving revision 1.26.2.1
diff -C2 -r1.26 -r1.26.2.1
*** posting_body.tpl 31 Mar 2002 00:06:34 -0000 1.26
--- posting_body.tpl 9 Apr 2002 14:39:51 -0000 1.26.2.1
***************
*** 280,284 ****
<!-- BEGIN switch_smilies_extra -->
<tr align="center">
! <td colspan="{S_SMILIES_COLSPAN}"><span class="nav"><a href="{U_MORE_SMILIES}" onclick="window.open('{U_MORE_SMILIES}', '_phpbbsmilies', 'HEIGHT=300,resizable=yes,scrollbars=yes,WIDTH=250');return false;" target="_phpbbsmilies" class="nav">{L_MORE_SMILIES}</a></td>
</tr>
<!-- END switch_smilies_extra -->
--- 280,284 ----
<!-- BEGIN switch_smilies_extra -->
<tr align="center">
! <td colspan="{S_SMILIES_COLSPAN}"><span class="nav"><a href="{U_MORE_SMILIES}" onclick="window.open('{U_MORE_SMILIES}', '_phpbbsmilies', 'HEIGHT=300,resizable=yes,scrollbars=yes,WIDTH=250');return false;" target="_phpbbsmilies" class="nav">{L_MORE_SMILIES}</a></span></td>
</tr>
<!-- END switch_smilies_extra -->
|
|
From: Paul S. O. <ps...@us...> - 2002-04-08 17:06:28
|
Update of /cvsroot/phpbb/phpBB2/includes
In directory usw-pr-cvs1:/tmp/cvs-serv25665/includes
Modified Files:
Tag: phpBB-2_0_0
page_header.php
Log Message:
Changes in sessions means a reduction in complexity for viewonline and page_header
Index: page_header.php
===================================================================
RCS file: /cvsroot/phpbb/phpBB2/includes/page_header.php,v
retrieving revision 1.106
retrieving revision 1.106.2.1
diff -C2 -r1.106 -r1.106.2.1
*** page_header.php 1 Apr 2002 13:23:42 -0000 1.106
--- page_header.php 8 Apr 2002 14:37:16 -0000 1.106.2.1
***************
*** 86,96 ****
// situation
//
! $user_forum_sql = ( !empty($forum_id) ) ? "AND ( u.user_session_page = $forum_id
! OR s.session_page = $forum_id)" : '';
$sql = "SELECT u.username, u.user_id, u.user_allow_viewonline, u.user_level, s.session_logged_in, s.session_ip
FROM ".USERS_TABLE." u, ".SESSIONS_TABLE." s
WHERE u.user_id = s.session_user_id
! AND ( s.session_time >= ".( time() - 300 ) . "
! OR u.user_session_time >= " . ( time() - 300 ) . " )
$user_forum_sql
ORDER BY u.username ASC, s.session_ip ASC";
--- 86,94 ----
// situation
//
! $user_forum_sql = ( !empty($forum_id) ) ? "AND s.session_page = $forum_id" : '';
$sql = "SELECT u.username, u.user_id, u.user_allow_viewonline, u.user_level, s.session_logged_in, s.session_ip
FROM ".USERS_TABLE." u, ".SESSIONS_TABLE." s
WHERE u.user_id = s.session_user_id
! AND s.session_time >= ".( time() - 300 ) . "
$user_forum_sql
ORDER BY u.username ASC, s.session_ip ASC";
|
|
From: Paul S. O. <ps...@us...> - 2002-04-08 16:45:44
|
Update of /cvsroot/phpbb/phpBB2
In directory usw-pr-cvs1:/tmp/cvs-serv25665
Modified Files:
Tag: phpBB-2_0_0
viewonline.php
Log Message:
Changes in sessions means a reduction in complexity for viewonline and page_header
Index: viewonline.php
===================================================================
RCS file: /cvsroot/phpbb/phpBB2/viewonline.php,v
retrieving revision 1.54
retrieving revision 1.54.2.1
diff -C2 -r1.54 -r1.54.2.1
*** viewonline.php 4 Apr 2002 11:25:56 -0000 1.54
--- viewonline.php 8 Apr 2002 14:37:17 -0000 1.54.2.1
***************
*** 80,88 ****
// Get user list
//
! $sql = "SELECT u.user_id, u.username, u.user_session_time, u.user_session_page, u.user_allow_viewonline, u.user_level, s.session_logged_in, s.session_time, s.session_page, s.session_ip
FROM ".USERS_TABLE." u, ".SESSIONS_TABLE." s
WHERE u.user_id = s.session_user_id
! AND ( s.session_time >= ".( time() - 300 ) . "
! OR u.user_session_time >= " . ( time() - 300 ) . " )
ORDER BY u.username ASC, s.session_ip ASC";
if ( !($result = $db->sql_query($sql)) )
--- 80,87 ----
// Get user list
//
! $sql = "SELECT u.user_id, u.username, u.user_allow_viewonline, u.user_level, s.session_logged_in, s.session_time, s.session_page, s.session_ip
FROM ".USERS_TABLE." u, ".SESSIONS_TABLE." s
WHERE u.user_id = s.session_user_id
! AND s.session_time >= ".( time() - 300 ) . "
ORDER BY u.username ASC, s.session_ip ASC";
if ( !($result = $db->sql_query($sql)) )
***************
*** 135,141 ****
}
- $last_update = $row['user_session_time'];
- $user_page = $row['user_session_page'];
-
$which_counter = 'reg_counter';
$which_row = 'reg_user_row';
--- 134,137 ----
***************
*** 147,157 ****
if ( $row['session_ip'] != $prev_ip )
{
$view_online = true;
$guest_users++;
- $username = $lang['Guest'];
- $last_update = $row['session_time'];
- $user_page = $row['session_page'];
-
$which_counter = 'guest_counter';
$which_row = 'guest_user_row';
--- 143,150 ----
if ( $row['session_ip'] != $prev_ip )
{
+ $username = $lang['Guest'];
$view_online = true;
$guest_users++;
$which_counter = 'guest_counter';
$which_row = 'guest_user_row';
***************
*** 163,169 ****
if ( $view_online )
{
! if ( $user_page < 1 || !$is_auth_ary[$user_page]['auth_view'] )
{
! switch( $user_page )
{
case PAGE_INDEX:
--- 156,162 ----
if ( $view_online )
{
! if ( $row['session_page'] < 1 || !$is_auth_ary[$row['session_page']]['auth_view'] )
{
! switch( $row['session_page'] )
{
case PAGE_INDEX:
***************
*** 210,215 ****
else
{
! $location_url = append_sid("viewforum.$phpEx?" . POST_FORUM_URL . '=' . $user_page);
! $location = $forum_data[$user_page];
}
--- 203,208 ----
else
{
! $location_url = append_sid("viewforum.$phpEx?" . POST_FORUM_URL . '=' . $row['session_page']);
! $location = $forum_data[$row['session_page']];
}
***************
*** 221,225 ****
'ROW_CLASS' => $row_class,
'USERNAME' => $username,
! 'LASTUPDATE' => create_date($board_config['default_dateformat'], $last_update, $board_config['board_timezone']),
'FORUM_LOCATION' => $location,
--- 214,218 ----
'ROW_CLASS' => $row_class,
'USERNAME' => $username,
! 'LASTUPDATE' => create_date($board_config['default_dateformat'], $row['session_time'], $board_config['board_timezone']),
'FORUM_LOCATION' => $location,
|
|
From: Paul S. O. <ps...@us...> - 2002-04-08 16:45:26
|
Update of /cvsroot/phpbb/phpBB2/includes
In directory usw-pr-cvs1:/tmp/cvs-serv2512/includes
Modified Files:
Tag: phpBB-2_0_0
sessions.php
Log Message:
Fix forgotten update of users table session info
Index: sessions.php
===================================================================
RCS file: /cvsroot/phpbb/phpBB2/includes/sessions.php,v
retrieving revision 1.58
retrieving revision 1.58.2.1
diff -C2 -r1.58 -r1.58.2.1
*** sessions.php 19 Mar 2002 11:59:36 -0000 1.58
--- sessions.php 8 Apr 2002 11:56:45 -0000 1.58.2.1
***************
*** 22,27 ****
//
- // session_begin()
- //
// Adds/updates a new session to the database for the given userid.
// Returns the new session ID on success.
--- 22,25 ----
***************
*** 55,60 ****
//
! // Try and pull the last time stored
! // in a cookie, if it exists
//
$sql = "SELECT *
--- 53,57 ----
//
! // Try and pull the last time stored in a cookie, if it exists
//
$sql = "SELECT *
***************
*** 82,87 ****
$login = 1;
$enable_autologin = 1;
-
- $last_visit = ( $userdata['user_session_time'] > 0 ) ? $userdata['user_session_time'] : $current_time;
}
else
--- 79,82 ----
***************
*** 103,107 ****
else
{
- $last_visit = ( $userdata['user_session_time'] > 0 ) ? $userdata['user_session_time'] : $current_time;
$login = 1;
}
--- 98,101 ----
***************
*** 147,151 ****
WHERE session_id = '" . $session_id . "'
AND session_ip = '$user_ip'";
! if ( !($result = $db->sql_query($sql)) || !$db->sql_affectedrows() )
{
$session_id = md5(uniqid($user_ip));
--- 141,145 ----
WHERE session_id = '" . $session_id . "'
AND session_ip = '$user_ip'";
! if ( !$db->sql_query($sql) || !$db->sql_affectedrows() )
{
$session_id = md5(uniqid($user_ip));
***************
*** 154,160 ****
(session_id, session_user_id, session_start, session_time, session_ip, session_page, session_logged_in)
VALUES ('$session_id', $user_id, $current_time, $current_time, '$user_ip', $page_id, $login)";
! if ( !($result = $db->sql_query($sql)) )
{
! message_die(CRITICAL_ERROR, 'Error creating new session : session_begin', '', __LINE__, __FILE__, $sql);
}
}
--- 148,154 ----
(session_id, session_user_id, session_start, session_time, session_ip, session_page, session_logged_in)
VALUES ('$session_id', $user_id, $current_time, $current_time, '$user_ip', $page_id, $login)";
! if ( !$db->sql_query($sql) )
{
! message_die(CRITICAL_ERROR, 'Error creating new session', '', __LINE__, __FILE__, $sql);
}
}
***************
*** 162,165 ****
--- 156,161 ----
if ( $user_id != ANONYMOUS )
{
+ // $last_visit = ( $userdata['user_session_time'] > $expiry_time && $auto_create ) ? $userdata['user_lastvisit'] : ( ( $userdata['user_session_time'] > 0 ) ? $userdata['user_session_time'] : $current_time );
+
$sql = "UPDATE " . USERS_TABLE . "
SET user_session_time = $current_time, user_session_page = $page_id, user_lastvisit = $last_visit
***************
*** 167,171 ****
if ( !$db->sql_query($sql) )
{
! message_die(CRITICAL_ERROR, 'Error updating last visit time : session_begin', '', __LINE__, __FILE__, $sql);
}
--- 163,167 ----
if ( !$db->sql_query($sql) )
{
! message_die(CRITICAL_ERROR, 'Error updating last visit time', '', __LINE__, __FILE__, $sql);
}
***************
*** 186,191 ****
setcookie($cookiename . '_data', serialize($sessiondata), $current_time + 31536000, $cookiepath, $cookiedomain, $cookiesecure);
setcookie($cookiename . '_sid', $session_id, 0, $cookiepath, $cookiedomain, $cookiesecure);
- // header('Set-cookie: ' . $cookiename . '_data=' . urlencode(serialize($sessiondata)) . '; expires=' . gmdate("l, d-M-Y H:i:s", $current_time + 31536000) . ' GMT; domain=' . $cookiedomain . '; path=' . $cookiepath . $cookiesecure);
- // header('Set-cookie: ' . $cookiename . '_sid=' . $session_id . '; domain=' . $cookiedomain . '; path=' . $cookiepath . $cookiesecure);
$SID = ( $sessionmethod == SESSION_METHOD_GET ) ? 'sid=' . $session_id : '';
--- 182,185 ----
***************
*** 195,200 ****
//
! // Checks for a given user session, tidies session
! // table and updates user sessions at each page refresh
//
function session_pagestart($user_ip, $thispage_id)
--- 189,194 ----
//
! // Checks for a given user session, tidies session table and updates user
! // sessions at each page refresh
//
function session_pagestart($user_ip, $thispage_id)
***************
*** 207,211 ****
$cookiedomain = $board_config['cookie_domain'];
$cookiesecure = $board_config['cookie_secure'];
- $cookiesecure = ( $board_config['cookie_secure'] ) ? '; secure' : '';
$current_time = time();
--- 201,204 ----
***************
*** 241,245 ****
if ( !($result = $db->sql_query($sql)) )
{
! message_die(CRITICAL_ERROR, 'Error doing DB query userdata row fetch : session_pagestart', '', __LINE__, __FILE__, $sql);
}
--- 234,238 ----
if ( !($result = $db->sql_query($sql)) )
{
! message_die(CRITICAL_ERROR, 'Error doing DB query userdata row fetch', '', __LINE__, __FILE__, $sql);
}
***************
*** 256,267 ****
// Only update session DB a minute or so after last update
//
! $last_update = ( $userdata['user_id'] == ANONYMOUS ) ? $userdata['session_time'] : $userdata['user_session_time'];
!
! if ( $current_time - $last_update > 60 )
! { // || $userdata['user_session_page'] != $thispage_id
! $sql = ( $userdata['user_id'] == ANONYMOUS ) ? "UPDATE " . SESSIONS_TABLE . " SET session_time = $current_time, session_page = $thispage_id WHERE session_id = '" . $userdata['session_id'] . "' AND session_ip = '$user_ip'" : "UPDATE " . USERS_TABLE . " SET user_session_time = $current_time, user_session_page = $thispage_id WHERE user_id = " . $userdata['user_id'];
if ( !$db->sql_query($sql) )
{
! message_die(CRITICAL_ERROR, 'Error updating sessions table : session_pagestart', '', __LINE__, __FILE__, $sql);
}
--- 249,273 ----
// Only update session DB a minute or so after last update
//
! if ( $current_time - $userdata['session_time'] > 60 )
! {
! // || $userdata['user_session_page'] != $thispage_id
! $sql = "UPDATE " . SESSIONS_TABLE . "
! SET session_time = $current_time, session_page = $thispage_id
! WHERE session_id = '" . $userdata['session_id'] . "'
! AND session_ip = '$user_ip'";
if ( !$db->sql_query($sql) )
{
! message_die(CRITICAL_ERROR, 'Error updating sessions table', '', __LINE__, __FILE__, $sql);
! }
!
! if ( $userdata['user_id'] != ANONYMOUS )
! {
! $sql = "UPDATE " . USERS_TABLE . "
! SET user_session_time = $current_time, user_session_page = $thispage_id
! WHERE user_id = " . $userdata['user_id'];
! if ( !$db->sql_query($sql) )
! {
! message_die(CRITICAL_ERROR, 'Error updating sessions table', '', __LINE__, __FILE__, $sql);
! }
}
***************
*** 273,285 ****
WHERE session_time < $expiry_time
AND session_id <> '$session_id'";
! if ( !($result = $db->sql_query($sql)) )
{
! message_die(CRITICAL_ERROR, 'Error clearing sessions table : session_pagestart', '', __LINE__, __FILE__, $sql);
}
setcookie($cookiename . '_data', serialize($sessiondata), $current_time + 31536000, $cookiepath, $cookiedomain, $cookiesecure);
setcookie($cookiename . '_sid', $session_id, 0, $cookiepath, $cookiedomain, $cookiesecure);
- // header('Set-cookie: ' . $cookiename . '_data=' . urlencode(serialize($sessiondata)) . '; expires=' . gmdate("l, d-M-Y H:i:s", $current_time + 31536000) . ' GMT; domain=' . $cookiedomain . '; path=' . $cookiepath . $cookiesecure);
- // header('Set-cookie: ' . $cookiename . '_sid=' . $session_id . '; domain=' . $cookiedomain . '; path=' . $cookiepath . $cookiesecure);
}
--- 279,289 ----
WHERE session_time < $expiry_time
AND session_id <> '$session_id'";
! if ( !$db->sql_query($sql) )
{
! message_die(CRITICAL_ERROR, 'Error clearing sessions table', '', __LINE__, __FILE__, $sql);
}
setcookie($cookiename . '_data', serialize($sessiondata), $current_time + 31536000, $cookiepath, $cookiedomain, $cookiesecure);
setcookie($cookiename . '_sid', $session_id, 0, $cookiepath, $cookiedomain, $cookiesecure);
}
***************
*** 296,300 ****
if ( !($userdata = session_begin($user_id, $user_ip, $thispage_id, TRUE)) )
{
! message_die(CRITICAL_ERROR, 'Error creating user session : session_pagestart', '', __LINE__, __FILE__, $sql);
}
--- 300,304 ----
if ( !($userdata = session_begin($user_id, $user_ip, $thispage_id, TRUE)) )
{
! message_die(CRITICAL_ERROR, 'Error creating user session', '', __LINE__, __FILE__, $sql);
}
***************
*** 317,321 ****
$cookiedomain = $board_config['cookie_domain'];
$cookiesecure = $board_config['cookie_secure'];
- // $cookiesecure = ( $board_config['cookie_secure'] ) ? '; secure' : '';
//
--- 321,324 ----
***************
*** 339,356 ****
WHERE session_id = '$session_id'
AND session_user_id = $user_id";
! if ( !($result = $db->sql_query($sql)) )
{
! message_die(CRITICAL_ERROR, 'Error removing user session : session_end', '', __LINE__, __FILE__, $sql);
}
setcookie($cookiename . '_data', '', $current_time - 31536000, $cookiepath, $cookiedomain, $cookiesecure);
setcookie($cookiename . '_sid', '', $current_time - 31536000, $cookiepath, $cookiedomain, $cookiesecure);
- // header('Set-cookie: ' . $cookiename . '_data=0; expires=' . gmdate("l, d-M-Y H:i:s", 0) . ' GMT; domain=' . $cookiedomain . '; path=' . $cookiepath. $cookiesecure);
- // header('Set-cookie: ' . $cookiename . '_sid=0; expires=' . gmdate("l, d-M-Y H:i:s", 0) . ' GMT; domain=' . $cookiedomain . '; path=' . $cookiepath . $cookiesecure);
-
- $SID = ( $sessionmethod == SESSION_METHOD_GET ) ? 'sid=' . $session_id : '';
-
- return TRUE;
}
--- 342,354 ----
WHERE session_id = '$session_id'
AND session_user_id = $user_id";
! if ( !$db->sql_query($sql) )
{
! message_die(CRITICAL_ERROR, 'Error removing user session', '', __LINE__, __FILE__, $sql);
}
setcookie($cookiename . '_data', '', $current_time - 31536000, $cookiepath, $cookiedomain, $cookiesecure);
setcookie($cookiename . '_sid', '', $current_time - 31536000, $cookiepath, $cookiedomain, $cookiesecure);
+ return true;
}
***************
*** 373,375 ****
}
! ?>
--- 371,373 ----
}
! ?>
\ No newline at end of file
|
Update of /cvsroot/phpbb/phpBB2/language/lang_chinese_traditional_taiwan/email
In directory usw-pr-cvs1:/tmp/cvs-serv28286/language/lang_chinese_traditional_taiwan/email
Modified Files:
Tag: phpBB-2_0_0
admin_activate.tpl admin_welcome_activated.tpl
admin_welcome_inactive.tpl coppa_welcome_inactive.tpl
group_added.tpl group_approved.tpl group_request.tpl
privmsg_notify.tpl topic_notify.tpl user_activate.tpl
user_activate_passwd.tpl user_welcome.tpl
user_welcome_inactive.tpl
Log Message:
Various updates
Index: admin_activate.tpl
===================================================================
RCS file: /cvsroot/phpbb/phpBB2/language/lang_chinese_traditional_taiwan/email/admin_activate.tpl,v
retrieving revision 1.2
retrieving revision 1.2.2.1
diff -C2 -r1.2 -r1.2.2.1
*** admin_activate.tpl 2 Mar 2002 18:13:23 -0000 1.2
--- admin_activate.tpl 8 Apr 2002 14:44:12 -0000 1.2.2.1
***************
*** 1,4 ****
- Subject: ·sªº·|û±b¸¹
-
±z¦n,
--- 1,2 ----
Index: admin_welcome_activated.tpl
===================================================================
RCS file: /cvsroot/phpbb/phpBB2/language/lang_chinese_traditional_taiwan/email/admin_welcome_activated.tpl,v
retrieving revision 1.2
retrieving revision 1.2.2.1
diff -C2 -r1.2 -r1.2.2.1
*** admin_welcome_activated.tpl 2 Mar 2002 18:13:23 -0000 1.2
--- admin_welcome_activated.tpl 8 Apr 2002 14:44:12 -0000 1.2.2.1
***************
*** 1,4 ****
- Subject: ±b¸¹¤w¸g±Ò¥Î
-
¿Ë·Rªº {USERNAME} ±z¦n,
--- 1,2 ----
Index: admin_welcome_inactive.tpl
===================================================================
RCS file: /cvsroot/phpbb/phpBB2/language/lang_chinese_traditional_taiwan/email/admin_welcome_inactive.tpl,v
retrieving revision 1.2
retrieving revision 1.2.2.1
diff -C2 -r1.2 -r1.2.2.1
*** admin_welcome_inactive.tpl 2 Mar 2002 18:13:23 -0000 1.2
--- admin_welcome_inactive.tpl 8 Apr 2002 14:44:12 -0000 1.2.2.1
***************
*** 1,4 ****
- Subject: wªï¨Ó¨ì {SITENAME} °Q½×°Ï
-
{WELCOME_MSG}
--- 1,2 ----
Index: coppa_welcome_inactive.tpl
===================================================================
RCS file: /cvsroot/phpbb/phpBB2/language/lang_chinese_traditional_taiwan/email/coppa_welcome_inactive.tpl,v
retrieving revision 1.2
retrieving revision 1.2.2.1
diff -C2 -r1.2 -r1.2.2.1
*** coppa_welcome_inactive.tpl 2 Mar 2002 18:13:23 -0000 1.2
--- coppa_welcome_inactive.tpl 8 Apr 2002 14:44:12 -0000 1.2.2.1
***************
*** 1,4 ****
- Subject: wªï¨Ó¨ì {SITENAME} °Q½×°Ï
-
{WELCOME_MSG}
--- 1,2 ----
Index: group_added.tpl
===================================================================
RCS file: /cvsroot/phpbb/phpBB2/language/lang_chinese_traditional_taiwan/email/group_added.tpl,v
retrieving revision 1.2
retrieving revision 1.2.2.1
diff -C2 -r1.2 -r1.2.2.1
*** group_added.tpl 2 Mar 2002 18:13:23 -0000 1.2
--- group_added.tpl 8 Apr 2002 14:44:12 -0000 1.2.2.1
***************
*** 1,4 ****
- Subject: ±z¤w¸g³Q¥[¤J³oÓ·|û¸s²Õ
-
®¥³ß±z,
--- 1,2 ----
Index: group_approved.tpl
===================================================================
RCS file: /cvsroot/phpbb/phpBB2/language/lang_chinese_traditional_taiwan/email/group_approved.tpl,v
retrieving revision 1.2
retrieving revision 1.2.2.1
diff -C2 -r1.2 -r1.2.2.1
*** group_approved.tpl 2 Mar 2002 18:13:23 -0000 1.2
--- group_approved.tpl 8 Apr 2002 14:44:12 -0000 1.2.2.1
***************
*** 1,4 ****
- Subject: ±zªº½Ð¨D¤w¸gÀò±o§åã
-
®¥³ß±z,
--- 1,2 ----
Index: group_request.tpl
===================================================================
RCS file: /cvsroot/phpbb/phpBB2/language/lang_chinese_traditional_taiwan/email/group_request.tpl,v
retrieving revision 1.2
retrieving revision 1.2.2.1
diff -C2 -r1.2 -r1.2.2.1
*** group_request.tpl 2 Mar 2002 18:13:23 -0000 1.2
--- group_request.tpl 8 Apr 2002 14:44:12 -0000 1.2.2.1
***************
*** 1,4 ****
- Subject: ¦³¤@Ó·|û¥Ó½Ð¥[¤J±zªº¸s²Õ
-
¿Ë·Rªº {GROUP_MODERATOR} ±z¦n,
--- 1,2 ----
Index: privmsg_notify.tpl
===================================================================
RCS file: /cvsroot/phpbb/phpBB2/language/lang_chinese_traditional_taiwan/email/privmsg_notify.tpl,v
retrieving revision 1.2
retrieving revision 1.2.2.1
diff -C2 -r1.2 -r1.2.2.1
*** privmsg_notify.tpl 2 Mar 2002 18:13:23 -0000 1.2
--- privmsg_notify.tpl 8 Apr 2002 14:44:12 -0000 1.2.2.1
***************
*** 1,4 ****
- Subject: "±z¦³·sªº¨p¤H°T®§
-
¿Ë·Rªº {USERNAME} ±z¦n,
--- 1,2 ----
Index: topic_notify.tpl
===================================================================
RCS file: /cvsroot/phpbb/phpBB2/language/lang_chinese_traditional_taiwan/email/topic_notify.tpl,v
retrieving revision 1.2
retrieving revision 1.2.2.1
diff -C2 -r1.2 -r1.2.2.1
*** topic_notify.tpl 2 Mar 2002 18:13:23 -0000 1.2
--- topic_notify.tpl 8 Apr 2002 14:44:12 -0000 1.2.2.1
***************
*** 1,4 ****
- Subject: ¥DÃD¦^Âгqª¾ - {TOPIC_TITLE}
-
¿Ë·Rªº {USERNAME} ±z¦n,
--- 1,2 ----
Index: user_activate.tpl
===================================================================
RCS file: /cvsroot/phpbb/phpBB2/language/lang_chinese_traditional_taiwan/email/user_activate.tpl,v
retrieving revision 1.2
retrieving revision 1.2.2.1
diff -C2 -r1.2 -r1.2.2.1
*** user_activate.tpl 2 Mar 2002 18:13:23 -0000 1.2
--- user_activate.tpl 8 Apr 2002 14:44:12 -0000 1.2.2.1
***************
*** 1,4 ****
- Subject: ±zªº±b¸¹¤w¸g«ì´_±Ò¥Î!
-
¿Ë·Rªº {USERNAME} ±z¦n,
--- 1,2 ----
Index: user_activate_passwd.tpl
===================================================================
RCS file: /cvsroot/phpbb/phpBB2/language/lang_chinese_traditional_taiwan/email/user_activate_passwd.tpl,v
retrieving revision 1.2
retrieving revision 1.2.2.1
diff -C2 -r1.2 -r1.2.2.1
*** user_activate_passwd.tpl 2 Mar 2002 18:13:23 -0000 1.2
--- user_activate_passwd.tpl 8 Apr 2002 14:44:12 -0000 1.2.2.1
***************
*** 1,4 ****
- Subject: ·sªº±K½X±Ò¥Î
-
¿Ë·Rªº {USERNAME} ±z¦n,
--- 1,2 ----
Index: user_welcome.tpl
===================================================================
RCS file: /cvsroot/phpbb/phpBB2/language/lang_chinese_traditional_taiwan/email/user_welcome.tpl,v
retrieving revision 1.2
retrieving revision 1.2.2.1
diff -C2 -r1.2 -r1.2.2.1
*** user_welcome.tpl 2 Mar 2002 18:13:23 -0000 1.2
--- user_welcome.tpl 8 Apr 2002 14:44:12 -0000 1.2.2.1
***************
*** 1,4 ****
- Subject: wªï¨Ó¨ì {SITENAME} °Q½×°Ï
-
{WELCOME_MSG}
--- 1,2 ----
Index: user_welcome_inactive.tpl
===================================================================
RCS file: /cvsroot/phpbb/phpBB2/language/lang_chinese_traditional_taiwan/email/user_welcome_inactive.tpl,v
retrieving revision 1.2
retrieving revision 1.2.2.1
diff -C2 -r1.2 -r1.2.2.1
*** user_welcome_inactive.tpl 2 Mar 2002 18:13:23 -0000 1.2
--- user_welcome_inactive.tpl 8 Apr 2002 14:44:12 -0000 1.2.2.1
***************
*** 1,4 ****
- Subject: wªï¨Ó¨ì {SITENAME} °Q½×°Ï
-
{WELCOME_MSG}
--- 1,2 ----
|
|
From: Paul S. O. <ps...@us...> - 2002-04-08 16:44:51
|
Update of /cvsroot/phpbb/phpBB2/includes
In directory usw-pr-cvs1:/tmp/cvs-serv7859/includes
Modified Files:
Tag: phpBB-2_0_0
usercp_register.php
Log Message:
Another minor change to avatar upload capability check
Index: usercp_register.php
===================================================================
RCS file: /cvsroot/phpbb/phpBB2/includes/usercp_register.php,v
retrieving revision 1.20.2.2
retrieving revision 1.20.2.3
diff -C2 -r1.20.2.2 -r1.20.2.3
*** usercp_register.php 7 Apr 2002 19:26:07 -0000 1.20.2.2
--- usercp_register.php 8 Apr 2002 00:51:50 -0000 1.20.2.3
***************
*** 790,794 ****
//
$ini_val = ( phpversion() >= '4.0.0' ) ? 'ini_get' : 'get_cfg_var';
! $form_enctype = ( !@$ini_val('file_uploads') || strtolower(@$ini_val('file_uploads') == 'off') || phpversion() == '4.0.4pl1' || !$board_config['allow_avatar_upload'] || ( phpversion() < '4.0.3' && @$ini_val('open_basedir') != '' ) ) ? '' : 'enctype="multipart/form-data"';
$template->assign_vars(array(
--- 790,794 ----
//
$ini_val = ( phpversion() >= '4.0.0' ) ? 'ini_get' : 'get_cfg_var';
! $form_enctype = ( @$ini_val('file_uploads') == 0 || strtolower(@$ini_val('file_uploads') == 'off') || phpversion() == '4.0.4pl1' || !$board_config['allow_avatar_upload'] || ( phpversion() < '4.0.3' && @$ini_val('open_basedir') != '' ) ) ? '' : 'enctype="multipart/form-data"';
$template->assign_vars(array(
|
|
From: Jonathan H. <the...@us...> - 2002-04-08 16:44:48
|
Update of /cvsroot/phpbb/phpBB2/includes
In directory usw-pr-cvs1:/tmp/cvs-serv26236
Modified Files:
Tag: phpBB-2_0_0
bbcode.php
Log Message:
Ok I'm an idiot.. variables work better with "$"'s in front of them..
Index: bbcode.php
===================================================================
RCS file: /cvsroot/phpbb/phpBB2/includes/bbcode.php,v
retrieving revision 1.36.2.2
retrieving revision 1.36.2.3
diff -C2 -r1.36.2.2 -r1.36.2.3
*** bbcode.php 8 Apr 2002 15:36:17 -0000 1.36.2.2
--- bbcode.php 8 Apr 2002 15:46:59 -0000 1.36.2.3
***************
*** 440,444 ****
// of table structure..
//
! $curr_pos = curr_pos + strlen($possible_start);
}
else
--- 440,444 ----
// of table structure..
//
! $curr_pos = $curr_pos + strlen($possible_start);
}
else
|
|
From: Paul S. O. <ps...@us...> - 2002-04-08 16:44:37
|
Update of /cvsroot/phpbb/phpBB2/includes
In directory usw-pr-cvs1:/tmp/cvs-serv26518/includes
Modified Files:
Tag: phpBB-2_0_0
sessions.php
Log Message:
oops
Index: sessions.php
===================================================================
RCS file: /cvsroot/phpbb/phpBB2/includes/sessions.php,v
retrieving revision 1.58.2.1
retrieving revision 1.58.2.2
diff -C2 -r1.58.2.1 -r1.58.2.2
*** sessions.php 8 Apr 2002 11:56:45 -0000 1.58.2.1
--- sessions.php 8 Apr 2002 13:11:58 -0000 1.58.2.2
***************
*** 155,160 ****
if ( $user_id != ANONYMOUS )
! {
! // $last_visit = ( $userdata['user_session_time'] > $expiry_time && $auto_create ) ? $userdata['user_lastvisit'] : ( ( $userdata['user_session_time'] > 0 ) ? $userdata['user_session_time'] : $current_time );
$sql = "UPDATE " . USERS_TABLE . "
--- 155,160 ----
if ( $user_id != ANONYMOUS )
! {// ( $userdata['user_session_time'] > $expiry_time && $auto_create ) ? $userdata['user_lastvisit'] : (
! $last_visit = ( $userdata['user_session_time'] > 0 ) ? $userdata['user_session_time'] : $current_time;
$sql = "UPDATE " . USERS_TABLE . "
|
|
From: Jonathan H. <the...@us...> - 2002-04-08 16:43:23
|
Update of /cvsroot/phpbb/phpBB2/includes
In directory usw-pr-cvs1:/tmp/cvs-serv4158
Modified Files:
Tag: phpBB-2_0_0
bbcode.php
Log Message:
A likely fix for the quote table breaking behavior
Index: bbcode.php
===================================================================
RCS file: /cvsroot/phpbb/phpBB2/includes/bbcode.php,v
retrieving revision 1.36
retrieving revision 1.36.2.1
diff -C2 -r1.36 -r1.36.2.1
*** bbcode.php 25 Mar 2002 12:41:41 -0000 1.36
--- bbcode.php 8 Apr 2002 15:02:24 -0000 1.36.2.1
***************
*** 252,256 ****
$text = bbencode_first_pass_pda($text, $uid, '[quote]', '[/quote]', '', false, '');
! $text = bbencode_first_pass_pda($text, $uid, '/\[quote=(\\\\".*?\\\\")\]/is', '[/quote]', '', false, '', "[quote:$uid=\\1]");
// [list] and [list=x] for (un)ordered lists.
--- 252,256 ----
$text = bbencode_first_pass_pda($text, $uid, '[quote]', '[/quote]', '', false, '');
! $text = bbencode_first_pass_pda($text, $uid, '/\[quote=(\\\\"[^"]*?\\\\")\]/is', '[/quote]', '', false, '', "[quote:$uid=\\1]");
// [list] and [list=x] for (un)ordered lists.
***************
*** 766,768 ****
! ?>
\ No newline at end of file
--- 766,768 ----
! ?>
|
|
From: Paul S. O. <ps...@us...> - 2002-04-08 16:39:05
|
Update of /cvsroot/phpbb/phpBB2/templates/subSilver
In directory usw-pr-cvs1:/tmp/cvs-serv32384/templates/subSilver
Modified Files:
Tag: phpBB-2_0_0
posting_topic_review.tpl
Log Message:
Minor change to tag
Index: posting_topic_review.tpl
===================================================================
RCS file: /cvsroot/phpbb/phpBB2/templates/subSilver/posting_topic_review.tpl,v
retrieving revision 1.4
retrieving revision 1.4.2.1
diff -C2 -r1.4 -r1.4.2.1
*** posting_topic_review.tpl 31 Mar 2002 00:06:34 -0000 1.4
--- posting_topic_review.tpl 8 Apr 2002 13:29:53 -0000 1.4.2.1
***************
*** 8,12 ****
<td class="row1"><iframe width="100%" height="300" src="{U_REVIEW_TOPIC}" >
<!-- END switch_inline_mode -->
! <table border="0" cellpadding="3" cellspacing="1" width="100%" class="forumline" style="border: 0px #006699 solid ">
<tr>
<th class="thCornerL" width="22%" height="26">{L_AUTHOR}</th>
--- 8,12 ----
<td class="row1"><iframe width="100%" height="300" src="{U_REVIEW_TOPIC}" >
<!-- END switch_inline_mode -->
! <table border="0" cellpadding="3" cellspacing="1" width="100%" class="forumline">
<tr>
<th class="thCornerL" width="22%" height="26">{L_AUTHOR}</th>
|
|
From: Paul S. O. <ps...@us...> - 2002-04-08 16:38:57
|
Update of /cvsroot/phpbb/phpBB2
In directory usw-pr-cvs1:/tmp/cvs-serv11713
Modified Files:
Tag: phpBB-2_0_0
upgrade.php
Log Message:
Fix user_timezone problem (in association with new schemas) + fix setting of user_level for moderators
Index: upgrade.php
===================================================================
RCS file: /cvsroot/phpbb/phpBB2/upgrade.php,v
retrieving revision 1.27
retrieving revision 1.27.2.1
diff -C2 -r1.27 -r1.27.2.1
*** upgrade.php 25 Mar 2002 20:28:11 -0000 1.27
--- upgrade.php 8 Apr 2002 01:11:06 -0000 1.27.2.1
***************
*** 162,166 ****
}
! function smiley_replace($text = "")
{
global $db;
--- 162,166 ----
}
! function smiley_replace($text = '')
{
global $db;
***************
*** 187,191 ****
}
! return ( $text != "" ) ? preg_replace($search, $replace, $text) : "";
}
--- 187,191 ----
}
! return ( $text != '' ) ? preg_replace($search, $replace, $text) : '';
}
***************
*** 202,221 ****
$line = $schemafile[$i];
! if ( preg_match("/^CREATE TABLE (\w+)/i", $line, $matches) )
{
// Start of a new table definition, set some variables and go to the next line.
$tabledata = 1;
// Replace the 'phpbb_' prefix by the user defined prefix.
! $table = str_replace("phpbb_", $table_prefix, $matches[1]);
$table_def[$table] = "CREATE TABLE $table (\n";
continue;
}
! if ( preg_match("/^\);/", $line) )
{
// End of the table definition
// After this we will skip everything until the next 'CREATE' line
$tabledata = 0;
! $table_def[$table] .= ")"; // We don't need the closing semicolon
}
--- 202,221 ----
$line = $schemafile[$i];
! if ( preg_match('/^CREATE TABLE (\w+)/i', $line, $matches) )
{
// Start of a new table definition, set some variables and go to the next line.
$tabledata = 1;
// Replace the 'phpbb_' prefix by the user defined prefix.
! $table = str_replace('phpbb_', $table_prefix, $matches[1]);
$table_def[$table] = "CREATE TABLE $table (\n";
continue;
}
! if ( preg_match('/^\);/', $line) )
{
// End of the table definition
// After this we will skip everything until the next 'CREATE' line
$tabledata = 0;
! $table_def[$table] .= ')'; // We don't need the closing semicolon
}
***************
*** 225,229 ****
// Add the current line to the complete table definition:
$table_def[$table] .= $line;
! if ( preg_match("/^\s*(\w+)\s+(\w+)\((\d+)\)(.*)$/", $line, $matches) )
{
// This is a column definition
--- 225,229 ----
// Add the current line to the complete table definition:
$table_def[$table] .= $line;
! if ( preg_match('/^\s*(\w+)\s+(\w+)\(([\d,]+)\)(.*)$/', $line, $matches) )
{
// This is a column definition
***************
*** 232,240 ****
$size = $matches[3];
! preg_match("/DEFAULT (NULL|\'.*?\')[,\s](.*)$/i", $matches[4], $match);
$default = $match[1];
! $notnull = ( preg_match("/NOT NULL/i", $matches[4]) ) ? 1 : 0;
! $auto_increment = ( preg_match("/auto_increment/i", $matches[4]) ) ? 1 : 0;
$field_def[$table][$field] = array(
--- 232,240 ----
$size = $matches[3];
! preg_match('/DEFAULT (NULL|\'.*?\')[,\s](.*)$/i', $matches[4], $match);
$default = $match[1];
! $notnull = ( preg_match('/NOT NULL/i', $matches[4]) ) ? 1 : 0;
! $auto_increment = ( preg_match('/auto_increment/i', $matches[4]) ) ? 1 : 0;
$field_def[$table][$field] = array(
***************
*** 247,261 ****
}
! if ( preg_match("/\s*PRIMARY\s+KEY\s*\((.*)\).*/", $line, $matches) )
{
// Primary key
$key_def[$table]['PRIMARY'] = $matches[1];
}
! else if ( preg_match("/\s*KEY\s+(\w+)\s*\((.*)\)/", $line, $matches) )
{
// Normal key
$key_def[$table][$matches[1]] = $matches[2];
}
! else if ( preg_match("/^\s*(\w+)\s*(.*?),?\s*$/", $line, $matches) )
{
// Column definition
--- 247,261 ----
}
! if ( preg_match('/\s*PRIMARY\s+KEY\s*\((.*)\).*/', $line, $matches) )
{
// Primary key
$key_def[$table]['PRIMARY'] = $matches[1];
}
! else if ( preg_match('/\s*KEY\s+(\w+)\s*\((.*)\)/', $line, $matches) )
{
// Normal key
$key_def[$table][$matches[1]] = $matches[2];
}
! else if ( preg_match('/^\s*(\w+)\s*(.*?),?\s*$/', $line, $matches) )
{
// Column definition
***************
*** 281,289 ****
global $table_prefix;
! $insertfile = file("db/schemas/mysql_basic.sql");
for($i = 0; $i < count($insertfile); $i++)
{
! if ( preg_match("/(INSERT INTO (\w+)\s.*);/i", str_replace("phpbb_", $table_prefix, $insertfile[$i]), $matches) )
{
$returnvalue[$matches[2]][] = $matches[1];
--- 281,289 ----
global $table_prefix;
! $insertfile = file('db/schemas/mysql_basic.sql');
for($i = 0; $i < count($insertfile); $i++)
{
! if ( preg_match('/(INSERT INTO (\w+)\s.*);/i', str_replace('phpbb_', $table_prefix, $insertfile[$i]), $matches) )
{
$returnvalue[$matches[2]][] = $matches[1];
***************
*** 324,337 ****
{
// Undo [code]
! $code_start_html = "<!-- BBCode Start --><TABLE BORDER=0 ALIGN=CENTER WIDTH=85%><TR><TD><font size=-1>Code:</font><HR></TD></TR><TR><TD><FONT SIZE=-1><PRE>";
! $code_end_html = "</PRE></FONT></TD></TR><TR><TD><HR></TD></TR></TABLE><!-- BBCode End -->";
! $message = str_replace($code_start_html, "[code]", $message);
! $message = str_replace($code_end_html, "[/code]", $message);
// Undo [quote]
! $quote_start_html = "<!-- BBCode Quote Start --><TABLE BORDER=0 ALIGN=CENTER WIDTH=85%><TR><TD><font size=-1>Quote:</font><HR></TD></TR><TR><TD><FONT SIZE=-1><BLOCKQUOTE>";
! $quote_end_html = "</BLOCKQUOTE></FONT></TD></TR><TR><TD><HR></TD></TR></TABLE><!-- BBCode Quote End -->";
! $message = str_replace($quote_start_html, "[quote]", $message);
! $message = str_replace($quote_end_html, "[/quote]", $message);
// Undo [b] and [i]
--- 324,337 ----
{
// Undo [code]
! $code_start_html = '<!-- BBCode Start --><TABLE BORDER=0 ALIGN=CENTER WIDTH=85%><TR><TD><font size=-1>Code:</font><HR></TD></TR><TR><TD><FONT SIZE=-1><PRE>';
! $code_end_html = '</PRE></FONT></TD></TR><TR><TD><HR></TD></TR></TABLE><!-- BBCode End -->';
! $message = str_replace($code_start_html, '[code]', $message);
! $message = str_replace($code_end_html, '[/code]', $message);
// Undo [quote]
! $quote_start_html = '<!-- BBCode Quote Start --><TABLE BORDER=0 ALIGN=CENTER WIDTH=85%><TR><TD><font size=-1>Quote:</font><HR></TD></TR><TR><TD><FONT SIZE=-1><BLOCKQUOTE>';
! $quote_end_html = '</BLOCKQUOTE></FONT></TD></TR><TR><TD><HR></TD></TR></TABLE><!-- BBCode Quote End -->';
! $message = str_replace($quote_start_html, '[quote]', $message);
! $message = str_replace($quote_end_html, '[/quote]', $message);
// Undo [b] and [i]
***************
*** 354,368 ****
// <li> tags:
! $message = str_replace("<!-- BBCode --><LI>", "[*]", $message);
// [list] tags:
! $message = str_replace("<!-- BBCode ulist Start --><UL>", "[list]", $message);
// [list=x] tags:
! $message = preg_replace("#<!-- BBCode olist Start --><OL TYPE=([A1])>#si", "[list=\\1]", $message);
// [/list] tags:
! $message = str_replace("</UL><!-- BBCode ulist End -->", "[/list]", $message);
! $message = str_replace("</OL><!-- BBCode olist End -->", "[/list]", $message);
return $message;
--- 354,368 ----
// <li> tags:
! $message = str_replace('<!-- BBCode --><LI>', '[*]', $message);
// [list] tags:
! $message = str_replace('<!-- BBCode ulist Start --><UL>', '[list]', $message);
// [list=x] tags:
! $message = preg_replace('#<!-- BBCode olist Start --><OL TYPE=([A1])>#si', "[list=\\1]", $message);
// [/list] tags:
! $message = str_replace('</UL><!-- BBCode ulist End -->', '[/list]', $message);
! $message = str_replace('</OL><!-- BBCode olist End -->', '[/list]', $message);
return $message;
***************
*** 1076,1080 ****
$row['post_text'] = bbdecode(stripslashes($row['post_text']));
$row['post_text'] = undo_make_clickable($row['post_text']);
! $row['post_text'] = str_replace("<BR>", "\n", $row['post_text']);
// make a uid
--- 1076,1080 ----
$row['post_text'] = bbdecode(stripslashes($row['post_text']));
$row['post_text'] = undo_make_clickable($row['post_text']);
! $row['post_text'] = str_replace('<BR>', "\n", $row['post_text']);
// make a uid
***************
*** 1087,1098 ****
$edited_sql = "";
! if ( preg_match("/^(.*?)([\n]+<font size=\-1>\[ This message was .*?)$/s", $row['post_text'], $matches) )
{
$row['post_text'] = $matches[1];
$edit_info = $matches[2];
! $edit_times = count(explode(" message ", $edit_info)) - 1; // Taken from example for substr_count in annotated PHP manual
! if ( preg_match("/^.* by: (.*?) on (....)-(..)-(..) (..):(..) \]<\/font>/s", $edit_info, $matches) )
{
$edited_user = $matches[1];
--- 1087,1098 ----
$edited_sql = "";
! if ( preg_match('/^(.*?)([\n]+<font size=\-1>\[ This message was .*?)$/s', $row['post_text'], $matches) )
{
$row['post_text'] = $matches[1];
$edit_info = $matches[2];
! $edit_times = count(explode(' message ', $edit_info)) - 1; // Taken from example for substr_count in annotated PHP manual
! if ( preg_match('/^.* by: (.*?) on (....)-(..)-(..) (..):(..) \]<\/font>/s', $edit_info, $matches) )
{
$edited_user = $matches[1];
***************
*** 1131,1135 ****
if ( $inc == $per_pct )
{
! print ".";
flush();
$inc = 0;
--- 1131,1135 ----
if ( $inc == $per_pct )
{
! print '.';
flush();
$inc = 0;
***************
*** 1260,1264 ****
if ( $inc == $per_pct )
{
! print ".";
flush();
$inc = 0;
--- 1260,1264 ----
if ( $inc == $per_pct )
{
! print '.';
flush();
$inc = 0;
***************
*** 1280,1284 ****
{
// Check if this moderator and this forum still exist
! $sql = "SELECT NULL
FROM " . USERS_TABLE . ", " . FORUMS_TABLE . "
WHERE user_id = " . $row['user_id'] . "
--- 1280,1284 ----
{
// Check if this moderator and this forum still exist
! $sql = "SELECT user_id
FROM " . USERS_TABLE . ", " . FORUMS_TABLE . "
WHERE user_id = " . $row['user_id'] . "
***************
*** 1310,1313 ****
--- 1310,1342 ----
print "<span class=\"ok\"><b>OK</b></span><br />\n";
}
+
+ print " * Setting correct user_level for moderators ::";
+ flush();
+
+ $sql = "SELECT DISTINCT u.user_id
+ FROM " . USERS_TABLE . " u, " . USER_GROUP_TABLE . " ug, " . AUTH_ACCESS_TABLE . " aa
+ WHERE aa.auth_mod = 1
+ AND ug.group_id = aa.group_id
+ AND u.user_id = ug.user_id
+ AND u.user_level <> " . ADMIN;
+ $result = query($sql, "Couldn't obtain list of moderators");
+
+ if ( $row = $db->sql_fetchrow($result) )
+ {
+ $ug_sql = '';
+
+ do
+ {
+ $ug_sql .= ( ( $ug_sql != '' ) ? ', ' : '' ) . $row['user_id'];
+ }
+ while ( $row = $db->sql_fetchrow($result) );
+
+ $sql = "UPDATE " . USERS_TABLE . "
+ SET user_level = " . MOD . "
+ WHERE user_id IN ($ug_sql)";
+ query($sql, "Couldn't set moderator status for users");
+ }
+
+ print "<span class=\"ok\"><b>OK</b></span><br />\n";
end_step('convert_privforums');
|
|
From: Paul S. O. <ps...@us...> - 2002-04-08 15:43:36
|
Update of /cvsroot/phpbb/phpBB2/language/lang_greek
In directory usw-pr-cvs1:/tmp/cvs-serv26292/language/lang_greek
Modified Files:
Tag: phpBB-2_0_0
lang_main.php
Log Message:
Various updates
Index: lang_main.php
===================================================================
RCS file: /cvsroot/phpbb/phpBB2/language/lang_greek/lang_main.php,v
retrieving revision 1.5
retrieving revision 1.5.2.1
diff -C2 -r1.5 -r1.5.2.1
*** lang_main.php 10 Mar 2002 03:23:55 -0000 1.5
--- lang_main.php 8 Apr 2002 14:38:51 -0000 1.5.2.1
***************
*** 1,905 ****
! <?php
! /***************************************************************************
! * lang_main.php [Greek]
! * -------------------
! * begin : Dec 6 2001
! * copyright : (C) 2001 The phpBB Group
! * email : su...@ph...
! *
! * $Id$
! *
[...1876 lines suppressed...]
!
! //
! // Errors (not related to a
! // specific failure on a page)
! //
! $lang['Information'] = "Ðëçñïöïñßåò";
! $lang['Critical_Information'] = "Êñßóéìåò ðëçñïöïñßåò";
!
! $lang['General_Error'] = "Ãåíéêü ËÜèïò";
! $lang['Critical_Error'] = "Êñßóéìï ËÜèïò";
! $lang['An_error_occured'] = "ÐáñïõóéÜóèçêå ËÜèïò";
! $lang['A_critical_error'] = "ÐáñïõóéÜóèçêå Êñßóéìï ËÜèïò";
!
!
!
! //
! // That's all Folks!
! // -------------------------------------------------
!
?>
|
|
From: Jonathan H. <the...@us...> - 2002-04-08 15:36:21
|
Update of /cvsroot/phpbb/phpBB2/includes
In directory usw-pr-cvs1:/tmp/cvs-serv20637
Modified Files:
Tag: phpBB-2_0_0
bbcode.php
Log Message:
Ok one more try at this one...
Index: bbcode.php
===================================================================
RCS file: /cvsroot/phpbb/phpBB2/includes/bbcode.php,v
retrieving revision 1.36.2.1
retrieving revision 1.36.2.2
diff -C2 -r1.36.2.1 -r1.36.2.2
*** bbcode.php 8 Apr 2002 15:02:24 -0000 1.36.2.1
--- bbcode.php 8 Apr 2002 15:36:17 -0000 1.36.2.2
***************
*** 434,438 ****
$match = array("pos" => $curr_pos, "tag" => $which_start_tag, "index" => $start_tag_index);
bbcode_array_push($stack, $match);
! ++$curr_pos;
}
else
--- 434,444 ----
$match = array("pos" => $curr_pos, "tag" => $which_start_tag, "index" => $start_tag_index);
bbcode_array_push($stack, $match);
! //
! // Rather than just increment $curr_pos
! // Set it to the ending of the tag we just found
! // Keeps error in nested tag from breaking out
! // of table structure..
! //
! $curr_pos = curr_pos + strlen($possible_start);
}
else
|
|
From: Paul S. O. <ps...@us...> - 2002-04-08 15:00:04
|
Update of /cvsroot/phpbb/phpBB2/includes
In directory usw-pr-cvs1:/tmp/cvs-serv18239/includes
Modified Files:
Tag: phpBB-2_0_0
usercp_register.php
Log Message:
COPPA appears to be broken ... this should fix it
Index: usercp_register.php
===================================================================
RCS file: /cvsroot/phpbb/phpBB2/includes/usercp_register.php,v
retrieving revision 1.20.2.3
retrieving revision 1.20.2.4
diff -C2 -r1.20.2.3 -r1.20.2.4
*** usercp_register.php 8 Apr 2002 00:51:50 -0000 1.20.2.3
--- usercp_register.php 8 Apr 2002 01:47:10 -0000 1.20.2.4
***************
*** 28,36 ****
}
! //
// Load agreement template since user has not yet
// agreed to registration conditions/coppa
//
! function show_coppa(&$coppa)
{
global $template, $lang, $phpbb_root_path, $phpEx;
--- 28,36 ----
}
! // ---------------------------------------
// Load agreement template since user has not yet
// agreed to registration conditions/coppa
//
! function show_coppa()
{
global $template, $lang, $phpbb_root_path, $phpEx;
***************
*** 41,45 ****
$template->assign_vars(array(
- 'COPPA' => $coppa,
'REGISTRATION' => $lang['Registration'],
'AGREEMENT' => $lang['Reg_agreement'],
--- 41,44 ----
***************
*** 56,61 ****
}
//
! //
! //
$error = FALSE;
--- 55,59 ----
}
//
! // ---------------------------------------
$error = FALSE;
***************
*** 66,75 ****
include($phpbb_root_path . 'includes/page_header.'.$phpEx);
! show_coppa($coppa);
include($phpbb_root_path . 'includes/page_tail.'.$phpEx);
}
! $coppa = ( ( !$HTTP_POST_VARS['coppa'] && !$HTTP_GET_VARS['coppa'] ) || $mode == 'register' ) ? 0 : TRUE;
//
--- 64,73 ----
include($phpbb_root_path . 'includes/page_header.'.$phpEx);
! show_coppa();
include($phpbb_root_path . 'includes/page_tail.'.$phpEx);
}
! $coppa = ( empty($HTTP_POST_VARS['coppa']) && empty($HTTP_GET_VARS['coppa']) ) ? 0 : TRUE;
//
***************
*** 224,229 ****
else if ( $mode == 'register' )
{
- $coppa = (!$HTTP_POST_VARS['coppa'] && !$HTTP_GET_VARS['coppa']) ? 0 : TRUE;
-
if ( empty($username) || empty($password) || empty($password_confirm) || empty($email) )
{
--- 222,225 ----
***************
*** 231,235 ****
$error_msg .= ( ( isset($error_msg) ) ? '<br />' : '' ) . $lang['Fields_empty'];
}
!
}
--- 227,231 ----
$error_msg .= ( ( isset($error_msg) ) ? '<br />' : '' ) . $lang['Fields_empty'];
}
!
}
***************
*** 790,794 ****
//
$ini_val = ( phpversion() >= '4.0.0' ) ? 'ini_get' : 'get_cfg_var';
! $form_enctype = ( @$ini_val('file_uploads') == 0 || strtolower(@$ini_val('file_uploads') == 'off') || phpversion() == '4.0.4pl1' || !$board_config['allow_avatar_upload'] || ( phpversion() < '4.0.3' && @$ini_val('open_basedir') != '' ) ) ? '' : 'enctype="multipart/form-data"';
$template->assign_vars(array(
--- 786,790 ----
//
$ini_val = ( phpversion() >= '4.0.0' ) ? 'ini_get' : 'get_cfg_var';
! $form_enctype = ( @$ini_val('file_uploads') == '0' || strtolower(@$ini_val('file_uploads') == 'off') || phpversion() == '4.0.4pl1' || !$board_config['allow_avatar_upload'] || ( phpversion() < '4.0.3' && @$ini_val('open_basedir') != '' ) ) ? '' : 'enctype="multipart/form-data"';
$template->assign_vars(array(
|
|
From: Paul S. O. <ps...@us...> - 2002-04-08 14:59:59
|
Update of /cvsroot/phpbb/phpBB2/language/lang_chinese_traditional_taiwan
In directory usw-pr-cvs1:/tmp/cvs-serv28286/language/lang_chinese_traditional_taiwan
Modified Files:
Tag: phpBB-2_0_0
lang_admin.php lang_bbcode.php lang_faq.php lang_main.php
Log Message:
Various updates
Index: lang_admin.php
===================================================================
RCS file: /cvsroot/phpbb/phpBB2/language/lang_chinese_traditional_taiwan/lang_admin.php,v
retrieving revision 1.2
retrieving revision 1.2.2.1
diff -C2 -r1.2 -r1.2.2.1
*** lang_admin.php 10 Mar 2002 03:23:55 -0000 1.2
--- lang_admin.php 8 Apr 2002 14:44:13 -0000 1.2.2.1
***************
*** 1,736 ****
! <?php
!
! /***************************************************************************
! * lang_admin.php [English]
! * -------------------
! * begin : Sat Dec 16 2000
! * copyright : (C) 2001 The phpBB Group
! * email : su...@ph...
! *
! * $Id$
[...1444 lines suppressed...]
! $lang['ftp_username'] = "±zªº FTP µn¤J¦WºÙ:";
! $lang['ftp_password'] = "±zªº FTP µn¤J±K½X:";
! $lang['Transfer_config'] = "¶}©l¶Ç¿é";
! $lang['NoFTP_config'] = "FTP ¤W¶Ç³]©wÀÉ¥¢±Ñ. ½Ð¤U¸ü³]©wÀɨùÁ¸Õ¤â°Ê¤W¶Ç.";
!
! $lang['Install'] = "§¹¾ã¦w¸Ë";
! $lang['Upgrade'] = "¨t²Î¤É¯Å";
!
!
! $lang['Install_Method'] = "½Ð¿ï¾Ü¦w¸Ë¼Ò¦¡";
!
! $lang['Install_No_Ext'] = "±z¥D¾÷¤Wªº PHP ³]©w¨Ã¤£¤ä´©±z©Ò¿ï¾Üªº¸ê®Æ®w«¬ºA";
!
! $lang['Install_No_PCRE'] = "phpBB2 »Ýn¨Ï¥Î¨ì Perl-Compatible Regular Expressions Module, ¦Ó±zªº PHP ³]©w¨Ã¤£¤ä´©³o¶µ¥\¯à";
!
! //
! // That's all Folks!
! // -------------------------------------------------
!
?>
Index: lang_bbcode.php
===================================================================
RCS file: /cvsroot/phpbb/phpBB2/language/lang_chinese_traditional_taiwan/lang_bbcode.php,v
retrieving revision 1.1
retrieving revision 1.1.2.1
diff -C2 -r1.1 -r1.1.2.1
*** lang_bbcode.php 28 Feb 2002 14:18:52 -0000 1.1
--- lang_bbcode.php 8 Apr 2002 14:44:13 -0000 1.1.2.1
***************
*** 12,25 ****
***************************************************************************/
! /***************************************************************************
! * Traditional Chinese[ÁcÅ餤¤å»y¨t] Translation
! * -------------------
! * begin : Thu Nov 26 2001
! * by : ¤p¦Ë¤l, OOHOO, ¬Ó®aÃM¤h, «ä
* email : kyo...@ms...
! * mc...@bi...
* sj...@ms...
* f88...@ma...
! *
* last modify : Sun Dec 30 2001
*
--- 12,25 ----
***************************************************************************/
! /***************************************************************************
! * Traditional Chinese Translation [ÁcÅ餤¤å»y¨t]
! * -------------------
! * begin : Thu Nov 26 2001
! * by : ¤p¦Ë¤l, OOHOO, ¬Ó®aÃM¤h, «ä
* email : kyo...@ms...
! * we...@ho...
* sj...@ms...
* f88...@ma...
! *
* last modify : Sun Dec 30 2001
*
Index: lang_faq.php
===================================================================
RCS file: /cvsroot/phpbb/phpBB2/language/lang_chinese_traditional_taiwan/lang_faq.php,v
retrieving revision 1.1
retrieving revision 1.1.2.1
diff -C2 -r1.1 -r1.1.2.1
*** lang_faq.php 28 Feb 2002 14:18:52 -0000 1.1
--- lang_faq.php 8 Apr 2002 14:44:13 -0000 1.1.2.1
***************
*** 12,25 ****
***************************************************************************/
! /***************************************************************************
! * Traditional Chinese[ÁcÅ餤¤å»y¨t] Translation
! * -------------------
! * begin : Thu Nov 26 2001
! * by : ¤p¦Ë¤l, OOHOO, ¬Ó®aÃM¤h, «ä
* email : kyo...@ms...
! * mc...@bi...
* sj...@ms...
* f88...@ma...
! *
* last modify : Sun Dec 30 2001
*
--- 12,25 ----
***************************************************************************/
! /***************************************************************************
! * Traditional Chinese Translation [ÁcÅ餤¤å»y¨t]
! * -------------------
! * begin : Thu Nov 26 2001
! * by : ¤p¦Ë¤l, OOHOO, ¬Ó®aÃM¤h, «ä
* email : kyo...@ms...
! * we...@ho...
* sj...@ms...
* f88...@ma...
! *
* last modify : Sun Dec 30 2001
*
***************
*** 107,111 ****
$faq[] = array("½Ö¼g¤F³oÓ°Q½×ª©?", "³oÓµ{¦¡ (¥¼¸gק諸®æ¦¡) ¥Ñ phpBB Group ©Ò¶}µo¤ÎÄÀ¥X, µÛ§@ª©ÅvÂk <a href=\"http://www.phpbb.com/\" target=\"_blank\">phpBB Group</a> ©Ò¦³. ¨Ì·Ó¡u²¥£¤j²³¤½¦³ª©Åv¡v(GNU General Public License) ªºÁn©ú, ³oÓµ{¦¡¥i¥H¦Û¥Ñªº¨Ï¥Î¤Î´²¥¬, ¦pªG±z»Ýn§ó¦hªº¸ê°T¥i¥H°Ñ¦Ò <a href=\"http://www.gnu.org/copyleft/gpl.html\" target=\"_blank\">GNU General Public License</a>.");
$faq[] = array("¬°¤°»ò¤£¯à¨Ï¥Î§ó¦hªº¥\¯à ?", "³oÓ³nÅé¬O¥Ñ phpBB Group ©Ò»s§@. ¦pªG±z»{¬°»Ýn¥[¤J§ó¦h¥\¯à½Ð°ÑÆ[ phpbb.com website ªº»¡©ú. ½Ð¤£nµoªí¶i¶¥¥\¯àn¨D¨ì phpbb.com ªº°Q½×ª©, ³o·|¨Ï±o¶}µo¤p²Õ¤À¤ßµLªkP¤O·s¥\¯àªº¶}µo. ½Ð¦bª©±ÂsÄý, ¦pªG¦³¥ô¦ó§Ṳ́w¶}µo¥B¸g¹L´ú¸Õªºµ{¦¡§ÚÌ·|©ñ¦bª©±¤Wªº.");
! $faq[] = array("§Ú¸Ó¦V½ÖÁpô¦³Ãö³oÓ°Q½×ª©»~¥Î©Îªk«ß¤Wªº¬ÛÃö¨Æ°È?", "±z¥i¥H³sµ¸³oÓ°Q½×ª©ªººÞ²zªÌ. ¦pªG±z¤£¯à§ä¨ì³oÓª©±ªººÞ²zªÌ¥H´M¨D§ó¶i¤@¨BªºªºÁpô. ¦pªG±z³sµ¸ºÞ²zªÌ¤§«á¤´µM¨S¦³¦^À³ (´M§ä whois ) ©ÎªÌ¨ä¬OÄÝ©ó¤@Ó°õ¦æ¤¤ªº§K¶OªA°È (¨Ò¦p: yahoo, free.fr, f2s.com...µ¥µ¥), ºÞ²zªÌ©Î»~¥Î¦¹ªA°Èªº³¡ªù. ½Ð°O¦í phpBB Group ¬O§¹¥þ¨S¦³±±¨îÅv¦Ó¥B§¹¥þ¤£t¥ô¦ó³d¥ôªº, ³oÓ°Q½×ª©¦ì©~¦ó³B¥H¤Î¦ó¤H¾Ö¦³. ¦b¬ÛÃöªk¥O¤U, §¹¥þ¨S¦³¦V phpBB Group «ü¥Ü (cease and desist, liable, defamatory comment...µ¥µ¥). ¤]³\¤£¬Oª½±µ¥Ñ phpbb.com website ¸ô®|¦Ó±o, ©ÎªÌ¬O¥u¦³ phpBB ¦¹³nÅ骺³¡¥÷¦Ó¤w. ¦pªG±z email¨ì phpBB Group ¦³Ãö¥ô¦ó²Ä¤TªÌ¨Ï¥Î³nÅé¤Wªº°ÝÃD, ±zªºµª®×±N·|«D±`²³æ©Î¬O®Ú¥»¤£¤©¦^À³.");
//
--- 107,111 ----
$faq[] = array("½Ö¼g¤F³oÓ°Q½×ª©?", "³oÓµ{¦¡ (¥¼¸gק諸®æ¦¡) ¥Ñ phpBB Group ©Ò¶}µo¤ÎÄÀ¥X, µÛ§@ª©ÅvÂk <a href=\"http://www.phpbb.com/\" target=\"_blank\">phpBB Group</a> ©Ò¦³. ¨Ì·Ó¡u²¥£¤j²³¤½¦³ª©Åv¡v(GNU General Public License) ªºÁn©ú, ³oÓµ{¦¡¥i¥H¦Û¥Ñªº¨Ï¥Î¤Î´²¥¬, ¦pªG±z»Ýn§ó¦hªº¸ê°T¥i¥H°Ñ¦Ò <a href=\"http://www.gnu.org/copyleft/gpl.html\" target=\"_blank\">GNU General Public License</a>.");
$faq[] = array("¬°¤°»ò¤£¯à¨Ï¥Î§ó¦hªº¥\¯à ?", "³oÓ³nÅé¬O¥Ñ phpBB Group ©Ò»s§@. ¦pªG±z»{¬°»Ýn¥[¤J§ó¦h¥\¯à½Ð°ÑÆ[ phpbb.com website ªº»¡©ú. ½Ð¤£nµoªí¶i¶¥¥\¯àn¨D¨ì phpbb.com ªº°Q½×ª©, ³o·|¨Ï±o¶}µo¤p²Õ¤À¤ßµLªkP¤O·s¥\¯àªº¶}µo. ½Ð¦bª©±ÂsÄý, ¦pªG¦³¥ô¦ó§Ṳ́w¶}µo¥B¸g¹L´ú¸Õªºµ{¦¡§ÚÌ·|©ñ¦bª©±¤Wªº.");
! $faq[] = array("§Ú¸Ó¦V½ÖÁpô¦³Ãö³oÓ°Q½×ª©»~¥Î©Îªk«ß¤Wªº¬ÛÃö¨Æ°È?", "±z¥i¥H³sµ¸³oÓ°Q½×ª©ªººÞ²zªÌ. ¦pªG±z¤£¯à§ä¨ì³oÓª©±ªººÞ²zªÌ¥H´M¨D§ó¶i¤@¨BªºªºÁpô. ¦pªG±z³sµ¸ºÞ²zªÌ¤§«á¤´µM¨S¦³¦^À³ (´M§ä whois ) ©ÎªÌ¨ä¬OÄÝ©ó¤@Ó°õ¦æ¤¤ªº§K¶OªA°È (¨Ò¦p: yahoo, free.fr, f2s.com...µ¥µ¥), ºÞ²zªÌ©Î»~¥Î¦¹ªA°Èªº³¡ªù. ½Ð°O¦í phpBB Group ¬O§¹¥þ¨S¦³±±¨îÅv¦Ó¥B§¹¥þ¤£t¥ô¦ó³d¥ôªº, ³oÓ°Q½×ª©¦ì©~¦ó³B¥H¤Î¦ó¤H¾Ö¦³. ¦b¬ÛÃöªk¥O¤U, §¹¥þ¨S¦³¦V phpBB Group «ü¥Ü (cease and desist, liable, defamatory comment...µ¥µ¥). ¤]³\¤£¬Oª½±µ¥Ñ phpbb.com website ¸ô®|¦Ó±o, ©ÎªÌ¬O¥u¦³ phpBB ¦¹³nÅ骺³¡¥÷¦Ó¤w. ¦pªG±z email ¨ì phpBB Group ¦³Ãö¥ô¦ó²Ä¤TªÌ¨Ï¥Î³nÅé¤Wªº°ÝÃD, ±zªºµª®×±N·|«D±`²³æ©Î¬O®Ú¥»¤£¤©¦^À³.");
//
Index: lang_main.php
===================================================================
RCS file: /cvsroot/phpbb/phpBB2/language/lang_chinese_traditional_taiwan/lang_main.php,v
retrieving revision 1.4
retrieving revision 1.4.2.1
diff -C2 -r1.4 -r1.4.2.1
*** lang_main.php 10 Mar 2002 03:23:55 -0000 1.4
--- lang_main.php 8 Apr 2002 14:44:13 -0000 1.4.2.1
***************
*** 1,1008 ****
! <?php
! /***************************************************************************
! * lang_main.php [English]
! * -------------------
! * begin : Sat Dec 16 2000
! * copyright : (C) 2001 The phpBB Group
! * email : su...@ph...
! *
! * $Id$
! *
[...1988 lines suppressed...]
! $lang['datetime']['Nov'] = "¤Q¤@¤ë";
! $lang['datetime']['Dec'] = "¤Q¤G¤ë";
!
! //
! // Errors (not related to a
! // specific failure on a page)
! //
! $lang['Information'] = "¨t²Î°T®§";
! $lang['Critical_Information'] = "«¤j°T®§";
!
! $lang['General_Error'] = "¤@¯ë¿ù»~";
! $lang['Critical_Error'] = "«¤j¿ù»~";
! $lang['An_error_occured'] = "µo¥Í¿ù»~";
! $lang['A_critical_error'] = "µo¥Í«¤j¿ù»~";
!
! //
! // That's all Folks!
! // -------------------------------------------------
!
?>
|
|
From: Paul S. O. <ps...@us...> - 2002-04-08 00:30:01
|
Update of /cvsroot/phpbb/phpBB2/db/schemas
In directory usw-pr-cvs1:/tmp/cvs-serv32000/db/schemas
Modified Files:
Tag: phpBB-2_0_0
mssql_schema.sql mysql_schema.sql postgres_schema.sql
Log Message:
Change user_timezone type to decimal
Index: mssql_schema.sql
===================================================================
RCS file: /cvsroot/phpbb/phpBB2/db/schemas/mssql_schema.sql,v
retrieving revision 1.24
retrieving revision 1.24.2.1
diff -C2 -r1.24 -r1.24.2.1
*** mssql_schema.sql 21 Mar 2002 13:59:33 -0000 1.24
--- mssql_schema.sql 8 Apr 2002 00:17:41 -0000 1.24.2.1
***************
*** 319,323 ****
[user_level] [smallint] NOT NULL ,
[user_posts] [int] NOT NULL ,
! [user_timezone] [real] NOT NULL ,
[user_style] [int] NULL ,
[user_lang] [varchar] (255) NULL ,
--- 319,323 ----
[user_level] [smallint] NOT NULL ,
[user_posts] [int] NOT NULL ,
! [user_timezone] [decimal] (4,2) NOT NULL ,
[user_style] [int] NULL ,
[user_lang] [varchar] (255) NULL ,
Index: mysql_schema.sql
===================================================================
RCS file: /cvsroot/phpbb/phpBB2/db/schemas/mysql_schema.sql,v
retrieving revision 1.17
retrieving revision 1.17.2.1
diff -C2 -r1.17 -r1.17.2.1
*** mysql_schema.sql 21 Mar 2002 13:59:33 -0000 1.17
--- mysql_schema.sql 8 Apr 2002 00:17:41 -0000 1.17.2.1
***************
*** 464,468 ****
user_level tinyint(4) DEFAULT '0',
user_posts mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
! user_timezone float DEFAULT '0' NOT NULL,
user_style tinyint(4),
user_lang varchar(255),
--- 464,468 ----
user_level tinyint(4) DEFAULT '0',
user_posts mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
! user_timezone decimal(4,2) DEFAULT '0' NOT NULL,
user_style tinyint(4),
user_lang varchar(255),
Index: postgres_schema.sql
===================================================================
RCS file: /cvsroot/phpbb/phpBB2/db/schemas/postgres_schema.sql,v
retrieving revision 1.19
retrieving revision 1.19.2.1
diff -C2 -r1.19 -r1.19.2.1
*** postgres_schema.sql 21 Mar 2002 13:59:33 -0000 1.19
--- postgres_schema.sql 8 Apr 2002 00:17:41 -0000 1.19.2.1
***************
*** 479,483 ****
user_level int4 DEFAULT '1',
user_lang varchar(255),
! user_timezone real DEFAULT '0' NOT NULL,
user_dateformat varchar(14) DEFAULT 'd M Y H:m' NOT NULL,
user_notify_pm int2 DEFAULT '1' NOT NULL,
--- 479,483 ----
user_level int4 DEFAULT '1',
user_lang varchar(255),
! user_timezone decimal(4) DEFAULT '0' NOT NULL,
user_dateformat varchar(14) DEFAULT 'd M Y H:m' NOT NULL,
user_notify_pm int2 DEFAULT '1' NOT NULL,
|
|
From: Paul S. O. <ps...@us...> - 2002-04-07 19:40:18
|
Update of /cvsroot/phpbb/phpBB2
In directory usw-pr-cvs1:/tmp/cvs-serv18446
Modified Files:
Tag: phpBB-2_0_0
search.php
Log Message:
Fix issue with URI sid and post subject links
Index: search.php
===================================================================
RCS file: /cvsroot/phpbb/phpBB2/search.php,v
retrieving revision 1.72.2.2
retrieving revision 1.72.2.3
diff -C2 -r1.72.2.2 -r1.72.2.3
*** search.php 7 Apr 2002 18:33:12 -0000 1.72.2.2
--- search.php 7 Apr 2002 19:18:04 -0000 1.72.2.3
***************
*** 741,745 ****
$forum_url = append_sid("viewforum.$phpEx?" . POST_FORUM_URL . '=' . $searchset[$i]['forum_id']);
$topic_url = append_sid("viewtopic.$phpEx?" . POST_TOPIC_URL . '=' . $searchset[$i]['topic_id'] . "&highlight=$highlight_active");
! $post_url = append_sid("viewtopic.$phpEx?" . POST_POST_URL . '=' . $searchset[$i]['post_id'] . "&highlight=$highlight_active#" . $searchset[$i]['post_id']);
$post_date = create_date($board_config['default_dateformat'], $searchset[$i]['post_time'], $board_config['board_timezone']);
--- 741,745 ----
$forum_url = append_sid("viewforum.$phpEx?" . POST_FORUM_URL . '=' . $searchset[$i]['forum_id']);
$topic_url = append_sid("viewtopic.$phpEx?" . POST_TOPIC_URL . '=' . $searchset[$i]['topic_id'] . "&highlight=$highlight_active");
! $post_url = append_sid("viewtopic.$phpEx?" . POST_POST_URL . '=' . $searchset[$i]['post_id'] . "&highlight=$highlight_active") . '#' . $searchset[$i]['post_id'];
$post_date = create_date($board_config['default_dateformat'], $searchset[$i]['post_time'], $board_config['board_timezone']);
|
|
From: Paul S. O. <ps...@us...> - 2002-04-07 19:38:48
|
Update of /cvsroot/phpbb/phpBB2/includes
In directory usw-pr-cvs1:/tmp/cvs-serv20489/includes
Modified Files:
Tag: phpBB-2_0_0
usercp_avatar.php usercp_register.php
Log Message:
Fix incorrect behaviour of allow view online when returning from avatar gallery
Index: usercp_avatar.php
===================================================================
RCS file: /cvsroot/phpbb/phpBB2/includes/usercp_avatar.php,v
retrieving revision 1.8
retrieving revision 1.8.2.1
diff -C2 -r1.8 -r1.8.2.1
*** usercp_avatar.php 31 Mar 2002 00:06:34 -0000 1.8
--- usercp_avatar.php 7 Apr 2002 19:26:07 -0000 1.8.2.1
***************
*** 234,238 ****
}
! function display_avatar_gallery($mode, &$category, &$user_id, &$email, &$current_email, &$coppa, &$username, &$email, &$icq, &$aim, &$msn, &$yim, &$website, &$location, &$occupation, &$interests, &$signature, &$viewemail, &$notifypm, &$popuppm, &$notifyreply, &$attachsig, &$allowhtml, &$allowbbcode, &$allowsmilies, &$allowviewonline, &$style, &$language, &$timezone, &$dateformat)
{
global $board_config, $db, $template, $lang, $images, $theme;
--- 234,238 ----
}
! function display_avatar_gallery($mode, &$category, &$user_id, &$email, &$current_email, &$coppa, &$username, &$email, &$icq, &$aim, &$msn, &$yim, &$website, &$location, &$occupation, &$interests, &$signature, &$viewemail, &$notifypm, &$popuppm, &$notifyreply, &$attachsig, &$allowhtml, &$allowbbcode, &$allowsmilies, &$hideonline, &$style, &$language, &$timezone, &$dateformat)
{
global $board_config, $db, $template, $lang, $images, $theme;
***************
*** 310,314 ****
}
! $params = array('coppa', 'user_id', 'username', 'email', 'current_email', 'icq', 'aim', 'msn', 'yim', 'website', 'location', 'occupation', 'interests', 'signature', 'viewemail', 'notifypm', 'popuppm', 'notifyreply', 'attachsig', 'allowhtml', 'allowbbcode', 'allowsmilies', 'allowviewonline', 'style', 'language', 'timezone', 'dateformat');
$s_hidden_vars = '<input type="hidden" name="agreed" value="true" />';
--- 310,314 ----
}
! $params = array('coppa', 'user_id', 'username', 'email', 'current_email', 'icq', 'aim', 'msn', 'yim', 'website', 'location', 'occupation', 'interests', 'signature', 'viewemail', 'notifypm', 'popuppm', 'notifyreply', 'attachsig', 'allowhtml', 'allowbbcode', 'allowsmilies', 'hideonline', 'style', 'language', 'timezone', 'dateformat');
$s_hidden_vars = '<input type="hidden" name="agreed" value="true" />';
***************
*** 334,336 ****
}
! ?>
--- 334,336 ----
}
! ?>
\ No newline at end of file
Index: usercp_register.php
===================================================================
RCS file: /cvsroot/phpbb/phpBB2/includes/usercp_register.php,v
retrieving revision 1.20.2.1
retrieving revision 1.20.2.2
diff -C2 -r1.20.2.1 -r1.20.2.2
*** usercp_register.php 7 Apr 2002 00:58:51 -0000 1.20.2.1
--- usercp_register.php 7 Apr 2002 19:26:07 -0000 1.20.2.2
***************
*** 708,711 ****
--- 708,713 ----
);
+ $allowviewonline = !$allowviewonline;
+
display_avatar_gallery($mode, $avatar_category, $user_id, $email, $current_email, $coppa, $username, $email, $icq, $aim, $msn, $yim, $website, $location, $occupation, $interests, $signature, $viewemail, $notifypm, $popuppm, $notifyreply, $attachsig, $allowhtml, $allowbbcode, $allowsmilies, $allowviewonline, $user_style, $user_lang, $user_timezone, $user_dateformat);
}
|
7 messages has been excluded from this view by a project administrator.
