From a5a63df36f05eda4f5703e20e39082aaffb0eceb Mon Sep 17 00:00:00 2001 From: Ludovic Arnaud Date: Mon, 7 Oct 2002 01:07:41 +0000 Subject: Fixed last poster name, dumped categories table. git-svn-id: file:///svn/phpbb/trunk@2939 89ea8834-ac86-4346-8a33-228a782c2dd0 --- phpBB/includes/forums_display.php | 2 +- phpBB/install/schemas/mysql_basic.sql | 2 +- phpBB/install/schemas/mysql_schema.sql | 14 -------------- 3 files changed, 2 insertions(+), 16 deletions(-) (limited to 'phpBB') diff --git a/phpBB/includes/forums_display.php b/phpBB/includes/forums_display.php index 8120576aea..d995afc9de 100644 --- a/phpBB/includes/forums_display.php +++ b/phpBB/includes/forums_display.php @@ -89,7 +89,7 @@ foreach ($forum_rows as $row) { $last_post = create_date($board_config['default_dateformat'], $forum_last_post_time, $board_config['board_timezone']) . '
'; - $last_post .= ($user_id == ANONYMOUS) ? (($forum_last_poster_name != '') ? $forum_last_poster_name . ' ' : $lang['Guest'] . ' ') : '' . $username . ' '; + $last_post .= ($forum_last_poster_id == ANONYMOUS) ? (($forum_last_poster_name != '') ? $forum_last_poster_name . ' ' : $lang['Guest'] . ' ') : '' . $username . ' '; $last_post .= '' . create_img($theme['goto_post_latest'], $lang['View_latest_post']) . ''; } diff --git a/phpBB/install/schemas/mysql_basic.sql b/phpBB/install/schemas/mysql_basic.sql index 1f1ea0df28..31f6ca9425 100644 --- a/phpBB/install/schemas/mysql_basic.sql +++ b/phpBB/install/schemas/mysql_basic.sql @@ -148,7 +148,7 @@ INSERT INTO phpbb_styles_theme (theme_id, css_data, css_external) VALUES (1, 'th # -- Forums -INSERT INTO phpbb_forums (forum_id, forum_name, forum_desc, left_id, right_id, parent_id, forum_posts, forum_topics, forum_last_post_id) VALUES (1, 'Test Forum 1', 'This is just a test forum.', 1, 2, 0, 1, 1, 1); +INSERT INTO phpbb_forums (forum_id, forum_name, forum_desc, left_id, right_id, parent_id, forum_posts, forum_topics, forum_last_post_id, forum_last_poster_id) VALUES (1, 'Test Forum 1', 'This is just a test forum.', 1, 2, 0, 1, 1, 1, 2); # -- Users diff --git a/phpBB/install/schemas/mysql_schema.sql b/phpBB/install/schemas/mysql_schema.sql index 9f30fbbd61..943e09c506 100644 --- a/phpBB/install/schemas/mysql_schema.sql +++ b/phpBB/install/schemas/mysql_schema.sql @@ -92,19 +92,6 @@ CREATE TABLE phpbb_banlist ( ); -# -------------------------------------------------------- -# -# Table structure for table 'phpbb_categories' <- DUMP THIS? -# -CREATE TABLE phpbb_categories ( - cat_id mediumint(8) UNSIGNED NOT NULL auto_increment, - cat_title varchar(60), - cat_order mediumint(8) UNSIGNED NOT NULL, - PRIMARY KEY (cat_id), - KEY cat_order (cat_order) -); - - # -------------------------------------------------------- # # Table structure for table 'phpbb_config' @@ -133,7 +120,6 @@ CREATE TABLE phpbb_disallow ( # CREATE TABLE phpbb_forums ( forum_id smallint(5) UNSIGNED NOT NULL, - cat_id smallint(5) UNSIGNED NOT NULL, parent_id smallint(5) UNSIGNED NOT NULL, left_id smallint(5) UNSIGNED NOT NULL, right_id smallint(5) UNSIGNED NOT NULL, -- cgit v1.2.1