4images Forum & Community

4images Modifications / Modifikationen => Mods & Plugins (Requests & Discussions) => Topic started by: benzo on May 07, 2003, 12:14:19 AM

Title: Top Uploaders
Post by: benzo on May 07, 2003, 12:14:19 AM

Hi everybody, I need a little mod that show top users uploads

example:

    TOP UPLOADERS:

benzo       45 images upload
Xico         32 images upload
pepe        21 images upload
john         20 images upload
manu        9  images upload

Someone can help me?

thanks.

Title: Re: Top Uploaders
Post by: smartboyinuk on May 07, 2003, 01:41:43 AM

Quote from: benzo

Hi everybody, I need a little mod that show top users uploads

example:

    TOP UPLOADERS:

benzo       45 images upload
Xico         32 images upload
pepe        21 images upload
john         20 images upload
manu        9  images upload

Someone can help me?

thanks.

Code: [Select]

SELECT COUNT(*) AS count,user_id FROM 4images_images GROUP BY user_id ORDER BY count DESC LIMIT 10

The above sql query can be used to find the top posters by user_id, you can then co-relate the user_id with the username.

Infact, somebody can create a nice Mod for this purpose.

Cheers,

SB

Title: Re: Top Uploaders
Post by: Bilal on March 26, 2005, 07:29:07 AM

i know there is a mod posted for this.....I am also looking for it...I saw it somewhere on this community....damn....I am searching since last 20 mins...and now I can't find it :( I am also looking for it...if someone know about it...then plz...let me know!

Title: Re: Top Uploaders
Post by: ascanio on April 29, 2005, 12:49:07 AM

http://www.4homepages.de/forum/index.php?topic=7678.0