Statistics Panel

[jly2klee]

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

[Floris]

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

[jly2klee]

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

[E]

nice, looks great-thanks

[nafae]

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

[MrLister]

Originally posted by nafae
sexy! I like it and shall install in a bit :)
by any chance do you work in a hair salon? :)

[BigJohnson]

thanx i will install this soon

[Mohamed]

nice work
installed
:)

thanks

[Moegames]

Nice work

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

[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
$toptstarter=$DB_site->query_first("SELECT COUNT(*) AS count,postuserid,postusername FROM thread GROUP BY postuserid ORDER BY count DESC LIMIT 1");
replace with

$toptstarter=$DB_site->query_first("SELECT COUNT(*) AS count,thread.postuserid,thread.postusername,user.u serid,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. ;)

[pHAZE_1]

Originally posted by 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:

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

[69-FLy-gUy]

thanks it worked

[warpedvision]

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

[EchoHype.com]

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

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

[pHAZE_1]

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

[pHAZE_1]

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

[pHAZE_1]

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

[fasal]

Originally posted by |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??????????

Your right how we do that

[pHAZE_1]

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

[Chris M]

@warpedvision & fasal...

Goto : [vB v2.2.1] SQL Query from Control Panel - by JamesUS (https://vborg.vbsupport.ru/showthread.php?s=&threadid=33731)

Satan

[Danny]

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?

[scsa20]

you need to have this installed (https://vborg.vbsupport.ru/showthread.php?s=&threadid=34779) ;)

[Danny]

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?

[DelusionalMind]

Originally posted by scsa20
you need to have this installed (https://vborg.vbsupport.ru/showthread.php?s=&threadid=34779) ;)

sweet. found the fix there. thanks :)

[scsa20]

np ;)

[pran]

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?

[dreamhost]

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

[Obi-Wan]

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?

[Steve St.Lauren]

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

[Obi-Wan]

Could well be yes.

but found the bugger.

Thx anywayz for the help

[Conroy]

ok, I installed the hack that allows you to run queries in the admin cp and I copied the this text from the installation file:

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

But I got an error message that said:

Database error in vBulletin Control Panel 2.2.6:

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

mysql error: You have an error in your SQL syntax near ';
' at line 1

mysql error number: 1064

Date: Saturday 07th of December 2002 10:07:16 AM
Script: http://www.advancedgamers.com/vbulletin/vbulletin/admin/query.php
Referer: http://www.advancedgamers.com/vbulletin/admin/query.php?t=0

I dont know what went wrong.