Trigger – Itens para novos personagens separando classes

[yBatata 0]

CREATE TRIGGER BONUS_ITEM ON Dbo.CHARACTER FOR INSERT

AS

BEGIN

WAITFOR DELAY '00:00:03' -- aguardar 3 segundos

-- BONUS EM ITEMS

DECLARE @tipo int;

declare @Char varchar(10)

SELECT @Char = Name FROM INSERTED

SELECT @tipo = class FROM INSERTED

 

– Fazendo condição para gerar items

if (@tipo = 16) — BK SET BRONZE

BEGIN

WAITFOR DELAY ’00:00:01′

UPDATE Dbo.Character

SET inventory = 0x00CCFF000000005F8877CCCCFF000000007B7918E0CCFF000000005F295500

CCFF00000000DF855820CCFF00000000DF400740CCFF00000000DF186160CCFF00000000DF9270FF

FFFFFFFFFFFFFFFFFFA0CCFF00000000C00339AC84FF00000000802347A884FF00000000802165A8

84FF00000000809382FFFFFFFFFFFFFFFF

WHERE NAME = @CHAR

END

 

if (@tipo = 32) — ELF SET GUARDIAM

BEGIN

WAITFOR DELAY ’00:00:01′

UPDATE Dbo.Character

SET inventory = 0x81CCFF000000005F76758000140000000000FFFFEECCFF000000005F06060E

CCFF00000000DF00462ECCFF00000000DF73694ECCFF00000000DF60006ECCFF00000000DF8691FF

FFFFFFFFFFFFFFFFFFA0CCFF00000000C03881AC8CFF00000000808211A88CFF00000000807492A8

8CFF00000000807695FFFFFFFFFFFFFFFF

WHERE NAME = @CHAR

END

 

if (@tipo = 48) — MG SET UNICORN

BEGIN

WAITFOR DELAY ’00:00:01′

UPDATE Dbo.Character

SET inventory = 0x00CCFF000000005F8080C000160000000000FFFFFFFFFFFFFFFFFFFFFFFF0F

CCFF00000000DF01012FCCFF00000000DF94234FCCFF00000000DF75036FCCFF00000000DF0262FF

FFFFFFFFFFFFFFFFFFA084FF00000000801294AC84FF00000000802227A884FF00000000806405A8

84FF00000000805231FFFFFFFFFFFFFFFF

WHERE NAME = @CHAR

END

if (@tipo = 0) — SM SET PAD

BEGIN

WAITFOR DELAY ’00:00:01′

UPDATE Dbo.Character

SET inventory = 0x00CCFF000000005F3245FFFFFFFFFFFFFFFFFFFFE2CCFF000000005F286202

CCFF00000000DF330222CCFF00000000DF582142CCFF00000000DF421762CCFF00000000DF3798FF

FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFAC84FF00000000804192A884FF00000000802306A8

84FF00000000800624FFFFFFFFFFFFFFFF

WHERE NAME = @CHAR

END

 

END

 

Para remover:

 

DROP TRIGGER BONUS_ITEM

 

Testado em versão 97D. Caso dê erro de cursor inválido, instale o SQL SERVER 2000 SP4.

 

Créditos:

yBatata