array(postRequestParameter('pay_name')), __FILE__, __LINE__);
if (SQL_HASZERONUMS($result)) {
// No entry found so add this line
- SQL_QUERY_ESC("INSERT INTO `{?_MYSQL_PREFIX?}_sponsor_paytypes` (`pay_name`, `pay_rate`, `pay_min_count`, `pay_currency`) VALUES ('%s','%s','%s','%s')",
+ SQL_QUERY_ESC("INSERT INTO `{?_MYSQL_PREFIX?}_sponsor_paytypes` (`pay_name`,`pay_rate`,`pay_min_count`,`pay_currency`) VALUES ('%s','%s','%s','%s')",
array(
postRequestParameter('pay_name'),
convertCommaToDot(postRequestParameter('pay_rate')),
), __FILE__, __LINE__);
// Payment type added!
- $message = getMaskedMessage('ADMIN_SPONSOR_PAYTYPE_ADDED', postRequestParameter('pay_name'));
+ $message = '{%message,ADMIN_SPONSOR_PAYTYPE_ADDED=' . postRequestParameter('pay_name') . '%}';
} else {
// Entry does already exists
- $message = getMaskedMessage('ADMIN_SPONSOR_PAYTYPE_ALREADY', postRequestParameter('pay_name'));
+ $message = '{%message,ADMIN_SPONSOR_PAYTYPE_ALREADY=' . postRequestParameter('pay_name') . '%}';
}
// Free memory
$OUT = '';
foreach (postRequestParameter('id') as $id => $sel) {
// Load entry
- $result = SQL_QUERY_ESC("SELECT `id`, `pay_name`, `pay_rate`, `pay_min_count`, `pay_currency` FROM `{?_MYSQL_PREFIX?}_sponsor_paytypes` WHERE `id`=%s LIMIT 1",
+ $result = SQL_QUERY_ESC("SELECT `id`,`pay_name`,`pay_rate`,`pay_min_count`,`pay_currency` FROM `{?_MYSQL_PREFIX?}_sponsor_paytypes` WHERE `id`=%s LIMIT 1",
array(bigintval($id)), __FILE__, __LINE__);
if (SQL_NUMROWS($result) == 1) {
// Load data
} else {
// Load all payment types
$result = SQL_QUERY("SELECT
- `id`, `pay_name`, `pay_rate`, `pay_min_count`, `pay_currency`
+ `id`,`pay_name`,`pay_rate`,`pay_min_count`,`pay_currency`
FROM
`{?_MYSQL_PREFIX?}_sponsor_paytypes`
ORDER BY