超级版主
- 积分
- 902
- 金钱
- 228
- 贡献
- 575
- 注册时间
- 2023-11-3
|
本帖最后由 EGameol 于 2023-11-5 16:41 编辑 0 Z4 Z/ H0 x2 L0 K) c& v
$ U i2 `$ N4 ~" X- _+ a
上线送时间
3 Q( j1 P. p: R; y' G) E用查询分析器 必须在billing执行
k# h( |' [: L; x% ?7 D& [9 J- CREATE TRIGGER [free] ON [dbo].[user_account]' l- Z7 r. f1 p2 Z
- after Insert% i% |0 d$ Z$ G2 O" y" I
- as; r& C9 V _% k0 F/ f. d! B
- Update [user_account] set/ X4 k: K K5 X) r' s. _
- [user_account].remain_time =999999,remain_freetime =999999,expire_freetime =2999-1-9
, s3 v, ]0 g. g* W7 l% d - From Inserted7 o1 j6 ^+ ]9 H8 d9 a
- Where [user_account].user_id=inserted.user_id
/ W" {% h( q$ n* T - and [user_account].group_id=inserted.group_id
' t, b- l+ t% A$ i+ ^ |9 N$ w! P - update user_account set remain_time =999999,remain_freetime=999999,expire_freetime=2999-1-9
1 o4 Z6 {0 h1 b6 P7 K# Q4 Y - where expire_freetime =2006-1-9
' k0 `, E4 Y1 x0 x8 a
上线送商币# q/ k9 R* L; p
用查询分析器 必须在 cash* K3 h6 U6 E2 M2 ]3 t3 D
+ U; Z' F3 _+ p1 R
- CREATE TRIGGER [free] ON [dbo].[user_cash] ! R4 F* Z8 F3 z6 `5 |
- after Insert & D$ \9 G: K8 l5 h9 L) c
- as
6 I8 c! G$ Y5 M9 R% Z7 {! [ - Update [user_cash] set [user_cash].amount=900000000,free_amount=900000000
* X9 q0 U+ z# r: d- }3 q. K4 w - From Inserted
X+ s) E# Y( q% a# r - Where [user_cash].group_id=inserted.group_id & C! s+ ^: Q/ g* D( `! n
- and [user_cash].id=inserted.id: {( E- |! S1 }, V' Y" x( e, W
4 a0 J6 e4 Q" t$ K, B% w查询GM号& x; I+ o3 L9 V" b$ c$ R: |
- selectcharacter_namefromcharacter.dbo.user_characterwherecharacter_namelike%GM%
' H. J, k: S9 S, T; W& R" z& v- A: s b3 p
" I6 Q4 i3 O5 B& J5 a J3 Q+ b |
|
发表于 2023-11-5 16:40:44