Statistics Panel

Well, I wiped this up for another set of forums at There is 2 other hacks used in this, and I take NO credit for them.

So I would just like to say thanks to FireFly and Lesane. Now Get To That Thread To Download!


Installation Time: 3 minutes aprox.
Experience Level: Between Beginner and Intermediate


Features:

Shows the Member Of The Day, Total Members, posts and threads and Top poster and thread starter, and lastly but not least, Total Posts Today!



Whats To Come?

Well, soon there will be a new version, with more useful info, like the top referer.

- Jly2klee

[nafae]

Originally posted by LamBras
Nice idea, allthough the "posts today" query seems to put heavy load on the database. I put it on my forumshome and it inceases loading time of the page by several seconds (!). Is there a way to lower that load?

Yes I would like to know this also :laugh:

[vertex]

how does member of the week work? do you chose or is it random?

[jly2klee]

it is a random thing. It chooses a new user every 24-hours using the server clock.

[|GMK|PlaTooN]

First, we need to run this query:

INSERT INTO template (templateid,templatesetid,title,template) VALUES (NULL,-2,'memberoftheday','0||vb||0||vb||0');

What is that??????????

[LamBras]

An SQL query. You can insert it right on the command shell with the "mysql" command, or use phpMyAdmin (www.phpwizard.net/phpmyadmin ) and enter it via a webpage (which I recommend).

[69-FLy-gUy]

Hm i have a little problem..

I also use the autoposter hack.. and the top thread starter is the autoposter. lol..

how do i code it so that it doesn't include the usergroup=0?

[69-FLy-gUy]

*bump*

[pHAZE_1]

this line right here

INSERT INTO template (templateid,templatesetid,title,template) VALUES (NULL,-2,'memberoftheday','0||vb||0||vb||0');

what template does it go into and exactly where does it go?

[Xanthine]

You dont enter that in any template, its a SQL query. This question was already answered in this thread, please read it before you ask next time. :ermm:

[Wolf42]

Originally posted by 69-FLy-gUy
Hm i have a little problem..

I also use the autoposter hack.. and the top thread starter is the autoposter. lol..

how do i code it so that it doesn't include the usergroup=0?

Find

PHP Code:

$toptstarter=$DB_site->query_first("SELECT COUNT(*) AS count,postuserid,postusername FROM thread GROUP BY postuserid ORDER BY count DESC LIMIT 1"); 


replace with

PHP Code:

$toptstarter=$DB_site->query_first("SELECT COUNT(*) AS count,thread.postuserid,thread.postusername,user.userid,user.usergroupid FROM thread,user WHERE thread.postuserid=user.userid AND user.usergroupid<>0 GROUP BY postuserid ORDER BY count DESC LIMIT 1"); 


Think that should word.