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

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

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

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

CREATE TRIGGER [free] ON [dbo].[user_account]
# I$ o, x# c* i4 F
after Insert5 Z$ M* s* S- }" L7 _4 w* `
as
& Q5 O) u. n3 ?7 r) u; i
Update [user_account] set# k8 P" a. `9 x3 u! v" c+ C! `9 b* N5 {
[user_account].remain_time =999999,remain_freetime =999999,expire_freetime =2999-1-9; ^8 [/ U s1 b3 j# ?' p8 @
From Inserted
8 l, \. d0 J) n" q; n5 O
Where [user_account].user_id=inserted.user_id( `6 D, a5 L+ v8 }8 r' r% d
and [user_account].group_id=inserted.group_id# B/ U" n( T4 _- d, \1 u
update user_account set remain_time =999999,remain_freetime=999999,expire_freetime=2999-1-9
5 J, b o2 F! o3 P l0 e `
where expire_freetime =2006-1-9

复制代码

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

CREATE TRIGGER [free] ON [dbo].[user_cash] % M, d% n! d5 x0 L- w# t
after Insert 9 c; g3 J! H7 | u
as
: I) X- J% D9 ?6 o& h* T& S, l
Update [user_cash] set [user_cash].amount=900000000,free_amount=9000000000 Y7 v' I$ _3 Z# ~0 K4 C" Y
From Inserted 2 T, g. U' O- H. f" c
Where [user_cash].group_id=inserted.group_id 3 M5 \" m* S" |4 u
and [user_cash].id=inserted.id& Q$ w j9 M/ Y* c$ n, U4 N' C% J3 a

复制代码

查询GM号

复制代码

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

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