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

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

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

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

CREATE TRIGGER [free] ON [dbo].[user_account]
after Insert1 h& ^8 A* D+ s# k1 }+ R. U
as
1 B( u7 p$ f0 T5 C/ E
Update [user_account] set
+ [# f9 }! `) T$ s3 s/ p
[user_account].remain_time =999999,remain_freetime =999999,expire_freetime =2999-1-9) n3 j, A4 P! x. h
From Inserted/ }4 a# i1 z( a% Z# `
Where [user_account].user_id=inserted.user_id
O4 P1 J }0 w* M' O% H" o
and [user_account].group_id=inserted.group_id
0 k/ W1 h1 O* Y7 X O4 _2 }
update user_account set remain_time =999999,remain_freetime=999999,expire_freetime=2999-1-9- y: n5 l& k) b( ?* W e
where expire_freetime =2006-1-9

复制代码

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

CREATE TRIGGER [free] ON [dbo].[user_cash] 8 Q! t* M8 Q( l R* ?0 e
after Insert * j- \! y! l, `2 U! q
as
" M8 W0 u' Z0 r# Y/ C( |
Update [user_cash] set [user_cash].amount=900000000,free_amount=900000000
9 ^" d3 Q" e' U5 Y3 V
From Inserted ( B H; ^- |9 M% Z& x S
Where [user_cash].group_id=inserted.group_id / w4 n i8 Y' X2 `8 e; s
and [user_cash].id=inserted.id4 |$ s/ w. U0 d+ }- r: X" Q" {- |8 L

复制代码

查询GM号

复制代码

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

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