Tadashi Okoshi
slash****@users*****
2006年 6月 13日 (火) 14:20:25 JST
Index: affelio/lib/Affelio/SNS/FriendManager.pm
diff -u affelio/lib/Affelio/SNS/FriendManager.pm:1.25 affelio/lib/Affelio/SNS/FriendManager.pm:1.26
--- affelio/lib/Affelio/SNS/FriendManager.pm:1.25 Tue Jun 6 11:02:33 2006
+++ affelio/lib/Affelio/SNS/FriendManager.pm Tue Jun 13 14:20:25 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: FriendManager.pm,v 1.25 2006/06/06 02:02:33 slash5234 Exp $
+# $Id: FriendManager.pm,v 1.26 2006/06/13 05:20:25 slash5234 Exp $
package Affelio::SNS::FriendManager;
{
@@ -54,10 +54,19 @@
sub get_F1_count{
my $self = shift;
my $af = $self->{af};
+ my %param = @_;
+ my $type=$param{type};
+ my $WHERE_BLOOCK="";
+
+ if($type ne ""){
+ $WHERE_BLOOCK = " WHERE af_type = '$type' ";
+ }else{
+ $WHERE_BLOOCK = "WHERE af_type = 'Personal' or af_type = 'Standalone' ";
+ }
##############################
#retrieve all friend records from DB
- my $query = "SELECT count(*) FROM $af->{site__dbtbl_prefix}_CORE_friends"; #
+ my $query = "SELECT count(*) FROM $af->{site__dbtbl_prefix}_CORE_friends $WHERE_BLOOCK";
my $sth;
eval{
$sth = $af->getDB->prepare($query);