That seemed important

Reading helps :p Serious bizarre, eh?

Well, for some reason while redoing the database schema I never thought it necessary to really restrict the house ownership to one per realm per account and due to some weirdness some circumstances can allow you to have multiple houses. Combine that with "your house" being set on each restart and the house loading order being random and your lot can change from reboot to reboot.

Probably more hilarious but also quite serious when I first introduced npc reuse, this actually had two parts, the first one was rather terrifying: npc equipment wasn't reset when a different model / npc was made, this quickly made all sorts of mobs appear with the redcap or other weapons. Especially nice when the weapon is then actually visible on the client on some animals. The second part was super similar but this time with active pulse spells not being reset leading to then recently introduced darkspire pulse spells, like damage, amnesia or silence, to appear on any respawned mob including level 1 mobs.

Super serious and bizarre was a somewhat recent issue where random bonuses could permanently apply to your item and even overwrite existing bonuses, although it usually "only" overwrote those other random bonuses. To not break templates we even kept the existing bonuses which is why you can find some items with 2x the same bonus on it. The reason here was rather stupid and technical and basically when writing your own database library don't assume you will never encounter numbers above 10 in the field name (e. g. bonus_type10, bonus_value10, bonus_type11 etc) and now it lead to items with bonus 10 set to apply this bonus to all items that were updated in the same batch. This was kind of the result of an optimization, before we had an unlimited amount of bonuses on items but in a separate table, the optimization now pulled them all back into the items table and since there was already a handful of rogs with up to 14 bonuses that's how many fields are there now.