X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fmodules%2Fadmin%2Fwhat-config_points.php;h=c43f40a6e613bbbcc70495de1430d0485986893b;hb=501a861954273a54a21b714587fc33b57322d8e4;hp=53cbc18472f81738df2793b05152e057a2391392;hpb=1ebf518b9552f71ee95de6f4b80e6de3a27716d1;p=mailer.git diff --git a/inc/modules/admin/what-config_points.php b/inc/modules/admin/what-config_points.php index 53cbc18472..c43f40a6e6 100644 --- a/inc/modules/admin/what-config_points.php +++ b/inc/modules/admin/what-config_points.php @@ -59,7 +59,7 @@ if (isGetRequestElementSet('sub')) { case 'ref': if (isGetRequestElementSet('do')) { - if (((!isPostRequestElementSet(('level'))) || (!isPostRequestElementSet(('perc')))) && (getRequestElement('do') == 'add')) { + if (((!isPostRequestElementSet(('level'))) || (!isPostRequestElementSet(('percents')))) && (getRequestElement('do') == 'add')) { unsetPostRequestElement('ok'); } } @@ -81,20 +81,20 @@ if (isFormSent()) { switch (getRequestElement('do')) { case 'add': - addSql("INSERT INTO `{?_MYSQL_PREFIX?}_refdepths` (level, percents) VALUES ('".postRequestElement('level')."','".postRequestElement('perc')."')"); + addSql("INSERT INTO `{?_MYSQL_PREFIX?}_refdepths` (`level`, `percents`) VALUES ('".postRequestElement('level')."','".postRequestElement('percents')."')"); break; case 'edit': // Change entries foreach (postRequestElement('level') as $id => $value) { - // Secure ID + // Secure id $id = bigintval($id); // Revert german commata - setRequestPostElement('perc', array($id => convertCommaToDot(postRequestElement('perc', $id)))); + setRequestPostElement('percents', array($id => convertCommaToDot(postRequestElement('percents', $id)))); // Update entry - SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_refdepths` SET level='%s', percents='%s' WHERE `id`=%s LIMIT 1", - array(bigintval($value), postRequestElement('perc', $id), $id), __FILE__, __LINE__); + SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_refdepths` SET `level`='%s', `percents`='%s' WHERE `id`=%s LIMIT 1", + array(bigintval($value), postRequestElement('percents', $id), $id), __FILE__, __LINE__); } $message = getMessage('REF_DEPTHS_SAVED'); break; @@ -135,8 +135,8 @@ WHERE `mails_confirmed` < %s", $REF, $REF)); 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", - array(bigintval(postRequestElement('level'))), __FILE__, __LINE__); + $result = SQL_QUERY_ESC("SELECT `id` FROM `{?_MYSQL_PREFIX?}_refdepths` WHERE `level`='%s' LIMIT 1", + array(bigintval(postRequestElement('level'))), __FILE__, __LINE__); SQL_FREERESULT($result); } // END - if @@ -220,7 +220,7 @@ WHERE `mails_confirmed` < %s", $REF, $REF)); 'sw' => $SW, 'id' => $id, 'level' => $content['level'], - 'percents' => translateComma($contentp['percents']), + 'percents' => translateComma($content['percents']), ); // Load row template and switch color