[vassalengine-svn] SF.net SVN: vassalengine:[6776] site-src/trunk/bridge/src/Bridge.php
Brought to you by:
rodneykinney,
uckelman
From: <uck...@us...> - 2010-04-27 22:53:07
|
Revision: 6776 http://vassalengine.svn.sourceforge.net/vassalengine/?rev=6776&view=rev Author: uckelman Date: 2010-04-27 22:53:01 +0000 (Tue, 27 Apr 2010) Log Message: ----------- Correct SQL. Modified Paths: -------------- site-src/trunk/bridge/src/Bridge.php Modified: site-src/trunk/bridge/src/Bridge.php =================================================================== --- site-src/trunk/bridge/src/Bridge.php 2010-04-27 22:46:36 UTC (rev 6775) +++ site-src/trunk/bridge/src/Bridge.php 2010-04-27 22:53:01 UTC (rev 6776) @@ -28,10 +28,10 @@ $sql = 'SELECT p1.message_id FROM posts AS p1 ' . 'LEFT OUTER JOIN posts AS p2 ON (' . - 'p1.post_id = ' . $postId . ' AND ' . - 'p2.post_id = ' . $postId . ' AND ' . + 'p1.post_id = p2.post_id AND ' . 'p1.edit_id < p2.edit_id' . - ') WHERE p2.post_id IS NULL'; + ') WHERE p1.post_id = ' . $postId . ' AND ' . + 'p2.post_id IS NULL'; $row = $this->get_exactly_one_row($sql); return $row ? $row['message_id'] : false; This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |