Release Guide: Adding drops

*HellFire* · 07:33 AM

Ok well this is just an simple guide with no screenshots or anything.
If u can understand english, then it shouldn't be a problem.

Ok lets say we want to add a Silver Bar to cardinal, with: 60% drop rate.

Lets go into Query Analyzer.
paste the following code:

Code:

UPDATE K_MONSTER SET sItem='113'
WHERE strName Like 'Cardinal'

the sItem is linked to the table K_MONSTER_ITEM. Look below to see why.

Ok now we want to get the id of the silverbar.
Well i mostly use the Drop Editor of Qwerty to get all Id's.
note: dont use qwerty's editor for the actual editing, itll mess up ur drops since u got MAKE_ITEM_GROUP.
Ok so using his drop editor i found out the id is:

Code:

379067000

We dont need the id of cardinal, we already linked it to sItem

Code:

Now open up K_MONSTER_ITEM, now u see 11 columns.
the first one sindex must contain the sItem in this case its 113 for cardinal.
The 2nd column until sPersent02 is only for MAKE_ITEM_GROUP wich im not going to explain, since its way difficult.

Ok now in iItem03 put:

Code:

379067000

sPersent03 should be:

Code:

<- 60% chance to drop.
100 = 1%.

Leave the other columns null, or do the same as 03 to add more items.

Now for the lazy people a simple query to do it all in 1 click.

Code:

UPDATE K_MONSTER SET sItem='xxx'
 WHERE strName Like 'monstername'

Code:

INSERT INTO [KN_online].[dbo].[K_MONSTER_ITEM]
           ([sIndex]
           ,[iItem01]
           ,[sPersent01]
           ,[iItem02]
           ,[sPersent02]
           ,[iItem03]
           ,[sPersent03]
           ,[iItem04]
           ,[sPersent04]
           ,[iItem05]
           ,[sPersent05])
VALUES(xxx,NULL,NULL,NULL,NULL,itemid,persent,itemid,persent,itemid,persent)

I advise to use this query.

Code:

DELETE from MAKE_ITEM_GROUP

and this one;

Code:

DELETE FROM K_MONSTER_ITEM

the reason is because its much better if you make all drops by hand, so u can be sure there arent monsters who are bugged, or like bosses who drop like smitehammer+10 100% rate.
etc just an example.

i hope u found this guide usefull.

-ceelen1 aka HellFire

*HellFire* · 10-19-2008, 10:31 AM

so is this guide usefull?

vipsarnius · 10-19-2008, 12:03 PM

Thanks. Ill use this guide to help me when I get my server going :)

w00tang · 10-29-2008, 04:40 AM

100 = 1%

RaGEZONE is proudly sponsored by