XF 1.5 How does xenForo store attachments?

BaeFell

Member
Hiya!

I'm trying to do some tools to help moderators review resources submitted via xenForo Resource Manager. One way is an external viewer, but I cannot figure out how a file like "123-a4173ab2dbc4952e38485aa18e866e37.data" relates back to the actual resource. Is there a specific method of knowing which file is for which resource?

Thanks
 

BaeFell

Member
Solved.

Example resource ID: 238
Resource Manager download button has a ?version=<number> at the end of the download URL. In xf_attachment table there content_id which is the same as the <number> in the URL (488). Then in xf_attachment_data there is data_id which is the same as the content_id. This then gives you the number of the file and then the file_hash for a full data URL.

Hope this helps someone.
 
Top