Country Flag Hack v2.0

UPDATED TO v2.1 - 3/11/2002

Version 2.1 - March 11, 2002
================================================== ==
Well, it's been awhile! I sorta disappeared there while
doing many other things! I guess v2.0 that was supposed
to use the same images as vBStats didn't go as planned
(thanks Bane ). I removed this hack from my site
awhile ago when I was having some other problems. I have
finally decided to add it back and it worked great in 2.2.0,
and I'm sure it will work in all other 2.2.x versions.

Changes:
- Updated to work with vBulletin 2.2.x
- Added Display Flag in Member List - Thanks Orca
- Used slightly larger flag images by X-Fan (I did run
them through Ulead's 16-color optimization which cut
the total file size from 271K to 54K!)
- Added 'align="absmiddle"' to image tag for text vertical centering
- Fixed Bane's name in docs below where I botched it up!
- Support for 280 Countries


Version 2.0 - September 6, 2001
================================================== ==
Changes from v1.0:
- Images have been changed from country codes to country names
- Flags will now have their ALT text as country name.
- Modified Hack to work with Bane's vbStats hack that will be released in the future.
- Added CP Addon by Stasik and modded it for new country names
- Changed country field in USER table from CHAR(2) to VARCHAR(50)
- Support for 226 countries

Known Problems:
- Countries with a dash (-) or comma (,) will not show up
automatically in as selected when you or the member edit
their profile (Congo, Korea, and Micronesia are the only 3)
Anyone know a fix please let me know.
- The 'modifyprofile_country' template needs to be changed
to a default original templatesetid of -1 (changed templates
have the templatesetid set to 2) or else the Admin CP addon
will not work (Any ideas why?). To do this, use phpMyAdmin
and run this query:
UPDATE template SET templatesetid="-1" where title="modifyprofile_country"
This will move the template from the custom to default templates
and will be found in the 'User Option Templates' group.

Any questions or comments can be posted here. Enjoy!

Database error in vBulletin Control Panel: Invalid SQL: ALTER TABLE user ADD
country VARCHAR (50) NOT NULL

mysql error: Duplicate column name 'country'
mysql error number: 1060
Date: Friday 21st of September 2001 02:24:11 PM
Script: /forums/admin/flag.php?
Referer:

[AJR]

You only need to run flag.php ONCE! This will create the field for country in the user table. After that you DON'T run flag.php again! Delete flag.php!

Make sure you have followed the rest of the instructions in the .txt file. All the php files that were edited need to be uploaded and everything should be working!

i tried replacing all the files with default and the same problem persist.

[AJR]

First of all, you need to get ONE hack working before you start another. You seem to be simultaneously working on 2 hacks (Country Flag and Astrological Sign) and getting errors from one, the other, or both!!!

i tried replacing all the files with default and the same problem persist.

What do you mean by this?? ?? ?? ?? ?? There are NO files to replace. You need to go to the first post in this thread and download the actual hack. Then you need to read and follow the .txt file as it guides you through editing the .php files it needs to work. Then, after EVERYTHING is followed in the .txt file, if you still have problems, let me know. You are posting in both this and the Astrological Sign hack at the same time which you can't be working on both at the same time... get one working first! Then move on to the next hack!

Originally posted by tkhjosh
i tried replacing all the files with default and the same problem persist.

meaning i uploaded the default .php files example member.php and register.php and ran flag.php again but did not work.

[AJR]

Like I said, if you already ran flag.php, DON'T run it again! The first time you ran it, it added the country field to the user table. Every time you try to run it now, it sees that the country field already exists and will ALWAYS give you an error because it exists. If you made all the changes to the .php files and uploaded them, go to your forum homepage, log in as you, click on the 'User CP' and click on 'Edit Profile'. Look for 'Select your Country' and choose your country from the dropdown list. Submit the modifications and look for one of your posts in the forum. You should see the flag next to your name! Click on your profile and you should see the flag next to your name!

ok i get the options for selecting country, but it is blank! nothing to choose! i think below is what i dont understand, if possible pls explain.

this is from the readme:

*** The 'modifyprofile_country' template needs to be changed
to a default original templatesetid of -1 (changed templates
have the templatesetid set to 2) or else the Admin CP addon
will not show the country select list (Any ideas why?). To do
this, use phpMyAdmin and run this query:
UPDATE template SET templatesetid="-1" where title="modifyprofile_country"
This will move the template from the custom to default templates
and will be found in the 'User Option Templates' group.

hope to hear from u soon.

[AJR]

If you have access to phpMyAdmin, go to it and use the following query:

UPDATE template SET templatesetid="-1" where title="modifyprofile_country"

Otherwise, upload the attached tempchange.php file to your admin directory and execute it like you did with flag.php. Then try going to your Edit Profile and see if the list is there.

nope....sighz...ok

and a problem i cant seem to add the template modifyprofile_country anymore, i tried adding 2 times but its never there, help~

[AJR]

You can't add a 'modifyprofile_country' template anymore because one already exists! By running the tempchange.php, it changed the template from a "custom" to a "default original" template (-1). You will now find the template in the 'User Option Templates' group. Click on expand and you should see the 'modifyprofile_country' template.