vb.org Archive - Attachment Type

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB4 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=252)

- - Attachment Type (https://vborg.vbsupport.ru/showthread.php?t=315314)

Forum-Germany

11-08-2014 01:45 AM

Attachment Type

Hello.

How can I distinguish as "images" or other types of attachments using the database?

The column "contenttypeid" it can not be, since JPG images sometimes have the ID "1" but also "24". RAR files have "1"...

I need a differentiator.

Thanks.

kh99	11-08-2014 10:11 AM

It think what you want is to use the filedataid and the filedata table, then look at the 'extension' column.

Forum-Germany

11-08-2014 03:07 PM

Thanks.

Table filedate: 225 Results
Table attachments: 274 Results

ACP -> Attachments... 274 / 225

He?

kh99	11-08-2014 03:46 PM

Are you asking why there are more attachments than filedata? I'm not sure, but I think it's probably because you can attach the same file more than once, so if you attached the same file to 2 different posts then there would be 2 rows in the attachment table with the same filedataid.

Forum-Germany

11-08-2014 08:51 PM

You are right. :up:

PHP Code:


		
			
"SELECT DISTINCT filedataid FROM attachment"

Result: 224

:) :up:

All times are GMT. The time now is 03:04 PM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01459 seconds Memory Usage 1,709KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)bbcode_php_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (5)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: