[Question] Mob Drops

04/07/2012 18:00 liston28727#1
I have an EP5+ server working.. in the later maps "68+" the mobs are not dropping items.. Example Desiree i have set the Justia gear to drop at 100% for a test. Nothing drops. Any ideas why these drops are not working.. and yes i have the mob_items set in the database..
04/07/2012 19:01 RebeccaBlack#2
You say you have the MobItems set? Did you restart once you did that?

What are the grades to the items? Are they 999+?

Cross reference the mob names in your database, with the grades and IDs and make sure you didn't accidentally set the wrong number or something.

Another thing I found, if the executable finds any missing data between drops (i.e. for mob 2023 you have Grade1=0,Grade2=0,Grade3=40) that it'll just abandon the mob's drops.
04/07/2012 19:46 liston28727#3
yes some if the grades are 999+..
I have restarted the server both in msql and shaiya server with no results.
I have been using the mobs in Top ruins and Desiree the boss, Desiree has drop 1,2,and 3 with items then 4and 5= 0 then 6,7,8 and 9 have items. I have move the Justia drop to #1 at 100% hoping to at least see a drop. The gold drop is intermittently working.
04/08/2012 00:57 dirksen95#4
as im informed, grades over 999 dont work, so try to edit the grades to like 948 for lv69 gear etc and then try it again, got same problems on another server where i'd been AD-A and it worked when i edited it to grades under 1000, please try it out and then tell us if it worked
04/08/2012 03:28 sondo81#5
Ok !

Use this script :

create table #a (num int)
declare @i int
set @i=0
while @i < 999
begin
set @i=@i+1
if not exists (select * from ps_gamedefs.dbo.items where grade = @i)
insert #a select @i
end
select * from #a

Thanks to Zargon!

To find free Grade!

Use only Grades under 999!!!!

For drop 6 - 9 use this :

[Only registered and activated users can see links. Click Here To Register...]
04/09/2012 03:21 liston28727#6
Thanks all,, I changed the grades over 999 to unused grades under 999, all is working well now, i edited the dbo_Items and the dbo_MobItems grades.. Now for the server notices, if anyone knows how to edit them, example "When i take the relics in KI to open the pvp portal to PR the notice "Now open the way to PR" dosent come up.. After that will start working on the mystery of the EP5 skills..
08/02/2012 15:16 alin12345#7
How i can set Drop 0 on all mobs/boss
08/02/2012 15:44 TeddyBear94#8
Quote:
Originally Posted by alin12345 View Post
How i can set Drop 0 on all mobs/boss
open the monster.sdata and go into every mob which is in there open the drop bar and u see the drop grades then click on the grade u dont want to have for that mob and press CLR and the grade disappers and the mob stops droping that ( what was in that grade placed in item.sdata.
08/02/2012 23:19 Bаne#9
Grades over 999 just don't work, common grades are multiples of 10.