How many attachments for member

[all-the-vb]

Hack: How many attachments for member
Hacked By: All-the-vb

This hack viewing in postbit the number of attachments that user posted.
Tested with: vB 2.2.8, 2.2.9, and 2.3.0

Files to edit: (1)admin/functions.php
Templates to edit: (1) postbit templates/postbit
Time to install: 1 minute


Don't forget to click on install (http://vbulletin.org/forum/misc.php?s=&action=install&threadid=52115)

[all-the-vb]

SCREENSHOT:

[Arabs Emperor]

WoW good work dude
what do you mean from--------> (0)nada

[Red Blaze]

lol I was wondering what you meant by that Arabs, until I read the instructions.

nada = spanish for nothing.

Good hack btw. will install. :)

[all-the-vb]

:p

nada = spanish for nothing.

eng = none

arabic = ??????

[Red Blaze]

Hey I was close *shrugs*

Anyway, that gave me a database error. It worked on some forums, but in the art forum there was database errors on every thread. So I took it off. Might work with someone else though, dunno. Maybe it's just me.

[Mony@k]

Queries to Run: (0)nada
Above past this:

//start user attachment add By All-the-vb
global $DB_site;
$attachment = $DB_site->query_first("SELECT COUNT(attachmentid) AS total FROM attachment WHERE userid=$post[userid] ");
$attachcoun = $attachment[total];
//end user attachment add By All-the-vb This code doesn't contain any query? :D

[Boofo]

Nice idea but this will add a query for every user on the page.

[all-the-vb]

Mony@k



:p

i wrote this while i am in rush

[Ryu]

Nice hack
But i think it Released

[Sun Boy]

Nice !

[Link14716]

Never, EVER add a query to the postbit function. By doing that, you add a query for EVERY SINGLE POST. Youy are better off adding a new field to the user table, and everytime someone posts an attachment, update that field.

Nice hack, I'll install when the changes above have been made ;)

[alkatraz]

cool idea!

[ranger2kxlt]

What about limiting the number of attachments a user can have??

[!!!]

This doesn't seem to work anyway...any reason? Perhaps because of attachment database or attachments in PMs?

[Kane Da Don]

yeah this aint working for me either with vbulletin 2.3.0 could some one help