How to know wich file is associate with wich post?

Get help with installation and running phpBB 3.0.x here. Please do not post bug reports, feature requests, or MOD-related questions here.
Scam Warning
Forum rules
END OF SUPPORT: 1 January 2017 (announcement)
Locked
laior
Registered User
Posts: 40
Joined: Tue May 06, 2008 12:17 pm

How to know wich file is associate with wich post?

Post by laior » Wed May 20, 2009 1:13 pm

How to know wich file is associate with wich post?

Can we know that?

narqelion
I've Been Banned!
Posts: 7235
Joined: Sat Dec 13, 2008 5:00 pm
Contact:

Re: How to know wich file is associate with wich post?

Post by narqelion » Wed May 20, 2009 1:44 pm

Do you mean attachments? :?

laior
Registered User
Posts: 40
Joined: Tue May 06, 2008 12:17 pm

Re: How to know wich file is associate with wich post?

Post by laior » Wed May 20, 2009 3:33 pm

Yes

User avatar
stevemaury
Support Team Member
Support Team Member
Posts: 50885
Joined: Thu Nov 02, 2006 12:21 am
Location: The U.P.
Name: Steve
Contact:

Re: How to know wich file is associate with wich post?

Post by stevemaury » Wed May 20, 2009 5:08 pm

Do you want to know the real filename of an attachment to a specific post? And if not, exactly what do you want?
For REALLY good and VERY inexpensive hosting CLICK HERE

I can stop all your spam. I can upgrade or update your Board. PM or email me. (Paid support)

laior
Registered User
Posts: 40
Joined: Tue May 06, 2008 12:17 pm

Re: How to know wich file is associate with wich post?

Post by laior » Wed May 20, 2009 5:20 pm

No

In my ftp software in "files" folder I have a lot of name like this one : "490_345f8ba138a3a2c9d05a5e4b1b44c554"

I know it's corresponds to a rar or jpg file and I want to know wich rar or jpg file it's corresponds or what post this name files is corresponding.

User avatar
stevemaury
Support Team Member
Support Team Member
Posts: 50885
Joined: Thu Nov 02, 2006 12:21 am
Location: The U.P.
Name: Steve
Contact:

Re: How to know wich file is associate with wich post?

Post by stevemaury » Wed May 20, 2009 6:15 pm

Oh. OK. You can do it with sql:

Code: Select all

SELECT `real_filename`, `post_msg_id` FROM phpbb_attachments WHERE `physical_filename` = '490_345f8ba138a3a2c9d05a5e4b1b44c554';
That will return the actual name of the file and the post_id where it is attached.
For REALLY good and VERY inexpensive hosting CLICK HERE

I can stop all your spam. I can upgrade or update your Board. PM or email me. (Paid support)

Locked

Return to “[3.0.x] Support Forum”