* -------------------------------------------------------------------- *
* Copyright (c) 2003 - 2009 by Roland Haeder *
* Copyright (c) 2009, 2010 by Mailer Developer Team *
* -------------------------------------------------------------------- *
* Copyright (c) 2003 - 2009 by Roland Haeder *
* Copyright (c) 2009, 2010 by Mailer Developer Team *
// Add description as navigation point
addMenuDescription('admin', __FILE__);
// Add description as navigation point
addMenuDescription('admin', __FILE__);
$submit = '{--ADMIN_COUNTRY_DELETE_NOW--}';
$title = '{--ADMIN_COUNTRY_DELETE_TITLE--}';
$reset = '';
}
// Edit all selected country codes
$submit = '{--ADMIN_COUNTRY_DELETE_NOW--}';
$title = '{--ADMIN_COUNTRY_DELETE_TITLE--}';
$reset = '';
}
// Edit all selected country codes
- $result = SQL_QUERY_ESC("SELECT code, descr FROM `{?_MYSQL_PREFIX?}_countries` WHERE `id`=%s LIMIT 1",
+ $result = SQL_QUERY_ESC("SELECT `id`, `code`, `descr` FROM `{?_MYSQL_PREFIX?}_countries` WHERE `id`=%s LIMIT 1",
array(bigintval($id)), __FILE__, __LINE__);
if (SQL_NUMROWS($result) == 1) {
// Load data
array(bigintval($id)), __FILE__, __LINE__);
if (SQL_NUMROWS($result) == 1) {
// Load data
- list($code, $descr) = SQL_FETCHROW($result);
- SQL_FREERESULT($result);
-
- // Prepare data, load row template and switch colors
- $content = array(
- 'id' => $id,
- 'code' => $code,
- 'descr' => $descr,
- 'sw' => $SW,
- );
+ $content = SQL_FETCHARRAY($result);
// Insert row template and switch color
$OUT .= loadTemplate($row, true, $content);
// Insert row template and switch color
$OUT .= loadTemplate($row, true, $content);
// 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__);
// 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__);
// Load row template and switch colors
$OUT .= loadTemplate('admin_list_country_row', true, $content);
// Load row template and switch colors
$OUT .= loadTemplate('admin_list_country_row', true, $content);