* -------------------------------------------------------------------- *
* File : ref.php *
* -------------------------------------------------------------------- *
- * Short description : Redirection for the referral link *
+ * Short description : Redirection for the referal link *
* -------------------------------------------------------------------- *
- * Kurzbeschreibung : Weiterleitungsscript fuer die Referral-Links *
+ * Kurzbeschreibung : Weiterleitungsscript fuer die Referal-Links *
* -------------------------------------------------------------------- *
- * *
+ * $Revision:: $ *
+ * $Date:: $ *
+ * $Tag:: 0.2.1-FINAL $ *
+ * $Author:: $ *
+ * Needs to be in all Files and every File needs "svn propset *
+ * svn:keywords Date Revision" (autoprobset!) at least!!!!!! *
* -------------------------------------------------------------------- *
- * Copyright (c) 2003 - 2008 by Roland Haeder *
+ * Copyright (c) 2003 - 2009 by Roland Haeder *
* For more information visit: http://www.mxchange.org *
* *
* This program is free software; you can redistribute it and/or modify *
* MA 02110-1301 USA *
************************************************************************/
-// Load security stuff here (Oh, I hope this is not unsecure? Am I paranoia??? ;-) )
-require_once("inc/libs/security_functions.php");
-
-// Init "action" and "what"
-global $what, $action;
-$GLOBALS['what'] = ""; $GLOBALS['action'] = "";
-if (!empty($_GET['action'])) $GLOBALS['action'] = secureString($_GET['action']);
-if (!empty($_GET['what'])) $GLOBALS['what'] = secureString($_GET['what']);
+// Load security stuff here
+require('inc/libs/security_functions.php');
// Set module
-$GLOBALS['module'] = "ref"; $CSS = -1;
+$GLOBALS['module'] = 'ref';
+$GLOBALS['output_mode'] = -1;
// Load the required file(s)
-require ("inc/config.php");
-
-// Redirect only to registration page when this script is installed
-if (defined('mxchange_installed') && (mxchange_installed))
-{
- // Base URL for redirection
- switch ($CONFIG['refid_target'])
- {
- case "register":
- $URL = URL."/modules.php?module=index&what=register&refid=";
+require('inc/config-global.php');
+
+// No refid by default
+$URL = 'index.php';
+
+// Invalid request by default
+$ref = 0;
+
+// Base URL for redirection
+switch (getConfig('refid_target')) {
+ case 'register':
+ $URL = 'modules.php?module=index&what=register&refid=';
break;
- case "index":
- $URL = URL."/index.php?refid=";
+ case 'index':
+ $URL = 'index.php?refid=';
break;
- }
-
- // Get referral ID from ref or refid variable
- if (!empty($_GET['ref'])) $ref = strip_tags(htmlentities($_GET['ref']));
- elseif (!empty($_GET['refid'])) $ref = bigintval($_GET['refid']);
-
- if (!empty($ref))
- {
- // Test if nickname ($test == "0") or ID
- $test = "".round($ref)."";
- if ((EXT_IS_ACTIVE("nickname")) && ($test != $ref))
- {
- // Nickname in URL, so load the ID
- $result = SQL_QUERY_ESC("SELECT userid FROM "._MYSQL_PREFIX."_user_data WHERE nickname='%s' LIMIT 1", array($ref), __FILE__, __LINE__);
+} // END - switch
+
+// Get referal id from ref or refid variable
+if (isGetRequestElementSet('ref')) $ref = getRequestElement('ref');
+ elseif (isGetRequestElementSet('refid')) $ref = getRequestElement('refid');
+
+if (!empty($ref)) {
+ // Test if nickname or numeric id
+ if (isExtensionActive('nickname')) {
+ // Nickname in URL, so load the id
+ $result = SQL_QUERY_ESC("SELECT `userid` FROM `{?_MYSQL_PREFIX?}_user_data` WHERE `nickname`='%s' LIMIT 1",
+ array($ref), __FILE__, __LINE__);
+
+ // Do we have an entry?
+ if (SQL_NUMROWS($result) == 1) {
+ // Load userid
list($ref) = SQL_FETCHROW($result);
- SQL_FREERESULT($result);
+ } else {
+ // So do we have a userid?
+ $result2 = SQL_QUERY_ESC("SELECT `userid` FROM `{?_MYSQL_PREFIX?}_user_data` WHERE `userid`='%s' LIMIT 1",
+ array($ref), __FILE__, __LINE__);
+
+ // Do we have an entry?
+ if (SQL_NUMROWS($result2) == 0) {
+ // No entry, so no referal id
+ $ref = 0;
+ } // END - if
+
+ // Free result
+ SQL_FREERESULT($result2);
}
- // Also edit this 0 !
- if (empty($ref)) $ref = "0";
- // We have an refid here. So we simply add it
- $URL .= bigintval($ref);
+ // Free result
+ SQL_FREERESULT($result);
+ } // END - if
+
+ // Also edit this 0 !
+ if (empty($ref)) $ref = 0;
+
+ // Update session
+ setSession('refid', $ref);
+ // We have an refid here. So we simply add it
+ $URL .= bigintval($ref);
+
+ // Is the refid valid?
+ if ($ref > 0) {
// Update ref counter
- $result = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_user_data SET ref_clicks=ref_clicks+1 WHERE userid=%d LIMIT 1",
- array(bigintval($ref)), __FILE__, __LINE__);
- }
- else
- {
- // No refid and we add our refid (don't forget to set $def_refid!)
- $URL = URL."/index.php";
- }
- // Load the URL
- LOAD_URL($URL);
- // Redirection should be done here
-}
- else
-{
- // You have to configure first!
- LOAD_URL(URL."/install.php");
-}
-
-// Really all done here... ;-)
+ SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_user_data` SET `ref_clicks`=`ref_clicks`+1 WHERE `userid`=%s LIMIT 1",
+ array(bigintval($ref)), __FILE__, __LINE__);
+ } // END - if
+} // END - if
+
+// Load the URL
+redirectToUrl($URL);
+
+// [EOF]
?>
projects / mailer.git / blobdiff