X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Flibs%2Fregister_functions.php;h=665a4b7873fdd09c5722ac56952747e918634f61;hb=e5dde615db05fb62ebe91bd1c030f40c9b91fe17;hp=4c5c05aeeb6fe22f83b3e1504e8b0ca2e970b375;hpb=7e17864b7d07fb5123b1b1d68f83db28ea5394ef;p=mailer.git

diff --git a/inc/libs/register_functions.php b/inc/libs/register_functions.php
index 4c5c05aeeb..665a4b7873 100644
--- a/inc/libs/register_functions.php
+++ b/inc/libs/register_functions.php
@@ -87,7 +87,7 @@ function registerGenerateCategoryTable ($mode, $return=false) {
 	$result = SQL_QUERY("SELECT `id`, `cat`, `visible` FROM `{?_MYSQL_PREFIX?}_cats` ".$AND." ORDER BY `sort` ASC",
 		__FUNCTION__, __LINE__);
 
-	if (SQL_NUMROWS($result) > 0) {
+	if (!SQL_HASZERONUMS($result)) {
 		// List alle visible modules (or all to the admin)
 		$OUT .= '<table border="0" cellspacing="0" cellpadding="0" width="100%">';
 		while ($content = SQL_FETCHARRAY($result)) {
@@ -274,14 +274,14 @@ function doRegistration () {
 
 	// Generate hash which will be inserted into confirmation mail
 	$hash = generateHash(sha1(
-		$confirmedUsers . getConfig('ENCRYPT_SEPERATOR') .
-		$unconfirmedUsers . getConfig('ENCRYPT_SEPERATOR') .
-		$lockedUsers . getConfig('ENCRYPT_SEPERATOR') .
+		$confirmedUsers . getEncryptSeperator() .
+		$unconfirmedUsers . getEncryptSeperator() .
+		$lockedUsers . getEncryptSeperator() .
 		postRequestParameter('month') . '-' .
 		postRequestParameter('day') . '-' .
-		postRequestParameter('year') . getConfig('ENCRYPT_SEPERATOR') .
-		detectServerName() . getConfig('ENCRYPT_SEPERATOR') .
-		detectRemoteAddr() . getConfig('ENCRYPT_SEPERATOR') .
+		postRequestParameter('year') . getEncryptSeperator() .
+		detectServerName() . getEncryptSeperator() .
+		detectRemoteAddr() . getEncryptSeperator() .
 		detectUserAgent() . '/' .
 		getConfig('SITE_KEY') . '/' .
 		getConfig('DATE_KEY') . '/' .
@@ -376,26 +376,8 @@ VALUES ('%s','%s','%s','%s','%s',%s,'%s','%s',%s, %s,%s,'%s',%s, %s,'%s','UNCONF
 	} // END - if
 
 	// Write his welcome-points
-	// @TODO Rewrite this whole if() block to addPointsThroughReferalSystem(). This will also make following if() block obsolete
 	// @TODO Wether the registration bonus should only be added to user directly or through referal system should be configurable
-	$result = SQL_QUERY_ESC("SELECT `id` FROM `{?_MYSQL_PREFIX?}_user_points` WHERE `userid`=%s AND `ref_depth`=0 LIMIT 1",
-		array($userid), __FUNCTION__, __LINE__);
-	if (SQL_HASZERONUMS($result)) {
-		// Add only when the line was not found (maybe some more secure?)
-		$locked = 'points';
-
-		// Pay him later. First he has to confirm some mails!
-		if (getConfig('ref_payout') > 0) $locked = 'locked_points';
-
-		SQL_QUERY_ESC("INSERT INTO `{?_MYSQL_PREFIX?}_user_points` (`userid`, `ref_depth`, `%s`) VALUES (%s,0,'{?points_register?}')",
-			array($locked, $userid), __FUNCTION__, __LINE__);
-
-		// Update mediadata as well
-		if ((isExtensionInstalledAndNewer('mediadata', '0.0.4')) && ($locked == 'points')) {
-			// Update database
-			updateMediadataEntry(array('total_points'), 'add', getConfig('points_register'));
-		} // END - if
-	} // END - if
+	addPointsDirectly('register_welcome', $userid, getConfig('points_register'));
 
 	// Write catgories
 	if ((is_array(postRequestParameter('cat'))) && (count(postRequestParameter('cat')))) {
@@ -409,7 +391,7 @@ VALUES ('%s','%s','%s','%s','%s',%s,'%s','%s',%s, %s,%s,'%s',%s, %s,'%s','UNCONF
 	} // END - if
 
 	// ... rewrite a zero referal id to the main title
-	if (postRequestParameter('refid') == '0') setPostRequestParameter('refid', getConfig('MAIN_TITLE'));
+	if (postRequestParameter('refid') == '0') setPostRequestParameter('refid', getMainTitle());
 
 	// Is ZIP code set?
 	if (isPostRequestParameterSet('zip')) {