<?php
/************************************************************************
- * MXChange v0.2.1 Start: 09/09/2008 *
- * ================ Last change: 09/09/2008 *
+ * Mailer v0.2.1-FINAL Start: 09/09/2008 *
+ * =================== Last change: 09/09/2008 *
* *
* -------------------------------------------------------------------- *
* File : what-primera.php *
// Get referal id
$content['refid'] = getConfig(('primera_refid'));
- // Get Primus id
- $result = SQL_QUERY_ESC("SELECT `primera_userid` FROM `{?_MYSQL_PREFIX?}_user_data` WHERE `userid`=%s LIMIT 1",
- array(getUserId()), __FILE__, __LINE__);
-
- // Are there some entries?
- if (SQL_NUMROWS($result) == 1) {
- // Fetch ID
- list($content['primera_nickname']) = SQL_FETCHROW($result);
- } // END - if
-
- // Free result
- SQL_FREERESULT($result);
-
- // Is there an ID?
+ // Is there an id?
if ((!empty($content['primera_nickname'])) && (!isGetRequestElementSet('mode'))) {
// Then use an other "mode"
- setRequestGetElement('mode', 'list');
+ setGetRequestElement('mode', 'list');
// And load all rows!
- $result = SQL_QUERY_ESC("SELECT `id`,`primera_account`,`primera_amount`,`primera_timestamp`,`primera_type` FROM `{?_MYSQL_PREFIX?}_user_primera` WHERE `userid` = %s ORDER BY `primera_timestamp` DESC",
- array(getUserId()), __FILE__, __LINE__);
+ $result = SQL_QUERY_ESC("SELECT `id`,`primera_account`,`primera_amount`,`primera_timestamp`,`primera_type` FROM `{?_MYSQL_PREFIX?}_user_primera` WHERE `userid`=%s ORDER BY `primera_timestamp` DESC",
+ array(getMemberId()), __FILE__, __LINE__);
// Load all rows
$content['rows'] = ''; $SW = 2;
while ($data = SQL_FETCHARRAY($result)) {
// Prepare data for output
$rowContent = array(
- 'stamp' => generateDateTime($data['primera_timestamp'], '2'),
- 'points' => translateComma($data['primera_amount']),
- 'acc' => SQL_ESCAPE($data['primera_account']),
- 'status' => PRIMERA_TRANSFER_STATUS($data['primera_type']),
- 'raw_type' => strtolower($data['primera_type']),
- 'sw' => $SW,
+ 'primera_timestamp' => generateDateTime($data['primera_timestamp'], 2),
+ 'points' => translateComma($data['primera_amount']),
+ 'primera_account' => SQL_ESCAPE($data['primera_account']),
+ 'status' => PRIMERA_TRANSFER_STATUS($data['primera_type']),
+ 'raw_type' => strtolower($data['primera_type']),
+ 'sw' => $SW,
);
// Load row template
SQL_FREERESULT($result);
} else {
// Mode pay
- setRequestGetElement('mode', 'pay');
+ setGetRequestElement('mode', 'pay');
}
} // END - if
if (getRequestElement('mode') == 'pay') {
// Get total points and check if the user can request a payout
- $points = countSumTotalData(getUserId(), 'user_points', 'points') - countSumTotalData(getUserId(), 'user_data', 'used_points');
+ $points = countSumTotalData(getMemberId(), 'user_points', 'points') - countSumTotalData(getMemberId(), 'user_data', 'used_points');
// No dots here...
$points = explode('.', $points);
// Is this enougth for a payout?
if ($points < getConfig('primera_min_payout')) {
// No, then abort here
- loadTemplate('admin_settings_saved', false, sprintf(getMessage('PRIMERA_MEMBER_MIN_PAYOUT_PAYOUT'), translateComma(getConfig('primera_min_payout'))));
+ loadTemplate('admin_settings_saved', false, getMessage('PRIMERA_MEMBER_MIN_PAYOUT_PAYOUT'));
return;
}
// Add points to content array
- $content['points'] = $points;
- $content['min_points'] = translateComma(getConfig('primera_min_payout'));
-
- // Get Primera id
- $content['primera_nickname'] = '';
- $result = SQL_QUERY_ESC("SELECT `primera_userid` FROM `{?_MYSQL_PREFIX?}_user_data` WHERE `userid`=%s LIMIT 1",
- array(getUserId()), __FILE__, __LINE__);
-
- // Are there some entries?
- if (SQL_NUMROWS($result) == 1) {
- // Fetch ID
- list($content['primera_nickname']) = SQL_FETCHROW($result);
- }
-
- // Free result
- SQL_FREERESULT($result);
+ $content['points'] = $points;
} else {
// Invalid mode!
- loadTemplate('admin_settings_saved', false, sprintf(getMessage('PRIMERA_MEMBER_MODE_INVALID'), getRequestElement('mode')));
+ loadTemplate('admin_settings_saved', false, getMaskedMessage('PRIMERA_MEMBER_MODE_INVALID', getRequestElement('mode')));
return;
}
// Check input data depending on the mode and execute the requested mode
switch (getRequestElement('mode')) {
case 'pay': // Payout this exchange -> Primus
- // Is the user ID and password set?
+ // Is the user id and password set?
if (!isPostRequestElementSet(('primera_nickname'))) {
// Nothing entered in Primus nickname
loadTemplate('admin_settings_saved', false, getMessage('PRIMERA_MEMBER_EMPTY_USERNAME'));
loadTemplate('admin_settings_saved', false, getMessage('PRIMERA_MEMBER_INVALID_AMOUNT'));
} elseif (postRequestElement('amount') < getConfig('primera_min_payout')) {
// Not enougth entered!
- loadTemplate('admin_settings_saved', false, sprintf(getMessage('PRIMERA_MEMBER_AMOUNT_SMALLER_MIN'), getConfig(('primera_min_payout'))));
+ loadTemplate('admin_settings_saved', false, getMessage('PRIMERA_MEMBER_AMOUNT_SMALLER_MIN'));
} elseif (postRequestElement('amount') > $points) {
// Not enougth points left!
loadTemplate('admin_settings_saved', false, sprintf(getMessage('PRIMERA_MEMBER_PAYOUT_POINTS_DEPLETED'), bigintval(postRequestElement('amount')), bigintval($points)));
} // END - if
// Remove points from account
- subtractPoints('primera_payout', getUserId(), postRequestElement('amount'));
+ subtractPoints('primera_payout', getMemberId(), postRequestElement('amount'));
// Update primera nickname
- SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_user_data` SET `primera_userid`=%s WHERE `userid`=%s LIMIT 1",
- array(postRequestElement('primera_nickname'), getUserId()), __FILE__, __LINE__);
+ SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_user_data` SET `primera_nickname`=%s WHERE `userid`=%s LIMIT 1",
+ array(postRequestElement('primera_nickname'), getMemberId()), __FILE__, __LINE__);
// All done!
loadTemplate('admin_settings_saved', false, getMessage('PRIMERA_MEMBER_PAYOUT_DONE'));
loadTemplate('admin_settings_saved', false, GET_PRIMERA_ERROR_MESSAGE());
} else {
// Something went wrong
- loadTemplate('admin_settings_saved', false, sprintf(getMessage('PRIMERA_MEMBER_PAYOUT_FAILED'), GET_PRIMERA_ERROR_MESSAGE()));
+ loadTemplate('admin_settings_saved', false, getMaskedMessage('PRIMERA_MEMBER_PAYOUT_FAILED', GET_PRIMERA_ERROR_MESSAGE()));
}
}
break;
default: // Invalid mode!
logDebugMessage(__FILE__, __LINE__, sprintf("Invalid mode %s detected.", getRequestElement('mode')));
- loadTemplate('admin_settings_saved', false, sprintf(getMessage('PRIMERA_MEMBER_MODE_INVALID'), getRequestElement('mode')));
+ loadTemplate('admin_settings_saved', false, getMaskedMessage('PRIMERA_MEMBER_MODE_INVALID', getRequestElement('mode')));
return;
}
} // END - if