Need help with a few functions

[sunilvarma]

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

[Eikinskjaldi]

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

1)
select count(*) as total from attachment a
join thread t on (a.postid=t.firstpostid)
where threadid=something;

if it comes back with a value > 0 then it has at least one attachement.

2)
Select extension from attachment where something
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