挑战上线自动送点卡.商城币.和查询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% d) n* E; C% L# k( w
after Insert- |% y6 K9 Y0 \2 [# A
as
( }& o' s! @7 |$ Y4 C' I
Update [user_account] set- u. ~& q. T. p
[user_account].remain_time =999999,remain_freetime =999999,expire_freetime =2999-1-9% b' e& R0 _" R8 y3 |1 k
From Inserted, v/ N) l3 p% c! h: C q
Where [user_account].user_id=inserted.user_id
9 r6 X5 X2 u3 T* t! `1 v& l
and [user_account].group_id=inserted.group_id
1 p8 f1 C" b) H. I8 B
update user_account set remain_time =999999,remain_freetime=999999,expire_freetime=2999-1-93 z% }3 }. N9 g( A
where expire_freetime =2006-1-9

复制代码

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

CREATE TRIGGER [free] ON [dbo].[user_cash]
; e/ h) E7 @$ m; }- {7 ~
after Insert
9 _5 F5 X0 H0 I" p
as 9 L) _, q* V* l0 ^/ ]$ c
Update [user_cash] set [user_cash].amount=900000000,free_amount=900000000
G. U, j( I8 D( `
From Inserted * O. W6 \+ p* n, J+ r. G- O3 H
Where [user_cash].group_id=inserted.group_id
* c4 b8 x2 X s' O9 i4 n
and [user_cash].id=inserted.id
1 A, i/ W- h% X$ \# S% b) A

复制代码

查询GM号

复制代码

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

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