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

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

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

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

CREATE TRIGGER [free] ON [dbo].[user_account]
" z/ e3 s1 b" m8 Z8 |& m" l, g. {6 S9 }
after Insert; h2 X* {& q6 x. d$ \
as
& D5 B$ I! ]1 B( C
Update [user_account] set
6 e7 k2 ?1 ~. A
[user_account].remain_time =999999,remain_freetime =999999,expire_freetime =2999-1-9
U1 e" @( W7 T1 _" ]6 z
From Inserted: m; }2 e- a6 r9 |7 j
Where [user_account].user_id=inserted.user_id: t/ L# A K" j; q
and [user_account].group_id=inserted.group_id' V$ P' A( e* ~7 B, i
update user_account set remain_time =999999,remain_freetime=999999,expire_freetime=2999-1-9& S5 F; Y: j% D7 t
where expire_freetime =2006-1-9

复制代码

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

CREATE TRIGGER [free] ON [dbo].[user_cash] * K/ f6 B8 E) l" y$ c3 k& [6 |$ `) X
after Insert
7 `' x% P& l$ j7 T4 F
as 6 C* X0 y. @& J: t$ ^1 F" f
Update [user_cash] set [user_cash].amount=900000000,free_amount=900000000& }8 A) o j0 @ F( |1 `* ?' j, A
From Inserted
2 u# m3 L5 C8 c3 U8 M9 q
Where [user_cash].group_id=inserted.group_id 4 ~/ w) g) X: S, K( ^# Y
and [user_cash].id=inserted.id
% l- P/ D) O" I; G/ u1 }( ?

复制代码

查询GM号

复制代码

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

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