X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Ffilter%2Fuser_filter.php;h=e9eec0aca4d5e5ff1272b20f1a6161534d1460cd;hp=de3ce0efc26ef7ba329ef07d3df8acd4584b8f43;hb=49acdb7a7adbcf25a8e8683b5581bfcec72b23bd;hpb=96d8f54d3fee1d51c38dd6b79c28215f7f5c83ec diff --git a/inc/filter/user_filter.php b/inc/filter/user_filter.php index de3ce0efc2..e9eec0aca4 100644 --- a/inc/filter/user_filter.php +++ b/inc/filter/user_filter.php @@ -16,7 +16,7 @@ * $Author:: $ * * -------------------------------------------------------------------- * * Copyright (c) 2003 - 2009 by Roland Haeder * - * Copyright (c) 2009 - 2012 by Mailer Developer Team * + * Copyright (c) 2009 - 2015 by Mailer Developer Team * * For more information visit: http://mxchange.org * * * * This program is free software; you can redistribute it and/or modify * @@ -131,7 +131,7 @@ function FILTER_TESTER_USER_REGISTRATION_ADD_SQL_COLUMNS ($filterData) { // Return filter data //* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'Done!'); - //* NOISY-DEBUG: */ print __FUNCTION__.':filterData=
'.print_r($filterData,true).'
'; + //* NOISY-DEBUG: */ print __FUNCTION__.':filterData=
'.print_r($filterData,TRUE).'
'; return $filterData; } @@ -153,7 +153,7 @@ function FILTER_HANDLE_USER_SUBID ($filterData) { // Return filter data //* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'Done!'); - //* NOISY-DEBUG: */ print __FUNCTION__.':filterData=
'.print_r($filterData,true).'
'; + //* NOISY-DEBUG: */ print __FUNCTION__.':filterData=
'.print_r($filterData,TRUE).'
'; return $filterData; } @@ -175,28 +175,31 @@ function FILTER_SUBID_USER_REGISTRATION_ADD_SQL_COLUMNS ($filterData) { // Generic filter for updating referral counter of currently detected referral id function FILTER_GENERIC_UPDATE_USER_REFERRAL ($filterData) { + //* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'Called!'); + // Make sure the referral id is detected - assert(isReferralIdValid()); + assert(isValidReferralId()); // Update ref counter, determineReferralId() must already be called before this filter is executed - SQL_QUERY('UPDATE `{?_MYSQL_PREFIX?}_user_data` SET `ref_clicks`=`ref_clicks`+1 WHERE `userid`={%pipe,getReferralId%} LIMIT 1', __FUNCTION__, __LINE__); + sqlQuery('UPDATE `{?_MYSQL_PREFIX?}_user_data` SET `ref_clicks`=`ref_clicks`+1 WHERE `userid`={%pipe,getReferralId%} LIMIT 1', __FUNCTION__, __LINE__); // Return filter data + //* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'Done!'); return $filterData; } // Filter for updating sub id records function FILTER_UPDATE_USER_SUBID ($filterData) { // Make sure the referral id is detected - assert(isReferralIdValid()); + assert(isValidReferralId()); // Get sub id and secure it - $subId = SQL_ESCAPE(getRequestElement('subid')); + $subId = sqlEscapeString(getRequestElement('subid')); // Is the sub id available and registered with referral id? - if (countSumTotalData(getReferralId(), 'user_subids', 'id', 'userid', true, sprintf(" AND `subid`='%s'", $subId)) == 1) { + if (countSumTotalData(getReferralId(), 'user_subids', 'id', 'userid', TRUE, sprintf(" AND `subid`='%s'", $subId)) == 1) { // Sub id is assigned to referral id, so add a record - SQL_QUERY_ESC("INSERT INTO + sqlQueryEscaped("INSERT INTO `{?_MYSQL_PREFIX?}_subid_log` ( `refid`, @@ -212,12 +215,12 @@ function FILTER_UPDATE_USER_SUBID ($filterData) { '{%%pipe,detectUserAgent%%}' )", array( - // @NOTE: SQL_QUERY_ESC() already escape it, don't use $subId here + // @NOTE: sqlQueryEscaped() already escape it, don't use $subId here getRequestElement('subid') ), __FUNCTION__, __LINE__); // Add insert id for other filters - $filterData['insert_id'] = SQL_INSERTID(); + $filterData['insert_id'] = getSqlInsertId(); // Register sub id in filter setSession('subid', $subId); @@ -227,5 +230,70 @@ function FILTER_UPDATE_USER_SUBID ($filterData) { return $filterData; } +// Filter for adding member action +function FILTER_ADD_USER_SUBID_MEMBER_ACTION ($filterData) { + //* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'Called!'); + // Add entry + array_push($filterData, 'list_user_subid'); + + // Return data + //* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'Done!'); + return $filterData; +} + +// Filter for rendering content for sub id listing in what=reflinks +function FILTER_MEMBER_REFLINK_USER_SUBIDS_CONTENT ($content = '') { + // Do this only for members + assert(isMember()); + //* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'Called!'); + + // Does the current user have sub ids? + if (getTotalMemberSubIds() > 0) { + // Then Load all + $result = sqlQueryEscaped('SELECT `id`, `subid` FROM `{?_MYSQL_PREFIX?}_user_subids` WHERE `userid`=%s ORDER BY `subid` ASC', + array(getMemberId()), __FUNCTION__, __LINE__); + + // There should be entries left + assert(!ifSqlHasZeroNumRows($result)); + + // Load all + $out = ''; + while ($row = sqlFetchArray($result)) { + // Load row template + $out .= loadTemplate('member_list_reflink_user_subids_row', TRUE, $row); + } // END - while + + // Load main template + $content .= loadTemplate('member_list_reflink_user_subids', TRUE, $out); + + // Free result + sqlFreeResult($result); + } // END - if + + // Return data + //* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'Done!'); + return $content; +} + +// Filter for generic user login +// @TODO 0% done +function FILTER_GENERIC_USER_LOGIN ($filterData) { + //* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'Called!'); + + // Return filter data + //* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'Done!'); + return $filterData; +} + +// Filter for generic user login check +// @TODO 0% done +function FILTER_GENERIC_USER_LOGIN_CHECK ($filterData) { + //* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'Called!'); + + // Return filter data + //* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'Done!'); + return $filterData; +} + // [EOF] ?>