Data inscrierii: 13/Apr/2007 Mesaje: 1416 Localitate: www.muzone.myforum.ro
Trimis: 06/09/2007 18:33 Titlul subiectului: How to make the new character to start with bonus points
CONFECțIONATE 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?
Nu puteti crea un subiect nou in acest forum Nu puteti raspunde in subiectele acestui forum Nu puteti modifica mesajele proprii din acest forum Nu puteti sterge mesajele proprii din acest forum Nu puteti vota in chestionarele din acest forum