17 Sep
2011
17 Sep
'11
5:54 p.m.
The branch, master has been updated
via dad70b66d913ee1b0cac4ce3e7bd8bbff1728ada (commit)
from d01bb41213b9241e0d45b5a3f63b6869bb85a071 (commit)
- Log -----------------------------------------------------------------
commit dad70b66d913ee1b0cac4ce3e7bd8bbff1728ada
Author: Rouslan Placella <rouslan(a)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