X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Flibs%2Fcountry_functions.php;h=ec76f25c1e8430b05b1498dad49d796a248b3828;hb=46f2e389417a40f1029612b58cb285416ccae7a5;hp=be8658bd2a294e0cd28d7853fd3403c227f019dd;hpb=43885129ac24cee5545a8a5ad51e90aa182fdf46;p=mailer.git diff --git a/inc/libs/country_functions.php b/inc/libs/country_functions.php index be8658bd2a..ec76f25c1e 100644 --- a/inc/libs/country_functions.php +++ b/inc/libs/country_functions.php @@ -10,7 +10,12 @@ * -------------------------------------------------------------------- * * Kurzbeschreibung : Funktionen fuer den Newsletter an die Gaeste * * -------------------------------------------------------------------- * - * * + * $Revision:: $ * + * $Date:: $ * + * $Tag:: 0.2.1-FINAL $ * + * $Author:: $ * + * Needs to be in all Files and every File needs "svn propset * + * svn:keywords Date Revision" (autoprobset!) at least!!!!!! * * -------------------------------------------------------------------- * * Copyright (c) 2003 - 2008 by Roland Haeder * * For more information visit: http://www.mxchange.org * @@ -32,28 +37,32 @@ ************************************************************************/ // Some security stuff... -if (ereg(basename(__FILE__), $_SERVER['PHP_SELF'])) -{ +if (!defined('__SECURITY')) { $INC = substr(dirname(__FILE__), 0, strpos(dirname(__FILE__), "/inc") + 4) . "/security.php"; require($INC); } -// -function COUNTRY_GENERATE_INFO($ID) -{ - $result = SQL_QUERY_ESC("SELECT code, descr FROM "._MYSQL_PREFIX."_countries WHERE id=%s LIMIT 1", - array(bigintval($ID)), __FILE__, __LINE__); - if (SQL_NUMROWS($result) == 1) - { + +// Generate a human-readable country description with code +function COUNTRY_GENERATE_INFO ($id) { + // Load code and description + $result = SQL_QUERY_ESC("SELECT code, descr FROM `{!_MYSQL_PREFIX!}_countries` WHERE id=%s LIMIT 1", + array(bigintval($id)), __FUNCTION__, __LINE__); + + // Is there an entry? + if (SQL_NUMROWS($result) == 1) { + // Load entry list($code, $descr) = SQL_FETCHROW($result); - SQL_FREERESULT($result); - $ret = $descr." (".$code.")"; - } - else - { + + // Construct human-readable description + $ret = sprintf("%s (%s)", $descr, $code); + } else { // Not found! $ret = COUNTRY_NOT_FOUND; } + // Free the result + SQL_FREERESULT($result); + // Return info return $ret; }