[Astrospaces-commits] SF.net SVN: astrospaces: [94] trunk/functions/user.php
Brought to you by:
p3net
|
From: <del...@us...> - 2007-08-06 05:12:07
|
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.
|