2 /************************************************************************
3 * Mailer v0.2.1-FINAL Start: 12/16/2008 *
4 * =================== Last change: 12/16/2008 *
6 * -------------------------------------------------------------------- *
8 * -------------------------------------------------------------------- *
9 * Short description : Generic filters *
10 * -------------------------------------------------------------------- *
11 * Kurzbeschreibung : Allgemeine Filter *
12 * -------------------------------------------------------------------- *
15 * $Tag:: 0.2.1-FINAL $ *
17 * -------------------------------------------------------------------- *
18 * Copyright (c) 2003 - 2009 by Roland Haeder *
19 * Copyright (c) 2009 - 2013 by Mailer Developer Team *
20 * For more information visit: http://mxchange.org *
22 * This program is free software; you can redistribute it and/or modify *
23 * it under the terms of the GNU General Public License as published by *
24 * the Free Software Foundation; either version 2 of the License, or *
25 * (at your option) any later version. *
27 * This program is distributed in the hope that it will be useful, *
28 * but WITHOUT ANY WARRANTY; without even the implied warranty of *
29 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the *
30 * GNU General Public License for more details. *
32 * You should have received a copy of the GNU General Public License *
33 * along with this program; if not, write to the Free Software *
34 * Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, *
36 ************************************************************************/
38 // Some security stuff...
39 if (!defined('__SECURITY')) {
43 // Filter for flushing all new filters to the database
44 function FILTER_FLUSH_FILTERS () {
45 // Clear all previous SQL queries
48 // Is a database link here and not in installation mode?
49 if ((!isSqlLinkUp()) && (!isInstaller())) {
51 reportBug(__FUNCTION__, __LINE__, 'No database link is up. Cannot flush filters.');
52 } elseif ((isInstaller()) && (!isSqlLinkUp())) {
53 // If the link is not up in installation phase, skip flushing filters
54 //* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'Cannot flush filters: No link is up.');
58 // Is the extension ext-sql_patches updated?
59 if (((!isExtensionInstalled('sql_patches')) || (isExtensionInstalledAndOlder('sql_patches', '0.5.9'))) && (!isInstaller())) {
60 // Log only in debug mode
61 if (isDebugModeEnabled()) {
62 logDebugMessage(__FUNCTION__, __LINE__, 'Cannot flush filters, ext-sql_patches might be missing. isExtensionInstalled()=' . intval(isExtensionInstalled('sql_patches')) . ',isExtensionInstalledAndOlder()=' . intval(isExtensionInstalledAndOlder('sql_patches', '0.5.9')));
65 // Abort silently here
69 // Nothing is added/remove by default
73 // Prepare SQL queries
74 $insertSQL = 'INSERT INTO `{?_MYSQL_PREFIX?}_filters` (`filter_name`, `filter_function`, `filter_active`) VALUES';
75 $removeSQL = 'DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_filters` WHERE';
77 // Write all filters to database
78 foreach ($GLOBALS['cache_array']['filter']['chains'] as $filterName => $filterArray) {
79 // Walk through all filters
80 foreach ($filterArray as $filterFunction => $active) {
81 // Is this filter loaded?
82 //* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'FOUND:'.$filterName.'/'.$filterFunction.'='.$active);
83 if (((!isset($GLOBALS['cache_array']['filter']['loaded'][$filterName][$filterFunction])) && ($active != 'R')) || ($active == 'A')) {
84 // Is this filter already in database?
85 if (countSumTotalData($filterFunction, 'filters', 'filter_name', 'filter_function', TRUE, sprintf(" AND `filter_name`='%s'", sqlEscapeString($filterName))) == 0) {
86 // Add this filter (all filters are active by default)
87 //* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'ADD:'.$filterName.'/'.$filterFunction);
88 $insertSQL .= sprintf("('%s','%s','Y'),", $filterName, $filterFunction);
90 } elseif (isDebugModeEnabled()) {
91 // Log already registered filters
92 logDebugMessage(__FUNCTION__, __LINE__, 'Already registered: filterName=' . $filterName . ',filterFunction=' . $filterFunction . ',active=' . $active);
94 } elseif ($active == 'R') {
96 //* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'REMOVE:'.$filterName.'/'.$filterFunction);
97 $removeSQL .= sprintf(" (`filter_name`='%s' AND `filter_function`='%s') OR", $filterName, $filterFunction);
104 //* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'inserted=' . $inserted . ',removed=' . $removed . ' - AFTER COLLECTION');
106 // Something has been added?
108 // Finish SQL command and add it
109 addSql(substr($insertSQL, 0, -1));
112 // Something has been removed?
114 // Finish SQL command and add it
115 addSql(substr($removeSQL, 0, -2) . 'LIMIT ' . $removed);
118 // Shall we update usage counters (ONLY FOR DEBUGGING!)
119 if (isFilterUsageUpdateEnabled()) {
120 // Update all counters
121 foreach ($GLOBALS['cache_array']['filter']['counter'] as $filterName => $filterArray) {
122 // Walk through all filters
123 foreach ($filterArray as $filterFunction => $count) {
124 // Construct and add the query
125 addSql(sprintf("UPDATE `{?_MYSQL_PREFIX?}_filters` SET `filter_counter`=%s WHERE `filter_name`='%s' AND `filter_function`='%s' LIMIT 1",
134 // Run the run_sqls filter in non-dry mode
135 runFilterChain('run_sqls');
137 // Should we rebuild cache?
138 if (($inserted > 0) || ($removed > 0)) {
140 rebuildCache('filter', 'filter');
144 // Filter for calling the handler for login failures
145 function FILTER_CALL_HANDLER_LOGIN_FAILTURES ($filterData) {
147 $content = $filterData;
149 // Handle failed logins here if not in guest
150 //* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'type=' . $filterData['type'] . ',action=' . getAction() . ',what=' . getWhat() . ',level=' . $filterData['access_level']);
151 if ((($filterData['type'] == 'what') || ($filterData['type'] == 'action') && ((!isWhatSet()) || (getWhat() == 'welcome') || (getWhat() == getIndexHome()))) && ($filterData['access_level'] != 'guest') && ((isExtensionInstalledAndNewer('sql_patches', '0.4.7')) || (isExtensionInstalledAndNewer('admins', '0.7.6')))) {
153 $content['content'] .= handleLoginFailures($filterData['access_level']);
156 // Return the content
160 // Filter for auto-activation of a extension
161 function FILTER_AUTO_ACTIVATE_EXTENSION ($filterData) {
163 //* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'ext_name=' . $filterData['ext_name'] . ',isThisExtensionAlwaysActive()=' . intval(isThisExtensionAlwaysActive()));
165 // Is this extension always activated?
166 if (isThisExtensionAlwaysActive()) {
167 // Then activate the extension
168 doActivateExtension($filterData['ext_name']);
175 // Filter for solving task given task
176 function FILTER_SOLVE_TASK ($filterData) {
177 // Don't solve anything if no admin!
182 // Is this a direct task id or array element task_id is found?
183 if (is_int($filterData)) {
185 adminSolveTask($filterData);
186 } elseif ((is_array($filterData)) && (isset($filterData['task_id']))) {
188 adminSolveTask($filterData['task_id']);
191 reportBug(__FUNCTION__, __LINE__, sprintf('Cannot resolve task. data[%s]=<pre>%s</pre>', gettype($filterData), print_r($filterData, TRUE)));
198 // Filter to load include files
199 function FILTER_LOAD_INCLUDES ($filterData) {
201 if (is_null($filterData)) {
202 // This should not happen!
203 reportBug(__FUNCTION__, __LINE__, 'pool is null.');
206 // Is the pool an array and 'pool' set?
207 if ((is_array($filterData)) && (isset($filterData['pool']))) {
208 // Then use it as pool
209 $realPool = $filterData['pool'];
211 // Default is $data as inclusion list
212 $realPool = $filterData;
216 $data = getIncludePool($realPool);
219 if ((!isset($data)) || (!is_array($data))) {
221 reportBug(__FUNCTION__, __LINE__, sprintf('INC_POOL is no array! Type: %s', gettype($data)));
222 } elseif (isset($data['inc_pool'])) {
223 // Use this as new inclusion pool!
224 setIncludePool($realPool, $data['inc_pool']);
227 // Check for added include files
228 if (countIncludePool($realPool) > 0) {
229 // Loads every include file
230 loadIncludePool($realPool);
233 initIncludePool($realPool);
236 // Continue with processing
240 // Filter for running SQL commands
241 function FILTER_RUN_SQLS ($filterData) {
246 //* DEBUG: */ die('getSqls()=<pre>'.print_r(getSqls(), TRUE).'</pre>ext_update_depends=<pre>'.print_r($GLOBALS['ext_update_depends'], TRUE).'</pre>');
247 //* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, '- Entered!');
249 // Is the array there?
250 if ((isSqlsValid()) && ((!isset($filterData['dry_run'])) || ($filterData['dry_run'] == FALSE))) {
252 //* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, '- Found ' . countSqls() . ' queries to run.');
253 foreach (getSqls() as $mode => $sqls) {
255 //* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'mode=' . $mode . ',count()=' . count($sqls));
257 // New cache format...
258 foreach ($sqls as $sql) {
262 // Is 'enable_codes' not set? Then set it to true
263 if (!isset($filterData['enable_codes'])) {
264 $filterData['enable_codes'] = TRUE;
267 // Is there still a query left?
269 // Is there an "ALTER TABLE" command? Exclude installation phase here as it would cause this query to fail
270 if ((substr(strtolower($sql), 0, 11) == 'alter table') && (!isset($filterData['ext_installing']))) {
271 // Analyse the alteration command
272 //* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'Alterting table: ' . $sql . ',enable_codes=' . intval($filterData['enable_codes']));
273 sqlQueryAlterTable($sql, __FUNCTION__, __LINE__, $filterData['enable_codes']);
275 // Run regular SQL command
276 //* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'Running regular query: ' . $sql . ',enable_codes=' . intval($filterData['enable_codes']));
277 sqlQuery($sql, __FUNCTION__, __LINE__, $filterData['enable_codes']);
280 // Has a line changed?
281 if (!ifSqlHasZeroAffectedRows()) {
282 // Add it to total account
283 $count += sqlAffectedRows();
291 //* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, '- Left!');
297 // Filter for updating/validating login data
298 function FILTER_UPDATE_LOGIN_DATA () {
300 if ((!isset($GLOBALS['last_online'])) || (!is_array($GLOBALS['last_online']))) {
301 $GLOBALS['last_online'] = array();
304 // Recheck if logged in
305 if ((!isMember()) || ((isAdmin()) && (!isDebugModeEnabled()))) {
310 setMemberId(getSession('userid'));
313 if (fetchUserData(getMemberId())) {
314 // Load last module and online time
315 $content = getUserDataArray();
317 // Maybe first login time?
318 if (empty($content[getUserLastWhatName()])) {
319 $content[getUserLastWhatName()] = 'login';
322 // This will be displayed on welcome page! :-)
323 if (empty($GLOBALS['last_online']['module'])) {
324 $GLOBALS['last_online']['module'] = $content[getUserLastWhatName()];
325 $GLOBALS['last_online']['online'] = $content['last_online'];
332 if (getIndexHome() != '') {
333 setWhatFromConfig('index_home');
337 // Update last module / online time
338 updateLastActivity(getMemberId());
340 // Destroy session, we cannot update!
341 destroyMemberSession();
345 // Filter for initializing randomizer
346 function FILTER_INIT_RANDOMIZER () {
347 // Take a prime number which is long (if you know a longer one please try it out!)
348 setConfigEntry('_PRIME', 591623);
350 // Initialize array with all allowed chars
351 $GLOBALS['_abc'] = explode(',', 'a,b,c,d,e,f,g,h,i,j,k,l,m,n,o,p,q,r,s,t,u,v,w,x,y,z,A,B,C,D,E,F,G,H,I,J,K,L,M,N,O,P,Q,R,S,T,U,V,W,X,Y,Z,1,2,3,4,6,7,8,9,-,+,_,/,.');
353 // Only execute this filter if installed
354 if ((!isInstalled()) || (!isExtensionInstalledAndNewer('other', '0.2.5'))) {
356 setConfigEntry('_ADD', 0);
360 // Calculate "entropy" with the prime number (for code generation)
361 setConfigEntry('_ADD', (getPrime() * getPrime() / (pi() * getCodeLength() + 1)));
363 // Simply init the randomizer with seed and _ADD value
364 mt_srand(generateSeed() + getConfig('_ADD'));
367 // Filter for removing updates
368 function FILTER_REMOVE_UPDATES ($filterData) {
370 initExtensionRemovalList();
372 // Add the current extension to it
373 addCurrentExtensionToRemovalList();
376 unsetExtensionSqls();
378 // Are there update dependencies to remove?
379 if (countExtensionUpdateDependencies() > 0) {
380 // Then find all updates we shall no longer execute
381 foreach (getExtensionUpdateDependencies() as $id => $ext_name) {
382 // Shall we remove this update?
383 if (in_array($ext_name, getExtensionRemovalList())) {
384 // Then remove this extension!
385 removeExtensionDependency($ext_name);
394 // Determines username for current user state
395 function FILTER_DETERMINE_USERNAME () {
396 // Check if logged in
398 // Is still logged in so we welcome him with his name
399 if (fetchUserData(getMemberId())) {
400 // Load surname and family's name and build the username
401 $content = getUserDataArray();
404 setUsername($content['surname'] . ' ' . $content['family']);
406 // Additionally admin?
409 setUsername(getUsername() . ' ({--USERNAME_ADMIN_SHORT--})');
412 // Hmmm, logged in and no valid userid?
413 setUsername('<span class="bad">{--USERNAME_UNKNOWN--}</span>');
416 destroyMemberSession();
418 } elseif (isAdmin()) {
420 setUsername('{--USERNAME_ADMIN--}');
422 // He's a guest, hello there... ;-)
423 setUsername('{--USERNAME_GUEST--}');
427 // Filter for compiling config entries
428 function FILTER_COMPILE_CONFIG ($code, $compiled = FALSE) {
429 // Save the uncompiled code
433 if (!isset($GLOBALS['compiled_config'][$code])) {
434 // Compile {?some_var?} to getConfig('some_var')
435 preg_match_all('/\{\?(([a-zA-Z0-9-_]+)*)\?\}/', $code, $matches);
437 // Some entries found?
438 if ((isFilledArray($matches)) && (isFilledArray($matches[0]))) {
439 // Replace all matches
440 foreach ($matches[0] as $key => $match) {
442 if (!isset($GLOBALS['compile_config'][$matches[1][$key]])) {
443 // Is the config valid?
444 if (isConfigEntrySet($matches[1][$key])) {
445 // Set it for caching
446 $GLOBALS['compile_config'][$matches[1][$key]] = '{%config=' . $matches[1][$key] . '%}';
447 } elseif (isConfigEntrySet('default_' . strtoupper($matches[1][$key]))) {
449 $GLOBALS['compile_config'][$matches[1][$key]] = '{%config=' . 'DEFAULT_' . strtoupper($matches[1][$key]) . '%}';
450 } elseif (isMessageIdValid('DEFAULT_' . strtoupper($matches[1][$key]))) {
451 // No config, try the language system
452 $GLOBALS['compile_config'][$matches[1][$key]] = '{%message,DEFAULT_' . strtoupper($matches[1][$key]) . '%}';
455 $GLOBALS['compile_config'][$matches[1][$key]] = '!' . $matches[1][$key] . '!';
459 // Use this for replacing
460 $code = str_replace($match, $GLOBALS['compile_config'][$matches[1][$key]], $code);
461 //* DEBUG: */ if (($match == '{?URL?}') && (strlen($code) > 10000)) die(__FUNCTION__.'['.__LINE__.']:<pre>'.secureString($code).'</pre>');
466 $GLOBALS['compiled_config'][$uncompiled] = $code;
469 // Should we compile it?
470 if ($compiled === TRUE) {
472 $eval = "\$GLOBALS['compiled_config'][\$uncompiled] = \"" . $GLOBALS['compiled_config'][$uncompiled] . '";';
473 //* DEBUG: */ debugOutput(__FUNCTION__.'['.__LINE__.']:<pre>' . encodeEntities($eval) . '</pre>');
477 // Return compiled code
478 return $GLOBALS['compiled_config'][$uncompiled];
481 // Filter for compiling expression code
482 function FILTER_COMPILE_EXPRESSION_CODE ($filterData) {
483 // Compile {%cmd,callback,extraFunction=some_value%} to get expression code snippets
484 // See switch() command below for supported commands
485 preg_match_all('/\{%(([a-zA-Z0-9-_,]+)(=([^\}]+)){0,1})*%\}/', $filterData, $matches);
486 //* DEBUG: */ debugOutput(__FUNCTION__.'['.__LINE__.']:<pre>'.print_r($matches, TRUE).'</pre>');
488 // Default is from outputHtml()
489 $outputMode = getScriptOutputMode();
491 // Some entries found?
492 if ((isFilledArray($matches)) && (isFilledArray($matches[3]))) {
493 // Replace all matches
494 foreach ($matches[2] as $key => $eti) {
495 // Init replacer/call-back variable
499 $extraFunction2 = '';
502 // Extract command and call-back
503 $etiArray = explode(',', $eti);
506 // Detect call-back function
507 if (isset($etiArray[1])) {
508 // Call-back function detected
509 $callback = $etiArray[1];
512 // Detect extra function
513 if (isset($etiArray[2])) {
515 $extraFunction = $etiArray[2];
518 // Detect extra function 2
519 if (isset($etiArray[3])) {
521 $extraFunction2 = $etiArray[3];
525 if (isset($matches[4][$key])) {
527 $value = $matches[4][$key];
530 // Construct call-back function name for the command
531 $etiFunction = 'doExpression' . capitalizeUnderscoreString($eti);
533 // Is this function there?
534 if (function_exists($etiFunction)) {
535 // Prepare $matches, $key, $outputMode, etc.
537 'matches' => $matches,
539 'output_mode' => getScriptOutputMode(),
540 'code' => $filterData,
541 'callback' => $callback,
542 'extra_func' => $extraFunction,
543 'extra_func2' => $extraFunction2,
548 //* DEBUG: */ debugOutput(__FUNCTION__ . '[' . __LINE__ . ']: etiFunction=' . $etiFunction);
549 $filterData = call_user_func($etiFunction, $data);
551 // Unsupported command detected
552 logDebugMessage(__FUNCTION__, __LINE__, 'eti=' . $eti . ',etiFunction=' . $etiFunction . ',callback=' . $callback . ',extraFunction=' . $extraFunction . ',extraFunction2=' . $extraFunction2 . ' - UNSUPPORTED');
557 // Is there non-HTML/AJAX mode?
558 if ((!isHtmlOutputMode()) && (!isAjaxOutputMode())) {
559 $filterData = decodeEntities($filterData);
562 // Return compiled code
563 //* DEBUG: */ debugOutput(__FUNCTION__.'['.__LINE__.']:<pre>'.($filterData).'</pre>');
567 // Runs some generic filter update steps
568 function FILTER_UPDATE_EXTENSION_DATA ($ext_name) {
569 // Create task (we ignore the task id here)
570 createExtensionUpdateTask(getCurrentAdminId(), $ext_name, $GLOBALS['update_ver'][$ext_name], sqlEscapeString(getExtensionNotes(getExtensionNotes())));
572 // Update extension's version
573 sqlQueryEscaped("UPDATE `{?_MYSQL_PREFIX?}_extensions` SET `ext_version`='%s' WHERE `ext_name`='%s' LIMIT 1",
574 array($GLOBALS['update_ver'][$ext_name], $ext_name), __FUNCTION__, __LINE__);
578 unset($GLOBALS['update_ver'][$ext_name]);
581 // Load more hourly reset scripts
582 function FILTER_RUN_HOURLY_INCLUDES () {
583 // Is the reset set or old sql_patches?
584 if (((!isHourlyResetEnabled()) || (!isExtensionInstalledAndNewer('sql_patches', '0.9.8'))) && (isHtmlOutputMode())) {
586 reportBug(__FUNCTION__, __LINE__, 'Cannot run hourly reset! enabled='.intval(isHourlyResetEnabled()).',isExtensionInstalledAndNewer='.intval(isExtensionInstalledAndNewer('sql_patches', '0.9.8')).' Please report this bug. Thanks');
589 // Is ext-sql_patches at least 0.9.8?
590 if (isExtensionInstalledAndNewer('sql_patches', '0.9.8')) {
592 if ((getLastHourly() != getHour()) || (isDebugHourlyEnabled())) {
593 // Get more hourly reset scripts
594 setIncludePool('hourly', getArrayFromDirectory('inc/hourly/', 'hourly_'));
597 runFilterChain('load_includes', 'hourly');
602 // Load more daily scripts
603 function FILTER_RUN_DAILY_INCLUDES () {
604 // Is the reset set or old sql_patches?
605 if (((!isDailyResetEnabled()) || (!isExtensionInstalledAndNewer('sql_patches', '0.9.8'))) && (isHtmlOutputMode())) {
607 reportBug(__FUNCTION__, __LINE__, 'Cannot run daily reset! enabled='.intval(isDailyResetEnabled()).',isExtensionInstalledAndNewer='.intval(isExtensionInstalledAndNewer('sql_patches', '0.9.8')).' Please report this bug. Thanks');
610 // Is ext-sql_patches at least 0.9.8?
611 if (isExtensionInstalledAndNewer('sql_patches', '0.9.8')) {
613 if ((getLastDaily() != getDay()) || (isDebugDailyEnabled())) {
614 // Get more daily reset scripts
615 setIncludePool('daily', getArrayFromDirectory('inc/daily/', 'daily_'));
618 runFilterChain('load_includes', 'daily');
623 // Load more weeklt scripts
624 function FILTER_RUN_WEEKLY_INCLUDES () {
625 // Is the reset set or old sql_patches?
626 if (((!isWeeklyResetEnabled()) || (!isExtensionInstalledAndNewer('sql_patches', '0.9.8'))) && (isHtmlOutputMode())) {
628 reportBug(__FUNCTION__, __LINE__, 'Cannot run weekly reset! enabled='.intval(isWeeklyResetEnabled()).',isExtensionInstalledAndNewer()='.intval(isExtensionInstalledAndNewer('sql_patches', '0.9.8')).' Please report this bug. Thanks');
631 // Is ext-sql_patches at least 0.9.8?
632 if (isExtensionInstalledAndNewer('sql_patches', '0.9.8')) {
634 if ((getLastWeekly() != getWeek()) || (isDebugWeeklyEnabled())) {
635 // Include weekly reset scripts
636 setIncludePool('weekly', getArrayFromDirectory('inc/weekly/', 'weekly_'));
639 runFilterChain('load_includes', 'weekly');
644 // Load more monthly scripts
645 function FILTER_RUN_MONTHLY_INCLUDES () {
646 // Is the reset set or old sql_patches?
647 if (((!isMonthlyResetEnabled()) || (!isExtensionInstalledAndNewer('sql_patches', '0.9.8'))) && (isHtmlOutputMode())) {
649 reportBug(__FUNCTION__, __LINE__, 'Cannot run monthly reset! enabled='.intval(isMonthlyResetEnabled()).',isExtensionInstalledAndNewer='.intval(isExtensionInstalledAndNewer('sql_patches', '0.9.8')).' Please report this bug. Thanks');
652 // Is ext-sql_patches at least 0.9.8?
653 if (isExtensionInstalledAndNewer('sql_patches', '0.9.8')) {
655 if ((getLastMonthly() != getMonth()) || (isDebugMonthlyEnabled())) {
656 // Include monthly reset scripts
657 setIncludePool('monthly', getArrayFromDirectory('inc/monthly/', 'monthly_'));
660 runFilterChain('load_includes', 'monthly');
665 // Load more yearly scripts
666 function FILTER_RUN_YEARLY_INCLUDES () {
667 // Is the reset set or old sql_patches?
668 if (((!isYearlyResetEnabled()) || (!isExtensionInstalledAndNewer('sql_patches', '0.9.8'))) && (isHtmlOutputMode())) {
670 reportBug(__FUNCTION__, __LINE__, 'Cannot run yearly reset! enabled='.intval(isYearlyResetEnabled()).',isExtensionInstalledAndNewer='.intval(isExtensionInstalledAndNewer('sql_patches', '0.9.8')).' Please report this bug. Thanks');
673 // Is ext-sql_patches at least 0.9.8?
674 if (isExtensionInstalledAndNewer('sql_patches', '0.9.8')) {
676 if ((getLastYearly() != getYear()) || (isDebugYearlyEnabled())) {
677 // Include yearly reset scripts
678 setIncludePool('yearly', getArrayFromDirectory('inc/yearly/', 'yearly_'));
681 runFilterChain('load_includes', 'yearly');
686 // Filter for removing the given extension
687 function FILTER_REMOVE_EXTENSION () {
688 // Delete this extension (remember to remove it from your server *before* you click on welcome!
689 sqlQueryEscaped("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_extensions` WHERE `ext_name`='%s' LIMIT 1",
690 array(getCurrentExtensionName()), __FUNCTION__, __LINE__);
692 // Remove the extension from cache array as well
693 removeExtensionFromArray();
696 rebuildCache('extension', 'extension');
699 // Filter for flushing the output
700 function FILTER_FLUSH_OUTPUT () {
701 // Is this filter called?
702 if (isset($GLOBALS[__FUNCTION__])) {
704 reportBug(__FUNCTION__, __LINE__, 'Double call of ' . __FUNCTION__ . ' causes problems with sent headers.');
707 // Mark this filter as called
708 $GLOBALS[__FUNCTION__] = TRUE;
714 // Prepares an SQL statement part for HTML mail and/or holiday dependency
715 function FILTER_HTML_INCLUDE_USERS ($mode) {
716 // Exclude no users by default
720 if ($mode == 'html') {
721 $MORE = " AND `html`='Y'";
724 if (isExtensionInstalledAndNewer('holiday', '0.1.3')) {
725 // Add something for the holiday extension
726 $MORE .= " AND `holiday_active`='N'";
733 // Filter for determining what/action/module
734 function FILTER_DETERMINE_WHAT_ACTION () {
735 // In installation phase we don't have what/action
746 if ((!isCssOutputMode()) && (!isRawOutputMode())) {
748 if (!isModuleSet()) {
749 // Is the module registered?
750 if (!isModuleRegistered(getRequestElement('module'))) {
751 // Is not a valid module
752 redirectToUrl('modules.php?module=index');
755 // Is the request element set?
756 if (isGetRequestElementSet('module')) {
757 // Set module from request
758 setModule(getRequestElement('module'));
759 } elseif (isHtmlOutputMode()) {
760 // Set default module 'index'
764 setModule('unknown');
768 // Fix 'what' if not yet set
770 setWhat(getWhatFromModule(getModule()));
773 // Fix 'action' if not yet set
774 if (!isActionSet()) {
778 setAction(getActionFromModuleWhat(getModule(), getWhat()));
780 // Set action/what to empty
786 // Set action/what to empty
791 // Set default 'what' value
792 //* DEBUG: */ debugOutput('-' . getModule() . '/' . getWhat() . '-');
793 if ((!isWhatSet()) && (!isActionSet()) && (!isCssOutputMode()) && (!isRawOutputMode())) {
794 if (getModule() == 'admin') {
795 // Set 'action' value to 'login' in admin menu
796 setAction(getActionFromModuleWhat(getModule(), getWhat()));
797 } elseif ((getModule() == 'index') || (getModule() == 'login')) {
798 // Set 'what' value to 'welcome' in guest and member menu
799 setWhatFromConfig('index_home');
801 // Anything else like begging link
807 // Sends out pooled mails
808 function FILTER_TRIGGER_SENDING_POOL () {
809 // Are we in normal output mode?
810 if (!isHtmlOutputMode()) {
811 // Only in normal output mode to prevent race-conditons!
816 $GLOBALS['pool_cnt'] = '0';
818 // Init & set the include pool
819 initIncludePool('pool');
820 setIncludePool('pool', getArrayFromDirectory('inc/pool/', 'pool-'));
823 runFilterChain('load_includes', 'pool');
825 // Remove the counter
826 unset($GLOBALS['pool_cnt']);
829 // Filter for checking and updating SVN revision
830 function FILTER_CHECK_REPOSITORY_REVISION () {
831 // Only execute this filter if installed and all config entries are there
832 if ((!isInstalled()) || (!isConfigEntrySet('patch_level'))) {
836 // Check for patch level differences between database and current hard-coded
837 if ((getCurrentRepositoryRevision() > getConfig('patch_level')) || (getConfig('patch_level') == 'CURRENT_REPOSITORY_REVISION') || (getConfig('patch_ctime') == 'UNIX_TIMES')) {
838 // Update database and CONFIG array
839 updateConfiguration(array('patch_level', 'patch_ctime'), array(getCurrentRepositoryRevision(), 'UNIX_TIMESTAMP()'));
840 setConfigEntry('patch_level', getCurrentRepositoryRevision());
841 setConfigEntry('patch_ctime', time());
845 // Filter for running hourly reset
846 function FILTER_RUN_HOURLY_RESET () {
847 // Only execute this filter if installed
848 if ((isInstaller()) || (!isInstalled()) || (!isAdminRegistered()) || (!isExtensionInstalledAndNewer('sql_patches', '0.9.8'))) {
852 // Shall we run the reset scripts? If a day has changed, maybe also a week/month has changed... Simple! :D
853 //* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'getLastHourly()=' . getLastHourly() . ',getHour()=' . getHour());
854 if (((getLastHourly() != getHour()) || (isDebugHourlyEnabled())) && (!isInstaller()) && (isAdminRegistered()) && (!isGetRequestElementSet('setup')) && (!isCssOutputMode())) {
855 // Tell every module we are in reset-mode!
860 // Filter for running daily reset
861 function FILTER_RUN_DAILY_RESET () {
862 // Only execute this filter if installed
863 if ((isInstaller()) || (!isInstalled()) || (!isAdminRegistered()) || (!isExtensionInstalledAndNewer('sql_patches', '0.9.8'))) {
867 // Shall we run the reset scripts? If a day has changed, maybe also a week/month has changed... Simple! :D
868 //* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'getLastDaily()=' . getLastDaily() . ',getDay()=' . getDay());
869 if (((getLastDaily() != getDay()) || (isDebugDailyEnabled())) && (!isInstaller()) && (isAdminRegistered()) && (!isGetRequestElementSet('setup')) && (!isCssOutputMode())) {
870 // Tell every module we are in reset-mode!
875 // Filter for running weekly reset
876 function FILTER_RUN_WEEKLY_RESET () {
877 // Only execute this filter if installed
878 if ((isInstaller()) || (!isInstalled()) || (!isAdminRegistered()) || (!isExtensionInstalledAndNewer('sql_patches', '0.9.8'))) {
882 // Shall we run the reset scripts? If a day has changed, maybe also a week/month has changed... Simple! :D
883 //* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'getLastWeekly()=' . getLastWeekly() . ',getWeek()=' . getWeek());
884 if (((getLastWeekly() != getWeek()) || (isDebugWeeklyEnabled())) && (!isInstaller()) && (isAdminRegistered()) && (!isGetRequestElementSet('setup')) && (!isCssOutputMode())) {
885 // Tell every module we are in reset-mode!
890 // Filter for running monthly reset
891 function FILTER_RUN_MONTHLY_RESET () {
892 // Only execute this filter if installed
893 if ((isInstaller()) || (!isInstalled()) || (!isAdminRegistered()) || (!isExtensionInstalledAndNewer('sql_patches', '0.9.8'))) {
897 // Shall we run the reset scripts? If a day has changed, maybe also a week/month has changed... Simple! :D
898 //* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'getLastMonthly()=' . getLastMonthly() . ',getMonth()=' . getMonth());
899 if (((getLastMonthly() != getMonth()) || (isDebugMonthlyEnabled())) && (!isInstaller()) && (isAdminRegistered()) && (!isGetRequestElementSet('setup')) && (!isCssOutputMode())) {
900 // Tell every module we are in reset-mode!
905 // Filter for running yearly reset
906 function FILTER_RUN_YEARLY_RESET () {
907 // Only execute this filter if installed
908 if ((isInstaller()) || (!isInstalled()) || (!isAdminRegistered()) || (!isExtensionInstalledAndNewer('sql_patches', '0.9.8'))) {
912 // Shall we run the reset scripts? If a day has changed, maybe also a week/month has changed... Simple! :D
913 //* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'getLastYearly()=' . getLastYearly() . ',getYear()=' . getYear());
914 if (((getLastYearly() != getYear()) || (isDebugYearlyEnabled())) && (!isInstaller()) && (isAdminRegistered()) && (!isGetRequestElementSet('setup')) && (!isCssOutputMode())) {
915 // Tell every module we are in reset-mode!
920 // Filter for loading more runtime includes (not for installation)
921 function FILTER_LOAD_RUNTIME_INCLUDES () {
922 // Load more includes
923 foreach (array('databases', 'session', 'versions') as $inc) {
925 loadIncludeOnce('inc/' . $inc . '.php');
929 // Filter for checking admin ACL
930 function FILTER_CHECK_ADMIN_ACL () {
931 // Extension not installed so it's always allowed to access everywhere!
934 // Ok, Cookie-Update done
935 if ((isExtensionInstalledAndNewer('admins', '0.3.0')) && (isExtensionActive('admins'))) {
936 // Check if action GET variable was set
937 $action = getAction();
939 // Get action value by what-value
940 $action = getActionFromModuleWhat('admin', getWhat());
943 // Check for access control line of current menu entry
944 $ret = isAdminsAllowedByAcl($action, getWhat());
948 $GLOBALS['acl_allow'] = $ret;
951 // Init random number/cache buster
952 function FILTER_INIT_RANDOM_NUMBER () {
953 // Is the extension ext-sql_patches installed and at least 0.3.6?
954 if (isSessionVariableSet('random_number')) {
956 setConfigEntry('RAND_NUMBER', getSession('random_number'));
957 } elseif ((isExtensionInstalledAndNewer('sql_patches', '0.3.6')) && (isExtensionInstalledAndNewer('other', '0.2.5'))) {
958 // Generate random number
959 setConfigEntry('RAND_NUMBER', generateRandomCode(10, mt_rand(10000, 99999), getMemberId(), ''));
961 // Generate *WEAK* code
962 setConfigEntry('RAND_NUMBER', mt_rand(1000000, 9999999));
965 // Set it in session for faster script execusion
966 setSession('random_number', getConfig('RAND_NUMBER'));
968 // Copy it to CACHE_BUSTER
969 setConfigEntry('CACHE_BUSTER', getConfig('RAND_NUMBER'));
972 // Update module counter
973 function FILTER_COUNT_MODULE () {
974 // Is installation phase or no admin registered?
975 if ((isInstaller()) || (!isInstalled()) || (!isAdminRegistered())) {
976 // Then don't count any modules
980 //* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'getModule()=' . getModule() . ' - ENTERED!');
981 // Count module click
982 sqlQueryEscaped("UPDATE `{?_MYSQL_PREFIX?}_mod_reg` SET `clicks`=`clicks`+1 WHERE `module`='%s' LIMIT 1",
983 array(getModule()), __FUNCTION__, __LINE__);
984 //* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'getModule()=' . getModule() . ',sqlAffectedRows()=' . sqlAffectedRows() . ' - EXIT!');
987 // Handles fatal errors
988 function FILTER_HANDLE_FATAL_ERRORS () {
989 // Is there errors to handle and right output mode?
990 if ((!ifFatalErrorsDetected()) || (!isHtmlOutputMode())) {
991 // Abort executing here
996 setContentType('text/html');
999 loadIncludeOnce('inc/load_config.php');
1001 // Default content is none
1004 // Installation phase or regular mode?
1005 if ((isInstaller())) {
1006 // While we are installing ouput other header than while it is installed... :-)
1008 foreach (getFatalArray() as $key => $value) {
1009 // Prepare content for the template
1011 'key' => ($key + 1),
1015 // Load row template
1016 $OUT .= loadTemplate('install_fatal_row', TRUE, $content);
1019 // Load main template
1020 $content = loadTemplate('install_fatal_table', TRUE, $OUT);
1021 } elseif (isInstalled()) {
1022 // Display all runtime fatal errors
1024 foreach (getFatalArray() as $key => $value) {
1025 // Prepare content for the template
1027 'key' => ($key + 1),
1031 // Load row template
1032 $OUT .= loadTemplate('runtime_fatal_row', TRUE, $content);
1035 // Load main template
1036 $content = loadTemplate('runtime_fatal_table', TRUE, $OUT);
1039 // Message to regular users (non-admin)
1040 $CORR = '{--FATAL_REPORT_ERRORS--}';
1042 // Maybe the admin wants to take a look?
1044 $CORR = '{--FATAL_CORRECT_ERRORS--}';
1047 // Remember all in array
1054 loadIncludeOnce('inc/header.php');
1056 // Load main template
1057 loadTemplate('fatal_errors', FALSE, $content);
1059 // Delete all to prevent double-display
1060 initFatalMessages();
1063 loadIncludeOnce('inc/footer.php');
1069 // Filter for displaying copyright line
1070 function FILTER_DISPLAY_COPYRIGHT () {
1071 // Shall we display the copyright notice?
1072 if ((isFullPage()) && ((getWriteFooter() == 'Y') || (isInstalling())) && ($GLOBALS['__header_sent'] == 2) && (ifCopyrightFooterEnabled())) {
1073 // Backlink enabled?
1074 if (((isConfigEntrySet('ENABLE_BACKLINK')) && (getConfig('ENABLE_BACKLINK') == 'Y')) || (isInstalling())) {
1075 // Copyright with backlink, thanks! :-)
1076 $GLOBALS['__page_footer'] .= loadTemplate('copyright_backlink', TRUE);
1078 // No backlink in Copyright note
1079 $GLOBALS['__page_footer'] .= loadTemplate('copyright', TRUE);
1084 // Filter for displaying parsing time
1085 function FILTER_DISPLAY_PARSING_TIME () {
1086 // Shall we display the parsing time and number of queries?
1087 // 1234 5 54 4 554 4 5543 3 4432 2 332 2 21
1088 if ((((isExtensionInstalledAndNewer('sql_patches', '0.4.1')) && (isShowTimingsEnabled()) && (isFullPage())) && (!isInstaller())) && (isHtmlOutputMode()) && ($GLOBALS['__header_sent'] == 2)) {
1089 // Then display it here
1090 displayParsingTime();
1094 // Filter for flushing template cache
1095 function FILTER_FLUSH_TEMPLATE_CACHE () {
1096 // Do not flush when debugging the template cache
1097 if (isDebugTemplateCacheEnabled()) {
1098 // Do not flush templates in debug-mode
1102 // Is there cached eval() data?
1103 if ((isset($GLOBALS['template_eval'])) && (isFilledArray($GLOBALS['template_eval']))) {
1105 foreach ($GLOBALS['template_eval'] as $prefix => $templateArray) {
1106 foreach ($templateArray as $template => $eval) {
1107 // Flush the cache (if not yet found)
1108 flushTemplateCache($prefix, $template, $eval);
1114 // Filter for loading user data
1115 function FILTER_FETCH_USER_DATA ($userid = NULL) {
1116 // Is the userid not set?
1117 if (!isValidId($userid)) {
1118 // Then use member id
1119 $userid = getMemberId();
1123 if (!fetchUserData($userid)) {
1124 // Userid is not valid
1125 reportBug(__FUNCTION__, __LINE__, 'User id ' . $userid . ' is invalid.');
1129 setMemberId($userid);
1131 // Continue with next filter
1135 // Filter for reseting users' last login failure, only available with latest ext-sql_patches
1136 function FILTER_RESET_USER_LOGIN_FAILURE () {
1137 // Is the user data valid?
1139 // Do only run for logged in members
1140 reportBug(__FUNCTION__, __LINE__, 'Please only run this filter for logged in users.');
1143 // Remmeber login failures if available
1144 if (isExtensionInstalledAndNewer('user', '0.3.7')) {
1145 // Reset login failures
1146 sqlQueryEscaped("UPDATE
1147 `{?_MYSQL_PREFIX?}_user_data`
1154 array(getMemberId()), __FUNCTION__, __LINE__);
1156 // Store it in session
1157 setSession('mailer_member_failures' , getUserData('login_failures'));
1158 setSession('mailer_member_last_failure', getUserData('last_failure'));
1162 // Try to login the admin by setting some session/cookie variables
1163 function FILTER_DO_LOGIN_ADMIN ($filterData) {
1164 // Now set all session variables and store the result for later processing
1165 $GLOBALS['admin_login_success'] = ((
1166 setAdminMd5(encodeHashForCookie($filterData['pass_hash']))
1168 setAdminId($filterData['id'])
1170 setAdminLast(time())
1173 // Return the data for further processing
1177 // Filter for loading page header, this should be ran first!
1178 function FILTER_LOAD_PAGE_HEADER () {
1179 // Output page header code
1180 $GLOBALS['__page_header'] = loadTemplate('page_header', TRUE);
1182 // Include meta data in 'guest' module
1183 if (isModuleSet()) {
1184 // Load meta data template
1185 $GLOBALS['__page_header'] .= loadTemplate(getMenuModeFromModule() . '_metadata', TRUE);
1187 // Add meta description to header
1188 if ((isInstalled()) && (isAdminRegistered()) && (isSqlLinkUp()) && (getModule() == 'index')) {
1189 // Add meta description not in admin and login module and when the script is installed
1190 generateMetaDescriptionCode();
1195 // Filter for adding style sheet, closing page header
1196 function FILTER_FINISH_PAGE_HEADER () {
1197 // Include stylesheet
1198 loadIncludeOnce('inc/stylesheet.php');
1201 $GLOBALS['__page_header'] .= '</head>';
1204 // Cleans up the DNS cache if ext-sql_patches is at least 0.7.0
1205 function FILTER_CLEANUP_DNS_CACHE () {
1206 // Is the latest version installed?
1207 if (isExtensionInstalledAndNewer('sql_patches', '0.7.0')) {
1209 loadIncludeOnce('inc/classes/resolver.class.php');
1211 // Instance the resolver
1212 $resolver = new HostnameResolver();
1215 $resolver->purgeEntries();
1217 // Cute, isn't it? ;-)
1221 // Filter for setting CURRENT_DATE, this is required after initialization of extensions
1222 function FILTER_SET_CURRENT_DATE () {
1224 setConfigEntry('CURRENT_DATE', generateDateTime(time(), '3'));
1226 // Epoche time for yesterday, today ... all at 00:00 am
1227 setConfigEntry('START_YDAY', makeTime(0, 0, 0, time() - getOneDay()));
1228 setConfigEntry('START_TDAY', makeTime(0, 0, 0, time()));
1231 // Filter for marking extension as installed
1232 function FILTER_EXTENSION_MARK_INSTALLED ($filterData) {
1233 // Mark it as installed
1234 $GLOBALS['ext_is_installed'][$filterData['ext_name']] = TRUE;
1237 // Filter for generating mails links for 'pool' mails
1238 function FILTER_GENERATE_POOL_MAIL_LINKS ($filterData) {
1239 // Is type 'normal'?
1240 if ($filterData['type'] == 'normal') {
1242 $filterData['__output'] .= loadTemplate('admin_links_' . strtolower($filterData['mail_status']) . '_pool_mail', TRUE, $filterData);
1249 // Filter to activate exchange
1250 function FILTER_ACTIVATE_EXCHANGE () {
1251 // Are the extension ext-user/other there?
1252 if ((!isExtensionActive('user')) || (!isExtensionInstalled('other')) || (isAjaxOutputMode()) || (getActivateXchange() == '0')) {
1253 // Silently abort here
1257 // Check total amount of users
1258 if (getTotalConfirmedUser() >= getActivateXchange()) {
1260 addSql("UPDATE `{?_MYSQL_PREFIX?}_mod_reg` SET `locked`='N',`hidden`='N',`mem_only`='Y' WHERE `module`='order' LIMIT 1");
1261 addSql("UPDATE `{?_MYSQL_PREFIX?}_member_menu` SET `visible`='Y',`locked`='N' WHERE `what`='order' OR `what`='unconfirmed' LIMIT 2");
1264 runFilterChain('run_sqls');
1266 // Update configuration
1267 updateConfiguration('activate_xchange' ,0);
1270 rebuildCache('modules', 'modules');
1274 // Filter to handle configuration
1275 function FILTER_HANDLE_HOME_IN_INDEX_SETTING ($filterData) {
1276 // Is ext-sql_patches up-to-date?
1277 if ((isExtensionInstalledAndNewer('sql_patches', '0.8.3')) && (isDisplayHomeInIndexEnabled())) {
1278 // Is 'search' as same as 'index_home'?
1279 if ($filterData['search'] == getIndexHome()) {
1280 // Then set 'content' to link to index.php
1281 $filterData['content'] = $filterData['prefix'] . '<strong><a class="you_are_here" href="{%url=index.php' . $filterData['link_add'] . '%}">' . getTitleFromMenu($filterData['access_level'], $filterData['search'], $filterData['type'], $filterData['add']) . '</a></strong>';
1289 // Filter to add history entry
1290 function FILTER_ADD_HISTORY_ENTRY ($filterData) {
1292 sqlQueryEscaped("INSERT INTO `{?_MYSQL_PREFIX?}_history` (`history_subject`, `history_userid`, `history_value`) VALUES ('%s',%s,'%s')",
1294 __FUNCTION__, __LINE__);
1296 // Remember insert id for other filters
1297 $filterData['history_id'] = getSqlInsertId();
1303 // Filter for initializing ext-sql_patches
1304 function FILTER_GENERATE_FILE_SECRET_HASH ($filterData) {
1305 // Transfer POINTS word
1306 if (isExtensionInstalledAndNewer('sql_patches', '0.0.3')) {
1307 // Okay, recent enough, so transfer the word for POINTS
1308 setConfigEntry('POINTS', getPointsWord());
1312 setConfigEntry('secret_key', '');
1314 // File hash fas generated so we can also file the secret file... hopefully.
1315 $hashFile = sprintf('%s%s.%s.cache', getPath(), getCachePath(), getFileHash());
1317 // Read key from secret file
1318 if ((getFileHash() == '') || (getMasterSalt() == '') || (getPassScramble() == '') || (!isFileReadable($hashFile))) {
1319 // Maybe need setup of secret key!
1320 loadIncludeOnce('inc/gen_sql_patches.php');
1324 if ((getFileHash() != '') && (getMasterSalt() != '') && (getPassScramble() != '')) {
1325 // Is the secret key file readable?
1326 if (isFileReadable($hashFile)) {
1328 setConfigEntry('secret_key', readFromFile($hashFile));
1330 // Remove it from database
1331 updateConfiguration('file_hash', '', '', '0', TRUE);
1333 // Cannot read secret file!
1334 reportBug(__FILE__, __LINE__, 'Cannot read secret file! Please try to reload.');
1342 // Filter to initialize session
1343 function FILTER_INIT_SESSION ($filterData) {
1344 // Determine and set referral id
1345 determineReferralId();
1351 // Filter for sending "build mail" to admin
1352 function FILTER_SEND_BUILD_MAIL ($filterData) {
1353 // Was one line updated?
1354 if (($filterData['affected'] > 0) || (isDebugBuildMailsEnabled())) {
1355 // Then call the proper function
1356 call_user_func_array('sendGenericBuildMails', $filterData);
1363 // Handles click on referral banner
1364 function FILTER_HANDLE_REFERRER_BANNER_CLICK ($filterData) {
1365 // Check required parameters
1366 if ((isGetRequestElementSet('user')) && (isGetRequestElementSet('banner'))) {
1367 // Update clicks counter...
1368 sqlQueryEscaped("UPDATE `{?_MYSQL_PREFIX?}_refbanner` SET `clicks`=`clicks`+1 WHERE `id`=%s LIMIT 1",
1369 array(bigintval(getRequestElement('banner'))), __FUNCTION__, __LINE__);
1371 // A line has been updated?
1372 if ((!ifSqlHasZeroAffectedRows()) && (isGetRequestElementSet('user'))) {
1373 // Redirect to the user's referral link
1374 redirectToUrl('ref.php?refid=' . bigintval(getRequestElement('user')));
1378 // Return filter data
1382 // Filter for handling viewing of a referral banner
1383 function FILTER_HANDLE_REFERRER_BANNER_VIEW ($filterData) {
1384 // Are all required parameters set
1385 if ((isGetRequestElementSet('user')) && (isGetRequestElementSet('banner'))) {
1386 // For later things... ;-)
1387 $result = sqlQueryEscaped("SELECT `url` FROM `{?_MYSQL_PREFIX?}_refbanner` WHERE `id`=%s LIMIT 1",
1388 array(bigintval(getRequestElement('banner'))), __FUNCTION__, __LINE__);
1390 // Is there the banner?
1391 if (sqlNumRows($result) == 1) {
1393 $data = sqlFetchArray($result);
1396 sqlQueryEscaped("UPDATE `{?_MYSQL_PREFIX?}_refbanner` SET `counter`=`counter`+1 WHERE `id`=%s LIMIT 1",
1397 array(bigintval(getRequestElement('banner'))), __FUNCTION__, __LINE__);
1399 // Set header and ...
1400 setContentType('image/' . substr($data['url'], -3, 3));
1403 redirectToUrl($data['url'], FALSE);
1406 // @TODO No banner found, output some default banner
1407 logDebugMessage(__FUNCTION__, __LINE__, 'Banner ' . bigintval(getRequestElement('banner')) . ' not found.');
1410 sqlFreeResult($result);
1413 // Do nothing for now
1414 redirectToUrl('modules.php?module=index');
1417 // Filter for redirecting on wrong server name (e.g. bad.your-server.tld will be redirected to your-server.tld)
1418 function FILTER_REDIRECT_WRONG_SERVER_NAME ($filterData) {
1422 // Is the configured URL same as SERVER_NAME?
1423 if (extractHostnameFromUrl($url) != detectServerName()) {
1425 logWrongServerNameRedirect();
1427 // Then redirect to configured URL
1428 redirectToRequestUri();
1431 // Return filter data
1435 // Filter for adding hidden session id
1436 function FILTER_ADD_INPUT_HIDDEN_SESSION_ID ($filterData) {
1437 // Is a spider detected?
1438 if ((!isSpider()) && (!isSessionValid()) && ($filterData['__form_method'] == 'get')) {
1439 // No, then add the hidden field
1440 $filterData['__replacer'] .= '<input type="hidden" name="' . session_name() . '" value="' . session_id() . '" />';
1443 // Return filter data
1447 // Filter for purging old SERVER_NAME entries
1448 function FILTER_SERVER_NAME_EXTRA_AUTOPURGE ($filterData) {
1449 // Is purging configured?
1450 if ((isApServerNameEnabled()) && (getApServerNameSince() > 0)) {
1451 // Then start purging
1452 sqlQuery('DELETE LOW_PRIORITY FROM
1453 `{?_MYSQL_PREFIX?}_server_name_log`
1455 (UNIX_TIMESTAMP() - UNIX_TIMESTAMP(`server_name_added`)) >= {?ap_server_name_since?}',
1456 __FILE__, __LINE__);
1458 // Are some entries deleted?
1459 if (sqlAffectedRows() > 0) {
1460 // Okay, then send an email to the admin
1461 sendAdminNotification('{--ADMIN_PURGE_USER_SERVER_NAME_LOG_SUBJECT--}', 'admin_purge_user_server_name_log', sqlAffectedRows());
1465 // Return filter data
1469 // Filter for detecting menu mode
1470 function FILTER_DETERMINE_MENU_MODE_GENERIC ($filterData) {
1472 switch (getModule()) {
1473 case 'chk_login': // Is also faked
1474 case 'confirm': // Login script is 'member'
1475 case 'loader': // Is faked to 'member' to avoid indexing by search engines
1476 case 'mailid': // Mail confirmation is 'member'
1477 $filterData = 'member';
1481 // Return filter data
1485 // Filter to exclude default referral id
1486 function FILTER_EXCLUDE_DEFAULT_REFID ($filterData = array()) {
1488 if (isValidId(getDefRefid())) {
1490 array_push($filterData, '{?def_refid?}');