X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fmodules%2Fguest%2Fwhat-confirm.php;h=a4b0bedfcca00ea4996524995b580a112723037b;hb=3c4fbc22e3c04348734182d4d29bfef7eb050aa6;hp=bb273a74d5d429e93134069402bfafb7e1be667b;hpb=f01652b7b8efac92d97889e312402c4a845c2f14;p=mailer.git

diff --git a/inc/modules/guest/what-confirm.php b/inc/modules/guest/what-confirm.php
index bb273a74d5..a4b0bedfcc 100644
--- a/inc/modules/guest/what-confirm.php
+++ b/inc/modules/guest/what-confirm.php
@@ -32,84 +32,75 @@
  ************************************************************************/
 
 // Some security stuff...
-if (ereg(basename(__FILE__), $_SERVER['PHP_SELF']))
-{
+if (!defined('__SECURITY')) {
 	$INC = substr(dirname(__FILE__), 0, strpos(dirname(__FILE__), "/inc") + 4) . "/security.php";
 	require($INC);
 }
+
 // Add description as navigation point
-ADD_DESCR("guest", basename(__FILE__));
+ADD_DESCR("guest", __FILE__);
 
-if (!empty($_GET['hash']))
-{
+if (!empty($_GET['hash'])) {
 	// Initialize the user ID
 	$uid = 0;
 
 	// Search for an unconfirmed or confirmed account
 	$result = SQL_QUERY_ESC("SELECT userid, email, refid FROM "._MYSQL_PREFIX."_user_data WHERE user_hash='%s' AND (status='UNCONFIRMED' OR status='CONFIRMED') LIMIT 1",
-	 array($_GET['hash']), __FILE__, __LINE__);
-	if (SQL_NUMROWS($result) == 1)
-	{
+		array($_GET['hash']), __FILE__, __LINE__);
+	if (SQL_NUMROWS($result) == 1) {
 		// Ok, he want's to confirm now so we load some data
 		list ($uid, $email, $rid) = SQL_FETCHROW($result);
 
 		// Unlock his account (but only when it is on UNCONFIRMED!)
-		$result = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_user_data SET status='CONFIRMED', ref_payout='%s' WHERE user_hash='%s' AND status='UNCONFIRMED' LIMIT 1",
-		 array($_CONFIG['ref_payout'], $_GET['hash']), __FILE__, __LINE__);
-		if (SQL_AFFECTEDROWS() == 1)
-		{
+		$result = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_user_data SET status='CONFIRMED', ref_payout=%s, user_hash=NULL WHERE user_hash='%s' AND status='UNCONFIRMED' LIMIT 1",
+			array($_CONFIG['ref_payout'], $_GET['hash']), __FILE__, __LINE__);
+		if (SQL_AFFECTEDROWS() == 1) {
 			$msg = LOAD_EMAIL_TEMPLATE("confirm-member", array('points' => $_CONFIG['points_register']), bigintval($uid));
 
 			// And send him right away the confirmation mail
 			SEND_EMAIL($email, GUEST_THANX_CONFIRM, $msg);
 
-			// Maybe he got "referraled"?
-			if (($rid > 0) && ($rid != $uid))
-			{
-				// Select the referral userid
+			// Maybe he got "referaled"?
+			if (($rid > 0) && ($rid != $uid)) {
+				// Select the referal userid
 				$result = SQL_QUERY_ESC("SELECT userid FROM "._MYSQL_PREFIX."_user_data WHERE userid=%s LIMIT 1",
 				 array(bigintval($rid)), __FILE__, __LINE__);
-				if (SQL_NUMROWS($result) == 1)
-				{
+				if (SQL_NUMROWS($result) == 1) {
 					// Update ref counter...
 					UPDATE_REF_COUNTER($rid);
 
 					// Ok, write the ref-points to this user and his parent-ref
 					unset($DEPTH);
 
-					// Shall I "pay" the referral points imidiately?
-					if ($_CONFIG['ref_payout'] == "0")
-					{
+					// Shall I "pay" the referal points imidiately?
+					if ($_CONFIG['ref_payout'] == "0") {
 						// Yes, "pay" it now
 						$locked = false;
-					}
-					 else
-					{
+					} else {
 						// No, "pay" it later
 						$locked = true;
 					}
 
 					// If version matches add ref bonus to refid's account
-					if ((GET_EXT_VERSION("bonus") >= "0.4.4") && ($_CONFIG['bonus_active'] == "Y"))
-					{
+					if ((GET_EXT_VERSION("bonus") >= "0.4.4") && ($_CONFIG['bonus_active'] == "Y")) {
 						// Add points (directly only!)
 						$result = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_user_data SET bonus_ref=bonus_ref+%s WHERE userid=%s LIMIT 1",
 						 array($_CONFIG['bonus_ref'], bigintval($rid)), __FILE__, __LINE__);
 
 						// Subtract points from system
 						BONUS_POINTS_HANDLER($_CONFIG['bonus_ref']);
-					}
+					} // END - if
 
-					// Add one-time referral bonus over referral system or directly
-					$DEPTH = 0;
-					ADD_POINTS_REFSYSTEM($rid, $_CONFIG['points_ref'], true, bigintval($uid), $locked, $_CONFIG['reg_points_mode']);
-				}
-			}
+					// Add one-time referal bonus over referal system or directly
+					unset($DEPTH);
+					ADD_POINTS_REFSYSTEM("referal_bonus", $rid, $_CONFIG['points_ref'], true, bigintval($uid), $locked, $_CONFIG['reg_points_mode']);
+				} // END - if
+			} // END - if
 
 			if (EXT_IS_ACTIVE("rallye")) {
 				// Add user to rallye (or not?)
 				RALLYE_AUTOADD_USER(bigintval($uid));
-			}
+			} // END - if
 
 			// Account confirmed!
 			if (defined('LEAD_CODE_ENABLED') && defined('LEAD_EXPIRY_TIME')) {