vbStats

[Bane]

the vbstats options and exclude *are* in the admin directory. The only difference between the two are the action=add for excludes, I'm not sure why they wouldnt both work. The link to the actual statistics was sortof a thrown in bonus so not sure on that.

[Steve Machol]

[QUOTE]Originally posted by Bane
:( the exclude system is a bit confusing right now, it doesnt actually list what you exclude.. just excludes it. I will put the list in the next version. I'll try this on 2.2.0 and let you know what I get.

[Bane]

If you add it into the excludes it will not log new hits to that site, any that are in the table already will still be displayed. You would have to go into phpMyAdmin and remove them. :(

[Steve Machol]

Ah, ok. Thanks for clarifying this. :)

[Bane]

If you see any other things that are confusing please let me know. Im going to try to put as much documentation in for the next version as I can.

[Steve Machol]

Thanks Bane. Here's a few more things I noticed:

1. The text colors are very difficult to manage because of all the style sets I have. Can I put the vB replacement variables in these fields instead of the colors?

2. Shouldn't the 'activity levels' show up as a percent? I'm getting '581.115' instead of '58.1%.

3. How do I set it up so that private forums only show up for members that have access to those forums?

[Bane]

I didnt change the title to 2.2.0

The MySQL errors were quite likely from not putting the vbs_counter include in your header file. Did you check that?

[Bane]

Steve,

1) I will have to look at that. Or maybe set extra replacements per style. I had put the extra codes there to begin with because I had wanted the numbers to stand out.

2) This is as was intended, as I prefered that, but I will change it in the release since it seems to confuse people as well.

3) You can exclude forums in the vbstats config.

[Steve Machol]

Thanks Bane. On #3, I don't want to exclude forums. I want the forums to show based on user permissions. Are you saying it's all or nothing?

[Bane]

Steve: For now it is, One gentleman figured out the permissions for vbstats, but I believe he is trying to sell them :(. So you'll have to wait for me to grow the brain cells to grasp that :p

Everyone? I have a lot of things I need to throw in this version. Most are done or near done, just sorting through them. Unfortunately (fortunately?) I have had enough client work that I havent even been able to upgrade my own forum. As soon as Im done with that vbstats has my attention and I will release the next full version. It will have an upgrade from 203.2 so hopefully all the people (thanks :)) who have signed up for updates/installed will have an easy time when I release the upgrade.

I want to take this space for a special thanks though. You guys have been pretty patient with me, through my initial bumbling with the updates etc, to my current schedule, and I wanted to thank everyone for that. :) I'll try to get her out soon!

[|DarkManX|]

no, thank you for your hard work bane :)

[Steve Machol]

Yeah, thanks Bane! You're work is appreciated!

[|DarkManX|]

i just saw a small lil bug........

here is a SS

any way to fix this to make it say viewing forum stats or something like that??

[Bane]

hmm.. did you do the optional online.php hack? it should have taken care of that.

[|DarkManX|]

yes i did do that part of it....

[Bane]

Hmm.. thats odd, that should add that to the online.php, if its not I'll find out soon. I'm starting on my upgrade in about an hour.

[|DarkManX|]

ok cool sounds good, yea i'm on 2.2 now so maybe its just with a small update somewhere.....thanks Bane :)

[Bane]

The correct file substitutions for vbStats in vb2.2.0 are as follows. These changes will be redocumented in the strictly 2.2.0 version though it should be noted it seems to work just dandy in 2.2.0 with these tweaks :)

The admin/template.php hack remains as is.

vb 2.2.0 online.php changes

Find
case 'spider':

Just ABOVE this place

// vbStats
case 'vbstats':
$userinfo[where] = "Viewing <a href='vbstats.php?action=stats&s=$session[sessionhash]'>Statistics</a>";
break;
// vbStats End



Find
case '/robots.txt':

Just ABOVE this place

// vbStats
case $forumprefix.'vbstats.php':
$userinfo[activity] = 'vbstats';
break;
// vbStats End


vb 2.2.0 admin/index.php changes

Find

makenavselect("Statistics & Logs","<hr>",$df);

Just BELOW that place

// vbStats
makenavoption("Config","vbstats_set.php?action=edit","<br>");
makenavoption("View Public Statistics","../vbstats.php?action=stats","<br>");
makenavoption("Exclude URL","vbstats_set.php?action=add");
makenavselect("vbStats","<hr>");
// vbStats

[Steve Machol]

Good job Bane! Works like a charm!

[patvdv]

Hi Bane,

Just upgrade to v2.2.0 of vbulletin and vbstats still works as a charm after making the v2.2.0 specific changes.

However I have been browsing all weekend from my Linux box (Redhat 7.1) with the Konquerer browser and all these ticks are counted against the Netscape browser and 'unknown' OS. :(

Any ideas?

[pgowder]

Does this drastically affect the server load?

[patvdv]

Do you mean the upgrade to v2.2.0? No not that I have noticed so far.

[pgowder]

I mean the whole hack. I don't have any part of it installed.

[patvdv]

No not at all but then again we are only using a speck of our current server.

[pgowder]

Has anyone else tracked what this does to the server load?

[centris]

I have not tracked what it does to the load on the server, but I can say that I have NOT noticed any slowdown on page load etc. I have had two sql error e-mails ;

Database error in vBulletin :

Link-ID == false, connect failed
mysql error:

mysql error number:

Date: Monday 05th of November 2001 06:22:47 PM
Script: /forum/vbstats.php
Referer:

but thats it so far, I then changed the code to that, that Bane gave for ver. 2.2.0 and its running fine with no problems. I should add that my server is running slow lately, including FTP etc. So the above error may be due to a server issue.

[TheComputerGuy]

Does anyone know why phpportals hack has a little problem with it?

[orca]

Originally posted by TheComputerGuy
Does anyone know why phpportals hack has a little problem with it?

What kind of problem? I didn't notice any...

[Mike Gaidin]

Woohoo! I finally got it working. Great program. :D

[xcal]

installed like a charm, quality hack :)

up and running here

www.rtcw.co.uk/forums/vbstats.php

:D

[NYI Fan]

Bane, and everyone else who posted help along the way on this thread
THANK YOU!

This was an easy install and my members LOVE it!!

Than you Thank you Thank you!!!

[Dartigan]

Thanks. :) Quick Q though: Is there an easy way to reset it? MY forum isn't open to the public yet and I'll want to reset it when it goes live.

Thanks again on the nice hack. :D
- Dart

[FWC]

Great job, Bane!! I just installed it with the 2.2.0 mods and it worked perfectly. :)

[jselwyn]

Thanks Bane.
Until 3 weeks ago, I knew little about html, php etc. Then bought vBulletin, have now just installed your hack and it works brilliantly first time. We are now running a UK government online consultation without a problem and can provide them with excellent stats. Thanks again

[LuBi]

Said it before, but this is great! Thanks! :D

[LuBi]

I get the following error at the top of my vbstats.php page.

Warning: Division by zero in /www/htdocs/forums/vbstats.php on line 159

Warning: Division by zero in /www/htdocs/forums/vbstats.php on line 165

Warning: Division by zero in /www/htdocs/forums/vbstats.php on line 162

Warning: Division by zero in /www/htdocs/forums/vbstats.php on line 186

Warning: Division by zero in /www/htdocs/forums/vbstats.php on line 148

Warning: Division by zero in /www/htdocs/forums/vbstats.php on line 139

Warning: Division by zero in /www/htdocs/forums/vbstats.php on line 145

Warning: Division by zero in /www/htdocs/forums/vbstats.php on line 142

Warning: Division by zero in /www/htdocs/forums/vbstats.php on line 136

Warning: Division by zero in /www/htdocs/forums/vbstats.php on line 151

Warning: Division by zero in /www/htdocs/forums/vbstats.php on line 154

Any help would be great. Thanks again

[DarkReaper]

I think that's because you didn't <? include("vbs_counter.php"); ?> in your phpinclude header.

Bane, any idea on when you'll be releasing the new version with 2.2.0 compatibility, as well as new features?

[LuBi]

lol now I get:

Parse error: parse error in /www/htdocs/forums/global.php(274) : eval()'d code on line 6

Warning: Division by zero in /www/htdocs/forums/vbstats.php on line 159

Warning: Division by zero in /www/htdocs/forums/vbstats.php on line 165

Warning: Division by zero in /www/htdocs/forums/vbstats.php on line 162

Warning: Division by zero in /www/htdocs/forums/vbstats.php on line 186

Warning: Division by zero in /www/htdocs/forums/vbstats.php on line 148

Warning: Division by zero in /www/htdocs/forums/vbstats.php on line 139

Warning: Division by zero in /www/htdocs/forums/vbstats.php on line 145

Warning: Division by zero in /www/htdocs/forums/vbstats.php on line 142

Warning: Division by zero in /www/htdocs/forums/vbstats.php on line 136

Warning: Division by zero in /www/htdocs/forums/vbstats.php on line 151

Warning: Division by zero in /www/htdocs/forums/vbstats.php on line 154

** Also it does work with 2.2, it works with mine... Kind of.. But others have it running on their 2.2 forums.

[FWC]

I don't know if it matters, but my phpinclude only has:

include("vbs_counter.php");

added to it.

[DarkReaper]

Sorry, should've been more clear. You don't throw in the <??>, I just habitually did that because its php code :)

[LuBi]

Well I got rid of one problem, thanks... but still have this.

Warning: Division by zero in /www/htdocs/forums/vbstats.php on line 159

Warning: Division by zero in /www/htdocs/forums/vbstats.php on line 165

Warning: Division by zero in /www/htdocs/forums/vbstats.php on line 162

Warning: Division by zero in /www/htdocs/forums/vbstats.php on line 186

Warning: Division by zero in /www/htdocs/forums/vbstats.php on line 148

Warning: Division by zero in /www/htdocs/forums/vbstats.php on line 139

Warning: Division by zero in /www/htdocs/forums/vbstats.php on line 145

Warning: Division by zero in /www/htdocs/forums/vbstats.php on line 142

Warning: Division by zero in /www/htdocs/forums/vbstats.php on line 136

Warning: Division by zero in /www/htdocs/forums/vbstats.php on line 151

Warning: Division by zero in /www/htdocs/forums/vbstats.php on line 154

Any help would be great..

[Bane]

LuBi make sure that you add

include("vbs_counter.php");

to the php include template. That error springs from having no entries in the database.

DarkReaper I have been slacking a little due to some personal issues that are being dealt with atm. This is still on my to do list, it just had to be moved back a bit to make way for some paying projects as the fundage was running awful low. As soon as Im caught up there will be a new release, I havent given up on vbStats.

[LuBi]

Originally posted by Bane
LuBi make sure that you add

include("vbs_counter.php");

to the php include template. That error springs from having no entries in the database.

DarkReaper I have been slacking a little due to some personal issues that are being dealt with atm. This is still on my to do list, it just had to be moved back a bit to make way for some paying projects as the fundage was running awful low. As soon as Im caught up there will be a new release, I havent given up on vbStats.

Great as usual! thanks, I forgot the "include" from the line... works great now

[Steve Machol]

Something strange happened. All my vbstat templates are gone. I haven't made any changes yet when I checked them today they were gone from all my style sets?

What could have caused this? And more importantly, how do I get them back? I'm hesitant to tun the installation again because I don't want duplicate tables in my database.

[Bane]

Not sure what would set them missing (unless you reuploaded the vb default style) but to get them back run the install again and select [UPGRADE]

[Steve Machol]

No - no changes to the styles. The only thing I changed was a bug-fix test of template.php. However reinstalling the original template.php did not bring them back.

[Steve Machol]

Thanks - the 'upgrade' worked! :)

[JTMON]

Great Hack!!!

Just installed using only the code in the zipfile using 2.2.0. The only time I ran into slight problems was with the code to replace for admin/index.php. I just threw it inbetween the Forum Home and Forum Options and all seems to work great.

One question. Where/how would I edit the footer to include the stats on the main index?

Thanks for a great hack!!

[FWC]

Originally posted by JTMON
One question. Where/how would I edit the footer to include the stats on the main index?You could just put something like:

<a href="vbstats.php?s=$session[sessionhash]"><smallfont>Statistics</smallfont></a>

anywhere you want in your footer template. You can add any enhancements like making it bold.

[jselwyn]

As I said before the hack is great - just some questions on it:
1) Excuse my ignorance but what does Activity Level represent?
2) On forum stats I have over 300 views this week and going up all the time but on views in last 24 hours it shows 0 even though total views continues to increase - is this something different?
3) Is it possible to insert some code to find out how many different people viewed the site over a set period of time (even better who viewed the site)?
cheers

[JTMON]

Originally posted by FWC
You could just put something like:

<a href="vbstats.php?s=$session[sessionhash]"><smallfont>Statistics</smallfont></a>

anywhere you want in your footer template. You can add any enhancements like making it bold.

Well that's almost what I wanted to do. But actually, I want to take the code in vb_stats.php and tack it on the end of whatever template the main forum index is. So that, beneath the Private Message part, the vb_stats would show there.

TIA!

[SWFans.net]

Originally posted by JTMON


Well that's almost what I wanted to do. But actually, I want to take the code in vb_stats.php and tack it on the end of whatever template the main forum index is. So that, beneath the Private Message part, the vb_stats would show there.

TIA! I just copied a few of the variable's defenition lines into index.php, and set it up like you are trying to, though its under my "Currently Online" display.

http://www.swforums.net/forum

[Gholsie]

Originally posted by Bane
LuBi make sure that you add

include("vbs_counter.php");

to the php include template. That error springs from having no entries in the database.


I've been reading up on this issue because I just installed vbStats on my system with phpPortals. I dug deep into the system and couldn't find a file named "phpinclude" at all. But, I did manage to find (from this thread) instructions to add your include statement to my "globals.php" located in my vBulletin forum (/forums) directory.

After I added that statement, it all works fine.

BTW: Your DOCS Install.txt file is vague on this issue. It just says, "Add this statement to your phpinclude template"..... This, I think, is where people got a little lost. I know I did. I was looking for a file the whole time.

[m]

[FWC]

Originally posted by Gholsie

I dug deep into the system and couldn't find a file named "phpinclude" at all. phpinclude is not a file. It's a template. It also shows up at the top of Modify Styles as PHP parsed code:.

[humble]

Excellent hack!!! working great on both my old 2.0.3 and my new 2.2.0...

Much appreciated.

[JTMON]

ok I'm having a slight problem trying to add the relevant code to my forumhome template. I copy the appropriate code I want from the vbstats templates into the forumhome template where I want it. It displays correctly, links and all, but I get no totals for any fields except threads, members, and posts, the rest are empty. I have put the vbcounter... in the phpinclude template also and if I goto vbstats.php all the totals are there.

[Bane]

You need the corresponding code from the vbstats.php file added in as well if you wish to have that found

[JTMON]

So look at the variables in the source and put them in the template?

[Bane]

No, you would have to hack them into the index.php if you want it to show on forumhome.

What are you trying to include there?

[JTMON]

Member Stats, Forum Stats and Last 24 Hours. I have everything showing up except for the totals. All the text and tables are there. I just don't know what to grab from vbstats.php

[FWC]

Originally posted by JTMON
Member Stats, Forum Stats and Last 24 Hours. I have everything showing up except for the totals. All the text and tables are there. I just don't know what to grab from vbstats.php To get the totals you'll have to do what Bane said and hack the PHP code in that generates the totals. The variables are generated in vbstats.php. If you want them somewhere else, you need to put the code to generate the variables there.

[JTMON]

Well when I grab the code I want from vbstats and add it just about anywhere in index.php I get a parse error on the last line of index.php which is ?>

[JTMON]

The code I am trying to insert into index.php from vbstats.php is:

// #########################################
// vBStats by Bane Macleod (http://www.talkloud.net/)
// (c) influx9.Design
// For vBulletin version 2.0.3
// (c) 2001 Jelsoft Enterprises, Ltd.
// #########################################
// Thanks for trying out vbStats. I would appreciate you leaving
// everything as is (including gratis) and if you do that you certainly
// deserve a thank you, and I do, however I know most of you
// won't so here is the one thing I ask. Please do not claim this work
// as your own or remove the header/hack notifications. This is
// peoples work and they should get credit.
// #########################################

// ###############################
// Other Vars (DO NOT MODIFY!!!)
// ###############################

$tl_statsv="203.2";
$tl_statsu="talkloud.net/vbstats/";
$tltoday=time()-(86400);

// ###############################

require('./global.php3'); // vBulletin Globals
require('./vbslang_en.php3'); // Future Language File

if (!isset($action) or $action=="") {
$action="stats";
}

// ###############################
// Stats Page
// ###############################
// Hacks Incorperated:
// Colored Users Online Hack by Afterburner
// Top Referrer by FireFly
// ###############################
if ($action=="stats") {

// ########## Breadcrumb
$tl_title=""._STATS."";
$breadcrumb=""._SITESTATS."";

$statistic=$DB_site->query_first("SELECT statloc,useonnow,usequeue,usevbp,usevbpl,queuemax, color1,color2,color3,color4,acolor,scolor,mocolor, mecolor,ucolor,norefer1 FROM vbstats_options");
$startdate=$statistic[startdate];
$statloc=$statistic[statloc];
$useonnow=$statistic[useonnow];
$usequeue=$statistic[usequeue];
$usevbp=$statistic[usevbp];
$usevbpl=$statistic[usevbpl];
$queuemax=$statistic[queuemax];
$color1=$statistic[color1];
$color2=$statistic[color2];
$color3=$statistic[color3];
$color4=$statistic[color4];
$acolor=$statistic[acolor];
$scolor=$statistic[scolor];
$mocolor=$statistic[mocolor];
$mecolor=$statistic[mecolor];
$ucolor=$statistic[ucolor];
$norefer1=$statistic[norefer1];

// ########## Member Stats
// How Many?
$numbersmembers=$DB_site->query_first('SELECT COUNT(*) AS users,MAX(userid) AS max FROM user');
$numbermembers=$numbersmembers['users'];

// Active/Non?
$snonposters=$DB_site->query_first('SELECT COUNT(*) AS users,MAX(userid) AS max FROM user WHERE posts=0');
$nonposters=$snonposters['users'];
$activemembers=$numbermembers-$nonposters;
$activityrate=sprintf("%.2f",(1000*$activemembers/$numbermembers));

// Newest Member
$getnewestusers=$DB_site->query_first("SELECT userid,username FROM user WHERE userid=$numbersmembers[max]");
$newusername=$getnewestusers['username'];
$newuserid=$getnewestusers['userid'];

// PM Totals
$totalpms = $DB_site->query_first("SELECT count(*) as pmcount FROM privatemessage");
$totalpm = $totalpms[pmcount];

// Staff
$anum = mysql_num_rows(mysql_query("select * from user WHERE usergroupid=5 or usergroupid=6 or usergroupid=7"));

// Top Referrer
if ($usereferrer) {
$topref = $DB_site->query_first("SELECT COUNT(*) AS referrals, user.username, user.userid FROM user AS users
LEFT JOIN user ON (users.referrerid = user.userid)
WHERE users.referrerid <> 0 AND
user.userid NOT IN ($norefer1)
GROUP BY users.referrerid
ORDER BY referrals DESC
LIMIT 1");
$tl_refid = $topref[userid];
$tl_refname = $topref[username];
$tl_refnum = $topref[referrals];
}

// ########## Post/Thread Stats
// Total
$countposts=$DB_site->query_first('SELECT COUNT(*) AS posts FROM post');
$totalposts=$countposts['posts'];
if ($totalposts=='') { $totalposts=0; }
$countthreads=$DB_site->query_first('SELECT COUNT(*) AS threads FROM thread');
$totalthreads=$countthreads['threads'];
if ($totalthreads=='') { $totalthreads=0; }

// Today [FireFly]
$getpoststoday=$DB_site->query_first("SELECT count(*) AS count FROM post WHERE dateline>='$tltoday'");
$poststoday=$getpoststoday[count];
$getthreadstoday=$DB_site->query_first("SELECT count(*) AS count FROM thread WHERE dateline>='$tltoday'");
$threadstoday=$getthreadstoday[count];

// Views
$boardviews = $DB_site->query_first("SELECT SUM(views) AS threadviews FROM thread");
$totalviews = number_format($boardviews[threadviews]);

// ########## Visits Today
$vbs_atviews = $DB_site->query_first("SELECT count FROM vbstats_date WHERE date = '$vbs_date'");
$todayviews = number_format($vbs_atviews[count]);

[FWC]

Originally posted by JTMON
The code I am trying to insert into index.php from vbstats.php is:

require('./global.php3'); // vBulletin Globals You don't need that line. It's already called at the top of index.php

[JTMON]

Yep, I had noticed that and removed that. I also tried putting the variables part up at the top of index.php with the other variables and then the relevant other vbstat code below elsewhere in index but every time I get a parse error on whatever line number ?> happens to be on. What exactly does a parse error means. Doesn't that mean I coded something wrong?

[|DarkManX|]

Originally posted by SWFans.net
I just copied a few of the variable's defenition lines into index.php, and set it up like you are trying to, though its under my "Currently Online" display.

http://www.swforums.net/forum


that is awesome man, how did you do that?

[SWFans.net]

Thanks. :)

I just placed this code into my index.php:

// Total Thread Views
$boardviews=$DB_site->query_first("SELECT SUM(views) AS threadviews FROM thread");
$totalviews=number_format($boardviews['threadviews']);Above the "//get newest member" section, then built a table row like loggedinusers in forum home and put the things I wanted inside it, all done in the forumhome template

[|DarkManX|]

Originally posted by SWFans.net
Thanks. :)

I just placed this code into my index.php:

// Total Thread Views
$boardviews=$DB_site->query_first("SELECT SUM(views) AS threadviews FROM thread");
$totalviews=number_format($boardviews['threadviews']);Above the "//get newest member" section, then built a table row like loggedinusers in forum home and put the things I wanted inside it, all done in the forumhome template


i think you should make this a mini-release :)


i am not smart enough to figure all that myself......but i am smart enough to follow detailed directions :)

[SWFans.net]

I'm not sure if vbstats added this to global.php, or if I did, but this is in there above the "// ###################### Start sessions #######################" section.

// ########## Visits Today
$vbs_atviews = $DB_site->query_first("SELECT count FROM vbstats_date WHERE date = '$vbs_date'");
$todayviews = number_format($vbs_atviews[count]);

// Today [FireFly]
$getpoststoday=$DB_site->query_first("SELECT count(*) AS count FROM post WHERE dateline>='$tltoday'");
$poststoday=number_format($getpoststoday[count]);
$getthreadstoday=$DB_site->query_first("SELECT count(*) AS count FROM thread WHERE dateline>='$tltoday'");
$threadstoday=number_format($getthreadstoday[count]);

// Views
$boardviews = $DB_site->query_first("SELECT SUM(views) AS threadviews FROM thread");
$totalviews = number_format($boardviews[threadviews]);Now that I think about it a little, moving it to index.php, might speed my forums up some, if it was in fact me that put it there. Those database queries don't need to be in global and thus run on every page load for threads forums and all. :x

[SWFans.net]

Thanks for making me look into that. I was right, I moved the code I had in global.php to index.php, and now threads load considerably faster again. :)

I placed the section I quoted from global.php to the same place, just after, I had the other code in index.php.

[JTMON]

ok but lets say I wanted what you have in my index.php, when I put it in I get the parse error. Where would I put it to get it to show below the newest member text?

[SWFans.net]

Just add this to index.php right above the "// get newest member" section:


// Total Thread Views
$boardviews=$DB_site->query_first("SELECT SUM(views) AS threadviews FROM thread");
$totalviews=number_format($boardviews['threadviews']);

// ########## Visits Today
$vbs_atviews = $DB_site->query_first("SELECT count FROM vbstats_date WHERE date = '$vbs_date'");
$todayviews = number_format($vbs_atviews[count]);

// Today [FireFly]
$getpoststoday=$DB_site->query_first("SELECT count(*) AS count FROM post WHERE dateline>='$tltoday'");
$poststoday=number_format($getpoststoday[count]);
$getthreadstoday=$DB_site->query_first("SELECT count(*) AS count FROM thread WHERE dateline>='$tltoday'");
$threadstoday=number_format($getthreadstoday[count]);

Once that is there, then you can call the variables from the forumhome template. the variables it makes available are:

$totalviews
$todayviews
$poststoday
$threadstoday

[Princeton]

I have vbportal and I would like to add TOP POP REVIEWS and NEW REVIEWS to vbstats. How can I do this?
thank you

[Bane]

Interesting Idea. I will work on this in a minute and see if I cant get it to do what you want.

[Bane]

Or not.. I see SWFans.net has already :p For the Top Pop Reviews and such the code is in the top.php file I believe, you could just copy the code from there.

[Bane]

OK, I was a bit bored and decided to add this into the next version :D Here is an example.

[Bane]

For those of you who dont wish to wait for the next version instructions follow:

edit: attachment deleted. added on next page

[Princeton]

My $linkqueue and $navbar menu just disappeared. How can I get it back?

UPDATE: It's fixed.

[|DarkManX|]

Originally posted by Bane
For those of you who dont wish to wait for the next version instructions follow:


getting a database error when i install this addon......

[SWFans.net]

I decided to remove the last 24 hour stats from my index.php and from my forumhome template. It was causing the load time of my main page to be about double, if not a little more, than without. 4 extra DB queries make a big difference there. @_@

[JTMON]

Hmmm, strange. I had an issue where it was loading slow so I emailed my hosters. We are back to superspeed with the last 24 hours in there.

[|DarkManX|]

could someone help me out with this index.php part of the code, i get a mysql error.....

[SWFans.net]

JTMON: Are you on a dedicated or shared host? I have been having the speed problems/load time issues for over a week(since I added the 24 hour stats to the forumhome) and at first thought it a host issue, but with it lasting so long, I decided to start experimenting. Removing those queries helped my load time a great deal.

Could you PM me the URL of your board and your host provider information, if its not too much trouble?

Dark: Bane provided instrictions and the ones I provided also work, but don't include as many stats as Bane's. Did you revert back to your original index.php and try reapplying the hack?

[JTMON]

Sure SWF, Pm'ing you now.

[Bane]

Dark: Try using the zip that has changed. There was a teeny problem :) This new one works swell. (or should) I'll attach to this post. Let me know.

The only difference between this version and the excellent Idea from SWFans is this one uses a seperate template. And has a few more stats.

[Pady]

Thanx Bane gunna give this one a try

[orca]

I think you have an error in the following line for the index.php modification:

$topref = $DB_site->query_first("SELECT COUNT(*) AS referrals, user.username, user.userid FROM user AS users LEFT JOIN user ON (users.referrerid = user.userid) WHERE users.referrerid <> 0 AND user.userid NOT IN ($norefer1) GROUP BY users.referrerid ORDER BY referrals DESC LIMIT 1");

I get a mySQL error there. Looking at the code I think that the variable $norefer1 isn't defined.

[|DarkManX|]

Originally posted by Bane
Dark: Try using the zip that has changed. There was a teeny problem :) This new one works swell. (or should) I'll attach to this post. Let me know.

The only difference between this version and the excellent Idea from SWFans is this one uses a seperate template. And has a few more stats.



thanks bane, i gave it a try, but i got this error

Database error in vBulletin 2.2.0:

Invalid SQL: SELECT COUNT(*) AS referrals, user.username, user.userid FROM user AS users
LEFT JOIN user ON (users.referrerid = user.userid)
WHERE users.referrerid <> 0 AND
user.userid NOT IN ()
GROUP BY users.referrerid
ORDER BY referrals DESC
LIMIT 1
mysql error: You have an error in your SQL syntax near ')
GROUP BY users.referrerid
ORDER BY referrals DESC
LIMIT 1' at line 4

mysql error number: 1064

Date: Sunday 18th of November 2001 11:34:11 AM
Script: http://www.partylounge.net/tof/tof/index.php?
Referer: http://www.partylounge.net/tof/online.php?

[orca]

Darkman, that was exactly the error I got and I think it's related to that $norefer1 isn't declared.

[|DarkManX|]

hmmmmmmm............i dunno, do you think its just a typo in the code somewhere, or more to it than that?

[Bane]

I put up a new zip with that removed.. kindof a stupid mistake on my part since I took out the top referrer bit in the display. It didnt come up on the test board since I never turned on the referrer system.

Please note, If you want to add the top referrer to your front page you can add the following code..

// Set this to ids you dont want counted, seperated by , 0 for none
$norefer1="0";

// Top Referrer
if ($usereferrer) {
$topref = $DB_site->query_first("SELECT COUNT(*) AS referrals, user.username, user.userid FROM user AS users
LEFT JOIN user ON (users.referrerid = user.userid)
WHERE users.referrerid <> 0 AND
user.userid NOT IN ($norefer1)
GROUP BY users.referrerid
ORDER BY referrals DESC
LIMIT 1");
$tl_refid = $topref[userid];
$tl_refname = $topref[username];
$tl_refnum = $topref[referrals];
}

And in your vbstats_forumhome template add:

<smallfont>Top Referrer: <b><a href="member.php?s=$session[sessionhash]&action=getinfo&userid=$tl_refid">$tl_refname</a></b> (<smallfont color="$tl_color1">$tl_refnum referrals!</smallfont>)
&nbsp;[<a href="vbstats.php?s=$session[sessionhash]&action=memberrefer">Full List</a>] &nbsp; [ <a href="misc.php?s=$session[sessionhash]&action=faq&page=2#referrals">Help</a> ]</smallfont>


This is not fully tested as Im about to go to lunch but it should work dandy. The non referrer top stats is in the zip sorry about the messup.

[|DarkManX|]

thanks, that did the trick :D

[jselwyn]

1) Excuse my ignorance but what does Activity Level represent?
2) On forum stats I have over 300 views this week and going up all the time but on views in last 24 hours it shows 0 even though total views continues to increase - is this something different?
3) Is it possible to insert some code to find out how many different people viewed the site over a set period of time (even better who viewed the site)?
By the way why is this bulletin board so wide on my screen when none of the others are?
cheers

[Bane]

1) Activity level is percentage of your users that have at least one post. "Active on your board"

2) What server do you run on? It may be possible its not doing the 24 hour function correctly, or that you need to change the var name, not sure.

3) This will be logged per day in the next release. So you can find out how many today, this week, etc..

Because there is code in it and for some reason it doesnt pop out of the table like vbs so..

[|DarkManX|]

my 24 hour stats won't update.....

take a look.....

[Bane]

Like I said :) A quickie. Try putting this code right after

// Today [FireFly]

$tltoday=time()-(86400);

[Wordplay]

Excuse me but i'm really new to this board. And was just wondering... it says v2.21 in the subject, but your post says that it's v2.03 compatible. Does that mean that it was originally designed for 2.03 but also works for 2.21 or did somebody mess up the subject/post :confused:?

[Bane]

What it means is that for some reason the admin/moderator of this board has taken it upon himself to change the title of the post. It will work with 2.2.1 with the changes that were explained earlier in the thread. But yes, it was originally made for 2.0.3 and yes, I find it as annoying as you do.

[BaldNut]

couple of little problems im having getting this running :(

first my hands are too cold :D

secondly :) i cant find my online.php in on my server ? but it is in my local machine in my vb folder

thirdly i get this message when i click on the online users link

Warning: Failed opening './counter.php' for inclusion (include_path='') in /home/sites/site4/web/vbp_includes.php on line 12

ive also tried changing it to: include("vbs_counter.php"); in the vbp_includes.php file ?

and if i go to http://www.golden-springs.com/vbstats.php i get a blank page ?


i have not changed the hacks on the online.php because it aint their, i looked in the one on my local machine but i could not find the parts i needed to change ? any help will be appreciated

Many thanx

Balds.

PS your all doing a great job here, keep up the good work ;)

[JTMON]

BaldNut,

You put the include statement in your phpinclude TEMPLATE. Not file.

[BaldNut]

cheers m8 i try now, any ideas on the online.php ?

[JTMON]

Not really, if it's not there, why not try uploading it.

[BaldNut]

i just got this message now ?

Warning: Failed opening 'vbs_counter.php' for inclusion (include_path='') in /home/sites/site4/web/forums/global.php(274) : eval()'d code on line 3

[JTMON]

Do you have that file vbs_counter.php on your server?

[BaldNut]

yes m8 that is their

[JTMON]

The correct include statement that should be in your PHPINCLUDE template is:

include("./counter.php");

Make sure that the ./ is in there and the syntax is the same

[BaldNut]

right i put in my template what you said this is what is in my phpincludes now

if (!isset($mainfile)){
include("../vbp_includes.php");
include("./counter.php");
}

this is the new report
Warning: Failed opening './counter.php' for inclusion (include_path='') in /home/sites/site4/web/forums/global.php(274) : eval()'d code on line 3

[JTMON]

I see you have PHPportal installed. This would mean that the path to the file is probably different as I assume you have the forums in a forum folder?

[JTMON]

Well now I am not sure as this file has changed since I installed it. I have my forums in my root folder so my phpinclude template is:

// This code is PHP4 only:
// ob_start();
// require("yourheader.html");
// $header = ob_get_contents();
// ob_end_clean();
include("vbs_counter.php3");

Also I'm using php3 extensions

[JTMON]

Maybe putting that include statement at the end of your phpinclude template out of the loop?

[BaldNut]

1 sec i try m8

[Bane]

Why are you calling the counter.php in your phpinclude template? try removing that, certainly if its not even on your server. I believe wajones is going to be moving vbPortals stats over to vbstats anyway.

counter.php is called in your vbPortal head.php (or header?) try editing it out of there.

Try uploading vbs_counter.php to both your forum and root directories.

[JTMON]

Bane I checked his forums and it appears he has both the vbs_counter.php and counter.php files there in his root folder.

[JTMON]

At any rate, Glad the expert is here! :p

[Bane]

Is the file (vbs_counter) in the root and forums directories? I have mine in both because vbportal seems to not want to find it from time to time. it seems like its not finding it at all. and if vbstats.php is showing up all white that means its not finding the language file for inclusion.

Make sure vbstats.php is installed in your FORUMS directory. not root.

Make sure you have the paths right in all cases.

Let me know.

[Bane]

Originally posted by JTMON
At any rate, Glad the expert is here! :p
LOL, I just wrote it, what do I know?

[JTMON]

I'd say alot. This seems to be the most popular hack ever! :D

I just checked his forums again. He has the vbstat.php file in his root only :(

Oh yeah, you should change your sig so it says. El Coolest Hacko!

[BaldNut]

:D

i try now m8 cheers & to JTmon thanx

[JTMON]

Well I see he moved it to his forums folder but is still getting the white page. That means the language file isn't getting called? NUTZ-I can't remember where the code is supposed to go for that :p

[BaldNut]

whats the language file m8, and where should it be ?

[JTMON]

The file is called vbslang_en.php. If it's up on your server you may want to try it in your forum folder I think

[JTMON]

Yeah I see it's in the root. Try moving it to the forum folder.

[BaldNut]

right its sort of working but its got a lot of errors at the top of the page

Warning: Division by zero in /home/sites/site4/web/forums/vbstats.php on line 159

Warning: Division by zero in /home/sites/site4/web/forums/vbstats.php on line 165

Warning: Division by zero in /home/sites/site4/web/forums/vbstats.php on line 162

Warning: Division by zero in /home/sites/site4/web/forums/vbstats.php on line 186

Warning: Division by zero in /home/sites/site4/web/forums/vbstats.php on line 148

Warning: Division by zero in /home/sites/site4/web/forums/vbstats.php on line 139

Warning: Division by zero in /home/sites/site4/web/forums/vbstats.php on line 145

Warning: Division by zero in /home/sites/site4/web/forums/vbstats.php on line 142

Warning: Division by zero in /home/sites/site4/web/forums/vbstats.php on line 136

Warning: Division by zero in /home/sites/site4/web/forums/vbstats.php on line 151

Warning: Division by zero in /home/sites/site4/web/forums/vbstats.php on line 154

but some of the data is ok, i think some of the paths may be the prob cause the images are missing ?

ill be 5 mins cause i have to see a client (slimming consultant you see :D )

[JTMON]

Ok now we're getting somewhere. Division by zero errors mean there's something up with the include statement. Paste your current PHPinclude statement here. Or try like Bane said and put the vbs_counter.php file in both your root and forums folder.

[BaldNut]

ive put that in both m8, my phpincludes is:

if (!isset($mainfile)){
include("../vbp_includes.php");
}

back in 5 mins

[JTMON]

um, I think that's supposed to be vbs_counter.php and with one less . before the /


WHERE'D ya go Bane!! :stupid: :eek: :confused: :D :p

[JTMON]

Also, I don;t know if it's supposed to be in that loop as it seems that if the condition isn't met then the file won't be included.

[Bane]

Make your phpinclude template look like this:

if (!isset($mainfile)){
include("../vbp_includes.php");
}
include("./vbs_counter.php");

[BaldNut]

right guys we starting to get their now.......

look here :

http://www.golden-springs.com/forums/vbstats.php?s=&action=stats

but if i visit

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

i get a blank page

ooooh i just noticed their is a link on the vbportal (my main page) for stats which displays some of the stats ?

was that always their ?

[JTMON]

I get a working vbstat page at both. The only thing is that your images are missing.

[Princeton]

Congratulations, baldnut it's working. I get vbstats on both links.

Upload your images to it's proper folder.

[JTMON]

did you upload the gifs to your forum/images folder in binary?

Note this from the install instructions I got:

Upload the GIF files to your server.
I would advise the [vbulletin]/images/ directory, but the
$tl_loc and $tl_loc2 variables in the vbstats.php can point anywhere you like.

[BaldNut]

couldnt of done it without you guys thank you v.much :)

now for my next hack install :)

dont you go offline you lot :p

[JTMON]

I'll be here. Just hope any other hacks are ones I've also installed:D

[BaldNut]

cool m8 thanx :)

ive now got the images working too :)

have you installed the one which says next to your name

online | offline ?

if so is it difficuilt

[JTMON]

dunno haven't done that one yet:D

It's on me list tho!

[BaldNut]

what about giving the drop down box to select which colour display is shown to the user ?

[JTMON]

I believe there are options in the AdminCP where you can set the colors.

[BaldNut]

sorry m8 i was meaning the kind that displays on the main page so the user can choose what colour scheme to use on the page

[JTMON]

For VBStats I believe most of it corresponds to your style colors.

[BaldNut]

sorry m8, ive confused things here, its for my overall site design (the whole forums) im gonna do a custom design and i was gonna use one of those drop down boxes so users can select which style they like best

[JTMON]

gotta put it in the request section here. It should be easy enough tho.

[BaldNut]

its a hack ive seen on http://www.sportbikeworld.com/

have a look on the top right hand side m8

[JTMON]

That's not a hack it's built into VBPortals. I think getting the same thing for the forums would be tho

[JTMON]

Well I thought it was. They used to have that same drop down on php portals but it seems like it's gone now!

[JTMON]

Yeah if you read the last news post in the center it says:

Styles Demo Posted by: [wajones] on 10-18-2001 @ 10:12 PM
Thanks to Pete, note the new Styles demo block, top of right column. These aren't fancy, just a demo of the multiple styles you can have for vbPortal. This isn't meant to set your default style. You will still have to do that in the usercp. It's just to demo the capabilitiy to new visitors.

Now it was there the other day but is not now. BTW I think we should discuss this elsewhere, like in general chat or something:D

[Amasov]

Heyho @Bane :)

This is the most powerful Hack I've ever seen. It works like a charm :) :)

But, I do have a little problem:

I've installed also this *mini-hack* for the forum_home.

But on the main-index-page is maybe a little bug, because this one shows all threads and all posting for last 24h !

On "vbstats.php" works it quiet well. :)

Just test yourself:

Bugproblem:
http://www.d-c-f.de

Working:
http://www.d-c-f.de/vbstats.php

As you can see, there are different values for $threadstoday and $poststoday.

So, how may I fix it?

(This hack is incredible! :) )

[Psychdrone]

any working versio n for 2.2.1?

[JTMON]

It does work for 2.2.1 as there were no changes to index.php for 2.2.1

Not sure why the values are off though

[Bane]

Originally posted by Amasov
As you can see, there are different values for $threadstoday and $poststoday.

Try putting this code right after

// Today [FireFly]

in the index.php

$tltoday=time()-(86400);

[Amasov]

Double thumbs up!!

That rocks.... :cool: :cool:

Thanks a lot. :)

[|DarkManX|]

that work'd but it doesn't say how many views that there were in the last 24 hours??

[Psychdrone]

HOw about, when some body gets a chance, they could reput it together for 2.2.1 and then up it for me thanks:)

[JTMON]

Psych,

I think it's exaclty the same as there were no changes to index.php between 2.2.0 and 2.2.1

[|DarkManX|]

Bane

for some reason, in the 24 hour block it isn't showing the views for the last 24 hours....any ideas???


thanks :)

[cditty]

I must have really screwed something up. When I try to access the public stats, I get this error.

Warning: Supplied argument is not a valid MySQL result resource in /home/httpd/html/sweeps/forum_dev/vbstats.php on line 88

I ran the install with no problems. Anyone give any ideas?

Thanks

Chris

[Wordplay]

Originally posted by Bane
What it means is that for some reason the admin/moderator of this board has taken it upon himself to change the title of the post. It will work with 2.2.1 with the changes that were explained earlier in the thread. But yes, it was originally made for 2.0.3 and yes, I find it as annoying as you do.
Oh'k, well thanks for letting me know.

[Princeton]

My url keeps showing up under refferer list. I did use the 'exclude url' under admin.

What can I be doing wrong?

http://www.total-impact.com/

fixed

[Steve Machol]

Speaking of referring sties, is there a way to clear out certain sites? For instance I'd like to remove vbulletin.org and vbulletin,com from this list. Unfortunately I didn't exclude these earlier and they have both accumulated the vast majority or refferences.

[|DarkManX|]

yea it would be cool, if we could reset the referring sites....or something like that....

[Bane]

Those are maybe from before you entered it into the excluded stats? In the next version I will try to put in a way to easily delete those but for now it must be deleted from phpMyAdmin.

[cditty]

Anyone have any ideas on this?

Originally posted by cditty
I must have really screwed something up. When I try to access the public stats, I get this error.

Warning: Supplied argument is not a valid MySQL result resource in /home/httpd/html/sweeps/forum_dev/vbstats.php on line 88

I ran the install with no problems. Anyone give any ideas?

Thanks

Chris

[Princeton]

Originally posted by Bane
Those are maybe from before you entered it into the excluded stats? In the next version I will try to put in a way to easily delete those but for now it must be deleted from phpMyAdmin. I was in phpadmin but I'm not quite sure what to do? Can you give me a run down?

never mind

[SgtSling]

for some reason on my logged in users..
it displays

the first person's name

then lists

, , , , , , , , , , , , , , , , , , , , , , , , , , , , ,

not showing the other usernames?
Any clues?

[FWC]

Originally posted by SgtSling
for some reason on my logged in users..
it displays

the first person's name

then lists


, , , , , , , , , , , , , , , , , , , , , , , , , , , , ,


not showing the other usernames?
Any clues? I had that problem after I upgraded from 2.2.0 to 2.2.1. I ran the install script again as an UPGRADE and it fixed it.

[MApI]

My Ever's counters on Top Posters Statistics doesn't update. Someone other ? How can I fix it ?

cya

[WizyWyg]

Help getting this on the vbstats.php file:

Warning: Division by zero in /home/path/to/forums.animation-web.com/vbstats.php on line 159

Warning: Division by zero in /home/path/to/forums.animation-web.com/vbstats.php on line 165

Warning: Division by zero in /home/path/to/forums.animation-web.com/vbstats.php on line 162

Warning: Division by zero in /home/path/to/forums.animation-web.com/vbstats.php on line 186

Warning: Division by zero in /home/path/to/forums.animation-web.com/vbstats.php on line 148

Warning: Division by zero in /home/path/to/forums.animation-web.com/vbstats.php on line 139

Warning: Division by zero in /home/path/toforums.animation-web.com/vbstats.php on line 145

Warning: Division by zero in /home/path/to/forums.animation-web.com/vbstats.php on line 142

Warning: Division by zero in /home/path/to/forums.animation-web.com/vbstats.php on line 136

Warning: Division by zero in /home/path/to/forums.animation-web.com/vbstats.php on line 151

Warning: Division by zero in /home/path/to/forums.animation-web.com/vbstats.php on line 154

And then it displays no information ( iget the setup but they are all 0%)

[|DarkManX|]

did u do this

Be sure to add this line to your phpinclude template:

include("vbs_counter.php");

[WizyWyg]

Found it. Should hve been more clear.

Ie Under Templates > Modify > phpinclude > edit
add this:

include("vbs_counter.php");

[Hooper]

FIXED

[Hooper]

Ah I see someone else a page or two back had the same problem.

Here is my opinion.

1) You were not clear on the inclusion via the tempate file.
2) The instructions are incomplete.
3) I have found errors with the html
4) The instructions are not compatable with any 2.2.1 within the installer and needs to be updated or the hack removed.
5) Putting your name and site on the bottom of the hack is not what I installed this hack for and it WILL be removed whether you like it or not.
6) I don't see where I can add multiple sites to ignore from the admin CP. Only one it appears which will not work for me. I need to exclude many sites from the collection of data. If this is possible, super. If not, another peave.

I have several hacks installed. My opinion is the hack needs much work and inclusions via the phpinclude template is something I frown on. To many inclusions already.

I do not reccomend installing this hack until it has been cleaned up and updated.

[Amasov]

I'm not Bane, but this is my opinion of yours:

Originally posted by Hooper

Here is my opinion.
1) You were not clear on the inclusion via the tempate file.

Reviewing these Pages, it is clear ;)

2) The instructions are incomplete.

Be patient, all the incompleted instructions will be added, I think Bugfixes are more important.

3) I have found errors with the html

Did you? Where?

4) The instructions are not compatable with any 2.2.1 within the installer and needs to be updated or the hack removed.

Just the online.php and for the Admin CP, but I think there was an addon?

5) Putting your name and site on the bottom of the hack is not what I installed this hack for and it WILL be removed whether you like it or not.

I think he mentioned in his templates, that this will be gratis-lines? However, he was doing a fine <4free> job and he should get the credit.

6) I don't see where I can add multiple sites to ignore from the admin CP. Only one it appears which will not work for me. I need to exclude many sites from the collection of data. If this is possible, super. If not, another peave.

Just go to your phpmyAdmin and look in the database for it. In the CP you can add as many as you want. Removing should be part in the next release.

I do not reccomend installing this hack until it has been cleaned up and updated.

I do recommend installing this hack. It's great. With a few (minor) fixes, it works quiet well. :)

Regards.

[Amasov]

Originally posted by cditty
Anyone have any ideas on this?

Warning: Supplied argument is not a valid MySQL result resource in /home/httpd/html/sweeps/forum_dev/vbstats.php on line 88


Funny. This is the User-Table of your database and should replying the mods,super-mods and admins.

Did you look into your database and checked if these entries are legal ?

[Hooper]

Well,

You do have a right to your opinion. I'm done with the subject. There are too many good, mostly trouble free hacks to mess around with something like this. No wonder he stressed backing up the db over and over.

Something else,

I've been adding hacks to vbull since beta3. I have never complained about a hack before. I have had questions, but I never complained. I'm not actually even complaining here. I am stating my opinion of this hack.

This is the first. Take it for what it's worth.

[JTMON]

Originally posted by Hooper
Ah I see someone else a page or two back had the same problem.

Here is my opinion.

1) You were not clear on the inclusion via the tempate file.
2) The instructions are incomplete.
3) I have found errors with the html
4) The instructions are not compatable with any 2.2.1 within the installer and needs to be updated or the hack removed.
5) Putting your name and site on the bottom of the hack is not what I installed this hack for and it WILL be removed whether you like it or not.
6) I don't see where I can add multiple sites to ignore from the admin CP. Only one it appears which will not work for me. I need to exclude many sites from the collection of data. If this is possible, super. If not, another peave.

I have several hacks installed. My opinion is the hack needs much work and inclusions via the phpinclude template is something I frown on. To many inclusions already.

I do not reccomend installing this hack until it has been cleaned up and updated.

I would install this hack/ and have already!! It works just dandy!!!

[JTMON]

Originally posted by Hooper
Well,

You do have a right to your opinion. I'm done with the subject. There are too many good, mostly trouble free hacks to mess around with something like this. No wonder he stressed backing up the db over and over.

Isn't it funny how most of us could get it working with no problems. You just have to actually read and do what the instructions say.

[Hooper]

"I think he mentioned in his templates, that this will be gratis-lines? However, he was doing a fine <4free> job and he should get the credit. "

If Chen and Kevin had their names all over every hack on my site, I would have to call my site FireFlyTubeDogg.com . They are top notch hackers and don't do such.

I surely don't expect anyless from anyone else. Nor do I want to erase your advertisements.

It's not giving credit I have a problem with, If you want to put a link on a hack fine. Take it to your site and add a disclaimer stating not to remove it.

This is vBulletin.org. Conversation closed. I won't be back to the thread.

Good Day and Cheers,

[Bane]

1) You were not clear on the inclusion via the tempate file.

In the instructions it could be considered vague I suppose, though quite a few people managed to do it without all the trouble you seemed to have faced. However I fail to see how you could have missed the SECOND POST IN THIS THREAD which mentions trouble areas that have been covered. I have answered this same question about 20 times in the thread from people who also couldnt be bothered to pay attention.

2) The instructions are incomplete.

There are no instructions. This hack installs itself. The hacks are optional. This is stated in the Install.TXT I will try to be more clear (IE spell everything out) in the next version. I thought having a hack that for the most part installs itself would be enough. Apparently not.

3) I have found errors with the html

You will find quite a few, I didnt notice you pointing them out so I cant really tell you how to fix them.

4) The instructions are not compatable with any 2.2.1 within the installer and needs to be updated or the hack removed.

There are still hacks here from pre 2.x and you want to remove mine because you cant be bothered to look through the thread for the 2.2.1 fixes? You really dont like it much do you?

5) Putting your name and site on the bottom of the hack is not what I installed this hack for and it WILL be removed whether you like it or not.

I also mentioned inside the file I DONT CARE if you remove my name, I realize some will, thats fine. What you are prohibited from doing is removing any of the names FROM THE CODE, as that is the credits, and it doesnt show on your site so where is the problem?

6) I don't see where I can add multiple sites to ignore from the admin CP. Only one it appears which will not work for me. I need to exclude many sites from the collection of data. If this is possible, super. If not, another peave.

Just keep putting them in. They will all take, someone with extensive hack experiance may have been able to take a look at the table to check if they are taking or not, but your right, I should have wasted more of my time to spell this out to you as well for my free project that you've done not a thing but complain about. I would also like to apologise from the bottom of my heart for not being a "Top Notch Hacker" like FireFly and Tubedogg (as you will also note in the instructions you didnt bother reading) I will now go and meditate on how I can better make this hack without dissappointing you. I will dedicate the rest of my days to making vbstats v.IhopeHooperlikesthisone

This is YET ANOTHER thing that has been mentioned in this thread. Something you should have maybe at least taken a quick glance through before giving your opinion. Others have done so with far more tact than you.

I have several hacks installed. My opinion is the hack needs much work and inclusions via the phpinclude template is something I frown on. To many inclusions already.

How do you expect the file to count hits without running the queries? Maybe you can set me straight on this?

You are right that the hack needs work. You are welcome to work on it. Or you could try bothering one of the "Top Notch" hackers for it. Orrrr you can wait for me to update. Orrrrrrr you can just uninstall (I can send you instructions on how to do so if you like) it and not come back to the thread as you said.

I do not reccomend installing this hack until it has been cleaned up and updated.

Thats sweet, I'll put you're opinion in future versions instructions, I doubt you'll notice, since you dont read them anyway.

[Bane]

Originally posted by Hooper
You do have a right to your opinion. I'm done with the subject. There are too many good, mostly trouble free hacks to mess around with something like this. No wonder he stressed backing up the db over and over.

--

It's not giving credit I have a problem with, If you want to put a link on a hack fine. Take it to your site and add a disclaimer stating not to remove it.

Man, you should always back up your DB before you make ANY change to it. Thats why I stress backing it up. So you did read the instructions after all?

The point in the gratis was to make it so if you didnt want it you *could* remove it. What would be the point of what you suggest?

[JTMON]

Originally posted by Hooper
"I think he mentioned in his templates, that this will be gratis-lines? However, he was doing a fine <4free> job and he should get the credit. "


If Chen and Kevin had their names all over every hack on my site, I would have to call my site FireFlyTubeDogg.com . They are top notch hackers and don't do such.

I surely don't expect anyless from anyone else. Nor do I want to erase your advertisements.

It's not giving credit I have a problem with, If you want to put a link on a hack fine. Take it to your site and add a disclaimer stating not to remove it.

This is vBulletin.org. Conversation closed. I won't be back to the thread.

Good Day and Cheers,

Where exactly is his name "all over"? I only see it once.

Also, like he said, if you bothered to READ, you would have seen that you just can't remove it from the code.

Apparently you DO have a problem with giving credit, else you wouldn't be so upset. Have you nothing better to do? Are you admin here? Then why are you dictating where it goes? Why don't YOU go away? If you can't say something nice, just don't say anything..

Thank you for telling us the URL. I guess it's a good thing it's in that thing we call an address bar huh? You already said you wouldn't be back..

-------------------

Bane, as for not being a "top notch" hacker. I happen to think you are. I think this is one of the best hacks ever made. Looking at the totals, it would seem that many people feel the same. Don't sell yourself short because of one VERY ungrateful person. :D

[Bane]

Originally posted by JTMON
Bane, as for not being a "top notch" hacker. I happen to think you are. I think this is one of the best hacks ever made. Looking at the totals, it would seem that many people feel the same. Don't sell yourself short because of one VERY ungrateful person. :D
I appreciate that bro :) And believe me I have seen the totals, they astound me :p I think it has a lot more to do with the hack than me though. A lot of people are statistic hounds like me I guess.

What I am referring to is PHP ability Tubedogg and Chen have far above me. I basically see how it works in vb then try it on my own. After the 60 or 70th time I've broken it usually it works somehow ;p This hack really is a hack like that :p

[FWC]

Originally posted by Bane

I appreciate that bro :) And believe me I have seen the totals, they astound me :p I think it has a lot more to do with the hack than me though. A lot of people are statistic hounds like me I guess.

What I am referring to is PHP ability Tubedogg and Chen have far above me. I basically see how it works in vb then try it on my own. After the 60 or 70th time I've broken it usually it works somehow ;p This hack really is a hack like that :p Bane, a lot of us have your back on this one! I love this hack!

[Hooper]

Bane,

The offer on how to unistall this hack including table alterations etc.. is a fine offer. This will be fine.

Please send here. <edit>resolved</edit>

On the post about backing up. I've been running a nightly cron for quite some time. Db is always backed up and burned to a cd.

-----------------------------------------------------------------------------

3) I have found errors with the html

You will find quite a few, I didnt notice you pointing them out so I cant really tell you how to fix them.

------------------------------------------------------------------------------

Thank you, but I need no help fixing your html errors. And I agree you have many.

-------------------------------------------------------------------------------

4) The instructions are not compatable with any 2.2.1 within the installer and needs to be updated or the hack removed.

There are still hacks here from pre 2.x and you want to remove mine because you cant be bothered to look through the thread for the 2.2.1 fixes? You really dont like it much do you?

--------------------------------------------------------------------------------

I've already given my opinion of the hack. I didn't come in here to argue. I came to give my opinion on the hack. I've done so.

--------------------------------------------------------------------------------

I would also like to apologise from the bottom of my heart for not being a "Top Notch Hacker" like FireFly and Tubedogg (as you will also note in the instructions you didnt bother reading) I will now go and meditate on how I can better make this hack without dissappointing you.

---------------------------------------------------------------------------------

I did indeed read the instructions. I installed the hack. I found a bunch of basic html errors after the install script hacked at my db.

It is not good to find such errors in html after doing alterations to your db. Shows lack of concern. First thought was if he cannot write html he shouldn't be hacking. I don't need my db screwed up.

----------------------------------------------------------------------------------

Orrrrrrr you can just uninstall (I can send you instructions on how to do so if you like) it and not come back to the thread as you said.

----------------------------------------------------------------------------------

As mentioned above, The instuctions on a complete uninstall will be fine. Much apprecited.

Somthing else I wanted to mention. You are not going to please everyone. I am that one. I don't want to discourage you from further proceeding with your hack in any way, shape or form.

Please do continue. I just prefer not to have beta hacks installed on my server. This hack has been around since 2.03 from what I see here. Am I correct?

BTW, you are not talking to a kid here. You are talking to a NATTS certified computer technician with a degree and 15 years in the field. You are also talking to someone who knows html and the fundamentals of Web Dev.
Not everyone that gives their feedback is an idiot. I obviously wouldn't have known about the html errors if I hadn't checked for them now would I.

Again, I mentioned it several times. I didn't come in here to argue. I came in here to leave my opinion. I did just that and the folks in here turned into Osama's on me. That's fine but this is not a holly war. Just a hack that needs work before being displayed as a FULL RELEASE. This should be in the beta hack forum.

I oplologize for the FireFlyTubeDogg comment. That was uncalled for. I oplogize for comming here not as happy as I should have when I found what I did. But if you go back and read my original post to this one, you will see that I did't come in here to dog anyone or argue. I have beta tested software for Ensoniq Corporation, QuikstoreLLC, LKTOH products and a few more. If there are bugs I find them or they seem to find me. Regardless, please re-read my posts and you'll see that I indeed did not come in here to splatter you. I made points on why I didn't like this hack.

It's fine when you get posts on how nice your hack is by the kids. But when you get someone that does know what they are talking about, try to not treat them like they are out of line.

Did I once say anything about not backing up a database?

Have a nice evening.

[Bane]

The offer on how to unistall this hack including table alterations etc.. is a fine offer. This will be fine.

There is an uninstall feature :) Im sure you wont want to trust it though since I wrote it.

Thank you, but I need no help fixing your html errors. And I agree you have many.

But again make no mention of them. There are also basic html errors in vB. Some corrected, some not. I'm sure they would get a long way if people just said "Psst.. there are bugs." and not else.

I've already given my opinion of the hack. I didn't come in here to argue. I came to give my opinion on the hack. I've done so.

Yes you have, albeit a bit confusing one. You made your points, offered no corrections in your infinite knowledge as a "NATTS certified computer technician with a degree and 15 years in the field, who knows html and the fundamentals of Web Dev." Therefore immediately putting most of the people who do like this hack on the defensive since you didnt seem to be doing anything but complaining and saying you never complain.


It is not good to find such errors in html after doing alterations to your db. Shows lack of concern. First thought was if he cannot write html he shouldn't be hacking. I don't need my db screwed up.

I'm not sure how your database would be screwed up by HTML errors but I'll take your NATTS certified word for it. You may consider putting some thought into the fact that if its not constructive its useless. Yours was in no way constructive.

As mentioned above, The instuctions on a complete uninstall will be fine. Much apprecited.

For the most part all vbstats changes are named vbstats_ ... the tables are vbstats_ the templates also. there is one field modified for referrers

BTW, you are not talking to a kid here. Not everyone that gives their feedback is an idiot. I obviously wouldn't have known about the html errors if I hadn't checked for them now would I.

Yes, we have been over the mystery HTML errors in depth and I appreciate that. Not sure what you mean with the kid comment, as It makes no diffference to me if you are a kid or not. FireFly would fall into that catagory (being a teen no?) yet hes still one of your "Top Notch" hackers. I believe you are confusing Kid with childlike, and we can leave that to others to decide.

I did just that and the folks in here turned into Osama's on me. That's fine but this is not a holly war.

I dont think I will be the only one saying that this is a very poor choice of words for an adult.

Just a hack that needs work before being displayed as a FULL RELEASE. This should be in the beta hack forum.

It should be noted this is not a beta, it is a release. Just because it doesnt work the way you like with a software it wasnt intended to run on initially doesnt make it beta. And even if it were this was not release on vbulletin.org and to the best of my knowledge there was no damned BETA HACK FORUM at that point in time. There are bugs in the hack Im sure. Thats the purpose of this discussion thread. To find them. If you would like to contribute and mention any errors (actual errors mind you, not you being unable to find a template) like the HTML error you tote so highly I would invite you to do so. Otherwise I would strongly suggest that you do exactly what you had mentioned before and not bother revisiting the thread.

I find myself defending a script that I have said in the past has flaws. This is a rather unfortunate position to be in, however I am more than up to it. This script seems to work fine as is for quite a few people and you come in here blasting away with things that have been mentioned multiple times throughout the thread. Your points 1,2,4,and 6 were all addressed in this thread, #5 is addressed in the files, and #3 is a mystery to everyone.

[Hooper]

No problem. We will agree to disagree. Or agree on some and disagree on the other. I have no problem with that.

I will try your uninstall program. If you could email information on tables altered etc... I will verify manually that the uninstall script has removed them and left the database intact. This will be fine. I appreicate the instuctions on the hack removal.

I can clearly see that after this statement and your response:

"It is not good to find such errors in html after doing alterations to your db. Shows lack of concern. First thought was if he cannot write html he shouldn't be hacking. I don't need my db screwed up."

I'm not sure how your database would be screwed up by HTML errors but I'll take your NATTS certified word for it. You may consider putting some thought into the fact that if its not constructive its useless. Yours was in no way constructive.

That we are having a lack in communication.

Thank You,

[itstd]

Holy cow! I can't beleive what I just read. This was one of the easiest hacks I have ever applied to my forum and it works just fine on the new release. Went in without a hitch and survived the upgrade without a hitch. I want to thank you Bane for an excellent hack. It's one of the first things I check on my forum each morning. We started getting a bunch of hit's from Afghanistan all of a sudden and after checking it out found out it was some service guys that were sent over there that were still checking in with us. Made me feel good. Never would have known about it without your hack. Thanks again Bane.

[Bane]

Sorry for the miscommunitcation Hooper. I'll be glad to send you a list of tables. It may not arrive until the morning but you shall have it soon enough :P A bit of a day its turning into here.

[Hooper]

Ok. That will be super. No hurry.

Thank You,

[Steve Machol]

I searched but couldn't find the answer to this. Has anyone been able to modify online.php for 2.2.1 so that it shows when a person is viewing the stats? I've added what I thought were the correct lines, but I'm still getting 'Unknown location'.

[Bane]

The code I posted before doesnt work Steve? Or you werent able to find it?

[Steve Machol]

I wasn't able to find it. I'll look again. Thanks!

[Steve Machol]

Found it! I was searching for online when I should have been looking for online.php. Works now. Thanks again!

[Hooper]

Bane,

I ran the uninstall script and unhacked. I verified the tables have indeed been removed from the database. I haven't found anything in the db that resembles vbstats and am confident that the uninstall was a complete success. No need for the table information.

Thank You,
Have a good week.

[FWC]

Originally posted by smachol
Found it! I was searching for online when I should have been looking for online.php. Works now. Thanks again! It's a great trick. I've used the same method to make my signature editor and attachment search programs show up right in Who's Online. A nice little bonus, Bane!! :D

[Steve Machol]

I've also modified online.php for my Chat Room, Optical Help Wanted Page and Donations Page. I thought I had it right for vBStats but I had made a slight mistake.

[JTMON]

Hey Steve,

What kind of chat software are you running? Am looking into this.

[trilOByte]

Originally posted by Hooper
<snip>....This hack has been around since 2.03 from what I see here. Am I correct?.....<snip>

<snip>....Just a hack that needs work before being displayed as a FULL RELEASE. This should be in the beta hack forum.....<snip>


LMAO :D

You should go see Bill Gates with that one ;)

[Steve Machol]

[QUOTE]Originally posted by JTMON
Hey Steve,

What kind of chat software are you running? Am looking into this.

[Meta]

Thank you for the hack, Bane!

Easy to install ... working well ... well done!

[patvdv]

Hey Bane,

I just noticed today (1st of Dec) that the Monthly postings stats do not roll over. It seems like they keep being added from November. Any ideas what might be the cause?

[FWC]

Originally posted by patvdv
Hey Bane,

I just noticed today (1st of Dec) that the Monthly postings stats do not roll over. It seems like they keep being added from November. Any ideas what might be the cause? If you are referring to the top posters for the last month, it should be dynamic based on the last 30 days. I don't think it does or should reset with the first of a month.

[patvdv]

FWC,

Yes I am referring to that. If that would be the case, I'd say the titel should be changed from 'Last Month' to 'Last 30 days'. Maybe an option for a next release to allow the choice between true monthly based and xx days interval based.

[Bane]

Good Point Pat. And the wording is misleading. I wrote this suggestion down in my todo list. Thanks

[mvigod]

First let me say that vstats is an awesome hack. Good Job!

Now I have 2 questions of which I apologize if they were addressed in this thread already. I'm asking them because it takes me between 2 minutes to 5 minutes to pull up each page in vbulletin.org or vbulletin.com. The sites are EXTREMELY SLOW for me. I'm on a cable modem too. Anyone else have these speed issues. It's unbearably painfully slow. Is it just me?

My 1st question on vbstats is the date field on the setup file where it says date statistics begin. What does this field do if you change it? Also, what is the format? My default entry after install says 952001. What is that number?

Second question is with the exclusion URL. I listed my domain (in the form of domain.com) in the exclusion list but it keeps coming up in the referrer list. How do I keep it from coming up and excluding? I thought adding it to the url list would work?

Thanks and again, awesome job.

[Prezident]

This is a cool hack, I like the things it does. It would be cool if it would also track hits to the forums from not only countries, but states also, so I could get an idea of what states were visiting the forum.

Also, I know a couple people have asked about the performance hit this hack causes. Well I have found it to be significant. The tracking system causes a 20% - 40% CPU spike whenever a page is loaded. Just a brief one, but a spike nontheless. I am running my server from a P3-700 with 256 RAM.

People who are paying web hosts to run their forums and their servers may not be too concerned with this, but others who are running it locally might think twice.

So, besides the change in CPU demand, this hack is pretty cool.

Nice work, and thanks to you Bane.

[-=dm=-]

Thanx Bane it working fine:)

btw how do I uninstall it?

thanx in advance

dm

[-=dm=-]

can someone please tell me why it not showing any Countries
(Visitor Countries (0) )

is it possible to see vbstats on who is online section?

thanx in advance:)

dm

[FWC]

Originally posted by -=dm=-
is it possible to see vbstats on who is online section?dm You can do it manually, but Firefly released this wonderful hadk for adding Who's Online locations:

https://vborg.vbsupport.ru/showthread.php?s=&threadid=32849

[-=dm=-]

You can do it manually, but Firefly released this wonderful hadk for adding Who's Online locations:

thanx

but this one from FireFly is for the cp right?

how can I do it manually?

i want one like Bane have on he?s "Viewing Talk Loud Network Statistics"

[FWC]

In online.php add// vbStats
case 'vbstats':
$userinfo[where] = "Viewing <a href='vbstats.php?action=stats&s=$session[sessionhash]'>Statistics</a>";
break;
// vbStats Endright before case 'spider':
$userinfo[where] = "Search Engine Spider";
break;and// vbStats
case $forumprefix.'vbstats.php':
$userinfo[activity] = 'vbstats';
break;
// vbStats Endright before case '/robots.txt':
$userinfo[activity] = 'spider';
break;
default:
$userinfo[activity] = 'unknown';
}Add whatever words you want after "Viewing and before the <a href in the first code to change what it says.

[-=dm=-]

thanx man:)

I have also just installed the one from the link and I cant get it to work:(

ok I?ll this one now:)

thanx

[-=dm=-]

Thanx it works:):):)

can u please also help me with the other one, I dont know what Im doing wrong, I did exactly what FireFly wrote in the post and uploaded both files.
I cant see the whois online option in the admin cp.

thanx
dm

[FWC]

Originally posted by -=dm=-
can u please also help me with the other one, I dont know what Im doing wrong, I did exactly what FireFly wrote in the post and uploaded both files.
I cant see the whois online option in the admin cp.

thanx
dm I haven't installed Chen's hack yet because I already added all my links manually. I am going to install it the next time I need ot add one. It's cool. :)

[mvigod]

I have everything working ok but the referring sites is still showing my site as the top referrar and counting hits from it. I checked the database tables and my site is in the exclude table so why is it still showing up? Is anyone else having this problem?

Also, in the setup control panel for vbstats what does the date starting field do if you change it and what date format does it take? Mine says 952001???

thanks.

[-=dm=-]

I have the same problem and also countries does only show UK nothing else:(

can someone please help?

[Bane]

Originally posted by mvigod
I have everything working ok but the referring sites is still showing my site as the top referrar and counting hits from it. I checked the database tables and my site is in the exclude table so why is it still showing up? Is anyone else having this problem?

Also, in the setup control panel for vbstats what does the date starting field do if you change it and what date format does it take? Mine says 952001???

thanks.

Is your site listed as yoursite.com or www.yoursite.com? make sure its yoursite.com with no www. or anything like that. And what is coming up in the list?

The date can be any format, it makes no difference, it is only used to display tracking since > so this should be the date you began tracking.

Im really not sure why it wouldnt track countries. That seems to be a unique problem. Perhaps your server?

[-=dm=-]

hmm strange
it dont work for me:(
everything else are working fine.

I have problems with:

Referring Sites and Countries

please is there someone who can help me out.

thanx in advance

dm

[Amasov]

What kind of problems do you have with it ?

(*geee* sorry, i did'nt read the post before... )

So, just give us a link to your forum and we will see, what we can do....

[-=dm=-]

btw this statstic thingy are showing alot of fake info.
I like the hack and I like the whole style of it. but for me it look like something , which should only be added for fun its not any seriuse stuff, and Bane why is Denmark flag not showing on u r Visitor Countries page, I see u have my site on u r Link Queue, so urs are also not working correct, u have even newer version of they vBstat hack.

sorry if Im wrong, but I have playid with that vbstatic 2 days and with no luck.

but its still one of the cools hacks:)

thanx

dm

[Bane]

dm - there is a known problem with the country detection. Im going to use a new scheme if I can ever get time to work on it.

[Symbian.info]

I wil get
Unknown Location: /forum/vbstats.php?&action=stats&s=
With who is online...

[floleb7]

do you have www.yourforum.com/forum and forum.yourforum.com for visitor ?

[FWC]

Originally posted by Symbian.info
I wil get
Unknown Location: /forum/vbstats.php?&action=stats&s=
With who is online... You can fix this manually in online.php. There are instructions somewhere in this thread. I would recommend installing this hack:

https://vborg.vbsupport.ru/showthread.php?s=&threadid=32849

It makes it really easy to add new locations to Who's Online.

[Symbian.info]

Originally posted by FWC
You can fix this manually in online.php. There are instructions somewhere in this thread. I would recommend installing this hack:

https://vborg.vbsupport.ru/showthread.php?s=&threadid=32849

It makes it really easy to add new locations to Who's Online.

Already installed, but is still the same problem.. Maybe because our forum is in Dutch?

Butt a like Vbstat it very mutch..!

floleb7: our url is: www.symbian.info/forum

[DarkReaper]

Strange...

http://dynamic3.gamespy.com/~serioussam/forums/vbstats.php?action=topposters

It shows the top 3 posters as being sartophiketle, MasterEvilAce, and Smithboy, but here (http://dynamic3.gamespy.com/~serioussam/forums/memberlist.php?s=&what=topposters&perpage=15) it has it in a different order. To see post counts on the member list edit the html code and search for "2475" - you can clearly see that there's a different reported post count between the 2.

sartophiketle has 2475 posts on the top 15 posters list in member.php, but in vbstats.php he has 2103...??

Also, for the last 30 days...it could be right, but most likely isn't...800 posts in 30 days? Um..yea.

[The Realist]

I have 2 problems.

1) I am running version 2.2.1 and in admin/index.php I cannot find:

<tr><td>
<table width="100%" border="0" cellspacing="0" cellpadding="2" id="navtable">
<?php maketableheader("Stats & Logs"); ?>

BUT I can find something similar to:
<table width="100%" border="0" cellspacing="0" cellpadding="2" id="navtable">

So I placed the requiered txt above that "IS THIS CORRECT" OR WERE SHOULD I PLACE IT"

Also I am getting the following errors when wiewing the "View Public Statistics" in CP.

Warning: Division by zero in /usr/local/psa/home/vhosts/skytronic-forums.com/httpdocs/vbstats.php on line 159

Warning: Division by zero in /usr/local/psa/home/vhosts/skytronic-forums.com/httpdocs/vbstats.php on line 165

Warning: Division by zero in /usr/local/psa/home/vhosts/skytronic-forums.com/httpdocs/vbstats.php on line 162

Warning: Division by zero in /usr/local/psa/home/vhosts/skytronic-forums.com/httpdocs/vbstats.php on line 186

Warning: Division by zero in /usr/local/psa/home/vhosts/skytronic-forums.com/httpdocs/vbstats.php on line 148

Warning: Division by zero in /usr/local/psa/home/vhosts/skytronic-forums.com/httpdocs/vbstats.php on line 139

Warning: Division by zero in /usr/local/psa/home/vhosts/skytronic-forums.com/httpdocs/vbstats.php on line 145

Warning: Division by zero in /usr/local/psa/home/vhosts/skytronic-forums.com/httpdocs/vbstats.php on line 142

Warning: Division by zero in /usr/local/psa/home/vhosts/skytronic-forums.com/httpdocs/vbstats.php on line 136

Warning: Division by zero in /usr/local/psa/home/vhosts/skytronic-forums.com/httpdocs/vbstats.php on line 151

Warning: Division by zero in /usr/local/psa/home/vhosts/skytronic-forums.com/httpdocs/vbstats.php on line 154


Any help please?

Brian :confused:

[KuraFire]

Okay, I'm still reading this thread but here's a suggestion in advance:

Bane, how about adding [Stats home] at the bottom nav so that people don't have to click the Statistics link in "$bbtitle > Statistics > .... " anymore to get to the main page of the Statistics? :)

I really miss that "home" link down there. :)



Also, I would like to know how to remove all parts about Referrals in this hack. I don't use the referral system on my board so it'd be pretty useless to have the "Top Referrer" listed - can this be edited out easily?


And to FWC: Would you please tell me how you have the whole Statistics block coded into your Forum Home page? I'm talking about the block that starts with a link to the vbstats.php and ends with "Hottest thread this week" - I would LOVE to have that overview on my forum home as well, please tell me how to code this in there. I'd be very grateful :)



Furthermore: I'm waiting until I read that there is a fully detailed zipfile with instructions and Everything all sorted together, for vbulletin 2.2.1 - meaning I won't have to search through this Very long thread all over again to find out how to make this work on vbulletin 2.2.1, from a clean install (haven't installed this hack ever, so far). It'd be great if you, Bane, could make a new decent and complete overview again in your next release. I think MANY people would be very grateful if everything would be put in a clear and complete overview again, it would prevent users from REPEATEDLY asking the same questions and reporting the same issues.

Maybe you ought to close this thread and start a new one with your next release, have a clear overview there and everything?

[KuraFire]

Originally posted by Bane
I appreciate that bro :) And believe me I have seen the totals, they astound me :p I think it has a lot more to do with the hack than me though. A lot of people are statistic hounds like me I guess.

Yup. I'm a stat.hound as well, that's why I like this hack so much. However, I think in all fairness that having to sift through several hundred posts just to find one or two posts that describe how to make it work for 2.2.0 and 2.2.1 isn't something you should EXPECT from the users. That's a LOT of work, especially since most of this thread is repetitive, i.e. person A going "I have this and this error" and then one or more people answering how to fix it, and that goes on for most of the entire thread. It's very easy to lose focus when reading such things, and then you miss the one or two posts that have the added instructions for 2.2.x and you get upset because you can't find it.

What I think is a good idea, is to just add those instructions to the attachment in the first post if you haven't already. If you have, I apologize and will just continue reading this insanely long thread. :)

Btw: I think it's absolutely great that you're doing this Bane, you've been an excellent hacker in both creating and supporting everyone with this, very admirable. You might not have as many hacks as FireFly or so, I know of only one hack that is better than this one, and that's a tiny, very easy hack of two lines only that prevents signatures from being shown by default for a second time in a thread.

I'll shut up again till I have more to add. *continues reading after the Hooper incident ;)*

[KuraFire]

I should stay out of this, I know, but I just can't resist:

Originally posted by Hooper
BTW, you are not talking to a kid here. You are talking to a NATTS certified computer technician with a degree and 15 years in the field. You are also talking to someone who knows html and the fundamentals of Web Dev.

15 years of coding experience with HTML and what not, and you still don't know how to spell "apologize" (pending on the case, this could also be "apologise" of course) ?

Sorry, but I've had several debates on INA with people who think spelling has nothing to do with intelligence, and that people who attack others on their lousy spelling capabilities are 'losing the debate' but that's just a load of crap. If someone is truly intelligent and arrogant enough to BOAST about their intelligence, the least they could do is spell their posts properly, in order to be at least a BIT believable.

By Hooper again
It's fine when you get posts on how nice your hack is by the kids. But when you get someone that does know what they are talking about, try to not treat them like they are out of line.

We're not condescending at ALL here, are we now? Earth to Hooper: just because YOU have 15 years of experience (not in spelling, though ;)) doesn't mean that EVERYBODY else here is a kid and has no valuable opinion or input.
I think the only reason people responded to you as if you were "out of line" is because of your arrogant, cocky and condescending attitude that is very inappropriate on a forum like this. Bane is offering his services for free, everybody else here is offering their help and support for free. The least you could do is be CIVIL towards people when you complain.


There, ranted out, and I tried to keep it as short as possible. I'll continue reading again, lol :D

[KuraFire]

Originally posted by trilOByte
LMAO :D

You should go see Bill Gates with that one ;)

LOL, good one! GG_OWNED @ Hooper ^_^



Bane et al: Adding the Stats page to the Forum Jump, that would require only ONE template (per style) to be changed, am I correct? Cos that'd be quite nice, to have the Statistics listed in the Forum Jump menu :)

[KuraFire]

Originally posted by DarkReaper
Also, for the last 30 days...it could be right, but most likely isn't...800 posts in 30 days? Um..yea.

Bwhahaha, forum-n00b! ;)

I once posted 2000 posts in 30 days, not a single post was spam or anything. It can be done easily, y'know. Just work in a position where you can surf online all day long and you can easily amount up to 3K of posts a month, less if you actually post LONG posts all the time (like I usually do... *shudder*).


Anyway...

TheRealist: you have to add a line to your phpinclude template. You can find that in your Admin Panel > Styles: Modify > Edit Fonts/colors > first template is the phpinclude template. Add this line to that template:

include("vbs_counter.php");

That should take care of all the Division by zero errors. :)
The other problem, I don't know..

[FWC]

Originally posted by KuraFire
And to FWC: Would you please tell me how you have the whole Statistics block coded into your Forum Home page? I'm talking about the block that starts with a link to the vbstats.php and ends with "Hottest thread this week" - I would LOVE to have that overview on my forum home as well, please tell me how to code this in there. I'd be very grateful :)
That isn't vBstats, though I did put the link to vBstats at the top. That's a couple of hacks I merged together and modified. It's just one chunk of code and one template now. Send me an email and I'll work up some instructions and send you the stuff.

[DarkReaper]

Originally posted by KuraFire


Bwhahaha, forum-n00b! ;)

I once posted 2000 posts in 30 days, not a single post was spam or anything. It can be done easily, y'know. Just work in a position where you can surf online all day long and you can easily amount up to 3K of posts a month, less if you actually post LONG posts all the time (like I usually do... *shudder*).


Bah. What about my other problem, with the most posts ever counts varying?

[KuraFire]

Not sure about the other issue DR, sorry. I can only come up with it something to do with the fact that they messed around Big time with postcounts on those forums - seeing as how they don't show up anywhere aside of on the vbstats page, I think it safe to assume they Might have messed with the post counts on different locations as well, which, in turn, could be the reason these postcounts are messed up in different places.

Also, could be just something to do with the way they have the queries in vbstats implemented - i.e. do vbstats' queries select posts from the user's Current Postcount, or all of the users posts INCLUDING those in forums that don't COUNT towards your post count, and/or does it include deleted posts?

It's probably something with queries combined with their messing about, but again: I am not sure on Any of all this!

[DarkReaper]

I run those boards, and haven't touched the post counts. I removed post counts from displaying because of issues with them, and spam...

[The Realist]

Any help on the below chaps?..................Please.

I have 2 problems.

1) I am running version 2.2.1 and in admin/index.php I cannot find:

<tr><td>
<table width="100%" border="0" cellspacing="0" cellpadding="2" id="navtable">
<?php maketableheader("Stats & Logs"); ?>

BUT I can find something similar to:
<table width="100%" border="0" cellspacing="0" cellpadding="2" id="navtable">

So I placed the requiered txt above that "IS THIS CORRECT" OR WERE SHOULD I PLACE IT"

Also I am getting the following errors when wiewing the "View Public Statistics" in CP.

Warning: Division by zero in /usr/local/psa/home/vhosts/skytronic-forums.com/httpdocs/vbstats.php on line 159

Warning: Division by zero in /usr/local/psa/home/vhosts/skytronic-forums.com/httpdocs/vbstats.php on line 165

Warning: Division by zero in /usr/local/psa/home/vhosts/skytronic-forums.com/httpdocs/vbstats.php on line 162

Warning: Division by zero in /usr/local/psa/home/vhosts/skytronic-forums.com/httpdocs/vbstats.php on line 186

Warning: Division by zero in /usr/local/psa/home/vhosts/skytronic-forums.com/httpdocs/vbstats.php on line 148

Warning: Division by zero in /usr/local/psa/home/vhosts/skytronic-forums.com/httpdocs/vbstats.php on line 139

Warning: Division by zero in /usr/local/psa/home/vhosts/skytronic-forums.com/httpdocs/vbstats.php on line 145

Warning: Division by zero in /usr/local/psa/home/vhosts/skytronic-forums.com/httpdocs/vbstats.php on line 142

Warning: Division by zero in /usr/local/psa/home/vhosts/skytronic-forums.com/httpdocs/vbstats.php on line 136

Warning: Division by zero in /usr/local/psa/home/vhosts/skytronic-forums.com/httpdocs/vbstats.php on line 151

Warning: Division by zero in /usr/local/psa/home/vhosts/skytronic-forums.com/httpdocs/vbstats.php on line 154

Any help please?

[FWC]

Originally posted by The Realist
Any help on the below chaps?..................Please.Message #482 above:
Originally posted by KuraFire
Anyway...

TheRealist: you have to add a line to your phpinclude template. You can find that in your Admin Panel > Styles: Modify > Edit Fonts/colors > first template is the phpinclude template. Add this line to that template:

include("vbs_counter.php");

That should take care of all the Division by zero errors. :)
The other problem, I don't know.. For your other issue. Put this:// vbStats
makenavoption("Config","vbstats_set.php?action=edit","<br>");
makenavoption("View Public Statistics","../vbstats.php?action=stats","<br>");
makenavoption("Exclude URL","vbstats_set.php?action=add");
makenavselect("vbStats","<hr>");
// vbStatsunder this:// ***
makenavoption("Statistics","stats.php?action=index","<br>");
makenavoption("Admin Log","adminlog.php?action=choose");
makenavselect("Statistics & Logs",$df);
//***You should be set to go.

[DarkReaper]

Me next, me next! :D

[FWC]

Originally posted by DarkReaper
Me next, me next! :D vBstats directly queries the database and pulls the current post totals. It does not filter for forums where you exlcude post counts. It is a real time total post count as far as I know.

[KuraFire]

Originally posted by FWC
vBstats directly queries the database and pulls the current post totals. It does not filter for forums where you exlcude post counts. It is a real time total post count as far as I know.

Yeah but there was someone who added to the vBStats-query to make it count ONLY realtime posts, thus Excluding those from forums that don't count posts. That query is SOMEWHERE in this thread, but I'll be damned to know what page exactly! :(

And that's why I would love to see someone make an overview again. But my guess is that Bane is really busy so I'll be patient and shut up again ;)

[The Realist]

Thank you, works like a charm.

;)

[FWC]

Originally posted by KuraFire


Yeah but there was someone who added to the vBStats-query to make it count ONLY realtime posts, thus Excluding those from forums that don't count posts. That query is SOMEWHERE in this thread, but I'll be damned to know what page exactly! :(You would go into the queries for counting posts in vbstats.php and add the appropriate AND forumid<>'XX' AND forumid<>'YY' to the WHERE clauses.

[dyt4]

Can you tell me is there a really working version for 2.2.1 ???

I use 2.2.1 here : http://forum.dyt4concept.org

thx

regards

david

[Kengan]

Nice Hack !!

[Dalius]

I cant find the place to edit the admin/index.php

:confused:

2.2.1

[Xsentrik.com]

nice hack

[KuraFire]

Originally posted by FWC
You would go into the queries for counting posts in vbstats.php and add the appropriate AND forumid<>'XX' AND forumid<>'YY' to the WHERE clauses.

No, somewhere in this thread there's a better solution. Something to do with simply taking the same query method as the vB system itself does...

But since this thread is 11 pages, I wouldn't know where exactly it is NOR do I feel like digging through it.

[dotagious]

I was wondering what kind of ratio the activity level stat calculates off of? What does it take into consideration before giving the result and what should it be compared to?

[Bane]

Active Users vs. Non Active Users

Percentage of total users that are active.

[KuraFire]

Bane, how's the progress going on fixing the current issues and improving the hack? :)