From 0732d32f508045da40fe9df607b9ef20ce2d198f Mon Sep 17 00:00:00 2001 From: xaver <xaver@ispconfig3> Date: Tue, 06 Mar 2012 10:03:23 -0500 Subject: [PATCH] join fix - disappered in commit + Switch traffic joins, because its faster - Tested in a productive system (MySQL 5.1) as query few tausend domains 1-3 sec for Webtraffic sort, faster SQL = faster and MySQL 5.5 is much faster with joins (standard is not sorted with slow traffic querys) -> slowest part is coping the tables into temp -> more tweeks on cache... -> faster by heavy use --- server/mods-available/server_module.inc.php | 20 +++++++++++++++++++- 1 files changed, 19 insertions(+), 1 deletions(-) diff --git a/server/mods-available/server_module.inc.php b/server/mods-available/server_module.inc.php index a9e28dd..fb7042f 100644 --- a/server/mods-available/server_module.inc.php +++ b/server/mods-available/server_module.inc.php @@ -40,7 +40,19 @@ 'server_ip_delete', 'firewall_insert', 'firewall_update', - 'firewall_delete'); + 'firewall_delete', + 'software_update_inst_insert', + 'software_update_inst_update', + 'software_update_inst_delete'); + + //* This function is called during ispconfig installation to determine + // if a symlink shall be created for this plugin. + function onInstall() { + global $conf; + + return true; + + } /* This function is called when the module is loaded @@ -69,6 +81,7 @@ $app->modules->registerTableHook('server','server_module','process'); $app->modules->registerTableHook('server_ip','server_module','process'); $app->modules->registerTableHook('firewall','server_module','process'); + $app->modules->registerTableHook('software_update_inst','server_module','process'); // Register service //$app->services->registerService('httpd','web_module','restartHttpd'); @@ -99,6 +112,11 @@ if($action == 'u') $app->plugins->raiseEvent('firewall_update',$data); if($action == 'd') $app->plugins->raiseEvent('firewall_delete',$data); break; + case 'software_update_inst': + if($action == 'i') $app->plugins->raiseEvent('software_update_inst_insert',$data); + if($action == 'u') $app->plugins->raiseEvent('software_update_inst_update',$data); + if($action == 'd') $app->plugins->raiseEvent('software_update_inst_delete',$data); + break; } // end switch } // end function -- Gitblit v1.9.1