[Stack-cvs] stack-dev/lib/database StackDBReporting.php,1.31,1.32

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

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

Modified Files:
	StackDBReporting.php 
Log Message:
DB query tweak to return only versions which are latest in line.

Index: StackDBReporting.php
===================================================================
RCS file: /cvsroot/stack/stack-dev/lib/database/StackDBReporting.php,v
retrieving revision 1.31
retrieving revision 1.32
diff -C2 -d -r1.31 -r1.32
*** StackDBReporting.php	29 Nov 2010 15:40:05 -0000	1.31
--- StackDBReporting.php	1 Dec 2010 12:09:57 -0000	1.32
***************
*** 51,59 ****
  		$sql = 'SELECT questionID, questionName, questionDescription
  		        FROM   stackquestion, question_lines
! 				WHERE  line = question_lines.id';
  
  		if (isset($ids)) $sql .= " AND questionID IN ($ids)";
  
! 		$sql .= ' GROUP BY line';
  
  		$this->connect();
--- 51,59 ----
  		$sql = 'SELECT questionID, questionName, questionDescription
  		        FROM   stackquestion, question_lines
! 				WHERE questionID = latestVersion';
  
  		if (isset($ids)) $sql .= " AND questionID IN ($ids)";
  
! 		//$sql .= ' GROUP BY line';
  
  		$this->connect();