X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Fmodules%2Fmember%2Fwhat-payout.php;h=a95a8777350ea991e01206103962da1875b5b8ab;hp=25aa636c78b4d803a2f61833e8c60c9d604e5dcb;hb=3daede4c904e23905c3e48dd6749019deca0a0e0;hpb=b3f82be7e5ecc294acfe9c00ef75e3dc0c8b43d1 diff --git a/inc/modules/member/what-payout.php b/inc/modules/member/what-payout.php index 25aa636c78..a95a877735 100644 --- a/inc/modules/member/what-payout.php +++ b/inc/modules/member/what-payout.php @@ -40,27 +40,31 @@ if (!defined('__SECURITY')) { // Not logged in LOAD_URL("modules.php?module=index"); } elseif ((!EXT_IS_ACTIVE("payout")) && (!IS_ADMIN())) { - // Extension "payout" is not active - ADD_FATAL(EXTENSION_PROBLEM_EXT_INACTIVE, "payout"); + addFatalMessage(EXTENSION_PROBLEM_EXT_INACTIVE, "payout"); return; } // Add description as navigation point -ADD_DESCR("member", basename(__FILE__)); +ADD_DESCR("member", __FILE__); $result_depths = SQL_QUERY("SELECT level, percents FROM "._MYSQL_PREFIX."_refdepths ORDER BY level", __FILE__, __LINE__); $TPTS = 0; -while (list($lvl, $per) = SQL_FETCHROW($result_depths)) -{ - // Load referral points +while (list($lvl, $per) = SQL_FETCHROW($result_depths)) { + // Load referal points $result_points = SQL_QUERY_ESC("SELECT points FROM "._MYSQL_PREFIX."_user_points WHERE userid=%s AND ref_depth=%d LIMIT 1", - array($GLOBALS['userid'], bigintval($lvl)), __FILE__, __LINE__); - if (SQL_NUMROWS($result_points) == 1) - { + array($GLOBALS['userid'], bigintval($lvl)), __FILE__, __LINE__); + + // Entry found? + if (SQL_NUMROWS($result_points) == 1) { + // Load points list($points) = SQL_FETCHROW($result_points); - SQL_FREERESULT($result_points); + + // Add them to total $TPTS += $points; } + + // Free result + SQL_FREERESULT($result_points); } // Free memory @@ -102,8 +106,7 @@ ORDER BY p.payout_timestamp DESC", while (list($pid, $total, $account, $bank, $type, $tstamp, $status, $allow, $url, $alt, $banner) = SQL_FETCHROW($result_payouts)) { // Translate status - $evl = "\$status = PAYOUT_MEMBER_STATUS_".strtoupper($status).";"; - eval($evl); + $status = constant('PAYOUT_MEMBER_STATUS_'.strtoupper($status).''); $status = "".$status.""; // Nothing entered must be secured in member/what-payputs.php ! @@ -193,13 +196,13 @@ ORDER BY p.payout_timestamp DESC", define('PAYOUT_POINTS_VALUE', $PAYOUT); // Subtract points from member's account - SUB_POINTS($GLOBALS['userid'], $PAYOUT); + SUB_POINTS("payout", $GLOBALS['userid'], $PAYOUT); // Add entry to his tranfer history if ($allow == "Y") { // Banner/textlink ordered - $result = SQL_QUERY_ESC("INSERT INTO "._MYSQL_PREFIX."_user_payouts (userid, payout_total, payout_id, payout_timestamp, status, target_url, link_text, banner_url) + SQL_QUERY_ESC("INSERT INTO "._MYSQL_PREFIX."_user_payouts (userid, payout_total, payout_id, payout_timestamp, status, target_url, link_text, banner_url) VALUES (%s,%s,%s, UNIX_TIMESTAMP(), 'NEW','%s','%s','%s')", array( $GLOBALS['userid'], @@ -218,13 +221,13 @@ VALUES (%s,%s,%s, UNIX_TIMESTAMP(), 'NEW','%s','%s','%s')", } else { - $msg_adm = addslashes(LOAD_EMAIL_TEMPLATE("admin_payout_request_banner", array(), $GLOBALS['userid'])); + $msg_adm = LOAD_EMAIL_TEMPLATE("admin_payout_request_banner", array(), $GLOBALS['userid']); } } else { // e-currency payout requested - $result = SQL_QUERY_ESC("INSERT INTO "._MYSQL_PREFIX."_user_payouts (userid, payout_total, target_account, target_bank, payout_id, payout_timestamp, status, password) + SQL_QUERY_ESC("INSERT INTO "._MYSQL_PREFIX."_user_payouts (userid, payout_total, target_account, target_bank, payout_id, payout_timestamp, status, password) VALUES (%s,%s,%s,'%s',%s, UNIX_TIMESTAMP(), 'NEW','%s')", array( $GLOBALS['userid'], @@ -237,7 +240,7 @@ VALUES (%s,%s,%s,'%s',%s, UNIX_TIMESTAMP(), 'NEW','%s')", // Load templates $msg_mem = LOAD_EMAIL_TEMPLATE("member_payout_request", array(), $GLOBALS['userid']); - $msg_adm = addslashes(LOAD_EMAIL_TEMPLATE("admin_payout_request", array(), $GLOBALS['userid'])); + $msg_adm = LOAD_EMAIL_TEMPLATE("admin_payout_request", array(), $GLOBALS['userid']); $admin_tpl = ""; if (GET_EXT_VERSION("admins") >= "0.4.1") { @@ -246,7 +249,7 @@ VALUES (%s,%s,%s,'%s',%s, UNIX_TIMESTAMP(), 'NEW','%s')", } // Generate task - $result = SQL_QUERY_ESC("INSERT INTO "._MYSQL_PREFIX."_task_system (assigned_admin, status, task_type, subject, text, task_created, userid) + SQL_QUERY_ESC("INSERT INTO "._MYSQL_PREFIX."_task_system (assigned_admin, status, task_type, subject, text, task_created, userid) VALUES (0, 'NEW','PAYOUT_REQUEST','[payout:] ".PAYOUT_REQUEST_ADMIN."','%s', UNIX_TIMESTAMP(), %s)", array( $msg_adm,