The branch, master has been updated via dad70b66d913ee1b0cac4ce3e7bd8bbff1728ada (commit) from d01bb41213b9241e0d45b5a3f63b6869bb85a071 (commit)
- Log ----------------------------------------------------------------- commit dad70b66d913ee1b0cac4ce3e7bd8bbff1728ada Author: Rouslan Placella rouslan@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