SHStudio Changing Drops

[driesy1]

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

[STIV123]

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?

[driesy1]

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

[treica]

Add in dbo.MobItems the drops columns...

[JohnHeatz]

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"

[driesy1]

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??)

[ShaiyaOmega]

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.

[driesy1]

i use the sql server management studio

[treica]

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.

[driesy1]

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

[treica]

what grades are you using to drop?
you have to use from 1 to 999 if the item were 1000 - + will not drop any.

[driesy1]

ooo tru thats my problem thnx heap

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