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
---
interface/web/admin/form/dbsync.tform.php | 4 ++--
1 files changed, 2 insertions(+), 2 deletions(-)
diff --git a/interface/web/admin/form/dbsync.tform.php b/interface/web/admin/form/dbsync.tform.php
index 5e4ded8..27ad1f6 100644
--- a/interface/web/admin/form/dbsync.tform.php
+++ b/interface/web/admin/form/dbsync.tform.php
@@ -81,7 +81,7 @@
while ($file = @readdir ($handle)) {
if ($file != '.' && $file != '..' && substr($file, 0, 1) != '.') {
include_once(ISPC_WEB_PATH."/$md/form/$file");
- if($form['db_history'] == 'yes') {
+ if(isset($form['db_history']) && $form['db_history'] == 'yes') {
$tmp_id = $form['db_table'];
$db_tables[$tmp_id] = $form['db_table'];
}
@@ -94,7 +94,7 @@
$form['title'] = 'DB sync';
-$form['description'] = 'ISPConfig database snchronisation tool.';
+$form['description'] = 'ISPConfig database synchronisation tool.';
$form['name'] = 'dbsync';
$form['action'] = 'dbsync_edit.php';
$form['db_table'] = 'sys_dbsync';
--
Gitblit v1.9.1