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 * Copyright (c) 2009, 2010 by Mailer Developer Team *
22 * For more information visit: http://www.mxchange.org *
24 * This program is free software; you can redistribute it and/or modify *
25 * it under the terms of the GNU General Public License as published by *
26 * the Free Software Foundation; either version 2 of the License, or *
27 * (at your option) any later version. *
29 * This program is distributed in the hope that it will be useful, *
30 * but WITHOUT ANY WARRANTY; without even the implied warranty of *
31 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the *
32 * GNU General Public License for more details. *
34 * You should have received a copy of the GNU General Public License *
35 * along with this program; if not, write to the Free Software *
36 * Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, *
38 ************************************************************************/
40 // Some security stuff...
41 if (!defined('__SECURITY')) {
43 } elseif (!isMember()) {
44 // User is not logged in
45 redirectToIndexMemberOnlyModule();
48 // Is the refback system enabled?
49 if (getConfig('refback_enabled') != 'Y') {
51 loadTemplate('admin_settings_saved', false, getMessage('MEMBER_REFBACK_DISABLED'));
56 // Add description as navigation point
57 addMenuDescription('member', __FILE__);
59 if ((!isExtensionActive('refback')) && (!isAdmin())) {
60 loadTemplate('admin_settings_saved', false, generateExtensionInactiveNotInstalledMessage('refback'));
64 // Was the form submitted?
65 if ((isPostRequestParameterSet('edit')) && (isPostRequestParameterSet('id'))) {
66 // Okay, has the user entered some values?
67 if (isPostRequestParameterSet('percents')) {
68 // Revert german commta for testing
69 $percents = convertCommaToDot(postRequestParameter('percents'));
72 if ((($percents >= getConfig('refback_min_perc')) || (round($percents) == 0)) && ($percents <= getConfig('refback_max_perc'))) {
73 // Change ref-back for this direct id
74 $status = updateMemberRefbackPercents(postRequestParameter('id'), postRequestParameter('percents'));
77 if (isset($status['ok'])) {
79 loadTemplate('admin_settings_saved', false, getMessage('MEMBER_REFBACK_DONE'));
80 } elseif (isset($status['message'])) {
81 // Something went wrong with error message
82 loadTemplate('admin_settings_saved', false, getMaskedMessage('MEMBER_REFBACK_ERROR_MESSAGE', $status['message']));
85 loadTemplate('admin_settings_saved', false, getMessage('MEMBER_REFBACK_ERROR_EMPTY_MESSAGE'));
88 // Percents out-of-bounds ;-)
89 loadTemplate('admin_settings_saved', false, getMaskedMessage('MEMBER_REFBACK_ERROR_OUT_OF_BOUNDS'));
94 // Read data from refback table
95 $content = getArrayFromUserRefbackData(postRequestParameter('id'));
98 $content['refback'] = translateComma($content['refback']);
100 // Load form for editing
101 loadTemplate('member_refback_edit', false, $content);
105 // Load all referal levels
106 $result = SQL_QUERY_ESC("SELECT
109 `{?_MYSQL_PREFIX?}_refdepths` AS r
114 array(getMemberId()), __FILE__, __LINE__);
116 // Are there some entries? (Shall be!)
117 if (SQL_NUMROWS($result) > 0) {
120 while ($content = SQL_FETCHARRAY($result)) {
126 // Check for users ref in this level
127 foreach (getArrayFromRefbackUserRefs(getMemberId(), $content['level']) as $refRow) {
128 // Not-deleted account is default
130 if (is_null($refRow['status'])) $deleted = true;
132 // Add/"translate" more content
134 $refRow['points'] = translateComma($refRow['points']);
135 $refRow['refback'] = translateComma($refRow['refback']);
136 // UNUSED: $refRow['status'] = translateUserStatus($refRow['status']);
137 $refRow['joined'] = generateDateTime($refRow['joined'], '3');
138 if (empty($refRow['nickname'])) $refRow['nickname'] = '---';
141 if ($deleted === true) {
142 $rows .= loadTemplate('member_refback_list_row_deleted', true, $refRow);
144 $rows .= loadTemplate('member_refback_list_row', true, $refRow);
147 // Count this ref and switch color
152 // Remember the content
153 $content['counter'] = translateComma($counter);
154 $content['percents'] = translateComma($content['percents']);
155 $content['rows'] = $rows;
157 // Load level template
158 $OUT .= loadTemplate('member_refback_list_level', true, $content);
161 // Load main template
162 loadTemplate('member_refback_list', false, $OUT);
165 loadTemplate('admin_settings_saved', false, getMessage('MEMBER_REFBACK_NO_ENTRIES'));
169 SQL_FREERESULT($result);