[Astrospaces-commits] SF.net SVN: astrospaces: [92] trunk

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

Revision: 92
          http://astrospaces.svn.sourceforge.net/astrospaces/?rev=92&view=rev
Author:   deltalabs
Date:     2007-08-04 20:43:57 -0700 (Sat, 04 Aug 2007)

Log Message:
-----------
Finished groups and added a description field to the group table.

Modified Paths:
--------------
    trunk/develop/new-schema.sql
    trunk/functions/user.php

Modified: trunk/develop/new-schema.sql
===================================================================
--- trunk/develop/new-schema.sql	2007-08-04 00:18:45 UTC (rev 91)
+++ trunk/develop/new-schema.sql	2007-08-05 03:43:57 UTC (rev 92)
@@ -60,6 +60,7 @@
 CREATE TABLE  `as_groups` (
   `group_id` int(10) unsigned NOT NULL auto_increment,
   `name` varchar(45) NOT NULL,
+  `desc` text NOT NULL,
   `founder` int(11) unsigned NOT NULL,
   `create_timestamp` int(10) unsigned NOT NULL,
   PRIMARY KEY  (`group_id`)

Modified: trunk/functions/user.php
===================================================================
--- trunk/functions/user.php	2007-08-04 00:18:45 UTC (rev 91)
+++ trunk/functions/user.php	2007-08-05 03:43:57 UTC (rev 92)
@@ -448,25 +448,192 @@
     }
     /*
 	Function Name: is_in_group
-	Arguments: (int) user_id --  id of user, (int) grp_id -- id of group
+	Arguments: (int) grp_id -- id of group
 	Purpose: check to see whether or not user is part of a particular group
 	*/
-	function is_in_group ($user_id, $grp_id)
+	function is_in_group ($grp_id)
 	{
-		if (!is_numeric($user_id) and $user_id != null)
+		if (!is_numeric($grp_id) and $grp_id != null)
 		{
-            $error->general('Invalid userID', "Invalid userID = Possible hack! Input value: \"".$id."\" User Hostname: ".$_SERVER['REMOTE_ADDR']);
+            $error->general('Invalid groupID', "Invalid groupID = Possible hack! Input value: \"".$id."\" User Hostname: ".$_SERVER['REMOTE_ADDR']);
             return false;
 		}
-		else if (!is_numeric($grp_id) and $grp_id != null)
+		
+		$_query = 'SELECT pair_id FROM '.AS_TBL_GRPRES.' WHERE user_id = ' . $user->data['user_id'] . ' AND group_id = ' . $grp_id;
+    	$res = $db->GetArray($db->Execute($_query));
+    	if (count($res) > 0)
 		{
+			return true;
+		}
+		return false;
+	}
+    /*
+	Function Name: join_group
+	Arguments: (int) grp_id -- id of group
+	Purpose: join a group
+	*/
+	function join_group ($grp_id)
+	{
+		if (!is_numeric($grp_id) and $grp_id != null)
+		{
             $error->general('Invalid groupID', "Invalid groupID = Possible hack! Input value: \"".$id."\" User Hostname: ".$_SERVER['REMOTE_ADDR']);
             return false;
 		}
+	
+		$_query = 'INSERT INTO ' . AS_TBL_GRPRES . ' (user_id, group_id, join_date) VALUES ('
+			. $user->data['user_id'] . ', ' . $grp_id . ', ' . ', ' . time(). ')';
+		if ($db->Execute($_query) === false)
+		{
+			$error->general('Problem joining group', 'Unknown problem joining group: ' . $db->ErrorMsg());
+            return false;
+		}
+	}
+    /*
+	Function Name: leave_group
+	Arguments: (int) grp_id -- id of group
+	Purpose: leave a group
+	*/
+	function leave_group ($grp_id)
+	{
+		if (!is_numeric($grp_id) and $grp_id != null)
+		{
+            $error->general('Invalid groupID', "Invalid groupID = Possible hack! Input value: \"".$id."\" User Hostname: ".$_SERVER['REMOTE_ADDR']);
+            return false;
+		}
+	
+		$_query = 'DELETE FROM ' . AS_TBL_GRPRES . ' WHERE user_id = '
+			. $user->data['user_id'] . ' AND group_id = ' . $grp_id;
+		if ($db->Execute($_query) === false)
+		{
+			$error->general('Problem leaving group', 'Unknown problem leaving group: ' . $db->ErrorMsg());
+            return false;
+		}
+	}
+    /*
+	Function Name: kick_from_group
+	Arguments: (int) grp_id -- id of group, (int) user_id -- id of user to kick
+	Purpose: forcefully remove a user from your group
+	*/
+	function kick_from_group ($grp_id, $user_id)
+	{		
+		$_query = 'SELECT founder FROM ' . AS_TBL_GRP . ' WHERE founder = ' . $user->data['user_id'];
+		$_query = $db->Execute($_query);
+    	$res = $db->GetArray($_query);
+    	$founder_id = $res[0]['founder'];
 		
-		/* Work in progress... */
+		if ($user->data['user_id'] == $founder_id)
+		{
+			if (!is_numeric($grp_id) and $grp_id != null)
+			{
+				$error->general('Invalid groupID', "Invalid groupID = Possible hack! Input value: \"".$id."\" User Hostname: ".$_SERVER['REMOTE_ADDR']);
+				return false;
+			}
+			else if (!is_numeric($user_id) and $user_id != null)
+			{
+				$error->general('Invalid userID', "Invalid userID = Possible hack! Input value: \"".$id."\" User Hostname: ".$_SERVER['REMOTE_ADDR']);
+				return false;
+			}
+			
+			$_query = 'DELETE FROM ' . AS_TBL_GRPRES . ' WHERE group_id = ' . $grp_id . ' AND user_id = ' . $user_id;
+			if ($db->Execute($_query) === false)
+			{
+				$error->general('Failed to kick user', 'Unknown problem removing user from group: ' . $db->ErrorMsg());
+				return false;
+			}
+			return true;
+		}
 	}
     /*
+	Function Name: create_group
+	Arguments: (string) name -- name of group, (string) desc -- description of the group
+	Purpose: create a group
+	*/
+	function create_group ($name, $desc)
+	{
+		if (!is_numeric($grp_id) and $grp_id != null)
+		{
+            $error->general('Invalid groupID', "Invalid groupID = Possible hack! Input value: \"".$id."\" User Hostname: ".$_SERVER['REMOTE_ADDR']);
+            return false;
+		}
+	
+		$_query = 'INSERT INTO ' . AS_TBL_GRPS . ' (name, desc, founder, create_timestamp) VALUES '
+			. '(' . $db->qstr($name) . ', ' . $db->qstr($desc) . ', ' . $user->data['user_id'] . ', ' . time() . ')';
+		if ($db->Execute($_query) === false)
+		{
+			$error->general('Problem creating group', 'Unknown problem creating group: ' . $db->ErrorMsg());
+            return false;
+		}
+		return true;
+	}
+    /*
+	Function Name: edit_group
+	Arguments: (int) grp_id, id of the group to edit, (string) new_name -- new name of group, (string) desc -- new description of the group
+	Purpose: modify a group
+	*/
+	function edit_group ($grp_id, $new_name, $new_desc)
+	{
+		$_query = 'SELECT founder FROM ' . AS_TBL_GRP . ' WHERE founder = ' . $user->data['user_id'];
+		$_query = $db->Execute($_query);
+    	$res = $db->GetArray($_query);
+    	$founder_id = $res[0]['founder'];
+		
+		if ($user->data['user_id'] == $founder_id)
+		{
+			if (!is_numeric($grp_id) and $grp_id != null)
+			{
+				$error->general('Invalid groupID', "Invalid groupID = Possible hack! Input value: \"".$id."\" User Hostname: ".$_SERVER['REMOTE_ADDR']);
+				return false;
+			}
+		
+			$_query = 'UPDATE ' . AS_TBL_GRPS . ' SET name = ' . $db->qstr($new_name) . ', desc = ' . $db->qstr($new_desc)
+				. ' WHERE group_id = ' . $grp_id;
+			if ($db->Execute($_query) === false)
+			{
+				$error->general('Problem editing group', 'Unknown problem editing group: ' . $db->ErrorMsg());
+				return false;
+			}
+			return true;
+		}
+		else
+		{
+			$error->general('Problem editing group', "You don't have permission to edit this group!");
+			return false;
+		}
+	}
+    /*
+	Function Name: delete_group
+	Arguments: (int) grp_id
+	Purpose: remove an existing group
+	*/
+	function delete_group ($grp_id)
+	{
+		$_query = 'SELECT founder FROM ' . AS_TBL_GRP . ' WHERE founder = ' . $user->data['user_id'];
+		$_query = $db->Execute($_query);
+    	$res = $db->GetArray($_query);
+    	$founder_id = $res[0]['founder'];
+		if ($user->data['user_id'] == $founder_id)
+		{
+			if (!is_numeric($grp_id) and $grp_id != null)
+			{
+				$error->general('Invalid groupID', "Invalid groupID = Possible hack! Input value: \"".$id."\" User Hostname: ".$_SERVER['REMOTE_ADDR']);
+				return false;
+			}
+		
+			$_query = 'DELETE FROM ' . AS_TBL_GRPS . ' WHERE group_id = ' . $grp_id;
+			if ($db->Execute($_query) === false)
+			{
+				$error->general('Problem deleting group', 'Unknown problem deleting group: ' . $db->ErrorMsg());
+				return false;
+			}
+			return true;
+		}
+		else
+		{
+			$error->general('Problem deleting group', "You don't have permission to delete this group!");
+			return false;
+		}
+	}
+    /*
 	Function Name: generate_timestamp
 	Arguments: (int) time --  time to parse
 	Purpose: Generate datestamp of time passed, taking user's time offset into consideration


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