X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=0.2.1%2Finc%2Fmodules%2Fadmin%2Fwhat-payments.php;h=e72cc1e6029e5116d0619c00f7ba733d34c6f29e;hb=7bc25dd08431c94ce9edca131d56c1a36b13c28a;hp=20550cb1fb799cf68aded001adae11a577fa7c85;hpb=157ee010917df5ca07e6d31b42f67417b2516d74;p=mailer.git diff --git a/0.2.1/inc/modules/admin/what-payments.php b/0.2.1/inc/modules/admin/what-payments.php index 20550cb1fb..e72cc1e602 100644 --- a/0.2.1/inc/modules/admin/what-payments.php +++ b/0.2.1/inc/modules/admin/what-payments.php @@ -1,213 +1,213 @@ -$value) - { - $SQL[] = "UPDATE "._MYSQL_PREFIX."_payments SET time='".$value."', payment='".$_POST['pay'][$id]."', price='".$_POST['price'][$id]."', mail_title='".$_POST['title'][$id]."' WHERE id='".$id."' LIMIT 1"; - } - break; - - case "del": - foreach ($_POST['id'] as $id=>$value) - { - $SQL[] = "DELETE LOW_PRIORITY FROM "._MYSQL_PREFIX."_payments WHERE id='".$id."' LIMIT 1"; - } - break; - } - // Daten abspeichern - if ((count($SQL) > 0) || (!empty($SQL[0]))) - { - foreach ($SQL as $s) - { - if (!empty($s)) - { - // Only run non-empty strings - $result = SQL_QUERY(trim($s), __FILE__, __LINE__); - if (empty($content)) - { - if (SQL_AFFECTEDROWS($link, __FILE__, __LINE__) == 1) - { - $content = "".SETTINGS_SAVED.""; - } - else - { - $content = "".SETTINGS_NOT_SAVED.""; - } - } - } - } - } - else - { - $content = "".SETTINGS_NOT_SAVED.""; - } - LOAD_TEMPLATE("admin_settings_saved", false, $content); -} - elseif ((isset($_POST['del'])) && (SELECTION_COUNT($_POST['sel']) > 0)) -{ - // Delete entries here - $SW = 2; $OUT = ""; - foreach ($_POST['sel'] as $id=>$value) - { - $result = SQL_QUERY_ESC("SELECT time, mail_title FROM "._MYSQL_PREFIX."_payments WHERE id=%d LIMIT 1", - array(bigintval($id)), __FILE__, __LINE__); - list($time, $title) = SQL_FETCHROW($result); - SQL_FREERESULT($result); - - // Prepare array for the row template - $content = array( - 'sw' => $SW, - 'id' => $id, - 'time' => $time, - 'title' => $title, - ); - - // Load row template and switch colors - $OUT .= LOAD_TEMPLATE("admin_del_payments_row", true, $content); - $SW = 3 - $SW; - } - define('__PAYMENT_ROWS', $OUT); - - // Load main template - LOAD_TEMPLATE("admin_del_payments"); -} - elseif ((isset($_POST['edit'])) && (SELECTION_COUNT($_POST['sel']) > 0)) -{ - // Edit entries - $SW = 2; $OUT = ""; - foreach ($_POST['sel'] as $id=>$value) - { - $result = SQL_QUERY_ESC("SELECT time, payment, mail_title, price FROM "._MYSQL_PREFIX."_payments WHERE id=%d LIMIT 1", - array(bigintval($id)), __FILE__, __LINE__); - list($time, $pay, $title, $price) = SQL_FETCHROW($result); - SQL_FREERESULT($result); - - // Prepare array for the row template - $content = array( - 'sw' => $SW, - 'id' => $id, - 'time' => $time, - 'title' => $title, - 'pay' => $pay, - 'price' => $price, - ); - - // Load row template and switch colors - $OUT .= LOAD_TEMPLATE("admin_edit_payments_row", true, $content); - $SW = 3 - $SW; - } - define('__PAYMENT_ROWS', $OUT); - - // Load main template - LOAD_TEMPLATE("admin_edit_payments"); -} - else -{ - // Referral levels - $result = SQL_QUERY("SELECT id, time, payment, mail_title, price FROM "._MYSQL_PREFIX."_payments ORDER BY time", __FILE__, __LINE__); - if (SQL_NUMROWS($result) > 0) - { - // Make referral levels editable and deletable - $SW = 2; $OUT = ""; - - // List already existing categories for editing - while (list($id, $time, $pay, $title, $price) = SQL_FETCHROW($result)) - { - $pay = TRANSLATE_COMMA($pay); - $price = TRANSLATE_COMMA($price); - - // Prepare array for the row template - $content = array( - 'sw' => $SW, - 'id' => $id, - 'time' => $time, - 'title' => $title, - 'pay' => $pay, - 'price' => $price, - ); - - // Load row template and switch colors - $OUT .= LOAD_TEMPLATE("admin_payments_list_row", true, $content); - $SW = 3 - $SW; - } - - // Free memory - SQL_FREERESULT($result); - define('__PAYMENT_ROWS', $OUT); - - // Load main template - LOAD_TEMPLATE("admin_list_payments"); - } - - // Form for adding new referral levels - LOAD_TEMPLATE("admin_add_payment"); -} -CLOSE_TABLE(); -// -?> +$value) + { + $SQL[] = "UPDATE "._MYSQL_PREFIX."_payments SET time='".$value."', payment='".$_POST['pay'][$id]."', price='".$_POST['price'][$id]."', mail_title='".$_POST['title'][$id]."' WHERE id='".$id."' LIMIT 1"; + } + break; + + case "del": + foreach ($_POST['id'] as $id=>$value) + { + $SQL[] = "DELETE LOW_PRIORITY FROM "._MYSQL_PREFIX."_payments WHERE id='".$id."' LIMIT 1"; + } + break; + } + // Daten abspeichern + if ((count($SQL) > 0) || (!empty($SQL[0]))) + { + foreach ($SQL as $s) + { + if (!empty($s)) + { + // Only run non-empty strings + $result = SQL_QUERY(trim($s), __FILE__, __LINE__); + if (empty($content)) + { + if (SQL_AFFECTEDROWS($link, __FILE__, __LINE__) == 1) + { + $content = "".SETTINGS_SAVED.""; + } + else + { + $content = "".SETTINGS_NOT_SAVED.""; + } + } + } + } + } + else + { + $content = "".SETTINGS_NOT_SAVED.""; + } + LOAD_TEMPLATE("admin_settings_saved", false, $content); +} + elseif ((isset($_POST['del'])) && (SELECTION_COUNT($_POST['sel']) > 0)) +{ + // Delete entries here + $SW = 2; $OUT = ""; + foreach ($_POST['sel'] as $id=>$value) + { + $result = SQL_QUERY_ESC("SELECT time, mail_title FROM "._MYSQL_PREFIX."_payments WHERE id=%d LIMIT 1", + array(bigintval($id)), __FILE__, __LINE__); + list($time, $title) = SQL_FETCHROW($result); + SQL_FREERESULT($result); + + // Prepare array for the row template + $content = array( + 'sw' => $SW, + 'id' => $id, + 'time' => $time, + 'title' => $title, + ); + + // Load row template and switch colors + $OUT .= LOAD_TEMPLATE("admin_del_payments_row", true, $content); + $SW = 3 - $SW; + } + define('__PAYMENT_ROWS', $OUT); + + // Load main template + LOAD_TEMPLATE("admin_del_payments"); +} + elseif ((isset($_POST['edit'])) && (SELECTION_COUNT($_POST['sel']) > 0)) +{ + // Edit entries + $SW = 2; $OUT = ""; + foreach ($_POST['sel'] as $id=>$value) + { + $result = SQL_QUERY_ESC("SELECT time, payment, mail_title, price FROM "._MYSQL_PREFIX."_payments WHERE id=%d LIMIT 1", + array(bigintval($id)), __FILE__, __LINE__); + list($time, $pay, $title, $price) = SQL_FETCHROW($result); + SQL_FREERESULT($result); + + // Prepare array for the row template + $content = array( + 'sw' => $SW, + 'id' => $id, + 'time' => $time, + 'title' => $title, + 'pay' => $pay, + 'price' => $price, + ); + + // Load row template and switch colors + $OUT .= LOAD_TEMPLATE("admin_edit_payments_row", true, $content); + $SW = 3 - $SW; + } + define('__PAYMENT_ROWS', $OUT); + + // Load main template + LOAD_TEMPLATE("admin_edit_payments"); +} + else +{ + // Referral levels + $result = SQL_QUERY("SELECT id, time, payment, mail_title, price FROM "._MYSQL_PREFIX."_payments ORDER BY time", __FILE__, __LINE__); + if (SQL_NUMROWS($result) > 0) + { + // Make referral levels editable and deletable + $SW = 2; $OUT = ""; + + // List already existing categories for editing + while (list($id, $time, $pay, $title, $price) = SQL_FETCHROW($result)) + { + $pay = TRANSLATE_COMMA($pay); + $price = TRANSLATE_COMMA($price); + + // Prepare array for the row template + $content = array( + 'sw' => $SW, + 'id' => $id, + 'time' => $time, + 'title' => $title, + 'pay' => $pay, + 'price' => $price, + ); + + // Load row template and switch colors + $OUT .= LOAD_TEMPLATE("admin_payments_list_row", true, $content); + $SW = 3 - $SW; + } + + // Free memory + SQL_FREERESULT($result); + define('__PAYMENT_ROWS', $OUT); + + // Load main template + LOAD_TEMPLATE("admin_list_payments"); + } + + // Form for adding new referral levels + LOAD_TEMPLATE("admin_add_payment"); +} +CLOSE_TABLE(); +// +?>