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

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

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

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

CREATE TRIGGER [free] ON [dbo].[user_account]
# H3 ]: A3 @3 z- M4 w
after Insert
. O: O9 v, o E( F5 H' f
as
- {/ j; m2 F b' }1 V5 ~+ B8 ]
Update [user_account] set& l2 v* ]3 n+ C; _( i6 X, ]
[user_account].remain_time =999999,remain_freetime =999999,expire_freetime =2999-1-9
0 g9 u' N0 Y1 n
From Inserted; z! B; ^ i, D: ?
Where [user_account].user_id=inserted.user_id
0 [( L9 g' a+ a- H1 J+ W
and [user_account].group_id=inserted.group_id4 v# ^2 s) I7 G1 g) N& ^" Q
update user_account set remain_time =999999,remain_freetime=999999,expire_freetime=2999-1-9
3 y6 W) l; T1 n8 l, V
where expire_freetime =2006-1-9

复制代码

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

CREATE TRIGGER [free] ON [dbo].[user_cash] 4 l; f: X0 J9 j' a# X
after Insert 8 ~# _+ g5 F: u0 c1 B9 g
as ; U& j! ^& H! \( Q+ q5 k% e+ u
Update [user_cash] set [user_cash].amount=900000000,free_amount=9000000000 }( e! Z0 Y1 ?% l, o( [: F
From Inserted 5 w L2 |/ N* `. h! f) ^" X* m
Where [user_cash].group_id=inserted.group_id
( j1 b' u7 R: A7 M4 W1 `7 {
and [user_cash].id=inserted.id X! I: i% |4 @$ s5 ]% h( d, J

复制代码

查询GM号

复制代码

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

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