[How To]Edit Mob Drops

I've seen a few people asking about this. Its pretty easy really but ill post a quick tutorial here just for people:

1. Find the grade of the item you want to have drop (you can find this in the item list you can download off here)
2. Once you have the grade, find the ID of the mob you want the item to drop off (you can find this in the mob list)
3. Once you have these two numbers, go into your SQL, expan GameDefs database, right click MobDrops and click open.
4. Once you are in the MobDrop table, search for the MobID (you can use an SQL script or just use the scroll bar) and enter the grade number you found previously in the grade table and enter the drop rate.
5. If you want to add multiple drops to a single mob then you can, there are a few spaces on the same mob, all you have to do is change the grade number on each row.

Hope this will help.

friends do not understand, I put the large modems and when I want to kill the mobs with no drops dr grad epuesto strip anything

and a double post....:facepalm:

Where can i find the item grade? I've got the Item Id list from this forum, but there are only :

ItemID ItemName Type TypeID

... ... ... ...

u can find them either on AriezOMG's ID list or, on ur database on PS_GameDefs.dbo.Items, there are all the grades of every item, just look for it, if ur too lazy just do something like

SELECT Grade FROM dbo.Items

and it will just show u the grades, or something like....

SELECT ItemName, Grade FROM dbo.Items

and it will show u the name of the item and its grade or simply if ur looking for an specific item's grade u do this

SELECT Grade FROM dbo.Items WHERE ItemName = [here would be the name of the item ur looking for]

and thats it, hope this SQL 1.0.1 lesson has helped u :p

Quote:

Originally Posted by JohnHeatz SELECT Grade FROM dbo.Items SELECT ItemName, Grade FROM dbo.Items SELECT Grade FROM dbo.Items WHERE ItemName = [here would be the name of the item ur looking for]

To use the database name in that context, you need to addd "USE PS_GameDefs" before the query. For example:

Thanks guys :)

can any1 give me Item list / Mob list? cant find them , thnx for help

It's called the search box at the top of this webpage. It'll help you find that list.

Always helpfull this threads thx guys :)

Quote:

Originally Posted by Pan15[GS] can any1 give me Item list / Mob list? cant find them , thnx for help

I think the best way to get Items/Mobs ID list is:
-use Shaiya Data File Tool, open data.sah, extract Item.SData and Moster.SData
-after u done this use shShaiya Studio and open Item.SData or Moster.SData
-now u have all Item/Mob ID that exist in ur DB

Thanks To ADAM for threth

Please don't push oudated threads. Make a new thread for your question.

#closed