array(postRequestParameter('catname')), __FILE__, __LINE__);
if (SQL_HASZERONUMS($result)) {
// Category does not exists, we simply add it...
- SQL_QUERY_ESC("INSERT INTO `{?_MYSQL_PREFIX?}_cats` (`cat`, `visible`, `sort`) VALUES ('%s','%s','%s')",
+ SQL_QUERY_ESC("INSERT INTO `{?_MYSQL_PREFIX?}_cats` (`cat`,`visible`,`sort`) VALUES ('%s','%s','%s')",
array(
postRequestParameter('catname'),
postRequestParameter('visible'),
} // END - switch
} else {
// Entry not saved
- $TEXT .= getMaskedMessage('ADMIN_CATEGORY_NOT_SAVED', $id);
+ $TEXT .= '{%message,ADMIN_CATEGORY_NOT_SAVED=' . $id . '%}';
}
} // END - foreach
$OUT = '';
foreach (postRequestParameter('sel') as $id => $value) {
// Load data from the category
- $result = SQL_QUERY_ESC("SELECT `id`, `visible`, `sort` FROM `{?_MYSQL_PREFIX?}_cats` WHERE `id`=%s LIMIT 1",
+ $result = SQL_QUERY_ESC("SELECT `id`,`visible`,`sort` FROM `{?_MYSQL_PREFIX?}_cats` WHERE `id`=%s LIMIT 1",
array(bigintval($id)), __FILE__, __LINE__);
$content = SQL_FETCHARRAY($result);
$CATS = '';
// Load all categories
- $result = SQL_QUERY("SELECT `id`, `cat`, `visible`, `sort` FROM `{?_MYSQL_PREFIX?}_cats` ORDER BY `sort` ASC", __FILE__, __LINE__);
+ $result = SQL_QUERY("SELECT `id`,`cat`,`visible`,`sort` FROM `{?_MYSQL_PREFIX?}_cats` ORDER BY `sort` ASC", __FILE__, __LINE__);
if (!SQL_HASZERONUMS($result)) {
// Init variables
$OUT = '';