Dodatki Na Start

anxumanum

Wystarczy wlaczyc QA i wpisac

Dodawanie pkt na start:

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

Usuwanie pkt na start:

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

Kasa na start:

CREATE TRIGGER [Add_zen] ON dbo.[Character]
after Insert
as
Update [Character] set [Character].Money=500000 From Inserted
Where Inserted.Money = 0 and [Character].accountid=inserted.accountid
and [Character].name=inserted.name

nastepnie zatwierdzic naciskajac F5 i nie zapisywac