Country Flag Hack (Complete)

Version 2.0 - September 6, 2001 Released
==============================================
http://vbulletin.com/forum/showthrea...threadid=27485

or you can still load v1.0 below

Version 1.0 - September 1, 2001
==============================================
This is the first release of the Country Hack. I've seen many people asking for this hack to be completed. I have changed and added a lot from the original Flag hack by Pingu. Thanks Pingu for the start of this hack!

This is my first hack. Everything should work fine in vBulletin v2.0.x (v2.0.3 has a note below for a different file to edit than in v2.0.1).

Version 1.0 has support for 221 countries and their corresponding flags. The country names are stored by their 2-letter ISO-3166 country codes, with the exception of Scotland which uses '01' because of no known country code (To add other countries that have no country code, use 02, 03, etc). Some countries have the same 2-letter notation because they have the same flag (e.g. many countries like France and UK have territories that use the mainland flag).

I have created large (x by 32) and small (x by 16) icons in .gif format. If you want to put the flag next to the name in the post, get the small icons. If you want to put the flag under the name or
somewhere else in the post, the large ones look better. The flag zips are in the first 2 posts below.


In Version 1.0:
- Support for 221 countries (any more? anyone?)
- Requires adult registrant to choose their country
- Allows existing users to select/change their country
in the 'Edit Profile' form
- Displays country flag on member profile page
- Use template for country list to be pulled anywhere
- Very easy to add new countries

What I'd like to add:
- A way to translate country codes to their appropriate
name to display on the profile page


I don't have a demo board setup yet and mine is still under construction. I have attached a picture:



Bane at TalkLoud has added the Country Flag hack. So I'm using his site as the demo: http://www.talkloud.net/showthread.php?threadid=203

Questions and comments...please post here. Enjoy!

AJ

1 - Add to database-Table user, field named: country
( country varchar(2) NOT NULL )

Before I screw up my database

should the part I insert into "Run SQL query/queries on database" textbox in phpmyadin is

Table user, field named: country
( country varchar(2) NOT NULL )

or do I use the

- Add to database-Table user, field named: country
( country varchar(2) NOT NULL )

when I insert it.

Thanks for the help!

[AJR]

In phpMyAdmin, you can run this query:

ALTER TABLE user ADD country CHAR (2) not null

4 mins on that reply.. not bad

Parse error: parse error in /home/dlrarmy/public_html/forums/register.php on line 93

That was probably my fault... I don't know. I thought I did it right.


Anyways besides in register.php I have the hack installed and it looks really good!

I wonder if the parse error was because of my stars hack?

[AJR]

Looks good Sarge! Got a few hacks installed do ya . For your register error, make sure your register.php looks like this around the line 90's (I put in some code above and below the hack):

PHP Code:

  //MaxPosts by User
  $optionArray = explode(",", $usermaxposts);
  while (list($key, $val) = each($optionArray))
  {
     eval ("\$maxpostsoptions .= \"".gettemplate("modifyoptions_maxposts")."\";");
  }
  $postsdefaultselected = "selected";
// Country Hack
  eval("\$countrytext.= \"".gettemplate("modifyprofile_country")."\";");
// Country Hack End
  // Referrer 


Just make sure you put the eval line for the country hack in the right place.

<!-- Database error in vBulletin: Invalid SQL: INSERT INTO user (userid,username,password,email,parentemail,coppau ser,homepage,icq,aim,yahoo,signature,adminemail,sh owemail,invisible,usertitle,joindate,cookieuser,da ysprune,lastvisit,lastactivity,usergroupid,timezon eoffset,emailnotification,receivepm,emailonpm,opti ons,birthday,maxposts,startofweek,ipaddress,pmpopu p,referrerid,nosessionhash,country) VALUES (NULL,'Kinta Kunte','eeeeee','e@blackman.com','','0','http://www.dlrarmy.com','','','','','1','1','0','Recruit' ,'999421680','1','-1','999421680','999421680','3','0','1','1','1','15 ','1966-3-4','-1','1','209.244.79.18','1','0','1','','','pg')
mysql error: Column count doesn't match value count at row 1
mysql error number: 1136
Date: Sunday 02nd of September 2001 05:08:00 AM
Script: /forums/register.php
Referer: http://www.dlrarmy.com/forums/register.php

I changed it and this is what I got..

Want me to send you the register file so you can look it over? I know this has to do because I have hacked the sheettz out of my forums.

My users are digging this hack by the way
Thanks
Sarge

[AJR]

Just read what the error is telling you... field mismatch - means either there are too many column names, or too many values. After matching them up, you have too many values trying to be inserted into the database.

It looks like you have the stars hack installed because the extra spaces are the ,'','', below from the error message:

'1','','','pg')

If you have the stars hack installed, make sure on the $DB_site->query line just before VALUES you have the following:

nosessionhash,starlevel,starimg,country)

Currently you only have:

nosessionhash,country)

If you don't get what I mean let me know.

[Afterburner]

nice hack

Originally posted by AJR
Just read what the error is telling you... field mismatch - means either there are too many column names, or too many values. After matching them up, you have too many values trying to be inserted into the database.

It looks like you have the stars hack installed because the extra .

I just emailed you bro.
Thnks for doing this hack i have been waiting a long time for this
Thanks
Sarge