Nickname active, but id provided should result in valid refid
[mailer.git] / ref.php
1 <?php
2 /************************************************************************
3  * MXChange v0.2.1                                    Start: 10/13/2003 *
4  * ===============                              Last change: 09/04/2004 *
5  *                                                                      *
6  * -------------------------------------------------------------------- *
7  * File              : ref.php                                          *
8  * -------------------------------------------------------------------- *
9  * Short description : Redirection for the referal link                 *
10  * -------------------------------------------------------------------- *
11  * Kurzbeschreibung  : Weiterleitungsscript fuer die Referal-Links      *
12  * -------------------------------------------------------------------- *
13  * $Revision::                                                        $ *
14  * $Date::                                                            $ *
15  * $Tag:: 0.2.1-FINAL                                                 $ *
16  * $Author::                                                          $ *
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                  *
22  *                                                                      *
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.                                  *
27  *                                                                      *
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.                         *
32  *                                                                      *
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,               *
36  * MA  02110-1301  USA                                                  *
37  ************************************************************************/
38
39 // Load security stuff here
40 require('inc/libs/security_functions.php');
41
42 // Set module
43 $GLOBALS['module'] = 'ref';
44 $GLOBALS['output_mode'] = -1;
45
46 // Load the required file(s)
47 require('inc/config-global.php');
48
49 // No refid by default
50 $URL = 'index.php';
51
52 // Invalid request by default
53 $ref = 0;
54
55 // Base URL for redirection
56 switch (getConfig('refid_target')) {
57         case 'register':
58                 $URL = 'modules.php?module=index&amp;what=register&amp;refid=';
59                 break;
60
61         case 'index':
62                 $URL = 'index.php?refid=';
63                 break;
64 } // END - switch
65
66 // Get referal ID from ref or refid variable
67 if (isGetRequestElementSet('ref'))        $ref = getRequestElement('ref');
68  elseif (isGetRequestElementSet('refid')) $ref = getRequestElement('refid');
69
70 if (!empty($ref)) {
71         // Test if nickname or numeric id
72         if (isExtensionActive('nickname')) {
73                 // Nickname in URL, so load the ID
74                 $result = SQL_QUERY_ESC("SELECT `userid` FROM `{?_MYSQL_PREFIX?}_user_data` WHERE `nickname`='%s' LIMIT 1",
75                         array($ref), __FILE__, __LINE__);
76
77                 // Do we have an entry?
78                 if (SQL_NUMROWS($result) == 1) {
79                         // Load userid
80                         list($ref) = SQL_FETCHROW($result);
81                 } else {
82                         // So do we have a userid?
83                         $result2 = SQL_QUERY_ESC("SELECT `userid` FROM `{?_MYSQL_PREFIX?}_user_data` WHERE `userid`='%s' LIMIT 1",
84                                 array($ref), __FILE__, __LINE__);
85
86                         // Do we have an entry?
87                         if (SQL_NUMROWS($result2) == 0) {
88                                 // No entry, so no referal id
89                                 $ref = 0;
90                         } // END - if
91
92                         // Free result
93                         SQL_FREERESULT($result2);
94                 }
95
96                 // Free result
97                 SQL_FREERESULT($result);
98         } // END - if
99
100         // Also edit this 0 !
101         if (empty($ref)) $ref = 0;
102
103         // Update session
104         setSession('refid', $ref);
105
106         // We have an refid here. So we simply add it
107         $URL .= bigintval($ref);
108
109         // Is the refid valid?
110         if ($ref > 0) {
111                 // Update ref counter
112                 SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_user_data` SET `ref_clicks`=`ref_clicks`+1 WHERE `userid`=%s LIMIT 1",
113                         array(bigintval($ref)), __FILE__, __LINE__);
114         } // END - if
115 } // END - if
116
117 // Load the URL
118 redirectToUrl($URL);
119
120 // [EOF]
121 ?>