API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Jan 15th, 2014
164
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 8.43 KB | None | 0 0
raw download clone embed print report
  1. if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[PPCARD_ITEM_PROBABILITY]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
  2. drop table [dbo].[PPCARD_ITEM_PROBABILITY]
  3. GO
  4.  
  5. CREATE TABLE [dbo].[PPCARD_ITEM_PROBABILITY] (
  6. [ItemID] [int] NULL ,
  7. [Type] [tinyint] NULL ,
  8. [nCount] [int] NULL ,
  9. [Rate] [int] NULL
  10. ) ON [PRIMARY]
  11. GO
  12.  
  13. INSERT INTO [PPCARD_ITEM_PROBABILITY] VALUES (120810191,1,1,1)
  14.  
  15. DELETE FROM K_NPC WHERE sSid = 24000
  16. DELETE FROM K_NPC WHERE sSid = 24002
  17. DELETE FROM K_NPC WHERE sSid = 24003
  18. 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)
  19. 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)
  20. 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)
  21.  
  22.  
  23. DELETE FROM K_NPCPOS WHERE NpcID = 24000
  24. DELETE FROM K_NPCPOS WHERE NpcID = 24002
  25. DELETE FROM K_NPCPOS WHERE NpcID = 24003
  26. 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)
  27. 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)
  28. 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)
  29.  
  30. DROP TABLE PREMIUM_SERVICE
  31. CREATE TABLE [dbo].[PREMIUM_SERVICE](
  32. [strAccountID] [varchar](27) NOT NULL,
  33. [strType] [smallint] NOT NULL,
  34. [nDays] [smallint] NOT NULL,
  35. [PremStart] [smalldatetime] NOT NULL
  36. ) ON [PRIMARY]
  37.  
  38. GO
  39.  
  40. SET ANSI_PADDING ON
  41. GO
  42.  
  43. ALTER TABLE [dbo].[PREMIUM_SERVICE] ADD CONSTRAINT [DF_PREMIUM_SERVICE_PremStart] DEFAULT (getdate()) FOR [PremStart]
  44. GO
  45.  
  46.  
  47. ---Chaos Stone---
  48. delete from k_npc where ssid = 24001
  49. delete from k_npcpos where npcid = 24001
  50. delete from k_monster where ssid >= 1987 and ssid <= 2000
  51. 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');
  52. 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');
  53. 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');
  54. 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');
  55. 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');
  56. 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');
  57. 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');
  58. 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');
  59. 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');
  60. 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');
  61. 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');
  62. 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');
  63. 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');
  64. 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');
  65. 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');
  66. 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');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!