[SMF Converter] Burning Board 3

[margarett]

In fact there is no WHERE but it should

And no, the converter doesn't copy all files, just the files retrieved by the SELECT query

[iMpuLz]

Ah okay.

Changed it to:

Code Select Expand

SELECT
attachmentID, containerID AS id_msg, downloads AS downloads, attachmentName AS filename
FROM {$from_prefix}{$wcf_prefix}attachment
WHERE containerType ='post';


Going to test it in 20 or 30 minutes and will report if it has worked.

[iMpuLz]

Attached the fixed .sql with "WHERE containerType ='post';"

It looks like it worked:
PRE fix: 625 attachments
Post fix: 549 attachments


But I noticed something strange:
It only creates some thumbnails. As soon as a post with a thumbnail is called up, a record is created in the database with the filename and _thumb attached as filename and an attachment type of 3. The rest has the following values:

Code Select Expand

attachment_type = 0
id_thumb = 0
fileext = empty
width = 0
height = 0
mime_type = empty