How attachments are stored in XenForo

[Andy]

When a image file is attached using the Attach files button:

The image will get an attachment_id.

For example:

[ATTACH]545168[/ATTACH]

Using phpMyAdmin, you can see the attachment _id in the xf_attachment table:

The data_id has a number 430544, this number is used in the file system to store the file. Use File manager in cPanel do navigate to the following folder:

internal_data/attachments/430/

In the /430/ folder you will see the following file:

 

[Andy]

So lets say you want to go to the post where attachment_id 545168 is posted, use the content_id like this:

https://domain.com/posts/2242022