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!

[webhost]

AJR

Thanks for the update.

Question, I am upgrading, in the new zip file I only see the small flags, I am using the large flags.Do you also have them somewhere laying around with full names like the small flags in your new zip file?

[AJR]

Webhost... I do not have the large flag names converted because the vBStats Hack by Bane, when released, will require the small flags as the same name as the Country Hack.

If you want to use the large flags and don't plan on using the vBStats hack, rename the large flags that you have with the names from the modifyprofile_country template. If I get a chance I'll do it and post them, but it won't be for a day or two. If you are planning on using the vbstats hack, for now you can keep the names as country codes and just use the modifyprofile_country template from v1.0 text file... make sure to only grab from:

<select name="country">
.
.
.
</select></smallfont>

Do not at the <td><smallfont> or </td> before and after since they are being put into the other templates. The plus is you won't have the problem with the 3 countries that have - or ,. The only drawback to this is the ALT name will not be shown as the full country name. If anyone gets time to convert the large flags from country code to country name before I do, please post them here.

[aldamon]

Nevermind, my bad....

Great work! Excellent hack!

Great hack
Thanks a lot

[TheComputerGuy]

I get a dB error on the member.php file when I try to go edit my country

the error is saying that it is sending an email to me...just a slight problem as it says

[Typhon]

This is a great hack... and it works like a charm on my site. I'm currently in the process of converting all the flags to a beveled 30x15 pixels, and I'll post the ZIP files when I get it done. Thanks!

[AJR]

Originally posted by TheComputerGuy
I get a dB error on the member.php file when I try to go edit my country

the error is saying that it is sending an email to me...just a slight problem as it says

And......what was the email that was sent to you (the db error)? That is the key to helping you with your problem.

[TheComputerGuy]

> Database error in vBulletin: Invalid SQL: SELECT country FROM user WHERE
userid=1
> mysql error: Unknown column 'country' in 'field list'
> mysql error number: 1054
> Date: Saturday 08th of September 2001 01:44:45 PM
> Script: /forums/member.php?s=&action=getinfo&find=lastposter&forum id=31
> Referer: http://www.moneytec.com/forums/index.php?s=

[AJR]

Originally posted by TheComputerGuy
> mysql error: Unknown column 'country' in 'field list'

It tells you the problem right in the error message. You didn't do STEP 1 in the country_flag_hack_20.txt file:

STEP 1:
======
In phpMyAdmin, you can run this query to create the country field:
ALTER TABLE user ADD country VARCHAR (50) NOT NULL


If the field 'country' is not there it can't save the country selection!

AJ