vB3 Boardstatistic Version 2

[Zelda-King]

Hmm, how does this look to you? On 600x800 resolution those tables are suddenly wide for me. - http://www.gamercrossfire.net/bb/statistik.php?do=countries (This is having just run that country table fix.)

[oldfan]

Parse error: parse error in /xxxxx/xxxx/xxxxx/xxxx/admincp/install_statistik_english.php on line 340

lol

[oldfan]

nevermind
* oldfan clicks install
thanks again Onkel_Tom'
All I need now is some dark background .gifs :p
Thanks

[Onkel_Tom]

Hmm, how does this look to you? On 600x800 resolution those tables are suddenly wide for me. - http://www.gamercrossfire.net/bb/statistik.php?do=countries (This is having just run that country table fix.)

Perhaps you have to shorten the name of "United Kingdom Academic Institutions" to short your table width

[Stormwolf]

here is the dump of the fixed country table for phpmyadmin.


Worked like a charm thanks, My operating systems are not showing, do you have a working table for that part, if so could you share a similar table dump for that?

[Zelda-King]

Perhaps you have to shorten the name of "United Kingdom Academic Institutions" to short your table widthHmm, that wasn't a problem before. I reckon it's to do with that 'display dynamical' which I don't think is really needed anyway.

Edit: Yeah, removing that did the trick. It also showed me something I missed so I've changed a sentence in the statistic_spider template:

$statistic_header
<!-- Spider Anzeige Start -->
<table class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%" align="center">
<tr>
<td class="tcat" colspan="2"><div align="center"><strong>Spiders and Searchrobots</strong></div></td>
</tr>
<tr>
<td valign="top" class="panelsurround">
<div class="panel">
<fieldset class="fieldset">
<legend><strong>Spiders</strong> ($wieviele_spider of known 93 varieties) <font color="#FF0000"> </font></legend>
<table width="95%" border="0" align="center">
<tr>
<td>&nbsp;</td>
</tr>
$statistic_bots_bit
</table>

</fieldset>

</div>
</td>

<td valign="top" class="panelsurround">
<div class="panel">
<fieldset class="fieldset">
<legend><strong>Searchrobots Summary</strong></legend>
<table width="95%" border="0" align="center">
<tr>
<td>$totalspider ($totalspider_in_prozent %) counted Spiders since statistics started.</td>
</tr>
</table>
</fieldset>
</div>
</td>
</tr>
<tr>
<td class="tcat" colspan="2">&nbsp;</td>
</tr>
</table>
<!-- Spider Anzeige Ende -->
$statistic_footer

So it says "Spiders (4 of known 93 varieties)"

[Onkel_Tom]

Also, found another bug.

When you click Top 10 posters, it displays their homepage url. When you click on the homepage url, it gives you the "page not found" error.

What is displayed in the browser upon clicking it is:

See for yourself here: http://www.ez-company.net/forums/statistik.php

to fix it:
open template "statistic_top_poster_bit" and search for:
<a onclick="window.open(\'goto.php?goto=$poster_homepage\')


replace it with:
<a onclick="window.open(\'$poster_homepage\')

[Onkel_Tom]

new zip file with all updates right now !
the only thing missing at the moment is the compare of all countries in database table in conjuction with image name of flag and identification listing in file functions_statistic.php

LAST UPDATE of Zip File: August, 25th 04:30pm

[Onkel_Tom]

Worked like a charm thanks, My operating systems are not showing, do you have a working table for that part, if so could you share a similar table dump for that?

Did you install the latest version ?
The tables are okay for the browser identification.

here is the requested export of this table

[PcFreak]

Thank you at Onkel_Tom for the super support.

In the first post of this Thread i have update this hack, with Onkel_Tom´s zip.file. All credits go to him.

PcFreak

[Onkel_Tom]

Thank youuuuuuu PcFreak for that great hack !
It's a pleasure for me to support this hack, you're welcome PCFreak

[Zelda-King]

Just to confirm my El Salvador flag is working properly now.

[weitalia]

i start to phrase this hack, is the update already phrased?

[Onkel_Tom]

i start to phrase this hack, is the update already phrased?
No, there are no phrases right now.
To have a phrased hack would be very helpfull for translation in other languages.
If you will do that it would be great to share your work so we can update also the hack with phrases https://vborg.vbsupport.ru/external/2004/08/1.gif

[SnowBot]

Can you supply proper upgrade instructions? For some people comparing files is hard so maybe you could write some upgrade instructions for us so we know what to change to what, please.

Snowy

[Onkel_Tom]

Can you supply proper upgrade instructions? For some people comparing files is hard so maybe you could write some upgrade instructions for us so we know what to change to what, please.

Snowy

Hmmm, to supply a proper upgrade instruction would be very hard work because we changed in the meanwhile all 36 Templates and also the information in table statistic_laender.
With the wrong information in this table it would be better to do a complete reinstall of the hack because your data shown in Country stats is wrong.

Today I get an answer from PcFreak about the uninstalltion script but he mentioned that he is to busy to do that, so I decided to code this script tonight on my own ;)
At the moment this script is a independed script and can be uploaded and executed on the server. Next version will be integrated in the installation script and also in future an upgrade code in this script to make it easier for you.

Since PcFreak has updates the first post in this thread with my version from today I will now release updates for that version until a major change is neccesarry.

Updates for today:

- Fix for wrong referer count in file statistik.php:
- Arcade Games add on in file statistik.php
- Arcade Games add on hack
- Uninstalltion Script

Attached you will find the updates files which should be copied to your forums installation. The uninstallation script should be copied to your admincp directory only if you want to uninstall !

Only 4 days left to reach Hack of the Month... vote for us ;)

[oldfan]

c00, I'll add these too :)

[SnowBot]

AHH!! Great an uninstaller is cool, THANKS for the great work you have put in on this.

[oldfan]

/me voted

[Razz]

Onkel Tom, thanks for all the recent fixes :)

Do you know what causes the stats page to be too wide when using a fixed width board? This even happens when the stats are not big enough to stretch the page.

[Onkel_Tom]

Onkel Tom, thanks for all the recent fixes :)

Do you know what causes the stats page to be too wide when using a fixed width board? This even happens when the stats are not big enough to stretch the page.

I had also problems with the size of the statistic window. Try to replace the template statistic_header with this code:


$stylevar[htmldoctype]
<html dir="$stylevar[textdirection]" lang="$stylevar[languagecode]">
<head>
<!-- no cache headers -->
<meta http-equiv="Pragma" content="no-cache" />
<meta http-equiv="Expires" content="-1" />
<meta http-equiv="Cache-Control" content="no-cache" />
<meta name="author" content="PcFreak" />
<meta name="Keywords" content="Statistics" />
<meta name="Description" content="Statistics for vBulletin 3.0.x" />
<!-- end no cache headers -->
<title>$vboptions[bbtitle] - Forenstatistik ?bersicht</title>
$headinclude
</head>
<body>
$header
$navbar
$statistic_menue
<br />

This fixes my size problem ;)

[Onkel_Tom]

Hi again,
Today I fixed some template cache lines with a dot instead a comma at the end, and additional 2 instances of missing escaped apostrophe in db queries for usernames (=> db error).

just download the updated statistik.php file and replace the old one.

[Razz]

I had also problems with the size of the statistic window. Try to replace the template statistic_header with this code:


$stylevar[htmldoctype]
<html dir="$stylevar[textdirection]" lang="$stylevar[languagecode]">
<head>
<!-- no cache headers -->
<meta http-equiv="Pragma" content="no-cache" />
<meta http-equiv="Expires" content="-1" />
<meta http-equiv="Cache-Control" content="no-cache" />
<meta name="author" content="PcFreak" />
<meta name="Keywords" content="Statistics" />
<meta name="Description" content="Statistics for vBulletin 3.0.x" />
<!-- end no cache headers -->
<title>$vboptions[bbtitle] - Forenstatistik ?bersicht</title>
$headinclude
</head>
<body>
$header
$navbar
$statistic_menue
<br />

This fixes my size problem ;)

Perfect, thanks :)

[Darax The Good]

installed, thanks, I love looking at numbers and I didn't feel like writing a bunch o'queries.

[PcFreak]

I have updated the zip.file with Onkel_Toms modified code in the first post of this thread.

@all
I have closed the at-lantis board now.
For the moment it is no longer possible show a demo on my side.
But i plan a Version 3 of this hack.

PcFreak

[Zelda-King]

The flag link for Grenada: images/statistik/flaggen/grenada

It needs .gif putting on the end.

[oldfan]

Thanks, can't wait :)

I have updated the zip.file with Onkel_Toms modified code in the first post of this thread.

@all
I have closed the at-lantis board now.
For the moment it is no longer possible show a demo on my side.
But i plan a Version 3 of this hack.

PcFreak

[Onkel_Tom]

The flag link for Grenada: images/statistik/flaggen/grenada

It needs .gif putting on the end.

Also for:
- Gabon
- Georgia
- Djibouti
- Puerto Rico

Just put .gif at the end of this db entries for the flag in images/statistik/flaggen/

@ oldfan
Version 3 is only in planing ;)
For instance I work on Version 2, the spider part, to get more information about the spiders itself and also identify more spider. I found nearly 300 different spiders which can be identified, but therefore it's a lot of work t implement this spidern in the database and also put the additional data for the spiders in.
Also I found a lot of error in the actual spider identification of Version 2 with wrong useragent-names so please wait until my new release is ready ;)
This new spider identification will also be part of Version3

[Host Directory]

Great hack.. just installed.. works fine, no problems.

I click install

[Onkel_Tom]

Wow, 101 installations right now and also 71 clicks for the Hack of the Month August !
Thanks to all Users ;)

[Symbian.info]

Wow, 101 installations right now and also 71 clicks for the Hack of the Month August !
Thanks to all Users ;)
Install it! Love it! Wait now for version 3!! Thanks neighbour!

But I have one problem! Templates are only installed in style 1 !! :ermm:
How can I have it also in the other templates??? (noway I do it by hand !!)

[Host Directory]

Which bit of code do i need to change to add new search engine spiders graphics to the stats? I found a web stats program on google that has 111 search engine spider icons that i would like to use.

[PcFreak]

Which bit of code do i need to change to add new search engine spiders graphics to the stats? I found a web stats program on google that has 111 search engine spider icons that i would like to use.
You can add new spiders in the functions_statistik.php.

Found this part:
//################################################## ##############################################
//### Spider Bots und Crawler Erkennung START im Moment 92 verschiedene
//################################################## ##############################################

To add a new Spider use this code:
elseif(ereg("newspider", $agent)) $c_bot = "NewSpider";

Now you must create a new field in the statistik_spider table for the new spider.

PcFreak

PS:
Can you post a link to the web stats program, please

[Onkel_Tom]

Which bit of code do i need to change to add new search engine spiders graphics to the stats? I found a web stats program on google that has 111 search engine spider icons that i would like to use.
You have to add your search engines to the database table statistic_spider in the same way as the existing entries.
you can use this code in phpmyadmin to add a search engine to the table:

INSERT INTO `statistik_spider` ( `ID` , `spidername` , `spider_link` , `balken_link` , `Zaehler` ) VALUES
('', 'Spidername1', 'images/statistik/spider/spidernamerflagname1.gif', 'images/statistik/bar1.gif'),
('', 'Spidername2', 'images/statistik/spider/spidernamerflagname2.gif', 'images/statistik/bar2.gif'),
('', 'Spidername3', 'images/statistik/spider/spidernamerflagname3.gif', 'images/statistik/bar3.gif');

just replace SpidernameX with your Spidername, spidernamerflagname3.gif with your filename of the flag image. look also at the end of the code and change barx.gif for each line starting at bar1.gif up to bar11.gif and then again from bar1.gif.

Pay attention on the last line is a ";" at the end not a comma !

after adding the entries into the table you should also edit your file functions_statistik in /includes directory:
findelseif(ereg("zyborg", $agent)) $c_bot ="WiseNu"; //WiseNu
and add after:
elseif(ereg("spider agent identification string", $agent)) $c_bot ="Spidername as written in database"; //your new Spidername

find out the spider agent identification strinf while searching on google for this spider and wrote in this string, Spidername as written in database should have the identical syntax as your entrie in db table for spidername.

that's all

I'm working on a spider indentification at the moment which is identifiying more spiders and gives also more information about the spiders. So if you can wait you get a better version in few days or weeks ;)
It's a very hard work to write all the information from several websites in the net in one database table, collect all information and change the code that it works.
I also optimized the identification routine from functions_statistik that the serverload is not to high while identify the spiders, also a lot of double entries and wrong spider agents will be fixed in this release.

It would be great if you can share the spider flags with us and I can implement these grafics in the new release ;)

[venomx]

I just installed this on 9/2 yet its showing I had one signup on 9/1???

http://www.discussionjunction.com/forums/statistik.php?do=last_x_days

[DWard]

There is an error in the code... Where you show the latest sticky threads on the bottom left of 'Polls / Stickys / Searchwords' the userid in the username link does not correspond to the username itself.

Can you do something about this?

[Onkel_Tom]

There is an error in the code... Where you show the latest sticky threads on the bottom left of 'Polls / Stickys / Searchwords' the userid in the username link does not correspond to the username itself.

Can you do something about this?

You are right my friend ! ;)
Search in Template statistic_sticky_bit for:
href="member.php?u=$autorid">$sticky_autor

and replace it with:
href="member.php?u=$sticky_autorid">$sticky_autor

and it works ;)

[DWard]

No worries, if theres any problems ill find em out and report bk :)

[MissKalunji]

No worries, if theres any problems ill find em out and report bk :)


Hey dward i ws wondering how do you make that pic signature?? is it a php code and image??? dat shows up how many users and things??

Mind telling me how u did it??

** Off topic but im just curious *** :nervous:

[Onkel_Tom]

Hey dward i ws wondering how do you make that pic signature?? is it a php code and image??? dat shows up how many users and things??

Mind telling me how u did it??

** Off topic but im just curious *** :nervous:

This picture is the output of another Hack called Signature Hack.
Pls. use the search function on this board to find the Hack in the database ;)

[DWard]

@MissKalunji: The signature image you see below my name is a hack I developed, you can find it by following the link I've provided below:

https://vborg.vbsupport.ru/showthread.php?t=65361

[DWard]

How long does it take to get all the country and spider statistics? Mine are stil 0%

[MissKalunji]

How long does it take to get all the country and spider statistics? Mine are stil 0%


Thank you :nervous:

After a day it should show up...

Did you put the counter php in ur phpinclude_start template??
dat could be your problem

[Onkel_Tom]

Also if you are using an older version of php the $_SERVER command could be a problem.
To verify it you can open the file /includes/functions_statistik.php and at the beginning near line 26 you'll find the line:
$agent = $_SERVER['HTTP_USER_AGENT'];

You can change that to the line before which should read:
$agent = getenv("HTTP_USER_AGENT");

But if your Browsers are still identified with the $_SERVER Command also search engines should be identified by this command !

[DWard]

Ive got one of the latest php versions

[venomx]

Thank you :nervous:

After a day it should show up...

Did you put the counter php in ur phpinclude_start template??
dat could be your problem

Thats where we was told to put it... Why would that be a prob?

[DWard]

Mmm that was the problem. For some reason the line in that template dissapeared :S

[venomx]

Was wondering because the way MissKalunji asked that it sounded as if we shouldnt put it there...

[MissKalunji]

Was wondering because the way MissKalunji asked that it sounded as if we shouldnt put it there...


No no i meant....if you forget to put it....
somethings wouldnt show up in the statistik.php

Mah bad

[venomx]

NP.. I still dont see how I installed my VB3 on 9/2 and installed this hack the same day yet have a registered member stat for 9/1 hehe

[DWard]

Can somebody make an updated version of the spiders list??

heres a good list:

Spider Identification Strings
===========================================
ABCdatos
Ahoy!
ia_archiver
AlkalineBOT
http://www.almaden.ibm.com/cs/crawler
EMC Spider
Anthill
Aport
Arachnophilia
Araneo
ArchitextSpider
arks/1.0
Ask Jeeves
ASpider
ATN_Worldwide
Atomz
AURESYS
BackRub
Baiduspider
bbot
Big Brother
BigmirSpider
Bjaaland
BlackWidow
Board Reader
BoardViewer
borg-bot
BSpider
CACTVS Chemistry Spider
Calif
Checkbot
ChristCrawler.com
www.cienciaficcion.net
CMC/0.01
combine
ComputingSite Robi/1.0
conceptbot
CoolBot
Cusco
CyberSpyder
DesertRealm.com
Deweb
Die Blinde Kuh
dienstspider
Digger/1.0 JDK/1.3.0
Digimarc WebReader
Digimarc CGIReader
DIIbot
grabber
DNAbot/1.0
DragonBot/1.0 libwww/5.0
DWCP/2.0
LWP::
EbiNess/0.01a
EIT-Link-Verifier-Robot/0.2
elfinbot
Emacs-w3/v[0-9\.]+
esther
Evliya Celebi
FAST Enterprise Crawler 6
FastCrawler
FelixIDE
ESIRover
fido
Fish-Search-Robot
Mozilla/4.0 (compatible: FDSE robot)
fouineur.9bit.qc.ca
Freecrawl
FunnelWeb
gammaSpider
gazz
gcreep
GetterroboPlus
GetURL.rexx
Gigabot
Girafabot
Golem
Googlebot
Mediapartners-Google
griffon
Gromit
http://grub.org
Gulper Web Bot
H?m?h?kki
havIndex
HeinrichderMiragoRobot
HenryTheMiragoRobot
HKU WWW Robot
Hometown
htdig
AITCSRobot
HTMLgobble
I Robot
iajaBot
IBM_Planetwide
IlTrovatore-Setaccio
image.kapsi.net
Mozilla 3.01 PBWF (Win95)
IncyWincy
Informant
InfoSeek Robot
Infoseek Sidewinder
InfoSpiders
INGRID
slurp@inktomi
inspectorwww
IAGENT
Internet Cruiser Robot
sharp-info-agent
InternetLinkAgent
Iron33
IsraeliSearch
JavaBee
JBot
JCrawler
JoBo
Jobot
JoeBot
jumpstation
Katipo
KDD-Explorer
KIT-Fireball
KO_Yappo_Robot
LabelGrab
larbin
legs
Linkidator
LinkScan Server
LinkWalker
Lockon
logo.gif crawler
Lycos
Magpie
marvin/infoseek
M/3.8
MediaFox
MerzScope
METASpider
MetaGer-LinkChecker
MindCrawler
UdmSearch
moget
MOMspider
Monster
Motor
MSNBOT
MuscatFerret
MwdSearch
NPBot
NEC-MeshExplorer
Nederland.zoek
NetCarta CyberPilot Pro
NetMechanic
NetScoop
newscan-online
NHSEWalker
Nomad
Gulliver
explorersearch
Occam
Openbot
Openfind
Orbsearch
PackRat
PageBoy
ParaSite
Patric
PEGASUS
PerlCrawler/1.0 Xavatoria/2.0
PGP-KA
Duppies
phpdig
PiltdownMan
Pimptrain's robot
Pioneer
PlumtreeWebAccessor
Poppi
gestaltIconoclast
PortalJuice.com
PortalBSpider
psbot
StackRambler
Raven
Resume Robot
Road Runner: ImageScape Robot
RHCS
Robbie
RoboCrawl
Robofox
Robot du CRIM 1.0a
Robozilla
Roverbot
RuLeS
SafetyNet Robot
Scooter
SearchNZ
searchprocess
Senrigan
SG-Scout
Shagseeker
Shai'Hulud
SimBot/1.0
ssearcher100
Site Valet
SiteTech-Rover
aWapClient
SLCrawler
Sleek Spider
ESISmartSpider
Snooper
Solbot
www.entireweb.com/speedy.html
SpiderBot
spiderline
SpiderMan
SpiderView
mouse.house
suke
suntek
Black Widow
Tarantula
tarspider
dlw3robot
TechBOT
Templeton
JubiiRobot
NorthStar
w3index
Peregrinator-Mathematics
TITAN
TitIn
TLSpider
turnitinbot
UCSD-Crawler
urlck
URL Spider Pro
Valkyrie
Verticrawl
Victoria
vision-search
Voyager
VWbot_K
W3M2
w3mir
w@pSpider
appie
CrawlPaper
root
WebMoose
WebBandit
WebCatcher
WebCopy
WebFetcher
weblayers
WebLinker
wlm
WebQuest
WebReaper
webs@recruit.co.jp
WOLP
webvac
webwalk
WebWalker
WebWatch
Wget
whatUseek_winona
Hazel's Ferret Web hopper
wired-digital-newsbot
zyborg
WWWC
WWWWanderer
TECOMAC-Crawler
XGET
cosmos
Yahoo! Slurp
Yahoo-VerticalCrawler
YahooFeedSeeker
Yandex



Spider Identification Description
===========================================
ABCdatos BotLink
Ahoy!
Alexa
Alkaline
Almaden Crawler
ananzi
Anthill
Aport
Arachnophilia
Araneo
ArchitextSpider
arks
AskJeeves
ASpider
ATN Worldwide
Atomz.com
AURESYS
BackRub
Baiduspider
BBot
Big Brother
Bigmir
Bjaaland
BlackWidow
BoardReader
BoardViewer
Borg-Bot
BSpider
CACTVS Chemistry
Calif
Checkbot
ChristCrawler.com
cIeNcIaFiCcIoN.nEt
CMC/0.01
Combine System
ComputingSite Robi/1.0
Conceptbot
CoolBot
Cusco
CyberSpyder
Desert Realm
DeWeb(c)
Die Blinde Kuh
DienstSpider
Digger
Digimarc MarcSpider
Digimarc Marcspider/CGI
Digital Integrity Robot
Direct Hit Grabber
DNAbot
DragonBot
DWCP (Dridus' Web Cataloging Project)
e-collector
EbiNess
EIT Link Verifier Robot
ELFINBOT
Emacs-w3 Search Engine
Esther
Evliya Celebi
FAST / AlltheWeb
FastCrawler
Felix IDE
FetchRover
fido
Fish search
Fluid Dynamics
Fouineur
Freecrawl
FunnelWeb
gammaSpider
gazz
GCreep
GetterroboPlus Puu
GetURL
Gigabot
Girafabot
Golem
Google
Google AdSense
Griffon
Gromit
Grub Client
Gulper Bot
H?m?h?kki
havIndex
HeinrichderMiragoRobot
HenryTheMiragoRobot
HKU WWW Octopus
Hometown
ht://Dig
HTML Index
HTMLgobble
I, Robot
iajaBot
IBM_Planetwide
IlTrovatore-Setaccio
image.kapsi.net
Imagelock
IncyWincy
Informant
InfoSeek Robot 1.0
Infoseek Sidewinder
InfoSpiders
Ingrid
Inktomi
Inspector Web
IntelliAgent
Internet Cruiser
Internet Shinchakubin
InternetLinkAgent
Iron33
Israeli-search
JavaBee
JBot
JCrawler
JoBo
Jobot
JoeBot
JumpStation
Katipo
KDD-Explorer
KIT-Fireball
KO_Yappo_Robot
LabelGrabber
larbin
legs
Link Validator
LinkScan
LinkWalker
Lockon
logo.gif
Lycos
Magpie
marvin/infoseek
Mattie
MediaFox
MerzScope
META
MetaGer
MindCrawler
mnoGoSearch
moget
MOMspider
Monster
Motor
MSNBot
Muscat Ferret
Mwd.Search
NameProtect
NEC-MeshExplorer
Nederland.zoek
NetCarta WebMap
NetMechanic
NetScoop
newscan-online
NHSE Web Forager
Nomad
Northern Light
nzexplorer
Occam
Openbot
Openfind data gatherer
Orb Search
Pack Rat
PageBoy
ParaSite
Patric
pegasus
PerlCrawler 1.0
PGP Key Agent
Phantom
PhpDig
PiltdownMan
Pimptrain.com's
Pioneer
PlumtreeWebAccessor
Poppi
Popular Iconoclast
Portal Juice
PortalB Spider
psbot
Rambler
Raven Search
Resume Robot
Road Runner: The ImageScape Robot
RoadHouse Crawling System
Robbie the Robot
RoboCrawl
RoboFox
Robot Francoroute
Robozilla
Roverbot
RuLeS
SafetyNet
Scooter
SearchNZ
SearchProcess
Senrigan
SG-Scout
ShagSeeker
Shai'Hulud
Simmany Robot Ver1.0
Site Searcher
Site Valet
SiteTech-Rover
Skymob.com
SLCrawler
Sleek
Smart Spider
Snooper
Solbot
Speedy Spider
SpiderBot
Spiderline Crawler
SpiderMan
SpiderView(tm)
spider_monkey
Suke
suntek search engine
TACH Black Widow
Tarantula
tarspider
Tcl W3 Robot
TechBOT
Templeton
The Jubii
The NorthStar Robot
The NWI Robot
The Peregrinator
TITAN
TitIn
TLSpider
Turnitin.com
UCSD Crawl
URL Check
URL Spider Pro
Valkyrie
Verticrawl
Victoria
vision-search
Voyager
VWbot
W3M2
w3mir
w@pSpider
Walhello appie
WallPaper
Web Core / Roots
Web Moose
WebBandit
WebCatcher
WebCopy
webfetcher
weblayers
WebLinker
Weblog Monitor
WebQuest
WebReaper
webs
WebStolperer
WebVac
webwalk
WebWalker
WebWatch
Wget
whatUseek Winona
Wild Ferret Web Hopper
Wired Digital
WiseNut
WWWC
WWWWanderer
X-Crawler
XGET
XYLEME Robot
Yahoo! Slurp
Yahoo-VerticalCrawler
YahooFeedSeeker
Yandex

[Onkel_Tom]

We are working on this for the new 3.0 version....

[ChurchMedia]

Great hack! I installed it and voted for it for HOTM. I'm sure you'll take the prize :). I'm really looking forward to the screen resolution detection feature. I'm really curious about what my visitors are using so I can format my site for the majority of visitors.

If it's an easy addition to the hack, I'd love to see the code.

Thanks again!!

[Onkel_Tom]

Great hack! I installed it and voted for it for HOTM. I'm sure you'll take the prize :). I'm really looking forward to the screen resolution detection feature. I'm really curious about what my visitors are using so I can format my site for the majority of visitors.

If it's an easy addition to the hack, I'd love to see the code.

Thanks again!!
As I know from PcFreak this feature is in beta state and will be finished in version 3.0 with other new functionatilties ;)
stay tuned we are working on this new release...

[Mellow]

Any ideas on this problem,

the December 31, 1969 date is a little confusing.

Thanks
Joe

[Onkel_Tom]

Any ideas on this problem,

the December 31, 1969 date is a little confusing.

Thanks
Joe

Hmm, we just read the date of the day where the most registrations were done out of the database with a query. So you must have this date in some profiles as registration date of this users...
Check this registration date in admincp while searching in member profiles for that registration date and change it to the right one ;)
Or use phpmyadmin to search and change the date.

[Mellow]

Hmm, we just read the date of the day where the most registrations were done out of the database with a query. So you must have this date in some profiles as registration date of this users...
Check this registration date in admincp while searching in member profiles for that registration date and change it to the right one ;)
Or use phpmyadmin to search and change the date.
When I display Join Date in the memberlist, the correct date and format displays.

What is the format of the date displayed in phpmyadmin? I have joindates that look like this 1077904800.

[Onkel_Tom]

This is unixdate format at is okay for the table date, we convert this string with the function vbdate in your configured vB Date settings and show this date.
I checked the query again and found no errors in it, we using the standard vB table "stats" to get this information.
Did you change your date format settings for your vB after some persons has registered to your board ?

[Mellow]

This is unixdate format at is okay for the table date, we convert this string with the function vbdate in your configured vB Date settings and show this date.
I checked the query again and found no errors in it, we using the standard vB table "stats" to get this information.
Did you change your date format settings for your vB after some persons has registered to your board ?

I don't believe I've ever changed the date format.

In the stats table there is an entry for 63 users with a dateline of 0. Does that help?

[Onkel_Tom]

I don't believe I've ever changed the date format.

In the stats table there is an entry for 63 users with a dateline of 0. Does that help?
Ahh, okay, that is your problem !
Unix date start it's counting on that date with 0, so just copy a dateline you want to that line in your table to fix this entry.
Or just remove this line from db table, I think this is the best solution because I don't think you get 63 registrations on one day ;)

[Mellow]

That did it. Thanks Tom!

[Onkel_Tom]

That did it. Thanks Tom!

you're welcome ;)

[venomx]

I found an error_log in /forums
Has a bunch of these from each day I have added this..
[11-Sep-2004 00:00:00] PHP Warning: gethostbyaddr(): Address is not a valid IPv4 or IPv6 address in /home/forum/public_html/forums/includes/functions_statistik.php on line 254

[WreckRman2]

I did a search but didn't find anything on this problem so I'll post my question.

Install was flawless... works great!

On the main page under Top 5 Posters:

WreckRman2 with 3587 posts (43.35 %)

On the left under Topics/Threads/Users/Hits:

Posts: 41,972

If those numbers are correct then shouldn't my posts be 11.70% and not 43.35%?

Anyone else having this problem?

[A_BooK]

it is a nice hack and i want to ask if it is possible to try it in the local host server in my pc wich i used appserver ..??

thanks to PcFreak And Onkel_Tom .. :knockedout:

[DWard]

Not too sure if the issue has been raised, however if not, the referrers on the left of the referral page are sometimes invalid.

Below shows how the URL's are shown and linked:
http//
http://

[intrigue]

what a very nioce addition to the board even my members would be happy with this
.matt

[Onkel_Tom]

Not too sure if the issue has been raised, however if not, the referrers on the left of the referral page are sometimes invalid.

Below shows how the URL's are shown and linked:
http//
http://

I checked all my referers a few minutes ago and all the syntax of the referers is okay ! No missing ":" or something else, all with "http://xyz"

[venomx]

I found an error_log in /forums
Has a bunch of these from each day I have added this..
[11-Sep-2004 00:00:00] PHP Warning: gethostbyaddr(): Address is not a valid IPv4 or IPv6 address in /home/forum/public_html/forums/includes/functions_statistik.php on line 254

Anyone?

[PcFreak]

I don?t know how?
But there is a way to fake referrers.


I think the referrer routine works perfekt. ;)
I don?t know, why the referrers on the left of the referral page are sometimes invalid. (a referrer Fake? Huii.... :ermm: )

PcFreak

[alqafelah]

Gteat hack, but have error :(

Database error in vBulletin :

Invalid SQL:
SELECT * FROM style
WHERE (styleid = 0 AND userselect = 1)
OR styleid =
ORDER BY styleid ASC
LIMIT 1

mysql error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY styleid ASC
LIMIT 1' at line 4

mysql error number: 1064

any idea?

[Onkel_Tom]

Gteat hack, but have error :(

Database error in vBulletin :

Invalid SQL:
SELECT * FROM style
WHERE (styleid = 0 AND userselect = 1)
OR styleid =
ORDER BY styleid ASC
LIMIT 1

mysql error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY styleid ASC
LIMIT 1' at line 4

mysql error number: 1064

any idea?

Sorry, but this code you mentioned is not from vB3 Boardstatistic Version 2 hack !
You get this error because there is no number after the "styleid = " command, but this not from statistic hack ;)

[Wential]

Gteat hack, but have error :(

Database error in vBulletin :

Invalid SQL:
SELECT * FROM style
WHERE (styleid = 0 AND userselect = 1)
OR styleid =
ORDER BY styleid ASC
LIMIT 1

mysql error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY styleid ASC
LIMIT 1' at line 4

mysql error number: 1064

any idea?
What php file is this error from?

[alqafelah]

Onkel_Tom, thx for reply but i got this error in this hack only !

Wential, the Statistics home worked fine .. but the error got when i press on any of these links :

Overview | Browsers / Operating Systems | Countries of visitors | Searchrobots / Spiders | Last days | Referers / Top Level Domains | Polls / Stickys / Searchwords

thanx

[Onkel_Tom]

Hmm, we only use the variable styleid in the installation file to install all the Templates to the database. No where else this variable is used.

[Wential]

I tried to re-create this error and failed. It looks like something went wrong on the installation. Considering the number of Mods in your Forum, I'm not really surprised.

[Code Monkey]

Installed. Works great. :D

One question though. How is this affected by something like vbindex or the like? Since many visitors enter the site through the front page.

[Wential]

It is unaffected by VBindex since I use both hacks on my board and my stats are great!

[venomx]

Noone can help me? :(

[Code Monkey]

One thing I noticed in functions_statistik.php. You use ereg quite a bit. Such as.

if(ereg("Opera", $agent)) $c_browser = "Opera";


More efficient would be to use PCRE functions.

if(preg_match('#Opera#', $agent)) $c_browser = 'Opera';


And since no regular expresions are really needed for this, far more efficient would be.

if(strpos($agent, 'Opera')) $c_browser = 'Opera';


Anyway, thanks for the hack.

[iliton]

Someone knows why statistik2 (last version)
do not identificate googlebot spider
in online.php I saw google`s IP
but in statistik2 report It is not present ???

[Onkel_Tom]

Someone knows why statistik2 (last version)
do not identificate googlebot spider
in online.php I saw google`s IP
but in statistik2 report It is not present ???

There is a problem with the googlebot name.
You have to add a new ereg line in your /includes/functions_statistik.php file

search for:if(ereg("googlebot", $agent)) $c_bot = "googlebot"; //Googlebot
and replace it with:if(ereg("googlebot", $agent)) $c_bot = "googlebot"; //googlebot
elseif(ereg("Googlebot", $agent)) $c_bot = "googlebot"; //Googlebot

Now the googlebot is identified from the statistik.
Googlebot uses since a few weeks capital and small "g" in front ;)

[iliton]

thanks Tom
this changes has made .. and now
i shall wait for "google-dance" :)

[Beermonster]

Can you add something to this hack please, where is says xx registered members visited on xx day, can it also display the user names of the visited members.

I would like to know who the loyal members are that visit my forum on a daily basis

Thanks

[P.Jackson]

awsome hack great detail

* P.Jackson clicks install

:)

[Smitty]

Any idea when version 3 will be released?

[PcFreak]

Any idea when version 3 will be released?

So soon as possible! ;)

I think (hope) in 3 or 4 weeks.

Version 3 is very, very extensively.
More than 40 templates (phrased now).
More than 500 different images
20 new php?s.
Php and javascript counting.
15 new db tables.
Version 3 detect 200 spiders (this routine works correctly now) and 140 different Browsers, OS Systems and WAP Browsers.
Version 3 detected now searchengines and the searchkeywords.
Browserlanguages are now identified correctly.

and many many more

PcFreak

Version 3 is in beta status. (The counters routines are finished)
For a first impression visit the Statistic 3 demo here :
http://at-lantis.de/statistic.php

You can reach some sides by means of the new statistics naviagation and you can check there your systemstatus,too.

Not all phrase are finished. Some words in german and some in PcFreak english ;).
Have fun.

[djohn]

PcFreak, will the images be in english? I mean the country names, my members don't exactly enjoy the image names in german? ;)

[PcFreak]

PcFreak, will the images be in english? I mean the country names, my members don't exactly enjoy the image names in german? ;)

Yes ;)

PcFreak

[h75]

@ pcfreak. :rolleyes:
http://www.vbulletin-germany.com/forum/showpost.php?p=76812&postcount=167

[Code Monkey]

<a href="http://www.maani.us/charts/index.php" target="_blank">Here</a> is something you might find usefull for the next version. Pretty simple stuff once you learn the functions.

[integra99]

I found a bug. We have one user with an ' in his name, and that caused DB errors int he "Last Days" part of your script.

[integra99]

Also, my top domain referer is "Direkter Zugriff (7056 Einträge) "

WTF is that??

[Onkel_Tom]

I found a bug. We have one user with an ' in his name, and that caused DB errors int he "Last Days" part of your script.
You have to update to the latest version linked in post 2 of this thread.
This problem was fixed weeks ago ;)

[Onkel_Tom]

Also, my top domain referer is "Direkter Zugriff (7056 Eintr?ge) "

WTF is that??

Missing translation :D
It's "direct access (7056 Hits)"

[integra99]

Is there an easy way to upgrade? I am on v2 filedate 7.24.2003 10:33 am.

Thanks for the quick response :)

[Onkel_Tom]

Is there an easy way to upgrade? I am on v2 filedate 7.24.2003 10:33 am.

Thanks for the quick response :)
just replace the .php files from the new archive and done !

[Rick Sample]

I installed it, works like a charm!

http://www.muscle-mustangs.com/forums/statistik.php?

[Rick Sample]

I do have one location though. When I go to view online it says for the users browesing this hack "Unkown location" Forms/Statistiks.php"

Is their any way I can get that to say Site Statistics or something?

Thanks,

[integra99]

The demo of v3 would not come up for me, just a blank white screen. I wouldn't mind demo'ing it for you if your site it having trouble ;)

[integra99]

just replace the .php files from the new archive and done !I did this, and now the statistics are obviously wrong. It is showing that on one day I had 22 new posts and only 4 registered visitors! It used to show I had anywhere from 20-50 registered members per day, now its saying 0-8 for the last 30 days. For a few days its showing 40-60 new posts, and no registered visitors!

[bspiller82]

Seems my site isn't loggin vistors somehow?
CHeck it out
http://forums.247xtreme.com/statistik.php?do=browseros
Not logging the follow stats
Browsers / Operating Systems
Countries of visitors
Searchrobots / Spiders
Referers / Top Level Domains

[JBMoney]

Is there anything about the templates or some other caveat of this hack I might have missed, that would make it almost impossible to pull up.

I've installed it twice now, and each time it's pretty much unusable.

I've been tinkering with it all day and going back over the directions, but I've only been successful in actually getting it to pull up three times. When it does pull up, it looks great and seems to be creating the statistics just as it should be.

It just doesn't want to pull up though. I get 'page cannot be displayed errors' more than 9 times out of 10 (timeout?), meanwhile the rest of the forum seems fine.

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

[bspiller82]

.......

[PcFreak]

.......

Step 7)
=========
Now let's activate the statistics and count of visitors

Open Template "phpinclude_start" in your AdminCP

================================================== ==================
add the following code at the end of the template in the last line!:
================================================== ==================

//## vB Statistics by PcFreak Start ##

include("./statistik_counter.php");

// ## vB Statistics by PcFreak End ##

;)
PcFreak

[bspiller82]

Step 7)
=========
Now let's activate the statistics and count of visitors

Open Template "phpinclude_start" in your AdminCP

================================================== ==================
add the following code at the end of the template in the last line!:
================================================== ==================

//## vB Statistics by PcFreak Start ##

include("./statistik_counter.php");

// ## vB Statistics by PcFreak End ##

;)
PcFreak

Actually I've done that thats not hard to miss :) Its loggin everythign but the following
Browsers / Operating Systems
Countries of visitors
Searchrobots / Spiders
Referers / Top Level Domains
http://forums.247xtreme.com/statistik.php?do=browseros
See for yourself!

[bspiller82]

Works now. Seems somehow 2 of the vital php files where removed!

[JBMoney]

Is there anything about the templates or some other caveat of this hack I might have missed, that would make it almost impossible to pull up.

I've installed it twice now, and each time it's pretty much unusable.

I've been tinkering with it all day and going back over the directions, but I've only been successful in actually getting it to pull up three times. When it does pull up, it looks great and seems to be creating the statistics just as it should be.

It just doesn't want to pull up though. I get 'page cannot be displayed errors' more than 9 times out of 10 (timeout?), meanwhile the rest of the forum seems fine.

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

Hey... I always talk to myself.

As follow-up, every single option page pulls up perfectly fine. It's only the main page. I've tried removing elements from templates to see if that had anything to do with it, and it didn't. So whatever is going on probably is related to statistik.php itself. Since I don't understand German or PHP too well, it's kind of hard to figure that part out. :o

http://bushwhacked.net/forum/statistik.php?do=browseros

I am using the most up to date statistik.php.

[mcyates]

I have a bout 10 -20 google spiders roaming my site but the statistics has not picked up any of the google spiders, why is this?

[PcFreak]

I have a bout 10 -20 google spiders roaming my site but the statistics has not picked up any of the google spiders, why is this?

Here is one tip:
What is with the googlebot spider? (https://vborg.vbsupport.ru/showpost.php?p=554899&postcount=332)

PcFreak

[hdraye]

Thanx for a great hack, but; :devious: Can I have it count hits on my CMPS page? too, as some users land there and read news without accessing the forums

Thanx

Hani

[venomx]

I believe it does since its in the header templates and CMPS uses the forums heder/footer templates....

[buro9]

I really liked the idea of this hack, but 4 queries per page, ereg's instead of preg's, and massive switch statements... these do not add up to my idea of fun.

I'm afraid that I'm going to uninstall and wait (or maybe develop) a version that has a lighter counter (1 query), and with hourly generation of stats via cron rather than an almost permanently live thing.

This has just been too intensive for me. I have a good server, but we're running several boards and the difference was notable when I commented it out in headinclude. I wouldn't recommend this hack for boards that top several hundred simultaneous users.

Very nice work though... shame I don't have a quieter board at times ;)

[Skyline_GT]

How come it says

http://www.gamerzplanet.net/forums/statistik.php?

* - Since Statistics started on 31. December 1969 19:00

[venomx]

Sure you did all the template edits?

[Skyline_GT]

Sure you did all the template edits?N/m Fixed.

Thanks.

[hdraye]

Great hack, Thanx

2 things though
My board is in Arabic, but as AR is for Argentina, in the Country by browser language shows Argentina as top country :(

Also, How can I translate the page, I guess they are hardcoded, any idea if they will be in phrase variables?

Thanx again

[PitchouneN64ngc]

This is a very good hack but i've see a little bug in the code ;)

Into the statistikadmin.php, you can see this into the code:

$stat_set[WRITTENPOPST]=eregi_replace("[^0-9]", null, $stat_set[WRITTENPOST]);

$stat_set[WRITTENPOPST] is wrong :)

[Code Monkey]

This is a very good hack but i've see a little bug in the code ;)

Into the statistikadmin.php, you can see this into the code:

$stat_set[WRITTENPOPST]=eregi_replace("[^0-9]", null, $stat_set[WRITTENPOST]);

$stat_set[WRITTENPOPST] is wrong :)

all of those statements would be more efficient using...


$stat_set['WRITTENPOST'] = preg_replace('#[^\d]#', null, $stat_set['WRITTENPOST']);

[Watson]

When I installed this I lost around 300 of the posts from the main page, but they are still there in the stats page, any word on how this happened?

I thought it may be my admin forums, but they only have around 100 posts in them, though there are some other forums that are now closed that have some posts in them, would this have affected it, if so how would i get them to be displayed again on the main page?

Watson

[achtungbaby]

*installed*

very nice.

[RMS]

Looks quite nice. :)
How would I go about about linking to this page though?

I was thinking about putting it somewhere on the index, perhaps under the statistics box?

[Marv]

Hi PcFreak,

after the installation of this hack I became overwhelmed by error-msg?s like this:

Datenbankfehler in vBulletin 3.0.3:

Ungueltige SQL-Abfrage:
INSERT INTO vb3statistik_log
VALUES('','217.233.158.234','1098556512','Mozilla/5.0 (Windows; U; Win98; de-AT; rv:1.7.3) Gecko/20040910')

mysql error: Access denied for user: 'pxxxxxxx@%' to database 'dbxxxxxxxx'

mysql error number: 1044

Datum: 23.10.2004 20:35:12
Skript: http://www.xxx-xxxx.xxx/forum/usercp.php?
Referer:
Benutzername: xxxxxxxxx
IP-Adresse: 217.233.158.234 Until now I received 200+ error-notifications. Everytime with the same content:

mysql error: Access denied for user: 'pxxxxxxx@%' to database 'dbxxxxxxxx'

mysql error number: 1044 I can?t figure out what?s going wrong. All referers are different and the error occurs equal if it?s a registered member or an unregistered visitor.
But I wonder why the error-msg says user: 'pxxxxxxx@%'. The database user is pxxxxxxx without @%.

Do you have any idea what?s going on here ? Anyone..?

[master786]

Thanks for this hack ! We have installed it but how can we enable this on forum home page?

[Smitty]

Any word on the next version that has been discussed?

[bondjetta]

I have a quick question (that may or may not have been answered in the 25 pages before this post)...

is there any reason why the Spiders/Bots option isn't tracking Google Bots? is it something in their software that lets them fly under the radar? or is there a change I can make that will identify them? :)

[Onkel_Tom]

I have a quick question (that may or may not have been answered in the 25 pages before this post)...

is there any reason why the Spiders/Bots option isn't tracking Google Bots? is it something in their software that lets them fly under the radar? or is there a change I can make that will identify them? :)

Look here Google Problem (https://vborg.vbsupport.ru/showpost.php?p=557943&postcount=360) ;)

[bondjetta]

Look here Google Problem (https://vborg.vbsupport.ru/showpost.php?p=557943&postcount=360) ;)
thank you :D

[Hialls]

any chance of converting the arcade addon to work with the new arcade system? ibproarcade.

[TruthElixirX]

I'm getting some parse errors whjen I go to www.punktek.com/statistik.php

Warning: main(./global.php): failed to open stream: No such file or directory in c:\domains\punktek.com\wwwroot\statistik.php on line 50

Fatal error: main(): Failed opening required './global.php' (include_path='.;c:\php\includes') in c:\domains\punktek.com\wwwroot\statistik.php on line 50

[Onkel_Tom]

@ Punktek.com
Your forum installation is not in a /forum directory !
Please check if you have enaugh rights to execute script in your wwwroot dir.
Also all scripts should habe read and execute rights for al (chmod 755)

[Zain Jaffer]

I don't mean to sound stupid here ,,, but ...

Additional step 1
================================================== =============
Addition for showing Statistics only for Admins and Moderators
================================================== =============

open statistik.php and find:
=============================

// ######################### CHECK PERMISSIONS ###########################
// uncomment the following 4 lines if you want provide statistics only for Admins and Moderators
// if (!($permissions['adminpermissions'] & CANCONTROLPANEL) AND !can_moderate())
// {
// print_no_permission();
// }

================================================== =================
uncomment the lines as written in the code above to look like:
================================================== =================

// ######################### CHECK PERMISSIONS ###########################
// uncomment the following 4 lines if you want provide statistics only for Admins and Moderators
if (!($permissions['adminpermissions'] & CANCONTROLPANEL) AND !can_moderate())
{
print_no_permission();
}

I don't understand step 1, what do you mean by uncomment?!

[hdraye]

Hi Z\in
Just remove the "//" in the begining of line so they are commands not coments

[bendigo-tech]

Fantastic hack.

Have it installed and working great on 3.0.3 :)

Cheers!

[nineball]

any chance of converting the arcade addon to work with the new arcade system? ibproarcade.
I found that changing all references to gamesessions to gamesession seems to work ok

[TruthElixirX]

I fixed my previous error, now one problem. How do I add a link into the nav bar? For everyone to see.

[Mirlyn]

I get an error message on the first visit to my site:

Fatal error: Failed opening required './includes/functions_statistik.php' (include_path='.:/usr/share/pear') in /home/playit/www/forum/statistik_counter.php on line 190

Removing it from phpinclude_start will get rid of the problem.

It only happens once, and a refresh will fix it for the duration of the visit. Any ideas?

[Mark.B]

It's worth noting that the Arcade add on is 816 queries.

Yes, 816.

It's not recommended for people on shared hosting to be making that page public, not unless you want a nasty email from your hosts.

[Mr Peabody]

Only thing that dosent seem to work right is visitors from Hong Kong show up as unknown.
I would be great to be able to assign which usergroups can view stats

[GenSec]

48 queries.. ugh... okay only superadmins will get this.
I worked a little with main page part of statistik.php and now it's only 27 queries :squareeyed:

I attached my version of this part here.

It also needs to change STATISTIC template to correspond:

$postername1 to $postername[1]
$posterid1 to $posterid[1]
$poster_beitragszahl1 to $poster_beitragszahl[1]

$postername2 to $postername[2] etc.
.................................

[Sweet Evil]

looks great thanks!

[joeychgo]

@ Punktek.com
Your forum installation is not in a /forum directory !
Please check if you have enaugh rights to execute script in your wwwroot dir.
Also all scripts should habe read and execute rights for al (chmod 755)


My board isnt in a /forum directory either.

[Action-N]

Well I finally figured out why my board has so many queries on all my pages. I tracked it down to this hack, so I just finished uninstalling it. You should tell people up front that this adds atleast 4 extra queries on every vb page. If I know I'd have looked for an alternative which I'm going to do now. It looked like it was working alright, but to me wasn't worth it.

[ChuanSE]

I use to have it on my board, it didn't really slowed down stuff tho...
Bt i guess it isn't clever to have it on a 1000member board :-)

[BamaStangGuy]

I use to have it on my board, it didn't really slowed down stuff tho...
Bt i guess it isn't clever to have it on a 1000member board :-)
I have 1700 members, works fine on my site. Huge database attachment tables tend to slow it down alot. Fixed that buy putting attachments on file system. Now I can actually back the database up with ease.... my attachment table was 400+ mb

[Silverstangs]

I now have it installed on Stang Country (http://www.stangcountry.com). The stats are showing only 3 spiders, and I know I have google and a few other's hitting the site when I look at "who's online". ........ is there a fix for that?

BTW here is the link to that stats in action..
Stang Country Stats (http://www.stangcountry.com/forums/statistik.php).

[Couch]

Excellent Hack, installed and working no problem.

Thank You.

*Clicks Install*

[DS MrSinister]

I am having some problems with some of my stats.. I Had them working then my site crash.. When I reinstalled I cant get them to work Now.. Did everthing the same.. Can any one help me on this..


http://drunkensoldiers.net/forums/statistik.php

[joeychgo]

I have 1700 members, works fine on my site. Huge database attachment tables tend to slow it down alot. Fixed that buy putting attachments on file system. Now I can actually back the database up with ease.... my attachment table was 400+ mb


How did you do all that?

[goblues]

I am having some problems with some of my stats.. I Had them working then my site crash.. When I reinstalled I cant get them to work Now.. Did everthing the same.. Can any one help me on this..


http://drunkensoldiers.net/forums/statistik.php

Just taking a stab, did you place the following code into your phpinclude_start template?

include("./statistik_counter.php");

[BamaStangGuy]

How did you do all that?
AdminCP > Attachments > Attachment Storage Type and move them to filesystem

[DS MrSinister]

Just taking a stab, did you place the following code into your phpinclude_start template?

include("./statistik_counter.php");


thanks mate i forgot to do that..

[goblues]

thanks mate i forgot to do that..

Glad I could help out!

[Takamine334]

I have 3 styleids. This is what I get when installing

Template install completed. 36 templates added to styleid: 2
Click on "Add new database tables" to continue.


how do I get it to add to styleid 1 & 3 ?

[urmyantichrist]

How can I get the arcade addon working?

All I'm getting is a lank white page with the arcade stats info in a line down the middle of the page...

I'm not certain what I did wrong....?

[joeychgo]

Is there any way to reduce the queries?

[joeychgo]

This seems WAY too much --

This is from the overview page

Page generated in 10.11654 seconds with 47 queries [Server Loads: 5.38 7.23 : 7.23]
Page generated in 9.92194 seconds with 47 queries [Server Loads: 5.91 6.07 : 6.73]
Page generated in 10.25936 seconds with 47 queries [Server Loads: 4.76 5.68 : 6.54]

[Rick Sample]

This seems WAY too much --

This is from the overview page

How did you find that stuff out?

[joeychgo]

How did you find that stuff out?


Its magic -- :D


Nah - here is the hack https://vborg.vbsupport.ru/showthread.php?t=59700&highlight=server+load

[Rick Sample]

Its magic -- :D


Nah - here is the hack https://vborg.vbsupport.ru/showthread.php?t=59700&highlight=server+load


I'll have to give it a try and see how high my stuff is!

[joeychgo]

My host sent me this email today:

Your account is utilizing excessive resources, causing a significant
degradation of services on the server. This is a shared environment and we
can not allow one user to utilize the majority of the resources on a server as
it affects all users adversely. Because of this, you have been temporarily
moved to the Quantz server. A detail of the problem is shown below:

Top Process %CPU 30.0 /usr/bin/php
Top Process %CPU 20.0 /usr/bin/php
Top Process %CPU 12.0 /usr/bin/php

Using 4.63% of servers memory

We moved you to Quantz first to solve the issue of the degraded service on
Nasa, and second as a courtesy in order to prevent any downtime on your site to allow you time to rectify the situation. Currently, your site is not
suitable for a shared hosting environment.


The only thing I have installed recently is this hack -- I am waiting now to find out if removing this hack solved the problem ~will advise~

[mcyates]

My host sent me this email today:




The only thing I have installed recently is this hack -- I am waiting now to find out if removing this hack solved the problem ~will advise~
It probably was the statistics causing this problem, i took it off my site as it drastically reduced the speed and adding 5 - 6 queries on each page. Very querie intensive.

[joeychgo]

It appears so - I pulled it and the server loads dropped.

it seems this hack will make a mess unless your on a dedicated server.

[Mark.B]

Certainly, I would not advise use of the Arcade add on...806 queries on one page, sheesh.

[mcyates]

Certainly, I would not advise use of the Arcade add on...806 queries on one page, sheesh.
806??? It only added a couple whe i installed it. You must have done something wrong.

[Mark.B]

806??? It only added a couple whe i installed it. You must have done something wrong.
I should qualify, it doesn't add those to the index page, that's the number of queries it seems to use on the actual arcade stats page.

[mackers8923]

*Installed*

Going to give it a go as yet no major increase in server load is noted.

[mcyates]

*Installed*

Going to give it a go as yet no major increase in server load is noted.
this didn't increase my server load one bit. What it did do is increase the quieries and slowed my site down via tha database. But it was only slight slower. i like very fast sites and I actually had this on for 2 months, i've JUST remved it.

[Torqued]

It looks like the script is only counting people that are using custom avatars and not the people using the installed avatars.

I found this code that looks like it's doing that:

$alle_avatars = $DB_site->query_first("SELECT COUNT( * ) as avatar FROM " . TABLE_PREFIX . "customavatar ");

How would you fix that so that it would count both people using custom avatars and people using installed avatars?

[morrow]

*Installed tonight in about 8 minutes. Very nice hack so far, let's see what happens when the cron job kicks in! :)

Thanks a bunch for this gem.

*Clicks install

[GamerzWorld]

Hello installed this a while ago but recerntly found

The 10 Top Level Domains
http://www.revival-guild.com (850 entries)
http://forum.legendofmir.net (770 entries)
http://boards.legendofmir.net (415 entries)
http://www.legendofmir.net (366 entries)
http://www.brutal-rape.biz (195 entries)
http://mature.industryofporn.net (161 entries)
http://www.google.com (114 entries)
http://search.yahoo.com (103 entries)
http://www.google.co.uk (31 entries)
http://incest-porn.industryofporn.net (31 entries)


Now obviously im disgusted by this. How do i remove it and what is causing this

[Torqued]

It could be "stealth spamming" where a person signs up for accounts and puts "hidden" links in their sig, avatar, profile, etc. linking to those sites. It's a tactic used to improve their search engine rankings.

Have a look at this article:

Security: Silent Spamming - Is your Website Being Abused?

http://www.theadminzone.com/forums/articles.php?do=viewarticle&aid=684

[berberber]

Hello everybody, thanks for that hack, I am using it too (even if one feature is missing, the detection of new little referers (as, one day the main referers have all the space in the referer page)).
But I have a problem, i had little hosting problems, and after outtage I have that ::

Database error in vBulletin 3.0.3:

Invalid SQL:
INSERT INTO statistik_log
VALUES('','82.******.181','1102512176','Mozilla/5.0 (Windows; U; Windows
NT 5.1; en-US; rv:1.7.5) Gecko/20041107 Firefox/1.0')

mysql error: Got error 127 from table handler

mysql error number: 1030

Date: Wednesday 08th of December 2004 01:22:56 PM

One time I just had to clear it, the second time I had to repair it using phpmyadmin, but problem is, that without that the forum restarts without problem, so I imagine that table must be different...
Do anyone know how to fix that ?

Thanks,
Bernhard

Noch mal vielen dank ;)

[goblues]

Hello installed this a while ago but recerntly found

The 10 Top Level Domains
http://www.revival-guild.com (850 entries)
http://forum.legendofmir.net (770 entries)
http://boards.legendofmir.net (415 entries)
http://www.legendofmir.net (366 entries)
http://www.brutal-rape.biz (195 entries)
http://mature.industryofporn.net (161 entries)
http://www.google.com (114 entries)
http://search.yahoo.com (103 entries)
http://www.google.co.uk (31 entries)
http://incest-porn.industryofporn.net (31 entries)


Now obviously im disgusted by this. How do i remove it and what is causing this

I also am having problems with this. Started yesterday as far as I can tell. Had to disable (just renamed the files for now) until this can be addressed. You can physically remove these entries by deleting them in your statistik_domain & statistik_referer tables in your database.

[Torqued]

You might want to check your server logs for those URL's to see if they are linking to files/content on your site. Check out the article I posted earlier.

[PcFreak]

The last months I had no much time to work on the board statistic.

But i will release a new one in the end of this year.
Sorry that i had no more supported the old one.

More infos here, soon.

Pc Freak

[Smitty]

That would be GREAT!!! And very much appreciated! This is really a great 'hack'!

[kall]

Something everyone may want to know:

This script's main file is now being targetted by referrer spambots.

They go straight for statistik.php?do=referrer and your referrer links get filled with porn sites' URLs.

My advice is to rename the statistik.php to something else, and find/replace in the templates to point to the new file name, and not have this a public feature, otherwise you will end up with the badness like I do.

[Smitty]

That does it for me. I disabled that listing by editing the referrer_bit

[Smitty]

Can anyone explain just how the bots are making these entries?

By the way - I noticed the "adminshop dot com" is also appears to be doing this.

Can anyone give me a SQL query to delete all referrer entries of only 1 in the Zaehler field?

[TRStealth]

I'm getting a problem with this, lately, I've been getting emailed (About 600 of them actually) with a problem caused by this hack:

Database error in vBulletin 3.0.3:

Invalid SQL:
SELECT ID,Zaehler
FROM statistik_referer
WHERE Referer ='Direkter Zugriff'
ORDER BY ID DESC

mysql error: Got error 127 from table handler

mysql error number: 1030

Date: Sunday 12th of December 2004 02:42:26 AM
Script: http://www.enclave1.net/forums/showthread.php?goto=lastpost&t=591
Referer:
Username: Unregistered
IP Address:

I'm not really sure how to fix it.

[Smitty]

I've seen Direkter Zugriff in the database and have scrolled through 70,000+ entries deleting the 'crap'. I've been deleting the Direkter Zugriff references as well as some type of spam.

[PcFreak]

Something everyone may want to know:

This script's main file is now being targetted by referrer spambots.

They go straight for statistik.php?do=referrer and your referrer links get filled with porn sites' URLs.


Thank you.
Good to know this!

The best way to delete all referers is, to use the function empty the statistk_referer table, directly in the mysql.

Or use a query like this:
Truncate TABLE 'statistik_referer'.

PcFreak

[Smitty]

I saw a couple of posts on this but didn't thik much of it until I was doing some maintenance and took a looksie. I was really, really p*$$ed off. I edited the referrer template and disabled those stats. They're mostly google anyway.

It was even kinda creepy. I was going through the referrer and domain database tables with phpMyadmin deleting some entries for the bot entries. I was then checking the server logs with a log analysis app. While I was doing this those bots came!

Oh, well. Anything for an inbound link from another site, eh?

I plan to just leave that page disabled. I doubt my users care about that page anyway.

I do hope this is upgraded - it is a very nice hack. This has been a minor inconvenience.

[Takamine334]

I must have missed something because I've been getting this since December 5th when I installed this hack

[Smitty]

You know spammers. Where there's a will...

I went through my logs and this is relatively new - a week or so for me. I went through the entire database fields domain & referrers and checked and dumped all entries. Now I'll watch for a while. But I am keeping that page 'restricted - That is I edited the template as I said above so where there are typically the stats it just says disabled due to URL spam bots. I assume it's really a person doing this rather than a script or bot but you never know.

[Trosun]

My stats still doesn't track googlebot.

I've changed the functions_statistik.php as Onkel Tom spesified in post #332 (https://vborg.vbsupport.ru/showpost.php?p=554899&postcount=332)

[Smitty]

Thankis for the tip!

[Takamine334]

Wish someone could answer my question

[PcFreak]

Wish someone could answer my question
Step 7)
=========
Now let's activate the statistics and count of visitors

Open Template "phpinclude_start" in your AdminCP

================================================== ==================
add the following code at the end of the template in the last line!:
================================================== ==================

//## vB Statistics by PcFreak Start ##

include("./statistik_counter.php");

// ## vB Statistics by PcFreak End ##

;)
PcFreak

[eXtremeTim]

You really should learn to use left joins. Im using them right now to start to clean up the amt of queries in the arcade addon first since it was using 92. So far I have cut 92 down to 52. thats 4 queries per game you have listed that have now been cut out. :) I now have gotten the arcade addon page down to 16 queries no matter how many games you list be it 1 or a 100. Trust me I tested it. Im going to go through and see about doing the rest of this hack and see what I can get it down to.

If the author doesnt mind. I will post my current modified file for everyone.


This is when listing 10 games on the page.

When using inner joins it generates the page in the following time.
Page generated in 0.18413091 seconds (41.08% PHP - 58.92% MySQL) with 16 queries

Now using left joins it generates the page in the following time.
Page generated in 0.28608704 seconds (26.56% PHP - 73.44% MySQL) with 16 queries

Only problem with the inner join is that you can only use the conditionals when running mysql 3.23.17

I can release both versions thats no problem.


High Stress Load Test
Original Code set to display 1000 games:
Page generated in 2.45838499 seconds (26.88% PHP - 73.12% MySQL) with 3164 queries

Optimized Code Using inner join's displaying 1000 games:
Page generated in 0.50021791 seconds (78.25% PHP - 21.75% MySQL) with 16 queries

Optimized Code Using left join's displaying 1000 games:
Page generated in 0.67386508 seconds (68.22% PHP - 31.78% MySQL) with 16 queries

[PcFreak]

You really should learn to use left joins.

Jepp.
Can you post or quote the optimized code, please?
Or better..., you release both versions with the code you used.

I am still learning php ;)

PcFreak

[eXtremeTim]

Heres the fixed version of the statistics file. Use the inner join version first and if it does not work for you then please use the left join. There shouldn't be any problems with table prefix's in the code but if there are let me know so that I can fix them. You can see my demo here of this file working. I will see about what I can do to the other pages latter on. http://www.extremechatforums.com/forums/statistik.php

[Takamine334]

Step 7)
=========
Now let's activate the statistics and count of visitors

Open Template "phpinclude_start" in your AdminCP

================================================== ==================
add the following code at the end of the template in the last line!:
================================================== ==================

//## vB Statistics by PcFreak Start ##

include("./statistik_counter.php");

// ## vB Statistics by PcFreak End ##

;)
PcFreak

:up:

[Mark.B]

Heres the fixed version of the statistics file. Use the inner join version first and if it does not work for you then please use the left join. There shouldn't be any problems with table prefix's in the code but if there are let me know so that I can fix them. You can see my demo here of this file working. I will see about what I can do to the other pages latter on. http://www.extremechatforums.com/forums/statistik.phpUsing these I am finding the game's mini-image doesn't show up, it isn't pulling the right info as the image properties don't show a gif name. (As opposed to it being a filepath error).

[eXtremeTim]

Oh yes I fogot I made a template change also. Let me get the template for you as well. When I changed the query's it changed the variable for the miniimage.

[eXtremeTim]

Replace statistic_arcade_bit with the following html

<tr>
<td class="$bgclass"><div align="center"><img src="images/arcade/$letzte_spiele[miniimage]" alt="$spielname" width="20" height="20" border="0" /></div></td>
<td class="$bgclass"><div align="center"><a href="arcade.php?do=play&amp;gameid=$spielid">$spielname</a></div></td>
<td class="$bgclass"><div align="center"><a href="member.php?u=$spielerid">$spielername</a></div></td>
<td class="$bgclass"><div align="center">$spiel_beendet</div></td>
<td class="$bgclass"><div align="center">$spielkommentar</div></td>
<td class="$bgclass"><div align="center">$spieleergebnis</div></td>
<td class="$bgclass"><div align="center"><strong><a href="member.php?u=$highscorerid">$highsorename</a></strong><br />
with <strong>$highscore</strong> Points</div></td>
</tr>

[PcFreak]

95% of my new vBulletin Boardstatistic Version 3 is finished.

Here some futures:

The new Boardstatistc Version 3
Detect vistor countries: 257
Detect Browserlanguages: 119
Detect Referer and Shortreferer (Domains)
Detect 17 different searchengines and log the keywords
Detect 291 Spider, Crawler and Searchrobots (work with the database of robots)
Detect Browser Plug Ins, resolutions, color depth, java and much more.
Show you all about the board (Topposters, most popular thread, threads without answers and many, many more)
Show all about the database (for example: show the attachment traffic and more)
More than 20 PopUps witch show more information
Found more about countries with Wikipedia (I have include a search function to the Wikimedia database)
Detect more then 50 different browser, more then 40 different os?s, WebService, and more then 20 WAP Browser
Make a systemcheck with the new Statistic (Show you all, what we can detect about your system)

a Live Demo your found here:

http://at-lantis.de/statistic.php


Now my little problem:
English is not my mother language. It?s very hard for me to translate this statistic in English.
The statistic is work with phrases. (will be imported in xml format).
All phrases are finished (not the phrases for the admincp).
Is there anybody whose want help me to translate them from german into other languages?

Would be really nicely


PcFreak

[Smitty]

Now you're gettng me excited! Will all the icons you have in your demo be part of it?

Great job!

[PcFreak]

Now you're gettng me excited! Will all the icons you have in your demo be part of it?

Great job!

Surely.
All icons are freeware.
I found the most of them here: http://www.iconarchive.com/

PcFreak

[Spinball]

Now my little problem:
English is not my mother language. It?s very hard for me to translate this statistic in English.
The statistic is work with phrases. (will be imported in xml format).
All phrases are finished (not the phrases for the admincp).
Is there anybody whose want help me to translate them from german into other languages?

Would be really nicely
PcFreak

I was about to install version 2 but I'll wait, I think.
I'm happy to help with an English translation though I don't speak German. I am an English computer programmer, though, so I have experience of finding the shortest but most appropriate phrases. Your best guess at an English version and the ability to see where the text goes would be all that I need.

[kall]

All phrases are finished (not the phrases for the admincp).
Is there anybody whose want help me to translate them from german into other languages?
PcFreak

I also offer to help in this...I have a very basic understanding of german from the 2 fun years spent at school trying to learn it. :)

(I'm going away for a week or so next week though, so time would be of the essence.)

[PcFreak]

The new Statistic Version is finished.
We will begin to translate them soon.
Now we make few beta tests.
Hope i can release the new version this year.

PcFreak

[Morrus]

Is there a way for the referrers page to miss out referrers from your own domain? I have no interest in referrers from pages of my own website, only external referrers. At present, the list looks like this:

http://www.enworld.org/forums/forumdisplay.php?f=2 (6 visits)
http://www.enworld.org/forums/index.php (3 visits)
http://www.enworld.org/forums/index.php? (2 visits)
http://www.xopy.com/friendslinks.php (2 visits)
http://www.enworld.org/forums/showthread.php?t=109893 (1 visits)
http://enworld.cyberstreet.com/showthread.php...47b72&p=1927301 (1 visits)
http://www.enworld.org/forums/news.php (1 visits)
http://www.enworld.org/forums/forumdisplay.ph...30&daysprune=-1 (1 visits)
http://www.enworld.org/forums/showthread.php?...t=111543&page=3 (1 visits)
http://homepages.ihug.com.au/%7Ejclunie/getme...etmediaeval.htm (1 visits)
http://www.enworld.org/forums/showthread.php?t=111727 (1 visits)
http://www.enworld.org/forums/showthread.php?...124#post1929124 (1 visits)
http://www.enworld.org/forums/newthread.php?d...=newthread&f=68 (1 visits)
http://www.enworld.org/forums/showthread.php?t=108552 (1 visits)
http://www.google.fr/search?hl=fr&q=site+de+g...ion+shoes&meta= (1 visits)
http://www.enworld.org/forums/showthread.php?...85&page=7&pp=20 (1 visits)
http://www.enworld.org/forums/showthread.php?t=101983 (1 visits)
http://www.enworld.org/forums/ (1 visits)
http://www.enworld.org/forums/showthread.php?t=11166 (1 visits)
http://www.enworld.org/forums/showthread.php?...12&page=3&pp=20 (1 visits)
http://www.enworld.org/forums/newreply.php?do...reply&p=1929160 (1 visits)
http://www.enworld.org/ (1 visits)
http://www.enworld.org/forums/showthread.php?...57&page=2&pp=20 (1 visits)
http://www.google.com/search?hl=en&q=%2BYosim...mite+%2BBusiest (1 visits)
http://www.rpgnow.com/

As you can see, in all that there are only 4 entries of interest, and you have to search pretty hard to find them amongst all the internal referrals!

[PcFreak]

In the admin cp under statistic settings is this point:

Enter here your Domain.
This indication is very important. Otherwise direct accesses to the board (e.g. over favorite bookmarks etc.) are stored, as an external Link in Referers.
Use in the following format: my-domain.com without \"http://\" and without \"www.\" - only: my-domain.com"

There you can input your domain.

PcFreak

[TLSNetwork]

Just a quick question on this , Installed everything and its working fine , on install it only insalled templates into the style id1 , How do i get the templates into my other themes as well , sorry but very new to vb.

[Morrus]

In the admin cp under statistic settings is this point:



There you can input your domain.

PcFreak

Thanks. I hadn't noticed that got cleared when stats were reset.

I have noticed that it's impossible to reset your stats and then enter the domain in that box without a few entries from your own domain creeping in during the few seconds it takes between the two steps. No big deal.

[PcFreak]

Thanks. I hadn't noticed that got cleared when stats were reset.

I have noticed that it's impossible to reset your stats and then enter the domain in that box without a few entries from your own domain creeping in during the few seconds it takes between the two steps. No big deal.
disabel the statistic_logging if you make a reset

In the phpinclude_start template found

include("./statistik_counter.php");
replace with
//include("./statistik_counter.php");

after the statistic reset replace the code again with:

include("./statistik_counter.php");

Thats all ;)

PcFreak

[Spinball]

Are we still on for a pre-2005 release?
I would like to start gathering stats from the start of the year.

[Onkel_Tom]

PcFreak and I are still working on the new version 3 of vB Statistic. We don't want to offer a version which is buggy like the version 2 so we testing and optimizing the code each day and if all goes well we can offer the new version 3 beginning upcoming year.

[Smitty]

Great! We look forward to it and appreciate your work!

[Spinball]

Excellent. It will be the first install of yor hack on my boards.
I love statistics.:)

[eXtremeTim]

I can not get other spiders to be picked up in the spiders list. I have added them to the functions_statistik.php file

using the following
if(ereg("googlebot", $agent)) $c_bot = "googlebot"; //googlebot
elseif(ereg("Googlebot", $agent)) $c_bot = "googlebot"; //Googlebot
elseif(ereg("BecomeBot", $agent)) $c_bot = "BecomeBot";
elseif(ereg("Mediapartners-Google", $agent)) $c_bot = "Mediapartners-Google";
elseif(ereg("msnbot", $agent)) $c_bot = "msnbot";

Where else must I edit something?

[PcFreak]

Hello eXtremeTim.

Better is, you wait few days.
We will release Version 3 of the vBstatistic the next days.
The new version detect more then 290 differnt spiders correctly.

If you add new spiders in Version2 you must make inserts for them in the database, too.

for exampel
you add this spider:
elseif(ereg("Mediapartners-Google", $agent)) $c_bot = "Mediapartners-Google";
The new insert for this spider:
INSERT INTO statistik_spider VALUES (95, 'Mediapartners-Google', 'images/statistik/spider/new.gif', 'images/statistik/bar1.gif', '0')

Greets
PcFreak

[eXtremeTim]

Didnt even think about that. :-/ Will v3 have the option for adding spiders?

[PcFreak]

Will v3 have the option for adding spiders?
No. The spiders are hardcodet and up-to-date.

But new spider updates are planned.
The user must exchange just one php file.
The new install routine detect the Statistic version and update the statistic tables automatically.

I think this is the best way.

PcFreak

[lanoix]

I installed it but had to translate it in french for my forum... Thank you for this hack, it works perfectly :)

[Onkel_Tom]

I installed it but had to translate it in french for my forum... Thank you for this hack, it works perfectly :)

It would be great if you can translate our Phrases from the new version 3.0 to french. If you are interested please send me a PM with your eMail Address and I will sent you the phrases file in english to be translated in french.
So we can offer also the french language for the new version and you will get a credit on the translation page ;)

[kadafi_alive]

Anyone know how to put it on the forum? Like a link?

[Smitty]

Anyone know how to put it on the forum? Like a link?
As I remember, I edited my forumhome template. It's not very obvious, but if you click the 'graph' graphic in the 'What's Going On' block on my site it takes you to the statistics.

[kadafi_alive]

Help, how do I uninstall this hack.

I know how to modify the templates again and such but how do I reverse the mysql queries that I ran.

Any speedy reply is greatly appreciated.

[PcFreak]

@kadafi_alive
Use the uninstall_statistik_english.php from Onkel_Tom.

Download here:
https://vborg.vbsupport.ru/showpost.php?p=528547&postcount=2

PcFreak

[bandit022]

i installed this a few hours ago, and double checked that i followed every step.

it is working fine with the exception of counting the number of hits, number of visitors, and no stats are showing up on the "countries of visitors", "searchbots/spiders", and "browsers/operating systems" pages.

how can i fix this?

[BamaStangGuy]

i installed this a few hours ago, and double checked that i followed every step.

it is working fine with the exception of counting the number of hits, number of visitors, and no stats are showing up on the "countries of visitors", "searchbots/spiders", and "browsers/operating systems" pages.

how can i fix this?
You forgot to add the info in phpinclude

[bandit022]

You forgot to add the info in phpinclude

no, i added it. but i'm not sure if i've added it in the right place.

here is my phpinclude template. does it look right where it's added?

// Example of how to include a seperate file:
// ob_start();
// require("yourheader.html");
// $header = ob_get_contents();
// ob_end_clean();
//vBanner made by Thain, aka Rufus69.
$file ="images.txt";
$banner = file("$file");
$b = rand(0, sizeof($banner)-1);
if ($bbuserinfo[usergroupid] == 13) {
header("HTTP/1.0 404 Not Found");
header("Status: 404 Not Found");
exit;
}

$statscache = unserialize($datastore['statscache']);

<?php
if (@include(getenv('DOCUMENT_ROOT').'/adserver/phpadsnew.inc.php')) {
if (!isset($phpAds_context)) $phpAds_context = array();
$phpAds_raw = view_raw ('zone:1', 0, '_blank', '', '0', $phpAds_context);
$bannerad = $phpAds_raw['html'];
}

?>

include("./statistik_counter.php");

[BamaStangGuy]

take your <?php ?> out

you dont need those as phpinclude doesnt need you to define it being php

That should fix it

[bandit022]

take your <?php ?> out

you dont need those as phpinclude doesnt need you to define it being php

That should fix it

works like a champ now.

thanks man. :up:

[TheVirus]

No. The spiders are hardcodet and up-to-date.

But new spider updates are planned.
The user must exchange just one php file.
The new install routine detect the Statistic version and update the statistic tables automatically.

I think this is the best way.

PcFreak

I noticed on your site you have an english version of the new update. When can we expect to get our hands on the new release?

[PcFreak]

I noticed on your site you have an english version of the new update. When can we expect to get our hands on the new release?

Its not a update. ;)
Its a completely new version and i think, one of the largest Hacks that was ever written (more as 7000 Lines of code)

The Statistic Version 3 will release in the next days.
We want to publish this modification at the same time in german and english.

That is the reason why the At-lantis forum is open now.

PcFreak

[rikku3978]

Thank you for releasing this hack publically. I'll install it. ^-^;

[Smitty]

Thank you for releasing this hack publically. I'll install it. ^-^;
I have it installed and really like it. It's great - Just waiting for the new version.

[Smitty]

Its not a update. ;)
Its a completely new version and i think, one of the largest Hacks that was ever written (more as 7000 Lines of code)

The Statistic Version 3 will release in the next days.
We want to publish this modification at the same time in german and english.

That is the reason why the At-lantis forum is open now.

PcFreakWe all very much appreciate the work you've put into the 'hack'. When the 'v 2 release' is ready, and posted, it will be VERY much appreciated!

[bandit022]

awesome. i can't wait for v3 to be released.

[PcFreak]

no more support for statistic version 2



In the next days we will release a new statistic Version (vB Statistic 3).
For this reason I give from today on, no more support for the Statistic Version 2

This version is bigger, faster and we want to publish the statistic in two languages. (german and english).


In order to use the new Statistic Version, the old version must be unfortunately removed.

A deinstallation script you found here >> https://vborg.vbsupport.ru/showpost.php?p=528547&postcount=2

For a first impression

You find a English demonstration of the Statistic here >> http://at-lantis.de/statistic.php

You find a German demonstration of the Statistic here >> http://boardszene.de/statistic.php

May someone will translate our Phrases from the new version 3.0 into other languages. If you are interested please send me or Onkel_Tom (https://vborg.vbsupport.ru/member.php?userid=8459) a PM with your eMail Address and we will sent you the phrases file in english to be translated into other languages.

The vB Statistic is free. However, if you would like to donate a small amount, feel free.

https://vborg.vbsupport.ru/external/2010/02/12.gif (https://www.paypal.com/xclick/business=webmaster%40at-lantis.de&item_name=vBulletin+Statistic+Version+3&page_style=PayPal&no_shipping=0&no_note=1&tax=0&currency_code=EUR&lc=GB)

Statistic Version 3 have more as 7000 Lines of code and possibly, one of the largest Hacks that was ever written for vBulletin.
More as 450 different images
46 new Templates are provided
More than 350 phrases are needed.
Everything is completely adjustable over the AdminCp
More than 350 phrases are needed.
No much server load. Maximally 5 querys for logging. (normal 3 querys.)
The start side of the statistics needs approx. 15 querys (only if this is indicated)
More than 350 phrases are needed.
Possibility for later updates (e.g. new Spider and Crawler implements)
The installation is very, very simply, been made by an installscript and does not need more than 30 seconds. All attitudes and changes take maximally 5 minutes.
no changes of the existing vBulletin data base tables
15 new data base tables with more than 1100 inserts are provided
Support for international time formats implements.
Detect now browser plugins, resolutions and more with javascript.
vB Statistic Version 3 show Information about your System on a special side.
Detect now browser plugins, resolutions and more with javascript


More Infos soon
PcFreak

[PixelFx]

sounds great can't wait to try it out

[TheVirus]

no more support for statistic version 2



In the next days we will release a new statistic Version (vB Statistic 3).
For this reason I give from today on, no more support for the Statistic Version 2

This version is bigger, faster and we want to publish the statistic in two languages. (german and english).


In order to use the new Statistic Version, the old version must be unfortunately removed.

A deinstallation script you found here >> https://vborg.vbsupport.ru/showpost.php?p=528547&postcount=2

For a first impression

You find a English demonstration of the Statistic here >> http://at-lantis.de/statistic.php

You find a German demonstration of the Statistic here >> http://boardszene.de/statistic.php

May someone will translate our Phrases from the new version 3.0 into other languages. If you are interested please send me or Onkel_Tom (https://vborg.vbsupport.ru/member.php?userid=8459) a PM with your eMail Address and we will sent you the phrases file in english to be translated into other languages.

The vB Statistic is free. However, if you would like to donate a small amount, feel free.

https://vborg.vbsupport.ru/external/2010/02/12.gif (https://www.paypal.com/xclick/business=webmaster%40at-lantis.de&item_name=vBulletin+Statistic+Version+3&page_style=PayPal&no_shipping=0&no_note=1&tax=0&currency_code=EUR&lc=GB)

Statistic Version 3 have more as 7000 Lines of code and possibly, one of the largest Hacks that was ever written for vBulletin.
More as 450 different images
46 new Templates are provided
More than 350 phrases are needed.
Everything is completely adjustable over the AdminCp
More than 350 phrases are needed.
No much server load. Maximally 5 querys for logging. (normal 3 querys.)
The start side of the statistics needs approx. 15 querys (only if this is indicated)
More than 350 phrases are needed.
Possibility for later updates (e.g. new Spider and Crawler implements)
The installation is very, very simply, been made by an installscript and does not need more than 30 seconds. All attitudes and changes take maximally 5 minutes.
no changes of the existing vBulletin data base tables
15 new data base tables with more than 1100 inserts are provided
Support for international time formats implements.
Detect now browser plugins, resolutions and more with javascript.
vB Statistic Version 3 show Information about your System on a special side.
Detect now browser plugins, resolutions and more with javascript


More Infos soon
PcFreak

Holy ++++ man...sounds nice. Gimme gimme gimme :banana:

[nexialys]

proper url for new v3 english, is: http://at-lantis.de/statistic.php?guestlanguageid=2

this is a full features statistics engine, but the icons are kinda crap... i will have to find a good collection of images.. ;)

btw, it's good to see it's now phrased!

also, i'd like to see the usual navbar on this, is it possible ?!... you're not displaying it on your sites...

[Torqued]

Please release v3 soon! :) I was going to open up my board for beta testing today and would like to start collecting stats as soon as possible. :)

[nexialys]

Please release v3 soon! :) I was going to open up my board for beta testing today and would like to start collecting stats as soon as possible. :)
as usual... this will be ready WHEN IT'S READY !!!

[Torqued]

yeah yeah.. I know. :)

[PcFreak]

but the icons are kinda crap... i will have to find a good collection of images.. ;)


Sounds good. ( I like the icons but they are not everyone taste)
No big Problem, release the statistic with more images packs.

Are you interests to provide a new?
Please contact me.

PcFreak

[nexialys]

no, i will not provide new icons for your release, it would be too late... i'll have someone here(my company) that will provide us a pack for our style, and as we never release our stuff, i talked too loud on that one!

[kall]

Sounds good. ( I like the icons but they are not everyone taste)
No big Problem, release the statistic with more images packs.

Are you interests to provide a new?
Please contact me.

PcFreak
Dude, if I find anything nice in the icon line, I will let you know.

Heh, I keep checking back here for v3...vb.org must be loving you!

[kall]

Hmmm. Seems some scumbag is keeping an eye on this thread and sending the porn referral bots out to those people who reply...or something.

The nasty bots had gone away for a week or so, but I make one post to this thread and they are back.

[Torqued]

Hmmm. Seems some scumbag is keeping an eye on this thread and sending the porn referral bots out to those people who reply...or something.

The nasty bots had gone away for a week or so, but I make one post to this thread and they are back.

Can you ban them via IP ban in CPanel or with .httaccess?

Can you post an entry/sample of the referral bots so maybe we can come up with a strategy to block them?

[rex_b]

Can you ban them via IP ban in CPanel or with .httaccess?

Can you post an entry/sample of the referral bots so maybe we can come up with a strategy to block them?


Ditto. I hate those damn things!

[kall]

Can you ban them via IP ban in CPanel or with .httaccess?

Can you post an entry/sample of the referral bots so maybe we can come up with a strategy to block them?
There will be an option in version 3 to delete individual referrers from the referrer list.

Thanks to PCFreak and Onkel Tom for that.

:)

[Torqued]

There will be an option in version 3 to delete individual referrers from the referrer list.

Thanks to PCFreak and Onkel Tom for that.

:)

Deleting from the list is great.. but what I'd like to know is how to ban them/keep them from getting there in the first place. Will it block them if they try to make future referral spams?

[TheVirus]

Any word on a release of Version 3? :ninja:

[PcFreak]

The German version was released now on vBulletin Gemany and my forum.
The English version is released in few days

We want to release a very stable and bugfree Version.

PcFreak