daniellk
12/01/2015, 10:43 PM
CTRL C+V
Olá, eu mesmo estava atrás desta query, como eu não encontrei então resolvi eu mesmo cria-lá
Está query depois de executa-da, todos personagens criados no servidor começaram
Com os status FUL ou com os pontos que você desejar.
Basta modifica-lá aonde desejar.
Citar
USE MuOnline
IF EXISTS (SELECT name FROM sysobjects
WHERE name = 'MUC_BONUS' AND type = 'TR')
DROP TRIGGER MUC_BONUS
GO
CREATE TRIGGER MUC_BONUS ON Dbo.Character FOR INSERT
AS
BEGIN
-- Bonus para Novos Chars --
DECLARE
@Resets INT,
@Pontos INT,
@Dinheiro INT,
@Forca INT,
@Agilidade INT,
@Energia INT,
@Vitalidade INT,
@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]
UPDATE Dbo.Character
[Only registered and activated users can see links]
[Only registered and activated users can see links]
END
Comando para retirar o Bônus
Citar
USE MuOnline
IF EXISTS (SELECT name FROM sysobjects
WHERE name = 'MUC_BONUS' AND type = 'TR')
DROP TRIGGER MUC_BONUS
GO
Créditos :
Viciadosmu - Query original
Olá, eu mesmo estava atrás desta query, como eu não encontrei então resolvi eu mesmo cria-lá
Está query depois de executa-da, todos personagens criados no servidor começaram
Com os status FUL ou com os pontos que você desejar.
Basta modifica-lá aonde desejar.
Citar
USE MuOnline
IF EXISTS (SELECT name FROM sysobjects
WHERE name = 'MUC_BONUS' AND type = 'TR')
DROP TRIGGER MUC_BONUS
GO
CREATE TRIGGER MUC_BONUS ON Dbo.Character FOR INSERT
AS
BEGIN
-- Bonus para Novos Chars --
DECLARE
@Resets INT,
@Pontos INT,
@Dinheiro INT,
@Forca INT,
@Agilidade INT,
@Energia INT,
@Vitalidade INT,
@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]
UPDATE Dbo.Character
[Only registered and activated users can see links]
[Only registered and activated users can see links]
END
Comando para retirar o Bônus
Citar
USE MuOnline
IF EXISTS (SELECT name FROM sysobjects
WHERE name = 'MUC_BONUS' AND type = 'TR')
DROP TRIGGER MUC_BONUS
GO
Créditos :
Viciadosmu - Query original