•         

            

            

            

  • 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
Yönetici
KoCuce.Com
Katılım
7 Mart 2012
Mesajlar
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ü



Kod: 
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ü



Kod: 
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



Kod: 
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



Kod: 
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ü



Kod: 
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



Kod: 
	;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;

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

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



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​
 

Online istatistikleri

Çevrimiçi kullanıcılar
436
Çevrimiçi ziyaretçiler
2,532
Toplam ziyaretçi
2,968
Toplamlar, gizli ziyaretçiler içerebilir.

Ko-Cuce Links

En yeni üyeler

KoCuce Sosyal

Geri
Üst