owncloud / core

	 *

	 * Returns a list with all groups

	 */

	public function getGroups($search = '', $limit = null, $offset = null) {

		$parameters = [];

		$searchLike = '';

		if ($search !== '') {

			$parameters[] = '%' . $search . '%';

			$searchLike = ' WHERE LOWER(`gid`) LIKE LOWER(?)';

		}

		$stmt = OC_DB::prepare('SELECT `gid` FROM `*PREFIX*groups`' . $searchLike . ' ORDER BY `gid` ASC', $limit, $offset);

		$result = $stmt->execute($parameters);

		$groups = array();

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

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

		}

		return $groups;

	}

	/**

	 * check if a group exists

	 * @param int $offset

	 * @return array an array of user ids

	 */

	public function usersInGroup($gid, $search = '', $limit = null, $offset = null) {

		$parameters = [$gid];

		$searchLike = '';

		if ($search !== '') {

			$parameters[] = '%' . $this->escapeLikeParameter($search) . '%';

			$searchLike = ' AND `uid` LIKE ?';

		}

		$stmt = OC_DB::prepare('SELECT `uid` FROM `*PREFIX*group_user` WHERE `gid` = ?' . $searchLike . ' ORDER BY `uid` ASC',

			$limit,

			$offset);

		$result = $stmt->execute($parameters);

		$users = array();

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

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

		}

		return $users;

	}

	/**

	 * get the number of all users matching the search string in a group

	 * @param null|int $offset

	 * @return string[] an array of all uids

	 */

	public function getUsers($search = '', $limit = null, $offset = null) {

		$parameters = [];

		$searchLike = '';

		if ($search !== '') {

			$parameters[] = '%' . $search . '%';

			$searchLike = ' WHERE LOWER(`uid`) LIKE LOWER(?)';

		}

		$query = OC_DB::prepare('SELECT `uid` FROM `*PREFIX*users`' . $searchLike . ' ORDER BY `uid` ASC', $limit, $offset);

		$result = $query->execute($parameters);

		$users = array();

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

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

		}

		return $users;

	}

	/**

	 * check if a user exists