A few months ago I finished converting an old IPB 2.3.5 archive to SMF 2.0. I had to fix several problems in order to get the invision23_to_smf.sql script to work. I took the latest version I could find from the IPB 2.3 to SMF converter thread as well as introduce some fixes of my own.
Fixes taken from the IPB 2.3 to SMF converter topic:
Converting members
Altered the column properties of the passwd and password_salt columns in the SMF members
table to VARCHAR(64) NOT NULL with an empty default value
If an invalid birthdate value is encountered, it is set to 0001-01-01 instead
Grab the first 64 characters of the password salt instead of the first 5
The instant_messages value is cast to an integer
Converting topics
The id_poll value is cast to an integer
Converting posts
Changed incorrect string index from 'signature' to 'body'
The modified_time value is cast to an integer
Converting poll options
Added missing single-quotes to specify array index id_poll
Converting personal messages (part 1)
Changed incorrect string index from 'signature' to 'body'
Converting attachments
Added missing $ to the attachmentUploadDir variable
My fixes:
Converting members
The hide_email value is set to 1 if it is not set
the IPB bday_year, bday_month, and bday_day columns are concatenated with the "-"
character separating them, and the month and day values are padded with 0s if
they are less than 10
Added empty values for openid_uri and ignore_boards
Converting permissions
Added missing parameters when building the array for the convert_insert() call
Converting settings
Added $boarddir to get the path to the SMF folder
Properly added values to the $update_settings array for the call to convert_insert()
Converting calendar events
Fixed non-fatal error by adding semi-colon to the TRUNCATE {$to_prefix}calendar query
Fixed error by removing premature semi-colon before SQL query ends
Converting user avatars
Fixed getting the avatar directory if it does not exist
Also, some words have been changed (we have instead of we've, etc.) to make things better on code editors with syntax highlighting (like Notepad++). Some of these changes were done with the version fron the converter topic, and a few of them were done by me.
A few months ago I finished converting an old IPB 2.3.5 archive to SMF 2.0. I had to fix several problems in order to get the invision23_to_smf.sql script to work. I took the latest version I could find from the IPB 2.3 to SMF converter thread as well as introduce some fixes of my own.
Fixes taken from the IPB 2.3 to SMF converter topic:
My fixes:
Also, some words have been changed (we have instead of we've, etc.) to make things better on code editors with syntax highlighting (like Notepad++). Some of these changes were done with the version fron the converter topic, and a few of them were done by me.
Signed-off-by: MisterVector whizkid3000@hotmail.com