[Query] Bonificação de Golds ou Cash

Salve Vim trazer a Query de Bonificação de Gold ou Cash so basta saber alterar !!

Gold

Citação:

---

USE [MuOnline]
DECLARE @ConnectStat tinyint
DECLARE @memb___id varchar (10)
SELECT @memb___id=memb___id,@ConnectStat=ConnectStat FROM memb_stat WHERE ConnectStat=1
UPDATE MEMB_INFO SET GOLD=GOLD+15 where memb___id=@memb___id

---

RESET

Citação:

---

USE [MuOnline]
UPDATE Character SET Resets=Resets+15 FROM Character INNER JOIN
AccountCharacter ON Character.Name = AccountCharacter.GameIDC INNER JOIN
MEMB_STAT ON MEMB_STAT.memb___id = AccountCharacter.ID
WHERE ConnectStat=1

---