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!

[Talisman]

Thanks, AJR! Ours is an international community, so being able to display our national flags means a lot to everyone.

And thank you, Kira -- I started getting a bit nervous about installing this one and was so happy to see the summary update you posted.

I probably held my breath through the whole thing..... but it works!! What a rush!

[Harken]

hmmm..i installed the country hack..and now when im logged in as admin i see the option in the usercp and it works fine...but if i log in as a registered user..the scroll list is gone in the usercp...but the option for country is still there so its just a blank no bar to scroll or anything. Any ideas?

[Erwin]

Originally posted by Harken
hmmm..i installed the country hack..and now when im logged in as admin i see the option in the usercp and it works fine...but if i log in as a registered user..the scroll list is gone in the usercp...but the option for country is still there so its just a blank no bar to scroll or anything. Any ideas?

You need to run the database query to make the modify_country template default ie. templatesetid=-1

[Harken]

i ran that before and i show it under the User Option Templates....there is 3 of them...weird...should there be only 1 right? but it still doesnt work..

[Erwin]

Delete all of them.

Add a new one.

Then run the query.

[Harken]

ok i deleted it..the one under templates in phpmy admin..but still i have two showing up when i open templates user options under that style...so i can still only see the list as admin...not under any other kind.

[Erwin]

Can't you remove them from your Admin CP in Templates?

[Harken]

no because the only options i c are Change original...unless im missing something..

[TECK]

hmmm is normal there are so many boards out there with all kind of problems and security issues... due to bad code.
i made for you a little script to add and remove safely one or several templates:

<?php
error_reporting(E_ALL);

require('./global.php');

cpheader('<title>Templates</title>');

function dotemplate($title, $template, $templatesetid=-1) {
  global $DB_site;

  $DB_site->query("INSERT INTO template (templateid,templatesetid,title,template) VALUES (NULL,'$templatesetid','" . addslashes($title) . "','" . addslashes($template) . "')");
  echo "Installing $title template... Done.<br>\n";
}

function killtemplate($title, $templatesetid=-1) {
  global $DB_site;

  $DB_site->query("DELETE FROM template WHERE title='" . addslashes($title) . "' AND templatesetid=-1");
  echo "Removing $title template... Done.<br>\n";
}

$DB_site->reporterror = 1;

// add a template
dotemplate('yourtemplatename', 'yourtemplatehtmlcode');

// remove a template
killtemplate('yourtemplatename');

cpfooter();
?>

[Harken]

im sorry but what do i do with that....today has not been my day...