X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Fmodules%2Fmember%2Fwhat-transfer.php;h=aba730d1df36b0559a03ff285e1c7547f15e956a;hp=c7130ff3deb2a2add9122177e6be739aa046b70a;hb=49acdb7a7adbcf25a8e8683b5581bfcec72b23bd;hpb=7eb9da85bfb337997a58a244cb610c97a8d10c13
diff --git a/inc/modules/member/what-transfer.php b/inc/modules/member/what-transfer.php
index c7130ff3de..884e31b08d 100644
--- a/inc/modules/member/what-transfer.php
+++ b/inc/modules/member/what-transfer.php
@@ -1,7 +1,7 @@
0)
- {
- // Check for code
- $code = GEN_RANDOM_CODE($_CONFIG['transfer_code'], $_POST['code_chk'], $GLOBALS['userid'], __TRANSFER_MAX_VALUE);
- $valid_code = ($code == $_POST['code']);
- }
- else
- {
- // Zero length (= disabled) is always valid!
- $valid_code = true;
- }
+if ((getUserData('opt_in') != 'Y') && ($mode == 'new')) {
+ $mode = '';
+} // END - if
+
+switch ($mode) {
+ case 'new': // Start new transfer
+ // Get total points and subtract the balance amount from it = maximum transferable points
+ $total = getTotalPoints(getMemberId());
+
+ // Remember maximum value for template
+ $content['max_transferable'] = round($total - getConfig('transfer_balance') - 0.5);
+
+ if (isFormSent()) {
+ // Add new transfer
+ if (getTransferCode() > 0) {
+ // Check for code
+ $code = generateRandomCode(getTransferCode(), postRequestElement('code_chk'), getMemberId(), $content['max_transferable']);
+ $valid_code = ($code == postRequestElement('code'));
+ } else {
+ // Zero length (= disabled) is always valid!
+ $valid_code = TRUE;
+ }
- // Test password
- $valid_pass = ($pass == generateHash($_POST['password'], $pass));
+ // Test password
+ $valid_pass = ($pass == generateHash(postRequestElement('password'), $pass));
- // Test transfer amount
- $valid_amount = ((!empty($_POST['points'])) && ($_POST['points'] <= __TRANSFER_MAX_VALUE));
+ // Test transfer amount
+ $valid_amount = ((isPostRequestElementSet('points')) && (postRequestElement('points') <= $content['max_transferable']));
- // Test reason for transfer
- $valid_reason = (!empty($_POST['reason']));
+ // Test reason for transfer
+ $valid_reason = (isPostRequestElementSet('reason'));
- // Test if a recipient is selected
- $valid_recipient = ($_POST['to_uid'] > 0);
+ // Test if a recipient is selected
+ $valid_recipient = isValidId(postRequestElement('to_userid'));
- // Check for nickname extension and set additional data
- $nick = false; $ADD = ", userid";
- if (EXT_IS_ACTIVE("nickname"))
- {
- $ADD = ", nickname";
- $nick = true;
- }
- // Re-check receivers and own personal data
- $result = SQL_QUERY_ESC("SELECT userid, gender, surname, family, email".$ADD." FROM "._MYSQL_PREFIX."_user_data WHERE userid IN ('%s','%s') AND status='CONFIRMED' ORDER BY userid LIMIT 2",
- array($GLOBALS['userid'], bigintval($_POST['to_uid'])), __FILE__, __LINE__);
- $valid_data = (SQL_NUMROWS($result) == 2);
-
- if ($valid_code && $valid_pass && $valid_amount && $valid_reason && $valid_recipient)
- {
- // Let's start the transfer and load user data
- list($uid1, $gender1, $sname1, $fname1, $email1, $nick1) = SQL_FETCHROW($result);
- list($uid2, $gender2, $sname2, $fname2, $email2, $nick2) = SQL_FETCHROW($result);
- SQL_FREERESULT($result);
- if ($uid1 == $GLOBALS['userid'])
- {
- // Data row 1 is sender's data
- define('__SENDER_GENDER' , TRANSLATE_GENDER($gender1));
- define('__SENDER_NICK' , $nick1);
- define('__SENDER_SNAME' , $sname1);
- define('__SENDER_FNAME' , $fname1);
- define('__SENDER_EMAIL' , $email1);
- // Data row 2 is recpient's data
- define('__RECIPIENT_GENDER' , TRANSLATE_GENDER($gender2));
- define('__RECIPIENT_NICK' , $nick2);
- define('__RECIPIENT_SNAME', $sname2);
- define('__RECIPIENT_FNAME', $fname2);
- define('__RECIPIENT_EMAIL', $email2);
+ // Re-check receivers and own personal data
+ $result = sqlQueryEscaped("SELECT `userid`, `gender`, `surname`, `family`, `email` FROM `{?_MYSQL_PREFIX?}_user_data` WHERE `userid` IN ('%s','%s') AND `status`='CONFIRMED'" . runFilterChain('user_exclusion_sql', ' ') . " LIMIT 2",
+ array(
+ getMemberId(),
+ bigintval(postRequestElement('to_userid'))
+ ), __FILE__, __LINE__);
- // Prepare variables for testing
- $TEST_NICK_SENDER = $nick1;
- $TEST_NICK_REC = $nick2;
- }
- else
- {
- // Data row 2 is sender's data
- define('__SENDER_GENDER' , TRANSLATE_GENDER($gender2));
- define('__SENDER_NICK' , $nick2);
- define('__SENDER_SNAME' , $sname2);
- define('__SENDER_FNAME' , $fname2);
- define('__SENDER_EMAIL' , $email2);
- // Data row 1 is recpient's data
- define('__RECIPIENT_GENDER' , TRANSLATE_GENDER($gender1));
- define('__RECIPIENT_NICK' , $nick1);
- define('__RECIPIENT_SNAME', $sname1);
- define('__RECIPIENT_FNAME', $fname1);
- define('__RECIPIENT_EMAIL', $email1);
+ // Is there two entries?
+ $valid_data = (sqlNumRows($result) == 2);
+
+ // Final check if all is fine
+ if ($valid_code && $valid_data && $valid_pass && $valid_amount && $valid_reason && $valid_recipient) {
+ // Let's start the transfer and load user data
+ $content['sender'] = sqlFetchArray($result);
+ $content['recipient'] = sqlFetchArray($result);
+
+ // Is the nickname extension not installed?
+ if (!isExtensionActive('nickname')) {
+ // Fix empty nicknames
+ $content['sender']['nickname'] = '';
+ $content['recipient']['nickname'] = '';
+ } // END - if
// Prepare variables for testing
- $TEST_NICK_SENDER = $nick2;
- $TEST_NICK_REC = $nick1;
- }
- // Sender's UID is always currently stored in cookie userid...
- define('__SENDER_UID' , $GLOBALS['userid']);
- define('__RECIPIENT_UID' , $_POST['to_uid']);
-
- $SENDER = __SENDER_UID;
- $RECIPIENT = __RECIPIENT_UID;
- if ($nick)
- {
- if (($TEST_NICK_SENDER != __SENDER_UID) && (!empty($TEST_NICK_SENDER)))
- {
- $SENDER = __SENDER_NICK;
- }
- if (($TEST_NICK_REC != __RECIPIENT_UID) && (!empty($TEST_NICK_REC)))
- {
- $RECIPIENT = __RECIPIENT_NICK;
- }
+ $TEST_NICK_SENDER = $content['sender']['nickname'];
+ $TEST_NICK_REC = $content['recipient']['nickname'];
+
+ // Default is userids for subject line
+ $SENDER = getMemberId();
+ $RECIPIENT = bigintval(postRequestElement('to_userid'));
+
+ // If nickname is installed we can set the nickname
+ // @TODO Rewrite this to a filter
+ if (isExtensionActive('nickname')) {
+ if (($TEST_NICK_SENDER != getMemberId()) && (!empty($TEST_NICK_SENDER))) {
+ $SENDER = $content['sender']['nickname'];
+ } // END - if
+
+ if (($TEST_NICK_REC != postRequestElement('to_userid')) && (!empty($TEST_NICK_REC))) {
+ $RECIPIENT = $content['recipient']['nickname'];
+ } // END - if
+ } // END - if
+
+ // Remember transfer reason
+ $content['reason'] = postRequestElement('reason');
+
+ // Generate tranafer id
+ $content['trans_id'] = bigintval(generateRandomCode('10', getRandomTan(), getMemberId(), postRequestElement('reason')));
+
+ // Add entries to both tables
+ sqlQueryEscaped("INSERT INTO `{?_MYSQL_PREFIX?}_user_transfers_in` (`userid`, `from_userid`, `points`, `reason`, `time_trans`, `trans_id`) VALUES (%s,%s,%s,'%s', UNIX_TIMESTAMP(),%s)",
+ array(
+ bigintval(postRequestElement('to_userid')),
+ getMemberId(),
+ bigintval(postRequestElement('points')),
+ postRequestElement('reason'),
+ $content['trans_id']
+ ), __FILE__, __LINE__);
+ sqlQueryEscaped("INSERT INTO `{?_MYSQL_PREFIX?}_user_transfers_out` (`userid`, `to_userid`, `points`, `reason`, `time_trans`, `trans_id`) VALUES (%s,%s,%s,'%s', UNIX_TIMESTAMP(),%s)",
+ array(
+ getMemberId(),
+ bigintval(postRequestElement('to_userid')),
+ bigintval(postRequestElement('points')),
+ postRequestElement('reason'),
+ $content['trans_id']
+ ), __FILE__, __LINE__);
+
+ // Add points to account *directly* ...
+ initReferralSystem();
+ addPointsThroughReferralSystem('transfer', bigintval(postRequestElement('to_userid')), bigintval(postRequestElement('points')));
+
+ // ... and add it to current user's used points and ignore return status
+ subtractPoints('transfer', getMemberId(), postRequestElement('points'));
+
+ // First send email to recipient
+ $message = loadEmailTemplate('member_transfer_recipient', $content, postRequestElement('to_userid'));
+ sendEmail($content['recipient']['userid'], '{--TRANSFER_MEMBER_RECIPIENT_SUBJECT--}' . ': ' . $SENDER, $message);
+
+ // Second send email to sender
+ $message = loadEmailTemplate('member_transfer_sender', $content, getMemberId());
+ sendEmail($content['sender']['userid'], '{--TRANSFER_MEMBER_SENDER_SUBJECT--}' . ': ' . $RECIPIENT, $message);
+
+ // At last send admin mail(s)
+ $adminSubject = sprintf('%s (%s->%s)', '{--ADMIN_TRANSFER_SUBJECT--}', $SENDER, $RECIPIENT);
+ sendAdminNotification($adminSubject, 'admin_transfer_points', $content);
+
+ // Transfer is completed
+ displayMessage('
{--MEMBER_TRANSFER_COMPLETED--}' . '
');
+ } elseif ($valid_code === FALSE) {
+ // Invalid Touring code!
+ displayErrorMessage('{--MEMBER_TRANSFER_INVALID_CODE--}');
+ unsetPostRequestElement('ok');
+ } elseif ($valid_pass === FALSE) {
+ // Wrong password entered
+ displayErrorMessage('{--MEMBER_TRANSFER_INVALID_PASSWORD--}');
+ unsetPostRequestElement('ok');
+ } elseif ($valid_amount === FALSE) {
+ // Too much points entered
+ displayErrorMessage('{--MEMBER_TRANSFER_INVALID_POINTS--}');
+ unsetPostRequestElement('ok');
+ } elseif ($valid_reason === FALSE) {
+ // No transfer reason entered
+ displayErrorMessage('{--MEMBER_TRANSFER_INVALID_REASON--}');
+ unsetPostRequestElement('ok');
+ } elseif ($valid_recipient === FALSE) {
+ // No recipient selected
+ displayErrorMessage('{--MEMBER_TRANSFER_INVALID_RECIPIENT--}');
+ unsetPostRequestElement('ok');
+ } elseif ($valid_data === FALSE) {
+ // No recipient/sender selected
+ displayErrorMessage('{--MEMBER_TRANSFER_INVALID_DATA--}');
+ unsetPostRequestElement('ok');
}
- // Remember transfer reason and fancy date/time in constants
- define('__TRANSFER_REASON', $_POST['reason']);
- if (function_exists('CREATE_FANCY_TIME'))
- {
- define('__TRANSFER_EXPIRES', CREATE_FANCY_TIME($_CONFIG['transfer_age']));
- }
- else
- {
- define('__TRANSFER_EXPIRES', round($_CONFIG['transfer_age']/60/60/24)." ".DAYS);
+ // Free result
+ sqlFreeResult($result);
+ } // END - if
+
+ if (!isFormSent()) {
+ // Load member list
+ $result = sqlQueryEscaped("SELECT `userid` FROM `{?_MYSQL_PREFIX?}_user_data` WHERE `status`='CONFIRMED'" . runFilterChain('user_exclusion_sql', ' ') . " AND `opt_in`='Y' AND `userid` != '%s' ORDER BY `userid` ASC",
+ array(getMemberId()), __FILE__, __LINE__);
+
+ if (!ifSqlHasZeroNumRows($result)) {
+ // Load list
+ $OUT = '';
+ $content['to_disabled'] = '';
+
+ // Free memory
+ sqlFreeResult($result);
+ } else {
+ // No one else is opt-in
+ $OUT = returnMessage('{--MEMBER_TRANSFER_NO_ONE_ELSE_OPT_IN--}');
+ $content['to_disabled'] = ' disabled="disabled"';
}
- // Generate tranafer id
- define('__TRANS_ID', bigintval(GEN_RANDOM_CODE("10", mt_rand(0, 99999), $GLOBALS['userid'], $_POST['reason'])));
+ // Transfer output to constant for the template
+ $content['userid_selection'] = $OUT;
- // Add entries to both tables
- $result = SQL_QUERY_ESC("INSERT INTO "._MYSQL_PREFIX."_user_transfers_in (userid, from_uid, points, reason, time_trans, trans_id) VALUES ('%s','%s','%s','%s', UNIX_TIMESTAMP(),'%s')",
- array(bigintval($_POST['to_uid']), $GLOBALS['userid'], bigintval($_POST['points']), $_POST['reason'], __TRANS_ID),
- __FILE__, __LINE__);
- $result = SQL_QUERY_ESC("INSERT INTO "._MYSQL_PREFIX."_user_transfers_out (userid, to_uid, points, reason, time_trans, trans_id) VALUES ('%s','%s','%s','%s', UNIX_TIMESTAMP(),'%s')",
- array($GLOBALS['userid'], bigintval($_POST['to_uid']), bigintval($_POST['points']), $_POST['reason'], __TRANS_ID),
- __FILE__, __LINE__);
+ // Generate Code
+ if (getTransferCode() > 0) {
+ // Generate random number
+ $rand = getRandomTan();
- // Add points to account *directly* ...
- ADD_POINTS_REFSYSTEM(bigintval($_POST['to_uid']), bigintval($_POST['points']), false, "0", false, "direct");
+ // Generate CAPTCHA code
+ $code = generateRandomCode(getTransferCode(), $rand, getMemberId(), $content['max_transferable']);
- // ... and add it to current user's used points
- SUB_POINTS($GLOBALS['userid'], $_POST['points']);
+ // Generate image (HTML code)
+ $img = generateImageOrCode($code, FALSE);
- // First send email to recipient
- $msg = LOAD_EMAIL_TEMPLATE("member_transfer_recipient", "", __RECIPIENT_UID);
- SEND_EMAIL(__RECIPIENT_EMAIL, TRANSFER_MEMBER_RECIPIENT_SUBJ.": ".$SENDER, $msg);
+ // Add all and hidden field
+ $content['captcha_code'] = ' ' . $img;
+ } else {
+ $code = '00000';
+ $content['captcha_code'] = returnMessage('{--MEMBER_TRANSFER_NO_CODE--}');
+ }
- // Second send email to sender
- $msg = LOAD_EMAIL_TEMPLATE("member_transfer_sender", "", __SENDER_UID);
- SEND_EMAIL(__SENDER_EMAIL, TRANSFER_MEMBER_SENDER_SUBJ.": ".$RECIPIENT, $msg);
+ // Init points/reason
+ $content['points'] = '';
+ $content['reason'] = '';
- // At last send admin mail(s)
- $ADMIN_SUBJ = sprintf("%s (%s->%s)", TRANSFER_ADMIN_SUBJECT, $SENDER, $RECIPIENT);
- SEND_ADMIN_NOTIFICATION($ADMIN_SUBJ, "admin_transfer_points");
+ // Transfer maybe already entered valued'
+ if (isPostRequestElementSet('ok')) {
+ // Get values from form
+ $content['points'] = postRequestElement('points');
+ $content['reason'] = postRequestElement('reason');
+ } // END - if
- // Transfer is completed
- LOAD_TEMPLATE("admin_settings_saved", false, TRANSFER_COMPLETED."
".TRANSFER_CONTINUE_OVERVIEW."");
- }
- elseif (!$valid_code)
- {
- // Invalid Touring code!
- OUTPUT_HTML("".TRANSFER_INVALID_CODE."
");
- unset($_POST['ok']);
- }
- elseif (!$valid_pass)
- {
- // Wrong password entered
- OUTPUT_HTML("".TRANSFER_INVALID_PASSWORD."
");
- unset($_POST['ok']);
- }
- elseif (!$valid_amount)
- {
- // Too much points entered
- OUTPUT_HTML("".TRANSFER_INVALID_POINTS."
");
- unset($_POST['ok']);
- }
- elseif (!$valid_reason)
- {
- // No transfer reason entered
- OUTPUT_HTML("".TRANSFER_INVALID_REASON."
");
- unset($_POST['ok']);
- }
- elseif (!$valid_recipient)
- {
- // No recipient selected
- OUTPUT_HTML("".TRANSFER_INVALID_RECIPIENT."
");
- unset($_POST['ok']);
- }
- elseif (!$valid_data)
- {
- // No recipient selected
- OUTPUT_HTML("".TRANSFER_INVALID_DATA."
");
- unset($_POST['ok']);
- }
- }
- if (!isset($_POST['ok']))
- {
- // Load member list
- if (EXT_IS_ACTIVE("nickname"))
- {
- // Load userid and nickname
- $result = SQL_QUERY_ESC("SELECT userid, nickname FROM "._MYSQL_PREFIX."_user_data WHERE status='CONFIRMED' AND opt_in='Y' AND userid != '%s' ORDER BY userid",
- array($GLOBALS['userid']), __FILE__, __LINE__);
- }
- else
- {
- // Load only userid
- $result = SQL_QUERY_ESC("SELECT userid, userid FROM "._MYSQL_PREFIX."_user_data WHERE status='CONFIRMED' AND opt_in='Y' AND userid != '%s' ORDER BY userid",
- array($GLOBALS['userid']), __FILE__, __LINE__);
- }
- if (SQL_NUMROWS($result) > 0)
- {
- // Load list
- $OUT = "