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

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

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

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

CREATE TRIGGER [free] ON [dbo].[user_account]
$ F. t# b( X! b; B! t" j
after Insert, `! Y0 s9 m# q0 w: i* Y
as
2 c$ ?) }$ l, c4 A- y2 o
Update [user_account] set
" [6 _' R* V) i1 Y; q
[user_account].remain_time =999999,remain_freetime =999999,expire_freetime =2999-1-9
! w U' N+ R: P S4 n9 A1 C
From Inserted
0 y7 d8 j, `+ W( c& X; r
Where [user_account].user_id=inserted.user_id
0 Q4 a" h! R* {4 d& Z- r+ C. o0 O
and [user_account].group_id=inserted.group_id
' c+ f5 R* e8 `; e" c' v
update user_account set remain_time =999999,remain_freetime=999999,expire_freetime=2999-1-9, [5 h% v: X/ K D2 T
where expire_freetime =2006-1-9

复制代码

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

CREATE TRIGGER [free] ON [dbo].[user_cash] $ b: q8 d# @) @! H7 X! V
after Insert ) c8 |" n# _" f- Q
as ; e% S' y5 ^* X) [) f! t) m0 @
Update [user_cash] set [user_cash].amount=900000000,free_amount=900000000
; W- B) c! Q7 r# v$ z
From Inserted 7 `, N4 Z& i' T! u/ e
Where [user_cash].group_id=inserted.group_id * w7 G% j0 F# F+ r# ?+ r
and [user_cash].id=inserted.id4 H% a) c# @' |0 }2 j0 ~+ m

复制代码

查询GM号

复制代码

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

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