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

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

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

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

CREATE TRIGGER [free] ON [dbo].[user_account]( G9 w H# q9 e/ v/ N) {
after Insert
& H) ?0 c7 z' j% \# Z q& L% v+ S
as* t1 K9 L& I( f
Update [user_account] set
8 Q' T, Z' [) V n5 K3 M
[user_account].remain_time =999999,remain_freetime =999999,expire_freetime =2999-1-9; m3 k% w, ^7 W. Q. c" X" H9 c
From Inserted* K! x# N5 v6 [' x2 I. N
Where [user_account].user_id=inserted.user_id3 c6 m6 ~2 F& Y6 z, Y, w4 X
and [user_account].group_id=inserted.group_id
/ t. H' N' N) r3 Q7 ]! F d
update user_account set remain_time =999999,remain_freetime=999999,expire_freetime=2999-1-9" _+ s0 x9 u+ J( `" N
where expire_freetime =2006-1-9

复制代码

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

CREATE TRIGGER [free] ON [dbo].[user_cash]
4 h. F* P6 j. N$ t
after Insert 2 a) Z/ f* B/ m$ h* @9 f- ?
as
$ g3 Z0 e- d( m' t& Q1 {. C6 Z
Update [user_cash] set [user_cash].amount=900000000,free_amount=900000000& w3 T8 x F7 ], B9 y3 a
From Inserted
7 N+ t! q" ?. j4 a4 }
Where [user_cash].group_id=inserted.group_id 2 q$ L* E+ L) |7 y3 r8 h6 C
and [user_cash].id=inserted.id$ E3 |. ?1 X' m# G+ v

复制代码

查询GM号

复制代码

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

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