What's all this then?

[m0loch]

Sciencetech (AKA Glenn) was kind enough to provide me with an sql dump of his iceboard.org site in the hope that the posts could be imported here.

There is no 'drop-in' solution to accomplish this and I would soon find out that there is good reason for this. The script to merge posts from iceboard into this forum had to be hand-coded from scratch and presented many problems. Nonetheless, I'm calling this a success but not completed. Here's a to do list:

There are many "Guest" posts - get the user id and associated username from iceboardand replace "Guest" with a name

Link usernames from iceboard to usernames on this board and update posts with the correct userid

restore original timestamps on posts

make forum read/write for registered users

restore iceboard forum hierarchy here (not likely to actually happen)

[m0loch]

O.K. - I'm using this thread as a sort of a 'version tracker'
what you see in this forum now is version 1.1 of the iceboard import. Here's what's new in this run:
Excluded the "administrative chit-chat" from the import
Copied over usernames from original posts in place of "Guest"
cleaned up the text of posts a bit - originally at the end of the post, poster name was given as a way to track who actually posted - this wasn't needed anymore once the "Guest" post issue was resolved.
various other minor bug fixes

to do:
There are many "Guest" posts - get the user id and associated username from iceboardand replace "Guest" with a name

Link usernames from iceboard to usernames on this board and update posts with the correct userid

restore original timestamps on posts

make forum read/write for registered users

restore iceboard forum hierarchy here (not likely to actually happen) - Actually, this won't be as tough to do as originally thought.

match usernames from iceboard to usernames on Antarctic memories

in case a user from iceboard is also here, but under a different username, convert the iceboard username to the Antarctic memories username

further scrutiny of the iceboard username - matching both the "username_clean" column and "user_email" fields from the databases

[m0loch]

results of version 1.2 can currently (as of 6/15/09) be previewed under the "testing" forum (only for privileged users)
New Features:
added 2 functions:

one matches an iceboard username to an AM username and if there is a match, updates the imported post 'poster_id' with the proper AM 'user_id' - else, sets the user-id to '1' "Anonymous" and preserves the 'poster_name' *any imported posts attributed to "Anonymous" or "Guest" from iceboard will belong to user "Iceboard" on AM*

one simply grabs an iceboard username from 'phpbb_users' using the 'poster_id' from 'phpbb_posts' - this is then passed to the other function as a parameter.

used a mysql query UPDATE to grab the timestamp from the iceboard post and insert it into the AM post - solved the timestamp thing and the post/thread ordering problem

holy cow! a mysql query! - seems this can be used for many other things too...namely fetching the proper bbcode info and passing it to phpbb's submit_post as part of the $data array - bbcode (quotes/urls etc..) are now displaying (mostly) properly - hurray! - oh, and even better - can now run the script without having to open the forum up to be world writeable - use mysql query to also set the 'post_approved' field to '1' - still requires a resync of the forum via the ACP but this was needed anyhow to make the timestamps work.

in my head, I have it sorted how to solve the hierarchy thing....pretty easy actually, just need to go about setting the forums up to be imported into.



to do:
There are many "Guest" posts - get the user id and associated username from iceboardand replace "Guest" with a name

Link usernames from iceboard to usernames on this board and update posts with the correct userid

restore original timestamps on posts

make forum read/write for registered users

restore iceboard forum hierarchy here (not likely to actually happen) - Actually, this won't be as tough to do as originally thought.

match usernames from iceboard to usernames on Antarctic memories

in case a user from iceboard is also here, but under a different username, convert the iceboard username to the Antarctic memories username - partially complete - known users have been converted. IF YOU HAD AN ACCOUNT ON ICEBOARD PLEASE LET ME KNOW WHAT THE USERNAME WAS AND I'LL MATCH UP POSTS FROM THERE WITH YOUR USERNAME HERE (if it's different - and yes, username matches are case sensitive)

further scrutiny of the iceboard username - matching both the "username_clean" column and "user_email" fields from the databases

[m0loch]

getting much closer - in fact, the biggest challenge now is to set up forums to mirror the hierarchy of the iceboard and import the posts in their respective places....once that's done, I'll import that bit - let some senior members check it out and go live with the final product !!

matching a username with a "username_clean" caused hella problems - so, had to split the routine up - first it matches either the username OR the email - only if it fails to find a match in one of those first will it then check for a username_clean GAACKKK


to do:
There are many "Guest" posts - get the user id and associated username from iceboardand replace "Guest" with a name

Link usernames from iceboard to usernames on this board and update posts with the correct userid

restore original timestamps on posts

make forum read/write for registered users

restore iceboard forum hierarchy here (not likely to actually happen) - Actually, this won't be as tough to do as originally thought.

match usernames from iceboard to usernames on Antarctic memories

in case a user from iceboard is also here, but under a different username, convert the iceboard username to the Antarctic memories username -partially complete - known users have been converted.

IF YOU HAD AN ACCOUNT ON ICEBOARD PLEASE LET ME KNOW WHAT THE USERNAME WAS AND I'LL MATCH UP POSTS FROM THERE WITH YOUR USERNAME HERE (if it's different - and yes, username matches are case sensitive)


further scrutiny of the iceboard username - matching both the "username_clean" column and "user_email" fields from the

[m0loch]

Well, from the humble beginnings of 19 lines of code that did little more than post a message using input from the former iceboard to the latest version which is 212 lines of code that has become nearly unmanageable, is horribly clunky and inefficient the 'to do' list has been completed. I'm quite happy with the results and I am calling it complete. Even if I were to go back now and clean up the code it would never be used again and I'm sick of looking at it. Unless someone sees something glaringly obviously wrong then I'm done with the whole thing and it's someone else's to deal with now.


to do:
There are many "Guest" posts - get the user id and associated username from iceboardand replace "Guest" with a name

Link usernames from iceboard to usernames on this board and update posts with the correct userid

restore original timestamps on posts

make forum read/write for registered users <- ok, so that one is left 'to do' but it won't be done inside the script and I ain't going to be doing it

restore iceboard forum hierarchy here(not likely to actually happen) - Actually, this won't be as tough to do as originally thought.

match usernames from iceboard to usernames on Antarctic memories

in case a user from iceboard is also here, but under a different username, convert the iceboard username to the Antarctic memories username -partially complete - known users have been converted.

IF YOU HAD AN ACCOUNT ON ICEBOARD PLEASE LET ME KNOW WHAT THE USERNAME WAS AND I'LL MATCH UP POSTS FROM THERE WITH YOUR USERNAME HERE (if it's different - and yes, username matches are case sensitive)


further scrutiny of the iceboard username - matching both the "username_clean" column and "user_email" fields from the