[Stack-cvs] stack-dev/lib/database StackDBItem.php, 1.35.2.10, 1.35.2.11

[Simon H. <sim...@us...>]

Update of /cvsroot/stack/stack-dev/lib/database
In directory sfp-cvsdas-3.v30.ch3.sourceforge.com:/tmp/cvs-serv21325/lib/database

Modified Files:
      Tag: STACK2_2
	StackDBItem.php 
Log Message:
Fixed to show only latest version of a line from a tag search.

Index: StackDBItem.php
===================================================================
RCS file: /cvsroot/stack/stack-dev/lib/database/StackDBItem.php,v
retrieving revision 1.35.2.10
retrieving revision 1.35.2.11
diff -C2 -d -r1.35.2.10 -r1.35.2.11
*** StackDBItem.php	2 Jul 2010 14:42:07 -0000	1.35.2.10
--- StackDBItem.php	22 Jul 2010 15:31:50 -0000	1.35.2.11
***************
*** 733,740 ****
  	public function getQuestionsTagged($tagLine, $userID=NULL,$public=false) {
  		$tag = $tagLine; // to explode
! 		$sql = "SELECT stackquestion.* from stackquestion, question_keyword, keywords " .
  				"WHERE keywords.keyword = ".$this->dbSafeString($tag)." " .
  				"AND keywords.id = kwid " .
! 				"AND qid = stackquestion.questionID";
  		$result = $this->query($sql);
  
--- 733,741 ----
  	public function getQuestionsTagged($tagLine, $userID=NULL,$public=false) {
  		$tag = $tagLine; // to explode
! 		$sql = "SELECT stackquestion.* from stackquestion, question_keyword, keywords, question_lines " .
  				"WHERE keywords.keyword = ".$this->dbSafeString($tag)." " .
  				"AND keywords.id = kwid " .
! 				"AND qid = stackquestion.questionID " .
! 				"AND qid = latestVersion";
  		$result = $this->query($sql);