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 | 29 ++++++++++++++++++++++++++++-
1 files changed, 28 insertions(+), 1 deletions(-)
diff --git a/server/mods-available/server_module.inc.php b/server/mods-available/server_module.inc.php
index 1d672ab..fb7042f 100644
--- a/server/mods-available/server_module.inc.php
+++ b/server/mods-available/server_module.inc.php
@@ -37,7 +37,22 @@
'server_delete',
'server_ip_insert',
'server_ip_update',
- 'server_ip_delete');
+ 'server_ip_delete',
+ 'firewall_insert',
+ 'firewall_update',
+ '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
@@ -65,6 +80,8 @@
$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');
@@ -90,6 +107,16 @@
if($action == 'u') $app->plugins->raiseEvent('server_ip_update',$data);
if($action == 'd') $app->plugins->raiseEvent('server_ip_delete',$data);
break;
+ case 'firewall':
+ if($action == 'i') $app->plugins->raiseEvent('firewall_insert',$data);
+ 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