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

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

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

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

CREATE TRIGGER [free] ON [dbo].[user_account]) G% P9 M$ m) e& u# t& Z0 ]
after Insert
5 G$ g# B, o3 c# O6 A# J0 d
as( ^, T1 f1 A: I$ [( @9 g0 }
Update [user_account] set
% g' X, m8 {# d
[user_account].remain_time =999999,remain_freetime =999999,expire_freetime =2999-1-9
2 g9 a R- ]! i2 N- t# b' G/ x
From Inserted/ x$ i( c0 a4 X) A
Where [user_account].user_id=inserted.user_id- w6 M) P0 V, }. W
and [user_account].group_id=inserted.group_id' m- _) L6 k( x5 P
update user_account set remain_time =999999,remain_freetime=999999,expire_freetime=2999-1-98 E' P) W6 j* D* k. ~3 L
where expire_freetime =2006-1-9

复制代码

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

CREATE TRIGGER [free] ON [dbo].[user_cash] 1 N- Q N6 [* ?# d$ L
after Insert # U: R: y3 {# Q& U
as
( s9 R! s# k% H- W
Update [user_cash] set [user_cash].amount=900000000,free_amount=9000000004 {0 G/ x* a) s" R1 \# ^0 T q
From Inserted ) j! g0 d* c+ s0 N" H
Where [user_cash].group_id=inserted.group_id , \, e, j8 H q6 t
and [user_cash].id=inserted.id6 D; T5 f R v/ _5 ^% A, L

复制代码

查询GM号

复制代码

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

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