Castle Siege Setup

[sphynxs2k4]

Re: [Guide] Castle Siege Setup

why i ant enter treone room but iom hold the seal and castle
i need answer plzzzz

 

[rokosius]

Re: [Guide] Castle Siege Setup

Hello ,
i want to ask how i can establish minimum guild member that can be register to Castle Siege.

plz help very plz

 

[LoveGod]

Re: [Guide] Castle Siege Setup

great guide

 

[rokosius]

Re: [Guide] Castle Siege Setup

MuOnline/StoredProcedure/
WZ_CS_RegRegAttackGuild

IF (@iGuildMasterLevel < 200)
BEGIN
SELECT 5 As QueryResult	
END
ELSE
BEGIN
IF (@iGuildMemberCount < 20)

200-lvl
20-count of memb.

thx but have problem:

My wz_cs_regregattactguild

SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS OFF 
GO












--//************************************************************************
--// << ? ??? - ?? ???? >>
--// 
--// ??	: ?? ? (????) ? ???? ??? ??? ??? ??.
--// ??	: ???? 1? 
--// ???	: 2004.11.22
--// ???	: ???
--// 
--//************************************************************************

ALTER    PROCEDURE	WZ_CS_ReqRegAttackGuild
	@iMapSvrGroup		SMALLINT,	-- ??? ??
	@szGuildName		VARCHAR(8)	-- ????? ? ????
As
Begin
	BEGIN TRANSACTION
	
	SET NOCOUNT ON

	DECLARE	@iMaxRegGuildCount	INT					-- ??? ?? ??? ? ?? ?? ?
	DECLARE	@iCurRegGuildCount	INT					-- ?? ??? ??? ?? ?
	SET 		@iMaxRegGuildCount	= 100

	SELECT @iCurRegGuildCount = COUNT(*) FROM MuCastle_REG_SIEGE  WITH (READUNCOMMITTED)  WHERE MAP_SVR_GROUP = @iMapSvrGroup
	IF (@iCurRegGuildCount >= @iMaxRegGuildCount)
	BEGIN
			SELECT 6 As QueryResult					-- ??? ??? ?? N?? ???
	END
	ELSE
	BEGIN
		IF EXISTS ( SELECT MAP_SVR_GROUP FROM MuCastle_REG_SIEGE  WITH (READUNCOMMITTED) 
					WHERE MAP_SVR_GROUP = @iMapSvrGroup and REG_SIEGE_GUILD = @szGuildName)
		BEGIN
			SELECT 2 As QueryResult					-- ?? ???? ??
		END
		ELSE
		BEGIN
			DECLARE @szOwnGuildName		VARCHAR(8)
			SELECT @szOwnGuildName = OWNER_GUILD FROM MuCastle_DATA WHERE MAP_SVR_GROUP = @iMapSvrGroup
	
			-- ?? ??? ??? ??? ??
			IF (@szOwnGuildName = @szGuildName)
			BEGIN
				SELECT 3 As QueryResult				-- ??? ???
			END
			ELSE
			BEGIN
				IF NOT EXISTS ( SELECT G_Name FROM Guild  WITH (READUNCOMMITTED) WHERE G_Name = @szGuildName)
				BEGIN
					SELECT 4 As QueryResult			-- ????? ???? ??
				END
				ELSE
				BEGIN
					DECLARE @szGuildMaster			VARCHAR(10)
					DECLARE @iGuildMasterLevel			INT
					DECLARE @iGuildMemberCount			INT
					
					SELECT @szGuildMaster = G_Master FROM Guild WHERE G_Name = @szGuildName
					SELECT @iGuildMasterLevel = cLevel FROM Character WHERE Name = @szGuildMaster
					SELECT @iGuildMemberCount = COUNT(*) FROM GuildMember WHERE G_Name = @szGuildName
					
					IF (@iGuildMasterLevel < 200)
					BEGIN
						SELECT 5 As QueryResult		-- ?????? ??? ??
					END
					ELSE
					BEGIN
						IF (@iGuildMemberCount < 1)
						BEGIN
							SELECT 8 As QueryResult	-- ??? ?? ??
						END
						ELSE
						BEGIN
							DECLARE @iMAX_SEQNUM	INT	-- ?? ?? ????
							DECLARE @iNXT_SEQNUM	INT	-- ?? ????
							SELECT @iMAX_SEQNUM = MAX(SEQ_NUM) FROM MuCastle_REG_SIEGE  WITH (READUNCOMMITTED)  WHERE MAP_SVR_GROUP = @iMapSvrGroup
							
							IF (@iMAX_SEQNUM IS NULL)
								SET @iNXT_SEQNUM	= 1
							ELSE
								SET @iNXT_SEQNUM	= @iMAX_SEQNUM + 1

							INSERT INTO MuCastle_REG_SIEGE 
							VALUES (@iMapSvrGroup, @szGuildName, 0, 0, @iNXT_SEQNUM)
					
							SELECT 1 As QueryResult	-- ?? ??
						END
					END
				END
			END
		END
	END

	
	IF(@@Error <> 0 )
		ROLLBACK TRANSACTION
	ELSE	
		COMMIT TRANSACTION

	SET NOCOUNT OFF	
End


GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

whare its problem change 1 count ?

 

[rokosius]

Re: [Guide] Castle Siege Setup

no want man help me ? ;/

 

[sodazt]

Re: [Guide] Castle Siege Setup

Nothing to setup at GS_CS folder ??

but

setup at normal data folder .... is correct ?

 

[pd69]

Re: [Guide] Castle Siege Setup

how can i change how long the CS will be 3 hours ite too long i want to set it in 1 hour how can i do that?

open MuCastleData.txt in your data folder, and if your using any of the luciano files you'll see this:

//=========================================================================
// Setting of castle periods.. 
// Period ID	Day	Hour	Minute 
//=========================================================================
// ID Per

 

[noobies]

Re: [Guide] Castle Siege Setup

Thanks for posting this guide

 

[SharaK]

Re: [Guide] Castle Siege Setup

thx but have problem:

My wz_cs_regregattactguild

SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS OFF 
GO












--//************************************************************************
--// << ? ??? - ?? ???? >>
--// 
--// ??    : ?? ? (????) ? ???? ??? ??? ??? ??.
--// ??    : ???? 1? 
--// ???    : 2004.11.22
--// ???    : ???
--// 
--//************************************************************************

ALTER    PROCEDURE    WZ_CS_ReqRegAttackGuild
    @iMapSvrGroup        SMALLINT,    -- ??? ??
    @szGuildName        VARCHAR(8)    -- ????? ? ????
As
Begin
    BEGIN TRANSACTION
    
    SET NOCOUNT ON

    DECLARE    @iMaxRegGuildCount    INT                    -- ??? ?? ??? ? ?? ?? ?
    DECLARE    @iCurRegGuildCount    INT                    -- ?? ??? ??? ?? ?
    SET         @iMaxRegGuildCount    = 100

    SELECT @iCurRegGuildCount = COUNT(*) FROM MuCastle_REG_SIEGE  WITH (READUNCOMMITTED)  WHERE MAP_SVR_GROUP = @iMapSvrGroup
    IF (@iCurRegGuildCount >= @iMaxRegGuildCount)
    BEGIN
            SELECT 6 As QueryResult                    -- ??? ??? ?? N?? ???
    END
    ELSE
    BEGIN
        IF EXISTS ( SELECT MAP_SVR_GROUP FROM MuCastle_REG_SIEGE  WITH (READUNCOMMITTED) 
                    WHERE MAP_SVR_GROUP = @iMapSvrGroup and REG_SIEGE_GUILD = @szGuildName)
        BEGIN
            SELECT 2 As QueryResult                    -- ?? ???? ??
        END
        ELSE
        BEGIN
            DECLARE @szOwnGuildName        VARCHAR(8)
            SELECT @szOwnGuildName = OWNER_GUILD FROM MuCastle_DATA WHERE MAP_SVR_GROUP = @iMapSvrGroup
    
            -- ?? ??? ??? ??? ??
            IF (@szOwnGuildName = @szGuildName)
            BEGIN
                SELECT 3 As QueryResult                -- ??? ???
            END
            ELSE
            BEGIN
                IF NOT EXISTS ( SELECT G_Name FROM Guild  WITH (READUNCOMMITTED) WHERE G_Name = @szGuildName)
                BEGIN
                    SELECT 4 As QueryResult            -- ????? ???? ??
                END
                ELSE
                BEGIN
                    DECLARE @szGuildMaster            VARCHAR(10)
                    DECLARE @iGuildMasterLevel            INT
                    DECLARE @iGuildMemberCount            INT
                    
                    SELECT @szGuildMaster = G_Master FROM Guild WHERE G_Name = @szGuildName
                    SELECT @iGuildMasterLevel = cLevel FROM Character WHERE Name = @szGuildMaster
                    SELECT @iGuildMemberCount = COUNT(*) FROM GuildMember WHERE G_Name = @szGuildName
                    
                    IF (@iGuildMasterLevel < [COLOR=Red]200[/COLOR]) -- [COLOR=Red]Guild Master lvl[/COLOR]
                    BEGIN
                        SELECT 5 As QueryResult        -- ?????? ??? ??
                    END
                    ELSE
                    BEGIN
                        IF (@iGuildMemberCount < [COLOR=Red]1[/COLOR]) [COLOR=Red]-- Guild Member Count[/COLOR]
                        BEGIN
                            SELECT 8 As QueryResult    -- ??? ?? ??
                        END
                        ELSE
                        BEGIN
                            DECLARE @iMAX_SEQNUM    INT    -- ?? ?? ????
                            DECLARE @iNXT_SEQNUM    INT    -- ?? ????
                            SELECT @iMAX_SEQNUM = MAX(SEQ_NUM) FROM MuCastle_REG_SIEGE  WITH (READUNCOMMITTED)  WHERE MAP_SVR_GROUP = @iMapSvrGroup
                            
                            IF (@iMAX_SEQNUM IS NULL)
                                SET @iNXT_SEQNUM    = 1
                            ELSE
                                SET @iNXT_SEQNUM    = @iMAX_SEQNUM + 1

                            INSERT INTO MuCastle_REG_SIEGE 
                            VALUES (@iMapSvrGroup, @szGuildName, 0, 0, @iNXT_SEQNUM)
                    
                            SELECT 1 As QueryResult    -- ?? ??
                        END
                    END
                END
            END
        END
    END

    
    IF(@@Error <> 0 )
        ROLLBACK TRANSACTION
    ELSE    
        COMMIT TRANSACTION

    SET NOCOUNT OFF    
End


GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

whare its problem change 1 count ?

alredy set to 1 :juggle::juggle::juggle:

 

[juanmanuelsaad]

Re: [Guide] Castle Siege Setup

one question...i have luciano aibar server files, i've to edit date of siege from SQL or from MuCastleData?

 

[[RCZ]ShadowKing]

Re: [Guide] Castle Siege Setup

from sql but i setup the castle siege event and i can`t register :| why... i use luciano beta39 and when a press register its say This guild is not registered at Castle Siege,how to setup cs in this version?

 

[Macbeth]

Re: [Guide] Castle Siege Setup

Thanks alot!

 

[MuIsBest]

Re: [Guide] Castle Siege Setup

W0rks! Great Guide !

 

[aas5]

Re: [Guide] Castle Siege Setup

how write for sql i am not successful

 

[cooly]

Re: [Guide] Castle Siege Setup

Thanks man ! It works ! :biggrinth

 

[bfdatos]

Re: [Guide] Castle Siege Setup

hey i need your help i have my server server version 1.02N but wen I enter the server end entered my user and passworld he discoonected me why plz help me... my skype : bfdatos

 

[btxas]

Re: [Guide] Castle Siege Setup

Peapole help me plz ... I cant tolk to guard. what i nead to do ???

You must be registered to see links

I nead tolk to guard.

 

[btxas]

Re: [Guide] Castle Siege Setup

please help to me...

 

[kho_vi_yeu]

Re: [Guide] Castle Siege Setup

Please post code guardsman and please guide castle siege 1.04x. thanks so much

 

[GrInYa]

Re: [Guide] Castle Siege Setup

edit.....