MateiMu version 97d old schol ~ Cum faci ca un nou caracter sa aiba bonus de puncte

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 de aici: Update [Character] set [Character].LevelUpPoint=300
From Inserted 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)
- Execute Query (F5) Ok
Merge 100%