Dont use the trigger
Why?.. simple
Gameserver will not read that until you change character or log off.
The system workflow is:
1.- Read the inventory of each character to show them on character selection screen
2.- Read one more time all the stats at the moment of selection
3.- Only write (no read at all) data into character table on each exp change, level up, point added, inventory change, etc.
4.- Store one more time at log out or character change
as u can see.. it iwll not read your trigger changes while the character is online.
Here is my solution for u to try:
there is a procedure WZ_DISCONNECT_MEMB
this one will run on each Account Log Out to set all the fields and logs on the offline position so we can use that one inserting this at the end:
I dont recommend "on update" triggers on character table because those tables receibe so many updates during play so those triggers can add overheat and overheat will make your system not estable.
Hope it helps