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!

[mashby]

Just wanted to let you know that I followed your directions to a "T" and your hack installed just as described. Although the instructions were lengthy, the result was on the money.

Thanks for making such a GREAT hack!

[212rikanmofo]

the hack works great, but one thing thats not working is the user registering part, when a user submits, it keeps saying please filled all required fields, and ALL fields are filled out... i think it has to do with the registrationadult template, but the dropdown menu where you select your country doesnt even show up at all under the registration form, under enter your email...

here's what part of my registrationadult template looks like:

	<td bgcolor="{secondaltcolor}"><normalfont><b>Email:</b></normalfont><br>
	<smallfont>Please enter a valid email address. You can choose to hide it below in the preferences section.</smallfont></td>
	<td bgcolor="{secondaltcolor}"><normalfont><input type="text" class="bginput" name="email" size="25" maxlength="50"></normalfont></td>
</tr>
<tr>
	<td bgcolor="{secondaltcolor}"><normalfont><b>Enter Email Again:</b></normalfont></td>
	<td bgcolor="{secondaltcolor}"><normalfont><input type="text" class="bginput" name="emailconfirm" size="25" maxlength="50"></normalfont></td>
</tr>
<!-- Country Hack Code Begin -->
<tr>
<td bgcolor={firstaltcolor}><normalfont><b>Select your Country:</b></normalfont><br>
<smallfont>If you select your country, your country flag image will appear next to your name on your posts.</smallfont></td>
<td bgcolor={firstaltcolor}><smallfont>
$countrytext</td>
</tr>
<!-- Country Hack Code End -->
$customfields_required
<!-- *** -->
<tr>
	<td bgcolor="{tableheadbgcolor}" colspan="2"><normalfont color="{tableheadtextcolor}" class="thtcolor"><b>Optional Information</b></normalfont>

why isn't it showing up at all? any reasons, other than that, the hack works great, but i need to fix this, cause it wont let users register cause it keeps saying please fill in all fields, thats cause the dropdown menu for the country isnt even available to them...

[mashby]

Well, I spoke too soon as well. I ran into a similar problem. I'm in the process of removing the hack so that I can get my registeration back. Everything worked, but I got a SQL error everytime someone tried to register.

UPDATE:
Well, after un-installing the hack the error is still there. So, I'm going to have to take more drastic measures to get my board back to 100%. FYI, this is the SQL Error I'm getting.

Database error in vBulletin 2.2.5:

Invalid SQL: INSERT INTO userfield (userid,field5,field6,field7,field1,field2,field3, field4) VALUES (,'Demo
Account','Demo','Demo','','','','')
mysql error: You have an error in your SQL syntax near ''Demo Account','Demo','Demo','','','','')' at line 1

mysql error number: 1064

Date: Thursday 25th of April 2002 02:22:37 AM
Script: http://www.interpug.com/private/foru...m/register.php
Referer: http://www.interpug.com/private/forum/register.php

[mashby]

I downloaded a fresh copy of vBulletin 2.2.5 and uploaded a clean copy of register.php and everything is back to normal. So, obviously something is up with the register.php changes. Too many people are complaining about it to be a fluke, or a typo on the installer's part.

If the register.php worked properly, it would be a GREAT hack.

Does anyone know if I can install everything BUT the register.php changes? I don't really care to make the user choose their flag when they join.

[212rikanmofo]

mashby, i also need a fix for this

something is wrong with the register.php

when i have the hack, when a user registers, there is no drop down box where they can choose there country, it wont show up at all. and therefore they cant register since it's a required field, so i had to take it out, but the rest of the hack works great. just that one fault, is there a fix for this please?

[mashby]

My error was that the register just didn't work. Everything appeared ok, but register.php just didn't work.

Since my problem was a little different. I would check through the code that you have to alter in your templates and in register.php again. It sounds like you may just be missing something in the template you have to create.

[212rikanmofo]

i checked the template so many times, and thats not the problem
... i dont know why its not showing up at all when a user registers

[Erwin]

Make sure you've made the template -1 so that it's default. This hack is temperamental like that. Also make sure that you database inserts in register.php includes the country variable as well.

[Erwin]

Remember, each time you upgrade vB, you need to run the database query again to make that country select list template -1 again. This is the only hack that I know of that requires this.

[212rikanmofo]

i already ran that -1 query already, and what do you mean include register.php? im not understanding, do i have to include it in a template? clarify this for me please...