2 /************************************************************************
3 * MXChange v0.2.1 Start: 09/09/2008 *
4 * ================ Last change: 09/09/2008 *
6 * -------------------------------------------------------------------- *
7 * File : what-refback.php *
8 * -------------------------------------------------------------------- *
9 * Short description : Refback setup *
10 * -------------------------------------------------------------------- *
11 * Kurzbeschreibung : Refback-Einstellungen *
12 * -------------------------------------------------------------------- *
14 * -------------------------------------------------------------------- *
15 * Copyright (c) 2003 - 2008 by Roland Haeder *
16 * For more information visit: http://www.mxchange.org *
18 * This program is free software; you can redistribute it and/or modify *
19 * it under the terms of the GNU General Public License as published by *
20 * the Free Software Foundation; either version 2 of the License, or *
21 * (at your option) any later version. *
23 * This program is distributed in the hope that it will be useful, *
24 * but WITHOUT ANY WARRANTY; without even the implied warranty of *
25 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the *
26 * GNU General Public License for more details. *
28 * You should have received a copy of the GNU General Public License *
29 * along with this program; if not, write to the Free Software *
30 * Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, *
32 ************************************************************************/
34 // Some security stuff...
35 if (!defined('__SECURITY')) {
36 $INC = substr(dirname(__FILE__), 0, strpos(dirname(__FILE__), "/inc") + 4) . "/security.php";
38 } elseif (!IS_MEMBER()) {
39 // User is not logged in
40 LOAD_URL("modules.php?module=index");
41 } elseif ((!EXT_IS_ACTIVE("refback")) && (!IS_ADMIN())) {
42 addFatalMessage(__FILE__, __LINE__, getMessage('EXTENSION_PROBLEM_EXT_INACTIVE'), "refback");
46 // Is the refback system enabled?
47 if (getConfig('refback_enabled') != "Y") {
49 LOAD_TEMPLATE("admin_settings_saved", false, getMessage('MEMBER_REFBACK_DISABLED'));
54 // Add description as navigation point
55 ADD_DESCR("member", __FILE__);
57 // Was the form submitted?
58 if ((REQUEST_ISSET_POST(('edit'))) && (REQUEST_ISSET_POST(('id')))) {
59 // Okay, has the user entered some values?
60 if (REQUEST_ISSET_POST(('percents'))) {
61 // Revert german commta for testing
62 $percents = REVERT_COMMA(REQUEST_POST('percents'));
65 if ((($percents >= getConfig('refback_min_perc')) || (round($percents) == 0)) && ($percents <= getConfig('refback_max_perc'))) {
66 // Change ref-back for this direct id
67 $status = REFBACK_CHANGE_MEMBER_PERCENTS(REQUEST_POST('id'), REQUEST_POST('percents'));
70 if (isset($status['ok'])) {
72 LOAD_TEMPLATE("admin_settings_saved", false, getMessage('MEMBER_REFBACK_DONE'));
73 } elseif (isset($status['message'])) {
74 // Something went wrong with error message
75 LOAD_TEMPLATE("admin_settings_saved", false, sprintf(getMessage('MEMBER_REFBACK_ERROR_MESSAGE'), $status['message']));
78 LOAD_TEMPLATE("admin_settings_saved", false, getMessage('MEMBER_REFBACK_ERROR_EMPTY_MESSAGE'));
81 // Percents out-of-bounds ;-)
82 LOAD_TEMPLATE("admin_settings_saved", false, sprintf(getMessage('MEMBER_REFBACK_ERROR_OUT_OF_BOUNDS'), getConfig('refback_min_perc'), getConfig('refback_max_perc')));
87 // Read data from refback table
88 $content = GET_USER_REF_ENTRY(REQUEST_POST('id'));
91 $content['refback'] = TRANSLATE_COMMA($content['refback']);
92 $content['min'] = TRANSLATE_COMMA(getConfig('refback_min_perc').".0");
93 $content['max'] = TRANSLATE_COMMA(getConfig('refback_max_perc').".0");
95 // Load form for editing
96 LOAD_TEMPLATE("member_refback_edit", false, $content);
100 // Load all referal levels
101 $result = SQL_QUERY_ESC("SELECT r.level, r.percents
102 FROM `{!_MYSQL_PREFIX!}_refdepths` AS r
104 ORDER BY r.level ASC",
105 array($GLOBALS['userid']), __FILE__, __LINE__);
107 // Are there some entries? (Shall be!)
108 if (SQL_NUMROWS($result) > 0) {
111 while ($content = SQL_FETCHARRAY($result)) {
117 // Check for users ref in this level
118 foreach (GET_USER_REFS($GLOBALS['userid'], $content['level']) as $refRow) {
119 // Not-deleted account is default
121 if (is_null($refRow['status'])) $deleted = true;
123 // Add/"translate" more content
125 $refRow['points'] = TRANSLATE_COMMA($refRow['points']);
126 $refRow['refback'] = TRANSLATE_COMMA($refRow['refback']);
127 $refRow['status'] = TRANSLATE_STATUS($refRow['status']);
128 if (empty($refRow['nickname'])) $refRow['nickname'] = "---";
132 $rows .= LOAD_TEMPLATE("member_refback_list_row_deleted", true, $refRow);
134 $rows .= LOAD_TEMPLATE("member_refback_list_row", true, $refRow);
137 // Count this ref and switch color
142 // Remember the content
143 $content['counter'] = TRANSLATE_COMMA($counter);
144 $content['percents'] = TRANSLATE_COMMA($content['percents']);
145 $content['rows'] = $rows;
147 // Load level template
148 $OUT .= LOAD_TEMPLATE("member_refback_list_level", true, $content);
151 // Load main template
152 LOAD_TEMPLATE("member_refback_list", false, $OUT);
155 LOAD_TEMPLATE("admin_settings_saved", false, getMessage('MEMBER_REFBACK_NO_ENTRIES'));
159 SQL_FREERESULT($result);