Tulosta sivu - Script to Calculate Members with Most Sent PMs

Otsikko: Script to Calculate Members with Most Sent PMs
Kirjoitti: Jye - marraskuu 26, 2007, 09:59:40 AP

Hi Everyone. I need to find out which Member (Top 10 would be better), has Sent the Most PMs. If anyone with SQL knowledge could write a query I could run via a .php file or something, I'd really appreciate it!
Thank you for your time.

Otsikko: Re: Script to Calculate Members with Most Sent PMs
Kirjoitti: karlbenson - marraskuu 26, 2007, 11:23:20 AP

AFAIK, the total number pms sent is not stored.
So calculated based on the number of pm's stored in the db, that would not be a true figure, because when a user deletes a pm. The figure would go down,

Otsikko: Re: Script to Calculate Members with Most Sent PMs
Kirjoitti: Jye - marraskuu 26, 2007, 11:29:42 AP

Thanks for the reply karlbenson. Yes, that makes sense, but I would still like to obtain the Top 10 based on those saved in the Database.

Otsikko: Re: Script to Calculate Members with Most Sent PMs
Kirjoitti: SleePy - joulukuu 12, 2007, 10:53:57 IP

I won't provide information on this because it would be easily used to see pms users have sent. Which is something we are against.

We do count though how many pms a user has received though

Otsikko: Re: Script to Calculate Members with Most Sent PMs
Kirjoitti: Jye - joulukuu 12, 2007, 11:25:34 IP

Ok SleePy. I know that could be done, but I just want to find out for a Member Award. Thanks anyway.

Simple Machines Community Forum

General Community => Scripting Help => Aiheen aloitti: Jye - marraskuu 26, 2007, 09:59:40 AP