Final fixes for SQL_ALTER_TABLE() wrapper, INSERT INTO queries are still not wrapped...
[mailer.git] / inc / filters.php
1 <?php
2 /************************************************************************
3  * MXChange v0.2.1                                    Start: 12/16/2008 *
4  * ===============                              Last change: 12/16/2008 *
5  *                                                                      *
6  * -------------------------------------------------------------------- *
7  * File              : filters.php                                      *
8  * -------------------------------------------------------------------- *
9  * Short description : Functions for filter system                      *
10  * -------------------------------------------------------------------- *
11  * Kurzbeschreibung  : Funktionen fuer Filter-System                    *
12  * -------------------------------------------------------------------- *
13  * $Revision::                                                        $ *
14  * $Date::                                                            $ *
15  * $Tag:: 0.2.1-FINAL                                                 $ *
16  * $Author::                                                          $ *
17  * Needs to be in all Files and every File needs "svn propset           *
18  * svn:keywords Date Revision" (autoprobset!) at least!!!!!!            *
19  * -------------------------------------------------------------------- *
20  * Copyright (c) 2003 - 2008 by Roland Haeder                           *
21  * For more information visit: http://www.mxchange.org                  *
22  *                                                                      *
23  * This program is free software; you can redistribute it and/or modify *
24  * it under the terms of the GNU General Public License as published by *
25  * the Free Software Foundation; either version 2 of the License, or    *
26  * (at your option) any later version.                                  *
27  *                                                                      *
28  * This program is distributed in the hope that it will be useful,      *
29  * but WITHOUT ANY WARRANTY; without even the implied warranty of       *
30  * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the        *
31  * GNU General Public License for more details.                         *
32  *                                                                      *
33  * You should have received a copy of the GNU General Public License    *
34  * along with this program; if not, write to the Free Software          *
35  * Foundation, Inc., 51 Franklin St, Fifth Floor, Boston,               *
36  * MA  02110-1301  USA                                                  *
37  ************************************************************************/
38
39 // Some security stuff...
40 if (!defined('__SECURITY')) {
41         $INC = substr(dirname(__FILE__), 0, strpos(dirname(__FILE__), "/inc") + 4)."/security.php";
42         require($INC);
43 }
44
45 // Init "generic filter system"
46 function INIT_FILTER_SYSTEM () {
47         // Is the filter already initialized?
48         if ((isset($GLOBALS['filters']['chains'])) && (is_array($GLOBALS['filters']['chains']))) {
49                 // Then abort here
50                 addFatalMessage(__FUNCTION__, __LINE__, getMessage('FILTER_FAILED_ALREADY_INIT'));
51                 return false;
52         } // END - if
53
54         // Init the filter system (just some ideas)
55         $GLOBALS['filters']['chains'] = array(
56                 // Filters for pre-init phase
57                 'preinit'   => array(),
58                 // Filters for post-init phase
59                 'postinit'  => array(),
60                 // Filters for shutdown phase
61                 'shutdown'  => array()
62         );
63
64         // Init loaded filters and counter
65         $GLOBALS['filters']['loaded'] =  array();
66         $GLOBALS['filters']['counter'] = array();
67
68         // Load all saved filers if sql_patches is updated
69         if (GET_EXT_VERSION("sql_patches") >= "0.5.9") {
70                 // Init add
71                 $ADD = "";
72                 if (GET_EXT_VERSION("sql_patches") >= "0.6.0") $ADD = ", `filter_counter`";
73
74                 // Load all active filers
75                 $result = SQL_QUERY("SELECT `filter_name`,`filter_function`,`filter_active`".$ADD."
76 FROM `{!_MYSQL_PREFIX!}_filters`
77 ORDER BY `filter_id` ASC", __FUNCTION__, __LINE__);
78
79                 // Are there entries?
80                 if (SQL_NUMROWS($result) > 0) {
81                         // Load all filters
82                         while ($filterArray = SQL_FETCHARRAY($result)) {
83                                 // Get filter name and function
84                                 $filterName     = $filterArray['filter_name'];
85                                 $filterFunction = $filterArray['filter_function'];
86
87                                 // Set counter to default
88                                 $GLOBALS['filters']['counter'][$filterName][$filterFunction] = 0;
89
90                                 // Mark this filter as loaded (from database)
91                                 $GLOBALS['filters']['loaded'][$filterName][$filterFunction] = true;
92
93                                 // Set this filter
94                                 $GLOBALS['filters']['chains'][$filterName][$filterFunction] = $filterArray['filter_active'];
95
96                                 // Is the array element for counter there?
97                                 if (isset($filterArray['filter_counter'])) {
98                                         // Then use this value!
99                                         $GLOBALS['filters']['counter'][$filterName][$filterFunction] = $filterArray['filter_counter'];
100                                 } // END - if
101                         } // END - while
102                 } // END - if
103         
104                 // Free result
105                 SQL_FREERESULT($result);
106         } // END - if
107
108         // Init filters
109         REGISTER_FILTER('init', 'UPDATE_LOGIN_DATA');
110         REGISTER_FILTER('init', 'INIT_RANDOMIZER');
111
112         // Login failures handler
113         REGISTER_FILTER('post_youhere_line', 'CALL_HANDLER_LOGIN_FAILTURES');
114
115         // Filters for pre-extension-registration
116         REGISTER_FILTER('pre_extension_installed', 'RUN_SQLS');
117
118         // Filters for post-extension-registration
119         REGISTER_FILTER('post_extension_installed', 'AUTO_ACTIVATE_EXTENSION');
120         REGISTER_FILTER('post_extension_installed', 'SOLVE_TASK');
121         REGISTER_FILTER('post_extension_installed', 'LOAD_INCLUDES');
122
123         // Solving tasks
124         REGISTER_FILTER('solve_task', 'SOLVE_TASK');
125
126         // Loading includes in general
127         REGISTER_FILTER('load_includes', 'LOAD_INCLUDES');
128
129         // Run SQLs
130         REGISTER_FILTER('run_sqls', 'RUN_SQLS');
131
132         // Admin ACL check
133         REGISTER_FILTER('check_admin_acl', 'CHECK_ADMIN_ACL');
134
135         // Register shutdown filters
136         REGISTER_FILTER('shutdown', 'FLUSH_FILTERS');
137 }
138
139 // "Registers" a new filter function
140 function REGISTER_FILTER ($filterName, $filterFunction, $silentAbort = true, $force = false, $dry_run = false) {
141         // Extend the filter function name
142         $filterFunction = sprintf("FILTER_%s", strtoupper($filterFunction));
143
144         // Is that filter already there?
145         if ((isset($GLOBALS['filters']['chains'][$filterName][$filterFunction])) && (!$force)) {
146                 // Then abort here
147                 if (!$silentAbort) {
148                         addFatalMessage(__FUNCTION__, __LINE__, getMessage('FILTER_FAILED_ALREADY_ADDED'), array($filterFunction, $filterName));
149                 } // END - if
150
151                 // Abort here
152                 return false;
153         } // END - if
154
155         // Is the function there?
156         if (!function_exists($filterFunction)) {
157                 // Then abort here
158                 addFatalMessage(__FUNCTION__, __LINE__, getMessage('FILTER_FAILED_NOT_FOUND'), array($filterFunction, $filterName));
159                 return false;
160         } // END - if
161
162         // Shall we add it?
163         if (!$dry_run) {
164                 // Simply add it to the array
165                 $GLOBALS['filters']['chains'][$filterName][$filterFunction] = "Y";
166                 $GLOBALS['filters']['counter'][$filterName][$filterFunction] = 0;
167         } // END - if
168 }
169
170 // "Unregisters" a filter from the given chain
171 function UNREGISTER_FILTER ($filterName, $filterFunction, $force = false, $dry_run = false) {
172         // Extend the filter function name only if not loaded from database
173         if (!isset($GLOBALS['filters']['loaded'][$filterName][$filterFunction])) {
174                 $filterFunction = sprintf("FILTER_%s", strtoupper($filterFunction));
175         } // END - if
176
177         // Is that filter there?
178         if ((!isset($GLOBALS['filters']['chains'][$filterName][$filterFunction])) && (!$force)) {
179                 // Not found, so abort here
180                 addFatalMessage(__FUNCTION__, __LINE__, getMessage('FILTER_FAILED_NOT_REMOVED'), array($filterFunction, $filterName));
181                 return false;
182         } // END - if
183
184         // Shall we remove? (default, not while just showing an extension removal)
185         if (!$dry_run) {
186                 // Mark for filter removal
187                 $GLOBALS['filters']['chains'][$filterName][$filterFunction] = "R";
188                 unset($GLOBALS['filters']['counter'][$filterName][$filterFunction]);
189         } // END  - if
190 }
191
192 // "Runs" the given filters, data is optional and can be any type of data
193 function runFilterChain ($filterName, $data = null, $silentAbort = true) {
194         // Is that filter chain there?
195         if (!isset($GLOBALS['filters']['chains'][$filterName])) {
196                 // Then abort here (quick'N'dirty hack)
197                 if ((!$silentAbort) && (defined('FILTER_FAILED_NO_FILTER_FOUND'))) {
198                         // Add fatal message
199                         addFatalMessage(__FUNCTION__, __LINE__, getMessage('FILTER_FAILED_NO_FILTER_FOUND'), $filterName);
200                 } // END - if
201
202                 // Abort here
203                 return false;
204         } // END - if
205
206         // Default return value
207         $returnValue = $data;
208
209         // Then run all filters
210         foreach ($GLOBALS['filters']['chains'][$filterName] as $filterFunction=>$active) {
211                 // Debug message
212                 //* DEBUG: */ echo __FUNCTION__."(<font color=\"#0000aa\">".__LINE__."</font>): name={$filterName},func={$filterFunction},active={$active}<br />\n";
213
214                 // Is the filter active?
215                 if ($active == "Y") {
216                         // Is this filter there?
217                         if (!function_exists($filterFunction)) {
218                                 // Unregister it
219                                 UNREGISTER_FILTER($filterName, $filterFunction);
220
221                                 // Skip this entry
222                                 continue;
223                         } // END - if
224
225                         // Call the filter chain
226                         $returnValue = call_user_func_array($filterFunction, array($returnValue));
227
228                         // Update usage counter
229                         $GLOBALS['filters']['counter'][$filterName][$filterFunction]++;
230                 } // END - if
231         } // END - foreach
232
233         // Return the filtered content
234         return $returnValue;
235 }
236
237 // -----------------------------------------------------------------------------
238 // Generic filter functions we always need
239 // -----------------------------------------------------------------------------
240
241 // Filter for flushing all new filters to the database
242 function FILTER_FLUSH_FILTERS () {
243         // Clear all previous SQL queries
244         INIT_SQLS();
245
246         // Are we installing?
247         if (isInstalling()) {
248                 // Then silently skip this filter
249                 return true;
250         } // END - if
251
252         // Is a database link here and not in installation mode?
253         if ((!SQL_IS_LINK_UP()) && (!isInstalling())) {
254                 // Abort here
255                 addFatalMessage(__FUNCTION__, __LINE__, getMessage('FILTER_FLUSH_FAILED_NO_DATABASE'));
256                 return false;
257         } // END - if
258
259         // Is the extension sql_patches updated?
260         if (EXT_VERSION_IS_OLDER("sql_patches", "0.5.9")) {
261                 // Abort silently here
262                 return false;
263         } // END - if
264
265         // Nothing is added/remove by default
266         $inserted = 0; $removed = 0;
267
268         // Prepare SQL queries
269         $insertSQL = "INSERT INTO `{!_MYSQL_PREFIX!}_filters` (`filter_name`,`filter_function`,`filter_active`) VALUES";
270         $removeSQL = "DELETE LOW_PRIORITY FROM `{!_MYSQL_PREFIX!}_filters` WHERE";
271
272         // Write all filters to database
273         foreach ($GLOBALS['filters']['chains'] as $filterName => $filterArray) {
274                 // Walk through all filters
275                 foreach ($filterArray as $filterFunction => $active) {
276                         // Is this filter loaded?
277                         if (!isset($GLOBALS['filters']['loaded'][$filterName][$filterFunction])) {
278                                 // Add this filter (all filters are active by default)
279                                 $insertSQL .= sprintf("('%s','%s','Y'),", $filterName, $filterFunction);
280                                 $inserted++;
281                         } elseif ($active == "R") {
282                                 // Remove this filter
283                                 $removeSQL .= sprintf(" (`filter_name`='%s' AND `filter_function`='%s') OR", $filterName, $filterFunction);
284                                 $removed++;
285                         }
286                 } // END - foreach
287         } // END - foreach
288
289         // Something has been added?
290         if ($inserted > 0) {
291                 // Finish SQL command
292                 $insertSQL = substr($insertSQL, 0, -1);
293
294                 // And run it
295                 ADD_SQL($insertSQL);
296         } // END - if
297
298         // Something has been removed?
299         if ($removed > 0) {
300                 // Finish SQL command
301                 $removeSQL = substr($removeSQL, 0, -2) . "LIMIT ".$removed;
302
303                 // And run it
304                 ADD_SQL($removeSQL);
305         } // END - if
306
307         // Shall we update usage counters (ONLY FOR DEBUGGING!)
308         if (getConfig('update_filter_usage') == "Y") {
309                 // Update all counters
310                 foreach ($GLOBALS['filters']['counter'] as $filterName => $filterArray) {
311                         // Walk through all filters
312                         foreach ($filterArray as $filterFunction => $cnt) {
313                                 // Construct and add the query
314                                 ADD_SQL(sprintf("UPDATE `{!_MYSQL_PREFIX!}_filters` SET `filter_counter`=%s WHERE `filter_name`='%s' AND `filter_function`='%s' LIMIT 1",
315                                         bigintval($cnt),
316                                         $filterName,
317                                         $filterFunction
318                                 ));
319                         } // END - foreach
320                 } // END - foreach
321         } // END - if
322
323         // Run the run_sqls filter in non-dry mode
324         runFilterChain('run_sqls');
325 }
326
327 // Filter for calling the handler for login failures
328 function FILTER_CALL_HANDLER_LOGIN_FAILTURES ($data) {
329         // Init content
330         $content = $data;
331
332         // Handle failed logins here if not in guest
333         //* DEBUG: */ print __FUNCTION__."(<font color=\"#0000aa\">".__LINE__."</font>):type={$data['type']},action={$GLOBALS['action']},what={$GLOBALS['what']},lvl={$data['access_level']}<br />\n";
334         if ((($data['type'] == "what") || ($data['type'] == "action") && ((!isset($GLOBALS['what'])) || ($GLOBALS['what'] == "overview") || ($GLOBALS['what'] == getConfig('index_home')))) && ($data['access_level'] != "guest") && ((GET_EXT_VERSION("sql_patches") >= "0.4.7") || (GET_EXT_VERSION("admins") >= "0.7.0"))) {
335                 // Handle failure
336                 $content['content'] .= HANDLE_LOGIN_FAILTURES($data['access_level']);
337         } // END - if
338
339         // Return the content
340         return $content;
341 }
342
343 // Filter for redirecting to logout if sql_patches has been installed
344 function FILTER_REDIRECT_TO_LOGOUT_SQL_PATCHES () {
345         // Remove this filter
346         UNREGISTER_FILTER('shutdown', __FUNCTION__);
347
348         // Is the element set?
349         if (isset($GLOBALS['ext_load_mode'])) {
350                 // Redirect here
351                 LOAD_URL("modules.php?module=admin&amp;logout=1&amp;".$GLOBALS['ext_load_mode']."=sql_patches");
352         } // END - if
353
354         // This should not happen!
355         DEBUG_LOG(__FUNCTION__, __LINE__, "Cannot auto-logout because no extension load-mode has been set.");
356 }
357
358 // Filter for auto-activation of a extension
359 function FILTER_AUTO_ACTIVATE_EXTENSION ($data) {
360         // Is this extension always activated?
361         if (EXT_GET_ALWAYS_ACTIVE() == "Y") {
362                 // Then activate the extension
363                 //* DEBUG: */ echo __FUNCTION__."(<font color=\"#0000aa\">".__LINE__."</font>): ext_name={$data['ext_name']}<br />\n";
364                 ACTIVATE_EXTENSION($data['ext_name']);
365         } // END - if
366
367         // Return the data
368         return $data;
369 }
370
371 // Filter for solving task given task
372 function FILTER_SOLVE_TASK ($data) {
373         // Don't solve anything if no admin!
374         if (!IS_ADMIN()) return $data;
375
376         // Is this a direct task id or array element task_id is found?
377         if (is_int($data)) {
378                 // Then solve it...
379                 ADMIN_SOLVE_TASK($data);
380         } elseif ((is_array($data)) && (isset($data['task_id']))) {
381                 // Solve it...
382                 ADMIN_SOLVE_TASK($data['task_id']);
383         }
384
385         // Return the data
386         return $data;
387 }
388
389 // Filter to load include files
390 function FILTER_LOAD_INCLUDES ($data) {
391         // Default is $data as inclusion list
392         $INC_POOL = $data;
393
394         // Is it an array?
395         if ((!isset($data)) || (!is_array($data))) {
396                 // Then abort here
397                 debug_report_bug(sprintf("INC_POOL is no array! Type: %s", gettype($INC_POOL)));
398         } elseif (isset($data['inc_pool'])) {
399                 // Use this as new inclusion pool!
400                 $INC_POOL = $data['inc_pool'];
401         }
402
403         // Check for added include files
404         if (count($INC_POOL) > 0) {
405                 // Loads every include file
406                 foreach ($INC_POOL as $FQFN) {
407                         LOAD_INC_ONCE($FQFN);
408                 } // END - foreach
409
410                 // Reset array
411                 if (isset($data['inc_pool'])) $data['inc_pool'] = array();
412         } // END - if
413
414         // Continue with processing
415         return $data;
416 }
417
418 // Filter for running SQL commands
419 function FILTER_RUN_SQLS ($data) {
420         // Debug message
421         //* DEBUG: */ DEBUG_LOG(__FUNCTION__, __LINE__, " - Entered!");
422
423         // Is the array there?
424         if ((IS_SQLS_VALID()) && ((!isset($data['dry_run'])) || ($data['dry_run'] == false))) {
425                 // Run SQL commands
426                 //* DEBUG: */ DEBUG_LOG(__FUNCTION__, __LINE__, " - Found ".COUNT_SQLS()." queries to run.");
427                 foreach (GET_SQLS() as $sql) {
428                         // Trim spaces away
429                         $sql = trim($sql);
430
431                         // Is there still a query left?
432                         if (!empty($sql)) {
433                                 // Do we have an "ALTER TABLE" command?
434                                 if (substr(strtolower($sql), 0, 11) == "alter table") {
435                                         // Analyse the alteration command
436                                         //* DEBUG: */ DEBUG_LOG(__FUNCTION__, __LINE__, "Alterting table: {$sql}");
437                                         SQL_ALTER_TABLE($sql, __FUNCTION__, __LINE__);
438                                 } else {
439                                         // Run regular SQL command
440                                         //* DEBUG: */ DEBUG_LOG(__FUNCTION__, __LINE__, "Running regular query: {$sql}");
441                                         $result = SQL_QUERY($sql, __FUNCTION__, __LINE__, false);
442                                 }
443                         } // END - if
444                 } // END - foreach
445         } // END - if
446
447         // Debug message
448         //* DEBUG: */ DEBUG_LOG(__FUNCTION__, __LINE__, " - Left!");
449 }
450
451 // Filter for updating/validating login data
452 function FILTER_UPDATE_LOGIN_DATA () {
453         // Add missing array
454         if ((!isset($GLOBALS['last'])) || (!is_array($GLOBALS['last']))) $GLOBALS['last'] = array();
455
456         // Recheck if logged in
457         if (!IS_MEMBER()) return false;
458
459         // Secure user ID
460         setUserId(get_session('userid'));
461
462         // Load last module and last online time
463         $result = SQL_QUERY_ESC("SELECT last_module, last_online FROM `{!_MYSQL_PREFIX!}_user_data` WHERE userid=%s LIMIT 1",
464                 array(getUserId()), __FUNCTION__, __LINE__);
465
466         // Entry found?
467         if (SQL_NUMROWS($result) == 1) {
468                 // Load last module and online time
469                 list($mod, $onl) = SQL_FETCHROW($result);
470
471                 // Maybe first login time?
472                 if (empty($mod)) $mod = "login";
473
474                 // This will be displayed on welcome page! :-)
475                 if (empty($GLOBALS['last']['module'])) {
476                         $GLOBALS['last']['module'] = $mod; $GLOBALS['last']['online'] = $onl;
477                 } // END - if
478
479                 // "what" not set?
480                 if (empty($GLOBALS['what'])) {
481                         // Fix it to default
482                         $GLOBALS['what'] = "welcome";
483                         if (getConfig('index_home') != "") $GLOBALS['what'] = getConfig('index_home');
484                 } // END - if
485
486                 // Update last module / online time
487                 SQL_QUERY_ESC("UPDATE `{!_MYSQL_PREFIX!}_user_data` SET last_module='%s', last_online=UNIX_TIMESTAMP(), REMOTE_ADDR='%s' WHERE userid=%s LIMIT 1",
488                         array($GLOBALS['what'], GET_REMOTE_ADDR(), getUserId()), __FUNCTION__, __LINE__);
489         }  else {
490                 // Destroy session, we cannot update!
491                 destroy_user_session();
492         }
493
494         // Free the result
495         SQL_FREERESULT($result);
496 }
497
498 // Filter for checking admin ACL
499 function FILTER_CHECK_ADMIN_ACL () {
500         // Extension not installed so it's always allowed to access everywhere!
501         $ret = true;
502
503         // Ok, Cookie-Update done
504         if (GET_EXT_VERSION("admins") >= "0.3") {
505                 // Check if action GET variable was set
506                 $action = SQL_ESCAPE($GLOBALS['action']);
507                 if (!empty($GLOBALS['what'])) {
508                         // Get action value by what-value
509                         $action = GET_ACTION("admin", $GLOBALS['what']);
510                 } // END - if
511
512                 // Check for access control line of current menu entry
513                 $ret = ADMINS_CHECK_ACL($action, $GLOBALS['what']);
514         } // END - if
515
516         // Return result
517         return $ret;
518 }
519
520 // Filter for initializing randomizer
521 function FILTER_INIT_RANDOMIZER () {
522         // Simply init the randomizer with seed and _ADD value
523         mt_srand(generateSeed() + constant('_ADD'));
524 }
525
526 //
527 ?>