The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
||||
|
||||
Need help with a few functions
Hi
I am planning to create a new hack (my first) and I need some information before I start. 1) How do I check if the first post of a thread has an attachment? 2) Can I know if that attachment is an image file? 3) How do I get the location of that image? Please guide me with this stuff... Thanks Sunil Varma |
#2
|
||||
|
||||
Quote:
[sql]select count(*) as total from attachment a join thread t on (a.postid=t.firstpostid) where threadid=something; [/sql] if it comes back with a value > 0 then it has at least one attachement. 2) [sql]Select extension from attachment where something[/sql] extension is jpg or gif or pdf or whatever 3) if you are storing your images in the db you will find them as data in filedata field of the attachment table. If on disk they live in forum/attachements/u/s/e/r/i/d |
Thread Tools | |
Display Modes | |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|