X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Flibs%2Fcountry_functions.php;h=c5d341e8487ee1d776fcdfc16ff8aac1672fd9b3;hb=b5cc7a564aee39e995b64c3db502b02ef20379bd;hp=30b1cfec4f6937f0ccf302e95344d3d83c2d8d8c;hpb=5bdeaf8b452206598b6c6cd4f941145b11a0eccc;p=mailer.git diff --git a/inc/libs/country_functions.php b/inc/libs/country_functions.php index 30b1cfec4f..c5d341e848 100644 --- a/inc/libs/country_functions.php +++ b/inc/libs/country_functions.php @@ -10,9 +10,14 @@ * -------------------------------------------------------------------- * * 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 * + * Copyright (c) 2003 - 2009 by Roland Haeder * * For more information visit: http://www.mxchange.org * * * * This program is free software; you can redistribute it and/or modify * @@ -33,27 +38,26 @@ // Some security stuff... if (!defined('__SECURITY')) { - $INC = substr(dirname(__FILE__), 0, strpos(dirname(__FILE__), "/inc") + 4) . "/security.php"; - require($INC); -} + die(); +} // END - if // Generate a human-readable country description with code -function COUNTRY_GENERATE_INFO ($id) { +function generateCountryInfo ($id) { + // Not found is the default + $ret = getMessage('COUNTRY_404'); + // Load code and description - $result = SQL_QUERY_ESC("SELECT code, descr FROM `{!_MYSQL_PREFIX!}_countries` WHERE id=%s LIMIT 1", - array(bigintval($id)), __FILE__, __LINE__); + $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); + $content = SQL_FETCHARRAY($result); // Construct human-readable description - $ret = sprintf("%s (%s)", $descr, $code); - } else { - // Not found! - $ret = COUNTRY_NOT_FOUND; - } + $ret = sprintf("%s (%s)", $content['descr'], $content['code']); + } // END - if // Free the result SQL_FREERESULT($result); @@ -61,5 +65,6 @@ function COUNTRY_GENERATE_INFO ($id) { // Return info return $ret; } -// + +// [EOF] ?>