DB'nize Sorunsuz Chaos Stone Ekleyin.

APLaceFormyHeaD · Jul 7, 2013

[HIDE-POSTS=50]Verdiğim kodlar ACME & SOACS içindir dengesiz dengesiz yorumlar atmayın diğer filesler için verecek varsa konuya eklesin kelime yapmasın !

You must reply in the thread to view hidden text.

Code:

DELETE FROM K_NPC WHERE sSid = 24000

DELETE FROM K_NPC WHERE sSid = 24002

DELETE FROM K_NPC WHERE sSid = 24003

INSERT INTO K_NPC (sSid, strName, sPid, sSize, iWeapon1, iWeapon2, byGroup, byActType, byType, byFamily, byRank, byTitle, iSellingGroup, sLevel, iExp, iLoyalty,iHpPoint, sMpPoint, sAtk, sAc, sHitRate, sEvadeRate, sDamage, sAttackDelay, bySpeed1, bySpeed2, sStandtime, iMagic1, iMagic2, iMagic3, sFireR, sColdR, sLightningR, sMagicR, sDiseaseR, sPoisonR, sLightR, sBulk, byAttackRange, bySearchRange, byTracingRange, iMoney, sItem, byDirectAttack, byMagicAttack, byMoneyType) VALUES (24000,'Ronark Land Base Monument',14005,120,0,0,3,0,156,1,1,1,0,80,0,0,250000,0,0,2500,124,124,0,1000,0,0,1000,0,0,0,250,250,250,250,250,250,250,100,5,5,5,32000,32578,0,0,0)

INSERT INTO K_NPC (sSid, strName, sPid, sSize, iWeapon1, iWeapon2, byGroup, byActType, byType, byFamily, byRank, byTitle, iSellingGroup, sLevel, iExp, iLoyalty,iHpPoint, sMpPoint, sAtk, sAc, sHitRate, sEvadeRate, sDamage, sAttackDelay, bySpeed1, bySpeed2, sStandtime, iMagic1, iMagic2, iMagic3, sFireR, sColdR, sLightningR, sMagicR, sDiseaseR, sPoisonR, sLightR, sBulk, byAttackRange, bySearchRange, byTracingRange, iMoney, sItem, byDirectAttack, byMagicAttack, byMoneyType) VALUES (24002,'Colony Zone Monument',14005,120,0,0,3,0,156,1,1,1,0,80,0,0,500000,0,0,5000,124,124,0,1000,0,0,1000,0,0,0,250,250,250,250,250,250,250,100,5,5,5,32000,32578,0,0,0)

INSERT INTO K_NPC (sSid, strName, sPid, sSize, iWeapon1, iWeapon2, byGroup, byActType, byType, byFamily, byRank, byTitle, iSellingGroup, sLevel, iExp, iLoyalty,iHpPoint, sMpPoint, sAtk, sAc, sHitRate, sEvadeRate, sDamage, sAttackDelay, bySpeed1, bySpeed2, sStandtime, iMagic1, iMagic2, iMagic3, sFireR, sColdR, sLightningR, sMagicR, sDiseaseR, sPoisonR, sLightR, sBulk, byAttackRange, bySearchRange, byTracingRange, iMoney, sItem, byDirectAttack, byMagicAttack, byMoneyType) VALUES (24003,'Ardream Monument',14005,120,0,0,3,0,156,1,1,1,0,80,0,0,100000,0,0,1000,124,124,0,1000,0,0,1000,0,0,0,250,250,250,250,250,250,250,100,5,5,5,32000,32578,0,0,0)





DELETE FROM K_NPCPOS WHERE NpcID = 24000

DELETE FROM K_NPCPOS WHERE NpcID = 24002

DELETE FROM K_NPCPOS WHERE NpcID = 24003

INSERT INTO K_NPCPOS (ZoneID, NpcID, ActType, RegenType, DungeonFamily, SpecialType, TrapNumber, LeftX, TopZ, RightX, BottomZ, LimitMinZ, LimitMinX, LimitMaxX,LimitMaxZ, NumNPC, RegTime, byDirection, DotCnt, path) VALUES (201,24002,137,0,0,0,0,1014,1012,1014,1012,1014,1012,1014,1012,1,900,0,0,NULL)

INSERT INTO K_NPCPOS (ZoneID, NpcID, ActType, RegenType, DungeonFamily, SpecialType, TrapNumber, LeftX, TopZ, RightX, BottomZ, LimitMinZ, LimitMinX, LimitMaxX,LimitMaxZ, NumNPC, RegTime, byDirection, DotCnt, path) VALUES (202,24003,137,0,0,0,0,525,526,525,526,525,526,525,526,1,900,0,0,NULL)

INSERT INTO K_NPCPOS (ZoneID, NpcID, ActType, RegenType, DungeonFamily, SpecialType, TrapNumber, LeftX, TopZ, RightX, BottomZ, LimitMinZ, LimitMinX, LimitMaxX,LimitMaxZ, NumNPC, RegTime, byDirection, DotCnt, path) VALUES (203,24000,137,0,0,0,0,509,509,509,509,509,509,509,509,1,900,0,0,NULL)



DROP TABLE PREMIUM_SERVICE

CREATE TABLE [dbo].[PREMIUM_SERVICE](

	[strAccountID] [varchar](27) NOT NULL,

	[strType] [smallint] NOT NULL,

	[nDays] [smallint] NOT NULL,

	[PremStart] [smalldatetime] NOT NULL

) ON [PRIMARY]



GO



SET ANSI_PADDING ON

GO



ALTER TABLE [dbo].[PREMIUM_SERVICE] ADD  CONSTRAINT [DF_PREMIUM_SERVICE_PremStart]  DEFAULT (getdate()) FOR [PremStart]

GO





---Chaos Stone---

delete from k_npc where ssid = 24001

delete from k_npcpos where npcid = 24001

delete from k_monster where ssid >= 1987 and ssid <= 2000

insert into [K_NPC] values ('24001','Chaos Stone','14001','120','0','0','3','0','156','1','1','1','0','80','0','0','250000','0','0','2500','124','124','0','1000','0','0','1000','0','0','0','250','250','250','250','250','250','250','100','5','5','5','32000','32578','0','0','0');

insert into [K_NPCPOS] values ('201','24001','137','0','0','0','0','1016','1057','1016','1057','1016','1057','1016','1057','1','28800','0','0','NULL');

insert into [K_MONSTER] values ('1987','[Javana]','1300','120','130450180','0','0','6','0','6','0','0','0','90','1','0','92344','15727','0','1296','299','745','3788','1200','2','8','5000','1315','0','0','0','500','500','500','500','500','500','500','300','5','10','60','32000','0','0','0');

insert into [K_MONSTER] values ('1988','[Samma]','1300','500','130450180','0','0','5','0','13','0','0','0','90','1406250','0','104370','15727','0','1296','299','745','4149','2000','2','8','5000','1315','0','0','0','500','500','500','500','500','500','500','300','5','10','60','32000','0','0','0');

insert into [K_MONSTER] values ('1989','[Barrkk]','600','160','0','0','0','6','0','6','0','0','0','55','1406250','0','29155','4864','0','792','96','239','998','1200','5','8','5000','607','0','0','0','500','500','500','500','500','500','500','165','5','10','60','32000','0','0','0');

insert into [K_MONSTER] values ('1990','[Duke]','1200','120','0','0','0','6','0','12','0','0','0','55','1406250','0','29155','4864','0','594','96','239','832','1000','2','8','5000','1215','300111','0','0','500','500','500','500','500','500','500','150','25','15','60','32000','1','2','0');

insert into [K_MONSTER] values ('1991','[Bishop]','1200','120','0','0','0','6','0','12','0','0','0','60','1406250','0','36300','5938','0','648','117','290','1045','1000','2','8','5000','1206','300112','0','0','500','500','500','500','500','500','500','175','25','15','60','32000','1','2','0');

insert into [K_MONSTER] values ('1992','[Bach]','1200','120','0','0','0','6','0','12','0','0','0','65','1406250','0','44520','7155','0','702','140','347','1291','1000','2','8','5000','1207','300113','0','0','500','500','500','500','500','500','500','200','25','15','60','32000','1','2','0');

insert into [K_MONSTER] values ('1993','[Lobo]','506','180','190250000','0','0','5','0','5','0','0','0','45','1406250','0','17790','3115','0','972','63','155','483','1000','5','7','5000','506','0','0','0','500','500','500','500','500','500','500','175','5','5','60','32000','0','0','0');

insert into [K_MONSTER] values ('1994','[Lupus]','506','180','140450000','0','0','5','0','5','0','0','0','50','1406250','0','23010','3927','0','1080','78','194','650','1000','5','7','7000','507','0','0','0','500','500','500','500','500','500','500','175','5','5','60','32000','0','0','0');

insert into [K_MONSTER] values ('1995','[Lycaon]','506','180','140650000','0','0','5','0','5','0','0','0','55','1406250','0','29155','4864','0','1188','96','239','832','1000','5','7','10000','508','0','0','0','500','500','500','500','500','500','500','200','5','5','60','32000','0','0','0');

insert into [K_MONSTER] values ('1996','[Attila]','1400','100','0','0','0','5','3','14','0','0','0','85','1406250','0','89650','13651','1','1224','261','649','2129','2000','2','9','5000','1400','300104','300105','0','500','500','500','500','500','500','500','300','30','10','60','32000','2','5','0');

insert into [K_MONSTER] values ('1997','[Barkirra]','600','130','0','0','0','6','0','6','0','0','0','60','1406250','0','36300','5938','0','864','117','290','1254','1200','5','8','5000','608','0','0','0','500','500','500','500','500','500','500','165','5','10','60','1320','0','0','0');

insert into [K_MONSTER] values ('1998','[Acer]','1400','80','0','0','0','1','3','14','0','0','0','85','1406250','100','89650','13651','0','1224','261','649','2129','2000','2','9','5000','1401','300104','300105','0','500','500','500','500','500','500','500','200','30','10','45','32000','2','5','0');

insert into [K_MONSTER] values ('1999','[Shaula]','907','500','0','0','0','5','0','9','0','0','0','75','1406250','0','64485','10060','0','1080','194','483','1263','1000','2','9','10000','914','300101','0','0','500','500','500','500','500','500','500','100','5','10','60','32000','0','2','0');

insert into [K_MONSTER] values ('2000','[Lesath]','907','500','0','0','0','5','0','9','0','0','0','75','1406250','0','64485','10060','0','1080','194','483','1263','1000','2','9','10000','908','300101','0','0','500','500','500','500','500','500','500','100','5','10','60','32000','0','2','0');

[/HIDE-POSTS]

DarkParadisE · Jul 7, 2013

Cevap: DB'nize Sorunsuz Chaos Stone Ekleyin.

Version Farkı Varmı ?

ByHeLL · Jul 7, 2013

Cevap: DB'nize Sorunsuz Chaos Stone Ekleyin.

tesekkürler dostumm demniyoruz..

HiFi · Jul 7, 2013

Cevap: DB'nize Sorunsuz Chaos Stone Ekleyin.

Standart DB'nize Sorunsuz Chaos Stone Ekleyin.

nostalgia · Jul 7, 2013

adamsın sagol

ByHeLL · Jul 7, 2013

Cevap: DB'nize Sorunsuz Chaos Stone Ekleyin.

Dostum stoneyi kesince bossları atmıyor sorun var..

hakan2199 · Jul 7, 2013

Cevap: DB'nize Sorunsuz Chaos Stone Ekleyin.

teşekkürler

Jayden JameS · Jul 7, 2013

Cevap: DB'nize Sorunsuz Chaos Stone Ekleyin.

version farkı varmı ?

Mr.Hoca · Jul 7, 2013

Cevap: DB'nize Sorunsuz Chaos Stone Ekleyin.

tesekkürler

Kanuniko · Jul 8, 2013

Cevap: DB'nize Sorunsuz Chaos Stone Ekleyin.

tesekkurler

Papix123 · Jul 8, 2013

Cevap: DB'nize Sorunsuz Chaos Stone Ekleyin.

eywww

KeremErden · Jul 8, 2013

Cevap: DB'nize Sorunsuz Chaos Stone Ekleyin.

bayadır arıyodum

Optimum · Jul 8, 2013

Cevap: DB'nize Sorunsuz Chaos Stone Ekleyin.

teşekkürler

mykol349 · Jul 8, 2013

Cevap: DB'nize Sorunsuz Chaos Stone Ekleyin.

işte bu be

cєηgℓу · Jul 9, 2013

Cevap: DB'nize Sorunsuz Chaos Stone Ekleyin.

Eyw

Red01 · Jul 9, 2013

Cevap: DB'nize Sorunsuz Chaos Stone Ekleyin.

Tesekkurler

MithriLVI · Jul 9, 2013

Cevap: DB'nize Sorunsuz Chaos Stone Ekleyin.

teşekkürler

BaLTaZaR · Jul 9, 2013

Cevap: DB'nize Sorunsuz Chaos Stone Ekleyin.

eyw reis

33alihanreis33 · Jul 9, 2013

3333333333333333333333333333333333

codename · Jul 9, 2013

deneyelim

DB'nize Sorunsuz Chaos Stone Ekleyin.

APLaceFormyHeaD

Hızlı Cüce

DarkParadisE

Hızlı Cüce

ByHeLL

Hiperaktif Cüce

HiFi

Hızlı Cüce

nostalgia

Cool Cüce

ByHeLL

Hiperaktif Cüce

hakan2199

Jayden JameS

Karizma Cüce

Mr.Hoca

Cool Cüce

Kanuniko

Yeni Cüce

Papix123

KeremErden

Optimum

Karizma Cüce

mykol349

Hızlı Cüce

cєηgℓу

Cool Cüce

Red01

Hiperaktif Cüce

MithriLVI

Cool Cüce

BaLTaZaR

Hiperaktif Cüce

33alihanreis33

Kayıtlı Üye

codename

Karizma Cüce