Simple Machines Community Forum

SMF Support => Converting to SMF => Topic started by: packman on September 13, 2004, 04:43:25 PM

Title: ID_ATTACH in smf_members?
Post by: packman on September 13, 2004, 04:43:25 PM
[Unknown] - I think last time you looked at the phpBB2 converter you added the comment to the section that copies user avatars into SMF...

        // Technically, these should go in attachments/, with each member's ID_ATTACH set properly...

There isn't an ID_ATTACH field in my smf_members table. Is this new in the next release?
Title: Re: ID_ATTACH in smf_members?
Post by: Ben_S on September 13, 2004, 05:22:47 PM
ID_ATTACH is in the messages table.
Title: Re: ID_ATTACH in smf_members?
Post by: packman on September 13, 2004, 05:35:08 PM
Quote from: Ben_S on September 13, 2004, 05:22:47 PM
ID_ATTACH is in the messages table.

I'd spotted that one, but I can't see a connection between user uploaded avatars and the messages table. Unknown's comment suggested that uploaded avatars go into the attachments directory (which would make sense), but I can't work out how you'd then find the uploaded avatar for a specific member.
Title: Re: ID_ATTACH in smf_members?
Post by: [Unknown] on September 13, 2004, 08:27:10 PM
Actually, the only ID_ATTACH is on the attachments table.  There is no ID_ATTACH on the messages table. (or, there shouldn't be!)

Actually, in this case, for a variety of reasons... there's an ID_MEMBER on attachments.  If it is not zero, it means this attachment is actually an avatar.  It works just like an attachment (although it's always named avatar_ID_MEMBER.(png|jpeg)...).  The ID_MSG should, of course, be 0.

-[Unknown]
Title: Re: ID_ATTACH in smf_members?
Post by: packman on September 14, 2004, 03:48:00 PM
You're right...there isn't an ID_ATTACH on the messages table. I'm starting to see imaginary things...should I see a psychiatrist ::)

Just to confirm...a gif avatar for user 1234 should be called avatar_1234.gif ??
Title: Re: ID_ATTACH in smf_members?
Post by: packman on September 14, 2004, 05:28:21 PM
No need to confirm. I've worked out what's required and the converter now correctly handles uploaded avatars :)