- exemplo.: Galera se bater o recorde este final de semana todos
que tiver online iram ganhar 5 dias vip.
Querys analyzer, basta executar no query analyzer do SQL Server na database muonline.
________________________________________________
Resets
Use MuOnline DECLARE @ConnectStat tinyint DECLARE @memb___id varchar (10) SELECT @memb___id=memb___id,@ConnectStat=ConnectStat FROM memb_stat WHERE ConnectStat='1' UPDATE Character SET Resets=Resets+15 where AccountID=@memb___id
________________________________________________
Vip
________________________________________________
Vip
Use MuOnline DECLARE @ConnectStat tinyint DECLARE @memb___id varchar (10) SELECT @memb___id=memb___id,@ConnectStat=ConnectStat FROM memb_stat WHERE ConnectStat='1' UPDATE Character SET vip=vip+15 where AccountID=@memb___id
________________________________________________
Gold________________________________________________
Use MuOnline DECLARE @ConnectStat tinyint DECLARE @memb___id varchar (10) SELECT @memb___id=memb___id,@ConnectStat=ConnectStat FROM memb_stat WHERE ConnectStat='1' UPDATE Character SET gold=gold+15 where AccountID=@memb___id
________________________________________________
OBS:Se a query de gold não funcionar tente este código abaixo:________________________________________________
Use MuOnline
DECLARE @ConnectStat tinyint
DECLARE @memb___id varchar (10)
SELECT @memb___id=memb___id,@ConnectStat=ConnectStat FROM memb_stat WHERE ConnectStat='1'
UPDATE DT_SHOP_CREDITS SET credits=credits+15
________________________________________________DECLARE @ConnectStat tinyint
DECLARE @memb___id varchar (10)
SELECT @memb___id=memb___id,@ConnectStat=ConnectStat FROM memb_stat WHERE ConnectStat='1'
UPDATE DT_SHOP_CREDITS SET credits=credits+15
Para esse codigo acima Rodar Use a Web Dark Team
Premiando quem está online so mude o número 15 para seu número desejado
Créditos: AjudaMuOnline
