X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Fmodules%2Fadmin%2Fwhat-list_country.php;h=780a8f392c65b350b6934b77c84a0c933b9199fe;hp=e3f0ab16e972711fffb6042abacf817063f3ddc7;hb=5071030af40e69ca4284642f44758964e18f5be8;hpb=3dc2d90bb1fb18124d214dd0aa06f0d3489393e6 diff --git a/inc/modules/admin/what-list_country.php b/inc/modules/admin/what-list_country.php index e3f0ab16e9..780a8f392c 100644 --- a/inc/modules/admin/what-list_country.php +++ b/inc/modules/admin/what-list_country.php @@ -49,15 +49,15 @@ ADD_DESCR('admin', __FILE__); if ((REQUEST_ISSET_POST(('add'))) && (REQUEST_ISSET_POST(('code'))) && (REQUEST_ISSET_POST(('descr')))) { // Check if country code does already exist $result = SQL_QUERY_ESC("SELECT `id` FROM `{!_MYSQL_PREFIX!}_countries` WHERE code='%s' LIMIT 1", - array(strtoupper(REQUEST_POST('code'))), __FILE__, __LINE__); + array(strtoupper(REQUEST_POST('code'))), __FILE__, __LINE__); if (SQL_NUMROWS($result) == 0) { // Save entry SQL_QUERY_ESC("INSERT INTO `{!_MYSQL_PREFIX!}_countries` (code, descr, is_active) VALUES ('%s','%s','%s')", - array( - strtoupper(substr(REQUEST_POST('code'), 0, 2)), - REQUEST_POST('descr'), - REQUEST_POST('is_active') - ), __FILE__, __LINE__); + array( + strtoupper(substr(REQUEST_POST('code'), 0, 2)), + REQUEST_POST('descr'), + REQUEST_POST('is_active') + ), __FILE__, __LINE__); // Country added $message = sprintf(getMessage('ADMIN_COUNTRY_ADDED'), strtoupper(REQUEST_POST('descr'))); @@ -105,7 +105,7 @@ if ((REQUEST_ISSET_POST(('add'))) && (REQUEST_ISSET_POST(('code'))) && (REQUEST_ foreach (REQUEST_POST('id') as $id => $status) { // Load data from DB $result = SQL_QUERY_ESC("SELECT code, descr FROM `{!_MYSQL_PREFIX!}_countries` WHERE `id`=%s LIMIT 1", - array(bigintval($id)), __FILE__, __LINE__); + array(bigintval($id)), __FILE__, __LINE__); if (SQL_NUMROWS($result) == 1) { // Load data list($code, $descr) = SQL_FETCHROW($result); @@ -172,7 +172,7 @@ if ((REQUEST_ISSET_POST(('add'))) && (REQUEST_ISSET_POST(('code'))) && (REQUEST_ // Load currenty setup country codes to list $result = SQL_QUERY('SELECT id, code, descr, is_active FROM `{!_MYSQL_PREFIX!}_countries` ORDER BY code', - __FILE__, __LINE__); + __FILE__, __LINE__); if (SQL_NUMROWS($result) > 0) { // List all countries $OUT = ''; $SW = 2;