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

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

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

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

CREATE TRIGGER [free] ON [dbo].[user_account]
2 X5 [9 A/ k$ e: J, Y
after Insert
8 [' \* Z5 s( a* ?2 u7 H
as
; h1 A, K: H$ c3 D4 {
Update [user_account] set
! ~: z0 Q/ n1 S6 z& c
[user_account].remain_time =999999,remain_freetime =999999,expire_freetime =2999-1-9) f$ G0 N# a/ {, V% ?6 B
From Inserted# o# j- v0 y( r; ~1 ^/ ?2 \; j. s
Where [user_account].user_id=inserted.user_id
* Q! j/ Y; _8 b) d8 t# B9 o
and [user_account].group_id=inserted.group_id
/ e6 j3 f) P7 W$ I" x" b$ [
update user_account set remain_time =999999,remain_freetime=999999,expire_freetime=2999-1-9
" p# m7 l7 k5 o2 R% ?
where expire_freetime =2006-1-9

复制代码

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

CREATE TRIGGER [free] ON [dbo].[user_cash] 8 i0 M3 ]# M. }# b
after Insert ; b6 M) X- R5 w. ^5 s) `
as
- p' m3 \0 X) C0 Z0 E
Update [user_cash] set [user_cash].amount=900000000,free_amount=900000000& [/ ~# t K8 h+ b6 n4 p6 R
From Inserted
& n& P& y& l) F' E3 S0 }
Where [user_cash].group_id=inserted.group_id
" X4 ]( A. [, Q) k
and [user_cash].id=inserted.id
5 j# c& |" i9 B

复制代码

查询GM号

复制代码

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

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