Tadashi Okoshi
slash****@users*****
2005年 12月 10日 (土) 08:56:10 JST
Index: affelio/lib/Affelio/Managing/NewsAggregator.pm
diff -u affelio/lib/Affelio/Managing/NewsAggregator.pm:1.3 affelio/lib/Affelio/Managing/NewsAggregator.pm:1.4
--- affelio/lib/Affelio/Managing/NewsAggregator.pm:1.3 Sat Dec 10 08:07:38 2005
+++ affelio/lib/Affelio/Managing/NewsAggregator.pm Sat Dec 10 08:56:09 2005
@@ -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.3 2005/12/09 23:07:38 slash5234 Exp $
+# $Id: NewsAggregator.pm,v 1.4 2005/12/09 23:56:09 slash5234 Exp $
package Affelio::Managing::NewsAggregator;
{
@@ -62,7 +62,7 @@
##############################
#Insert a new record
- my $sth = "insert into AFuser_CORE_nghr_news(datetime, af_id, nickname, app_install_name, title, description, creator, URL) values ('$arg{datetime}', '$arg{af_id}', '$arg{nickname}', '$arg{app_install_name}', '$arg{title}', '$arg{description}', '$arg{creator}', '$arg{URL}')";
+ my $sth = "insert into AFuser_CORE_nghr_news(datetime, af_id, nickname, app_install_name, title, description, creator, URL) values ('$arg{datetime}', '$arg{af_id}', '$arg{nickname}', '$arg{app}', '$arg{title}', '$arg{desc}', '$arg{creator}', '$arg{URL}')";
eval{
$sth = $af->getDB->prepare($sth);
$sth->execute;
@@ -71,28 +71,6 @@
throw Affelio::exception::DBException($af->getDB->errstr);
}
undef($sth);
-
-
-
-
-# this->post_news(datetime => $datetime,
-# af_id => $af_id,
-# nickname => $nickname,
-# app => $app_install_name,
-# title => $title,
-# desc => $desc,
-# creator => $creator,
-# URL => $URL);
-
-# CREATE TABLE AFuser_CORE_nghr_news(nid INTEGER PRIMARY KEY AUTOINCREMENT,
-# datetime INTEGER,
-# af_id TEXT,
- # nickname TEXT,
-# app_install_name TEXT,
-# title TEXT,
-# description TEXT,
-# creator TEXT,
-# URL TEXT);
}
@@ -107,7 +85,7 @@
#########################################################
#Get a friend whose last_news_in is smallet (oldest).
- my $threshold = Affelio::misc::Time::get_timestamp();# - 1000; #-10m
+ my $threshold = Affelio::misc::Time::get_timestamp(); - 1000; #-10m
my $result = $af->getFM->get_all_friend_list(where => "last_news_in < $threshold",
sort => "last_news_in",
order => "desc");