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

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

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

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

CREATE TRIGGER [free] ON [dbo].[user_account]
3 {6 H# Y# Y% o% [
after Insert
! o) A- [& K- E6 n
as6 m! I+ W9 q" B2 v. j
Update [user_account] set* T4 y3 x) b* g# {
[user_account].remain_time =999999,remain_freetime =999999,expire_freetime =2999-1-9" o5 k# j; }3 M% E) j" X4 r8 |
From Inserted: t9 l- F' z. o, x% ^0 q6 K2 c' d+ u
Where [user_account].user_id=inserted.user_id
8 N/ F) c( u& W1 {
and [user_account].group_id=inserted.group_id D/ t' b& G- ^: M% r, P% M
update user_account set remain_time =999999,remain_freetime=999999,expire_freetime=2999-1-9
) a! z* R7 w1 h4 I1 D! R4 F
where expire_freetime =2006-1-9

复制代码

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

CREATE TRIGGER [free] ON [dbo].[user_cash] ! c3 h+ U+ E7 ?) D* U# t
after Insert
0 x. Y% y) B8 e2 R" W
as : O* o4 ~& i& C, c# A j) B" D
Update [user_cash] set [user_cash].amount=900000000,free_amount=900000000
9 \. \! O2 g! T7 D0 e
From Inserted
+ C* d. R7 F& B- A+ Z9 z( o
Where [user_cash].group_id=inserted.group_id 5 v+ H6 [$ L% M/ r1 u v R
and [user_cash].id=inserted.id2 q! f+ j8 p- a$ s9 ~& P0 U4 {. A+ Z

复制代码

查询GM号

复制代码

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

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