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 ?>