X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;ds=sidebyside;f=inc%2Fmodules%2Fmember%2Fwhat-primera.php;h=3a3e730f1bbaa62c7eeafbebdb25519083d18efd;hb=c47144dd555bbab4acdf9085e4623900dedb0e7c;hp=7abf34c0769597a96ba316f1b534f4877e4cc571;hpb=3daede4c904e23905c3e48dd6749019deca0a0e0;p=mailer.git
diff --git a/inc/modules/member/what-primera.php b/inc/modules/member/what-primera.php
index 7abf34c076..3a3e730f1b 100644
--- a/inc/modules/member/what-primera.php
+++ b/inc/modules/member/what-primera.php
@@ -63,7 +63,7 @@ if (!isset($_GET['mode'])) {
$content['refid'] = bigintval(getConfig('primera_refid'));
// Get Primus id
- $result = SQL_QUERY_ESC("SELECT primera_userid FROM `"._MYSQL_PREFIX."_user_data` WHERE userid=%s LIMIT 1",
+ $result = SQL_QUERY_ESC("SELECT primera_userid FROM `{!_MYSQL_PREFIX!}_user_data` WHERE userid=%s LIMIT 1",
array($GLOBALS['userid']), __FILE__, __LINE__);
// Are there some entries?
@@ -81,7 +81,7 @@ if (!isset($_GET['mode'])) {
$_GET['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",
+ $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($GLOBALS['userid']), __FILE__, __LINE__);
// Load all rows
@@ -133,7 +133,7 @@ if ($_GET['mode'] == "pay") {
// Get Primera id
$content['primera_nickname'] = "";
- $result = SQL_QUERY_ESC("SELECT primera_userid FROM `"._MYSQL_PREFIX."_user_data` WHERE userid=%s LIMIT 1",
+ $result = SQL_QUERY_ESC("SELECT primera_userid FROM `{!_MYSQL_PREFIX!}_user_data` WHERE userid=%s LIMIT 1",
array($GLOBALS['userid']), __FILE__, __LINE__);
// Are there some entries?
@@ -159,27 +159,21 @@ if ((isset($_POST['ok'])) && (isset($_GET['mode']))) {
if (empty($_POST['primera_nickname'])) {
// Nothing entered in Primus nickname
LOAD_TEMPLATE("admin_settings_saved", false, PRIMERA_MEMBER_EMPTY_USERNAME);
- OUTPUT_HTML("
");
} elseif (empty($_POST['primera_password'])) {
// Nothing entered in Primera password
LOAD_TEMPLATE("admin_settings_saved", false, PRIMERA_MEMBER_EMPTY_PASSWORD);
- OUTPUT_HTML("
");
} elseif (empty($_POST['amount'])) {
// Nothing entered in amount
LOAD_TEMPLATE("admin_settings_saved", false, PRIMERA_MEMBER_EMPTY_AMOUNT);
- OUTPUT_HTML("
");
} elseif ($_POST['amount'] != bigintval($_POST['amount'])) {
// Only numbers in amount!
LOAD_TEMPLATE("admin_settings_saved", false, PRIMERA_MEMBER_INVALID_AMOUNT);
- OUTPUT_HTML("
");
} elseif ($_POST['amount'] < getConfig('primera_min_payout')) {
// Not enougth entered!
LOAD_TEMPLATE("admin_settings_saved", false, sprintf(PRIMERA_MEMBER_AMOUNT_SMALLER_MIN, bigintval(getConfig('primera_min_payout'))));
- OUTPUT_HTML("
");
} elseif ($_POST['amount'] > $points) {
// Not enougth points left!
LOAD_TEMPLATE("admin_settings_saved", false, sprintf(PRIMERA_MEMBER_PAYOUT_POINTS_DEPLETED, bigintval($_POST['amount']), bigintval($points)));
- OUTPUT_HTML("
");
} else {
// All is fine here so do the payout
$success = PRIMERA_EXECUTE_PAYOUT($_POST['primera_nickname'], md5($_POST['primera_password']), $_POST['amount']);
@@ -197,7 +191,7 @@ if ((isset($_POST['ok'])) && (isset($_GET['mode']))) {
SUB_POINTS("primera_payout", $GLOBALS['userid'], $_POST['amount']);
// Update primera nickname
- SQL_QUERY_ESC("UPDATE `"._MYSQL_PREFIX."_user_data` SET `primera_userid`=%s WHERE userid=%s LIMIT 1",
+ SQL_QUERY_ESC("UPDATE `{!_MYSQL_PREFIX!}_user_data` SET `primera_userid`=%s WHERE userid=%s LIMIT 1",
array($_POST['primera_nickname'], $GLOBALS['userid']), __FILE__, __LINE__);
// All done!
@@ -206,11 +200,9 @@ if ((isset($_POST['ok'])) && (isset($_GET['mode']))) {
} elseif ((GET_PRIMERA_ERROR_CODE() == "user_failed") || (GET_PRIMERA_ERROR_CODE() == "own_failed") || (GET_PRIMERA_ERROR_CODE() == "amount_failed") || (GET_PRIMERA_ERROR_CODE() == "api_amount_failed")) {
// Wrong login data
LOAD_TEMPLATE("admin_settings_saved", false, GET_PRIMERA_ERROR_MESSAGE());
- OUTPUT_HTML("
");
} else {
// Something went wrong
LOAD_TEMPLATE("admin_settings_saved", false, sprintf(PRIMERA_MEMBER_PAYOUT_FAILED, GET_PRIMERA_ERROR_MESSAGE()));
- OUTPUT_HTML("
");
}
}
break;