Creating/Editing Items and Spells - Errors and Oddities

[Valorborn]

Disclaimer: For every single edit in my database I have consulted the EQEmu Database Schema Index.

This is an informational post only in the event I've found something that isn't working as intended. Of course If you've experienced any of these issues before and don't mind sharing a fix or work around it'd be appreciated but I think with a little more time in the database and on the forums all things shall be revealed.

Some things I've noticed:
1) The first time I 'clicked on edit' while trying to change the stats on a 'cloth cap' the database kicked back an "error: 200 text is okay" message, and resulted in 5 errors with MS Visual Studio while running the batch file. If I click on 'retry' items on my server will not load. If I cancel 5 times everything works as normal excluding the things below. If I do not click on edit but instead click inside the column box for the stat I can make changes and no errors occur while inside the database.

2) I added a worn effect of conviction to a necklace and then added to the starting items field. If I equipped the necklace the character would immediately fall on the ground unconscious. Their HP at level 1 would read 27/1300 or so and they would not regen past 27. If I ran another character up I could heal them full and they would stand up.

3) I changed Conviction from a worn effect to a click effect with out editing the spell itself. I was unable to cast it on any player (I received the character was not powerful enough error - even on a level 80), but I could cast it on any NPC.

4) I edited O'Klien's Radiation do 50 damage on the shield, and 100 to all stats, and last 10x longer. The damage shield area changed from 5 to 50, the FR bonus changed from 5 to 8, but no other resists where affected. Also the buff state it lasts 48 seconds but I would receive a spell interrupted error with 20-24 seconds left and the buff would disappear. If I closed my server with the buff on and then logged back in the duration would change to several minutes but not edit the resist fields, if I clicked it off and recast then it would be the 48 seconds as before.

5) Adding a regen or DS amount to any item that does not already have that effect will not work even though the item will list it in game.

6) Editing the regen on a fungi tunic to 60 hp worked, copying the fungi tunic and changing the item type to a charm did not change the item to a charm and the regen did not update to 60 even though it was copied with the value set to that. Though I did remove the negative dex/agi and add in sta which did reflect. This seems like an issue with copying items though.

7) I leveled a warrior to 80, deleveled him to 1 and just kinda messed with levels and augmented gear, eventually at level 1 he would dodge 99.9% of all attacks while naked and when he did get hit it was for a greatly reduced amount.


Ephron