X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Fmodules%2Fadmin%2Fwhat-payments.php;h=adbc2e95ab3d57e8dd4f21b0a41049ecb7703905;hp=24f58d4c6a2218b60f8048a2cfda5198c9117964;hb=e72031bcfdcd8e91f62bec6cc88f36b7a11d9221;hpb=d22205247313f4b67db5c9aa3aac07cd9d073bce;ds=sidebyside

diff --git a/inc/modules/admin/what-payments.php b/inc/modules/admin/what-payments.php
index 24f58d4c6a..adbc2e95ab 100644
--- a/inc/modules/admin/what-payments.php
+++ b/inc/modules/admin/what-payments.php
@@ -48,33 +48,35 @@ if (IS_FORM_SENT()) {
 	$SQL = array();
 	switch (REQUEST_GET('do')) {
 	case "add":
-		$SQLs[] = "INSERT INTO `{!_MYSQL_PREFIX!}_payments` (time, payment, mail_title, price) VALUES ('".REQUEST_POST('t_wait')."','".REQUEST_POST('payment')."','".REQUEST_POST('title')."','".REQUEST_POST('price')."')";
+		ADD_SQL("INSERT INTO `{!_MYSQL_PREFIX!}_payments` (time, payment, mail_title, price) VALUES ('".REQUEST_POST('t_wait')."','".REQUEST_POST('payment')."','".REQUEST_POST('title')."','".REQUEST_POST('price')."')");
 		$result = SQL_QUERY_ESC("SELECT id FROM `{!_MYSQL_PREFIX!}_payments` WHERE time='%s' LIMIT 1",
-		 array(REQUEST_POST('t_wait')), __FILE__, __LINE__);
+			array(REQUEST_POST('t_wait')), __FILE__, __LINE__);
 		if (SQL_NUMROWS($result) == 1) {
+			// Re-init the array here
+			INIT_SQLS();
+
 			// Free memory
-			$SQLs[0] = "";
 			SQL_FREERESULT($result);
 		}
 		break;
 
 	case "edit":
 		foreach (REQUEST_POST('time') as $id => $value) {
-			$SQLs[] = "UPDATE `{!_MYSQL_PREFIX!}_payments` SET time='".$value."', payment='".REQUEST_POST('pay', $id)."', price='".REQUEST_POST('price', $id)."', mail_title='".REQUEST_POST('title', $id)."' WHERE id='".$id."' LIMIT 1";
+			ADD_SQL("UPDATE `{!_MYSQL_PREFIX!}_payments` SET time='".$value."', payment='".REQUEST_POST('pay', $id)."', price='".REQUEST_POST('price', $id)."', mail_title='".REQUEST_POST('title', $id)."' WHERE id='".$id."' LIMIT 1");
 		}
 		break;
 
 	case "del":
 		foreach (REQUEST_POST('id') as $id => $value) {
-			$SQLs[] = "DELETE LOW_PRIORITY FROM `{!_MYSQL_PREFIX!}_payments` WHERE id='".$id."' LIMIT 1";
+			ADD_SQL("DELETE LOW_PRIORITY FROM `{!_MYSQL_PREFIX!}_payments` WHERE id='".$id."' LIMIT 1");
 		}
 		break;
 	}
 
 	// Save settings
-	if (count($SQLs) > 0) {
+	if (COUNT_SQLS() > 0) {
 		// Run all queries
-		RUN_FILTER('run_sqls', array('dry_run' => false, 'sqls' => $SQLs));
+		RUN_FILTER('run_sqls', array('dry_run' => false));
 		$content = "<span class=\"admin_failed\">".SETTINGS_SAVED."</span>";
 	} else {
 		// Nothing has changed!