From 51d5652343f9d731caefd32e8de790c18bb2e95b Mon Sep 17 00:00:00 2001 From: uckelman Date: Tue, 27 Apr 2010 22:46:36 +0000 Subject: Adjusted query, left out $postId. Oops. git-svn-id: https://vassalengine.svn.sourceforge.net/svnroot/vassalengine/site-src/trunk@6775 67b53d14-2c14-4ace-a08f-0dab2b34000c --- src/Bridge.php | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) (limited to 'src') diff --git a/src/Bridge.php b/src/Bridge.php index 91247b8..9753470 100644 --- a/src/Bridge.php +++ b/src/Bridge.php @@ -28,7 +28,8 @@ class Bridge { $sql = 'SELECT p1.message_id FROM posts AS p1 ' . 'LEFT OUTER JOIN posts AS p2 ON (' . - 'p1.post_id = p2.post_id AND ' . + 'p1.post_id = ' . $postId . ' AND ' . + 'p2.post_id = ' . $postId . ' AND ' . 'p1.edit_id < p2.edit_id' . ') WHERE p2.post_id IS NULL'; -- cgit v1.2.3