// Add new code?
if ((isFormSent('add')) && (isPostRequestParameterSet('code')) && (isPostRequestParameterSet('descr'))) {
// Check if country code does already exist
- $result = SQL_QUERY_ESC("SELECT `id` FROM `{?_MYSQL_PREFIX?}_countries` WHERE code='%s' LIMIT 1",
+ $result = SQL_QUERY_ESC("SELECT `id` FROM `{?_MYSQL_PREFIX?}_countries` WHERE `code`='%s' LIMIT 1",
array(strtoupper(postRequestParameter('code'))), __FILE__, __LINE__);
if (SQL_HASZERONUMS($result)) {
// Save entry
- SQL_QUERY_ESC("INSERT INTO `{?_MYSQL_PREFIX?}_countries` (code, descr, is_active) VALUES ('%s','%s','%s')",
+ SQL_QUERY_ESC("INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('%s','%s','%s')",
array(
- strtoupper(substr(postRequestParameter('code'), 0, 2)),
- postRequestParameter('descr'),
- postRequestParameter('is_active')
+ strtoupper(substr(postRequestParameter('code'), 0, 2)),
+ postRequestParameter('descr'),
+ postRequestParameter('is_active')
), __FILE__, __LINE__);
// Country added
$content['is_active'] = generateOptionList('/ARRAY/', array('Y', 'N'), array('{--YES--}', '{--NO--}'), $isActive);
} else {
// Only display status when in delete-mode
- $content['is_active'] = translateYesNo($isActive);
+ $content['is_active'] = '{%pipe,translateYesNo=' . $isActive . '%}';
}
// Insert row template and switch color
// Load main template
loadTemplate('admin_list_country_form', false, $content);
- }
+ } // END - if
} else {
// Shall we modify / remove entries now?
- $message = ''; initSqls();
+ $message = '';
+ initSqls();
if ((isPostRequestParameterSet('modify')) && (isPostRequestParameterSet('id'))) {
// Modify
foreach (postRequestParameter('id') as $id => $sel) {