From: <ny...@us...> - 2009-11-19 16:30:45
|
Revision: 23374 http://tikiwiki.svn.sourceforge.net/tikiwiki/?rev=23374&view=rev Author: nyloth Date: 2009-11-19 16:30:32 +0000 (Thu, 19 Nov 2009) Log Message: ----------- [FIX] newsletters: fix lastSent column in the list of newsletters (which was always returning the current time) Modified Paths: -------------- trunk/lib/newsletters/nllib.php Modified: trunk/lib/newsletters/nllib.php =================================================================== --- trunk/lib/newsletters/nllib.php 2009-11-19 15:15:54 UTC (rev 23373) +++ trunk/lib/newsletters/nllib.php 2009-11-19 16:30:32 UTC (rev 23374) @@ -484,16 +484,17 @@ $bindvars = array(); if ($find) { $findesc = '%' . $find . '%'; - $mid = " where (`name` like ? or `description` like ?)"; + $mid = " where (tn.`name` like ? or tn.`description` like ?)"; $bindvars[] = $findesc; $bindvars[] = $findesc; } else { $mid = " "; } - $query = "select * from `tiki_newsletters` $mid order by ".$this->convertSortMode("$sort_mode"); + $mid2 = ( empty( $mid ) ? ' WHERE ' : $mid . ' AND ' ) . ' tn.`nlId` = tsn.`nlId`'; + $query = "select tn.*, max(tsn.`sent`) as lastSent from `tiki_newsletters` as tn, `tiki_sent_newsletters` as tsn $mid2 group by tn.`nlId` order by ".$this->convert_sortmode("$sort_mode"); $result = $this->query($query,$bindvars,$maxRecords,$offset); - $query_cant = "select count(*) from `tiki_newsletters` $mid"; + $query_cant = "select count(*) from `tiki_newsletters` as tn $mid"; $cant = $this->getOne($query_cant,$bindvars); $ret = array(); This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |