$value) { $SQLs[] = "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) { $SQLs[] = "DELETE LOW_PRIORITY FROM "._MYSQL_PREFIX."_payments WHERE id='".$id."' LIMIT 1"; } break; } // Save settings if (count($SQLs) > 0) { // Run all queries RUN_FILTER('run_sqls', array('dry_run' => false, 'sqls' => $SQLs)); $content = "".SETTINGS_SAVED.""; } else { // Nothing has changed! $content = "".SETTINGS_NOT_SAVED.""; } // Output template 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=%s 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=%s 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 { // Referal 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 referal 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 referal levels LOAD_TEMPLATE("admin_add_payment"); } // ?>