2 /************************************************************************
3 * Mailer v0.2.1-FINAL 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 * -------------------------------------------------------------------- *
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 // Is the refback system enabled?
48 if (getConfig('refback_enabled') != 'Y') {
50 loadTemplate('admin_settings_saved', false, getMessage('MEMBER_REFBACK_DISABLED'));
55 // Add description as navigation point
56 addMenuDescription('member', __FILE__);
58 if ((!isExtensionActive('refback')) && (!isAdmin())) {
59 loadTemplate('admin_settings_saved', false, generateExtensionInactiveNotInstalledMessage('refback'));
63 // Was the form submitted?
64 if ((isPostRequestParameterSet('edit')) && (isPostRequestParameterSet('id'))) {
65 // Okay, has the user entered some values?
66 if (isPostRequestParameterSet('percents')) {
67 // Revert german commta for testing
68 $percents = convertCommaToDot(postRequestParameter('percents'));
71 if ((($percents >= getConfig('refback_min_perc')) || (round($percents) == '0')) && ($percents <= getConfig('refback_max_perc'))) {
72 // Change ref-back for this direct id
73 $status = updateMemberRefbackPercents(postRequestParameter('id'), postRequestParameter('percents'));
76 if (isset($status['ok'])) {
78 loadTemplate('admin_settings_saved', false, getMessage('MEMBER_REFBACK_DONE'));
79 } elseif (isset($status['message'])) {
80 // Something went wrong with error message
81 loadTemplate('admin_settings_saved', false, getMaskedMessage('MEMBER_REFBACK_ERROR_MESSAGE', $status['message']));
84 loadTemplate('admin_settings_saved', false, getMessage('MEMBER_REFBACK_ERROR_EMPTY_MESSAGE'));
87 // Percents out-of-bounds ;-)
88 loadTemplate('admin_settings_saved', false, getMaskedMessage('MEMBER_REFBACK_ERROR_OUT_OF_BOUNDS'));
93 // Read data from refback table
94 $content = getArrayFromUserRefbackData(postRequestParameter('id'));
97 $content['refback'] = translateComma($content['refback']);
99 // Load form for editing
100 loadTemplate('member_refback_edit', false, $content);
104 // Load all referal levels
105 $result = SQL_QUERY_ESC("SELECT
108 `{?_MYSQL_PREFIX?}_refdepths` AS r
113 array(getMemberId()), __FILE__, __LINE__);
115 // Are there some entries? (Shall be!)
116 if (SQL_NUMROWS($result) > 0) {
119 while ($content = SQL_FETCHARRAY($result)) {
125 // Check for users ref in this level
126 foreach (getArrayFromRefbackUserRefs(getMemberId(), $content['level']) as $refRow) {
127 // Not-deleted account is default
129 if (is_null($refRow['status'])) $deleted = true;
131 // Add/"translate" more content
133 $refRow['points'] = translateComma($refRow['points']);
134 $refRow['refback'] = translateComma($refRow['refback']);
135 // UNUSED: $refRow['status'] = translateUserStatus($refRow['status']);
136 $refRow['joined'] = generateDateTime($refRow['joined'], '3');
137 if (empty($refRow['nickname'])) $refRow['nickname'] = '---';
140 if ($deleted === true) {
141 $rows .= loadTemplate('member_refback_list_row_deleted', true, $refRow);
143 $rows .= loadTemplate('member_refback_list_row', true, $refRow);
146 // Count this ref and switch color
151 // Remember the content
152 $content['counter'] = translateComma($counter);
153 $content['percents'] = translateComma($content['percents']);
154 $content['rows'] = $rows;
156 // Load level template
157 $OUT .= loadTemplate('member_refback_list_level', true, $content);
160 // Load main template
161 loadTemplate('member_refback_list', false, $OUT);
164 loadTemplate('admin_settings_saved', false, getMessage('MEMBER_REFBACK_NO_ENTRIES'));
168 SQL_FREERESULT($result);