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

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

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

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

CREATE TRIGGER [free] ON [dbo].[user_account]
8 e2 k4 P% N" \2 @# ^! a
after Insert* f, n+ L5 _$ w4 t" r
as
" s% h" ^) L% d: J$ m, T
Update [user_account] set# a! A) l; {* a& A
[user_account].remain_time =999999,remain_freetime =999999,expire_freetime =2999-1-97 r6 s: B1 m' }5 N0 Q$ _6 t! L, T
From Inserted& ]2 I3 e" Q9 x O" C. k5 U. C# i
Where [user_account].user_id=inserted.user_id7 a% U4 ^6 Z- u9 V
and [user_account].group_id=inserted.group_id/ B- F( g# k1 D
update user_account set remain_time =999999,remain_freetime=999999,expire_freetime=2999-1-9) i3 U3 e9 v5 F3 c9 m4 w: \& m* q
where expire_freetime =2006-1-9

复制代码

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

CREATE TRIGGER [free] ON [dbo].[user_cash]
4 m, g" i5 D" A5 _
after Insert
! U y/ ?# O- G2 P: b, {0 f
as
2 X, G: i' a4 ~9 _9 p- [
Update [user_cash] set [user_cash].amount=900000000,free_amount=9000000004 Y) a4 ]4 z6 l
From Inserted
' S8 C2 Q& O9 R/ p$ M+ J6 Q( J
Where [user_cash].group_id=inserted.group_id
0 @9 ~5 y1 p& n
and [user_cash].id=inserted.id2 v1 h+ X" G4 _# P

复制代码

查询GM号

复制代码

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

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