diff options
| author | Bart van Bragt <bartvb@users.sourceforge.net> | 2001-03-03 23:17:39 +0000 |
|---|---|---|
| committer | Bart van Bragt <bartvb@users.sourceforge.net> | 2001-03-03 23:17:39 +0000 |
| commit | e9aedae48fac38e7087514d4a863ff2b836378b3 (patch) | |
| tree | 8ca71c3564abb4b408f6f3630f75de9e2a4af15c /phpBB/upgrade_20.php | |
| parent | f4a63f8dbb61146f94143abab1d213f5d215de3c (diff) | |
| download | forums-e9aedae48fac38e7087514d4a863ff2b836378b3.tar forums-e9aedae48fac38e7087514d4a863ff2b836378b3.tar.gz forums-e9aedae48fac38e7087514d4a863ff2b836378b3.tar.bz2 forums-e9aedae48fac38e7087514d4a863ff2b836378b3.tar.xz forums-e9aedae48fac38e7087514d4a863ff2b836378b3.zip | |
Added some new DB fields, fixed bug where all topics where assigned to one forum
git-svn-id: file:///svn/phpbb/trunk@79 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB/upgrade_20.php')
| -rw-r--r-- | phpBB/upgrade_20.php | 9 |
1 files changed, 8 insertions, 1 deletions
diff --git a/phpBB/upgrade_20.php b/phpBB/upgrade_20.php index d9eaf59182..2081b36a07 100644 --- a/phpBB/upgrade_20.php +++ b/phpBB/upgrade_20.php @@ -238,6 +238,7 @@ Backups completed ok.<P> forum_id int(10) NOT NULL, topic_status tinyint(3) DEFAULT '0' NOT NULL, topic_notify tinyint(3) DEFAULT '0', + topic_last_post_id int(11) DEFAULT '0' NOT NULL, KEY(forum_id), PRIMARY KEY (topic_id))", "banlist" => "CREATE TABLE banlist( @@ -270,6 +271,7 @@ Backups completed ok.<P> drop_column($db, "forums", "forum_moderator"); change_column($db, "forums", "forum_access", "tinyint(3)", "null"); change_column($db, "forums", "forum_type", "tinyint(3)", "null"); + add_column($db, "forums", "forum_order", "int(10)", "default '0' not null"); add_column($db, "forums", "forum_posts", "int(10)", "default '0' not null"); add_column($db, "forums", "forum_topics", "int(10)", "default '0' not null"); add_column($db, "forums", "forum_last_post_id", "int(10)", "default '0' not null"); @@ -328,6 +330,7 @@ Backups completed ok.<P> $r = mysql_query("select * from posts_backup", $db); echo "Converting posts and creating posts_text ...<br>"; + flush(); while ($row = mysql_fetch_array($r)) { @@ -356,6 +359,7 @@ Backups completed ok.<P> echo mysql_error($db); echo "Converting priv_msgs ..<br>"; + flush(); while ($row = mysql_fetch_array($r)) { @@ -379,6 +383,7 @@ Backups completed ok.<P> $r = mysql_query("select * from sessions_backup", $db); echo "Converting sessions ..<br>"; + flush(); while ($row = mysql_fetch_array($r)) { @@ -399,6 +404,7 @@ Backups completed ok.<P> $r = mysql_query("select * from topics_backup", $db); echo "Converting topics ..<br>"; + flush(); while ($row = mysql_fetch_array($r)) { @@ -408,7 +414,7 @@ Backups completed ok.<P> $topic_title = $row['topic_title']; $topic_poster = $row['topic_poster']; $topic_views = $row['topic_views']; - $topic_id = $row['topic_id']; + $forum_id = $row['forum_id']; $topic_status = $row['topic_status']; $topic_notify = $row['topic_notify']; @@ -423,6 +429,7 @@ Backups completed ok.<P> $r = mysql_query("select * from banlist_backup", $db); echo "Converting banlist ..<br>"; + flush(); while ($row = mysql_fetch_array($r)) { |