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 - 2008 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 // Redirect only to registration page when this script is installed
  50 if (!isInstalled()) {
  51         // You have to install first!
  52         redirectToUrl('install.php');
  53 } // END - if
  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 }
  65
  66 // Get referal ID from ref or refid variable
  67 if (REQUEST_ISSET_GET('ref'))        $ref = REQUEST_GET('ref');
  68  elseif (REQUEST_ISSET_GET('refid')) $ref = REQUEST_GET('refid');
  69
  70 if (!empty($ref)) {
  71         // Test if nickname or numeric id
  72         if (EXT_IS_ACTIVE('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                 // Load userid
  78                 list($ref) = SQL_FETCHROW($result);
  79
  80                 // Free result
  81                 SQL_FREERESULT($result);
  82         } else {
  83                 // Invalid request!
  84                 $ref = 0;
  85         }
  86
  87         // Also edit this 0 !
  88         if (empty($ref)) $ref = 0;
  89
  90         // Update session
  91         setSession('refid', $ref);
  92
  93         // We have an refid here. So we simply add it
  94         $URL .= bigintval($ref);
  95
  96         // Is the refid valid?
  97         if ($ref > 0) {
  98                 // Update ref counter
  99                 SQL_QUERY_ESC("UPDATE `{!_MYSQL_PREFIX!}_user_data` SET `ref_clicks`=`ref_clicks`+1 WHERE `userid`=%s LIMIT 1",
 100                         array(bigintval($ref)), __FILE__, __LINE__);
 101         } // END - if
 102 } else {
 103         // No refid and we add our refid (don't forget to set $def_refid!)
 104         $URL = 'index.php';
 105 }
 106
 107 // Load the URL
 108 redirectToUrl($URL);
 109
 110 // [EOF]
 111 ?>