Messages

1

Discussion & Troubleshooting / Re-send activation code

« on: June 30, 2003, 11:21:03 AM »

Maybe this went above me.. but is there any way that I can email users who have not activated their membership in last x (say 10 days) days ?

Is there a mod to do such a function ?

thanks,

S

2

Mods & Plugins (Requests & Discussions) / Re: Top Uploaders

« on: May 07, 2003, 01:41:43 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.

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