XF 1.5 Get attachment's filename on the system based on DB values

[SpecialK]

I know how to find the location of the physical attachment file for a given attachment. For example, I know that data ID 23557 is going to be in internal_data/attachments/23/23557-*.data. The problem is that I need to know how to calculate that * value (I assume it's a hash of some sort) based on the information in the database. Can anyone shed some light into how I can figure out the EXACT path to a given data id based on the information in the database tables?

 

[Jeremy P]

Check out file_hash on the corresponding xf_attachment_data row.

 

[SpecialK]

I...I don't know how I missed that. Late night I guess.

Thanks @Jeremy P