attachmenttype and extension and mimetype

[Moodeey]

im lost on a vbmod that im doin im not sure what the line of code would be for this idea i have in mind...

what im doin is im trying to make a .zip viewer mod where a user could click on a drop down and view the contents of a .zip file (Attachment) this mod uses the "postbit_attachment" template and showthread.php file..

my question is how would i just call a query for just .zip files only ?

please help

[Marco van Herwaarden]

You could select on the extension column.

[Moodeey]

what do u mean ?

[Marco van Herwaarden]

[sql]SELECT * FROM attachement WHERE extension = 'zip';[/sql]

[Moodeey]

thanks just one more thing how would i call the attachmentid for the .zip file ? or each zip file ?

would this work ?

PHP Code:

$DB_site->query("SELECT * FROM attachement WHERE extension ='zip' ORDER BY id"); 


[Marco van Herwaarden]

Are you coding for 3.0 or 3.5?

[Moodeey]

only for 3.0.X

[Marco van Herwaarden]

Then there is no extension column, you would need to determine the type yourself.

Maybe with a:
[sql]SELECT attachmentid FROM attachment WHERE filename LIKE '%.zip';[/sql]

[Moodeey]

well here is the start of the code here

PHP Code:


header('Content-Type: text/html; charset=windows-1256');
$dir = $DOCUMENT_ROOT.dirname($PHP_SELF);
$file = ' WHAT DO I PUT HERE ';
$zip = zip_open($dir.'/'.$file); 


where do i put the query ?