Yep, this is a bug.

I will fix them in a new zipfile soon.

To fix this now, search in the template statistic_popular_forum_bit
replace it with
(you found this two times)

PcFreak

While doing that I noticed the variable $popularforum_titel which is a misspelling. It should be $popularforum_title. I won't change it because I don't know where all it's used.

Oh, and all those references to "autor" on the last post on the last page should be "author". Not messing with ya just trying to help. :)

Thanks! I had that template in bbedit looking at it but I just didn't see the problem. I replaced both and it works fine now.

I'm still having problems with no fix :(

Once again, check out my Stats and click on any page besides the main (Overview) page to view my problem: www.forevergaming.com/forums/statistik.php

MGM out

I can?t see any problem.
Ok. The poll statistic is a little bit small on your side, but this ist not a bug.

This screenshoot show, what i see, when i visit your side.

PcFreak

yea, I know, i just fixed it.... I copied the header from forumhome into Statistiks_header and it worked (while editing the title to say Stats and adding statistik_menue to the bottom)

damned XML giving me problems :p

thanks for the help! lol

MGM out

In the do=referer Referrer Summary at the bottom of the page, I understand:
"1427 Visitors visited The Elsmar Cove directly"
and
"1215 Visitors came over a Hyperlink (Referer) to us"

Can anyone better explain to me what these are:
"over 1185 different Hyperlinks (Referer) found visitors to The Elsmar Cove"
and
"One has The Elsmar Cove over 117 different Top level Domains reaches"

Perhaps also this solution helps.

In AdminCP under vBulletin Settings -> General Settings

there must be a setting like this:

Templatenames as comment in HTML source text write?

NO!

(This is a free translation, because my AdminCp is in German).

PcFreak

I was looking at the Browsers numbers. How do the two numbers relate to each other?

Other Unidentified 7.804 % (283)* *of it 625 Spider

See attached.

I got these errors:

Anyone could help?
Thank's...

When did you get the error? It looks like you may have a table prefix issue but I'm guessing.

When visit url mydomain/statistik.php
I check all table prefix seems ok but I still got that, :(

In statistik.php

search for

replace it with
I think you found this 2 or 3 times.

PcFreak

Thank's...
Work fine now ;)

I'm getting this error during the install phase:

Hmmm, the statistik main page works, except from the visitors count since the stat started.
All stays 0, also on the other statistik pages, all values stay zero, as if they don't get counted?


Any idea's? :)

I am getting the same errors.. Its either the one you are getting or I get a

Database error in vBulletin 3.0.1:

Invalid SQL:
INSERT INTO vb3_ statistik_laender VALUES (1, 'ac', 'United Kingdom Academic Institutions', 'images/statistik/flaggen/ascension.gif', 'images/statistik/bar1.gif', 0, 0)

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 'statistik_laender VALUES (1, 'ac', 'United Kingdom Academic Ins

mysql error number: 1064

I saw one other guy post about this, but he never got his question answered.. PCFreak, what could be causing this?

Josh

Okay I figured out all these problems.. PC Freak.. First of all, great program.. I know its hard translating. It took me a while, but you are missing ALOT of " TABLE_PREFIX" where there should be. Another thing is the "Thread of Thread" change you mentioned earlier.

Finally, the last error I received is because in your install_Statistik_English.php file. You put a space where there shouldn't be this totally freaked MySql out...

You had " statistik_laender VALUES Should be "statistik_laender VALUES

If you make these changes, your install will be perfect!! I have one other question though.. The browser stuff didn't refresh information. Everything is 0% is this normal for a while?

Thanks,

Josh

Excellent hack... *clicks install*

I had trouble with the mysql code for the "LIKE 'pm'" section so i just commented out the PM stuff. Anyone else have that problem?

http://forums.pimprig.com/statistik.php

Now your getting all the browser info and referalls and such.. Im not getting those.. What could be the issue?

http://www.cowboys-forum.com/statistik.php

Josh

Glad to see you got this fixed! Is it too much to explain how to fix it? Is there simple way? :)

Something else must be happening for some of you because several days ago I did the install on my Mac test board and then on my BSD production board without one single problem in install on either.

*Most* of the statistics appear to be appropriate/correct. I'm sure the Spiders page isn't correct and there are a couple others I question, but it's an excellent 'hack'.

Guyz, can someone plz give us a fixed install file, a explanation how to make it work or delete this thread from releases forum PLZ :)

thx in advance

All I did was run the install (on 2 platforms) and it works fine (on both). All I did was follow the directions in the zip file.

Have you tried dropping the database fields it creates, deleting the templates it creates and then doing an install from scratch?

I would, but instead of putting the table prefixes I put the prefix in manually, so im afraid it would not work with your database.

In the install file, make sure that EVERY REFERENCE TO A TABLE has the table prefix tag on it. I found that many did not so half the time it was looking for Prefix_statistik_table and the other half of the time it was looking for statistik_table. Of course you have to have one or the other. Plus the reference I made above where MySql 4.X does not like that space on the install page.

Josh

Sorry, my wife and me are moving.
I have no mutch time work on a new installation routine or update the old files.

But i promise, i did this when we finished with our move.

Then i will release the arcade update too.

beg your pardon.

PcFreak

You have forgot to activate the statistic.


To activate the statistic and count your user

add this code at last line in the" phpinclude_start template"

PcFreak

Got mine working fine now as well :classic:

(had only modified one of my php start templates (have multiple styles) :rolleyes: )

Finally installed statistics and it looks great. A few changes and I easily see this being hack of the month. One really stupid question, how do I center it? It's to the right of the screen. Here is an example

http://www.allstarchat.com/forums/statistik.php

Installed perfect with no problems on 3.0.3 GREAT HACK!

An FYI: vBullletin isn't stable on MySQL 4.1 - See http://www.vbulletin.com/forum/showthread.php?t=110339
and
http://bugs.mysql.com/bug.php?id=4302

I get these errors when viewing any stat page besides the main one.

The XML page cannot be displayed
Cannot view XML input using XSL style sheet. Please correct the error and then click the Refresh button, or try again later.

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

End tag 'map' does not match the start tag 'area'. Error processing resource 'http://forums.squareultima.com/statistik.php?do=referer'. Line 71, Position 4

</map>
---^

Maybe it's a IE error because it works in mozilla fine but then again everyone uses IE.

How could i forget that :p

Thanx for this great Quality Hack !

Installed nice on my test forum but if I try to update the settings in the AdminCP, I click Update, it gives me an error message:

I assumed that KirbyDE's post was to make this for admin access only but as there are multiple reoccurances of the "require_once('./global.php');", which one should the change be made after or should it be all of them? (BTW KirbyDE, you have a typo, there should be a "." in front of the "/global.php" :) )
Thanks again! Very nice.

* clicks Install *

Great hack!! installed it with No problem on vb 3.0.3 only dat i dunno in wich phrase im suppose to add the "hack update".

Does anyone knows where i can get the add ons? or they aint out yet?

Can't we finnaly get a working installer for boards using table prefixes?




German: PCFreak, das Script ist cool, aber es funktioniert nicht, wenn man Table Prefixe f?r sein Forum benutzt. Kannst Du das irgendwann mal fixen? Man muss sonst den ganzen Code von Hand ?ndern. Danke


joshskeety, i would love to use your installer ;) It's easier to search and replace your board_prefix with mine ;)

Clicked install .. great hack .. amazing amount of useful information provided.

Only error I get is Can not find phrase "statistik_cp_gespeichert when trying to update in AdminCP

http://www.thetechguys.co.uk/forum/statistik.php

Great hack :)
Installed flawless on our board.
Had some minor problems, but most of them were adressed in this thread.

The phrases go to the "Control Panel Stop Message" as mentioned earlier in this thread.

I see one little problem though. The avatar and profile picture stats are not updating. Anyone else have that problem?

And a suggestion for a future release: please put all text in phrases. That way translation is easy for all languases. I translated manualy to Dutch, but that's to bad for our foreign visitors ;)

Got it fixed after much editing of the code, very hard to explain exactly what. :(

It's a great hack BTW, when it works! :D