******/
--- Converting posts (this may take some time)...
/************************************************** ****************************/
TRUNCATE {$to_prefix}messages;
TRUNCATE {$to_prefix}attachments;
---* {$to_prefix}messages 200
---{
$row['body'] = preg_replace('~[file name=.+?]http.+?[/file]~i', '',
$row['body']);
$row['body'] = preg_replace('~[img size=(\d+)]~i', '[img width=$1]', $row['body']);
---}
SELECT
m.id AS ID_MSG, m.thread AS ID_TOPIC, m.time AS posterTime,
SUBSTRING(m.subject, 1, 255), m.userid AS ID_MEMBER,
SUBSTRING(m.name, 1, 255) AS posterName,
SUBSTRING(m.email, 1, 255) AS posterEmail,
SUBSTRING(m.ip, 1, 255) AS posterIP, m.catid AS ID_BOARD,
SUBSTRING(mt.message, 1, 65534) AS body, '' AS modifiedName, 'xx' AS icon
FROM ({$from_prefix}sb_messages AS m, {$from_prefix}sb_messages_text AS mt)
WHERE mt.mesid = m.id;
---*
/************************************************** **************************