X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Fmodules%2Fadmin%2Fwhat-payments.php;h=8723a902c23c8cce6418813e900e8346b49093f1;hp=66e61a4694183c71eeb47f01b1a899041abb0069;hb=2df9f7a53f8b1dd5164f87824a324ccb3b6634cb;hpb=428be1738c81a57e4e75b4f701df9414656a3b13;ds=sidebyside diff --git a/inc/modules/admin/what-payments.php b/inc/modules/admin/what-payments.php index 66e61a4694..8723a902c2 100644 --- a/inc/modules/admin/what-payments.php +++ b/inc/modules/admin/what-payments.php @@ -50,7 +50,7 @@ if (((!isPostRequestElementSet('t_wait')) || (!isPostRequestElementSet('payment' if (isFormSent()) { switch (getRequestElement('do')) { case 'add': - addSql("INSERT INTO `{?_MYSQL_PREFIX?}_payments` (`time`,`payment`,`mail_title`,`price`) VALUES ('".postRequestElement('t_wait')."','".postRequestElement('payment')."','".postRequestElement('title')."','".postRequestElement('price')."')"); + addSql("INSERT INTO `{?_MYSQL_PREFIX?}_payments` (`time`, `payment`, `mail_title`, `price`) VALUES ('".postRequestElement('t_wait')."','".postRequestElement('payment')."','".postRequestElement('title')."','".postRequestElement('price')."')"); if (countSumTotalData(postRequestElement('t_wait'), 'payments', 'id', 'time', true) == 1) { // Re-init the array here initSqls(); @@ -91,7 +91,7 @@ if (isFormSent()) { // Delete entries here $OUT = ''; foreach (postRequestElement('sel') as $id => $value) { - $result = SQL_QUERY_ESC("SELECT `id`,`time`,`mail_title` FROM `{?_MYSQL_PREFIX?}_payments` WHERE `id`=%s LIMIT 1", + $result = SQL_QUERY_ESC("SELECT `id`, `time`, `mail_title` FROM `{?_MYSQL_PREFIX?}_payments` WHERE `id`=%s LIMIT 1", array(bigintval($id)), __FILE__, __LINE__); $content = SQL_FETCHARRAY($result); @@ -108,7 +108,7 @@ if (isFormSent()) { // Edit entries $OUT = ''; foreach (postRequestElement('sel') as $id => $value) { - $result = SQL_QUERY_ESC("SELECT `id`,`time`,`payment`,`mail_title`,`price` FROM `{?_MYSQL_PREFIX?}_payments` WHERE `id`=%s LIMIT 1", + $result = SQL_QUERY_ESC("SELECT `id`, `time`, `payment`, `mail_title`, `price` FROM `{?_MYSQL_PREFIX?}_payments` WHERE `id`=%s LIMIT 1", array(bigintval($id)), __FILE__, __LINE__); $content = SQL_FETCHARRAY($result); @@ -123,7 +123,7 @@ if (isFormSent()) { loadTemplate('admin_edit_payments', false, $OUT); } else { // Referral levels - $result = SQL_QUERY("SELECT `id`,`time`,`payment`,`mail_title`,`price` FROM `{?_MYSQL_PREFIX?}_payments` ORDER BY `time` ASC", __FILE__, __LINE__); + $result = SQL_QUERY("SELECT `id`, `time`, `payment`, `mail_title`, `price` FROM `{?_MYSQL_PREFIX?}_payments` ORDER BY `time` ASC", __FILE__, __LINE__); if (!SQL_HASZERONUMS($result)) { // Make referral levels editable and deletable $OUT = '';