[Oblivion Knight]

Originally Posted by Cloud-Warrior

I'm having problems with step seven of the script, due to the huge tables I have... I've had to change the first two SELECT queries to:

SELECT u.username, u.ipaddress, j.journal_id FROM user as u left join journals as j on u.userid=j.journalist_id WHERE j.journal_id<>"";

SELECT u.username, u.ipaddress, c.comment_id FROM user as u left join journal_comments AS c ON u.userid = c.commenter_id WHERE c.comment_id <> "";

Otherwise they run for way too long and the script times out.

Aha, the script hasn't been tested on a huge forum before, so thanks for the feedback. I'll update them shortly..

Other than that, did everything work ok for you?