XF 1.5 How does xenForo store attachments?

[BaeFell]

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]

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.