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!

[orca]

If you update, the template modifyprofile_country is deleted if you ran the query. Just redo the template.
This works, I just did it on my site.

[webhost]

It worked fine for me without any changes, if you read through this post it states somewhere in here to change it from a custom template to a main template which I did, when I dumped my old database and restored template followed.

[orca]

I had it also as custom template...it was removed anyway after running the update script.

[Mark Hewitt]

I've just reinstalled it in 2.2.0, no problems at all. And no template changes required!

[xug]

When you have looked well why you was copying and pasting some of this great hack in vb2.2.0 you would have seen that there are now some functions that will not work properly.

Old hack text :
// Country Hack Replace
// $DB_site->query("INSERT INTO user (userid,username,password,email,".$newstylefield." parentemail,coppauser,homepage ,icq,aim,yahoo,signature,adminemail,showemail,invi sible,usertitle,joindate,cooki euser,daysprune,lastvisit,lastactivity,usergroupid ,timezoneoffset,emailnotificat ion,receivepm,emailonpm,options,birthday,maxposts, startofweek,ipaddress,pmpopup, referrerid,nosessionhash) VALUES (NULL,'".addslashes(htmlspecialchars($username))." ','".addslashes($password)."', '".addslashes(htmlspecialchars($email))."',".$news tyleval."'".addslashes(htmlspe cialchars($parentemail))."','$coppauser','".addsla shes(htmlspecialchars($homepag e))."','".addslashes(htmlspecialchars($icq))."','" .addslashes(htmlspecialchars($ aim))."','".addslashes(htmlspecialchars($yahoo))." ','".addslashes($signature)."' ,'$adminemail','$showemail','$invisible','".addsla shes($usertitle)."','".time(). "','$cookieuser','".addslashes($prunedays)."','".t ime()."','".time()."','$newuse rgroupid','".addslashes($timezoneoffset)."','$emai lnotification','$receivepm','$ emailonpm','$options','".addslashes($birthday)."', '".addslashes($umaxposts)."',' ".addslashes($startofweek)."','".addslashes($ipadd ress)."','$pmpopup','".addslas hes($testreferrerid['userid'])."','$nosessionhash')");
$DB_site->query("INSERT INTO user (userid,username,password,email,".$newstylefield." parentemail,coppauser,homepage ,icq,aim,yahoo,signature,adminemail,showemail,invi sible,usertitle,joindate,cooki euser,daysprune,lastvisit,lastactivity,usergroupid ,timezoneoffset,emailnotificat ion,receivepm,emailonpm,options,birthday,maxposts, startofweek,ipaddress,pmpopup, referrerid,nosessionhash,country) VALUES (NULL,'".addslashes(htmlspecialchars($username))." ','".addslashes($password)."', '".addslashes(htmlspecialchars($email))."',".$news tyleval."'".addslashes(htmlspe cialchars($parentemail))."','$coppauser','".addsla shes(htmlspecialchars($homepag e))."','".addslashes(htmlspecialchars($icq))."','" .addslashes(htmlspecialchars($ aim))."','".addslashes(htmlspecialchars($yahoo))." ','".addslashes($signature)."' ,'$adminemail','$showemail','$invisible','".addsla shes($usertitle)."','".time(). "','$cookieuser','".addslashes($prunedays)."','".t ime()."','".time()."','$newuse rgroupid','".addslashes($timezoneoffset)."','$emai lnotification','$receivepm','$ emailonpm','$options','".addslashes($birthday)."', '".addslashes($umaxposts)."',' ".addslashes($startofweek)."','".addslashes($ipadd ress)."','$pmpopup','".addslas hes($testreferrerid['userid'])."','$nosessionhash','".addslashes($country)."')" );
// Country Hack End

Must be :
// Country Hack Replace
// $DB_site->query("INSERT INTO user (userid,username,password,email,".$newstylefield." parentemail,coppauser,homepage ,icq,aim,yahoo,signature,adminemail,showemail,invi sible,usertitle,joindate,cooki euser,daysprune,lastvisit,lastactivity,usergroupid ,timezoneoffset,emailnotificat ion,receivepm,emailonpm,options,birthday,maxposts, startofweek,ipaddress,pmpopup, referrerid,nosessionhash,avatarid) VALUES (NULL,'".addslashes(htmlspecialchars($username))." ','".addslashes($password)."', '".addslashes(htmlspecialchars($email))."',".$news tyleval."'".addslashes(htmlspe cialchars($parentemail))."','$coppauser','".addsla shes(htmlspecialchars($homepag e))."','".addslashes(htmlspecialchars($icq))."','" .addslashes(htmlspecialchars($ aim))."','".addslashes(htmlspecialchars($yahoo))." ','".addslashes($signature)."' ,'$adminemail','$showemail','$invisible','".addsla shes($usertitle)."','".time(). "','$cookieuser','".addslashes($prunedays)."','".t ime()."','".time()."','$newuse rgroupid','".addslashes($timezoneoffset)."','$emai lnotification','$receivepm','$ emailonpm','$options','".addslashes($birthday)."', '".addslashes($umaxposts)."',' ".addslashes($startofweek)."','".addslashes($ipadd ress)."','$pmpopup','".addslas hes($testreferrerid['userid'])."','$nosessionhash','$avatarid')");
$DB_site->query("INSERT INTO user (userid,username,password,email,".$newstylefield." parentemail,coppauser,homepage ,icq,aim,yahoo,signature,adminemail,showemail,invi sible,usertitle,joindate,cooki euser,daysprune,lastvisit,lastactivity,usergroupid ,timezoneoffset,emailnotificat ion,receivepm,emailonpm,options,birthday,maxposts, startofweek,ipaddress,pmpopup, referrerid,nosessionhash,avatarid,country) VALUES (NULL,'".addslashes(htmlspecialchars($username))." ','".addslashes($password)."', '".addslashes(htmlspecialchars($email))."',".$news tyleval."'".addslashes(htmlspe cialchars($parentemail))."','$coppauser','".addsla shes(htmlspecialchars($homepag e))."','".addslashes(htmlspecialchars($icq))."','" .addslashes(htmlspecialchars($ aim))."','".addslashes(htmlspecialchars($yahoo))." ','".addslashes($signature)."' ,'$adminemail','$showemail','$invisible','".addsla shes($usertitle)."','".time(). "','$cookieuser','".addslashes($prunedays)."','".t ime()."','".time()."','$newuse rgroupid','".addslashes($timezoneoffset)."','$emai lnotification','$receivepm','$ emailonpm','$options','".addslashes($birthday)."', '".addslashes($umaxposts)."',' ".addslashes($startofweek)."','".addslashes($ipadd ress)."','$pmpopup','".addslas hes($testreferrerid['userid'])."','$nosessionhash','$avatarid','".addslashes($c ountry)."')");
// Country Hack End

At the end off both lines the '$avatarid' needs to be inserted in the script for vb2.2.0, because when you have copied this part from the vb2.0.3 hack version it's not available

This was just what i found in a flash and maybe there are more things that needs to be adjusted !!

My $0.02

[Logtenberg]

When trying to view a members profile I get this error (Just installed flag hack)

Database error in vBulletin: Invalid SQL: UPDATE user SET profileviews=profileviews+1 WHERE userid=4196
mysql error: Unknown column 'profileviews' in 'field list'
mysql error number: 1054
Date: Wednesday 07th of November 2001 07:59:46 PM
Script: /forum/member.php?s=&action=getinfo&userid=4196
Referer: http://66.78.40.13/forum/showthread....oto=nextnewest

Anyone know the problem?

Also - I noticed that when I edited the required files and saved them, the size of the files would always increase be 2 or more kilobytes. Where did this extra size come from? (I am using windows 2000 and am editing the files in wordpad)

[webhost]

looks like u need to add a field to the user table

[Logtenberg]

What field would that be? did I miss a step?

[webhost]

Unknown column 'profileviews' in 'field list'

place that profileviews has a new field in your user table, should say smth in the instructions

[xug]

Is this hack working on V2.2.0 or not ?????