搜索
 找回密码
 加入

Some Scripts by(emrelevent)

ctgwglzc 2007-5-27 02:04:10 1241
返回列表 发新帖
ctgwglzc

DMM DUGA XCREAM SOKMIL等日本PPV站视频代购

Skill Editting


  2. update MAGIC_TYPE1 set Hit = ''0-30000 enter a number''
  3. where Name =''Skill Name''

  5. exemple :
  6. _________________________________
  7. update MAGIC_TYPE1 set Hit =''30000'' |
  8. where Name =''sword dancing'' |
  9. _______________________________ |
复制代码


Finding Account


  2. declare @name varchar(21)
  3. set @name = ''Character Name''


  6. SELECT * from ACCOUNT_CHAR
  7. where strcharid1 = @name
  8. or strcharid2 = @name
  9. or strcharid3 = @name
复制代码


To Be A gm
  1. update userdata set Authority = ''0''
  2. where struserid = ''Character Name''
复制代码


Editing Character

  2. update userdata set Strong = ''255'',Sta = ''255'',Dex = ''255'',Intel = ''255'',Cha = ''255'', Level = ''100'',Loyalty = ''100000000'',Points = ''255'',Gold = ''2100000000''
  3. where struserid = ''Character Name''
复制代码


Deleting Character''s items

  2. UPDATE warehouse
  3. SET WareHouseData = ''''
  4. WHERE strAccountID = ''Character Name''
复制代码


To Be Female Mage

  2. update userdata set class = ''109''
  3. where struserid = ''Character Name''
复制代码


Name Change


  3. create procedure [NameChange]
  4. (@oldname varchar(30),@newname varchar(30))
  5. AS DECLARE @clannumber smallint, @length int,@row int,@i int,@dwid int,@pos int,@dur int,@dur1 int,@ext int,@StackSize1 int,@strName varchar(30),@strExtName varchar(30),@Cdwid varbinary(4),@cdur varchar(2),@cstack varchar(2)
  6. begin tran
  7. Update account_char set strcharid1 = @newname where strcharid1 = @oldname
  8. Update account_char set strcharid2 = @newname where strcharid2 = @oldname
  9. Update account_char set strcharid3 = @newname where strcharid3 = @oldname
  10. Update userdata set struserid = @newname Where struserid = @oldname
  11. Update knights_user set struserid = @newname Where struserid = @oldname
  12. Update knights set chief = @newname where chief = @oldname
  13. Update knights set vicechief_1 = @newname where vicechief_1 = @oldname
  14. Update knights set vicechief_2 = @newname where vicechief_2 = @oldname
  15. Update knights set vicechief_3 = @newname where vicechief_3 = @oldname
  16. commit tran
复制代码


%100 upgrade
  1. UPDATE UPGRADEEXT0 SET siPercent0 = 100, siPercent1 = 100, siPercent2 = 100, siPercent3 = 100, siPercent4 = 100, siPercent5 = 100, siPercent6 = 100, siPercent7 = 100, siPercent8 = 100, siPercent9 = 100
  2. UPDATE UPGRADEEXT1 SET siPercent0 = 100, siPercent1 = 100, siPercent2 = 100, siPercent3 = 100, siPercent4 = 100, siPercent5 = 100, siPercent6 = 100, siPercent7 = 100, siPercent8 = 100, siPercent9 = 100
  3. UPDATE UPGRADEEXT2 SET siPercent0 = 100, siPercent1 = 100, siPercent2 = 100, siPercent3 = 100, siPercent4 = 100, siPercent5 = 100, siPercent6 = 100, siPercent7 = 100, siPercent8 = 100, siPercent9 = 100
  4. UPDATE UPGRADEEXT3 SET siPercent0 = 100, siPercent1 = 100, siPercent2 = 100, siPercent3 = 100, siPercent4 = 100, siPercent5 = 100, siPercent6 = 100, siPercent7 = 100, siPercent8 = 100, siPercent9 = 100
  5. UPDATE UPGRADEEXT4 SET siPercent0 = 100, siPercent1 = 100, siPercent2 = 100, siPercent3 = 100, siPercent4 = 100, siPercent5 = 100, siPercent6 = 100, siPercent7 = 100, siPercent8 = 100, siPercent9 = 100
  6. UPDATE UPGRADEEXT5 SET siPercent0 = 100, siPercent1 = 100, siPercent2 = 100, siPercent3 = 100, siPercent4 = 100, siPercent5 = 100, siPercent6 = 100, siPercent7 = 100, siPercent8 = 100, siPercent9 = 100
  7. UPDATE UPGRADEEXT6 SET siPercent0 = 100, siPercent1 = 100, siPercent2 = 100, siPercent3 = 100, siPercent4 = 100, siPercent5 = 100, siPercent6 = 100, siPercent7 = 100, siPercent8 = 100, siPercent9 = 100
  8. UPDATE UPGRADEEXT7 SET siPercent0 = 100, siPercent1 = 100, siPercent2 = 100, siPercent3 = 100, siPercent4 = 100, siPercent5 = 100, siPercent6 = 100, siPercent7 = 100, siPercent8 = 100, siPercent9 = 100
  9. UPDATE UPGRADEEXT8 SET siPercent0 = 100, siPercent1 = 100, siPercent2 = 100, siPercent3 = 100, siPercent4 = 100, siPercent5 = 100, siPercent6 = 100, siPercent7 = 100, siPercent8 = 100, siPercent9 = 100
  10. UPDATE UPGRADEEXT9 SET siPercent0 = 100, siPercent1 = 100, siPercent2 = 100, siPercent3 = 100, siPercent4 = 100, siPercent5 = 100, siPercent6 = 100, siPercent7 = 100, siPercent8 = 100, siPercent9 = 100
  11. UPDATE UPGRADEEXT10 SET siPercent0 = 100, siPercent1 = 100, siPercent2 = 100, siPercent3 = 100, siPercent4 = 100, siPercent5 = 100, siPercent6 = 100, siPercent7 = 100, siPercent8 = 100, siPercent9 = 100
  12. UPDATE UPGRADEEXT11 SET siPercent0 = 100, siPercent1 = 100, siPercent2 = 100, siPercent3 = 100, siPercent4 = 100, siPercent5 = 100, siPercent6 = 100, siPercent7 = 100, siPercent8 = 100, siPercent9 = 100
  13. UPDATE UPGRADEEXT12 SET siPercent0 = 100, siPercent1 = 100, siPercent2 = 100, siPercent3 = 100, siPercent4 = 100, siPercent5 = 100, siPercent6 = 100, siPercent7 = 100, siPercent8 = 100, siPercent9 = 100
  14. UPDATE UPGRADEEXT13 SET siPercent0 = 100, siPercent1 = 100, siPercent2 = 100, siPercent3 = 100, siPercent4 = 100, siPercent5 = 100, siPercent6 = 100, siPercent7 = 100, siPercent8 = 100, siPercent9 = 100
  15. UPDATE UPGRADEEXT14 SET siPercent0 = 100, siPercent1 = 100, siPercent2 = 100, siPercent3 = 100, siPercent4 = 100, siPercent5 = 100, siPercent6 = 100, siPercent7 = 100, siPercent8 = 100, siPercent9 = 100
  16. UPDATE UPGRADEEXT15 SET siPercent0 = 100, siPercent1 = 100, siPercent2 = 100, siPercent3 = 100, siPercent4 = 100, siPercent5 = 100, siPercent6 = 100, siPercent7 = 100, siPercent8 = 100, siPercent9 = 100
  17. UPDATE UPGRADEEXT16 SET siPercent0 = 100, siPercent1 = 100, siPercent2 = 100, siPercent3 = 100, siPercent4 = 100, siPercent5 = 100, siPercent6 = 100, siPercent7 = 100, siPercent8 = 100, siPercent9 = 100
  18. UPDATE UPGRADEEXT17 SET siPercent0 = 100, siPercent1 = 100, siPercent2 = 100, siPercent3 = 100, siPercent4 = 100, siPercent5 = 100, siPercent6 = 100, siPercent7 = 100, siPercent8 = 100, siPercent9 = 100
  19. UPDATE UPGRADEEXT18 SET siPercent0 = 100, siPercent1 = 100, siPercent2 = 100, siPercent3 = 100, siPercent4 = 100, siPercent5 = 100, siPercent6 = 100, siPercent7 = 100, siPercent8 = 100, siPercent9 = 100
  20. UPDATE UPGRADEEXT19 SET siPercent0 = 100, siPercent1 = 100, siPercent2 = 100, siPercent3 = 100, siPercent4 = 100, siPercent5 = 100, siPercent6 = 100, siPercent7 = 100, siPercent8 = 100, siPercent9 = 100
  21. UPDATE UPGRADEEXT20 SET siPercent0 = 100, siPercent1 = 100, siPercent2 = 100, siPercent3 = 100, siPercent4 = 100, siPercent5 = 100, siPercent6 = 100, siPercent7 = 100, siPercent8 = 100, siPercent9 = 100
  22. UPDATE UPGRADEEXT21 SET siPercent0 = 100, siPercent1 = 100, siPercent2 = 100, siPercent3 = 100, siPercent4 = 100, siPercent5 = 100, siPercent6 = 100, siPercent7 = 100, siPercent8 = 100, siPercent9 = 100
  23. UPDATE UPGRADEEXT22 SET siPercent0 = 100, siPercent1 = 100, siPercent2 = 100, siPercent3 = 100, siPercent4 = 100, siPercent5 = 100, siPercent6 = 100, siPercent7 = 100, siPercent8 = 100, siPercent9 = 100
  24. UPDATE UPGRADEEXT23 SET siPercent0 = 100, siPercent1 = 100, siPercent2 = 100, siPercent3 = 100, siPercent4 = 100, siPercent5 = 100, siPercent6 = 100, siPercent7 = 100, siPercent8 = 100, siPercent9 = 100
复制代码


Starting Money 21GB
  1. CREATE PROCEDURE CREATE_NEW_CHAR
  2. @nRet        smallint OUTPUT,
  3. @AccountID     char(21),
  4. @index         tinyint,
  5. @CharID    char(21),
  6. @Race         tinyint,
  7. @Class     smallint,
  8. @Hair         tinyint,
  9. @Face         tinyint,
  10. @Str         tinyint,
  11. @Sta         tinyint,
  12. @Dex         tinyint,
  13. @Intel         tinyint,
  14. @Cha         tinyint
  15. AS
  16. DECLARE @Row tinyint, @Nation tinyint, @Zone tinyint, @PosX int, @PosZ int
  17.     SET @Row = 0    SET @Nation = 0  SET @Zone = 0  SET @PosX = 0 SET @PosZ = 0
  18.     SELECT @Nation = bNation, @Row = bCharNum FROM ACCOUNT_CHAR WHERE strAccountID = @AccountID
  19.    
  20.     IF @Row >= 5    SET @nRet =  1
  21.    
  22.     IF @Nation = 1 AND @Race > 10    SET @nRet = 2
  23.     ELSE IF @Nation = 2 AND @Race < 10    SET @nRet = 2
  24.     ELSE IF @Nation <>1 AND @Nation <> 2    SET @nRet = 2
  25.     IF @nRet > 0
  26.         RETURN
  27.    
  28.     SELECT @Row = COUNT(*) FROM USERDATA WHERE strUserId = @CharID
  29.     IF @Row > 0
  30.     BEGIN
  31.         SET @nRet =  3
  32.         RETURN
  33.     END
  34.     SET @Zone = @Nation
  35.     SELECT @PosX = InitX, @PosZ = InitZ  FROM ZONE_INFO WHERE ZoneNo = @Zone
  36. BEGIN TRAN   
  37.     IF @index = 0
  38.         UPDATE ACCOUNT_CHAR SET strCharID1 = @CharID, bCharNum = bCharNum + 1 WHERE strAccountID = @AccountID
  39.     ELSE IF @index = 1
  40.         UPDATE ACCOUNT_CHAR SET strCharID2 = @CharID, bCharNum = bCharNum + 1 WHERE strAccountID = @AccountID
  41.     ELSE IF @index = 2
  42.         UPDATE ACCOUNT_CHAR SET strCharID3 = @CharID, bCharNum = bCharNum + 1 WHERE strAccountID = @AccountID
  43.     ELSE IF @index = 3
  44.         UPDATE ACCOUNT_CHAR SET strCharID4 = @CharID, bCharNum = bCharNum + 1 WHERE strAccountID = @AccountID
  45.     ELSE IF @index = 4
  46.         UPDATE ACCOUNT_CHAR SET strCharID5 = @CharID, bCharNum = bCharNum + 1 WHERE strAccountID = @AccountID
  47.    
  48.     INSERT INTO USERDATA (strUserId, Nation, Race, Class, HairColor, Face, Strong, Sta, Dex, Intel, Cha, Zone, PX, PZ, Gold )
  49. VALUES (@CharID, @Nation, @Race, @Class, @Hair, @Face, @Str, @Sta, @Dex, @Intel, @Cha, 21, 33550, 38520, 10000000 )

  51.    
  52.    
  53.     IF @@ERROR <> 0
  54.     BEGIN   
  55.         ROLLBACK TRAN
  56.         SET @nRet =  4
  57.         RETURN
  58.     END
  59.    
  60. COMMIT TRAN
  61. SET @nRet =  0

  63. GO
复制代码


If ebenezer get error you
  1. truncate table account_char

  3. go

  5. truncate table currentuser

  7. go

  9. truncate table deleted_userdata

  11. go

  13. truncate table knights

  15. go

  17. truncate table knights_rating

  19. go

  21. truncate table knights_user

  23. go

  25. truncate table tb_user

  27. go

  29. truncate table userdata

  31. go

  33. truncate table warehouse

  35. go
复制代码



Changing DB language 4 save bug
  1. ALTER DATABASE KN_Online
  2. COLLATE Latin1_General_CI_AS

  4. or

  6. ALTER DATABASE KN_Online
  7. COLLATE Turkish_CI_AS
复制代码


Nation Transfer

Elmorad To Karus
  1. CREATE procedure [nt1]
  2. @Account char(30)

  4. AS DECLARE @clannumber smallint, @length int,@row int,@i int,@dwid int,@pos int,@dur int,@dur1 int,@ext int,@StackSize1 int,@strName varchar(30),@strExtName varchar(30),@Cdwid varbinary(4),@cdur varchar(2),@cstack varchar(2)

  6. begin tran

  8. declare @char1 varchar(21)
  9. set @char1 = (select strcharid1 from account_char where straccountid = @account)
  10. declare @char2 varchar(21)
  11. set @char2 = (select strcharid2 from account_char where straccountid = @account)
  12. declare @char3 varchar(21)
  13. set @char3 = (select strcharid3 from account_char where straccountid = @account)
  14. declare @clannumber1 smallint
  15. set @clannumber1 = (select idnum from knights where chief = @char1)
  16. declare @clannumber2 smallint
  17. set @clannumber2 = (select idnum from knights where chief = @char2)
  18. declare @clannumber3 smallint
  19. set @clannumber3 = (select idnum from knights where chief = @char3)

  21. update account_char set bnation = ''1'' where bnation = ''2'' and straccountid = @Account

  23. update userdata set nation = ''1'' where nation = ''2'' and struserid = @char1
  24. Update userdata set race = ''1'' where class in (''201'',''205'') and struserid = @char1
  25. Update userdata set race = ''2'' where race = ''12'' and class in (''207'',''211'',''202'',''204'') and struserid = @char1
  26. update userdata set race = ''3'' where race = ''13'' and class in (''204'',''211'') and struserid = @char1
  27. update userdata set race = ''4'' where class in (''203'',''209'') and struserid = @char1
  28. update userdata set class = ''105'' where class = ''205'' and struserid = @char1
  29. update userdata set class = ''107'' where class = ''207'' and struserid = @char1
  30. update userdata set class = ''109'' where class = ''209'' and struserid = @char1
  31. update userdata set class = ''111'' where class = ''211'' and struserid = @char1
  32. update userdata set class = ''101'' where class = ''201'' and struserid = @char1
  33. update userdata set class = ''102'' where class = ''202'' and struserid = @char1
  34. update userdata set class = ''103'' where class = ''203'' and struserid = @char1
  35. update userdata set class = ''104'' where class = ''204'' and struserid = @char1
  36. update userdata set zone = ''21'',bind = ''-1'',px = ''31900'',pz = ''40100'',py = ''0'' where struserid = @char1
  37. delete from knights where chief = @char1
  38. delete from knights_user where sidnum = @clannumber1
  39. delete from knights_rating where shindex = @clannumber1
  40. update userdata set knights = 0, fame = 0 where knights = @clannumber1

  42. update userdata set nation = ''1'' where nation = ''2'' and struserid = @char2
  43. Update userdata set race = ''1'' where class in (''201'',''205'') and struserid = @char2
  44. Update userdata set race = ''2'' where race = ''12'' and class in (''207'',''211'',''202'',''204'') and struserid = @char2
  45. update userdata set race = ''3'' where race = ''13'' and class in (''204'',''211'') and struserid = @char2
  46. update userdata set race = ''4'' where class in (''203'',''209'') and struserid = @char2
  47. update userdata set race = ''4'' where class = ''209'' and struserid = @char2
  48. update userdata set class = ''105'' where class = ''205'' and struserid = @char2
  49. update userdata set class = ''107'' where class = ''207'' and struserid = @char2
  50. update userdata set class = ''109'' where class = ''209'' and struserid = @char2
  51. update userdata set class = ''111'' where class = ''211'' and struserid = @char2
  52. update userdata set class = ''101'' where class = ''201'' and struserid = @char2
  53. update userdata set class = ''102'' where class = ''202'' and struserid = @char2
  54. update userdata set class = ''103'' where class = ''203'' and struserid = @char2
  55. update userdata set class = ''104'' where class = ''204'' and struserid = @char2
  56. update userdata set zone = ''21'',bind = ''-1'',px = ''31900'',pz = ''40100'',py = ''0'' where struserid = @char2
  57. delete from knights where chief = @char2
  58. delete from knights_user where sidnum = @clannumber2
  59. delete from knights_rating where shindex = @clannumber2
  60. update userdata set knights = 0, fame = 0 where knights = @clannumber2

  62. update userdata set nation = ''1'' where nation = ''2'' and struserid = @char3
  63. Update userdata set race = ''1'' where class in (''201'',''205'') and struserid = @char3
  64. Update userdata set race = ''2'' where race = ''12'' and class in (''207'',''211'',''202'',''204'') and struserid = @char3
  65. update userdata set race = ''3'' where race = ''13'' and class in (''204'',''211'') and struserid = @char3
  66. update userdata set race = ''4'' where class in (''203'',''209'') and struserid = @char3
  67. update userdata set class = ''105'' where class = ''205'' and struserid = @char3
  68. update userdata set class = ''107'' where class = ''207'' and struserid = @char3
  69. update userdata set class = ''109'' where class = ''209'' and struserid = @char3
  70. update userdata set class = ''111'' where class = ''211'' and struserid = @char3
  71. update userdata set class = ''101'' where class = ''201'' and struserid = @char3
  72. update userdata set class = ''102'' where class = ''202'' and struserid = @char3
  73. update userdata set class = ''103'' where class = ''203'' and struserid = @char3
  74. update userdata set class = ''104'' where class = ''204'' and struserid = @char3
  75. update userdata set zone = ''21'',bind = ''-1'',px = ''31900'',pz = ''40100'',py = ''0'' where struserid = @char3
  76. delete from knights where chief = @char3
  77. delete from knights_user where sidnum = @clannumber3
  78. delete from knights_rating where shindex = @clannumber3
  79. update userdata set knights = 0, fame = 0 where knights = @clannumber3
  80. update userdata set knights = 0, fame = 0 where struserid = @char1
  81. update userdata set knights = 0, fame = 0 where struserid = @char2
  82. update userdata set knights = 0, fame = 0 where struserid = @char3
  83. Update knights set vicechief_1 = '''' where vicechief_1 = @char1
  84. Update knights set vicechief_2 = '''' where vicechief_2 = @char1
  85. Update knights set vicechief_3 = '''' where vicechief_3 = @char1
  86. Update knights set vicechief_1 = '''' where vicechief_1 = @char2
  87. Update knights set vicechief_2 = '''' where vicechief_2 = @char2
  88. Update knights set vicechief_3 = '''' where vicechief_3 = @char2
  89. Update knights set vicechief_1 = '''' where vicechief_1 = @char3
  90. Update knights set vicechief_2 = '''' where vicechief_2 = @char3
  91. Update knights set vicechief_3 = '''' where vicechief_3 = @char3
  92. delete from knights_user where struserid = @char1
  93. delete from knights_user where struserid = @char2
  94. delete from knights_user where struserid = @char3

  96. commit tran

  98. GO
复制代码

Karus To Elmorad
  1. CREATE procedure [nt2]
  2. @Account char(30)

  4. AS DECLARE @clannumber smallint, @length int,@row int,@i int,@dwid int,@pos int,@dur int,@dur1 int,@ext int,@StackSize1 int,@strName varchar(30),@strExtName varchar(30),@Cdwid varbinary(4),@cdur varchar(2),@cstack varchar(2)

  6. begin tran

  8. declare @char1 varchar(21)
  9. set @char1 = (select strcharid1 from account_char where straccountid = @account)
  10. declare @char2 varchar(21)
  11. set @char2 = (select strcharid2 from account_char where straccountid = @account)
  12. declare @char3 varchar(21)
  13. set @char3 = (select strcharid3 from account_char where straccountid = @account)
  14. declare @clannumber1 smallint
  15. set @clannumber1 = (select idnum from knights where chief = @char1)
  16. declare @clannumber2 smallint
  17. set @clannumber2 = (select idnum from knights where chief = @char2)
  18. declare @clannumber3 smallint
  19. set @clannumber3 = (select idnum from knights where chief = @char3)

  21. update account_char set bnation = ''2'' where bnation = ''1'' and straccountid = @Account

  23. update userdata set nation = ''2'' where nation = ''1'' and struserid = @char1
  24. Update userdata set race = ''11'' where class =  ''105''  and struserid = @char1
  25. update userdata set race = ''11'' where class = ''101'' and struserid = @char1
  26. Update userdata set race = ''12'' where race = ''2'' and class in (''107'',''111'',''102'',''104'') and struserid = @char1
  27. update userdata set race = ''13'' where race = ''3'' and class in (''104'',''111'') and struserid = @char1
  28. update userdata set race = ''13'' where class in (''203'',''209'') and race = ''4'' and struserid = @char1
  29. update userdata set class = ''205'' where class = ''105'' and struserid = @char1
  30. update userdata set class = ''207'' where class = ''107'' and struserid = @char1
  31. update userdata set class = ''209'' where class = ''109'' and struserid = @char1
  32. update userdata set class = ''211'' where class = ''111'' and struserid = @char1
  33. update userdata set class = ''201'' where class = ''101'' and struserid = @char1
  34. update userdata set class = ''202'' where class = ''102'' and struserid = @char1
  35. update userdata set class = ''203'' where class = ''103'' and struserid = @char1
  36. update userdata set class = ''204'' where class = ''104'' and struserid = @char1
  37. update userdata set zone = ''21'',bind = ''-1'',px = ''31900'',pz = ''40100'',py = ''0'' where struserid = @char1
  38. delete from knights where chief = @char1
  39. delete from knights_user where sidnum = @clannumber1
  40. delete from knights_rating where shindex = @clannumber1
  41. update userdata set knights = 0, fame = 0 where knights = @clannumber1

  43. update userdata set nation = ''2'' where nation = ''1'' and struserid = @char2
  44. Update userdata set race = ''11'' where class = ''105''  and struserid = @char2
  45. update userdata set race = ''11'' where class = ''101'' and struserid = @char2
  46. Update userdata set race = ''12'' where race = ''2'' and class in (''107'',''111'',''102'',''104'') and struserid = @char2
  47. update userdata set race = ''13'' where race = ''3'' and class in (''104'',''111'') and struserid = @char2
  48. update userdata set race = ''13'' where class in (''203'',''209'') and race = ''4'' and struserid = @char2
  49. update userdata set class = ''205'' where class = ''105'' and struserid = @char2
  50. update userdata set class = ''207'' where class = ''107'' and struserid = @char2
  51. update userdata set class = ''209'' where class = ''109'' and struserid = @char2
  52. update userdata set class = ''211'' where class = ''111'' and struserid = @char2
  53. update userdata set class = ''201'' where class = ''101'' and struserid = @char2
  54. update userdata set class = ''202'' where class = ''102'' and struserid = @char2
  55. update userdata set class = ''203'' where class = ''103'' and struserid = @char2
  56. update userdata set class = ''204'' where class = ''104'' and struserid = @char2
  57. update userdata set zone = ''21'',bind = ''-1'',px = ''31900'',pz = ''40100'',py = ''0'' where struserid = @char2
  58. delete from knights where chief = @char2
  59. delete from knights_user where sidnum = @clannumber2
  60. delete from knights_rating where shindex = @clannumber2
  61. update userdata set knights = 0, fame = 0 where knights = @clannumber2

  63. update userdata set nation = ''2'' where nation = ''1'' and struserid = @char3
  64. Update userdata set race = ''11'' where class = ''105''  and struserid = @char3
  65. update userdata set race = ''11'' where class = ''101'' and struserid = @char3
  66. Update userdata set race = ''12'' where race = ''2'' and class in (''107'',''111'',''102'',''104'') and struserid = @char3
  67. update userdata set race = ''13'' where race = ''3'' and class in (''104'',''111'') and struserid = @char3
  68. update userdata set race = ''13'' where class in (''203'',''209'') and race = ''4'' and struserid = @char3
  69. update userdata set class = ''205'' where class = ''105'' and struserid = @char3
  70. update userdata set class = ''207'' where class = ''107'' and struserid = @char3
  71. update userdata set class = ''209'' where class = ''109'' and struserid = @char3
  72. update userdata set class = ''211'' where class = ''111'' and struserid = @char3
  73. update userdata set class = ''201'' where class = ''101'' and struserid = @char3
  74. update userdata set class = ''202'' where class = ''102'' and struserid = @char3
  75. update userdata set class = ''203'' where class = ''103'' and struserid = @char3
  76. update userdata set class = ''204'' where class = ''104'' and struserid = @char3
  77. update userdata set zone = ''21'',bind = ''-1'',px = ''31900'',pz = ''40100'',py = ''0'' where struserid = @char3
  78. delete from knights where chief = @char3
  79. delete from knights_user where sidnum = @clannumber3
  80. delete from knights_rating where shindex = @clannumber3
  81. update userdata set knights = 0, fame = 0 where knights = @clannumber3
  82. update userdata set knights = 0, fame = 0 where struserid = @char1
  83. update userdata set knights = 0, fame = 0 where struserid = @char2
  84. update userdata set knights = 0, fame = 0 where struserid = @char3
  85. Update knights set vicechief_1 = '''' where vicechief_1 = @char1
  86. Update knights set vicechief_2 = '''' where vicechief_2 = @char1
  87. Update knights set vicechief_3 = '''' where vicechief_3 = @char1
  88. Update knights set vicechief_1 = '''' where vicechief_1 = @char2
  89. Update knights set vicechief_2 = '''' where vicechief_2 = @char2
  90. Update knights set vicechief_3 = '''' where vicechief_3 = @char2
  91. Update knights set vicechief_1 = '''' where vicechief_1 = @char3
  92. Update knights set vicechief_2 = '''' where vicechief_2 = @char3
  93. Update knights set vicechief_3 = '''' where vicechief_3 = @char3
  94. delete from knights_user where struserid = @char1
  95. delete from knights_user where struserid = @char2
  96. delete from knights_user where struserid = @char3

  98. commit tran

  100. GO
复制代码



Monsters Drops

  2. update K_MONSTER_ITEM set iItem02 = ''&#304;tem Kodu'',sPersent02 = ''Persent to drop 0 to 10000 number you write'',iItem03 = ''Item code'',sPersent03 = ''Persent to drop 0 to 10000 number you write'',iItem04 = ''Item code'', sPersent04 = ''Persent to drop 0 to 10000 number you write'',iItem05 = ''Item code'',sPersent05 = ''Persent to drop 0 to 10000 number you write''
  3. where sIndex = ''Monster''s sSid code''

复制代码


Changeing items + from npc

  1. update K_NPC set iSellingGroup = ' iSellingGroup No'
  2. where strName = 'Npc Name'
复制代码


emrelevent，Scripts，Some

举报

相关推荐
 Some Ebenezer Commands (1507)
 Setting War Clocks (emrelevent) (1507)
 SOME LINKS

0 回复

B Color Image Link Quote Code Smilies
高级模式
游客
返回
发布新主题
ctgwglzc
积分
169744 		主题
8709 		精华
13
作者最近主题
内容均来自互联网如侵犯您的权利请邮件:[email protected] 鄂ICP备07001904号