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

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

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

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

CREATE TRIGGER [free] ON [dbo].[user_account]9 ]6 P/ T; x/ J2 O% u
after Insert. Q% z) T& w5 M
as
0 h' r/ o" |, P
Update [user_account] set7 i8 v' w4 w$ z% D0 |0 k5 N0 ~% }
[user_account].remain_time =999999,remain_freetime =999999,expire_freetime =2999-1-9
3 s/ o/ }3 f# ~+ N9 Z& V
From Inserted% \; X# L6 @9 g' v7 M
Where [user_account].user_id=inserted.user_id
" C% V0 J& p4 |3 t
and [user_account].group_id=inserted.group_id
0 R& z/ \- D& F( I7 F% B1 G" H/ o
update user_account set remain_time =999999,remain_freetime=999999,expire_freetime=2999-1-9
, P9 e, I3 l: c9 r3 p9 @" @7 [
where expire_freetime =2006-1-9

复制代码

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

CREATE TRIGGER [free] ON [dbo].[user_cash] r) F1 M( z I( Z
after Insert % n( j& \+ U" v, V' q
as
/ }8 D% Q# J7 T7 {: Z/ f
Update [user_cash] set [user_cash].amount=900000000,free_amount=900000000# }- W2 [* F8 V2 ^
From Inserted
1 y2 V5 T) D( R3 u D# s+ o
Where [user_cash].group_id=inserted.group_id
% M( A) L) e* V; j1 R. s
and [user_cash].id=inserted.id: b5 c; n7 c9 q8 h

复制代码

查询GM号

复制代码

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

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