// Init "generic filter system"
function INIT_FILTER_SYSTEM() {
- global $filters, $loadedFilters;
+ global $filters, $loadedFilters, $counter;
// Is the filter already initialized?
if ((isset($filters)) && (is_array($filters))) {
'shutdown' => array()
);
- // Init loaded filters
+ // Init loaded filters and counter
$loadedFilters = array();
+ $counter = array();
// Load all saved filers if sql_patches is updated
if (GET_EXT_VERSION("sql_patches") >= "0.5.9") {
+ // Init add
+ $ADD = "";
+ if (GET_EXT_VERSION("sql_patches") >= "0.6.0") $ADD = ", `filter_counter`";
+
// Load all active filers
- $result = SQL_QUERY("SELECT `filter_name`, `filter_function`, `filter_active`
+ $result = SQL_QUERY("SELECT `filter_name`, `filter_function`, `filter_active`".$ADD."
FROM `"._MYSQL_PREFIX."_filters`
ORDER BY `filter_id` ASC", __FILE__, __LINE__);
if (SQL_NUMROWS($result) > 0) {
// Load all filters
while ($filterArray = SQL_FETCHARRAY($result)) {
+ // Get filter name and function
+ $filterName = $filterArray['filter_name'];
+ $filterFunction = $filterArray['filter_function'];
+
+ // Set counter to default
+ $counter[$filterName][$filterFunction] = 0;
+
// Mark this filter as loaded (from database)
- $loadedFilters[$filterArray['filter_name']][$filterArray['filter_function']] = true;
+ $loadedFilters[$filterName][$filterFunction] = true;
// Set this filter
- $filters[$filterArray['filter_name']][$filterArray['filter_function']] = $filterArray['filter_active'];
+ $filters[$filterName][$filterFunction] = $filterArray['filter_active'];
+
+ // Is the array element for counter there?
+ if (isset($filterArray['filter_counter'])) {
+ // Then use this value!
+ $counter[$filterName][$filterFunction] = $filterArray['filter_counter'];
+ } // END - if
} // END - while
} // END - if
SQL_FREERESULT($result);
} // END - if
- // @TODO Find some more init/shutdown filter functions
+ // Login failtures handler
+ REGISTER_FILTER('post_youhere_line', 'CALL_HANDLER_LOGIN_FAILTURES');
+
+ // Filters for pre-extension-registration
+ REGISTER_FILTER('pre_extension_installed', 'RUN_SQLS');
+
+ // Filters for post-extension-registration
+ REGISTER_FILTER('post_extension_installed', 'AUTO_ACTIVATE_EXTENSION');
+ REGISTER_FILTER('post_extension_installed', 'SOLVE_TASK');
+ REGISTER_FILTER('post_extension_installed', 'LOAD_INCLUDES');
+
+ // Solving tasks
+ REGISTER_FILTER('solve_task', 'SOLVE_TASK');
+
+ // Loading includes in general
+ REGISTER_FILTER('load_includes', 'LOAD_INCLUDES');
+
+ // Run SQLs
+ REGISTER_FILTER('run_sqls', 'RUN_SQLS');
// Register shutdown filters
REGISTER_FILTER('shutdown', 'FLUSH_FILTERS');
- REGISTER_FILTER('shutdown', 'SHUTDOWN_DATABASE');
}
// "Registers" a new filter function
-function REGISTER_FILTER ($filterName, $filterFunction, $silentAbort = true, $force = false) {
- global $filters;
+function REGISTER_FILTER ($filterName, $filterFunction, $silentAbort = true, $force = false, $add = true) {
+ global $filters, $counter;
// Extend the filter function name
$filterFunction = sprintf("FILTER_%s", strtoupper($filterFunction));
return false;
} // END - if
- // Simply add it to the array
- $filters[$filterName][$filterFunction] = "Y";
+ // Shall we add it?
+ if ($add) {
+ // Simply add it to the array
+ $filters[$filterName][$filterFunction] = "Y";
+ $counter[$filterName][$filterFunction] = 0;
+ } // END - if
}
// "Unregisters" a filter from the given chain
function UNREGISTER_FILTER ($filterName, $filterFunction, $force = false, $remove = true) {
- global $filters;
+ global $filters, $counter;
// Extend the filter function name
$filterFunction = sprintf("FILTER_%s", strtoupper($filterFunction));
if ($remove) {
// Mark for filter removal
$filters[$filterName][$filterFunction] = "R";
+ unset($counter[$filterName][$filterFunction]);
} // END - if
}
// "Runs" the given filters, data is optional and can be any type of data
function RUN_FILTER ($filterName, $data = null, $silentAbort = true) {
- global $filters;
+ global $filters, $counter;
// Is that filter chain there?
if (!isset($filters[$filterName])) {
// Is the filter active?
if ($active == "Y") {
+ // Is this filter there?
+ if (!function_exists($filterFunction)) {
+ // Unregister it
+ UNREGISTER_FILTER($filterName, $filterFunction);
+
+ // Skip this entry
+ continue;
+ } // END - if
+
// Call the filter chain
$returnValue = call_user_func_array($filterFunction, array($returnValue));
+
+ // Update usage counter
+ $counter[$filterName][$filterFunction]++;
} // END - if
} // END - foreach
// Filter for flushing all new filters to the database
function FILTER_FLUSH_FILTERS () {
- global $filters, $link, $loadedFilters;
+ global $filters, $counter, $link, $loadedFilters, $SQLs;
+
+ // Clear all previous SQL queries
+ $SQLs = array();
// Is a database link here and not in installation mode?
if ((!is_resource($link)) && (!isBooleanConstantAndTrue('mxchange_installing'))) {
$insertSQL = substr($insertSQL, 0, -1);
// And run it
- SQL_QUERY($insertSQL, __FILE__, __LINE__);
+ $SQLs[] = $insertSQL;
} // END - if
// Something has been removed?
$removeSQL = substr($removeSQL, 0, -2) . "LIMIT ".$removed;
// And run it
- SQL_QUERY($removeSQL, __FILE__, __LINE__);
+ $removeSQL;
+ } // END - if
+
+ // Shall we update usage counters (ONLY FOR DEBUGGING!)
+ if (getConfig('update_filter_usage') == "Y") {
+ // Update all counters
+ foreach ($counter as $filterName => $filterArray) {
+ // Walk through all filters
+ foreach ($filterArray as $filterFunction => $cnt) {
+ // Construct and add the query
+ $SQLs[] = sprintf("UPDATE `"._MYSQL_PREFIX."_filters` SET `filter_counter`=%s WHERE `filter_name`='%s' AND `filter_function`='%s' LIMIT 1",
+ bigintval($cnt),
+ $filterName,
+ $filterFunction
+ );
+ } // END - foreach
+ } // END - foreach
+ } // END - if
+
+ // Run the run_sqls filter in non-dry mode
+ RUN_FILTER('run_sqls', false);
+}
+
+// Filter for calling the handler for login failtures
+function FILTER_CALL_HANDLER_LOGIN_FAILTURES ($data) {
+ // Init content
+ $content = $data;
+
+ // Handle failed logins here if not in guest
+ //* DEBUG: */ print __FUNCTION__."(<font color=\"#0000aa\">".__LINE__."</font>):type={$data['type']},action={$GLOBALS['action']},what={$GLOBALS['what']},lvl={$data['access_level']}<br />\n";
+ 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"))) {
+ // Handle failture
+ $content['content'] .= HANDLE_LOGIN_FAILTURES($data['access_level']);
} // END - if
+
+ // Return the content
+ return $content;
}
-// Filter for shutting down the database link
-function FILTER_SHUTDOWN_DATABASE () {
- global $link;
+// Filter for redirecting to logout if sql_patches has been installed
+function FILTER_REDIRECT_TO_LOGOUT_SQL_PATCHES () {
+ // Remove this filter
+ UNREGISTER_FILTER('shutdown', __FUNCTION__);
- if (is_resource($link)) {
- // Close link
- SQL_CLOSE($link, __FILE__, __LINE__);
- } else {
- // No database link
- ADD_FATAL(NO_DB_LINK);
+ // Is the element set?
+ if (isset($GLOBALS['ext_load_mode'])) {
+ // Redirect here
+ LOAD_URL("modules.php?module=admin&logout=1&".$GLOBALS['ext_load_mode']."=sql_patches");
+ } // END - if
+
+ // This should not happen!
+ DEBUG_LOG(__FUNCTION__, __LINE__, "Cannot auto-logout because no extension load-mode has been set.");
+}
+
+// Filter for auto-activation of a extension
+function FILTER_AUTO_ACTIVATE_EXTENSION ($data) {
+ global $EXT_ALWAYS_ACTIVE;
+
+ // Is this extension always activated?
+ if ($EXT_ALWAYS_ACTIVE == "Y") {
+ // Then activate the extension
+ //* DEBUG: */ echo __FUNCTION__."(<font color=\"#0000aa\">".__LINE__."</font>): ext_name={$data['ext_name']}<br />\n";
+ ACTIVATE_EXTENSION($data['ext_name']);
+ } // END - if
+
+ // Return the data
+ return $data;
+}
+
+// Filter for solving task given task
+function FILTER_SOLVE_TASK ($data) {
+ // Don't solve anything if no admin!
+ if (!IS_ADMIN()) return $data;
+
+ // Is this a direct task id or array element task_id is found?
+ if (is_int($data)) {
+ // Then solve it...
+ ADMIN_SOLVE_TASK($data);
+ } elseif ((is_array($data)) && (isset($data['task_id']))) {
+ // Solve it...
+ ADMIN_SOLVE_TASK($data['task_id']);
+ }
+
+ // Return the data
+ return $data;
+}
+
+// Filter to load include files
+function FILTER_LOAD_INCLUDES ($data) {
+ global $INC_POOL;
+
+ // Is it an array?
+ if ((!isset($INC_POOL)) || (!is_array($INC_POOL))) {
+ // Then abort here
+ DEBUG_LOG(__FILE__, __LINE__, "INC_POOL is no array!");
+ return $data;
+ } // END - if
+
+ // Check for added include files
+ if (count($INC_POOL) > 0) {
+ // Loads every include file
+ foreach ($INC_POOL as $fqfn) {
+ require_once($fqfn);
+ } // END - foreach
+
+ // Remove array
+ unset($INC_POOL);
+ } // END - if
+
+ // Return $data
+ return $data;
+}
+
+// Filter for running SQL commands
+function FILTER_RUN_SQLS ($dry_run) {
+ global $SQLs;
+
+ // Is the array there?
+ if ((is_array($SQLs)) && (!$dry_run)) {
+ // Run SQL commands
+ foreach ($SQLs as $sql) {
+ $sql = trim($sql);
+ if (!empty($sql)) {
+ // Do we have an "ALTER TABLE" command?
+ if (substr(strtolower($sql), 0, 11) == "alter table") {
+ // Analyse the alteration command
+ SQL_ALTER_TABLE($sql, __FILE__, __LINE__);
+ } else {
+ // Run regular SQL command
+ $result = SQL_QUERY($sql, __FILE__, __LINE__, false);
+ }
+ } // END - if
+ } // END - foreach
+ } elseif (GET_EXT_VERSION("sql_patches") == "") {
+ // Remove SQLs if extension is not installed
+ $SQLs = array();
}
}