]> git.mxchange.org Git - mailer.git/blobdiff - inc/modules/admin/what-config_payouts.php
Huge rewrite:
[mailer.git] / inc / modules / admin / what-config_payouts.php
index d5ebab5fed9d24bc1dd4807b5e4f6968a1489e89..0143150c274ddfdc780c2a2cd1833f79174c6273 100644 (file)
@@ -10,7 +10,7 @@
  * -------------------------------------------------------------------- *
  * Kurzbeschreibung  : Auszahlungensarten editieren                     *
  * -------------------------------------------------------------------- *
- * $Revision:: 856                                                    $ *
+ * $Revision::                                                        $ *
  * $Date::                                                            $ *
  * $Tag:: 0.2.1-FINAL                                                 $ *
  * $Author::                                                          $ *
 
 // 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 (REQUEST_ISSET_POST(('rate'))) REQUEST_SET_POST('rate', REVERT_COMMA(REQUEST_POST('rate')));
+if (REQUEST_ISSET_POST('rate')) REQUEST_SET_POST('rate', convertCommaToDot(REQUEST_POST('rate')));
 
-if ((REQUEST_ISSET_POST(('add'))) && (REQUEST_ISSET_POST(('title'))) && (REQUEST_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(REQUEST_POST('title')), __FILE__, __LINE__);
+       $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
                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(
-       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__);
-               $msg = getMessage('ADMIN_PAYOUT_TYPE_ADDED');
+               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 = "<div class=\"admin_failed\">{--ADMIN_PAYOUT_TYPE_ALREADY--}</div>";
+               $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 ((REQUEST_ISSET_POST('edit')) && (SELECTION_COUNT(REQUEST_POST('sel')) > 0)) {
+if ((REQUEST_ISSET_POST('edit')) && (countPostSelection() > 0)) {
        // Edit payout types
-       if ((REQUEST_ISSET_GET('ok')) && (REQUEST_GET('ok') == "ok")) {
+       if ((REQUEST_ISSET_GET('ok')) && (REQUEST_GET('ok') == 'ok')) {
                // Init SQLs
                INIT_SQLS();
 
@@ -94,20 +96,20 @@ if ((REQUEST_ISSET_POST('edit')) && (SELECTION_COUNT(REQUEST_POST('sel')) > 0))
                        $id = bigintval($id);
 
                        // Edit only if something is entered
-                       if ((REQUEST_ISSET_POST(('title', $id))) && (REQUEST_POST('rate', $id) > 0)) {
+                       if ((REQUEST_ISSET_POST('title', $id)) && (REQUEST_POST('rate', $id) > 0)) {
                                // Update entry
                                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(
-       REQUEST_POST('title', $id),
-       REVERT_COMMA(REQUEST_POST('rate', $id)),
-       REVERT_COMMA(REQUEST_POST('mpoi' , $id)),
-       REQUEST_POST('allow', $id),
-),__FILE__, __LINE__, false));
+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));
                        }
                }
 
@@ -115,14 +117,14 @@ WHERE id='".$id."' LIMIT 1",
                runFilterChain('run_sqls');
 
                // Get message
-               $msg = getMessage('ADMIN_PAYOUT_ENTRIES_CHANGED');
+               $message = getMessage('ADMIN_PAYOUT_ENTRIES_CHANGED');
        } else {
                $display = false; //Suppress any other outputs
-               $OUT = ""; $SW = 2;
+               $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);
 
@@ -131,13 +133,13 @@ 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;
                }
 
@@ -145,35 +147,35 @@ WHERE id='".$id."' LIMIT 1",
                define('__PAYOUT_ROWS', $OUT);
 
                // Load main template
-               LOAD_TEMPLATE("admin_config_payouts_edit");
+               LOAD_TEMPLATE('admin_config_payouts_edit');
        }
-} elseif ((REQUEST_ISSET_POST('del')) && (SELECTION_COUNT(REQUEST_POST('sel')) > 0)) {
+} elseif ((REQUEST_ISSET_POST('del')) && (countPostSelection() > 0)) {
        // Delete payout types
-       if ((REQUEST_ISSET_GET('ok')) && (REQUEST_GET('ok') == "ok")) {
+       if ((REQUEST_ISSET_GET('ok')) && (REQUEST_GET('ok') == 'ok')) {
                // Init SQLs
                INIT_SQLS();
 
                // Delete entries
                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));
+                       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
-               $msg = getMessage('ADMIN_PAYOUT_ENTRIES_DELETED');
+               $message = getMessage('ADMIN_PAYOUT_ENTRIES_DELETED');
        } else {
                $display = false; //Suppress any other outputs
-               $OUT = ""; $SW = 2;
+               $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);
 
@@ -182,32 +184,37 @@ 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)) {
        // List all payout types
-       $OUT = ""; $SW = 2;
+       $OUT = ''; $SW = 2;
        while ($content = SQL_FETCHARRAY($result_type)) {
                // Prepare data for the row template
                $content = array(
@@ -215,12 +222,12 @@ if ((SQL_NUMROWS($result_type) > 0) && ($display)) {
                        'id'    => $content['id'],
                        'from'  => COMPILE_CODE($content['from_account']),
                        'type'  => COMPILE_CODE($content['type']),
-                       'rate'  => TRANSLATE_COMMA($content['rate']),
-                       'mpoi'  => TRANSLATE_COMMA($content['min_points']),
+                       '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;
        }
 
@@ -231,23 +238,23 @@ if ((SQL_NUMROWS($result_type) > 0) && ($display)) {
        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)) {
        // Members has requested payouts
-       LOAD_TEMPLATE("admin_settings_saved", false, "<a href=\"{!URL!}/modules.php?module=admin&amp;what=list_payouts\">{--ADMIN_PAYOUT_LIST_REQUESTS--}</a></P>");
+       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
-       LOAD_TEMPLATE("admin_settings_saved", false, getMessage('ADMIN_PAYOUT_NO_MEMBER_REQUESTS'));
+       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');
 
 //
 ?>