[Guide] 0.99.6XT Fix: Stats back to 0

View previous topic View next topic Go down

[Guide] 0.99.6XT Fix: Stats back to 0

Post by  on Fri Jan 11, 2008 3:46 am

Well, some users on my server told me about them stats back to 0, well then I started check my tables on MU database and I found this trigger on my character table:

CREATE TRIGGER [PuntosCero] ON [dbo].[Character]
FOR INSERT
AS
UPDATE CHARACTER SET LevelUpPoint=0

This trigger means when anybody create 1 char that trrgger will be activate and all char change them stats to zero again LOL.
If you have that problem just edit that trigger:

CREATE TRIGGER [PuntosCero] ON [dbo].[Character]
FOR INSERT
AS
UPDATE CHARACTER SET LevelUpPoint=0 where Experience=0

That fix this problem. If you want, you can edit that trigger only for inserted record or number of resets=0... finally wherever you want.


Favourite Game : MuOnline
Registration date : 1969-12-31

View user profile

Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum