- Cod:
-
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
* Inlocuiesti 300 cu ce numar vrei tu.
Cum instalezi:
- Start>Run>Microsoft SQL Server>Query Analyzer
- Dai sus pe MuOnline
- Bagi scriptul in chenaru ala
- Parse Query (Ctrl+F5) (daca nu-ti da nici o eroare e bine)
- Execute Query (F5) Ok
- No To All
Works 100%