X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Flibs%2Fcountry_functions.php;h=c5d341e8487ee1d776fcdfc16ff8aac1672fd9b3;hb=b5cc7a564aee39e995b64c3db502b02ef20379bd;hp=5af9cbae10a7e787e3e1dba01d6906db1aea84c6;hpb=508228c85fba8448d00865b1639cb8cd7a69e457;p=mailer.git diff --git a/inc/libs/country_functions.php b/inc/libs/country_functions.php index 5af9cbae10..c5d341e848 100644 --- a/inc/libs/country_functions.php +++ b/inc/libs/country_functions.php @@ -10,14 +10,14 @@ * -------------------------------------------------------------------- * * Kurzbeschreibung : Funktionen fuer den Newsletter an die Gaeste * * -------------------------------------------------------------------- * - * $Revision:: 856 $ * + * $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 * @@ -38,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", + $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); @@ -66,5 +65,6 @@ function COUNTRY_GENERATE_INFO ($id) { // Return info return $ret; } -// + +// [EOF] ?>