[HELP]

02/03/2012 16:20 Murik13#1

Hello guys any can help how add drops in sql i mean what are the MobId And Grade what need write in grade and how know MobId what are the mob..

----------------------------------
Sorry For English

02/03/2012 16:59 JohnHeatz#2

This is something quite basic...

To get to know the MobID of any mob, just do this:

Code:

Use PS_GameDefs
Select mobname, mobId from dbo.Mobs where Mobname like  '%[name]%'

That will bring you the exact name and it's ID.

Now, for the grade ofthe items you do the same:

Code:

Use PS_GameDefs
Select itemname, grade from dbo.Items where Itemname like  '%[name]%'

Done this you have the MobID of the mob you want to add the drop to, and the grade of the item you want this mob to drop, so basically all what is left is add the item as drop to the mob....

Code:

Use PS_GameDefs
Update dbo.MobItems set Grade = [item_grade], DropRate = [%] 
where MobID = [mob_id] and ItemOrder = [number 1-9]

With this you have successfully added the item to be dropped by the mob you selected with a specific droprate.

02/04/2012 08:07 Murik13#3

But i am do all right but no drop why? it depends from maps ep5?

02/04/2012 16:59 JohnHeatz#4

Restart the server after you do changes on drops

02/04/2012 17:12 Murik13#5

Nope Not Work

02/04/2012 17:55 JohnHeatz#6

The you are doing something wrong, because all that is needed to update drops is the last query I put in there:

Code:

Use PS_GameDefs
Update dbo.MobItems set Grade = [Grade], DropRate = [%] 
where MobID = [Mob] and ItemOrder = [number_from_1_to_9]

After this that mob will be dropping all the items on the grade you put in there with the drop rate that you input (remember there are always more than 1 item on each grade)

02/04/2012 21:53 Murik13#7

No not work...