Tadashi Okoshi
slash****@users*****
2005年 12月 10日 (土) 04:46:09 JST
Index: affelio/lib/Affelio/SNS/FriendManager.pm
diff -u affelio/lib/Affelio/SNS/FriendManager.pm:1.11 affelio/lib/Affelio/SNS/FriendManager.pm:1.12
--- affelio/lib/Affelio/SNS/FriendManager.pm:1.11 Tue Nov 1 13:03:57 2005
+++ affelio/lib/Affelio/SNS/FriendManager.pm Sat Dec 10 04:46: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: FriendManager.pm,v 1.11 2005/11/01 04:03:57 slash5234 Exp $
+# $Id: FriendManager.pm,v 1.12 2005/12/09 19:46:09 slash5234 Exp $
package Affelio::SNS::FriendManager;
{
@@ -57,7 +57,7 @@
##############################
#retrieve all friend records from DB
- my $query = 'SELECT count(*) FROM AFuser_CORE_friends';
+ my $query = 'SELECT count(*) FROM AFuser_CORE_friends'; #
my $sth;
eval{
$sth = $af->getDB->prepare($query);
@@ -80,7 +80,7 @@
##############################
#retrieve all friend records from DB
- my $query = 'SELECT count(*) FROM AFuser_CORE_friendsfriends';
+ my $query = 'SELECT count(*) FROM AFuser_CORE_friendsfriends'; #
my $sth;
eval{
$sth = $af->getDB->prepare($query);
@@ -121,7 +121,7 @@
#If so, we DO NOT ignore him.
#We have to update his information.
#
- $query = "SELECT * FROM AFuser_CORE_friends WHERE af_id = '$af_id'";
+ $query = "SELECT uid FROM AFuser_CORE_friends WHERE af_id = '$af_id'";
eval{
$sth = $af->getDB->prepare($query);
$sth->execute();
@@ -355,7 +355,7 @@
Affelio::misc::Debug::debug_print("FM::save_F2list: F1's F2list = [$f1_f2list]");
#The guy with F2_AF_ID is in the Friend table?
- $query = "SELECT * FROM AFuser_CORE_friends WHERE af_id = '$f2_af_id'";
+ $query = "SELECT uid, f2list FROM AFuser_CORE_friends WHERE af_id = '$f2_af_id'";
eval{
$sth = $af->getDB->prepare($query);
$sth->execute();
@@ -377,7 +377,7 @@
my $sth2="";
$f2_uid = $row_in_f1table[0];
- $f2_f1list = $row_in_f1table[8];
+ $f2_f1list = $row_in_f1table[1];
Affelio::misc::Debug::debug_print("FM::save_F2list: F2's F1list = [$f2_f1list]");
#Modify "Friend" table
@@ -588,7 +588,7 @@
##############################
#retrieve all friend records from DB
- my $query = "SELECT * FROM AFuser_CORE_friends order by $sort $order";
+ my $query = "SELECT uid, af_id, nickname, timestamp, password, intro, option_pid, lastupdated, f2list, last_news_in, last_news_out FROM AFuser_CORE_friends order by $sort $order";
my $sth;
eval{
$sth = $af->getDB->prepare($query);
@@ -616,7 +616,7 @@
##############################
#retrieve a friend record from DB
- my $query = "SELECT * FROM AFuser_CORE_friends WHERE uid = $uid";
+ my $query = "SELECT uid, af_id, nickname, timestamp, password, intro, option_pid, lastupdated, f2list, last_news_in, last_news_out FROM AFuser_CORE_friends WHERE uid = $uid";
my $sth;
eval{
$sth = $af->getDB->prepare($query);
@@ -645,7 +645,7 @@
##############################
#retrieve a friend record from DB
- my $query = "SELECT * FROM AFuser_CORE_friends WHERE af_id = '$af_id'";
+ my $query = "SELECT uid, af_id, nickname, timestamp, password, intro, option_pid, lastupdated, f2list, last_news_in, last_news_out FROM AFuser_CORE_friends WHERE WHERE af_id = '$af_id'";
my $sth;
eval{
$sth = $af->getDB->prepare($query);