X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;ds=inline;f=0.2.1%2Finc%2Fmodules%2Fadmin%2Fwhat-config_payouts.php;h=ef2ee324cd8112c382c029509a6c5c22ae4184c5;hb=7bc25dd08431c94ce9edca131d56c1a36b13c28a;hp=fddab7800f134c1f453cb7b0d45036268b90472e;hpb=157ee010917df5ca07e6d31b42f67417b2516d74;p=mailer.git diff --git a/0.2.1/inc/modules/admin/what-config_payouts.php b/0.2.1/inc/modules/admin/what-config_payouts.php index fddab7800f..ef2ee324cd 100644 --- a/0.2.1/inc/modules/admin/what-config_payouts.php +++ b/0.2.1/inc/modules/admin/what-config_payouts.php @@ -1,249 +1,249 @@ - 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) - { - // Add now - $result = 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 = "".ADMIN_PAYOUT_TYPE_ADDED.""; - } - else - { - // Free memory - SQL_FREERESULT($result); - - // Does already exist - $msg = "".ADMIN_PAYOUT_TYPE_ALREADY.""; - } -} - -// 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__); - -$display = true; -if ((isset($_POST['edit'])) && (SELECTION_COUNT($_POST['sel']) > 0)) -{ - // Edit payout types - if ((isset($_GET['ok'])) && ($_GET['ok'] == "ok")) - { - // Edit entries - foreach ($_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)) - { - // Update entry - $result = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_payout_types SET -type='%s', -rate=%d, -min_points=%d, -allow_url='%s' -WHERE id='".$id."' LIMIT 1", - array( - $_POST['title'][$id], - bigintval(str_replace(",", ".", $_POST['rate'][$id])), - bigintval(str_replace(",", ".", $_POST['mpoi'][$id])), - $_POST['allow'][$id], -),__FILE__, __LINE__); - } - } - $msg = ADMIN_PAYOUT_ENTRIES_CHANGED; - } - else - { - $display = false; //Suppress any other outputs - $SW = 2; $OUT = ""; - foreach ($_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=%d LIMIT 1", - array(bigintval($id)), __FILE__, __LINE__); - list($title, $rate, $mpoi, $allow) = SQL_FETCHROW($result); - SQL_FREERESULT($result); - - // Prepare data for the row template - $content = array( - 'sw' => $SW, - 'id' => $id, - 'title' => COMPILE_CODE($title), - 'rate' => TRANSLATE_COMMA($rate), - 'mpoi' => TRANSLATE_COMMA($mpoi), - 'allow' => ADD_SELECTION("yn", $allow, "allow[".$id."]"), - ); - - // Load row template and switch color - $OUT .= LOAD_TEMPLATE("admin_config_payouts_edit_row", true, $content); - $SW = 3 - $SW; - } - define('__PAYOUT_ROWS', $OUT); - - // Load main template - LOAD_TEMPLATE("admin_config_payouts_edit"); - } -} - elseif ((isset($_POST['del'])) && (SELECTION_COUNT($_POST['sel']) > 0)) -{ - // Delete payout types - if ($_GET['ok'] == "ok") - { - // Delete entries - foreach ($_POST['sel'] as $id=>$sel) - { - $result = SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM "._MYSQL_PREFIX."_payout_types WHERE id=%d LIMIT 1", - array(bigintval($id)), __FILE__, __LINE__); - } - $msg = ADMIN_PAYOUT_ENTRIES_DELETED; - } - else - { - $display = false; //Suppress any other outputs - $SW = 2; $OUT = ""; - foreach ($_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=%d LIMIT 1", - array($id), __FILE__, __LINE__); - list($title, $rate, $mpoi) = SQL_FETCHROW($result); - SQL_FREERESULT($result); - - // Prepare data for the row template - $content = array( - 'sw' => $SW, - 'id' => $id, - 'title' => COMPILE_CODE($title), - 'rate' => TRANSLATE_COMMA($rate), - 'mpoi' => TRANSLATE_COMMA($mpoi), - ); - - // Load row template and switch color - $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"); - } -} - -if (!empty($msg)) -{ - // Output message - LOAD_TEMPLATE("admin_settings_saved", false, $msg); -} - -// Payout types -$result_type = SQL_QUERY("SELECT id, type, rate, min_points, from_account FROM "._MYSQL_PREFIX."_payout_types ORDER BY type", __FILE__, __LINE__); - -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)) - { - // 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), - ); - - // Load row template and switch color - $OUT .= LOAD_TEMPLATE("admin_config_payouts_row", true, $content); - $SW = 3 - $SW; - } - - // Free memory - SQL_FREERESULT($result_type); - define('__PAYOUT_ROWS', $OUT); - - // Load main template - LOAD_TEMPLATE("admin_config_payouts"); -} - -// Does your members request payouts? -if ((SQL_NUMROWS($result_mem) > 0) && ($display)) -{ - // Members has requested payouts - SQL_FREERESULT($result_mem); - OUTPUT_HTML ("

".ADMIN_PAYOUT_LIST_REQUESTS."

"); -} - elseif ($display) -{ - // No member requests so far - OUTPUT_HTML ("

".ADMIN_PAYOUT_NO_MEMBER_REQUESTS."

"); -} -// Add new paypout type -if ($display) LOAD_TEMPLATE("admin_payout_add_new"); - -// -?> + 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) + { + // Add now + $result = 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 = "".ADMIN_PAYOUT_TYPE_ADDED.""; + } + else + { + // Free memory + SQL_FREERESULT($result); + + // Does already exist + $msg = "".ADMIN_PAYOUT_TYPE_ALREADY.""; + } +} + +// 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__); + +$display = true; +if ((isset($_POST['edit'])) && (SELECTION_COUNT($_POST['sel']) > 0)) +{ + // Edit payout types + if ((isset($_GET['ok'])) && ($_GET['ok'] == "ok")) + { + // Edit entries + foreach ($_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)) + { + // Update entry + $result = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_payout_types SET +type='%s', +rate=%d, +min_points=%d, +allow_url='%s' +WHERE id='".$id."' LIMIT 1", + array( + $_POST['title'][$id], + bigintval(str_replace(",", ".", $_POST['rate'][$id])), + bigintval(str_replace(",", ".", $_POST['mpoi'][$id])), + $_POST['allow'][$id], +),__FILE__, __LINE__); + } + } + $msg = ADMIN_PAYOUT_ENTRIES_CHANGED; + } + else + { + $display = false; //Suppress any other outputs + $SW = 2; $OUT = ""; + foreach ($_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=%d LIMIT 1", + array(bigintval($id)), __FILE__, __LINE__); + list($title, $rate, $mpoi, $allow) = SQL_FETCHROW($result); + SQL_FREERESULT($result); + + // Prepare data for the row template + $content = array( + 'sw' => $SW, + 'id' => $id, + 'title' => COMPILE_CODE($title), + 'rate' => TRANSLATE_COMMA($rate), + 'mpoi' => TRANSLATE_COMMA($mpoi), + 'allow' => ADD_SELECTION("yn", $allow, "allow[".$id."]"), + ); + + // Load row template and switch color + $OUT .= LOAD_TEMPLATE("admin_config_payouts_edit_row", true, $content); + $SW = 3 - $SW; + } + define('__PAYOUT_ROWS', $OUT); + + // Load main template + LOAD_TEMPLATE("admin_config_payouts_edit"); + } +} + elseif ((isset($_POST['del'])) && (SELECTION_COUNT($_POST['sel']) > 0)) +{ + // Delete payout types + if ($_GET['ok'] == "ok") + { + // Delete entries + foreach ($_POST['sel'] as $id=>$sel) + { + $result = SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM "._MYSQL_PREFIX."_payout_types WHERE id=%d LIMIT 1", + array(bigintval($id)), __FILE__, __LINE__); + } + $msg = ADMIN_PAYOUT_ENTRIES_DELETED; + } + else + { + $display = false; //Suppress any other outputs + $SW = 2; $OUT = ""; + foreach ($_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=%d LIMIT 1", + array($id), __FILE__, __LINE__); + list($title, $rate, $mpoi) = SQL_FETCHROW($result); + SQL_FREERESULT($result); + + // Prepare data for the row template + $content = array( + 'sw' => $SW, + 'id' => $id, + 'title' => COMPILE_CODE($title), + 'rate' => TRANSLATE_COMMA($rate), + 'mpoi' => TRANSLATE_COMMA($mpoi), + ); + + // Load row template and switch color + $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"); + } +} + +if (!empty($msg)) +{ + // Output message + LOAD_TEMPLATE("admin_settings_saved", false, $msg); +} + +// Payout types +$result_type = SQL_QUERY("SELECT id, type, rate, min_points, from_account FROM "._MYSQL_PREFIX."_payout_types ORDER BY type", __FILE__, __LINE__); + +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)) + { + // 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), + ); + + // Load row template and switch color + $OUT .= LOAD_TEMPLATE("admin_config_payouts_row", true, $content); + $SW = 3 - $SW; + } + + // Free memory + SQL_FREERESULT($result_type); + define('__PAYOUT_ROWS', $OUT); + + // Load main template + LOAD_TEMPLATE("admin_config_payouts"); +} + +// Does your members request payouts? +if ((SQL_NUMROWS($result_mem) > 0) && ($display)) +{ + // Members has requested payouts + SQL_FREERESULT($result_mem); + OUTPUT_HTML ("

".ADMIN_PAYOUT_LIST_REQUESTS."

"); +} + elseif ($display) +{ + // No member requests so far + OUTPUT_HTML ("

".ADMIN_PAYOUT_NO_MEMBER_REQUESTS."

"); +} +// Add new paypout type +if ($display) LOAD_TEMPLATE("admin_payout_add_new"); + +// +?>