• HyperFilter | DoS Protection | DDoS Protection | DoS Mitigation | DDoS Mitigation | AntiDoS | AntiDDoS | Proxy Shielding

DELOS [CSW] Sorunlu Buglu İse Cözüm İçerde!

bigahega

bigahega

Administrator
Staff member
KoCuce.Com
Joined
Mar 7, 2012
Messages
12,842
Prosedürleri bi güncelleyelim. Prosedürlerde hata olabilir. Presdürleri qa dan güncelle girerken hata verirse CREATE yerine ALTER yazın.



Update_siege prosedürü.



View hidden content is available for registered users!



UPDATE_SIEGE_CHALLENGER Prosedürü



View hidden content is available for registered users!



UPDATE_SIEGE_CHALLENGER2 Prosedürü



Code: 
CREATE PROCEDURE UPDATE_SIEGE_CHALLENGER2

@sCastleIndex		smallint,

@sKnights_1		smallint,

@sKnights_2		smallint,

@sKnights_3		smallint,

@sKnights_4		smallint,

@sKnights_5		smallint,

@sKnights_6		smallint,

@sKnights_7		smallint,

@sKnights_8		smallint,

@sKnights_9		smallint,

@sKnights_10		smallint,

@strChallengerList	varchar(50)



AS





UPDATE KNIGHTS_SIEGE_WARFARE SET strChallengeList = @strChallengerList,

					       sRequestList_1 = @sKnights_1,  

					       sRequestList_2 = @sKnights_2,

					       sRequestList_3 = @sKnights_3,

					       sRequestList_4 = @sKnights_4,

					       sRequestList_5 = @sKnights_5,

					       sRequestList_6 = @sKnights_6,

					       sRequestList_7 = @sKnights_7,

					       sRequestList_8 = @sKnights_8,

					       sRequestList_9 = @sKnights_9,

					       sRequestList_10 = @sKnights_10

	 WHERE sCastleIndex = @sCastleIndex





GO



UPDATE_SIEGE_DECIDE_CHALLENGER prosedürü



Code: 
CREATE PROCEDURE UPDATE_SIEGE_DECIDE_CHALLENGER

@sCastleIndex		smallint,

@sKnights_1		smallint,

@sKnights_2		smallint,

@sKnights_3		smallint,

@sKnights_4		smallint,

@sKnights_5		smallint,

@sKnights_6		smallint,

@sKnights_7		smallint,

@sKnights_8		smallint,

@sKnights_9		smallint,

@sKnights_10		smallint



AS





UPDATE KNIGHTS_SIEGE_WARFARE SET sChallengeList_1 = @sKnights_1,  

					       sChallengeList_2 = @sKnights_2,

					       sChallengeList_3 = @sKnights_3,

					       sChallengeList_4 = @sKnights_4,

					       sChallengeList_5 = @sKnights_5,

					       sChallengeList_6 = @sKnights_6,

					       sChallengeList_7 = @sKnights_7,

					       sChallengeList_8 = @sKnights_8,

					       sChallengeList_9 = @sKnights_9,

					       sChallengeList_10 = @sKnights_10,

					       sRequestList_1 = 0,  

					       sRequestList_2 = 0,

					       sRequestList_3 = 0,

					       sRequestList_4 = 0,

					       sRequestList_5 = 0,

					       sRequestList_6 = 0,

					       sRequestList_7 = 0,

					       sRequestList_8 = 0,

					       sRequestList_9 = 0,

					       sRequestList_10 = 0,

					       strChallengeList = NULL	

	 WHERE sCastleIndex = @sCastleIndex





GO



Knights_Siege_Warfare TABLOSU



Code: 
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[KNIGHTS_SIEGE_WARFARE]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)

drop table [dbo].[KNIGHTS_SIEGE_WARFARE]

GO



CREATE TABLE [dbo].[KNIGHTS_SIEGE_WARFARE] (

	[sCastleIndex] [smallint] NOT NULL ,

	[sMasterKnights] [smallint] NOT NULL ,

	[bySiegeType] [tinyint] NOT NULL ,

	[byWarDay] [tinyint] NOT NULL ,

	[byWarTime] [tinyint] NOT NULL ,

	[byWarMinute] [tinyint] NOT NULL ,

	[sChallengeList_1] [smallint] NOT NULL ,

	[sChallengeList_2] [smallint] NOT NULL ,

	[sChallengeList_3] [smallint] NOT NULL ,

	[sChallengeList_4] [smallint] NOT NULL ,

	[sChallengeList_5] [smallint] NOT NULL ,

	[sChallengeList_6] [smallint] NOT NULL ,

	[sChallengeList_7] [smallint] NOT NULL ,

	[sChallengeList_8] [smallint] NOT NULL ,

	[sChallengeList_9] [smallint] NOT NULL ,

	[sChallengeList_10] [smallint] NOT NULL ,

	[byWarRequestDay] [tinyint] NOT NULL ,

	[byWarRequestTime] [tinyint] NOT NULL ,

	[byWarRequestMinute] [tinyint] NOT NULL ,

	[byGuerrillaWarDay] [tinyint] NOT NULL ,

	[byGuerrillaWarTime] [tinyint] NOT NULL ,

	[byGuerrillaWarMinute] [tinyint] NOT NULL ,

	[strChallengeList] [char] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

	[sMoradonTariff] [smallint] NOT NULL ,

	[sDellosTariff] [smallint] NOT NULL ,

	[nDungeonCharge] [int] NOT NULL ,

	[nMoradonTax] [int] NOT NULL ,

	[nDellosTax] [int] NOT NULL ,

	[sRequestList_1] [smallint] NOT NULL ,

	[sRequestList_2] [smallint] NOT NULL ,

	[sRequestList_3] [smallint] NOT NULL ,

	[sRequestList_4] [smallint] NOT NULL ,

	[sRequestList_5] [smallint] NOT NULL ,

	[sRequestList_6] [smallint] NOT NULL ,

	[sRequestList_7] [smallint] NOT NULL ,

	[sRequestList_8] [smallint] NOT NULL ,

	[sRequestList_9] [smallint] NOT NULL ,

	[sRequestList_10] [smallint] NOT NULL 

) ON [PRIMARY]

GO



Tabloyu girdikten sonra bunu gir



Code: 
INSERT INTO [knights_siege_warfare] VALUES ('1','15003','5','3','5','54','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','NULL','20','20','0','0','0','0','0','0','0','0','0','0','0','0','0');



Update_knights_war prosedürü



Code: 
ALTER PROCEDURE [dbo].[UPDATE_KNIGHTS_WAR]

@byType		tinyint,

@shWhite		smallint,

@shBlue		smallint



AS

/*CPU*/

DECLARE @strWhiteName char(21)

DECLARE @strBlueName char(21)



SET @strWhiteName = NULL

SET @strBlueName = NULL



IF @byType = 1

BEGIN

	SELECT @strWhiteName = IDName FROM KNIGHTS WHERE IDNum = @shWhite

	SELECT @strBlueName = IDName FROM KNIGHTS WHERE IDNum = @shBlue

	UPDATE KNIGHTS SET nWarEnemyID = @shBlue, strEnemyName = @strBlueName WHERE IDNum = @shWhite

	UPDATE KNIGHTS SET nWarEnemyID = @shWhite, strEnemyName = @strWhiteName WHERE IDNum = @shBlue

END

ELSE IF @byType = 2

BEGIN

	UPDATE KNIGHTS SET byOldWarResult = 2, nLose = nLose+1, nWarEnemyID = 0 WHERE IDNum = @shWhite	-- lose team

	UPDATE KNIGHTS SET byOldWarResult = 1, nVictory = nVictory+1, nWarEnemyID = 0 WHERE IDNum = @shBlue	-- victory team

END



Orjinal 30.evt



Code: 
	;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;

	;;°ø¼º¹«±â À̺¥Æ®ÀÇ ½ÃÀÛ;;;;;;;;;;;;;;;;;;;;;

	;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;



EVENT 1;°ø¼º¹«±â ¼³¸í½ÃÀÛ

E SELECT_MSG 16087 35733 35583 12 35584 13 35585 14 35586 15 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1;´ëÀåÂ÷/Åõ¼®±â/»ç´Ù¸®Â÷/ÃşÂ÷

END



EVENT 12; ´ëÀåÂ÷

E SAY 10 11 35735 35736 35737 -1 -1 -1 -1 -1 -1 -1

END



EVENT 13; Åõ¼®±â

E SAY 10 11 35738 35739 35740 -1 -1 -1 -1 -1 -1 -1

END



EVENT 14; »ç´Ù¸®Â÷

E SAY 10 11 35741  35742  35743  -1 -1 -1 -1 -1 -1 -1

END



EVENT 15; ÃæÂ÷

E SAY 10 11 35744 35745 -1 -1 -1 -1 -1 -1 -1 -1

END



EVENT 10;°ø¼º¹«±â À̺¥Æ® ½ÃÀÛ

E SELECT_MSG 16087 35728 35579 2 35580 3 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1;±³È¯/±×³É °¡°Ú½À´Ï´Ù.

END



EVENT 2; ±³È¯

E RUN_EVENT 4

E RUN_EVENT 5

END



EVENT 3; ±×³É °¡°Ú½À´Ï´Ù.

E RETURN

END



EVENT 4

A HOWMUCH_ITEM 379157000 0 0;°ø¼º¹«±â »óÇ°±ÇÀÌ ¾øÀ» ¶§

E SAY -1 -1 35732 -1 -1 -1 -1 -1 -1 -1 -1 -1

E RETURN

END



EVENT 5

A HOWMUCH_ITEM 379157000 1 9999; °ø¼º¹«±â »óÇ°±Ç ÀÖÀ» ¶§

E RUN_EVENT 6;´ÜÀåÀ϶§

E RUN_EVENT 7;´ÜÀåÀÌ ¾Æ´Ò¶§

END



EVENT 6;´ÜÀåÀ϶§

A CHECK_CHIEF -1

E RUN_EVENT 8

END



EVENT 7;´ÜÀåÀÌ ¾Æ´Ò¶§

A CHECK_NO_CHIEF -1

E RUN_EVENT 9

END



EVENT 8;´ÜÀå ¾ÆÀÌÅÛ Áö±Ş

E ROB_ITEM 379157000 1 ;°ø¼º¹«±â »óÇ°±Ç

E GIVE_ITEM 389154000 1 ;´ëÀåÂ÷

E RETURN

END





EVENT 9;ÃæÂ÷, »ç´Ù¸®Â÷, Åõ¼®±â 

E RUN_EXCHANGE 125

END



	;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;

	;;°ø¼º¹«±â À̺¥Æ®ÀÇ ³¡;;;;;;;;;;;;;;;;;;;;;

	;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;



NOT : ALINTIDIR

Zagor ( Mehmet Ali Yavuzer ) Teşekkürler Kendisi Paylaşmişti Güncel kalmasi açisindan paylaştim​
 
Cevap: DELOS [CSW] Sorunlu Buglu İse Cözüm İçerde!



saolll
 

Online statistics

Members online
435
Guests online
2,926
Total visitors
3,361
Totals may include hidden visitors.

OnlineHile Links

Newest members

OnlineHile Sosyal

Back
Top