Tadashi Okoshi
slash****@users*****
2006年 6月 6日 (火) 12:01:20 JST
Index: affelio/lib/Affelio/Managing/NewsAggregator.pm
diff -u affelio/lib/Affelio/Managing/NewsAggregator.pm:1.25 affelio/lib/Affelio/Managing/NewsAggregator.pm:1.26
--- affelio/lib/Affelio/Managing/NewsAggregator.pm:1.25 Tue Jun 6 11:22:14 2006
+++ affelio/lib/Affelio/Managing/NewsAggregator.pm Tue Jun 6 12:01:20 2006
@@ -14,7 +14,7 @@
# along with this program; if not, write to the Free Software
# Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA.
#
-# $Id: NewsAggregator.pm,v 1.25 2006/06/06 02:22:14 slash5234 Exp $
+# $Id: NewsAggregator.pm,v 1.26 2006/06/06 03:01:20 slash5234 Exp $
package Affelio::Managing::NewsAggregator;
{
@@ -120,14 +120,14 @@
##############################
#retrieve all friend records from DB
- my $query = "SELECT datetime, af_id, nickname, app_install_name, title, description, creator, URL FROM $af->{site__dbtbl_prefix}_CORE_nghr_news order by";
+ my $query = "SELECT datetime, af_id, nickname, app_install_name, title, description, creator, URL FROM $af->{site__dbtbl_prefix}_CORE_nghr_news WHERE af_type= '$type' order by";
if ($sort eq "user"){
$query .= " nickname, app_install_name,";
}elsif($sort eq "subject"){
$query .= " title,";
}
$query.= " datetime desc limit $num , 10";
- $query.= " WHERE af_type= '$type' ";
+
my $sth;
eval{
$sth = $af->getDB->prepare($query);