owncloud / core

	 * This function fetches all groups a user belongs to. It does not check

	 * if the user exists at all.

	 */

	public function getUserGroups( $uid ) {

		// No magic!

		$stmt = OC_DB::prepare( "SELECT `gid` FROM `*PREFIX*group_user` WHERE `uid` = ?" );

		$result = $stmt->execute( array( $uid ));

		$groups = array();

		while( $row = $result->fetchRow()) {

			$groups[] = $row["gid"];

		}

		return $groups;

	}

	/**

	 * get a list of all groups

	 * @param string $uid uid of the SubAdmin

	 * @return array

	 */

	public static function getSubAdminsGroups($uid) {

		$stmt = OC_DB::prepare('SELECT `gid` FROM `*PREFIX*group_admin` WHERE `uid` = ?');

		$result = $stmt->execute(array($uid));

		$gids = array();

		while($row = $result->fetchRow()) {

			$gids[] = $row['gid'];

		}

		return $gids;

	}

	/**

	 * get SubAdmins of a group

	 * @param string $gid gid of the group

	 * @return array

	 */

	public static function getGroupsSubAdmins($gid) {

		$stmt = OC_DB::prepare('SELECT `uid` FROM `*PREFIX*group_admin` WHERE `gid` = ?');

		$result = $stmt->execute(array($gid));

		$uids = array();

		while($row = $result->fetchRow()) {

			$uids[] = $row['uid'];

		}

		return $uids;

	}

	/**

	 * get all SubAdmins

	 * get all SubAdmins

	 * @return array

	 */

	public static function getAllSubAdmins() {

		$stmt = OC_DB::prepare('SELECT * FROM `*PREFIX*group_admin`');

		$result = $stmt->execute();

		$subadmins = array();

		while($row = $result->fetchRow()) {

			$subadmins[] = $row;

		}

		return $subadmins;

	}

	/**

	 * checks if a user is a SubAdmin of a group