Monster.sdata

04/26/2011 01:24 TacticalNukez#1
in SHstudio guide it says you can access a file called monster.sdata i need it to edit drops cuz idk how in SQL will someone help me please
04/26/2011 11:24 IonutTheDawg#2
It's easier to edit the drops from dbs. :
04/29/2011 13:12 adamkoolkid23#3
editing drops is one of the easiest things to do.

I'll give you a quick run down:

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.
07/17/2011 20:34 Xiolinkimiko#4
Quote:
Originally Posted by adamkoolkid23 View Post
editing drops is one of the easiest things to do.

I'll give you a quick run down:

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.
New post on Old Topic but nvm, this is what i get when im into the SQL dbo.MobItems, this is the interface i get.

[Only registered and activated users can see links. Click Here To Register...]

So it looks extremely simple to put one item onto a mob, but I cant seem to locate another box that i can put a seccond item in? Help plz
07/17/2011 21:28 JohnHeatz#5
If you see, there are 9 different rows with for every MobID, they are identified by ItemOrder. Each of those is one "slot" for the mob to have stored an item to be droped, so you just have to use this:

Code:
Use PS_GameDefs
Update dbo.MobItems set Grade = [Grade of the item to drop], DropRate = [Drop Rate that you want for the item] where MobID = [ID of the mob you want to drop the item]
07/17/2011 21:41 castor4878#6
as it is, this statement is incorrect - you very likely don't want to obtain what it does.

you certainly wanna perform:

where MobID=<id> and ItemOrder=1
07/17/2011 21:49 Xiolinkimiko#7
Quote:
Originally Posted by JohnHeatz View Post
If you see, there are 9 different rows with for every MobID, they are identified by ItemOrder. Each of those is one "slot" for the mob to have stored an item to be droped, so you just have to use this:

Code:
Use PS_GameDefs
Update dbo.MobItems set Grade = [Grade of the item to drop], DropRate = [Drop Rate that you want for the item] where MobID = [ID of the mob you want to drop the item]
/facedesk Im such an idiot! Thanks though :$

EDIT:How do i make the Maximum Worship for 1-15 into Dread ?

Also In this picture
[Only registered and activated users can see links. Click Here To Register...]
Do i change all the Item Orders to 1 and 100 for DropRate and use AriezOMG's ID List to get the Grades and put them in??
07/17/2011 22:49 JohnHeatz#8
Quote:
Originally Posted by castor4878 View Post
as it is, this statement is incorrect - you very likely don't want to obtain what it does.

you certainly wanna perform:

where MobID=<id> and ItemOrder=1
Yeah, sorry forgot to put on which "slot" you are adding the drop plus its droprate, ty for that Castor.

Quote:
Originally Posted by Xiolinkimiko View Post
Do i change all the Item Orders to 1 and 100 for DropRate and use AriezOMG's ID List to get the Grades and put them in??
No, you would need to be changing the ItemOrder to the one you are changing, for example:

Code:
Use PS_GameDefs
Update dbo.MobItems set Grade = [Grade of the item to drop], DropRate = [Drop Rate that you want for the item] where MobID = [ID of the mob you want to drop the item] and ItemOrder = [slot you are updating]
If you wanted to change/add a drop on MobId = 2008 on the drop number 4 you would just have to do:

Code:
Use PS_GameDefs
Update dbo.MobItems set Grade = [Grade of the item to drop], DropRate = [Drop Rate that you want for the item] where MobID = 2008 and ItemOrder = 4
And so on to be changing every drop for that mob; remember that if you just dont add any grade nor droprate that slot is not going to be used so that mob is just going to drop the ammount of items that you used, so not necessarily you have to use all of them, yet, you can do so
10/11/2011 10:48 viper4513#9
Take a look for Banes ep5 database, use the search, it's around here somewhere. Stickied i think.
01/04/2012 13:16 alexandere99#10
TacticalNukez Do you Need GS or GM's Couse i have played Shaiya OS for 3 Years and Private servers for 1 Year Tell if you need me :) :confused: