[akanevsky]

FAQ
READ BEFORE YOU ASK QUESTIONS!!!
IF YOU ASK A QUESTION THAT'S ALREADY BEEN ANSWERED IN THIS POST, THAT'S BEEN ANSWERED MULTIPLE TIMES IN GENERAL, OR IF YOU ASK SAME QUESTION MORE THAN ONCE, YOU WLL BE ADDED TO IGNORE LIST!!!

Q: I am using vB 3.5.3 and am receiving an error about "UNLOCK TABLES".
A: Read: http://www.vbulletin.com/forum/bugs3...iew&bugid=2056

Q: How do I install the product XML?
A: http://www.vbulletin.com/docs/html/plugin_system

Q: How do I upgrade?
A: Find the last one of the "Upgrade: X.Y.Z" posts which contain banana and large font in them. Those posts contain upgrade instructions from the "X.Y.Z-1" version. Which means that you need to find each of those posts that came out since your last upgrade.

Q: How do I hide a certain part that I don't need?
A: You edit any of the psistats_yaddayadda templates to your needs.

Q: Stats do not get updated.
A: Stats are updated once every 15 minutes (not instantly).

Q: Can I limit viewing of the stats to certain usergroups?
A: Yes, using hack options which are located under vBulletin Options -> psiStats 2006

Q: I get a LOCK TABLES error...
A: Make sure you have set proper permissions for the MySQL user. To find out how to set MySQL permissions, contact your hosting provider.

Q: It's not tracking full referrer URLs, only domains.
A: That's how it is designed. It will not be changed.

Q: A country flag is missing.
A: I know. If you have the flag, please send it to me, otherwise there is nothing I can do.

Q: I have upgraded to 1.3.0 (or higher), and now I receive the following error: TABLE psistats_country does not exist.
A: Make sure that you have cancelled the changes done to class_core.php prior to version 1.3.0 of this hack.

Q: I have ____ hack and yours isn't working properly with it.
A: I do not provide support for 3rd party hacks.

Q: This and that isn't working properly...
A: Shh! First, make sure that you have the latest version installed, and doble check that you have done all the steps correctly. If you are 100% sure in both, post your problem.

[Yorixz]

Originally Posted by Psionic Vision

@Yorixz
>> On the toplist page it's totally ignoring the max amount I set to list for the Most viewed/Most replied collumn, it is actually following it for the Top forums though.
What? It uses the same number that you set in admincp for top threads/forums...

The file you attached didn't for me, the one that other user attached on page 7 or so did.

>>The link on the country page of Iceland links to a page about Isreal.
The link of Croatia links to Coral Sea Islands.
The link of Andorra doesn't exist.
Theres a continent without a phrase
There is a country without a phrase (this image: )

Please provide the problematic country codes.

Isreal: http://www.cia.gov/cia/publications/.../print/il.html (Missing)
Iceland: http://www.cia.gov/cia/publications/.../print/is.html (wrong one)
Andorra: http://www.cia.gov/cia/publications/.../print/ad.html (Missing)
Bosnia: http://www.cia.gov/cia/publications/.../print/ba.html (wrong one)
Bahrain: http://www.cia.gov/cia/publications/.../print/ba.html (wrong one apparently, never heard of any of these two)
Chile: http://www.cia.gov/cia/publications/.../print/cl.html (missing)
Puerto Rico: http://www.cia.gov/cia/publications/.../print/pr.html (missing)
Slovakia: http://www.cia.gov/cia/publications/.../print/sk.html (missing)

That's about the list I got so far, didn't check them all though. Maybe it's an idea to link to Wikipedia instead because are there so many things missing in that 'factbook'.

[akanevsky]

They are not "missing", they simply have invalid codes in the country database for some reason. I fixed those.

[firstrebel]

Is some of this thread missing?

Bob

[akanevsky]

I asked the moderator to clean up the thread, so it's ok. I have extracted a list of countries which are incorrectly mapped. So it'll be some time until I remap them.

From now on, please do not post pointless posts in this thread, as it is harder for me to follow up with the problems. Please only reply with either bug reports (and do so only once per bug), or testimonials. Thanks.

[akanevsky]

Here is a list of abbreviations that do not match, and potentially need to be remapped:

Block Disabled:      (Update License Status)
Suspended or Unlicensed Members Cannot View Code.

Kind of long, isn't it?

Option #1: A couple of volunteers could help me do the actual remap, which would be easy using Search&Replace program.
Pros: None. Cons: All script country databases known to me use the same abbr's as the current ones. All online country databases use the same abbr as cia.gov, or they use something completely different; It would be hard to update the database.

Option #2: Find a website that has acceptable information about countries and that uses matching abbreviations.
Pros: No works involved. Cons: CIA has the fullest list of countries, and perhaps the most valid ones.

Option #3: Simply insert the CIA data into the database.
Pros: No work required, is relatively simple in comparison with #1. Cons: A bit more storage space (negligible).

Block Disabled:      (Update License Status)
Suspended or Unlicensed Members Cannot View Code.

[akanevsky]

Alright, I choose option 3 then.

[MPDev]

Okay, on the top stats page, I get 0's for the threadcount and replycount total variables.

[akanevsky]

Are you speaking about Top Forums?

[MPDev]

Yes.

[Kihon Kata]

What do you mean.... 'so it's ok'? 'Clean up the thread'? You mean like delete like 95% of it.

WTF, my issues were deleted AND unanswered? This seems a little strange. And no, I don't think you code 24/7

[Yorixz]

Originally Posted by Psionic Vision

Alright, I choose option 3 then.

Like I already suggested; why not simply use Wikipedia? If you link to http://en.wikipedia.org/wiki/$countryname then the link is correct in 99% of the cases, you probably just need to convert spaces to underscores and then you're done - no need to worry about all the abbrevations.

[akanevsky]

Yes.

That'll be looked into.

WTF, my issues were deleted AND unanswered?

I thought I asked to post only to the point, and only once per issue. I thought I also said that I read everything. If the latter be true, you should be sure that your post was read too. If I am not replying, it only means that I know what causes the issue and how to fix it, and thus do not feel the need to discuss anything. Please also remember that this is a free hack and I am therefore not obliged neither to you nor to anyone else, to even support the hack.

If you'd like to receive any further support, you gotta calm yourself down and express yourself more diplomatically. Otherwise, feel free to uninstall my hack, because next time you are going into my ignore list.

Like I already suggested; why not simply use Wikipedia?

Wikipedia contains too much extra data, and it has 99% of the countries rather than 100%. In addition, wikipedia is an open encyclopedy, the contents of which can be modified by anyone. Therefore, wikipedia is not a reliable source - unlike cia.gov, which has - or is supposed to have - 100% correct information. I am going to simply add cia abbreviations into counrty database, in addition to "native" abbreviations.

[Kihon Kata]

Originally Posted by Psionic Vision

That'll be looked into.If you'd like to receive any further support, you gotta calm yourself down and express yourself more diplomatically. Otherwise, feel free to uninstall my hack, because next time you are going into my ignore list.

Don't worry, I am uninstalling this hack since I never received support ANYHOW. I personally do not need a teenager telling me to calm down or threats of adding me to ignore list. Advice, concentrate and focus your engergy on fixing your releases rather than worrying about getting a moderator to delete unanswered posts OR telling people to calm down with threats of ignoring. I don't know who you think you are with statements like that. I can see your immaturity shining here. Uninstalls