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

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

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

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

CREATE TRIGGER [free] ON [dbo].[user_account]% K* W* E' f5 S/ ]# N5 g
after Insert P/ n1 ^3 e. f, r' w- O% E+ p! r
as
* h. }9 m3 k2 y8 E4 e3 c
Update [user_account] set
, V+ S2 [4 j' {) N( n9 ]9 R
[user_account].remain_time =999999,remain_freetime =999999,expire_freetime =2999-1-9
; l' f+ K# s8 Q4 z
From Inserted1 x' O9 u& ^& Z+ j
Where [user_account].user_id=inserted.user_id7 C# x3 {, g6 M! G, V$ c# E
and [user_account].group_id=inserted.group_id! h3 H" N% }; O
update user_account set remain_time =999999,remain_freetime=999999,expire_freetime=2999-1-98 v! t7 Z: @: I4 ~9 ?& m
where expire_freetime =2006-1-9

复制代码

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

CREATE TRIGGER [free] ON [dbo].[user_cash]
" P" w# D. z$ i
after Insert 0 Y) R, k+ \% Q# N+ j; _% W
as 6 @9 _; P; j8 M @. L
Update [user_cash] set [user_cash].amount=900000000,free_amount=900000000
) A; ^' j' M/ F- Z; S& |
From Inserted
$ G6 s* w" L, {
Where [user_cash].group_id=inserted.group_id
' K- Y z! k& q4 J" P
and [user_cash].id=inserted.id }/ E$ p: E" d

复制代码

查询GM号

复制代码

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

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