[Astrospaces-commits] SF.net SVN: astrospaces: [94] trunk/functions/user.php

[<del...@us...>]

Revision: 94
          http://astrospaces.svn.sourceforge.net/astrospaces/?rev=94&view=rev
Author:   deltalabs
Date:     2007-08-05 22:12:05 -0700 (Sun, 05 Aug 2007)

Log Message:
-----------
Finished friends

Modified Paths:
--------------
    trunk/functions/user.php

Modified: trunk/functions/user.php
===================================================================
--- trunk/functions/user.php	2007-08-05 04:25:02 UTC (rev 93)
+++ trunk/functions/user.php	2007-08-06 05:12:05 UTC (rev 94)
@@ -353,13 +353,33 @@
 		{
 			$_query = 'DELETE FROM ' . AS_TBL_FRIEND . ' WHERE user2_id = ' . $user_id . ' AND user1_id = ' . $user->data['user_id'];
 			if ($db->Execute($_query) === false)
-			{				
+			{
 				$error->general('<b>DB Error!</b>', 'user.php - remove_friend(): '.$db->ErrorMsg());
 				return false;
 			}			
 		}
 		return true;
 	}
+	/*
+	Function Name: list_friends
+	Purpose: get a list of friends of the user
+	*/
+	function list_friends()
+	{
+		$_query = 'SELECT user1_id FROM ' . AS_TBL_FRIENDS . ' WHERE user2_id = ' . $user->data['user_id'] . ' AND accepted = 1';
+		if (($listpart1 = $db->fetch_array($_query)) === false)
+		{
+			$error->general('<b>DB Error!</b>', 'user.php - list_friends(): '.$db->ErrorMsg());
+			return false;
+		}
+		$_query = 'SELECT user2_id FROM ' . AS_TBL_FRIENDS . ' WHERE user1_id = ' . $user->data['user_id'] . ' AND accepted = 1';
+		if (($listpart2 = $db->fetch_array($_query)) === false)
+		{
+			$error->general('<b>DB Error!</b>', 'user.php - list_friends(): '.$db->ErrorMsg());
+			return false;
+		}
+		return array_merge($listpart1, $listpart2);
+	}
     /*
 	Function Name: add_coment
 	Arguments: (int) id -- ID of user who comment is directed to


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.