NaRuTo'
Special Jounin
Data inscrierii: 18/Feb/2008
Mesaje: 124
Localitate: Bucuresti
|
 Trimis: 18/02/2008 04:01 Titlul subiectului: Asa faci DL la ce level vrei tu |
 |
|
Deci intri in Enterprise Manager->
Acuma alegi Data Base MuOnline si  i clic  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
300 e level-ul...Deci shcimbi tu
Dupa ce ai pus codul apesi odata pe F5 si gata
e prea usor 
_________________
By NaRuTo     |
|
