vbStats

[G4cE]

Looks like a nice hack, but i'l lwait till a newer version comes out for 2.2.1.

Also, maybe a good idea to start a new thread bout a 2.2.1 version? 34 pages is a bit much lol :D

least it means ya hacks popular:p

G

[Bane]

I've worked on it a bit, but since this is normally the busiest time of the year for me its hard to find time. Its still a front burner thing for me but unfortunately gotta get the paid stuff done first. :(

[KuraFire]

Originally posted by Bane
I've worked on it a bit, but since this is normally the busiest time of the year for me its hard to find time. Its still a front burner thing for me but unfortunately gotta get the paid stuff done first. :(

Ah, great, no worries mate, glad to hear. I was primarily asking to see if you were still interested in working on this superbe hack - unfortunately, some of the coolest hacks I know never got made entirely public or got updated to include the last few required elements or whatnot, to make it worthwhile for me. It's great to see you still wanting to work on it - and I think I speak for all of us that we don't mind at all that you have to do other stuff first. You're doing this from the kindness of your heart, and we appreciate it a LOT! :up::up::up::up:

:)

[dotagious]

[QUOTE]Originally posted by Bane
Active Users vs. Non Active Users

Percentage of total users that are active.

[KuraFire]

None, that's actually 35% (35,333 to be precise) - the division that is used in the hack is just really weird :p

[dotagious]

Ouch. Wonder if there is a way to change it.

[FWC]

Originally posted by Avenger
Ouch. Wonder if there is a way to change it. In vbstats.php change this line$activityrate=sprintf("%.2f",(1000*$activemembers/$numbermembers));to$activityrate=sprintf("%.2f",(100*$activemembers/$numbermembers));Then go into the vbstats_stats template and add % after $activityrate.

[dotagious]

Oh no.. no you don't! Just Kidding lol thanks bro.

[FWC]

Originally posted by Avenger
Oh no.. no you don't! Just Kidding lol thanks bro. I was thinking the same thing. :D

[XiXora]

i dont have time too read all 500 of the posts so is there ne thing i have to add so this works for vb221?

[dotagious]

That's funny, because I don't have time to answer your question.

:D

[hypedave]

okay this is a great hack, it was easy to install,
I got one problem though , lol
this is how my phpincluide file looks like

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

and here is the error that im getting

Warning: Division by zero in c:\inetpub\wwwroot\hybridforums\forums\vbstats.php on line 159

Warning: Division by zero in c:\inetpub\wwwroot\hybridforums\forums\vbstats.php on line 165

Warning: Division by zero in c:\inetpub\wwwroot\hybridforums\forums\vbstats.php on line 162

Warning: Division by zero in c:\inetpub\wwwroot\hybridforums\forums\vbstats.php on line 186

Warning: Division by zero in c:\inetpub\wwwroot\hybridforums\forums\vbstats.php on line 148

Warning: Division by zero in c:\inetpub\wwwroot\hybridforums\forums\vbstats.php on line 139

Warning: Division by zero in c:\inetpub\wwwroot\hybridforums\forums\vbstats.php on line 145

Warning: Division by zero in c:\inetpub\wwwroot\hybridforums\forums\vbstats.php on line 142

Warning: Division by zero in c:\inetpub\wwwroot\hybridforums\forums\vbstats.php on line 136

Warning: Division by zero in c:\inetpub\wwwroot\hybridforums\forums\vbstats.php on line 151

Warning: Division by zero in c:\inetpub\wwwroot\hybridforums\forums\vbstats.php on line 154

what the heck did I do wrong, lol
can some help me out,

[FWC]

All you need in your phpinclude is:

include("vbs_counter.php");

[hypedave]

ok let me try that real quick

[hypedave]

okay that worked, but now, since I am using vbportals

what I should I do with the

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

[FWC]

I'm not sure since I don't use vBPortal. I would think you could have that in there, too. You just needed to get the vbstats include out of the if statement you had it in.

[hypedave]

cool it works, thanks for the quick response

[FWC]

Glad to help. :)

[hypedave]

hey where do I get this user online hack at, thats pretty cool, and the minimize button as well, lol

now on vbstats, the referring sites isnt working, I click on my forum url from my yahoo email box, and it didnt show that a hit came from a yahoo url, what could be wrong there

vbstat is located at

domain.com/forums/vbstats

and forums home page is

domain.com

any suggestions

[okrogius]

I installed it just fine, however any of the vbstast php pages just give me a blank white page. :(

[Bane]

Codename49: Make sure the path to the language file is correct. are you using a translated version?

[okrogius]

No, I use the default english version.

[hypedave]

how do I clear the vbstats
I would like periodically reset the stats

[XiXora]

Originally posted by Avenger
That's funny, because I don't have time to answer your question.

:D

haha NO, thats just a stupid comment. yes or no would of done

[hypedave]

so can anybody answere my question

[Bane]

hypedave: This will be included in the next version, but for now the easiest way to reset the stats is to run the un-install then reinstall. You dont have to take out the file hacks and it wont mess up any template customizing you do. Just deletes the tables and readds them.

XiXora: Yup it does, but you have to sort through the 500 posts for the fixes for the 2.2.x files :D

Codename49: The only time I have had problems with the white screen is when one of the included files are missing. Or you may have reuploaded the default style. Check to be sure:

1) Your vbstats language file is uploaded.
2) You do in fact have the templates installed for all styles.
3) That the path to the counter is correct.

[hypedave]

man its that easy, lol okay, thanks man, this is a vey nice addon it takes the place expensice software =)

[XiXora]

erk. i hope they work as they are then thanx bane. are you workin on a 2.2.1 specific version to work properly?

[JohnBradshaw]

Bane,

This hack is great! I notice on the talkloud site that you have a Stars and Awards hack can you tell me where to get them as they are perfect for my site!

Oh and Merry Christmas!

[andrew67]

Hi,
Can anyone help me out please? I've installed this hack in vbulletin 2.2.0. I ran the install file fine, I didn't intall any of the optional hacks except the admin cp one. Run the settings file and it all works fine, however if i try load the stats i get this error...

Warning: Supplied argument is not a valid MySQL result resource in /home/virtual/site1/fst/var/www/html/forum/vbstats.php on line 88
1046: No Database Selected

Please help I dont know what I've done wrong in the install.... Thanks in advance.

[hypedave]

hey are you runnin vbportals ???
I tryed to install this one time on a vb forum alone, really didnt have any success, but I installed on my vbportals, and had very much good success, and how does line 88 look

[andrew67]

Thanks for the quick reply, Nope not running vbportal.. Just VB 2.2.0..

Lines 87 88 89 look likes this:


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

[hypedave]

well only thing I can think of is you are running 2.2.0 and this hack has been written for 2.2.1 , now I maybe wrong , im not sure, but go to Bans site and see if he has a version out for 2.2.0 , there is probably a diffence in the php file ???

[Bane]

The version on the site is for 2.0 not 2.2 that one is really old, I'm working on another in the next week.

[XiXora]

can we have counters counting on an ip or summin? cos when i refresh the stas go up :)

[hypedave]

yeah same here when I refresh, stats go up,

[paulsmith]

Thanks for a excellent Addon!

[andrew67]

So i take it then the version here don't work with 2.2.0 ?? Is the no way i can fix that error ?? Or do i have to wait for the new version? is so will that work with 2.2.0 ? I can't be bothered upgrading yet I just spent weeks getting the forum the way I wanted it...

[FWC]

Originally posted by andrew67
So i take it then the version here don't work with 2.2.0 ?? Is the no way i can fix that error ?? Or do i have to wait for the new version? is so will that work with 2.2.0 ? I can't be bothered upgrading yet I just spent weeks getting the forum the way I wanted it... It works with 2.2.0. admin/index.php changed from 2.0.3 to 2.2.0. You just need to use the 2.2.0 way of adding the links in the admin CP.

[andrew67]

which are?? :) I think i did that as the options are in the admin cp when i load it, just when i click on display stats i get this:
Warning: Supplied argument is not a valid MySQL result resource in /home/virtual/site1/fst/var/www/html/forum/vbstats.php on line 88
1046: No Database Selected

??? I know I'm a pain, but I really do appreciate the help.. :rolleyes:

[andrew67]

Well I bit the bullet and upgraded to 2.2.1 and still the same error, thing is though when I install on my personal backup copy on server at home it works fine.. Its got me stumped...

[hypedave]

another successful installed hack

on my board I am running

vb 2.2.1
vb portals PR7 upgrading to 8 soon

I didnt like that stats included with portals it seemed to be a lite version of vbstats, so i wanted the fullest, but if anyone wants to see the stats running, here is the link

http://www.mindsights.com

[MalaK_3araby]

Many Thanks for the hack ..


Originally posted by andrew67
So i take it then the version here don't work with 2.2.0 ?? Is the no way i can fix that error ?? Or do i have to wait for the new version? is so will that work with 2.2.0 ? I can't be bothered upgrading yet I just spent weeks getting the forum the way I wanted it...

Andrew .. i belive the changes needed in (admin/index.php) is as follows:

find:makenavoption("Statistics","stats.php3?action=index","<br>");
and above that insert this code:
// <!-- vbStats -->
makenavoption("vbStats Config","vbstats_set.php","<br>");
makenavoption("View Public Statistics","../vbstats.php","<br>");
makenavoption("Exclude vbStats URL","vbstats_set.php?action=add","<br>");
makenavselect("vbStats");
// <!-- vbStats -->

However i am having a session problem with "vbstats_set.php" & "vbstats.php" .. the 2 pages won't load as:
[path]/vbb/vbstats.php
[path]/vbstats_set.php
but they load & work fine without the session, i.e:
[path]/vbstats.php
[path]/vbstats_set.php
the 3rd file "[path]/vbstats_set.php?action=add" works just fine.


Any thoughts?

forgot to mention .. running on 2.2.1

[mSoul01]

Originally posted by MalaK_3araby
Many Thanks for the hack ..

However i am having a session problem with "vbstats_set.php" & "vbstats.php" .. the 2 pages won't load as:
[path]/vbb/vbstats.php
[path]/vbstats_set.php
but they load & work fine without the session, i.e:
[path]/vbstats.php
[path]/vbstats_set.php
the 3rd file "[path]/vbstats_set.php?action=add" works just fine.


Any thoughts?

forgot to mention .. running on 2.2.1

Malak_3araby:

got it to work.. had to change the line to show:
vbstats.php?action=
vbstats_set.php?action=

The last vbstats_set worked fine, since it already had an action assigned to it.

Hope this helps.

[MalaK_3araby]

Originally posted by mSoul01

Malak_3araby:

got it to work.. had to change the line to show:
vbstats.php?action=
vbstats_set.php?action=

The last vbstats_set worked fine, since it already had an action assigned to it.

Hope this helps. [/B]


It solved the problem ... many thanks mSoul01 :)

[Sadie Frost]

Installed on 2.2.1 - works perfectly with the changes outlined on page 18 of this thread.

Awesome! :)

[Tim Wheatley]

I've noticed users from Denmark are not brought onto the countries page, is there any way to add something so they will?

I've opened up vbstats and there's no reference to Denmark or .dk in there anywhere, so is this part of the MySQL table? If so, where?

Thanks.

Tim

[Bane]

Tim, currently vbstats pulls the encoding from your browser and inserts a hit in the database under DK. You can find it in the tables.

[Tim Wheatley]

Hmm... :(

It doesn't seem to be working for me then.

All other countries count it seems, the server is in Denmark, and 20-40% of the visitors are from Denmark, but there's no hits being counted.

http://forum.racesimcentral.com/vbstats.php?action=country

[Tim Wheatley]

Yeah the other admin think dk is the only one not working, others all seem to be.

[Bane]

As I said, it goes by the language encoding you have set up.

Im not sure why its not registering, do you have someone there from denmark who can test what those hits are counting as?

[Tim Wheatley]

Yeah I have about a thousand who could help me. :)

How would they go about finding out for me??

I thought all Denmark ISP's would use DK? Or is that not what we're on about? :confused:

[Bane]

vbStats doesnt detect by IP. It uses language encoding. In other words its detecting the language setup of windows and not the ip or isp info. Really it should say User Languages instead of User Countries but..

The easiest way they can help you is have them go to the address:

your-path-to/vbstats.php?action=info

and paste you the region code line. that will tell you what the counter is finding.

[fonzerelli_79]

First of all id like to thank you for this great hack
youve obviously spent a lot of time with it

i have a few questions which i hope you can answer


You mentioned that vbstats detects the language setup of windows and not the ip when displaying what country they're from. Im from the UK, but i use the american keyboard set up (cos thats the way i installed it and im used to where all the keys are). This is now saying that i am from the USA. Is there not a way round this.
Reardless of how many times i exclude my own domain in the admin panel, my site still appears in the link queue. Why is this?
I use vbportal and have switched my stats page from http://www.presents4them.com/stats.php (http://) to http://www.presents4them.com/forums/vbstats.php . Is there an easy way to merge the link and downloads section into your hack. The first stats page which i mentioned has more fields and would be relevant to my site, especially to advertisers (ie. no of links clicked)
Also, is there a way to port my old statistics to this hack. What i mean is that the first page says i have had 'Since December 27th, 2001 we have received 17257 page views.' My new stats page says 0. Is there a way to add your old page views to the database
Is there an easy way to add the link queue to another page ie. the header or footer



Thanks bane and keep up the goodwork

(also, why was a certain member very reluctant to link back to your site - not good karma!!)

[Bane]

1) Currently no way around it. I hope to have ip detection in the next version.

2) If presents4them.com is in the exclude list it is likely still showing up because of making it into the list before it was excluded.

3) This can be done yes, you may have to wait a while unless your willing to pay for it though, as my free time is somewhat limited atm. :( That Im sorry about.

4) The easiest way would be to enter it into the field in phpMyAdmin. IE edit it so you have the 17257 views instead of 0.

5) I will be putting this in the next version (I cringe when I say that, it's been so long.)

[fonzerelli_79]

thanks bane for your speedy and honest response

all the best and good luck with the next version

[M.h.f]

very cute... BUT plz check mine and tell me wts wrong on it... :)
http://www.hagasny.net/vbstats.php

[Bane]

M.h.f. - Second post of this thread answers your problem.

make sure you made the changes to the phpinclude template

[M.h.f]

plz man cant be more specific??
i am stupid in php :(

[Bane]

Not PHP, its vbulletins templates. Read through the directions included in the zip.

you can find you phpinclude template in your vbulletin admin panel and in the menu templates click |edit| you should click on the set you wish to edit and scroll down until you see the name: phpinclude

Add the line

include("./vbs_counter.php");

in this template

[Tim Wheatley]

Ok, I posted a thread in the Danish off topic forum on my site and here it is:
http://forum.racesimcentral.com/showthread.php?s=&postid=107971

There's some strangely different stats being pulled there, any idea what I should modify the table 'dk' to?

[Joshua Clinard]

Can we have an ETA on the new version?

[M.h.f]

hello man
its me again..
sorry for annonying..
but i cat find this templates...
what can i do??

[Shenlong]

The thing about

admin/index.php

I cannot find that, not sure if its already been asked, just dont feel like reading 500 replies, 6 pages, so, can anyone help?

[Sadie Frost]

I'm not sure if this is what you're asking about, but if you follow the directions in the zip, and do the ones on page 18 of this thread, it should work for you. :)

[andrew67]

This has got me really stumped. Any help would be appreciated :D Ive got the hack to work fine on my home machine (XP Server) and a test copy of vbulletin 2.2.1. Runs fine not a problem had to edit one thing to get to work under XP but thats it. Once I try the install on my host (Linux) with the real site (I've tried about ten times) I continue to get this:

Warning: Supplied argument is not a valid MySQL result resource in /home/virtual/site1/fst/var/www/html/forum/vbstats.php on line 88
1046: No Database Selected

Is it something I'm doing wrong?? I read through most of this massive thread but cant find a sollution...

[sevenOne8]

I am running vbulletin 2.2.1 with the latest vb portal 3.0b I think and I installed it and everything works except for the additions to admin/index.php - I tried copying the format in there but it doesnt work because clicking on a link in that format adds the cookie id to the end and the php page does not load

I couldnt find the text that the instructions said to look for.. cAn someone help?

[FWC]

Originally posted by sevenOne8
I am running vbulletin 2.2.1 with the latest vb portal 3.0b I think and I installed it and everything works except for the additions to admin/index.php - I tried copying the format in there but it doesnt work because clicking on a link in that format adds the cookie id to the end and the php page does not load

I couldnt find the text that the instructions said to look for.. cAn someone help? Put this wherever you want in the left menu:// 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

[Jawelin]

Originally posted by Sadie Frost
Installed on 2.2.1 - works perfectly with the changes outlined on page 18 of this thread.

Awesome! :)

What's page 18 ????
I have only 5 pages as I set max per page... :)
Please, could you give the post# reference for a full 2.2.1 version ? :confused:

Thanks

[fonzerelli_79]

i can understand why members do not want to go throgh 38 pages of posts but it is incredibly cheeky to expect some other member to go and do that for you

if you want something done, do it yourself!!

[Bane]

A link to the instructions for installing on 2.2.1 can be found HERE (https://vborg.vbsupport.ru/showthread.php?postid=198797#post198797) and a link has been added to the small FAQ in the second post of this thread.

Not that anyone reads it :p

[Lucky]

Wicked work buddy!

Thank you :)

[Jawelin]

Hi Bane.

Great job! I finally installed it reading all this +570 posts thread !!! :stupid:

Everything works on my 2.2.1, even the optional features like online.php and admin/index.php.

But.... ;)


... when I tried to install the forumhome addon, as shown in
Post #342 (https://vborg.vbsupport.ru/showthread.php?postid=201406#post201406), I got only the usual forum homepage instead of one with all suggested statistics added...

I carefully created the vbstats_forumhome template and added the lines to index.php (on forum base dir)... even the FireFly's correction " $tltoday=time()-(86400); "....

All those vars seem to be calculated (I didn't got any php parse error), but I can't see anything of vbstat..... template on my forumhome.

What else could I check if forgot ?


P.S.: what's the sintax of "Date Statistics Begin", defaulted to '952001' ?

Thanks a lot.

Bye

[Bane]

Did you add the var to forumhome?

Date started is pretty useless.. just a date.. it only displays in the link list.. only worry about it if you want to.. I just put the date I started tracking with vbStats

[Jawelin]

:noid:

Just analyzing the index.php code I found the line: eval("\$vbstats = \"".gettemplate('vbstats_forumhome')."\";"); so I guessed the 'external' name of this 'bit' was actually $vbstats and not $vbstats_forumhome as I tried to insert before into forumhome template... :kiss:

Thanks.

Hwr, some number on that first page didn't match... Infact I had activeusers as a negative number, and the rate absolutely inconsistant.
The part in index.php // 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",(100*$activemembers/$numbermembers));
should be replaced with // Active/Non?
$snonposters=$DB_site->query_first('SELECT COUNT(*) AS users,MAX(userid) AS max FROM user WHERE posts=0');
$nonposters=$snonposters['users'];
$activemembers=$numbersmembers['users']- $nonposters;
$activityrate=sprintf("%.2f",(100*$activemembers/$numbersmembers['users']));

That's because the $numbermembers variable is not a number but a string (comes from a format for thousands separator)...
My version used the original value coming from SELECT....

Hope this could be useful to the advanced options...

Thanks a lot for such a fast answer.


P.S.: the starting date. I didn't found anywhere on vbstats.php pages... :?:

Thanks again.
Bye

[Smallville]

In my admin CP when I click View Public Stats or whatever, I get this. Warning: Division by zero in /home/thechar/public_html/vbstats.php on line 159

Warning: Division by zero in /home/thechar/public_html/vbstats.php on line 165

Warning: Division by zero in /home/thechar/public_html/vbstats.php on line 162

Warning: Division by zero in /home/thechar/public_html/vbstats.php on line 186

Warning: Division by zero in /home/thechar/public_html/vbstats.php on line 148

Warning: Division by zero in /home/thechar/public_html/vbstats.php on line 139

Warning: Division by zero in /home/thechar/public_html/vbstats.php on line 145

Warning: Division by zero in /home/thechar/public_html/vbstats.php on line 142

Warning: Division by zero in /home/thechar/public_html/vbstats.php on line 136

Warning: Division by zero in /home/thechar/public_html/vbstats.php on line 151

Warning: Division by zero in /home/thechar/public_html/vbstats.php on line 154

What should I do? It's in one of the files that came from the zip, so I don't think I did something wrong. PLEASE HELP. This is a ver cool hackl.

[Bane]

Smallville: Please take another look through the directions. Or at the second post of this thread. Or at any one of the 150 people who posted that same error. :( You didn't include the counter in the PHP include. For directions read the directions or the second post of the vbstats thread.

[Jawelin]

And me :kiss: just comin' before Smallville's question ?
;)

[Bane]

I will look at that when I update. Not having a problem on my board, but you never know. I have to adjust the activity level setting anyway.. by default it should be a percentage.

The starting date is something you can include.. IE if you want {900093093 Hits since $startdate} on your page. :D

[Smallville]

Figured out my problem.

I added what you said in the FAQ in the second post here, but what you gave is wrong.

The FAQ says to add include("./counter.php"); in the phpinclude template, but it's actually include("vbs_counter.php");

I found this on page 6 or something. Doesn't matter, but you should probably change the FAQ, because I did what you said there from the start and it was wrong. That's why I posted here. I do look at every post, but with 39 pages, I decided for THIS TIME to skip them. Sorry to annoy you.

[Bane]

Not an annoyance to me bro. If I seemed annoyed I apologise, It wasn't meant to come across that way. I understand not wanting to read through 39 pages of responses, but most of the reason people have to read through so much is because people have been not wanting to read since there were only 5 pages :) :p

Thanks for the tip on the FAQ, it has been corrected. :D

[Smallville]

Not a problem.

I'm working on integrating some of the stats this hack can show you with the Member Welcome Menu hack. That way at the top, under your avatar and all that, you can see a lot of the important stats.

http://www.matrix-unplugged.com will be where it's at when it's done.

[Sparkz]

Bane, I noticed that calling vbstats.php?action=info created a different region code on my site than on your site.

I suspect your version to be a bit updated or something :)
Any idea when you will release it to the public?


Great hack, btw :)

[Smallville]

Ok, what I was doing to integrate those into a welcome menu isn't working.

How do I extract one piece of the code to put on the welcome page.

Like, if I wanted how many members, threads, and posts, those variables are already there. But I want to add Total PMs, Staff #, Threads/posts in 24 hours, without the having to look at a new page.

How would I do this?

[Jawelin]

Originally posted by Bane
I will look at that when I update. Not having a problem on my board, but you never know. I have to adjust the activity level setting anyway.. by default it should be a percentage.

The starting date is something you can include.. IE if you want {900093093 Hits since $startdate} on your page. :D
Sorry but it isn't too clear to me, yet:
1) WHERE could I (we) find a full complete reference of all usable variables in a template ?
2) Is there any syntax to that $startdate or it's only a displayed variable which doesn't affect actually the statistics reported (i.e. the starting date is when I installed this hack... ) ??
3) What's the total hits variable to show a line like your example above ?

Sorry but, as about the vbstats_forumhome template inclusion, all the instructions aren't absolutely too clear about this matter .

Thanks again.

Note: I only would use all the features of this great hack. Just it is... ;)

[Jawelin]

Excuse. I would need a graphical display of posts just like the one of the browser....
Simply cluster-stats for post number groups (for example, cluster like 0 post, 1-10, 11-50, 51-100, 101-250, 251-500, 501-1000, and so on...)
Do you think exists any hack to do this or it shouldn't be too difficult to add to this great project ??

Thanks again.

P.S.: see previuos post, too... :D

[Xelation]

Just installed it last night with absolutly NO problems!! This is an Excellent Hack Bane!! Keep it Up!!

[Bane]

1) WHERE could I (we) find a full complete reference of all usable variables in a template ?

There is none available at the current time. Though I did what some people even made fun of me for overcommenting, my documentation wasnt as complete as it needed to be for a project of this size. When I made it I had assumed a working knowledge of vb before implementation. This however is being outpaced with hacks being easier to install and people starting sooner and sooner with hacking their board to pieces.


2) Is there any syntax to that $startdate or it's only a displayed variable which doesn't affect actually the statistics reported (i.e. the starting date is when I installed this hack... ) ??

There is NO purpose to this apart from display purposes. You can put whatever you like. from "September 5th, 2001" to "09/05/2001" or even "When the flying monkeys last landed on my porch for a rest on the way to Florida" ... actually the last may not fit.. Thanks :)


3) What's the total hits variable to show a line like your example above ?

Umm.. ($total hits since $startdate!) would be the string but that will only work where it is declared. those two vars are both declared in the file.

Sorry but, as about the vbstats_forumhome template inclusion, all the instructions aren't absolutely too clear about this matter .

The biggest problem with this is all the actual changes sans adding the counter to phpinclude (which is there in plain lettering) are OPTIONAL. The documentation was rushed because I was recieving 5-10 emails daily asking about the status of the hack, etc..

I'm even trying to improve this now.. But I'm only one guy with a lot of projects on my hands.. I hope you can understand that.

With the next version of talkloud in progress and two or three clients en queue my time is fairly limited. Enough so that I'm not sure I will have a large amount of time to do proper justice to the next round of vbstats unless requested by a client (I dream of this :p) This is my baby.. Yes? But its a baby thats being taken care of and nurtured by users like FWC until I get back from work.

[LanciaStratos]

This may have already been reported, but there seems to be random differences (sometimes lower, sometimes higher) in the number of posts by the top posters (Ever) and the number of their posts listed in their profile... Is this a known issue? You can see this going on for yourself at http://forums.gtplanet.net/vbstats.php?action=topposters. Just click on a member's profile and you'll see a different number listed. :?:

[FWC]

Originally posted by Bane
This is my baby.. Yes? But its a baby thats being taken care of and nurtured by users like FWC until I get back from work. We're just trying to help out where we can. That gives you more time to take care of your projects rather than answer questions we can take care of. :)

[Ninth Dimension]

I have just installed this hack for a 3rd time, and I love it better each time I do, please, keep up the good work.

[ForKmaN]

Is there like a Fresh Zip to install this on 2.2.1?

Sorry if I missed it :o

[heynurse]

Killer Hack! I love it, just one question....

What is the determining factor of what make a user Active or Non-Active?

I searched, but couldn't find the answer ;)

Thanks

[Bane]

FWC - And I do appreciate it :)
danielhollands - Thanks :D
ForKmaN - Not just yet no.. :(
heynurse - If someone has posted or not.. Simple hehe.. btw, nice site, I sent it to a nurse friend of mine, I'm sure she will dig it as well.

[heynurse]

Bane,

Thanks for your clarification.....DOH! I thought it was that simple, but my stats show that only 50% of users are non-active (http://allnurses.com/forums/vbstats.php?s=&action=stats)

It just seemed weird that 8877 (>50%) users would register just to lurk and not post, So I doubted that it could be so simple :p

Glad you liked the site and thanks passing it on to your friend

[Twig Deez]

Originally posted by LanciaStratos
This may have already been reported, but there seems to be random differences (sometimes lower, sometimes higher) in the number of posts by the top posters (Ever) and the number of their posts listed in their profile... Is this a known issue? You can see this going on for yourself at http://forums.gtplanet.net/vbstats.php?action=topposters. Just click on a member's profile and you'll see a different number listed. :?:

this bothers me as well. i'm assuming vbstats is pulling the actual post numbers;
on my forums, i've given posts away in contests or whatever,
i've lowered post counts, increased them, all in the control panel.
i installed vbstats and it showed all my postcounts and top posters out of kilter too.

is there any easy way around this?

[KeithMcL]

OK, i'm lost. During the installation it says to find:Step 1 of 1 find:

<tr><td>
<table width="100%" border="0" cellspacing="0" cellpadding="2" id="navtable">
<?php maketableheader("Stats & Logs"); ?> in the admin/index.php and add some more code after it. However my admin/index.php does not contain the above HTML. The only part refering to the Stats & Logs I could find was:makenavselect("Statistics & Logs","<hr>",$df);. I'm using version 2.2.1

Where do I go from here?

[Sparkz]

You start at the beginning of this thread, reading until you find the instructions on what to change if you're running 2.2.1 :)

[Bane]

Originally posted by KeithMcL
OK, i'm lost. During the installation it says to find:. I'm using version 2.2.1

Where do I go from here?

Please be kind enough to check the second post of this thread. It just may contain the information you need.

As a note, for those upgrading to 2.2.2 don't forget to run the upgrade to reinstall your templates :D

[-=dm=-]

dear Bane Our country (Denmark) is still not working/showing up, any of the forums which are runing u r hack :(
I should tell this to our Queen:D
cmon how can I fix it?

[Bane]

DM, Im going to try to repair the country detection as soon as I am able (time willing) perhaps the queen could hand down a edict of some sort should the miracle pass and I get time to do anything. :( I will *try* to look at it in the next day or so, as well as at least upgrading the instructions for 2.2.2 ...

[Gutspiller]

There is something wrong with the top posters in this hack. Here is the top posters ever for my site using this hack:

http://www.theforumz.com/forumz/vbstats.php?action=topposters

Now here is the top posters that is just part of 2.0.3:

http://www.theforumz.com/forumz/memberlist.php?what=topposters&perpage=15

Why isn't your hack doing it right? :confused:

Also, how do I change the default font for this hack to something different?

I would really like to show the top posters for the Last 24 Hours on the front page. Is there a varaible that gets that info?

On the Members Referred page, I would like the reffered names small and aligned to the left, not centered. (Please help me with this one as it is really annoying)

Also I have another hack installed that in the regular whos online it puts the letters PM behind their name and allows you to PM that person that way. On your hack when it shows the people online, on the first person farthest to the left it shows a PM behind their name, but nobody else. What gives? :(

If you could help me with these problems, I would really really REALLY appreciate it. I love the hack so far, but I am having troubles customizing it and if somebody could help me I would greatly appreciate it.

Thanks. :(

[Bane]

Gutspiller, most of your customization can be done through the vbstats templates, just like every other part of vb. As far as the top posters, Im aware of the problem, just havent hit on a solution.

[Gutspiller]

Originally posted by Bane
Gutspiller, most of your customization can be done through the vbstats templates, just like every other part of vb. As far as the top posters, Im aware of the problem, just havent hit on a solution.

Maybe it's the way it executes the vbstats then, because I did a search for "Members Referred" Which should of taken me to about where I wanted to be, and yet I searched every new template, and all the php files I modified and couldn't find it. Did I miss it or do I need to search for something else in other files? :confused:

[Lionel]

I have been enjoying vbstats from day one. Yesterday I placed the following important code in my php include

ob_start();
require("/var/www/aboutus/textads/textad.php");
$textads = ob_get_contents();
ob_end_clean();

and vbstats stopped working with the following error:

Warning: Supplied argument is not a valid MySQL result resource in /var/www/haitianforums/vbstats.php on line 555
No Database Selected

The code that I placed is very useful and I need them both.

Any idea why this will conflict with vbstats? Once I remove it, vbstats works.

My entire php include looks like this:

include("vbs_counter.php");

// start - get online users (hack by firefly)
$datecut=time()-$cookietimeout;
$headerguests=$DB_site->query_first("SELECT COUNT(*) AS count FROM session WHERE userid=0 AND lastactivity>$datecut");
$headerusers=$DB_site->query_first("SELECT COUNT(DISTINCT(userid)) AS count FROM session WHERE session.userid>0 AND session.lastactivity>$datecut");
$headerguests=$headerguests[count];
$headerusers=$headerusers[count];
$headeronline=$headerguests+$headerusers;
// end - get online users (hack by firefly)

ob_start();
require("/var/www/aboutus/textads/textad.php");
$textads = ob_get_contents();
ob_end_clean();

[FWC]

Have you tried changing the order around? Put the vBStats include last and see what happens.

[Lionel]

I tried reversing the order.

[lifesourcerec]

Originally posted by Bane

I have opted not to modify any VB php files, so how do I add these domains to the exclude list?

Simply point your browser to your vb admin directory address and run the file vbstats_set.php?action=add


What are excluded domains anyhow?

Excluded domains are domains that are not counted as referrers. They wont show up in your referrer list or on the link queue.


I added my URL to the exclude list and it said updated, yet the stats still include my URL.

[FWC]

Originally posted by lifesourcerec


I added my URL to the exclude list and it said updated, yet the stats still include my URL. Your URL is already entered in the referrers table. You need to delete the entry with phpMyAdmin (or use a mySQL query if you don't have it).

[lifesourcerec]

Originally posted by FWC
Your URL is already entered in the referrers table. You need to delete the entry with phpMyAdmin (or use a mySQL query if you don't have it).

Ok, I removed it from the referrer table and left it in the excluded list. Thanks :) Now, I'm feeling better everyday on the $160 I spent for vBulletin.

[FWC]

Originally posted by lifesourcerec


Ok, I removed it from the referrer table and left it in the excluded list. Thanks :) Now, I'm feeling better everyday on the $160 I spent for vBulletin. Cool! Yes, it's a very well spent $160. :)

[Bane]

Lionel - Have you tried commenting one line at a time and seeing when vbStats kicks back on? which line is killing it I mean?

[Lionel]

Originally posted by Bane
Lionel - Have you tried commenting one line at a time and seeing when vbStats kicks back on? which line is killing it I mean?

no I have not.

Actually when I reverse the order, I get vbstats to display the following not when you invoke it, but it actually prints it in all headers.


Warning: Supplied argument is not a valid MySQL result resource in /var/www/haitianforums/vbs_counter.php on line 74

more info could be found in post# 3 here (https://vborg.vbsupport.ru/showthread.php?s=&postid=219660#post219660)

[Lionel]

I fixed it by hardcoding the path ./admin/config in global.php

[Graphic-Forums]

What could be the problem here:
http://www.dietsupporters.com/forums/vbstats.php

A ton of errors.
vb 2.2.2

[Gutspiller]

Originally posted by Graphic-Forums
What could be the problem here:
http://www.dietsupporters.com/forums/vbstats.php

A ton of errors.
vb 2.2.2

7. Be sure to add this line to your phpinclude template:

include("vbs_counter.php");

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

A lot of people miss that step because it's after it says to upload your files. :up:

[vTed]

Under 'browser' and 'operating system' , the 'other' and 'unknown' numbers seem to be increasing by as much as 600 a night (and i'm pretty sure these are not 'real' hits) with no other numbers increasing. Any ideas?
take a look http://flashping.com/forums/vbstats.php

is vb stats counting some other activity on my server?

[Gutspiller]

It could be something you missed in the hack. Most likely you will probably have to retrace your hacking steps and make sure you did everything. If everything checks out, I would think that either somebody has a browser that the system doesn't recognize or it's a bug with the detection software. :up:

[Jawelin]

Originally posted by Bane
When you installed windows and picked a country I suppose :D

I am going to rewrite the way it detects countries. I thought encoding would be much better but it seems a mess.
Great hack, Bane!!
I saw it's the first one on vb.org, more!!

Just an off-topic, I suppose.
How could I read from PHP the user's TIMEZONE, along with the country ??
I though could be an enhancement a new page with a list of all timezones (with all the 3-char identifiers) and statistics of per-zone users.
I wouldn't prefer not to trust the timezone value of the user-table (I saw it isn't often upgraded by the user itself)

Thanks a lot.
Bye

[Massiel]

How can I include the "member stats" in the main forum page on the welcome panel? Please help!

Thanks :)

[Sidd]

one stupid question since I am new to this.

I have installed it and it runs fine on 2.2.2 but I have to bookmark the exact URL for the vbstats. Can be accessed through admin control panel and if yes how?

thanks in advance

[Gutspiller]

Sidd: Scroll down to the very bottom in your admin CP

On the left, 5th catagory up it should be there like this:

vbStats
vbStats Config
View Public Statistics
Exclude vbStats URL

If not, you probably missed a step in the admin directory.

Massiel, what are you asking? Trying to include the actual stats on the main page? Sorta like what ubb does? Let me know, I might be able to figure it out, unless a more experianced hacker knows right off the bat. :up:

[Massiel]

Look at this site :D http://x-mencomics.com/xfan/forums/index.php?s=

He had the member stats on the main forum page. :)

Just wondering how they got there...

[Gutspiller]

Originally posted by Massiel
Look at this site :D http://x-mencomics.com/xfan/forums/index.php?s=

He had the member stats on the main forum page. :)

Just wondering how they got there...

Do a search here at vb for Total Threads, and the names of others you want and it should find them.

[floleb7]

i turn referrer on in my board, in vbstats index there is someone with 1 referrer ( http://forum.latriade.net/vbstats.php?s= )

but when you browse http://forum.latriade.net/vbstats.php?s=&action=memberrefer nothing is showing .

[Hamsh]

I have uploaded all the files and changed the phpinclude file, but when I run install_vbstats.php, all I get is a blank page.

Help!

[DannyITR]

Same here. All blank.

[DannyITR]

Got it!

All I did was put the files in the appropriate directories. It says where to put them in the .txt files that are inclluded in the DOCS directory. The blank page is probably a result of image files not being in the images folder.

Now...to try an install this sucker.

[Hamsh]

Should be: /forum/images/flags
and: /forum/images/stats
?

or did you put the gifs straight into the /forum/images directory?

[DannyITR]

That's right

forums/images/stats
forums/images/flags

Now my problem is that I can't find the code in index.php to change. I opened it in notepad and man, that file is a mess! I thought programmers are supposed to make things readable by double spacing lines and indenting.

[DannyITR]

Why is everyone talking about a php include file? I didn't get any file like that in the download.

[DannyITR]

I'm now certain that the line it told me to find is not in my index.php file. The only line that resembles it is this one:

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

What do I do now?

[DannyITR]

Help!!

I modified the template file but now I get this error when I try to get into templates from the cp.

Parse error: parse error in /home/www/montrealracing/forums/admin/template.php on line 297

I took out the code I put in but it still gives me the error.

[DannyITR]

I reverted to my backup for the database that I made before starting the mess and I'm still getting an error! How can this be?? Please help me.

Can someone give me their origonal template.php file?

[Steve Machol]

Just reupload the original template.php from the zip file. It would be illegal for anyone to send you a copy of this file.

[DannyITR]

Thank you, that worked.

I still have the problem of not finding the required code in index.php.

Are you able to tell me why this may be or where I should look for it. Is the file suppoed to be one huge continuous mess?

[DannyITR]

You know what, I'll just live without the option hacks.

I have one question though: It doesn't give me the number of hit or page views. These are the most important stats. How come they are not there?

Also, I added the code to phpinclude but I still get the division by 0 error.

[Bane]

Danny, if you are running vb 2.2.2 there is a link to a set of instructions for that version in the 2nd post in this thread. phpinclude is not a file its a template. And if the division by zero error is there it is likely you havent added the line correctly. I would advise you to take a patient look at what you have done so far and make sure you have followed the instructions correctly.

[DannyITR]

I have fixed the divide by zero error. The template hack gives me errors but I don't want to push my luck.

What I need to know is where to find the total hits the forum is getting like it says in the first post. I see views but no unique visitors which is what really counts.

[Hamsh]

I have re-uploaded everything, done the hacks for 2.2.2 and added the include line to phpinclude, but I still get a blank page when I run install_vbstats.php. Any suggestions? What have I missed out?

Hamish

[Bane]

Hamsh: Are you running it from the vbulletin admin directory?

DannyITR: At the moment there is no tracking of unique :( I'm working on that.

[floleb7]

<a href="https://vborg.vbsupport.ru/showthread.php?postid=220948#post220948" target="_blank">https://vborg.vbsupport.ru/showt...948#post220948</a>

*bump*

[Bane]

floleb7 - umm.. is the referral system still on? I've never seen problems with them not showing unless the referrals were turned off somehow?

[floleb7]

the referral system is on i check in my admin and there is some referral

[Hamsh]

Bane:

No go, and I'm getting an eror message when I access the forum home page too:

Warning: Supplied argument is not a valid MySQL result resource in /usr/home/www/kendo/kendo-world.com/docs/forum/vbs_counter.php on line 74

http://www.kendo-world.com/forum/admin/install_vbstats.php

[ExcErr]

Hello!
Can you give decision for my probelm!!!
I've setup vbstat to my forum vb 2.2.2.
All is good, everything is fine, but one troubles... When I'm trying to open referals sites, it's writing me: NO SITES!!! Why so???
I have no VBPortal.... I just have the VBForum...

PLEASE HELP ME!!!

[Bane]

Hamsh: Why are you running some files with php3 and some with php? Are you required to use php3 extensions?

ExcErr: It's possible no sites have sent hits to your site. Can we have a link to the site to try it out?

[Hamsh]

No I'm not required to use them, I've just left them as is when I installed the various scripts, etc. Could that be causing the problem?

[JBMoney]

I'm having a problem with the 24-hour thread count too. I currently have this.

New Threads: 499 | New Posts: 145 | Views: 1,691

Kind of hard to have more new threads than posts.

I've watched the number since installation (about 18 hours) and it moves occassionally, but stays around that 500 mark. I think the post count is accurate.

I have read through this entire thread and didn't find anything helpful. I saw the item about adding one line to the index.php, but the line you said it should be placed after doesn't exist.

Any help?

[mvigod]

Is there a way to exclude moderators (or certain users) fro the top posters part of the stats...my moderators all have more posts than the userbase at large so it shows only them...can I exclude them somehow?

[cavola]

HELP!!!! What have i done?! I was installing vbStats on a 2.2.2 server... when i got to step 5 of install... i was editing the php files but using the vB2 changes.. then when i click on move to next step after editing files.. it came up with error 404.. NOW my site... www.cavola.com is not workin! i cant log into admin or anything! OMG! OMG! :eek: :eek:

[Bane]

cavola - Check your edited files again, you appear to have made an error. What is the error it's giving you?

mvigod - I will look at this, It's actually a good idea.

JBMoney - I don't think the edit is for 2.2.2 I will check again later to see, for now try putting the line one line before the other edits you made.

Sorry these answers aren't more in depth, I'm on my way to the airport.

[cavola]

EVERY SINGLE PAGE!!!

"There seems to have been a slight problem with the database.
Please try again by pressing the refresh button in your browser.

An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.

We apologise for any inconvenience."

I cant loggin to admin... i cant run repair.php... i cant run nuttin!! :eek:

[Bane]

Cavola, You need to tell me what is in the email you are getting. I can't help you if I don't even know what the error is.

[JBMoney]

I'm at a loss on the 24-hour thread issue:

Where exactly should I put this and in what file, index.php or admin/index.php?:

$tltoday=time()-(86400);

Or should I be doing something else?

[Bane]

Try putting that in your root/index.php just before the modifications you made for the forumhome.

[JBMoney]

I'm sorry for being a pain, but I guess my problem is that I don't see what changes were made to the root index.php.

I can clearly see the changes made to admin/index.php but I don't see any changes to the root index.php. At least none that are marked and none that are in the documentation.

[Bane]

I'm sorry, I assumed you were trying to do the forumhome additions, since thats the only area where that string is missing. are you saying that the 24 hours in your vbstats is messed up, not having a problem with forumhome?

[JBMoney]

Yes. Sorry, I thought I made that clear.

I don't have anything stats related on the home page except a link to the stats page. On the stats page I get this...

Last 24 Hours:
New Threads: 495 | New Posts: 191 | Views: 6,535


The new threads is always around 495, when clearly there wouldn't be more threads than posts. Posts is about right, I *think*.

The stats are here if you wanted to look. Was converted about a week ago from UBB.

http://bushwhacked.net/forum/vbstats.php

[LanciaStratos]

Bane, great hack, but I'd like to bring your attention back to this post I made (I guess it got lost in the fray) regarding the incorrect post counts for members. You'll also notice "Twig Deez" is also having this problem, so it's not just me! :)

https://vborg.vbsupport.ru/showthread.php?postid=214597#post214597

[xug]

Hi Bane

I run your hack now for a few months and didn't see any problems, till yesterday.
I had two small problems with the country list, one I found back in the beginning of this thread about Sweden and El Salvador switch, the other problem I couldn't find in this hugh thread and maybe I have looked over it, but I see no recording in my list for Japan, I have a few japanese members and daily I have a visitor from Japan, my list doesn't show even 1 from Japan.

What could be the problem ?

[Bane]

LanciaStratos - as soon as I get to rewriting this I'm going to look at that, some people are having the problem, some aren't, so I am kinda at a loss as to what it is. Some folks said a problem with ubb importing etc.. but some people are having the problem that didnt port from ubb.

xug - after a couple months I can honestly say that my country encoding system sucks. I thought to be clever by having the countries found by using language encoding however its not working as well as I had planned. What I was really trying to do was avoid having the .com .net .org listed in the country list etc.. So this is fairly accurate but has some big holes. I am looking to redo the detection scheme but really want to do without all those [dot] areas. So likely I will try to run a dual system, to check and resolve the ip, if it shows a country use it, otherwise use encoding. This still wont be faultless but I really dont know any other ways.

[VolSports]

im gettin a Object expected error on every page....what could be the problem???

[Bane]

It could be expecting an object. Thats just a guess though. :p Is there anything else to the message?

[JBMoney]

No receommendations on my issue?

[Bane]

JB you may have to wait just a while, Im gonna look this over tonight, my niece is on her way into the world sometime today so :p I will look at it though.

[lifesourcerec]

Originally posted by DannyITR
I'm now certain that the line it told me to find is not in my index.php file. The only line that resembles it is this one:


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

What do I do now?

Yep. I skipped that step. I got it installed, but the addon_forumhome didn't do anything. Seems the instructions are incomplete (especially for us newbies). ;)

[VolSports]

ok, i fixed the error but now for some reason i cant see all the referals.....when i click the link the page comes up blank.....and i remember there being a few links at the bottom of the page, and i kno i didnt touch them, but they aint there....i even re-uploaded vbstats.php

Any Ideas Any One?

[VolSports]

And How Do I Add The Stats That I Do Have To The Forum Page?

[ZiRu$]

i get this error

Warning: Division by zero in /home/blazing/public_html/vbstats.php on line 159

Warning: Division by zero in /home/blazing/public_html/vbstats.php on line 165

Warning: Division by zero in /home/blazing/public_html/vbstats.php on line 162

Warning: Division by zero in /home/blazing/public_html/vbstats.php on line 186

Warning: Division by zero in /home/blazing/public_html/vbstats.php on line 148

Warning: Division by zero in /home/blazing/public_html/vbstats.php on line 139

Warning: Division by zero in /home/blazing/public_html/vbstats.php on line 145

Warning: Division by zero in /home/blazing/public_html/vbstats.php on line 142

Warning: Division by zero in /home/blazing/public_html/vbstats.php on line 136

Warning: Division by zero in /home/blazing/public_html/vbstats.php on line 151

Warning: Division by zero in /home/blazing/public_html/vbstats.php on line 154

Can ii get some help please!

By the way it does show the stats but this is above the stats

[ZiRu$]

bump

please help

[trilOByte]

I know the division by 0 error is one that is common with this hack. I also know the solution is simple and is posted in this thread somewhere.

Unfortunately, it's a big thread - sorry, but it's here if ya dig for it.

[cditty]

Hello all. Just finished installing this and when I include the vbs_counter.php in the phpincludes template, I get the following errors on my pages.


Warning: MySQL Connection Failed: Access denied for user: 'apache@localhost' (Using password: NO) in /home/httpd/html/sweeps/forum/vbs_counter.php3 on line 47

Warning: MySQL: A link to the server could not be established in /home/httpd/html/sweeps/forum/vbs_counter.php3 on line 47

Warning: MySQL Connection Failed: Access denied for user: 'apache@localhost' (Using password: NO) in /home/httpd/html/sweeps/forum/vbs_counter.php3 on line 60

Warning: MySQL: A link to the server could not be established in /home/httpd/html/sweeps/forum/vbs_counter.php3 on line 60

Warning: MySQL Connection Failed: Access denied for user: 'apache@localhost' (Using password: NO) in /home/httpd/html/sweeps/forum/vbs_counter.php3 on line 61

Warning: MySQL: A link to the server could not be established in /home/httpd/html/sweeps/forum/vbs_counter.php3 on line 61

Warning: MySQL Connection Failed: Access denied for user: 'apache@localhost' (Using password: NO) in /home/httpd/html/sweeps/forum/vbs_counter.php3 on line 73

Warning: MySQL: A link to the server could not be established in /home/httpd/html/sweeps/forum/vbs_counter.php3 on line 73

Warning: Supplied argument is not a valid MySQL result resource in /home/httpd/html/sweeps/forum/vbs_counter.php3 on line 74

Warning: MySQL Connection Failed: Access denied for user: 'apache@localhost' (Using password: NO) in /home/httpd/html/sweeps/forum/vbs_counter.php3 on line 79

Warning: MySQL: A link to the server could not be established in /home/httpd/html/sweeps/forum/vbs_counter.php3 on line 79

Warning: MySQL Connection Failed: Access denied for user: 'apache@localhost' (Using password: NO) in /home/httpd/html/sweeps/forum/vbs_counter.php3 on line 89

Warning: MySQL: A link to the server could not be established in /home/httpd/html/sweeps/forum/vbs_counter.php3 on line 89




Any ideas?

Chris

[Bane]

The cure for the division by zero problem is in the second post of this thread :rolleyes: :p

cditty - It seems like the mysql_query command isn't working for you. If you havent fixed this by tonight let me know in a PM and maybe I can post an updated counter.

[cditty]

Bane, I have no idea what is happening with this one. My forum and the rest of the site is run from mysql_query and they are working fine.

I'll send you a pm also.

Chris

Originally posted by Bane
The cure for the division by zero problem is in the second post of this thread :rolleyes: :p

cditty - It seems like the mysql_query command isn't working for you. If you havent fixed this by tonight let me know in a PM and maybe I can post an updated counter.

[ZiRu$]

thanks trilOByte and bane

Problem solved

[wooolF[RM]]

By the way... I have been looking on many forums that have stats... And I found a lil "bug"... Maybe it's not a bug... But U miss one country : Denmark... There are a lot of users come to mine forum from DK, I know many of them, but Stats says that there are NO one from Denmark...

Any explanations?

PS: I don't need any updates or bug fixes or ask u to fix it or even beg u to look at this problem (specially for nakkid). Do with this whatever u want.

Have a nice day.

[Saiyan XL]

this is a very nice hack!!

[Bane]

wooolF[RM] - As is noted throughout the thread this is being looked at. The country detection is off a bit since it uses language encoding.

cditty - I'm sorry, I forgot about you man, I have been doing client work all day. :( I'll work on this as soon as I'm done setting up this server.

Saiyan XL - Thanks :D

[Dalius]

damn e-mail! stop e-mailing me! argggg!

[N!ck]

this is nice, but seems like it would use up a lot of space - about how much; does anyone know?

[Bane]

Just wanted to say hi to Dalius! :) Hey man! Been a while since I've seen you over on talkloud. Thought I would give you an email!

nicksaunders - you mean the files or the mySQL database? The files all told are fairly small. the flag graphics are most of the space.

[Jawelin]

Originally posted by Jawelin

Great hack, Bane!!
I saw it's the first one on vb.org, more!!

Just an off-topic, I suppose.
How could I read from PHP the user's TIMEZONE, along with the country ??
I though could be an enhancement a new page with a list of all timezones (with all the 3-char identifiers) and statistics of per-zone users.
I wouldn't prefer not to trust the timezone value of the user-table (I saw it isn't often upgraded by the user itself)

Thanks a lot.
Bye
What about a way to read TZ from the user's browser parameters ?
Thanks

[Bane]

That would be a neat addition but I'm not sure if that is in the browser info. Not sure how it could detect that.

[cditty]

Bane, any idea on my problem yet?

Chris

[Bane]

I'm going to go through and use the vbulletin connection method and we can see if that works chris.. Gimme a few.

[Bane]

argggh.. unfortunately ventures has chosen this time to put my test server out of commission. It may be a wee longer wait.

[cditty]

K

[cditty]

Bane, since you are connecting the non-vb way, would it help if I put the mysql_connect in the top of your code? What affect would that have on the rest of the forums?

I'm at work right now so I can't test right this minute.

Chris

[Bane]

I'm not sure.. all I am going to do is try making the mysql_connects go the same way as the rest of vb.

$DB_site->query

and see if that works right.

[cditty]

BINGO!!!! It's working with that now. Thanks for the idea.

[Bane]

=) w00t

[cditty]

Question....How do you determine the number of browsers that are used and the number of page views? Are these just incremental counters? I watched mine for a minute or two by simply refreshing the screen and noticed that they are incrementing rather quickly. As much as I would like my board to be this poplar, I don't think it really is.

Just curious.

Chris

[N!ck]

bane - it's the mysql space i'm concerned about (re: post #682)

[Flipsidejones]

After the update for 2.2.3, vbstats.php started returning a blank page. How can i get this working again?

[FWC]

Originally posted by Flipsidejones
After the update for 2.2.3, vbstats.php started returning a blank page. How can i get this working again? Run the installer and select update. You lost some of your templates.

[Me2Be]

Originally posted by FWC
Run the installer and select update. You lost some of your templates. I just installed this on my 2.2.3 for the first time and I am also getting a blank page --

Can you tell me what templates I SHOULD have in there so I can see if they installed correctly?

[Bane]

There should be a series of vbstats_**** templates.

[Me2Be]

Originally posted by Bane
There should be a series of vbstats_**** templates. I DO have about 17 of those (but still a while page).

Any suggestions to look for to get this working? (I just installed it tonight on the 2.2.3b version)

Thanks for your help :)

[Bane]

Oh! Yes :) Make sure you have the language file and counter in place correctly? Most of the time its a language file path out of whack that makes the white page.

[lifesourcerec]

I'm having trouble adding it to Admin CP. Can't find the code it asks for when installing it.

[FWC]

Originally posted by lifesourcerec
I'm having trouble adding it to Admin CP. Can't find the code it asks for when installing it. Find:makenavselect("Statistics & Logs",$df);
//***Place the following right underneath it:// 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

[lifesourcerec]

Thanks a million :)

[Xelation]

Has this been tested on 2.2.4?

[Xelation]

well, I was testing it out on 2.2.4 and in the admin/index.php I cant find this...


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


any help?

[Recon_Boy]

Well it works with my board on 2.2.4, but I upgraded...

[Recon_Boy]

Is this the part where it asks you to add the options on the left of the admin control panel? If so, you can pretty much stick that anywhere in the existing 'menu' list imho...dunno for sure tho

[Xelation]

can I see your admin/index.php file so I know where to put it?

[Recon_Boy]

I put mine right at the top:

<center><a href="index.php?s=<?php echo $session[sessionhash]; ?>&action=home"> Control Panel Home </a></center>
<table width="100%" border="0" cellspacing="0" cellpadding="<?php echo iif($cpnavjs,2,5); ?>" id="navtable">

<!-- vbStats -->
<tr><td><hr></td></tr>

<tr><td>
<table width="100%" border="0" cellspacing="0" cellpadding="2" id="navtable">
<tr class='tblhead'><td colspan='2'><a name=""><font size='1'><b><span class='tblhead'>vbStats</span></b></font></a></td></tr></table>
<a href="vbstats_set.php"> vbStats Config </a><br>
<a href="../vbstats.php"> View Public Statistics </a><br>
<a href="vbstats_set.php?action=add"> Exclude vbStats URL </a><br>
</td></tr>
<!-- vbStats -->

<tr><td><hr></td></tr>
<?php
// *************************************************
makenavoption("vBulletin Options","options.php?t=0","<br>");
if($debug==1) {
makenavoption("Edit Settings","setting.php?action=modify","<br>");
makenavoption("Add Setting","setting.php?action=add","<br>");
makenavoption("Add Setting Group","setting.php?action=addgroup");
}
makenavselect("Options","<hr>");
// *************************************************
makenavoption("Add","announcement.php?action=add","|");
makenavoption("Modify","announcement.php?action=modify");
makenavselect("Announcements");
// ***
makenavoption("Add","forum.php?action=add","|");
makenavoption("Modify","forum.php?action=modify","<br>");
makenavoption("Permissions","forumpermission.php?action=modify");
makenavselect("Forums & Moderators");
// ***

[Recon_Boy]

keep in mind, i may have an old version of this hack

[Xelation]

thx! youve been a big help! ;)

[Recon_Boy]

about time I gave something back! :)

[Xelation]

Originally posted by Recon_Boy
about time I gave something back! :)

yup, and it worked perfectly! ;)

[Bane]

Should work great on all 2.2.x versions with the code changes listed in the thread. and those are all cp and whos online stuff..

[HTP]

I'm getting errors after I install it:

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

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

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

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

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

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

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

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

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

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

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

What did I do wrong?

[Bane]

Please refer to the second post of this thread. For frequent problems such as this one.

Make sure you have included the counter in the phpinclude file.

[David Bott]

Greetings...

Seeing the very large size of this thread..Please forgive this this has been asked....

1) Does the currently posted download (zip) support 2.2.4 without having to go though this entire thread to find all the changes needed?

2) Seeing we are a VERY large VB site...What effect on the server would I expect to see by installing this wonderful software? (Avg users during peek time is 800 on-line.)

Thank you for your time.

David Bott
AVS Forum
http://www.avsforum.com

[wooolF[RM]]

damn... that's kinda many... I hope your users have the ability to choose another color scheme, doesn't they?

[Bane]

David, The current download does not, but you will find a link in the second post of this thread to the mods needed.

[David Bott]

wooolF[RM]....LOL - Yes, then can choose the Origional VB colors. But if I look, most use the default.

Bane...Too bad to read that. So, I guess I will need to play around but have this large fear based on the user load I have.

[Bane]

Well, the hack itself only requires one hack to work, thats putting the counter in the phpinclude template. The rest is gravy.

Adding vbstatsCP to the AdminCP (you can run this from the file instead)
Adding vbstats to whos online
Grouping vbstats templates in the template modify.

So really all you need to do is run the install and add the counter.

You can do the config by using http://your-site.com/forums/admin/vbstats_set.php and the excludes by pointing to http://your-site.com/forums/admin/vbstats_set.php?action=exclude

[Bane]

As a quick fix here is a txt file with the needed hacks for the full install, these should work for 2.2.4 with no problems.

Simply do these instead of the hacks listed in the installer. This was intended to be an install.txt so the instructions should be complete.

Removed attachment

[freehtml]

It works for me, I am using vB 2.2.4

Take a look (http://forums.sanguo-online.com/vbstats.php)

[Bane]

freehtml - I think I mentioned before I love your boards topic no? I want new games in the states! *sulks*

[thehobbyforum]

I'm not for sure if this has been brought up before or not - my referals all point to my start (vbportal) page and not the forum - is there any way to get the referals to reflect hits sent to the home (vbportal) page???

[Bane]

You have to hack the header.php file to point to the vbstats header instead of the php-nuke one.

[thehobbyforum]

I'm not very computer literate but I'm trying to learn - can you be a little more specific - sorry

[Bane]

open header.php and find "counter.php" try changing that to "vbs_counter.php" and then upload the vbs_counter.php file to your vbportal directory.

I dont have a copy of it right now so being anymore specific is difficult, I'm sorry :(

[thehobbyforum]

OK i just deleted all the other site referers from the db and changed what you said - i will monitor it throughout the day and then let you know what heppens - thanks for the help!!

John
http://www.thehobbyforum.com

[Bane]

np john

good luck :)

[thehobbyforum]

When I go to the vBPortal admin page and then view httpreferers it shows me that http://www.aerc.biz is the #1 referer but when I go to the vBStata referer page it shows me something different. I will wait until tomorrow to see for sure but my initial idea is that it is probably still not pointing to the right page.

[dgessler]

What the hell? I can't install it on 2.2.4, online.php, the file I have to edit, I can't find the sections to add the code under/above. I basically installed the hack, just need to edit the files.. what am I doing wrong?

Thanks,
Dan

[FWC]

Originally posted by dgessler
What the hell? I can't install it on 2.2.4, online.php, the file I have to edit, I can't find the sections to add the code under/above. I basically installed the hack, just need to edit the files.. what am I doing wrong?

Thanks,
Dan Add Firefly's killer Add Who's Online Locations from the Admin CP and you don't need to hardcode the loation in online.php.

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

[Bane]

Try this file

[dgessler]

bane - your directiosn dont apply for version 2.2.4..

nevermind, that actual stat program is working, and that's all I care about, thanks :)

[FWC]

Originally posted by dgessler
bane - your directiosn dont apply for version 2.2.4..

nevermind, that actual stat program is working, and that's all I care about, thanks :) What doesn't apply to 2.2.4? They will work fine.

[dgessler]

For example when I try editing admin/index.php, to add the extra lines of code, I search the document and can't find what I need to find.. even with that updated txt file.

[Webmasta XT]

okay i installed it on my vbb 2.2.4 and it gives a error on line 74
http://www.xtreme-forumz.cc/vbs_counter.php look.. how do i fix it? (please?)

[Bane]

Webmasta: Why are you running the counter itself?

[FWC]

Originally posted by dgessler
For example when I try editing admin/index.php, to add the extra lines of code, I search the document and can't find what I need to find.. even with that updated txt file. Well, it's there. I'm not sure why you are having trouble finding it. Try looking for:makenavselect("Statistics & Logs"

[Webmasta XT]

Originally posted by Bane
Webmasta: Why are you running the counter itself?
well i tought it is supose to work..? do i have to leave it like this?

[Bane]

You dont run the counter though, you include it.. it gives you the same error?

[HellRazor]

Bane, I just installed the AddonForumHome hack, but nothing has changed on my index page. I also added the template vbstats_forumhome to my custom templates.

Any idea what might be wrong?

[Webmasta XT]

i did the same but nothing is apearing?
and if i include it it shows nothing no errors or something..

[Bane]

Webmasta: If its included and not showing any errors then its working correctly. Is it logging?

HellRazor : Did you add $vbstats in the forumhome template?

[HellRazor]

Bane, that was the problem, I must have missed that. Thanks for your help!

[HellRazor]

Also, one question... would it be possible to add a section to VBStats that would show what resolution people were using? That would be useful!

[UltimaKing]

argh, I STILL can't figure out how to exclude my url >_< Please reply as quickly as possible

[FWC]

Originally posted by UltimaKing
argh, I STILL can't figure out how to exclude my url >_< Please reply as quickly as possible Go to the Exclude URL link in your Admin CP and enter your domain without the www. Then use phpMyAdmin to delete your domain from the vbstats_referrer table.

[UltimaKing]

I must be blind, because I can't see the link anywhere =/ I'm sorry.