DB'nize Sorunsuz Chaos Stone Ekleyin.

APLaceFormyHeaD · 7 Temmuz 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 !

Kod:

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 · 7 Temmuz 2013

Cevap: DB'nize Sorunsuz Chaos Stone Ekleyin.

Version Farkı Varmı ?

ByHeLL · 7 Temmuz 2013

Cevap: DB'nize Sorunsuz Chaos Stone Ekleyin.

tesekkürler dostumm demniyoruz..

HiFi · 7 Temmuz 2013

Cevap: DB'nize Sorunsuz Chaos Stone Ekleyin.

Standart DB'nize Sorunsuz Chaos Stone Ekleyin.

nostalgia · 7 Temmuz 2013

adamsın sagol

ByHeLL · 7 Temmuz 2013

Cevap: DB'nize Sorunsuz Chaos Stone Ekleyin.

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

hakan2199 · 7 Temmuz 2013

Cevap: DB'nize Sorunsuz Chaos Stone Ekleyin.

teşekkürler

Jayden JameS · 7 Temmuz 2013

Cevap: DB'nize Sorunsuz Chaos Stone Ekleyin.

version farkı varmı ?

Mr.Hoca · 7 Temmuz 2013

Cevap: DB'nize Sorunsuz Chaos Stone Ekleyin.

tesekkürler

Kanuniko · 8 Temmuz 2013

Cevap: DB'nize Sorunsuz Chaos Stone Ekleyin.

tesekkurler

Papix123 · 8 Temmuz 2013

Cevap: DB'nize Sorunsuz Chaos Stone Ekleyin.

eywww

KeremErden · 8 Temmuz 2013

Cevap: DB'nize Sorunsuz Chaos Stone Ekleyin.

bayadır arıyodum

Optimum · 8 Temmuz 2013

Cevap: DB'nize Sorunsuz Chaos Stone Ekleyin.

teşekkürler

mykol349 · 8 Temmuz 2013

Cevap: DB'nize Sorunsuz Chaos Stone Ekleyin.

işte bu be

cєηgℓу · 9 Temmuz 2013

Cevap: DB'nize Sorunsuz Chaos Stone Ekleyin.

Eyw

Red01 · 9 Temmuz 2013

Cevap: DB'nize Sorunsuz Chaos Stone Ekleyin.

Tesekkurler

MithriLVI · 9 Temmuz 2013

Cevap: DB'nize Sorunsuz Chaos Stone Ekleyin.

teşekkürler

BaLTaZaR · 9 Temmuz 2013

Cevap: DB'nize Sorunsuz Chaos Stone Ekleyin.

eyw reis

33alihanreis33 · 9 Temmuz 2013

3333333333333333333333333333333333

codename · 9 Temmuz 2013

deneyelim

DB'nize Sorunsuz Chaos Stone Ekleyin.

Kayıtlı Üye

Kayıtlı Üye

Kayıtlı Üye

Kayıtlı Üye

Kayıtlı Üye

Kayıtlı Üye

Kayıtlı Üye

Kayıtlı Üye

Kayıtlı Üye

Yeni Üye

Kayıtlı Üye

Kayıtlı Üye

Kayıtlı Üye

Kayıtlı Üye

Kayıtlı Üye

Kayıtlı Üye

Kayıtlı Üye

Kayıtlı Üye

Yeni Üye

Kayıtlı Üye