xtchabsx
19/07/2019, 09:54 PM
ola pessoal! estou querendo remover uma tg em meu db, mas tenho a duvida de como faco para fazer com que os personagens, ao criar, peguem os atributos padrão, pq tentei remover e os personagens continuam vindo full ao criar. obg a todos.
segue o tg
USE [MuOnline]
GO
DROP TRIGGER [dbo].[CRIAR_CHAR]
GO
CREATE TRIGGER [dbo].[CRIAR_CHAR] ON [dbo].[Character] FOR INSERT
AS
BEGIN
-- Bonus para Novos Chars
DECLARE
@Level INT,
@Resets INT,
@Pontos INT,
@Dinheiro INT,
@Forca INT,
@Agilidade INT,
@Vitalidade INT,
@Energia INT,
[Only registered and activated users can see links]
@Char varchar(10)
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
UPDATE Dbo.Character
[Only registered and activated users can see links]
[Only registered and activated users can see links]
UPDATE Dbo.Character
[Only registered and activated users can see links]
[Only registered and activated users can see links]
END
segue o tg
USE [MuOnline]
GO
DROP TRIGGER [dbo].[CRIAR_CHAR]
GO
CREATE TRIGGER [dbo].[CRIAR_CHAR] ON [dbo].[Character] FOR INSERT
AS
BEGIN
-- Bonus para Novos Chars
DECLARE
@Level INT,
@Resets INT,
@Pontos INT,
@Dinheiro INT,
@Forca INT,
@Agilidade INT,
@Vitalidade INT,
@Energia INT,
[Only registered and activated users can see links]
@Char varchar(10)
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
UPDATE Dbo.Character
[Only registered and activated users can see links]
[Only registered and activated users can see links]
UPDATE Dbo.Character
[Only registered and activated users can see links]
[Only registered and activated users can see links]
END