diff options
| author | bitweaver.org <bitweaver@users.sourceforge.net> | 2006-02-18 18:36:42 +0000 |
|---|---|---|
| committer | bitweaver.org <bitweaver@users.sourceforge.net> | 2006-02-18 18:36:42 +0000 |
| commit | 78bc7e8837520c376aaca3adebd39415c040eed7 (patch) | |
| tree | 8f17b0433615d70cf244d343e8ae7c5984326aaa /LibertyComment.php | |
| parent | 4d8ab61600fb1b8b66385bb7c6c075741802477d (diff) | |
| download | liberty-78bc7e8837520c376aaca3adebd39415c040eed7.tar.gz liberty-78bc7e8837520c376aaca3adebd39415c040eed7.tar.bz2 liberty-78bc7e8837520c376aaca3adebd39415c040eed7.zip | |
left outer join on root so updater works
Diffstat (limited to 'LibertyComment.php')
| -rw-r--r-- | LibertyComment.php | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/LibertyComment.php b/LibertyComment.php index 37c305b..26c1325 100644 --- a/LibertyComment.php +++ b/LibertyComment.php @@ -3,7 +3,7 @@ * Management of Liberty Content * * @package liberty - * @version $Header: /cvsroot/bitweaver/_bit_liberty/LibertyComment.php,v 1.14 2006/02/16 23:32:54 spiderr Exp $ + * @version $Header: /cvsroot/bitweaver/_bit_liberty/LibertyComment.php,v 1.15 2006/02/18 18:36:42 bitweaver Exp $ * @author spider <spider@steelsun.com> */ @@ -220,7 +220,7 @@ class LibertyComment extends LibertyContent { $bindVars[] = $pParamHash['created_ge']; } - + // left outer join on root so updater works $query = "SELECT" . " lcm.`comment_id` as comment_id, " @@ -240,7 +240,7 @@ class LibertyComment extends LibertyContent { . " FROM `".BIT_DB_PREFIX."liberty_comments` lcm INNER JOIN `".BIT_DB_PREFIX."liberty_content` lc ON (lcm.`content_id`=lc.`content_id` ) INNER JOIN `".BIT_DB_PREFIX."users_users` uu ON (uu.`user_id`=lc.`user_id`) - INNER JOIN `".BIT_DB_PREFIX."liberty_content` rlc ON (rlc.`content_id`=lcm.`root_id` ) + LEFT OUTER JOIN `".BIT_DB_PREFIX."liberty_content` rlc ON (rlc.`content_id`=lcm.`root_id` ) $joinSql ,`".BIT_DB_PREFIX."liberty_content` ptc WHERE lcm.`parent_id`=ptc.`content_id` $whereSql ORDER BY $sort_mode"; |