NoStres Team
Bine Ati Venit pe forumul nostru.Distractie Placuta
|
Nou pe simpatie:
ramonaa86
 | Femeie
25 ani
Brasov
cauta Barbat
31 - 46 ani |
|
|
NoStres TeamReguliInregistrareLoginPozeNu sunteti logat. Lista Forumurilor Pe Tematici
|
| #1 |
 ViperaMembru nouDin: Timisoara
Postari: 25
|
|
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
10.2KB
|
|
| |
|
