The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
||||
|
||||
How to identify a file to attachment id ?
Hello
Could someone tell me please is there any easy way to find a file by ID ? for example I see link to attachment - /attachment.php?attachmentid=72697&d=1390755704 but the file name is /customattachments/9/4/7/2/8/67174.attach So, how/where to get that info in most easy way (like some search field or a table or ...) ? Thank you |
#2
|
|||
|
|||
9/4/7/2/8 > 94728 in the path of the file on the server is the userid of the user.
72697 is the attachmentid in the attachment table. You could query SELECT userid FROM attachment WHERE attachmentid = 72697 to get the userid. |
#3
|
||||
|
||||
i dont need the user id. i can see who posted attachment. i need to know the name of real file if i know only like this - /attachment.php?attachmentid=72697
|
#5
|
||||
|
||||
I'm sorry, I just don't get it - what to do exactly?!..
could you please provide me with step-by-step instruction? Thank yoy anyway! --------------- Added [DATE]1457777231[/DATE] at [TIME]1457777231[/TIME] --------------- So, I see link /attachment.php?attachmentid=72697 in post. I go to /admincp/queries.php?do=modify what exactly should I do there? |
#6
|
|||
|
|||
You execute the query I posted in my previous post. You will then see the filedataid which belongs to the attachment which you can then use to track the file on the server.
|
#7
|
||||
|
||||
Code:
SELECT filedataid FROM attachment WHERE attachmentid = 72697 Quote:
|
#8
|
|||
|
|||
Do you use a table prefix? (You can check that in the includes/config.php file). You have to prepend that prefix to "attachment".
So if your prefix is "ka81_" then you should change it to ka81_attachment. |
#9
|
||||
|
||||
Whenever I need to find a file from ID I just put the number in to the vbulletin search and check the post it's in.
|
#10
|
||||
|
||||
Quote:
I CAN NOT see what file was for that attachment! it says - Invalid Attachment specified. If you followed a valid link, please notify the administrator and that's all, no more any info!!! --------------- Added [DATE]1457781656[/DATE] at [TIME]1457781656[/TIME] --------------- Dave thank you very much! but what if query don't give any result? |
Thread Tools | |
Display Modes | |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|