clan open with 2 players.

[zavi156]

Hello everyone!
I want to serve my clan can be opened two players or more.
But when I send a friend request opening the Clan, it does nothing.
I followed this guide: http://forum.ragezone.com/f497/creat...source-914451/
And I have no error.

[MentaL]

[ghostrevan]

im not the expert in this, but did you build the matchserver & cscommon aswell.

if you diddent build the matchserver yet or cscommon build those 2 aswell.

after building matchserver copy the matchserver.exe you build to your server and try it with that.

[zavi156]

im not the expert in this, but did you build the matchserver & cscommon aswell.

if you diddent build the matchserver yet or cscommon build those 2 aswell.

after building matchserver copy the matchserver.exe you build to your server and try it with that.

I built everything.
Does not work. ...
please help me !

[Tical]

I built everything.
Does not work. ...
please help me !

did you edit the database?
if not, then i have edited the script so it will create a clan with 2 players.
Programmability > Stored Procedures > dbo.spCreateClan

USE [GunzDB]
GO
/****** Object:  StoredProcedure [dbo].[spCreateClan]    Script Date: 06/18/2014 21:09:04 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- Ŭ·£ »ý¼ºÇϱâ
ALTER PROC [dbo].[spCreateClan]
 @clanName		varchar(24),
 @MasterCID		int,
 @Member1CID		int,

AS
	DECLARE @NewCLID	int

	-- Ŭ·£À̸§ÀÌ Áߺ¹ÀÎÁö °Ë»çÇؾßÇÑ´Ù.
	SELECT @NewCLID=CLID FROM Clan(NOLOCK) WHERE Name @clanName

	IF @NewCLID IS NOT NULL
	BEGIN
		SELECT 0 AS Ret, 0 AS NewCLID
		RETURN
	END


	DECLARE @CNT		int

	-- Ŭ·£¿øÀÌ ¸ðµÎ °¡ÀÔ °¡´ÉÇÑÁö °Ë»çÇؾßÇÑ´Ù.
	SELECT @CNT = COUNT(*) FROM ClanMember cm(NOLOCK), Character c(NOLOCK) WHERE ((cm.CID @MasterCID) OR (cm.CID @Member1CID)) AND cm.CID=c.CID AND c.DeleteFlag=0

	IF @CNT != 0
	BEGIN
		SELECT 0 AS Ret, 0 AS NewCLID
		RETURN
	END


	BEGIN TRAN
	-- Ŭ·£ »ý¼º
	INSERT INTO Clan (Name, MasterCID, RegDate) VALUES  @clanName, @MasterCID, GETDATE())
	IF 0 <> @@ERROR BEGIN
		ROLLBACK TRAN
		SELECT 0 AS Ret, 0 AS NewCLID
		RETURN
	END

	SELECT @NewCLID = @@IDENTITY
	IF  @NewCLID IS not NULL)
	BEGIN
		DECLARE @Err1 int
		DECLARE @Err2 int
		

		-- Ŭ·£¿ø °¡ÀÔ
		INSERT INTO ClanMember (CLID, CID, Grade, RegDate) VALUES  @NewCLID, @MasterCID, 1, GETDATE())
		SET @Err1 = @@ERROR		
		INSERT INTO ClanMember (CLID, CID, Grade, RegDate) VALUES  @NewCLID, @Member1CID, 9, GETDATE())
		SET @Err2 = @@ERROR
		

		IF (0 <> @Err1) OR (0 <> @Err2) BEGIN
			ROLLBACK TRAN
			SELECT 0 AS Ret, 0 AS NewCLID
			RETURN
		END
	END
	COMMIT TRAN

	-- ¸¶½ºÅÍ ¹Ù¿îƼ »èÁ¦
	--UPDATE Character SET BP=BP-1000 WHERE CID @MasterCID


	SELECT 1 AS Ret, @NewCLID AS NewCLID

[zavi156]

did you edit the database?
if not, then i have edited the script so it will create a clan with 2 players.
Programmability > Stored Procedures > dbo.spCreateClan

USE [GunzDB]
GO
/****** Object:  StoredProcedure [dbo].[spCreateClan]    Script Date: 06/18/2014 21:09:04 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- Ŭ·£ »ý¼ºÇϱâ
ALTER PROC [dbo].[spCreateClan]
 @clanName		varchar(24),
 @MasterCID		int,
 @Member1CID		int,

AS
	DECLARE @NewCLID	int

	-- Ŭ·£À̸§ÀÌ Áߺ¹ÀÎÁö °Ë»çÇؾßÇÑ´Ù.
	SELECT @NewCLID=CLID FROM Clan(NOLOCK) WHERE Name @clanName

	IF @NewCLID IS NOT NULL
	BEGIN
		SELECT 0 AS Ret, 0 AS NewCLID
		RETURN
	END


	DECLARE @CNT		int

	-- Ŭ·£¿øÀÌ ¸ðµÎ °¡ÀÔ °¡´ÉÇÑÁö °Ë»çÇؾßÇÑ´Ù.
	SELECT @CNT = COUNT(*) FROM ClanMember cm(NOLOCK), Character c(NOLOCK) WHERE ((cm.CID @MasterCID) OR (cm.CID @Member1CID)) AND cm.CID=c.CID AND c.DeleteFlag=0

	IF @CNT != 0
	BEGIN
		SELECT 0 AS Ret, 0 AS NewCLID
		RETURN
	END


	BEGIN TRAN
	-- Ŭ·£ »ý¼º
	INSERT INTO Clan (Name, MasterCID, RegDate) VALUES  @clanName, @MasterCID, GETDATE())
	IF 0 <> @@ERROR BEGIN
		ROLLBACK TRAN
		SELECT 0 AS Ret, 0 AS NewCLID
		RETURN
	END

	SELECT @NewCLID = @@IDENTITY
	IF  @NewCLID IS not NULL)
	BEGIN
		DECLARE @Err1 int
		DECLARE @Err2 int
		

		-- Ŭ·£¿ø °¡ÀÔ
		INSERT INTO ClanMember (CLID, CID, Grade, RegDate) VALUES  @NewCLID, @MasterCID, 1, GETDATE())
		SET @Err1 = @@ERROR		
		INSERT INTO ClanMember (CLID, CID, Grade, RegDate) VALUES  @NewCLID, @Member1CID, 9, GETDATE())
		SET @Err2 = @@ERROR
		

		IF (0 <> @Err1) OR (0 <> @Err2) BEGIN
			ROLLBACK TRAN
			SELECT 0 AS Ret, 0 AS NewCLID
			RETURN
		END
	END
	COMMIT TRAN

	-- ¸¶½ºÅÍ ¹Ù¿îƼ »èÁ¦
	--UPDATE Character SET BP=BP-1000 WHERE CID @MasterCID


	SELECT 1 AS Ret, @NewCLID AS NewCLID

Yes, I edited.
What the problem?

[Tical]

Yes, I edited.
What the problem?

did you copy and paste the one i just gave you and then test it? because when i followed that tutorial there was an error in the script

[zavi156]

did you copy and paste the one i just gave you and then test it? because when i followed that tutorial there was an error in the script

yes dude.

[mgdmgd]

then u forget to do something because it works fine..

[zavi156]

then u forget to do something because it works fine..

I did everything right times.