挑战上线自动送点卡.商城币.和查询GM号SQL执行语句

EGameol · 发表于 2023-11-5 16:40:44

本帖最后由 EGameol 于 2023-11-5 16:41 编辑

上线送时间
用查询分析器必须在billing执行

CREATE TRIGGER [free] ON [dbo].[user_account]7 ^) O& N" v5 L1 ?9 |- F
after Insert
, j) c/ P t1 z
as' |! u: s: G* D7 _" P; l
Update [user_account] set
s% N) x4 z- p% n
[user_account].remain_time =999999,remain_freetime =999999,expire_freetime =2999-1-9
" H9 b- j8 x% k
From Inserted; v4 \4 E5 V9 ^4 E* c
Where [user_account].user_id=inserted.user_id
4 k" V5 m6 h: A7 Y! }
and [user_account].group_id=inserted.group_id
* s7 h' i8 K. X5 l+ _
update user_account set remain_time =999999,remain_freetime=999999,expire_freetime=2999-1-9& [* A1 P' K# F' j
where expire_freetime =2006-1-9

复制代码

上线送商币
用查询分析器必须在 cash

CREATE TRIGGER [free] ON [dbo].[user_cash] ' }: ~- \+ |& u& y# j+ S: [5 D
after Insert
# c. m3 f' D- p/ e$ i o
as
. I4 O4 `+ |% S+ \
Update [user_cash] set [user_cash].amount=900000000,free_amount=900000000
v) i' V$ F" i
From Inserted
( {) G) {& Q+ V( O6 e
Where [user_cash].group_id=inserted.group_id 8 _/ ~- O/ g3 w; Q% _
and [user_cash].id=inserted.id( f% u/ G5 M" j. I2 K0 e

复制代码

查询GM号

复制代码

		自动登录	找回密码
密码			立即注册

[技术文章] 挑战上线自动送点卡.商城币.和查询GM号SQL执行语句