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

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

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

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

CREATE TRIGGER [free] ON [dbo].[user_account]
+ y* F/ @$ E$ G% x( ~
after Insert
. m" T) V% L" [
as# Y% f3 d% @/ ~7 s
Update [user_account] set9 u0 Q) e6 ~3 ^9 \1 G2 T
[user_account].remain_time =999999,remain_freetime =999999,expire_freetime =2999-1-9
8 S1 q1 h b% K, b9 n( P6 |
From Inserted
6 l- L$ ^% @/ n! p5 Y8 Y
Where [user_account].user_id=inserted.user_id; x" z/ w' x; K
and [user_account].group_id=inserted.group_id- v# T: \, u0 J1 S \: W
update user_account set remain_time =999999,remain_freetime=999999,expire_freetime=2999-1-90 ?/ {: q: q8 o$ A5 J4 j2 j/ f8 _
where expire_freetime =2006-1-9

复制代码

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

CREATE TRIGGER [free] ON [dbo].[user_cash]
. [" A8 Q% |5 _' P/ S
after Insert * x5 n* V6 Z- y7 }' E) e+ v: p
as
9 d6 C4 @+ K7 x2 T
Update [user_cash] set [user_cash].amount=900000000,free_amount=9000000008 J3 O! Y- T+ v, |# S2 C
From Inserted
- ?2 k: M8 m) I& F
Where [user_cash].group_id=inserted.group_id
4 l4 s3 ~: l3 @
and [user_cash].id=inserted.id
" l! ]( Q1 U6 f R/ v, b

复制代码

查询GM号

复制代码

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

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