MuZone Forum

vlad

CREATE TRIGGER [Update_IntLUP] ON [dbo].[Character]
after Insert
as
Update [Character] set [Character].LevelUpPoint=300
From Inserted
Where Inserted.LevelUpPoint=0 and
[Character].accountid=inserted.accountid
and [Character].name=inserted.name

* Change 300 from here : Update [Character] set [Character].LevelUpPoint=300
From Inserted with any number that you want

How to instal:
- Start>Run>Microsoft SQL Server>Query Analyzer
- Dai sus pe MuOnline
- Bagi scriptul in chenaru ala
- Parse Query (Ctrl+F5)
- Execute Query (F5) Ok

guilde made by dannySM (ro) and ro by [color=green]by vlad
_________________
CaN u HaCk ThE ReAl WoRlD?

How to make the new character to start with bonus points How to make the new character to start with bonus points

How to make the new character to start with bonus points How to make the new character to start with bonus points