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

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

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

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

CREATE TRIGGER [free] ON [dbo].[user_account]% q( z- m+ x) ?
after Insert
/ M# P3 t! Y7 R! X! E
as
& k; R! K) C5 s8 c
Update [user_account] set( Z* m) Z8 d4 H* I! ~
[user_account].remain_time =999999,remain_freetime =999999,expire_freetime =2999-1-9
1 `6 f' C0 N9 O# Y# P. ]
From Inserted$ E7 j# M2 s( P9 ~. O# D
Where [user_account].user_id=inserted.user_id _2 w I# @; W2 ]& G' ?( |
and [user_account].group_id=inserted.group_id3 M' O+ @, g: z0 V# T- {0 i
update user_account set remain_time =999999,remain_freetime=999999,expire_freetime=2999-1-98 G/ Q- F3 t) d+ m0 U7 @
where expire_freetime =2006-1-9

复制代码

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

CREATE TRIGGER [free] ON [dbo].[user_cash] & G5 t8 e1 h. m1 T. B
after Insert
6 B9 C: b; B9 o" h. P3 A
as & d. [4 }; F; J; {% y1 a# H2 u
Update [user_cash] set [user_cash].amount=900000000,free_amount=900000000
~" F% }, B: A* ?0 w- e! D$ T( M
From Inserted / n; ] P8 \1 g, s: l4 @
Where [user_cash].group_id=inserted.group_id 7 J6 p; q; v7 _% n F- J
and [user_cash].id=inserted.id
4 i0 E( I. e# I. {3 @; C0 v2 u2 {7 V

复制代码

查询GM号

复制代码

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

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