aboutsummaryrefslogtreecommitdiffstats
path: root/phpBB
diff options
context:
space:
mode:
authorLudovic Arnaud <ludovic_arnaud@users.sourceforge.net>2002-10-07 01:07:41 +0000
committerLudovic Arnaud <ludovic_arnaud@users.sourceforge.net>2002-10-07 01:07:41 +0000
commita5a63df36f05eda4f5703e20e39082aaffb0eceb (patch)
tree0950c01497fa821842776308d0a2b933f044c46c /phpBB
parentcf0ac8d63175dc60264bf39ce3b152ee1ef64fbe (diff)
downloadforums-a5a63df36f05eda4f5703e20e39082aaffb0eceb.tar
forums-a5a63df36f05eda4f5703e20e39082aaffb0eceb.tar.gz
forums-a5a63df36f05eda4f5703e20e39082aaffb0eceb.tar.bz2
forums-a5a63df36f05eda4f5703e20e39082aaffb0eceb.tar.xz
forums-a5a63df36f05eda4f5703e20e39082aaffb0eceb.zip
Fixed last poster name, dumped categories table.
git-svn-id: file:///svn/phpbb/trunk@2939 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB')
-rw-r--r--phpBB/includes/forums_display.php2
-rw-r--r--phpBB/install/schemas/mysql_basic.sql2
-rw-r--r--phpBB/install/schemas/mysql_schema.sql14
3 files changed, 2 insertions, 16 deletions
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']) . '<br />';
- $last_post .= ($user_id == ANONYMOUS) ? (($forum_last_poster_name != '') ? $forum_last_poster_name . ' ' : $lang['Guest'] . ' ') : '<a href="profile.' . $phpEx . $SID . '&amp;mode=viewprofile&amp;u=' . $user_id . '">' . $username . '</a> ';
+ $last_post .= ($forum_last_poster_id == ANONYMOUS) ? (($forum_last_poster_name != '') ? $forum_last_poster_name . ' ' : $lang['Guest'] . ' ') : '<a href="profile.' . $phpEx . $SID . '&amp;mode=viewprofile&amp;u=' . $forum_last_poster_id . '">' . $username . '</a> ';
$last_post .= '<a href="viewtopic.' . $phpEx . '$SID&amp;f=' . $forum_id . '&amp;p=' . $forum_last_post_id . '#' . $forum_last_post_id . '">' . create_img($theme['goto_post_latest'], $lang['View_latest_post']) . '</a>';
}
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
@@ -94,19 +94,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'
#
CREATE 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,