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

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

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

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

CREATE TRIGGER [free] ON [dbo].[user_account]
7 s0 i% {9 a7 N( ~ Z8 l; P2 @
after Insert
7 C4 k8 Q# ~/ L" p9 F
as
, T3 L( r3 K. O" k( P3 U
Update [user_account] set# B W9 t- U; V& x
[user_account].remain_time =999999,remain_freetime =999999,expire_freetime =2999-1-9- t) q, Z4 U/ {! `9 u: A8 {/ X
From Inserted% P0 [# ^: r+ G* N8 N: P
Where [user_account].user_id=inserted.user_id. i7 h" }( m6 z6 k j) R
and [user_account].group_id=inserted.group_id. r v, ?5 i5 y$ B
update user_account set remain_time =999999,remain_freetime=999999,expire_freetime=2999-1-9
& Z, g, J2 h( x4 j
where expire_freetime =2006-1-9

复制代码

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

CREATE TRIGGER [free] ON [dbo].[user_cash] 1 W) \7 g# S5 Y) `# l* K i
after Insert 6 i, C; E( T! a6 U6 [3 ^* s0 s
as ; E4 n* d! H) }# Y& k& U- D& G9 q
Update [user_cash] set [user_cash].amount=900000000,free_amount=900000000. ~# ~3 V6 ]6 d& o" t
From Inserted
- ]8 [6 A% i8 o$ O5 k
Where [user_cash].group_id=inserted.group_id . Z! j: z' O0 |4 O0 T
and [user_cash].id=inserted.id1 J. p- r5 F8 e5 Z

复制代码

查询GM号

复制代码

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

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