Fix for fix... :(

[mailer.git] / inc / modules / admin / what-config_points.php

diff --git a/inc/modules/admin/what-config_points.php b/inc/modules/admin/what-config_points.php
index 53cbc18472f81738df2793b05152e057a2391392..c43f40a6e613bbbcc70495de1430d0485986893b 100644 (file)
--- 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