Some Scripts by(emrelevent)
Skill Edittingupdate MAGIC_TYPE1 set Hit = ''0-30000 enter a number''
where Name =''Skill Name''
exemple :
_________________________________
update MAGIC_TYPE1 set Hit =''30000'' |
where Name =''sword dancing'' |
_______________________________ |
Finding Account
declare @name varchar(21)
set @name = ''Character Name''
SELECT * from ACCOUNT_CHAR
where strcharid1 = @name
or strcharid2 = @name
or strcharid3 = @name
To Be A gm
update userdata set Authority = ''0''
where struserid = ''Character Name''
Editing Character
update userdata set Strong = ''255'',Sta = ''255'',Dex = ''255'',Intel = ''255'',Cha = ''255'', Level = ''100'',Loyalty = ''100000000'',Points = ''255'',Gold = ''2100000000''
where struserid = ''Character Name''
Deleting Character''s items
UPDATE warehouse
SET WareHouseData = ''''
WHERE strAccountID = ''Character Name''
To Be Female Mage
update userdata set class = ''109''
where struserid = ''Character Name''
Name Change
create procedure
(@oldname varchar(30),@newname varchar(30))
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)
begin tran
Update account_char set strcharid1 = @newname where strcharid1 = @oldname
Update account_char set strcharid2 = @newname where strcharid2 = @oldname
Update account_char set strcharid3 = @newname where strcharid3 = @oldname
Update userdata set struserid = @newname Where struserid = @oldname
Update knights_user set struserid = @newname Where struserid = @oldname
Update knights set chief = @newname where chief = @oldname
Update knights set vicechief_1 = @newname where vicechief_1 = @oldname
Update knights set vicechief_2 = @newname where vicechief_2 = @oldname
Update knights set vicechief_3 = @newname where vicechief_3 = @oldname
commit tran
%100 upgrade
UPDATE UPGRADEEXT0 SET siPercent0 = 100, siPercent1 = 100, siPercent2 = 100, siPercent3 = 100, siPercent4 = 100, siPercent5 = 100, siPercent6 = 100, siPercent7 = 100, siPercent8 = 100, siPercent9 = 100
UPDATE UPGRADEEXT1 SET siPercent0 = 100, siPercent1 = 100, siPercent2 = 100, siPercent3 = 100, siPercent4 = 100, siPercent5 = 100, siPercent6 = 100, siPercent7 = 100, siPercent8 = 100, siPercent9 = 100
UPDATE UPGRADEEXT2 SET siPercent0 = 100, siPercent1 = 100, siPercent2 = 100, siPercent3 = 100, siPercent4 = 100, siPercent5 = 100, siPercent6 = 100, siPercent7 = 100, siPercent8 = 100, siPercent9 = 100
UPDATE UPGRADEEXT3 SET siPercent0 = 100, siPercent1 = 100, siPercent2 = 100, siPercent3 = 100, siPercent4 = 100, siPercent5 = 100, siPercent6 = 100, siPercent7 = 100, siPercent8 = 100, siPercent9 = 100
UPDATE UPGRADEEXT4 SET siPercent0 = 100, siPercent1 = 100, siPercent2 = 100, siPercent3 = 100, siPercent4 = 100, siPercent5 = 100, siPercent6 = 100, siPercent7 = 100, siPercent8 = 100, siPercent9 = 100
UPDATE UPGRADEEXT5 SET siPercent0 = 100, siPercent1 = 100, siPercent2 = 100, siPercent3 = 100, siPercent4 = 100, siPercent5 = 100, siPercent6 = 100, siPercent7 = 100, siPercent8 = 100, siPercent9 = 100
UPDATE UPGRADEEXT6 SET siPercent0 = 100, siPercent1 = 100, siPercent2 = 100, siPercent3 = 100, siPercent4 = 100, siPercent5 = 100, siPercent6 = 100, siPercent7 = 100, siPercent8 = 100, siPercent9 = 100
UPDATE UPGRADEEXT7 SET siPercent0 = 100, siPercent1 = 100, siPercent2 = 100, siPercent3 = 100, siPercent4 = 100, siPercent5 = 100, siPercent6 = 100, siPercent7 = 100, siPercent8 = 100, siPercent9 = 100
UPDATE UPGRADEEXT8 SET siPercent0 = 100, siPercent1 = 100, siPercent2 = 100, siPercent3 = 100, siPercent4 = 100, siPercent5 = 100, siPercent6 = 100, siPercent7 = 100, siPercent8 = 100, siPercent9 = 100
UPDATE UPGRADEEXT9 SET siPercent0 = 100, siPercent1 = 100, siPercent2 = 100, siPercent3 = 100, siPercent4 = 100, siPercent5 = 100, siPercent6 = 100, siPercent7 = 100, siPercent8 = 100, siPercent9 = 100
UPDATE UPGRADEEXT10 SET siPercent0 = 100, siPercent1 = 100, siPercent2 = 100, siPercent3 = 100, siPercent4 = 100, siPercent5 = 100, siPercent6 = 100, siPercent7 = 100, siPercent8 = 100, siPercent9 = 100
UPDATE UPGRADEEXT11 SET siPercent0 = 100, siPercent1 = 100, siPercent2 = 100, siPercent3 = 100, siPercent4 = 100, siPercent5 = 100, siPercent6 = 100, siPercent7 = 100, siPercent8 = 100, siPercent9 = 100
UPDATE UPGRADEEXT12 SET siPercent0 = 100, siPercent1 = 100, siPercent2 = 100, siPercent3 = 100, siPercent4 = 100, siPercent5 = 100, siPercent6 = 100, siPercent7 = 100, siPercent8 = 100, siPercent9 = 100
UPDATE UPGRADEEXT13 SET siPercent0 = 100, siPercent1 = 100, siPercent2 = 100, siPercent3 = 100, siPercent4 = 100, siPercent5 = 100, siPercent6 = 100, siPercent7 = 100, siPercent8 = 100, siPercent9 = 100
UPDATE UPGRADEEXT14 SET siPercent0 = 100, siPercent1 = 100, siPercent2 = 100, siPercent3 = 100, siPercent4 = 100, siPercent5 = 100, siPercent6 = 100, siPercent7 = 100, siPercent8 = 100, siPercent9 = 100
UPDATE UPGRADEEXT15 SET siPercent0 = 100, siPercent1 = 100, siPercent2 = 100, siPercent3 = 100, siPercent4 = 100, siPercent5 = 100, siPercent6 = 100, siPercent7 = 100, siPercent8 = 100, siPercent9 = 100
UPDATE UPGRADEEXT16 SET siPercent0 = 100, siPercent1 = 100, siPercent2 = 100, siPercent3 = 100, siPercent4 = 100, siPercent5 = 100, siPercent6 = 100, siPercent7 = 100, siPercent8 = 100, siPercent9 = 100
UPDATE UPGRADEEXT17 SET siPercent0 = 100, siPercent1 = 100, siPercent2 = 100, siPercent3 = 100, siPercent4 = 100, siPercent5 = 100, siPercent6 = 100, siPercent7 = 100, siPercent8 = 100, siPercent9 = 100
UPDATE UPGRADEEXT18 SET siPercent0 = 100, siPercent1 = 100, siPercent2 = 100, siPercent3 = 100, siPercent4 = 100, siPercent5 = 100, siPercent6 = 100, siPercent7 = 100, siPercent8 = 100, siPercent9 = 100
UPDATE UPGRADEEXT19 SET siPercent0 = 100, siPercent1 = 100, siPercent2 = 100, siPercent3 = 100, siPercent4 = 100, siPercent5 = 100, siPercent6 = 100, siPercent7 = 100, siPercent8 = 100, siPercent9 = 100
UPDATE UPGRADEEXT20 SET siPercent0 = 100, siPercent1 = 100, siPercent2 = 100, siPercent3 = 100, siPercent4 = 100, siPercent5 = 100, siPercent6 = 100, siPercent7 = 100, siPercent8 = 100, siPercent9 = 100
UPDATE UPGRADEEXT21 SET siPercent0 = 100, siPercent1 = 100, siPercent2 = 100, siPercent3 = 100, siPercent4 = 100, siPercent5 = 100, siPercent6 = 100, siPercent7 = 100, siPercent8 = 100, siPercent9 = 100
UPDATE UPGRADEEXT22 SET siPercent0 = 100, siPercent1 = 100, siPercent2 = 100, siPercent3 = 100, siPercent4 = 100, siPercent5 = 100, siPercent6 = 100, siPercent7 = 100, siPercent8 = 100, siPercent9 = 100
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
CREATE PROCEDURE CREATE_NEW_CHAR
@nRet smallint OUTPUT,
@AccountID char(21),
@index tinyint,
@CharID char(21),
@Race tinyint,
@Class smallint,
@Hair tinyint,
@Face tinyint,
@Str tinyint,
@Sta tinyint,
@Dex tinyint,
@Intel tinyint,
@Cha tinyint
AS
DECLARE @Row tinyint, @Nation tinyint, @Zone tinyint, @PosX int, @PosZ int
SET @Row = 0 SET @Nation = 0SET @Zone = 0SET @PosX = 0 SET @PosZ = 0
SELECT @Nation = bNation, @Row = bCharNum FROM ACCOUNT_CHAR WHERE strAccountID = @AccountID
IF @Row >= 5 SET @nRet =1
IF @Nation = 1 AND @Race > 10 SET @nRet = 2
ELSE IF @Nation = 2 AND @Race < 10 SET @nRet = 2
ELSE IF @Nation <>1 AND @Nation <> 2 SET @nRet = 2
IF @nRet > 0
RETURN
SELECT @Row = COUNT(*) FROM USERDATA WHERE strUserId = @CharID
IF @Row > 0
BEGIN
SET @nRet =3
RETURN
END
SET @Zone = @Nation
SELECT @PosX = InitX, @PosZ = InitZFROM ZONE_INFO WHERE ZoneNo = @Zone
BEGIN TRAN
IF @index = 0
UPDATE ACCOUNT_CHAR SET strCharID1 = @CharID, bCharNum = bCharNum + 1 WHERE strAccountID = @AccountID
ELSE IF @index = 1
UPDATE ACCOUNT_CHAR SET strCharID2 = @CharID, bCharNum = bCharNum + 1 WHERE strAccountID = @AccountID
ELSE IF @index = 2
UPDATE ACCOUNT_CHAR SET strCharID3 = @CharID, bCharNum = bCharNum + 1 WHERE strAccountID = @AccountID
ELSE IF @index = 3
UPDATE ACCOUNT_CHAR SET strCharID4 = @CharID, bCharNum = bCharNum + 1 WHERE strAccountID = @AccountID
ELSE IF @index = 4
UPDATE ACCOUNT_CHAR SET strCharID5 = @CharID, bCharNum = bCharNum + 1 WHERE strAccountID = @AccountID
INSERT INTO USERDATA (strUserId, Nation, Race, Class, HairColor, Face, Strong, Sta, Dex, Intel, Cha, Zone, PX, PZ, Gold )
VALUES (@CharID, @Nation, @Race, @Class, @Hair, @Face, @Str, @Sta, @Dex, @Intel, @Cha, 21, 33550, 38520, 10000000 )
IF @@ERROR <> 0
BEGIN
ROLLBACK TRAN
SET @nRet =4
RETURN
END
COMMIT TRAN
SET @nRet =0
GO
If ebenezer get error you
truncate table account_char
go
truncate table currentuser
go
truncate table deleted_userdata
go
truncate table knights
go
truncate table knights_rating
go
truncate table knights_user
go
truncate table tb_user
go
truncate table userdata
go
truncate table warehouse
go
Changing DB language 4 save bug
ALTER DATABASE KN_Online
COLLATE Latin1_General_CI_AS
or
ALTER DATABASE KN_Online
COLLATE Turkish_CI_AS
Nation Transfer
Elmorad To Karus
CREATE procedure
@Account char(30)
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)
begin tran
declare @char1 varchar(21)
set @char1 = (select strcharid1 from account_char where straccountid = @account)
declare @char2 varchar(21)
set @char2 = (select strcharid2 from account_char where straccountid = @account)
declare @char3 varchar(21)
set @char3 = (select strcharid3 from account_char where straccountid = @account)
declare @clannumber1 smallint
set @clannumber1 = (select idnum from knights where chief = @char1)
declare @clannumber2 smallint
set @clannumber2 = (select idnum from knights where chief = @char2)
declare @clannumber3 smallint
set @clannumber3 = (select idnum from knights where chief = @char3)
update account_char set bnation = ''1'' where bnation = ''2'' and straccountid = @Account
update userdata set nation = ''1'' where nation = ''2'' and struserid = @char1
Update userdata set race = ''1'' where class in (''201'',''205'') and struserid = @char1
Update userdata set race = ''2'' where race = ''12'' and class in (''207'',''211'',''202'',''204'') and struserid = @char1
update userdata set race = ''3'' where race = ''13'' and class in (''204'',''211'') and struserid = @char1
update userdata set race = ''4'' where class in (''203'',''209'') and struserid = @char1
update userdata set class = ''105'' where class = ''205'' and struserid = @char1
update userdata set class = ''107'' where class = ''207'' and struserid = @char1
update userdata set class = ''109'' where class = ''209'' and struserid = @char1
update userdata set class = ''111'' where class = ''211'' and struserid = @char1
update userdata set class = ''101'' where class = ''201'' and struserid = @char1
update userdata set class = ''102'' where class = ''202'' and struserid = @char1
update userdata set class = ''103'' where class = ''203'' and struserid = @char1
update userdata set class = ''104'' where class = ''204'' and struserid = @char1
update userdata set zone = ''21'',bind = ''-1'',px = ''31900'',pz = ''40100'',py = ''0'' where struserid = @char1
delete from knights where chief = @char1
delete from knights_user where sidnum = @clannumber1
delete from knights_rating where shindex = @clannumber1
update userdata set knights = 0, fame = 0 where knights = @clannumber1
update userdata set nation = ''1'' where nation = ''2'' and struserid = @char2
Update userdata set race = ''1'' where class in (''201'',''205'') and struserid = @char2
Update userdata set race = ''2'' where race = ''12'' and class in (''207'',''211'',''202'',''204'') and struserid = @char2
update userdata set race = ''3'' where race = ''13'' and class in (''204'',''211'') and struserid = @char2
update userdata set race = ''4'' where class in (''203'',''209'') and struserid = @char2
update userdata set race = ''4'' where class = ''209'' and struserid = @char2
update userdata set class = ''105'' where class = ''205'' and struserid = @char2
update userdata set class = ''107'' where class = ''207'' and struserid = @char2
update userdata set class = ''109'' where class = ''209'' and struserid = @char2
update userdata set class = ''111'' where class = ''211'' and struserid = @char2
update userdata set class = ''101'' where class = ''201'' and struserid = @char2
update userdata set class = ''102'' where class = ''202'' and struserid = @char2
update userdata set class = ''103'' where class = ''203'' and struserid = @char2
update userdata set class = ''104'' where class = ''204'' and struserid = @char2
update userdata set zone = ''21'',bind = ''-1'',px = ''31900'',pz = ''40100'',py = ''0'' where struserid = @char2
delete from knights where chief = @char2
delete from knights_user where sidnum = @clannumber2
delete from knights_rating where shindex = @clannumber2
update userdata set knights = 0, fame = 0 where knights = @clannumber2
update userdata set nation = ''1'' where nation = ''2'' and struserid = @char3
Update userdata set race = ''1'' where class in (''201'',''205'') and struserid = @char3
Update userdata set race = ''2'' where race = ''12'' and class in (''207'',''211'',''202'',''204'') and struserid = @char3
update userdata set race = ''3'' where race = ''13'' and class in (''204'',''211'') and struserid = @char3
update userdata set race = ''4'' where class in (''203'',''209'') and struserid = @char3
update userdata set class = ''105'' where class = ''205'' and struserid = @char3
update userdata set class = ''107'' where class = ''207'' and struserid = @char3
update userdata set class = ''109'' where class = ''209'' and struserid = @char3
update userdata set class = ''111'' where class = ''211'' and struserid = @char3
update userdata set class = ''101'' where class = ''201'' and struserid = @char3
update userdata set class = ''102'' where class = ''202'' and struserid = @char3
update userdata set class = ''103'' where class = ''203'' and struserid = @char3
update userdata set class = ''104'' where class = ''204'' and struserid = @char3
update userdata set zone = ''21'',bind = ''-1'',px = ''31900'',pz = ''40100'',py = ''0'' where struserid = @char3
delete from knights where chief = @char3
delete from knights_user where sidnum = @clannumber3
delete from knights_rating where shindex = @clannumber3
update userdata set knights = 0, fame = 0 where knights = @clannumber3
update userdata set knights = 0, fame = 0 where struserid = @char1
update userdata set knights = 0, fame = 0 where struserid = @char2
update userdata set knights = 0, fame = 0 where struserid = @char3
Update knights set vicechief_1 = '''' where vicechief_1 = @char1
Update knights set vicechief_2 = '''' where vicechief_2 = @char1
Update knights set vicechief_3 = '''' where vicechief_3 = @char1
Update knights set vicechief_1 = '''' where vicechief_1 = @char2
Update knights set vicechief_2 = '''' where vicechief_2 = @char2
Update knights set vicechief_3 = '''' where vicechief_3 = @char2
Update knights set vicechief_1 = '''' where vicechief_1 = @char3
Update knights set vicechief_2 = '''' where vicechief_2 = @char3
Update knights set vicechief_3 = '''' where vicechief_3 = @char3
delete from knights_user where struserid = @char1
delete from knights_user where struserid = @char2
delete from knights_user where struserid = @char3
commit tran
GO
Karus To Elmorad
CREATE procedure
@Account char(30)
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)
begin tran
declare @char1 varchar(21)
set @char1 = (select strcharid1 from account_char where straccountid = @account)
declare @char2 varchar(21)
set @char2 = (select strcharid2 from account_char where straccountid = @account)
declare @char3 varchar(21)
set @char3 = (select strcharid3 from account_char where straccountid = @account)
declare @clannumber1 smallint
set @clannumber1 = (select idnum from knights where chief = @char1)
declare @clannumber2 smallint
set @clannumber2 = (select idnum from knights where chief = @char2)
declare @clannumber3 smallint
set @clannumber3 = (select idnum from knights where chief = @char3)
update account_char set bnation = ''2'' where bnation = ''1'' and straccountid = @Account
update userdata set nation = ''2'' where nation = ''1'' and struserid = @char1
Update userdata set race = ''11'' where class =''105''and struserid = @char1
update userdata set race = ''11'' where class = ''101'' and struserid = @char1
Update userdata set race = ''12'' where race = ''2'' and class in (''107'',''111'',''102'',''104'') and struserid = @char1
update userdata set race = ''13'' where race = ''3'' and class in (''104'',''111'') and struserid = @char1
update userdata set race = ''13'' where class in (''203'',''209'') and race = ''4'' and struserid = @char1
update userdata set class = ''205'' where class = ''105'' and struserid = @char1
update userdata set class = ''207'' where class = ''107'' and struserid = @char1
update userdata set class = ''209'' where class = ''109'' and struserid = @char1
update userdata set class = ''211'' where class = ''111'' and struserid = @char1
update userdata set class = ''201'' where class = ''101'' and struserid = @char1
update userdata set class = ''202'' where class = ''102'' and struserid = @char1
update userdata set class = ''203'' where class = ''103'' and struserid = @char1
update userdata set class = ''204'' where class = ''104'' and struserid = @char1
update userdata set zone = ''21'',bind = ''-1'',px = ''31900'',pz = ''40100'',py = ''0'' where struserid = @char1
delete from knights where chief = @char1
delete from knights_user where sidnum = @clannumber1
delete from knights_rating where shindex = @clannumber1
update userdata set knights = 0, fame = 0 where knights = @clannumber1
update userdata set nation = ''2'' where nation = ''1'' and struserid = @char2
Update userdata set race = ''11'' where class = ''105''and struserid = @char2
update userdata set race = ''11'' where class = ''101'' and struserid = @char2
Update userdata set race = ''12'' where race = ''2'' and class in (''107'',''111'',''102'',''104'') and struserid = @char2
update userdata set race = ''13'' where race = ''3'' and class in (''104'',''111'') and struserid = @char2
update userdata set race = ''13'' where class in (''203'',''209'') and race = ''4'' and struserid = @char2
update userdata set class = ''205'' where class = ''105'' and struserid = @char2
update userdata set class = ''207'' where class = ''107'' and struserid = @char2
update userdata set class = ''209'' where class = ''109'' and struserid = @char2
update userdata set class = ''211'' where class = ''111'' and struserid = @char2
update userdata set class = ''201'' where class = ''101'' and struserid = @char2
update userdata set class = ''202'' where class = ''102'' and struserid = @char2
update userdata set class = ''203'' where class = ''103'' and struserid = @char2
update userdata set class = ''204'' where class = ''104'' and struserid = @char2
update userdata set zone = ''21'',bind = ''-1'',px = ''31900'',pz = ''40100'',py = ''0'' where struserid = @char2
delete from knights where chief = @char2
delete from knights_user where sidnum = @clannumber2
delete from knights_rating where shindex = @clannumber2
update userdata set knights = 0, fame = 0 where knights = @clannumber2
update userdata set nation = ''2'' where nation = ''1'' and struserid = @char3
Update userdata set race = ''11'' where class = ''105''and struserid = @char3
update userdata set race = ''11'' where class = ''101'' and struserid = @char3
Update userdata set race = ''12'' where race = ''2'' and class in (''107'',''111'',''102'',''104'') and struserid = @char3
update userdata set race = ''13'' where race = ''3'' and class in (''104'',''111'') and struserid = @char3
update userdata set race = ''13'' where class in (''203'',''209'') and race = ''4'' and struserid = @char3
update userdata set class = ''205'' where class = ''105'' and struserid = @char3
update userdata set class = ''207'' where class = ''107'' and struserid = @char3
update userdata set class = ''209'' where class = ''109'' and struserid = @char3
update userdata set class = ''211'' where class = ''111'' and struserid = @char3
update userdata set class = ''201'' where class = ''101'' and struserid = @char3
update userdata set class = ''202'' where class = ''102'' and struserid = @char3
update userdata set class = ''203'' where class = ''103'' and struserid = @char3
update userdata set class = ''204'' where class = ''104'' and struserid = @char3
update userdata set zone = ''21'',bind = ''-1'',px = ''31900'',pz = ''40100'',py = ''0'' where struserid = @char3
delete from knights where chief = @char3
delete from knights_user where sidnum = @clannumber3
delete from knights_rating where shindex = @clannumber3
update userdata set knights = 0, fame = 0 where knights = @clannumber3
update userdata set knights = 0, fame = 0 where struserid = @char1
update userdata set knights = 0, fame = 0 where struserid = @char2
update userdata set knights = 0, fame = 0 where struserid = @char3
Update knights set vicechief_1 = '''' where vicechief_1 = @char1
Update knights set vicechief_2 = '''' where vicechief_2 = @char1
Update knights set vicechief_3 = '''' where vicechief_3 = @char1
Update knights set vicechief_1 = '''' where vicechief_1 = @char2
Update knights set vicechief_2 = '''' where vicechief_2 = @char2
Update knights set vicechief_3 = '''' where vicechief_3 = @char2
Update knights set vicechief_1 = '''' where vicechief_1 = @char3
Update knights set vicechief_2 = '''' where vicechief_2 = @char3
Update knights set vicechief_3 = '''' where vicechief_3 = @char3
delete from knights_user where struserid = @char1
delete from knights_user where struserid = @char2
delete from knights_user where struserid = @char3
commit tran
GO
Monsters Drops
update K_MONSTER_ITEM set iItem02 = ''İ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''
where sIndex = ''Monster''s sSid code''
Changeing items + from npc
update K_NPC set iSellingGroup = ' iSellingGroup No'
where strName = 'Npc Name'
页:
[1]