[Phpmyadmin-git] [SCM] phpMyAdmin branch, master, updated. RELEASE_3_4_5RC1-19173-gdad70b6

Rouslan Placella roccivic at users.sourceforge.net
Sat Sep 17 16:54:54 CEST 2011


The branch, master has been updated
       via  dad70b66d913ee1b0cac4ce3e7bd8bbff1728ada (commit)
      from  d01bb41213b9241e0d45b5a3f63b6869bb85a071 (commit)


- Log -----------------------------------------------------------------
commit dad70b66d913ee1b0cac4ce3e7bd8bbff1728ada
Author: Rouslan Placella <rouslan at placella.com>
Date:   Sat Sep 17 15:54:27 2011 +0100

    Fixed broken retreival of triggers for a specific table

-----------------------------------------------------------------------

Summary of changes:
 libraries/database_interface.lib.php |    6 +++---
 1 files changed, 3 insertions(+), 3 deletions(-)

diff --git a/libraries/database_interface.lib.php b/libraries/database_interface.lib.php
index 709e15f..f0520a7 100644
--- a/libraries/database_interface.lib.php
+++ b/libraries/database_interface.lib.php
@@ -1603,12 +1603,12 @@ function PMA_DBI_get_triggers($db, $table = '', $delimiter = '//')
         // Note: in http://dev.mysql.com/doc/refman/5.0/en/faqs-triggers.html
         // their example uses WHERE TRIGGER_SCHEMA='dbname' so let's use this
         // instead of WHERE EVENT_OBJECT_SCHEMA='dbname'
-        $query = "SELECT TRIGGER_SCHEMA, TRIGGER_NAME, EVENT_MANIPULATION, EVENT_OBJECT_TABLE, ACTION_TIMING, ACTION_STATEMENT, EVENT_OBJECT_SCHEMA, EVENT_OBJECT_TABLE, DEFINER FROM information_schema.TRIGGERS WHERE TRIGGER_SCHEMA= '" . PMA_sqlAddSlashes($db,true) . "';";
+        $query = "SELECT TRIGGER_SCHEMA, TRIGGER_NAME, EVENT_MANIPULATION, EVENT_OBJECT_TABLE, ACTION_TIMING, ACTION_STATEMENT, EVENT_OBJECT_SCHEMA, EVENT_OBJECT_TABLE, DEFINER FROM information_schema.TRIGGERS WHERE TRIGGER_SCHEMA= '" . PMA_sqlAddSlashes($db) . "'";
         if (! empty($table)) {
-            $query .= " AND EVENT_OBJECT_TABLE = '" . PMA_sqlAddSlashes($table, true) . "';";
+            $query .= " AND EVENT_OBJECT_TABLE = '" . PMA_sqlAddSlashes($table) . "';";
         }
     } else {
-        $query = "SHOW TRIGGERS FROM " . PMA_backquote(PMA_sqlAddSlashes($db,true));
+        $query = "SHOW TRIGGERS FROM " . PMA_backquote($db);
         if (! empty($table)) {
             $query .= " LIKE '" . PMA_sqlAddSlashes($table, true) . "';";
         }


hooks/post-receive
-- 
phpMyAdmin




More information about the Git mailing list