The Arcive of Official vBulletin Modifications Site.

About Developer · **Released**: 10-29-2000

VBStats version 1.0

This hack creats some graphical statistics of your vBulletin Forum.

Demo1, this shows some general statistics about your board (posted posts, posted threads, new users)

http://feyenoordforever.nl/forum/sta...action=vbstats

Demo2, this shows the posting statistics of a particular member (in this case memberid 1 which is me)

http://feyenoordforever.nl/forum/sta...stats&userid=1

You can sort everything per month, per week or per day.

It uses the Ykcee class (http://ykcee.sourceforge.net)
Note: It works ONLY if your server has installed the GDLIB library!
Follow the following orders very carefully. There are no changes for you vBulletin files needed

First download the zip-file: http://www.feyenoordforever.nl/vbhacks/VBStats.zip

1- Open "vbstats.php" and change the variables on top to your needs. (For explanation of the ykcee variables go to: http://ykcee.sourceforge.net/index.php?MAINNAV=2)
2- If your server is running a PHP version smaller than 4.0 then uncomment the array_slice function in "vbstats.php" (eg: remove /* and */ and the 'Uncomment this if you have a PHP version smaller than 4.0' line)
3- Make a new directory into your vBulletin root directory and call it "stats".
4- Copy "vbstats.php", "ykcee.php", "VERDANA.TTF", "VERDANAB.TTF" and "VERDANAI.TTF" to this directory.
5- Chmod vbstats.php to 755 if you're server is running php in cgi-mode.
6- Make a new template in your vBulletin control panel called "vbstats"
7- Insert the following HTML in it (You can change it to your own design, only leave the $orderby variable and the "action", "max" and "orderby" fields):

<html
<head><title>$bbtitle Statistics</title></head>
<body bgcolor="#7d7092" text="#000000" id=all leftmargin="10" topmargin="10" marginwidth="10" marginheight="10" link="#000000" vlink="#000000" alink="#000000">
<form method="POST">
<table width="100%">
<tr>
<td align="center">
<table>
<tr>
<td align="center">
<img src="vbstats.php?orderby=$orderby&what=users&max=$ max&increased=$increased">
</td>
</tr>
<tr>
<td align="center">
<img src="vbstats.php?orderby=$orderby&what=posts&max=$ max&increased=$increased">
</td>
</tr>
<tr>
<td align="center">
<img src="vbstats.php?orderby=$orderby&what=threads&max =$max&increased=$increased">
</td>
</tr>
<tr>
<td align="center">
<input type="hidden" name="action" value="vbstats">
<input type="hidden" name="max" value="15">
<b><smallfont>Increasing?</b></smallfont><INPUT type="checkbox" value="true" name="increased">
<select name="orderby">
<option value="month">Per month</option>
<option value="week">Per week</option>
<option value="day">Per day</option>
</select>
<input type="submit" value="Submit">
</td>
</tr>
</table>
</td>
</tr>
</table>
</form>
</body></html>

8- Create somewhere you want in your forumtemplates a link to "http://yourdomain.com/forum/stats/vbstats.php?action=vbstats"
9- Create a new template in your control panel called "memberstats"
10- Insert the following HTML in it (You can change it to your own design, only leave the $orderby and $userid variables and the "action", "max" and "orderby" fields):

<html
<head><title>$bbtitle Member Statistics</title></head>
<body bgcolor="#7d7092" text="#000000" id=all leftmargin="10" topmargin="10" marginwidth="10" marginheight="10" link="#000000" vlink="#000000" alink="#000000">
<form method="POST">
<table width="100%">
<tr>
<td align="center">
<img src="vbstats.php?orderby=$orderby&what=members&use rid=$userid&max=$max&increased=$increased">
</td>
</tr>
<tr>
<td align="center">
<input type="hidden" name="action" value="userstats">
<input type="hidden" name="userid" value="$userid">
<input type="hidden" name="max" value="15">
<b><smallfont>Increasing?</b></smallfont><INPUT type="checkbox" value="true" name="increased">
<select name="orderby">
<option value="month">Per month</option>
<option value="week">Per week</option>
<option value="day">Per day</option>
</select>
<input type="submit" value="Submit">
</td>
</tr>
</table>
</td>
</tr>
</table>
</form>
</body></html>

11- Create a link to "http://feyenoordforever.nl/forum/stats/vbstats.php?action=userstats&userid=$userid" in your "getinfo" template (the template for the userprofiles)

OR

insert just a little html in the "getinfo" template to show the image directly:

<img src="stats/vbstats.php?vbstats.php?orderby=week&what=members& userid=$userid">

(change the orderby variable to suit your needs)

That's it!

The "max" variable is to set a maximum of the displayed days/weeks/months...otherwise you had to much of them and the image got real messy.
You can change it if you want or let the user choose the max value by creating a dropdownlist or a input field in your template called 'max'

The only problem I have is that if there is a period of inactivity the graphic isn't represented as it should,
(see the 'geplaatste threads' graphic at http://feyenoordforever.nl/forum/sta...&orderby=month )
and note how there ar a few months missing...In fact the space between januari and july should be bigger than it is, but it's too complicated to fix that....
I might fix it later...

Let me know what y'all think

enjoy!

[EDIT]Forgot the download link...DOH![/EDIT]

[Edited by Mas*Mind on 11-01-2000 at 04:49 PM]

#52 02-13-2001, 11:25 AM

this is the mysql error i get

Database error in vBulletin: Invalid SQL: SELECT username FROM user
WHERE userid =
mysql error: You have an error in your SQL syntax near '' at line 1
mysql error number: 1064
Date: Tuesday 13th of February 2001 01:23:17 PM
Script:
/vb/stats/vbstats.php?orderby=&what=members&userid=&max=15&i ncreased=
Referer:

and this are my gd option

GD Support enabled
GD Version 1.6.2 or higher
FreeType Support enabled
FreeType Linkage with TTF library
JPG Support enabled
WBMP Support enabled

#53 02-14-2001, 10:35 AM

ok i have solve the problem its alwais work better when you right jpg insted of jgp

we gone have it

SilverBoy · #54 04-08-2001, 11:58 PM

I wanna translate the words that appear in the graphs, help plz.

#55 04-13-2001, 01:01 AM

I cant download the hack anymore. There seems to be a problem with your DNS Mas*Mind.
Also, I would love to see an english version of the hack too.

Mas*Mind · #56 04-13-2001, 06:37 AM

Link's fixed...I see what I can do about an English version

SilverBoy · #57 04-15-2001, 11:21 AM

I wish some one who is have an english demo put the link here coz I want to translate the hack too

.
or plz MAssMind change the code to english, plz .

SilverBoy · #58 04-17-2001, 01:56 PM

ummmmmmmm......

Mas*Mind · #59 04-17-2001, 02:04 PM

It's easy to translate...Just open vbstats.php and change

PHP Code:


			
    $AxisXmonth = "Per maand";

    $AxisXweek = "Per week";

    $AxisXday = "Per dag";

    $AxisY = "";

    $noDataText = "Sorry, op dit moment is er geen data beschikbaar";

    $dayFormat = "%a %e %b %Y";

    $weekFormat = "Week %u";

    $monthFormat = "%b %Y";

    $memberStatsTitle = "Geplaatste posts door %s";

    $memberStatsLegend = "Geplaatste Posts";

    $postStatsTitle = "Geplaatste posts";

    $postStatsLegend = "Nieuwe posts";

    $threadStatsTitle = "Geplaatste threads";

    $threadStatsLegend = "Nieuwe threads";

    $userStatsTitle = "Nieuwe leden";

    $userStatsLegend = "Nieuwe leden";

to

PHP Code:


			
    $AxisXmonth = "Per month";

    $AxisXweek = "Per week";

    $AxisXday = "Per day";

    $AxisY = "";

    $noDataText = "Sorry, not data available at this moment";

    $dayFormat = "%a %e %b %Y";

    $weekFormat = "Week %u";

    $monthFormat = "%b %Y";

    $memberStatsTitle = "New posts by %s";

    $memberStatsLegend = "New Posts";

    $postStatsTitle = "New Posts";

    $postStatsLegend = "New Posts";

    $threadStatsTitle = "New Threads";

    $threadStatsLegend = "New Threads";

    $userStatsTitle = "New Members";

    $userStatsLegend = "New Members";

SilverBoy · #60 04-18-2001, 05:56 PM

if I want to change the font how I can do it, becaust my language doesn't suport this font, and how I can add vbtitle image and header and footer and fivelinks template to the templates, I tried it but failed. thx again

Mas*Mind · #61 04-18-2001, 06:31 PM

First q:

Upload the new font to the stats dir

then change:

PHP Code:


			
    $graph->SetTitleFont("./VERDANA.TTF");

    $graph->SetFont("./VERDANA.TTF");

in vbstats.php to reflect the new font

Second q:

Currently you can't....

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.06286 seconds Memory Usage 2,321KB Queries Executed 25 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (3)bbcode_php (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)modsystem_post (1)navbar (6)navbar_link (120)option (1)pagenav (1)pagenav_curpage (3)pagenav_pagelink (11)post_thanks_box (11)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (11)post_thanks_postbit_info (10)postbit (7)postbit_onlinestatus (11)postbit_wrapper (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create postbit_factory postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end fetch_musername bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start postbit_imicons pagenav_page pagenav_complete tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!