Asa Faci DarkLord(DL) La Ce lvl Vrei !

Lord_DL

Pentru a face DarKLorD la ce lvl urmareste pozele ....
Intratzi in Start > All Programs > Microsoft Sql Server > Enteprise Manager
[url=http://xs.to] Asa Faci DarkLord(DL) La Ce lvl Vrei ! Asa Faci DarkLord(DL) La Ce lvl Vrei !

Asa Faci DarkLord(DL) La Ce lvl Vrei ! Asa Faci DarkLord(DL) La Ce lvl Vrei !

[/url]
Acum alegetzi data de baza "MuOnline" din stanga si apoi selectatzi Tools > Sql Querry Analyzer ...

[url=http://xs.to] Asa Faci DarkLord(DL) La Ce lvl Vrei ! Asa Faci DarkLord(DL) La Ce lvl Vrei !

[/url]
Va va aparea o fereastra noua deskisa ca aceasta ...

[url=http://xs.to] Asa Faci DarkLord(DL) La Ce lvl Vrei ! Asa Faci DarkLord(DL) La Ce lvl Vrei !

[/url]
Dupa ce va aparut fereastra cea noua copiatzi codul de mai jos acolo ...

Cod:

Lord_DL a scris:

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

Pentru a transforma lvl la care vrei sa faci DL`u cauta in codul acela SET @Min = 300 300 fiind lvl`ul ...
Dupa ce atzi facut tot datzi un F5 close si NO SAVE !!
[url=http://xs.to] Asa Faci DarkLord(DL) La Ce lvl Vrei ! Asa Faci DarkLord(DL) La Ce lvl Vrei !

[/url]
Gata Treaba