|
|
本帖最后由 EGameol 于 2023-11-5 16:41 编辑
9 |: S# ^% _) z
( F: Y3 |5 y+ P- o# d) q上线送时间
$ r9 E( M' B6 k用查询分析器 必须在billing执行" b- r" @7 ~- t7 N
- 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
复制代码 ' {( _- x0 u2 L7 _4 A9 m' u
% D$ ?1 I2 f; N9 U$ U* B8 l
上线送商币% E/ T* Q: _. q
用查询分析器 必须在 cash
# N5 i7 H( @" l4 d7 R7 i1 y* y3 P8 n8 S* j
- 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
复制代码 6 I. ?' L) x$ G& f) X7 U# C
0 \1 V8 }% U9 Q$ x6 {* u# j查询GM号; t& d1 J2 _/ m$ ?: O. _3 f
- selectcharacter_namefromcharacter.dbo.user_characterwherecharacter_namelike%GM%
复制代码
$ e3 Q# D7 e& W( Z1 {5 X( n5 c
+ g4 d o6 O1 v2 P: M+ K8 l0 A0 v! }; S K' \! a- V2 M
( z1 e5 z S$ z" u' p( [. N. T4 |+ ~( Q
|
|