public function convertInviteEmails($email, $user_id)
	{
		// @FIXME: Should wrap this up in a nice transaction to handle partial failures and
		// race conditions.

		if (empty($email) || empty($user_id))
		{
			return false;
		}

		$db = \App::get('db');

		$sql = 'SELECT gidNumber FROM `#__xgroups_inviteemails` WHERE email=' . $db->quote($email) . ';';

		$db->setQuery($sql);

		$result = $db->loadColumn();

		if ($result === false)
		{
			return false;
		}

		if (empty($result))
		{
			return true;
		}

		foreach ($result as $r)
		{
			$values .= "($r,$user_id),";
			$gids   .= "$r,";
		}

		$values = rtrim($values, ',');
		$gids = rtrim($gids, ',');

		$sql = 'INSERT INTO `#__xgroups_invitees` (gidNumber,uidNumber) VALUES ' . $values . ';';

		$db->setQuery($sql);

		$result = $db->query();

		if (!$result)
		{
			return false;
		}

		$sql = 'DELETE FROM `#__xgroups_inviteemails` WHERE email=' . $db->quote($email) . ' AND gidNumber IN (' . $gids . ');';

		$db->setQuery($sql);

		$result = $db->query();

		if (!$result)
		{
			return false;
		}

		return true;
	}
public function convertInviteEmails($email, $user_id)
	{
		// @FIXME: Should wrap this up in a nice transaction to handle partial failures and
		// race conditions.

		if (empty($email) || empty($user_id))
		{
			return false;
		}

		$db = \App::get('db');

		$sql = 'SELECT gidNumber FROM `#__xgroups_inviteemails` WHERE email=' . $db->quote($email) . ';';

		$db->setQuery($sql);

		$result = $db->loadColumn();

		if ($result === false)
		{
			return false;
		}

		if (empty($result))
		{
			return true;
		}

		foreach ($result as $r)
		{
			$values .= "($r,$user_id),";
			$gids   .= "$r,";
		}

		$values = rtrim($values, ',');
		$gids = rtrim($gids, ',');

		$sql = 'INSERT INTO `#__xgroups_invitees` (gidNumber,uidNumber) VALUES ' . $values . ';';

		$db->setQuery($sql);

		$result = $db->query();

		if (!$result)
		{
			return false;
		}

		$sql = 'DELETE FROM `#__xgroups_inviteemails` WHERE email=' . $db->quote($email) . ' AND gidNumber IN (' . $gids . ');';

		$db->setQuery($sql);

		$result = $db->query();

		if (!$result)
		{
			return false;
		}

		return true;
	}
public function convertInviteEmails ( $ email , $ user_id ) { // @FIXME: Should wrap this up in a nice transaction to handle partial failures and // race conditions. if ( empty ( $ email ) || empty ( $ user_id ) ) { return false ; } $ db = \ App :: get ( 'db' ) ; $ sql = 'SELECT gidNumber FROM `#__xgroups_inviteemails` WHERE email=' . $ db -> quote ( $ email ) . ';' ; $ db -> setQuery ( $ sql ) ; $ result = $ db -> loadColumn ( ) ; if ( $ result === false ) { return false ; } if ( empty ( $ result ) ) { return true ; } foreach ( $ result as $ r ) { $ values .= "($r,$user_id)," ; $ gids .= "$r," ; } $ values = rtrim ( $ values , ',' ) ; $ gids = rtrim ( $ gids , ',' ) ; $ sql = 'INSERT INTO `#__xgroups_invitees` (gidNumber,uidNumber) VALUES ' . $ values . ';' ; $ db -> setQuery ( $ sql ) ; $ result = $ db -> query ( ) ; if ( ! $ result ) { return false ; } $ sql = 'DELETE FROM `#__xgroups_inviteemails` WHERE email=' . $ db -> quote ( $ email ) . ' AND gidNumber IN (' . $ gids . ');' ; $ db -> setQuery ( $ sql ) ; $ result = $ db -> query ( ) ; if ( ! $ result ) { return false ; } return true ; }
Converts invite emails to true group

@param   string   $email
@param   integer  $user_id
@return  void
Converts invite emails to true group