2 /************************************************************************
3 * MXChange v0.2.1 Start: 04/12/2004 *
4 * ================ Last change: 11/16/2004 *
6 * -------------------------------------------------------------------- *
7 * File : what-wernis.php *
8 * -------------------------------------------------------------------- *
9 * Short description : Wernis requests *
10 * -------------------------------------------------------------------- *
11 * Kurzbeschreibung : Auszahlungsanfragen *
12 * -------------------------------------------------------------------- *
15 * $Tag:: 0.2.1-FINAL $ *
17 * Needs to be in all Files and every File needs "svn propset *
18 * svn:keywords Date Revision" (autoprobset!) at least!!!!!! *
19 * -------------------------------------------------------------------- *
20 * Copyright (c) 2003 - 2009 by Roland Haeder *
21 * For more information visit: http://www.mxchange.org *
23 * This program is free software; you can redistribute it and/or modify *
24 * it under the terms of the GNU General Public License as published by *
25 * the Free Software Foundation; either version 2 of the License, or *
26 * (at your option) any later version. *
28 * This program is distributed in the hope that it will be useful, *
29 * but WITHOUT ANY WARRANTY; without even the implied warranty of *
30 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the *
31 * GNU General Public License for more details. *
33 * You should have received a copy of the GNU General Public License *
34 * along with this program; if not, write to the Free Software *
35 * Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, *
37 ************************************************************************/
39 // Some security stuff...
40 if (!defined('__SECURITY')) {
42 } elseif (!isMember()) {
43 // User is not logged in
44 redirectToIndexMemberOnlyModule();
47 // Add description as navigation point
48 addMenuDescription('member', __FILE__);
50 if ((!isExtensionActive('wernis')) && (!isAdmin())) {
51 loadTemplate('admin_settings_saved', false, generateExtensionInactiveNotInstalledMessage('wernis'));
55 // Check if the admin has entered the data
56 if ((getConfig('wernis_api_id') == '') || (getConfig('wernis_api_md5') == '')) {
57 // Something important is missing...
58 loadTemplate('admin_settings_saved', false, getMessage('WERNIS_MEMBER_API_DATA_MISSING'));
62 // Init the content array and points
63 $content = array(); $points = false;
65 // Is the mode set (withdraw or payout)
66 if ((!isGetRequestElementSet('mode')) || (getRequestElement('mode') == 'choose')) {
67 // Let the user choose what he wants to do
68 $content['refid'] = getConfig(('wernis_refid'));
69 $content['wds66_id'] = 0;
72 $result = SQL_QUERY_ESC("SELECT wernis_userid FROM `{?_MYSQL_PREFIX?}_user_data` WHERE `userid`=%s LIMIT 1",
73 array(getUserId()), __FILE__, __LINE__);
75 // Are there some entries?
76 if (SQL_NUMROWS($result) == 1) {
78 list($content['wds66_id']) = SQL_FETCHROW($result);
82 SQL_FREERESULT($result);
85 if ((!empty($content['wds66_id'])) && (!isGetRequestElementSet('mode'))) {
86 // Then use an other "mode"
87 setRequestGetElement('mode', 'list');
90 $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",
91 array(getUserId()), __FILE__, __LINE__);
94 $content['rows'] = ''; $SW = 2;
95 while ($data = SQL_FETCHARRAY($result)) {
96 // Prepare data for output
98 'stamp' => generateDateTime($data['wernis_timestamp'], 2),
99 'points' => translateComma($data['wernis_amount']),
100 'acc' => bigintval($data['wernis_account']),
101 'status' => WERNIS_TRANSFER_STATUS($data['wernis_type']),
102 'raw_type' => strtolower($data['wernis_type']),
107 $content['rows'] .= loadTemplate('member_wernis_mode_list_row', true, $rowContent);
112 SQL_FREERESULT($result);
114 // Default links are not active!
115 $content['payout_link'] = '<em>{--WERNIS_MEMBER_PAYOUT_DISABLED--}</em>';
116 $content['withdraw_link'] = '<em>{--WERNIS_MEMBER_WITHDRAW_DISABLED--}</em>';
118 // Is the payout mode active?
119 if (getConfig('wernis_payout_active') == 'Y') {
121 $content['payout_link'] = "<a class=\"menu_blur\" style=\"height: 40px\" href=\"{?URL?}/modules.php?module=login&what=wernis&mode=payout\"><div style=\"padding-top: 10px\">{--MEMBER_WERNIS_MODE_PAYOUT--}</div></a>";
124 // Is the withdraw mode active?
125 if (getConfig('wernis_withdraw_active') == 'Y') {
127 $content['withdraw_link'] = "<a class=\"menu_blur\" style=\"height: 40px\" href=\"{?URL?}/modules.php?module=login&what=wernis&mode=withdraw\"><div style=\"padding-top: 10px\">{--MEMBER_WERNIS_MODE_WITHDRAW--}</div></a>";
131 setRequestGetElement('mode', 'choose');
133 } elseif ((getRequestElement('mode') == 'payout') && (getConfig('wernis_payout_active') == 'Y')) {
134 // Get total points and check if the user can request a payout
135 $points = countSumTotalData(getUserId(), 'user_points', 'points') - countSumTotalData(getUserId(), 'user_data', 'used_points');
137 // Remove the registration fee
138 $points = $points - getConfig('points_register');
140 // Is there a percentage or fixed fee?
141 $points = WERNIS_TAKE_FEE($points, 'payout');
143 // Is this enougth for a payout?
144 if ($points < getConfig('wernis_min_payout')) {
145 // No, then abort here
146 loadTemplate('admin_settings_saved', false, sprintf(getMessage('WERNIS_MEMBER_MIN_PAYOUT'), translateComma(getConfig('wernis_min_payout'))));
151 $points = explode('.', $points);
152 $points = bigintval($points[0]);
154 // Add points to content array
155 $content['points'] = translateComma($points);
156 $content['min_points'] = translateComma(getConfig('wernis_min_payout'));
159 WERNIS_ADD_FEES_TO_ARRAY($content);
162 $content['wds66_id'] = '';
163 $result = SQL_QUERY_ESC("SELECT `wernis_userid` FROM `{?_MYSQL_PREFIX?}_user_data` WHERE `userid`=%s LIMIT 1",
164 array(getUserId()), __FILE__, __LINE__);
166 // Are there some entries?
167 if (SQL_NUMROWS($result) == 1) {
169 list($content['wds66_id']) = SQL_FETCHROW($result);
173 SQL_FREERESULT($result);
174 } elseif ((getRequestElement('mode') == 'withdraw') && (getConfig('wernis_withdraw_active') == 'Y')) {
175 // Get total points for just displaying them
176 $points = countSumTotalData(getUserId(), 'user_points', 'points') - countSumTotalData(getUserId(), 'user_data', 'used_points');
178 // Prepare data for the template
179 $content['points'] = translateComma($points);
180 $content['min_points'] = translateComma(getConfig('wernis_min_withdraw'));
181 $content['wds66_id'] = '';
184 WERNIS_ADD_FEES_TO_ARRAY($content);
187 $result = SQL_QUERY_ESC("SELECT `wernis_userid` FROM `{?_MYSQL_PREFIX?}_user_data` WHERE `userid`=%s LIMIT 1",
188 array(getUserId()), __FILE__, __LINE__);
190 // Are there some entries?
191 if (SQL_NUMROWS($result) == 1) {
193 list($content['wds66_id']) = SQL_FETCHROW($result);
197 SQL_FREERESULT($result);
200 loadTemplate('admin_settings_saved', false, sprintf(getMessage('WERNIS_MEMBER_MODE_INVALID'), getRequestElement('mode')));
204 // Is the formular sent?
205 if ((isFormSent()) && (isGetRequestElementSet('mode'))) {
206 // Is the user ID and password set?
207 if (!isPostRequestElementSet(('wds66_id'))) {
208 // Nothing entered in WDS66 user ID
209 loadTemplate('admin_settings_saved', false, getMessage('WERNIS_MEMBER_EMPTY_USERNAME'));
210 } elseif (!isPostRequestElementSet(('wds66_password'))) {
211 // Nothing entered in WDS66 password
212 loadTemplate('admin_settings_saved', false, getMessage('WERNIS_MEMBER_EMPTY_PASSWORD'));
213 } elseif (!isPostRequestElementSet(('amount'))) {
214 // Nothing entered in amount
215 loadTemplate('admin_settings_saved', false, getMessage('WERNIS_MEMBER_EMPTY_AMOUNT'));
216 } elseif (postRequestElement('wds66_id') != bigintval(postRequestElement('wds66_id'))) {
217 // Only numbers in account ID!
218 loadTemplate('admin_settings_saved', false, getMessage('WERNIS_MEMBER_INVALID_USERNAME'));
219 } elseif (postRequestElement('amount') != bigintval(postRequestElement('amount'))) {
220 // Only numbers in amount!
221 loadTemplate('admin_settings_saved', false, getMessage('WERNIS_MEMBER_INVALID_AMOUNT'));
223 // Check input data depending on the mode and execute the requested mode
224 switch (getRequestElement('mode')) {
225 case "withdraw": // Widthdraws WDS66 -> This exchange
226 if (postRequestElement('amount') < getConfig('wernis_min_withdraw')) {
227 // Not enougth entered!
228 loadTemplate('admin_settings_saved', false, sprintf(getMessage('WERNIS_MEMBER_AMOUNT_SMALLER_MIN'), getConfig(('wernis_min_withdraw'))));
230 // All is fine here so do the withdraw
231 $success = WERNIS_EXECUTE_WITHDRAW(postRequestElement('wds66_id'), md5(postRequestElement('wds66_password')), postRequestElement('amount'));
232 if ($success === true) {
233 // Add it to this amount
234 addPointsDirectly('wernis_withdraw', getUserId(), bigintval(postRequestElement('amount')));
236 // Update the user data as well..
237 SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_user_data` SET `wernis_userid`=%s WHERE `userid`=%s LIMIT 1",
238 array(bigintval(postRequestElement('wds66_id')), getUserId()), __FILE__, __LINE__);
241 loadTemplate('admin_settings_saved', false, getMessage('WERNIS_MEMBER_WITHDRAW_DONE'));
243 } elseif ((GET_WERNIS_ERROR_CODE() == "user_failed") || (GET_WERNIS_ERROR_CODE() == "own_failed") || (GET_WERNIS_ERROR_CODE() == "amount_failed")) {
245 loadTemplate('admin_settings_saved', false, GET_WERNIS_ERROR_MESSAGE());
247 // Something went wrong
248 loadTemplate('admin_settings_saved', false, sprintf(getMessage('WERNIS_MEMBER_WITHDRAW_FAILED'), GET_WERNIS_ERROR_MESSAGE()));
253 case 'payout': // Payout this exchange -> WDS66
254 if (postRequestElement('amount') < getConfig('wernis_min_payout')) {
255 // Not enougth entered!
256 loadTemplate('admin_settings_saved', false, sprintf(getMessage('WERNIS_MEMBER_AMOUNT_SMALLER_MIN'), getConfig(('wernis_min_payout'))));
257 } elseif (postRequestElement('amount') > $points) {
258 // Not enougth points left!
259 loadTemplate('admin_settings_saved', false, sprintf(getMessage('WERNIS_MEMBER_PAYOUT_POINTS_DEPLETED'), bigintval(postRequestElement('amount')), bigintval($points)));
261 // All is fine here so do the withdraw
262 $success = WERNIS_EXECUTE_PAYOUT(postRequestElement('wds66_id'), postRequestElement('amount'));
263 if ($success === true) {
265 subtractPoints('wernis_payout', getUserId(), postRequestElement('amount'));
268 SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_user_data` SET `wernis_userid`=%s WHERE `userid`=%s LIMIT 1",
269 array(bigintval(postRequestElement('wds66_id')), getUserId()), __FILE__, __LINE__);
272 loadTemplate('admin_settings_saved', false, getMessage('WERNIS_MEMBER_PAYOUT_DONE'));
274 } 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')) {
276 loadTemplate('admin_settings_saved', false, GET_WERNIS_ERROR_MESSAGE());
278 // Something went wrong
279 loadTemplate('admin_settings_saved', false, sprintf(getMessage('WERNIS_MEMBER_WITHDRAW_FAILED'), GET_WERNIS_ERROR_MESSAGE()));
284 default: // Invalid mode!
285 logDebugMessage(__FILE__, __LINE__, sprintf("Invalid mode %s detected.", getRequestElement('mode')));
286 loadTemplate('admin_settings_saved', false, sprintf(getMessage('WERNIS_MEMBER_MODE_INVALID'), getRequestElement('mode')));
292 // Prepare mode for template name
293 $mode = sprintf("member_wernis_mode_%s", getRequestElement('mode'));
296 loadTemplate($mode, false, $content);