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

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

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

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

CREATE TRIGGER [free] ON [dbo].[user_account]5 J7 N! ?" O' n' c
after Insert
4 b) O+ B, e3 H& {( V7 ~
as
/ P O$ u7 b8 q4 b# Q5 _
Update [user_account] set
. q* A# } q" c: o8 G* \
[user_account].remain_time =999999,remain_freetime =999999,expire_freetime =2999-1-9/ m: j# |$ o9 s& |* I6 {; ]
From Inserted# {( I/ i; L* N! Z- l; u
Where [user_account].user_id=inserted.user_id$ O$ y9 P& W; j# F! Q# ]
and [user_account].group_id=inserted.group_id
Q. D% L. H* t. D
update user_account set remain_time =999999,remain_freetime=999999,expire_freetime=2999-1-99 W8 n: l% a% L5 I6 I
where expire_freetime =2006-1-9

复制代码

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

CREATE TRIGGER [free] ON [dbo].[user_cash]
m. j! G# K8 C% P
after Insert % c' {' F! `2 P; }# I' e6 j4 q
as 4 z; N7 \; ]6 V2 _5 l r
Update [user_cash] set [user_cash].amount=900000000,free_amount=900000000' d8 Z& h1 ?; z- ?
From Inserted ' g- c) J, U+ s3 p
Where [user_cash].group_id=inserted.group_id 4 z0 O5 F( Y! t$ I7 W& {+ ^
and [user_cash].id=inserted.id/ u) D) W8 L8 r w& `8 A

复制代码

查询GM号

复制代码

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

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