if I want to have the following conversion scripts run along the others by convert.php.
after adding it to fluxbb_to_smf.sql file, I guess I must add some kind of call in convert.php?
also, the scripts must be wrong somewhere, cause when i run them directly on mysql server, with proper dbname+prefix instead of the variables {$from_prefix} {$to_prefix}, it doesn't seem to fill the smf_personal_messages and smf_pm_recipients tables. can anyone have a look please?
thanks in advance
/******************************************************************************/
--- Converting pm...
/******************************************************************************/
TRUNCATE {$to_prefix}personal_messages;
---* {$to_prefix}personal_messages
SELECT
pm.id AS id_pm, pm.id AS id_pm_head, pm.sender_id AS id_member_from, pm.sender AS from_name,
pm.posted AS msgtime,
SUBSTRING(pm.subject, 1, 255) AS subject,
SUBSTRING(REPLACE(pm.message, '<br>', '<br />'), 1, 65534) AS body
FROM {$from_prefix}messages AS pm
INNER JOIN {$from_prefix}users AS u ON (u.id = pm.sender_id);
---*
TRUNCATE {$to_prefix}pm_recipients;
---* {$to_prefix}pm_recipients
SELECT
pm.id AS id_pm, pm.owner AS id_member,
pm.showed AS is_read, pm.status AS deleted,
SUBSTRING(pm.subject, 1, 60) AS labels
FROM {$from_prefix}messages AS pm
INNER JOIN {$from_prefix}users AS u ON (u.id = pm.owner);
---*