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

You have a demo? The www button in your post isn't working.

the forums are closed.. but i attached a image.

nice, looks great-thanks

sexy! I like it and shall install in a bit :)

by any chance do you work in a hair salon? :)

thanx i will install this soon

nice work
installed
:)

thanks

Nice work

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:

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

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

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??????????

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).

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?

*bump*

this line right here

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

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:

Find
replace with
Think that should word. ;)

sorry bout that, but how exactly do i do this? please be specific im not good at this kind of stuff.

thanks it worked

I have a problem:

Top Poster, Top Thread Starter and member of the day arnt working.

I followed the hack exsactly right ?

Can anyone help me ?

http://www.warpedvision.net

Or find the hack called "Ruen a Query from the Admin CP" or whatever.

That's what I use, easiest, and quickest =)

to change the color to my regular text, what would i change. i believe it is <td bgcolor="{secondaltcolor} do i change the {secondaltcolor} to text or what? =]

1 more thing [[Top Poster: () | Top Thread Starter: () | Total Posts Today: 0]] doesnt work.. help please

i see what i did wrong now and fixed it. thanks for the help

Your right how we do that

you have to run a query, there is a hack by firefly called run MySQL queries from admin cp...

IS there a way that i can change the text color to the same as my board colors instead of black???

@warpedvision & fasal...

Goto : [vB v2.2.1] SQL Query from Control Panel - by JamesUS

Satan

hi nice hack it works fine except for the member of the day i get this error.

Invalid SQL: SELECT userid,username FROM user WHERE userid<>$daybits[1] AND (usergroupid=5 OR usergroupid=6 OR usergroupid=7 OR usergroupid=2) ORDER BY RAND() LIMIT 1
mysql error: You have an error in your SQL syntax near 'RAND() LIMIT 1' at line 1

any ideas anyone?

you need to have this installed ;)

it is installed turned out to be a different version of mysql didnt like the rand() see member of the day thread for fix.

but the problem i have now is that the userid numbers dont match the username.

http://www.golden-springs.com/forums/index.php

you will see the top poster and top thread starter show userid 1 and userid 2 from the database but the names arent userid 1 and userid 2

can this be fixed?

sweet. found the fix there. thanks :)

np ;)

Wouldn't this tax the server because every hit on the forumhome would generate 5 additional SQL select statements? Why not put this as a link on another page for those who want statistics?

love the hack, you said new vs coming out with referrer, due soon? wow it's hacks like this as to why i left dcforum after years of having to hack it myself, what a community

gonna install this one now m8.

Thx

hmm doesn't seem to work on the 2.2.6 version cause some lines are unable to be found.

Is there gonna be an update...or does somebody know what to edit?

I was able to install this hack on our 2.2.6 vB forum no problem. It's been a while but I don't remember having any problems. Have you installed other hacks that could have changed the code?

-Steve St.Laurent
Webmaster of http://www.turbodieselregister.com

Could well be yes.

but found the bugger.

Thx anywayz for the help