// Update all entries
foreach (postRequestElement('sel') as $id => $value) {
// Update database
- SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_must_register` SET `field_required`='%s' WHERE `id`=%s AND `field_required` != '%s' LIMIT 1",
+ sqlQueryEscaped("UPDATE `{?_MYSQL_PREFIX?}_must_register` SET `field_required`='%s' WHERE `id`=%s AND `field_required` != '%s' LIMIT 1",
array(
$value,
bigintval($id),
),__FILE__, __LINE__);
// Get affected rows
- $count += SQL_AFFECTEDROWS();
+ $count += sqlAffectedRows();
} // END - foreach
// Output message for updated entries
} // END - if
// List all register values
-$result = SQL_QUERY("SELECT `id`, `field_name`, `field_required` FROM `{?_MYSQL_PREFIX?}_must_register` ORDER BY `id` ASC", __FILE__, __LINE__);
+$result = sqlQuery("SELECT `id`, `field_name`, `field_required` FROM `{?_MYSQL_PREFIX?}_must_register` ORDER BY `id` ASC", __FILE__, __LINE__);
$OUT = '';
-while ($content = SQL_FETCHARRAY($result)) {
+while ($content = sqlFetchArray($result)) {
// Get language string
$content['field_name'] = '{--' . strtoupper($content['field_name']) . '--}';
} // END - while
// Free memory
-SQL_FREERESULT($result);
+sqlFreeResult($result);
// Load template
loadTemplate('admin_config_register', FALSE, $OUT);