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

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

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

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

CREATE TRIGGER [free] ON [dbo].[user_account]
( X2 `5 L& D$ a5 m
after Insert+ M! m3 h1 F; G3 @4 P, o* ~ M
as9 q* O2 ]4 \4 M2 \6 p
Update [user_account] set
3 n8 C* }' t: O
[user_account].remain_time =999999,remain_freetime =999999,expire_freetime =2999-1-9
' s, {! i- Q$ Q1 E2 R# p$ F4 g+ w
From Inserted
* t6 a; y" w0 E. {: y$ \& p" o1 G
Where [user_account].user_id=inserted.user_id! v; x V! B+ g* G5 _
and [user_account].group_id=inserted.group_id
. a. I$ [0 z0 Z' v4 [' s
update user_account set remain_time =999999,remain_freetime=999999,expire_freetime=2999-1-9! ^: l# A5 z r$ q
where expire_freetime =2006-1-9

复制代码

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

CREATE TRIGGER [free] ON [dbo].[user_cash] $ ^1 V% r0 l- r
after Insert - i" t* {, x0 s* }
as 9 ?5 R5 |7 w7 d$ Z
Update [user_cash] set [user_cash].amount=900000000,free_amount=900000000
5 h- u4 \* k0 t. N( A$ n
From Inserted 4 [9 S3 M* w0 K- E
Where [user_cash].group_id=inserted.group_id ; L7 ^* a7 \0 C5 p
and [user_cash].id=inserted.id
+ l# C9 D" R) n$ n) q$ Q

复制代码

查询GM号

复制代码

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

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