Prima data intram in Start->Programs->Microsoft SQL Svr->Enterprise Manager dupa care alegem Data Base MuOnline si dai click sus pe Tools si clic pe SQl Query Analyzer,si o sa apara o fereastra noua si pui codul urmator:
Cod: CREATE TRIGGER [prevent_DL] ON [dbo].[Character] FOR INSERT AS --declarations of variables DECLARE @Acc varchar(10), @Max INT, @Min INT SET @Min = 300 DECLARE LISTA CURSOR LOCAL FOR SELECT AccountID FROM INSERTED WHERE (Class=64) OPEN LISTA FETCH NEXT FROM LISTA INTO @Acc WHILE @@FETCH_STATUS = 0 BEGIN SET @Max = (SELECT MAX(cLevel) FROM [Character] WHERE (AccountID=@Acc)) IF (@Max < @Min) --if his max level is less than our minimun requiered: KILL! BEGIN ROLLBACK TRANSACTION END FETCH NEXT FROM LISTA INTO @Acc END --gracefully ending the procedure CLOSE LISTA DEALLOCATE LISTA
DL ramane la alegerea voastra de ce Lvl vreti sa-l faceti Exclamation
Cod: SET @Min = 300
300 e level-ul...Deci se poate schimba in functie de preferintele fiecaruia Razz Dupa introducerea codului apasati F5 pentru a salva modificarile.
Succes study
Asa faci DL de la ce LvL vrei – poza de Vipera, in ^Tutoriale^ · 10.2KB
