break;
case 'ref':
- switch (getRequestParameter('do'))
- {
+ switch (getRequestParameter('do')) {
case 'add':
- addSql("INSERT INTO `{?_MYSQL_PREFIX?}_refdepths` (`level`, `percents`) VALUES ('".postRequestParameter('level')."','".postRequestParameter('percents')."')");
+ addSql("INSERT INTO `{?_MYSQL_PREFIX?}_refdepths` (`level`, `percents`) VALUES ('".bigintval(postRequestParameter('level'))."','".bigintval(postRequestParameter('percents'))."')");
break;
case 'edit': // Change entries
// Update entry
SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_refdepths` SET `level`=%s, `percents`=%s WHERE `id`=%s LIMIT 1",
array(bigintval($value), convertCommaToDot(postRequestParameter('percents', $id)), $id), __FILE__, __LINE__);
- }
+ } // END - foreach
$message = '{--ADMIN_REFERAL_DEPTHS_SAVED--}';
break;
foreach (postRequestParameter('id') as $id => $value) {
SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_refdepths` WHERE `id`=%s LIMIT 1",
array(bigintval($id)), __FILE__, __LINE__);
- }
+ } // END - foreach
$message = '{--ADMIN_REFERAL_DEPTHS_DELETED--}';
break;
- }
+ } // END - switch
// Update cache file
// @TODO Rewrite this to a filter
if ((isSqlsValid()) && (isSqlsValid())) {
if (strpos($GLOBALS['sqls'][0], 'INSERT') > -1) {
- $result = SQL_QUERY_ESC("SELECT `id` FROM `{?_MYSQL_PREFIX?}_refdepths` WHERE `level`='%s' LIMIT 1",
+ $result = SQL_QUERY_ESC("SELECT `id` FROM `{?_MYSQL_PREFIX?}_refdepths` WHERE `level`=%s LIMIT 1",
array(bigintval(postRequestParameter('level'))), __FILE__, __LINE__);
SQL_FREERESULT($result);
} // END - if
// Shall we display a message?
if (!empty($message)) {
// When do so...
- loadTemplate('admin_settings_saved', false, $message);
+ displayMessage($message);
} // END - if
} elseif (getRequestParameter('sub') == 'settings') {
// Setup some settings like direct pay and so on