X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Fmodules%2Fmember%2Fwhat-wernis.php;h=8e5465d241df9a741b9fc7dff5bd6acf433cbd09;hp=1773a61282e6101235036f8dd64ca53e9f6387cb;hb=c47144dd555bbab4acdf9085e4623900dedb0e7c;hpb=22a33b87f9894a94efb71de7630f12129e34f83b
diff --git a/inc/modules/member/what-wernis.php b/inc/modules/member/what-wernis.php
index 1773a61282..8e5465d241 100644
--- a/inc/modules/member/what-wernis.php
+++ b/inc/modules/member/what-wernis.php
@@ -39,7 +39,7 @@ if (!defined('__SECURITY')) {
// User is not logged in
LOAD_URL("modules.php?module=index");
} elseif ((!EXT_IS_ACTIVE("wernis")) && (!IS_ADMIN())) {
- ADD_FATAL(EXTENSION_PROBLEM_EXT_INACTIVE, "wernis");
+ addFatalMessage(EXTENSION_PROBLEM_EXT_INACTIVE, "wernis");
return;
}
@@ -63,7 +63,7 @@ if ((!isset($_GET['mode'])) || ($_GET['mode'] == "choose")) {
$content['wds66_id'] = 0;
// Get WDS66 id
- $result = SQL_QUERY_ESC("SELECT wernis_userid FROM `"._MYSQL_PREFIX."_user_data` WHERE userid=%s LIMIT 1",
+ $result = SQL_QUERY_ESC("SELECT wernis_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'] == "choose")) {
$_GET['mode'] = "list";
// And load all rows!
- $result = SQL_QUERY_ESC("SELECT `id`, `wernis_account`, `wernis_amount`, `wernis_timestamp`, `wernis_type` FROM "._MYSQL_PREFIX."_user_wernis WHERE `userid` = %s ORDER BY `wernis_timestamp` DESC",
+ $result = SQL_QUERY_ESC("SELECT `id`, `wernis_account`, `wernis_amount`, `wernis_timestamp`, `wernis_type` FROM `{!_MYSQL_PREFIX!}_user_wernis` WHERE `userid` = %s ORDER BY `wernis_timestamp` DESC",
array($GLOBALS['userid']), __FILE__, __LINE__);
// Load all rows
@@ -112,13 +112,13 @@ if ((!isset($_GET['mode'])) || ($_GET['mode'] == "choose")) {
// Is the payout mode active?
if (getConfig('wernis_payout_active') == "Y") {
// Add link
- $content['payout_link'] = "";
+ $content['payout_link'] = "";
} // END - if
// Is the withdraw mode active?
if (getConfig('wernis_withdraw_active') == "Y") {
// Add link
- $content['withdraw_link'] = "";
+ $content['withdraw_link'] = "";
} // END - if
// Mode chooser! ;-)
@@ -154,7 +154,7 @@ if ((!isset($_GET['mode'])) || ($_GET['mode'] == "choose")) {
// Get WDS66 id
$content['wds66_id'] = "";
- $result = SQL_QUERY_ESC("SELECT wernis_userid FROM `"._MYSQL_PREFIX."_user_data` WHERE userid=%s LIMIT 1",
+ $result = SQL_QUERY_ESC("SELECT wernis_userid FROM `{!_MYSQL_PREFIX!}_user_data` WHERE userid=%s LIMIT 1",
array($GLOBALS['userid']), __FILE__, __LINE__);
// Are there some entries?
@@ -178,7 +178,7 @@ if ((!isset($_GET['mode'])) || ($_GET['mode'] == "choose")) {
WERNIS_ADD_FEES_TO_ARRAY($content);
// Get WDS66 id
- $result = SQL_QUERY_ESC("SELECT wernis_userid FROM `"._MYSQL_PREFIX."_user_data` WHERE userid=%s LIMIT 1",
+ $result = SQL_QUERY_ESC("SELECT wernis_userid FROM `{!_MYSQL_PREFIX!}_user_data` WHERE userid=%s LIMIT 1",
array($GLOBALS['userid']), __FILE__, __LINE__);
// Are there some entries?
@@ -201,23 +201,18 @@ if ((isset($_POST['ok'])) && (isset($_GET['mode']))) {
if (empty($_POST['wds66_id'])) {
// Nothing entered in WDS66 user ID
LOAD_TEMPLATE("admin_settings_saved", false, WERNIS_MEMBER_EMPTY_USERNAME);
- OUTPUT_HTML("
");
} elseif (empty($_POST['wds66_password'])) {
// Nothing entered in WDS66 password
LOAD_TEMPLATE("admin_settings_saved", false, WERNIS_MEMBER_EMPTY_PASSWORD);
- OUTPUT_HTML("
");
} elseif (empty($_POST['amount'])) {
// Nothing entered in amount
LOAD_TEMPLATE("admin_settings_saved", false, WERNIS_MEMBER_EMPTY_AMOUNT);
- OUTPUT_HTML("
");
} elseif ($_POST['wds66_id'] != bigintval($_POST['wds66_id'])) {
// Only numbers in account ID!
LOAD_TEMPLATE("admin_settings_saved", false, WERNIS_MEMBER_INVALID_USERNAME);
- OUTPUT_HTML("
");
} elseif ($_POST['amount'] != bigintval($_POST['amount'])) {
// Only numbers in amount!
LOAD_TEMPLATE("admin_settings_saved", false, WERNIS_MEMBER_INVALID_AMOUNT);
- OUTPUT_HTML("
");
} else {
// Check input data depending on the mode and execute the requested mode
switch ($_GET['mode']) {
@@ -225,7 +220,6 @@ if ((isset($_POST['ok'])) && (isset($_GET['mode']))) {
if ($_POST['amount'] < getConfig('wernis_min_withdraw')) {
// Not enougth entered!
LOAD_TEMPLATE("admin_settings_saved", false, sprintf(WERNIS_MEMBER_AMOUNT_SMALLER_MIN, bigintval(getConfig('wernis_min_withdraw'))));
- OUTPUT_HTML("
");
} else {
// All is fine here so do the withdraw
$success = WERNIS_EXECUTE_WITHDRAW($_POST['wds66_id'], md5($_POST['wds66_password']), $_POST['amount']);
@@ -235,7 +229,7 @@ if ((isset($_POST['ok'])) && (isset($_GET['mode']))) {
ADD_POINTS_REFSYSTEM("wernis_withdraw", $GLOBALS['userid'], bigintval($_POST['amount']), false, 0, false, "direct");
// Update the user data as well..
- $result = SQL_QUERY_ESC("UPDATE `"._MYSQL_PREFIX."_user_data` SET `wernis_userid`=%s WHERE userid=%s LIMIT 1",
+ SQL_QUERY_ESC("UPDATE `{!_MYSQL_PREFIX!}_user_data` SET `wernis_userid`=%s WHERE userid=%s LIMIT 1",
array(bigintval($_POST['wds66_id']), $GLOBALS['userid']), __FILE__, __LINE__);
// All done!
@@ -244,11 +238,9 @@ if ((isset($_POST['ok'])) && (isset($_GET['mode']))) {
} elseif ((GET_WERNIS_ERROR_CODE() == "user_failed") || (GET_WERNIS_ERROR_CODE() == "own_failed") || (GET_WERNIS_ERROR_CODE() == "amount_failed")) {
// Wrong login data
LOAD_TEMPLATE("admin_settings_saved", false, GET_WERNIS_ERROR_MESSAGE());
- OUTPUT_HTML("
");
} else {
// Something went wrong
LOAD_TEMPLATE("admin_settings_saved", false, sprintf(WERNIS_MEMBER_WITHDRAW_FAILED, GET_WERNIS_ERROR_MESSAGE()));
- OUTPUT_HTML("
");
}
}
break;
@@ -257,11 +249,9 @@ if ((isset($_POST['ok'])) && (isset($_GET['mode']))) {
if ($_POST['amount'] < getConfig('wernis_min_payout')) {
// Not enougth entered!
LOAD_TEMPLATE("admin_settings_saved", false, sprintf(WERNIS_MEMBER_AMOUNT_SMALLER_MIN, bigintval(getConfig('wernis_min_payout'))));
- OUTPUT_HTML("
");
} elseif ($_POST['amount'] > $points) {
// Not enougth points left!
LOAD_TEMPLATE("admin_settings_saved", false, sprintf(WERNIS_MEMBER_PAYOUT_POINTS_DEPLETED, bigintval($_POST['amount']), bigintval($points)));
- OUTPUT_HTML("
");
} else {
// All is fine here so do the withdraw
$success = WERNIS_EXECUTE_PAYOUT($_POST['wds66_id'], $_POST['amount']);
@@ -270,7 +260,7 @@ if ((isset($_POST['ok'])) && (isset($_GET['mode']))) {
SUB_POINTS("wernis_payout", $GLOBALS['userid'], $_POST['amount']);
// Update WDS66 id
- $result = SQL_QUERY_ESC("UPDATE `"._MYSQL_PREFIX."_user_data` SET `wernis_userid`=%s WHERE userid=%s LIMIT 1",
+ SQL_QUERY_ESC("UPDATE `{!_MYSQL_PREFIX!}_user_data` SET `wernis_userid`=%s WHERE userid=%s LIMIT 1",
array(bigintval($_POST['wds66_id']), $GLOBALS['userid']), __FILE__, __LINE__);
// All done!
@@ -279,11 +269,9 @@ if ((isset($_POST['ok'])) && (isset($_GET['mode']))) {
} elseif ((GET_WERNIS_ERROR_CODE() == "user_failed") || (GET_WERNIS_ERROR_CODE() == "own_failed") || (GET_WERNIS_ERROR_CODE() == "amount_failed") || (GET_WERNIS_ERROR_CODE() == "api_amount_failed")) {
// Wrong login data
LOAD_TEMPLATE("admin_settings_saved", false, GET_WERNIS_ERROR_MESSAGE());
- OUTPUT_HTML("
");
} else {
// Something went wrong
LOAD_TEMPLATE("admin_settings_saved", false, sprintf(WERNIS_MEMBER_WITHDRAW_FAILED, GET_WERNIS_ERROR_MESSAGE()));
- OUTPUT_HTML("
");
}
}
break;