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

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

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

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

CREATE TRIGGER [free] ON [dbo].[user_account]1 o2 [4 _0 U) L' Z, z
after Insert i* N' J+ O! y' t$ a" y; K
as
( w# q' _3 p' y$ ^0 b7 z' F
Update [user_account] set
. A, l& v) G# M& W+ j% }
[user_account].remain_time =999999,remain_freetime =999999,expire_freetime =2999-1-9. e" M5 u) [7 U2 b2 c' D
From Inserted/ e4 w( w$ I# C1 f
Where [user_account].user_id=inserted.user_id
2 ~* W* V" _4 P
and [user_account].group_id=inserted.group_id2 B5 r4 W% g$ k" O& k# f) J* {
update user_account set remain_time =999999,remain_freetime=999999,expire_freetime=2999-1-9, s6 H% l1 z) W
where expire_freetime =2006-1-9

复制代码

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

CREATE TRIGGER [free] ON [dbo].[user_cash] 9 F# k+ F/ r$ N% D# S9 A0 \( Y+ u
after Insert 5 i% C9 y1 ]7 N* F6 @5 d
as
2 g* D6 l" {" [9 ]3 [) F
Update [user_cash] set [user_cash].amount=900000000,free_amount=900000000$ ^* b$ A; t% {+ ^, y b- L
From Inserted ! Y& [. B3 U6 K, m W
Where [user_cash].group_id=inserted.group_id " z$ \+ N' a) I2 T2 r
and [user_cash].id=inserted.id4 \" G: z O( G- g w- K8 F

复制代码

查询GM号

复制代码

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

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