You are correct bud9weiser, however the frequency of the disconnects can be worked around by fixing bad data in the database. The client crashes in 5.3 DR2 appear to be happening whenever your character dies, so your assumption is correct, it's a code problem. However I was frequently getting killed in one hit by several low level mobs which then caused the disconnect. This is happening because an inordinate amount of mobs have their maxdmg set to 400:
Code:
mysql> select count(*) from npc_types where maxdmg = 400;
+----------+
| count(*) |
+----------+
| 44854 |
+----------+
Compare that to all the other rows with maxdmg values other than 400:
Code:
mysql> select count(*) from npc_types where maxdmg <> 400;
+----------+
| count(*) |
+----------+
| 26922 |
+----------+
Also see the levels which have maxdmg above 400:
Code:
mysql> select distinct level from npc_types where maxdmg > 400;
+-------+
| level |
+-------+
| 255 |
| 60 |
| 66 |
| 61 |
| 65 |
| 62 |
+-------+
My recommendation for the next release of the db is to take the average of all the distinct maxdmg values for each level and do a mass update per level with the averages. Of course if you are able to get the "legit" damage ranges in there that will be even better.
EDIT: I realized the above should read "take the average of all the distinct maxdmg values other than 400"
Threaded Mode
