Cum Faci sa creezi un dl la ce lvl vrei

Deci intri in Enterprise Manager

Acuma alegi Data Base MuOnline si dai clic sus pe Tools si clic pe SQl Query Analyzer

Acuma o sati apara o fereastra noua.Si pui urmatorul cod in acea fereastra

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


Acuma depinde la ce level vrei sa faci DL Cod:
SET @Min = 300

300 e level-ul...Deci shcimbi tu
Dupa ce ai pus codul apesi odata pe F5 si gata