From 06c8fa0abbe2ff3a9c05f8514e229f1a64eb514b Mon Sep 17 00:00:00 2001
From: Marc Delisle <marc@infomarc.info>
Date: Mon, 26 Apr 2010 16:38:20 -0400
Subject: [PATCH] Tracking report should obey MaxCharactersInDisplayedSQL

---
 ChangeLog        |  1 +
 tbl_tracking.php | 14 ++++++++++----
 2 files changed, 11 insertions(+), 4 deletions(-)

diff --git a/ChangeLog b/ChangeLog
index f39c01f079..46a7f1c008 100644
--- a/ChangeLog
+++ b/ChangeLog
@@ -23,6 +23,7 @@ $HeadURL: https://phpmyadmin.svn.sourceforge.net/svnroot/phpmyadmin/trunk/phpMyA
 - bug #2974067 [display] non-binary fields shown as hex
 - bug #2983065 [operations] Error when changing from Maria to MyISAM engine
 - bug #2975408 [tracking] Data too long for column data_sql
+- bug [tracking] Tracking report should obey MaxCharactersInDisplayedSQL 
 
 3.3.2.0 (2010-04-13)
 - patch #2969449 [core] Name for MERGE engine varies depending on the
diff --git a/tbl_tracking.php b/tbl_tracking.php
index fbee82a956..224ed87890 100644
--- a/tbl_tracking.php
+++ b/tbl_tracking.php
@@ -417,8 +417,11 @@ if (isset($_REQUEST['report']) || isset($_REQUEST['report_export'])) {
         <?php
         $style = 'odd';
         foreach ($data['ddlog'] as $entry) {
-            $parsed_sql = PMA_SQP_parse($entry['statement']);
-            $statement  = PMA_formatSql($parsed_sql);
+            if (strlen($entry['statement']) > $GLOBALS['cfg']['MaxCharactersInDisplayedSQL']) {
+                $statement = substr($entry['statement'], 0, $GLOBALS['cfg']['MaxCharactersInDisplayedSQL']) . '[...]';
+            } else {
+                $statement  = PMA_formatSql(PMA_SQP_parse($entry['statement']));
+            }
             $timestamp = strtotime($entry['date']);
 
             if ($timestamp >= $filter_ts_from && $timestamp <= $filter_ts_to && 
@@ -465,8 +468,11 @@ if (isset($_REQUEST['report']) || isset($_REQUEST['report_export'])) {
         <?php
         $style = 'odd';
         foreach ($data['dmlog'] as $entry) {
-            $parsed_sql = PMA_SQP_parse($entry['statement']);
-            $statement  = PMA_formatSql($parsed_sql);
+            if (strlen($entry['statement']) > $GLOBALS['cfg']['MaxCharactersInDisplayedSQL']) {
+                $statement = substr($entry['statement'], 0, $GLOBALS['cfg']['MaxCharactersInDisplayedSQL']) . '[...]';
+            } else {
+                $statement  = PMA_formatSql(PMA_SQP_parse($entry['statement']));
+            }
             $timestamp = strtotime($entry['date']);
 
             if ($timestamp >= $filter_ts_from && $timestamp <= $filter_ts_to && 
-- 
2.11.4.GIT