He's knows. See my post above for the install script fix attachment. If you don't use "vb3_" as your table prefix, change it globally throughout the file. I could create one for you, but I don't know what you use.

This is not the problem of apokphp !

This error from apokphp results of an not escaped character in that line, sh*t
This was from a translation fix by Zelda-King

apokphp for instance search in the file install_statistic_english.php for:

and replace that by this must be done for 5 instances with the name
$postername1
$postername2
$postername3
$postername4
$postername5

Just change your search to this names and change on each line the 's to \'s

@ Wential
Your table prefix fix is 3 postings before ;)

@Zelda-King
I'm working at the moment at the flag problem and find out that there are 3 countries mixed in the table. It's ID97 Indonesia, ID98 Ireland, ID99 Israel and ID100 Isle of Man. I will fix that also in the next release...

I have used Wentials, and removed the prefix. It works fine.

But as stated previously, I have a problem. I have installed this on 2 servers. One just now, using the latest English translation...works great.

The PROBLEM, is that I installed this a few weeks ago on a different server using the old English translation, which is needing a lot of help with proper translation. How can I uninstall it so I can reinstall w/ the updated install script?

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

Hmm, under the circumstances, the original sentence "View the profile of" is acceptable. It's not actually bad grammar at all. Just, well... the done way is to say "view username's profile".

No problem Zelda, we can fix it with the escaped ' ;)

Thanks apokphp, I will check it

For the deinstallation there is no deinstall script right now, so you have to drop all database tables with statistik_* and also delete all templates with statistic_* and the main template STATISTC.
I requested a deinstallation script from PcFreak (the maker of this hack) a few days ago in the german vbulletin forum but get no answer right now...

I made a list of all the countries that have the 'noflag' problem. It's easy to spot them in install_english.php by doing a text search for noflag.gif. :D

Anguilla, Brunei Darussalam, Bouvet Island, Belarus, Belize, Cocos Keeling Islands, Dem. Rep. Congo, Cote d Ivoire, Cape Verde, Christmas Island, Wesetern Sahara, Falkland Islands, Faroe Islands, French Guiana, Gibraltar, Guadaloupe, Equatorial Guinea, South Georgia and South Sandwich Islands, Guam, Heard and McDonald Islands, Israel, Jersey, Saint Kitts and Nevis, Cayman Islands, Libya, Mali, Northern Mariana Islands, Martinique, Montserrat, Mauritius, New Caledonia, Norfolk, Island, Nepal, Niue, French Polynesia, Saint Pierre and Miquelon, Pitcairn, Qatar, Reunion, Saint Helena, Svalbard and Jan Mayen Islands, San Marino, Sao Tome and Principe, El Salvador, Turks and Caicos Islands, French Southern Territories, Tokelau, East Timor, US Minor Outlying Islands, Saint Vincent and the Grenadines, Virgin Islands British, Wallis and Futuna Islands, Samoa, Mayotte.

Now here's what I DON'T get: I fixed the El Salvador link in the database as a test fix and even though that entry now correctly points to elsalvador.gif, I still see the flag on the stats page as noflag.gif. Weird. :/

Did you reload the page with F5 ????
Try also CTRL + F5 to not use the Internet files cache

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

If you have phpmyadmin installed on your server, just open your database and click on SQL in top and then open the file countryfix_table.txt with your favorite editor, press CTRL + A to mark all and afterwards CTRL +C to copy all.
Go to your phpmyadmin window and press CTRL +V to paste all the data in the SQL field, now press OK to process the new entries.

hope this is fine now, but I have to check also each entry step by step with image name and name of country in compare with functions_statistik.php to be sure all entries are correct.
As Zelda mentioned the El Salvador flag has also a wrong image name in database....

I refreshed. I cleaned my cache. I closed/reopened my browser. Anyway I'll see how this table fix goes.

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

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

lol

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

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

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?

Hmm, 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:

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

to fix it:
open template "statistic_top_poster_bit" and search for:
replace it with:

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

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

here is the requested export of this table

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

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

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

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

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 ;)

c00, I'll add these too :)

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

/me voted

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:

This fixes my size problem ;)

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.

Perfect, thanks :)

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

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

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

It needs .gif putting on the end.

Thanks, can't wait :)

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

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

I click install

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