i'm adding mobs and i use shtool.
the new mobs comes in both a sdata and csv file.
but anyway i need to add mobId 3005+ in the MobItems and insted of adding 3005 - 3100 manualy there has to be a way for sql to make that for you?
trying :
/*
Run the 2 lines below once to set start parameter
declare @MobId as int
set @MobId = 3006
*/
/* Inserting the first 9 lines for the first MobId */
insert into dbo.MobItems ()
select @MobId,1,0,0 -- MobId,ItemOrder,Grade,DropRate
insert into dbo.MobItems ()
select @MobId,2,0,0 -- MobId,ItemOrder,Grade,DropRate
insert into dbo.MobItems ()
select @MobId,3,0,0 -- MobId,ItemOrder,Grade,DropRate
insert into dbo.MobItems ()
select @MobId,4,0,0 -- MobId,ItemOrder,Grade,DropRate
insert into dbo.MobItems ()
select @MobId,5,0,0 -- MobId,ItemOrder,Grade,DropRate
insert into dbo.MobItems ()
select @MobId,6,0,0 -- MobId,ItemOrder,Grade,DropRate
insert into dbo.MobItems ()
select @MobId,7,0,0 -- MobId,ItemOrder,Grade,DropRate
insert into dbo.MobItems ()
select @MobId,8,0,0 -- MobId,ItemOrder,Grade,DropRate
insert into dbo.MobItems ()
select @MobId,9,0,0 -- MobId,ItemOrder,Grade,DropRate
/* Changes the parameter to current value +1 */
set @MobId = @MobId +1
but well it don't work hehe. anyone have a better idea to what i should run for it to make all the mobitems lines? 3005-3100 with 1-9 for the droprate?
if this is posible in the shtool tell me that too please.
 |
