SHStudio Changing Drops

07/03/2012 07:40 driesy1#1
Hey ive been able to change drops for bosses in KI and all mobs in KI but im unable to change or make drops on any bosses that sit in DC or caput.... i place my grade in the area needed set the %rate and click set and nothing happens



Any help please
07/03/2012 08:56 STIV123#2
You sure you typed good "Group Drop" (when adding the drop) ?

You Sure you have runned your monster.sdata.sql in your SQL?

You sure you restarted your server after all?
07/03/2012 08:59 driesy1#3
the problem is in shstudio i cant put any drops on the bosses they havent got drops on them at all and i can put any on them but i can do every other mob/bosses
07/03/2012 12:39 treica#4
Add in dbo.MobItems the drops columns...
07/03/2012 17:13 JohnHeatz#5
Why don't you add the drops on the database?

Just a simple update query on the PS_GameDefs.dbo.MobItems just find the ID of the mobs and you will be able to update the drops from them, no possible way on it "not working"
07/04/2012 05:52 driesy1#6
i sorted the mobs i add the Exmonster.sdata to it n i was able to. i dont use the database coz for some reason the only ammont of mob ids i can find is up to 1000 so i use shstudio to do it pritty simple and u jus run the sql then patch it and its all done.


im having one other problem i patched in the ep6 mobs but they dont come up in shstudio im using the data.sah that is patched in my client and i open monster.sdata and then import mob.csv and mobitem.csv and the mobs that come up are up to ep 5.3 no ep6 mobs are listed anyone no why (maybe i patched them in wrong??)
07/04/2012 10:38 ShaiyaOmega#7
Do you use MSSql Maestro to access your databse? I Use That and it only displays the first 1000 entries until i tell it to show all.
07/04/2012 11:56 driesy1#8
i use the sql server management studio
07/04/2012 12:28 treica#9
You have to go to Tools > Options > Sql results and there somewhere is to change ..and i don't remember exactly where but can be modified to make it display you more results if you use 2008 sql management studio.
07/04/2012 17:57 driesy1#10
ok im sticking with SHstudio DB dont lik me at all. my problem now is that ive set the drops on The PR mobs i want to drop items and the golems in KI but they dont drop at all there set at 25% and 50%. i also set the Ki ele bosses and ele guards and starter mobs and they all drop but the PR mobs and golems dont drop at all any ideas
07/04/2012 18:06 treica#11
what grades are you using to drop?
you have to use from 1 to 999 if the item were 1000 - + will not drop any.
07/04/2012 20:00 driesy1#12
ooo tru thats my problem thnx heap :D

but i got a problem im editing the item mall now Cash.sdata now i edited wat i needed to for now but when i run the SQL it comes up wit this problem
[Only registered and activated users can see links. Click Here To Register...]