RSS Feed/News vBulletin 4 Albums Importer: Comments on pictures are being imported for incorrect images

[ENXF NET]

Code:

SELECT
    att.*,
    f.*,
    u.username,
    a.*,
    att.attachmentid AS pictureid
FROM attachment AS att

vs

Code:

SELECT
    c.*,
    u.*,
    IF(u.username IS NULL, c.postusername, u.username) AS username,
    c.filedataid AS pictureid
FROM picturecomment AS c

So the media items do get imported using the old field attachmentid, but the comments do use filedataid for lookups - this does not work as those are different IDs (in vBulletin 4 the same filedataid can...

Read more

Continue reading...