X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Fmodules%2Fadmin%2Fwhat-config_payouts.php;h=0143150c274ddfdc780c2a2cd1833f79174c6273;hp=da87317ea191ff5021bf0fde925ec67a27897a72;hb=b8aa17b98b99c27eafbdca0fa090bae63527da9a;hpb=357b2ca133fc1f89db74097955c366cb4bee6996

diff --git a/inc/modules/admin/what-config_payouts.php b/inc/modules/admin/what-config_payouts.php
index da87317ea1..0143150c27 100644
--- a/inc/modules/admin/what-config_payouts.php
+++ b/inc/modules/admin/what-config_payouts.php
@@ -10,7 +10,12 @@
  * -------------------------------------------------------------------- *
  * Kurzbeschreibung  : Auszahlungensarten editieren                     *
  * -------------------------------------------------------------------- *
- *                                                                      *
+ * $Revision::                                                        $ *
+ * $Date::                                                            $ *
+ * $Tag:: 0.2.1-FINAL                                                 $ *
+ * $Author::                                                          $ *
+ * Needs to be in all Files and every File needs "svn propset           *
+ * svn:keywords Date Revision" (autoprobset!) at least!!!!!!            *
  * -------------------------------------------------------------------- *
  * Copyright (c) 2003 - 2008 by Roland Haeder                           *
  * For more information visit: http://www.mxchange.org                  *
@@ -33,94 +38,93 @@
 
 // Some security stuff...
 if ((!defined('__SECURITY')) || (!IS_ADMIN())) {
-	$INC = substr(dirname(__FILE__), 0, strpos(dirname(__FILE__), "/inc") + 4) . "/security.php";
+	$INC = substr(dirname(__FILE__), 0, strpos(dirname(__FILE__), '/inc') + 4) . '/security.php';
 	require($INC);
 }
 
 // Add description as navigation point
-ADD_DESCR("admin", __FILE__);
+ADD_DESCR('admin', __FILE__);
 
-if (!empty($_POST['rate'])) $_POST['rate'] = REVERT_COMMA($_POST['rate']);
+if (REQUEST_ISSET_POST('rate')) REQUEST_SET_POST('rate', convertCommaToDot(REQUEST_POST('rate')));
 
-if ((isset($_POST['add'])) && (!empty($_POST['title'])) && ($_POST['rate'] > 0))
-{
+if ((REQUEST_ISSET_POST('add')) && (REQUEST_ISSET_POST('title')) && (REQUEST_POST('rate') > 0)) {
 	// Add new payout type
-	$result = SQL_QUERY_ESC("SELECT id FROM "._MYSQL_PREFIX."_payout_types WHERE type='%s' LIMIT 1",
-	 array($_POST['title']), __FILE__, __LINE__);
-	if (SQL_NUMROWS($result) == 0)
-	{
+	$result = SQL_QUERY_ESC("SELECT `id` FROM `{!_MYSQL_PREFIX!}_payout_types` WHERE type='%s' LIMIT 1",
+	array(REQUEST_POST('title')), __FILE__, __LINE__);
+	if (SQL_NUMROWS($result) == 0) {
 		// Add now
-		$result = SQL_QUERY_ESC("INSERT INTO "._MYSQL_PREFIX."_payout_types
+		SQL_QUERY_ESC("INSERT INTO `{!_MYSQL_PREFIX!}_payout_types`
 (type, rate, min_points, from_account, from_pass, engine_url, engine_ret_ok, engine_ret_failed, pass_enc, allow_url)
 VALUES ('%s', %d, %d,'%s','%s','%s','%s','%s','%s','%s')",
- array(
-	$_POST['title'],
-	bigintval($_POST['rate']),
-	bigintval($_POST['mpoi']),
-	$_POST['yacc'],
-	$_POST['ypass'],
-	$_POST['yurl'],
-	$_POST['yrdone'],
-	$_POST['yrfailed'],
-	$_POST['ytrans'],
-	$_POST['allow_url'],
-), __FILE__, __LINE__);
-		$msg = "<FONT class=\"admin_done\">".ADMIN_PAYOUT_TYPE_ADDED."</FONT>";
-	}
-	 else
-	{
+		array(
+			REQUEST_POST('title'),
+			bigintval(REQUEST_POST('rate')),
+			bigintval(REQUEST_POST('mpoi')),
+			REQUEST_POST('yacc'),
+			REQUEST_POST('ypass'),
+			REQUEST_POST('yurl'),
+			REQUEST_POST('yrdone'),
+			REQUEST_POST('yrfailed'),
+			REQUEST_POST('ytrans'),
+			REQUEST_POST('allow_url'),
+		), __FILE__, __LINE__);
+
+		// Get message
+		$message = getMessage('ADMIN_PAYOUT_TYPE_ADDED');
+	} else {
 		// Free memory
 		SQL_FREERESULT($result);
 
 		// Does already exist
-		$msg = "<FONT class=\"admin_failed\">".ADMIN_PAYOUT_TYPE_ALREADY."</FONT>";
+		$message = "<div class=\"admin_failed\">{--ADMIN_PAYOUT_TYPE_ALREADY--}</div>";
 	}
 }
 
 // Payout requests by your members
-$result_mem = SQL_QUERY("SELECT id FROM "._MYSQL_PREFIX."_user_payouts WHERE status='NEW' ORDER BY payout_timestamp DESC", __FILE__, __LINE__);
+$result_mem = SQL_QUERY("SELECT `id` FROM `{!_MYSQL_PREFIX!}_user_payouts` WHERE `status`='NEW' ORDER BY payout_timestamp DESC", __FILE__, __LINE__);
 
 $display = true;
-if ((isset($_POST['edit'])) && (SELECTION_COUNT($_POST['sel']) > 0))
-{
+if ((REQUEST_ISSET_POST('edit')) && (countPostSelection() > 0)) {
 	// Edit payout types
-	if ((isset($_GET['ok'])) && ($_GET['ok'] == "ok"))
-	{
+	if ((REQUEST_ISSET_GET('ok')) && (REQUEST_GET('ok') == 'ok')) {
+		// Init SQLs
+		INIT_SQLS();
+
 		// Edit entries
-		foreach ($_POST['sel'] as $id => $sel)
-		{
+		foreach (REQUEST_POST('sel') as $id => $sel) {
 			// Secure ID
 			$id = bigintval($id);
 
 			// Edit only if something is entered
-			if ((!empty($_POST['title'][$id])) && ($_POST['rate'][$id] > 0))
-			{
+			if ((REQUEST_ISSET_POST('title', $id)) && (REQUEST_POST('rate', $id) > 0)) {
 				// Update entry
-				$result = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_payout_types SET
+				ADD_SQL(SQL_QUERY_ESC("UPDATE `{!_MYSQL_PREFIX!}_payout_types` SET
 type='%s',
 rate=%s,
 min_points=%s,
 allow_url='%s'
-WHERE id='".$id."' LIMIT 1",
- array(
-	$_POST['title'][$id],
-	bigintval(REVERT_COMMA($_POST['rate'][$id])),
-	bigintval(REVERT_COMMA($_POST['mpoi'][$id])),
-	$_POST['allow'][$id],
-),__FILE__, __LINE__);
+WHERE `id`='".$id."' LIMIT 1",
+				array(
+					REQUEST_POST('title', $id),
+					convertCommaToDot(REQUEST_POST('rate', $id)),
+					convertCommaToDot(REQUEST_POST('mpoi' , $id)),
+					REQUEST_POST('allow', $id),
+				),__FILE__, __LINE__, false));
 			}
 		}
-		$msg = ADMIN_PAYOUT_ENTRIES_CHANGED;
-	}
-	 else
-	{
+
+		// Run all SQLs
+		runFilterChain('run_sqls');
+
+		// Get message
+		$message = getMessage('ADMIN_PAYOUT_ENTRIES_CHANGED');
+	} else {
 		$display = false; //Suppress any other outputs
-		$SW = 2; $OUT = "";
-		foreach ($_POST['sel'] as $id => $sel)
-		{
+		$OUT = ''; $SW = 2;
+		foreach (REQUEST_POST('sel') as $id => $sel) {
 			// Load data
-			$result = SQL_QUERY_ESC("SELECT type, rate, min_points, allow_url FROM "._MYSQL_PREFIX."_payout_types WHERE id=%s LIMIT 1",
-			 array(bigintval($id)), __FILE__, __LINE__);
+			$result = SQL_QUERY_ESC("SELECT type, rate, min_points, allow_url FROM `{!_MYSQL_PREFIX!}_payout_types` WHERE `id`=%s LIMIT 1",
+			array(bigintval($id)), __FILE__, __LINE__);
 			list($title, $rate, $mpoi, $allow) = SQL_FETCHROW($result);
 			SQL_FREERESULT($result);
 
@@ -129,46 +133,49 @@ WHERE id='".$id."' LIMIT 1",
 				'sw'    => $SW,
 				'id'    => $id,
 				'title' => COMPILE_CODE($title),
-				'rate'  => TRANSLATE_COMMA($rate),
-				'mpoi'  => TRANSLATE_COMMA($mpoi),
-				'allow' => ADD_SELECTION("yn", $allow, "allow[".$id."]"),
+				'rate'  => translateComma($rate),
+				'mpoi'  => translateComma($mpoi),
+				'allow' => ADD_SELECTION('yn', $allow, "allow[".$id."]"),
 			);
 
 			// Load row template and switch color
-			$OUT .= LOAD_TEMPLATE("admin_config_payouts_edit_row", true, $content);
+			$OUT .= LOAD_TEMPLATE('admin_config_payouts_edit_row', true, $content);
 			$SW = 3 - $SW;
 		}
+
+		// @TODO Rewrite this constant
 		define('__PAYOUT_ROWS', $OUT);
 
 		// Load main template
-		LOAD_TEMPLATE("admin_config_payouts_edit");
+		LOAD_TEMPLATE('admin_config_payouts_edit');
 	}
-}
- elseif ((isset($_POST['del'])) && (SELECTION_COUNT($_POST['sel']) > 0))
-{
+} elseif ((REQUEST_ISSET_POST('del')) && (countPostSelection() > 0)) {
 	// Delete payout types
-	if ($_GET['ok'] == "ok")
-	{
+	if ((REQUEST_ISSET_GET('ok')) && (REQUEST_GET('ok') == 'ok')) {
+		// Init SQLs
+		INIT_SQLS();
+
 		// Delete entries
-		foreach ($_POST['sel'] as $id => $sel)
-		{
-			$result = SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM "._MYSQL_PREFIX."_payout_types WHERE id=%s LIMIT 1",
-			 array(bigintval($id)), __FILE__, __LINE__);
-		}
-		$msg = ADMIN_PAYOUT_ENTRIES_DELETED;
-	}
-	 else
-	{
+		foreach (REQUEST_POST('sel') as $id => $sel) {
+			ADD_SQL(SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM `{!_MYSQL_PREFIX!}_payout_types` WHERE `id`=%s LIMIT 1",
+			array(bigintval($id)), __FILE__, __LINE__, false));
+		} // END - foreach
+
+		// Run all SQLs
+		runFilterChain('run_sqls');
+
+		// Get message
+		$message = getMessage('ADMIN_PAYOUT_ENTRIES_DELETED');
+	} else {
 		$display = false; //Suppress any other outputs
-		$SW = 2; $OUT = "";
-		foreach ($_POST['sel'] as $id => $sel)
-		{
+		$OUT = ''; $SW = 2;
+		foreach (REQUEST_POST('sel') as $id => $sel) {
 			// Secure ID number
 			$id = bigintval($id);
 
 			// Load data
-			$result = SQL_QUERY_ESC("SELECT type, rate, min_points FROM "._MYSQL_PREFIX."_payout_types WHERE id=%s LIMIT 1",
-			 array($id), __FILE__, __LINE__);
+			$result = SQL_QUERY_ESC("SELECT type, rate, min_points FROM `{!_MYSQL_PREFIX!}_payout_types` WHERE `id`=%s LIMIT 1",
+			array($id), __FILE__, __LINE__);
 			list($title, $rate, $mpoi) = SQL_FETCHROW($result);
 			SQL_FREERESULT($result);
 
@@ -177,73 +184,77 @@ WHERE id='".$id."' LIMIT 1",
 				'sw'    => $SW,
 				'id'    => $id,
 				'title' => COMPILE_CODE($title),
-				'rate'  => TRANSLATE_COMMA($rate),
-				'mpoi'  => TRANSLATE_COMMA($mpoi),
+				'rate'  => translateComma($rate),
+				'mpoi'  => translateComma($mpoi),
 			);
 
 			// Load row template and switch color
-			$OUT .= LOAD_TEMPLATE("admin_config_payouts_del_row", true, $content);
+			$OUT .= LOAD_TEMPLATE('admin_config_payouts_del_row', true, $content);
 			$SW = 3 - $SW;
 		}
 		define('__PAYOUT_ROWS', $OUT);
 
 		// Load main template
-		LOAD_TEMPLATE("admin_config_payouts_del");
+		LOAD_TEMPLATE('admin_config_payouts_del');
 	}
 }
 
-if (!empty($msg))
-{
+if (!empty($message)) {
 	// Output message
-	LOAD_TEMPLATE("admin_settings_saved", false, $msg);
-}
+	LOAD_TEMPLATE('admin_settings_saved', false, $message);
+} // END - if
 
 // Payout types
-$result_type = SQL_QUERY("SELECT id, type, rate, min_points, from_account FROM "._MYSQL_PREFIX."_payout_types ORDER BY type", __FILE__, __LINE__);
+$result_type = SQL_QUERY("SELECT
+	`id`, `type`, `rate`, `min_points`, `from_account`
+FROM
+	`{!_MYSQL_PREFIX!}_payout_types`
+ORDER BY
+	`type` ASC", __FILE__, __LINE__);
 
-if ((SQL_NUMROWS($result_type) > 0) && ($display))
-{
+if ((SQL_NUMROWS($result_type) > 0) && ($display)) {
 	// List all payout types
-	$SW = 2; $OUT = "";
-	while (list($id, $type, $rate, $mpoi, $from) = SQL_FETCHROW($result_type))
-	{
+	$OUT = ''; $SW = 2;
+	while ($content = SQL_FETCHARRAY($result_type)) {
 		// Prepare data for the row template
 		$content = array(
 			'sw'    => $SW,
-			'id'    => $id,
-			'from'  => COMPILE_CODE($from),
-			'type'  => COMPILE_CODE($type),
-			'rate'  => TRANSLATE_COMMA($rate),
-			'mpoi'  => TRANSLATE_COMMA($mpoi),
+			'id'    => $content['id'],
+			'from'  => COMPILE_CODE($content['from_account']),
+			'type'  => COMPILE_CODE($content['type']),
+			'rate'  => translateComma($content['rate']),
+			'mpoi'  => translateComma($content['min_points']),
 		);
 
 		// Load row template and switch color
-		$OUT .= LOAD_TEMPLATE("admin_config_payouts_row", true, $content);
+		$OUT .= LOAD_TEMPLATE('admin_config_payouts_row', true, $content);
 		$SW = 3 - $SW;
 	}
 
 	// Free memory
 	SQL_FREERESULT($result_type);
+
+	// @TODO Rewrite this constant
 	define('__PAYOUT_ROWS', $OUT);
 
 	// Load main template
-	LOAD_TEMPLATE("admin_config_payouts");
+	LOAD_TEMPLATE('admin_config_payouts');
 }
 
 // Does your members request payouts?
-if ((SQL_NUMROWS($result_mem) > 0) && ($display))
-{
+if ((SQL_NUMROWS($result_mem) > 0) && ($display)) {
 	// Members has requested payouts
-	SQL_FREERESULT($result_mem);
-	OUTPUT_HTML("<P><A href=\"".URL."/modules.php?module=admin&amp;what=list_payouts\">".ADMIN_PAYOUT_LIST_REQUESTS."</A></P>");
-}
- elseif ($display)
-{
+	LOAD_TEMPLATE('admin_settings_saved', false, "<a href=\"{!URL!}/modules.php?module=admin&amp;what=list_payouts\">{--ADMIN_PAYOUT_LIST_REQUESTS--}</a></P>");
+} elseif ($display) {
 	// No member requests so far
-	OUTPUT_HTML("<P><STRONG>".ADMIN_PAYOUT_NO_MEMBER_REQUESTS."</STRONG></P>");
+	LOAD_TEMPLATE('admin_settings_saved', false, getMessage('ADMIN_PAYOUT_NO_MEMBER_REQUESTS'));
 }
+
+// Free result
+SQL_FREERESULT($result_mem);
+
 // Add new paypout type
-if ($display) LOAD_TEMPLATE("admin_payout_add_new");
+if ($display === true) LOAD_TEMPLATE('admin_payout_add_new');
 
 //
 ?>