Display total count of certain attachment type

		vb.org Archive > vBulletin 3 Discussion > vB3 General Discussions
Display total count of certain attachment type

06-25-2010, 04:07 PM

vat0r

Join Date: Aug 2005

Posts: 6

Благодарил(а): 0 раз(а)

Поблагодарили: 0 раз(а) в 0 сообщениях

Display total count of certain attachment type

I would like to display the total number of .txt files attached on my forum. Is there a way to accomplish this?

EDiT: Got it using this.

Code:

"SELECT COUNT(extension) AS total FROM " . TABLE_PREFIX . "attachment WHERE extension='txt'"

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Forum Rules

Forum Jump

All times are GMT. The time now is 02:16 PM.

The Arcive of vBulletin Modifications Site.