Before uploading the UCS and converter script to your server, you need to modify (open up the file with your preferred editor) it as per the following instructions (full credit to IngerK via filex):
- All the places with time/date in convert_webwiz.php in the arrays changed it TO
array('post_time' , 'UNIX_TIMESTAMP(tblThread.Message_date)'
- In webwiz_prepare_messages function changed:
return prepare_messages($Message, TRUE, TRUE, TRUE, make_uid())
$myvar = make_uid();
return prepare_messages($Message, TRUE, TRUE, TRUE, $myvar)
You can then upload the files to your server. Read the instructions in the READ ME file which is contained within the common_ucs folder. This will tell you where to put the files and where to put the convert_webwiz.php file so that it is available to the converter.
Once you have uploaded everything to the correct place, you can run the UCS script by inputting the path to the converter in your browser address bar (typically it would be something like http://www.yoursite.com/forum/convert/index.php
I think what I had to do at this point was to copy the entire Web Wiz forum folder from the old server to the new server, i.e. in the public_html directory I had the full Web Wiz folder alongside the phpBB folder.
This allowed me to input the correct relative paths into the UCS fields (see below). If I remember correctly you need to put in the relative path from phpBB to Web Wiz.
Fill in the fields (as per instructions from filex):
- leave table prefix blank
- For old forum URL: http://www.yoursite.com/oldforum
- For old forum path: ../oldforum/
Once you have put the right thing in, it will execute the convert script. At this point you should be able to access the converted forum and see if the topics, posts and members have transferred into phpBB.
The only thing you need to do now is make yourself an administrator by going directly into the forum database using phpMyAdmin, finding your username in the users table and change the user_level to 1 (thanks to Lumpy Burgertushie).
Essentially you should be where you want to be now. Your users will have to update their passwords, you may have to check their ranks and groups and reset them manually.