monster.sql

[Dread123]

hi i ran into a problem 1st my dbo.mobitems table dissapeared so i decided to change the db i got all the files working ingame except when i run the monster.sql in the db it comes up with number of row(s) affected. ive tryed multiple sql and nothing works.

if anyone could help would be appreciated

[TeddyBear94]

u may have the probs of bug mobs in ur monster.sdata. 8 i guess u got ep 5 and ep 6 mobs added)
way of fixing that :
u open monster.sdata in sh studio and click on show all colums then go down to mob id 3000.
and u have to check all the mobs up to 3600 if there are any double numbers.
deleate the ones that have no hp and skill and so on and leave the right mobs
after u deleate all these bug mobs u should be fine and ur quiery should be succesfully!

[Dread123]

ok ive wiped out all the buged mobs with 0 hp...which were all mobs wit weird spelt names...but i still get the problem 1 row(s) affected.

Yes i have ep5 and 6 mobs.

also getting this problem now

Msg 220, Level 16, State 1, Line 23
Arithmetic overflow error for data type smallint, value = 71792.

[TeddyBear94]

well u may deleate 1 mob to much

[Dread123]

so its only mobs with 0 hp between mob id 3000 to 3600

[TeddyBear94]

well soemtimes the name bug mob is used for a norm mob aswell so if u deleted that one aswell there is ur problem