Yeah, I wouldn't've suggested just cutting and pasting your user table. That wasn't going to work. That's why I asked everyone at my old board to register at the new one under the same name (or if they changed it, to let me know explicitly; I had/have scripts to handle that kind of thing, as LynnInDenver can testify). I suggest you truncate that table and do the same; then once everyone has recreated their accounts, you can write a script to carry over data like original registration dates and whatnot.
As for posts and threads, well, if PHPBB works much like MyBB, it's going to be ... complicated. You're going to have to create thread records and post records in parallel because they reference each other. And you can't just cut and paste from your old board because there's no guarantee that the thread and post IDs are even going to be close; in fact it's almost guaranteed that unless you recreate every thread and post on the board in perfect chronological order they won't be. That's why I needed to use cursors -- I needed to recreate one thread at a time and then insert its posts one post at a time, in proper order to maintain the board integrity.
If I get a chance I'll see if the PHPBB database structure is on line anywhere, and give it a look-see; maybe I can offer you some more specific advice.
As for posts and threads, well, if PHPBB works much like MyBB, it's going to be ... complicated. You're going to have to create thread records and post records in parallel because they reference each other. And you can't just cut and paste from your old board because there's no guarantee that the thread and post IDs are even going to be close; in fact it's almost guaranteed that unless you recreate every thread and post on the board in perfect chronological order they won't be. That's why I needed to use cursors -- I needed to recreate one thread at a time and then insert its posts one post at a time, in proper order to maintain the board integrity.
If I get a chance I'll see if the PHPBB database structure is on line anywhere, and give it a look-see; maybe I can offer you some more specific advice.
-- Bob
I have been Roland, Beowulf, Achilles, Gilgamesh, Clark Kent, Mary Sue, DJ Croft, Skysaber. I have been
called a hundred names and will be called a thousand more before the sun grows dim and cold....
I have been Roland, Beowulf, Achilles, Gilgamesh, Clark Kent, Mary Sue, DJ Croft, Skysaber. I have been
called a hundred names and will be called a thousand more before the sun grows dim and cold....