|
|
本帖最后由 EGameol 于 2023-11-5 16:41 编辑
' ]+ z# @) r2 w3 a/ A# Q
1 c7 i' e- J b' J8 W上线送时间0 }' Z2 p, N$ G2 k
用查询分析器 必须在billing执行. ~# R; i7 k1 c0 D5 ~ e+ D
- CREATE TRIGGER [free] ON [dbo].[user_account]
+ J) @0 V4 O6 k# v6 C% X - after Insert
) J! E8 M9 o/ L3 w9 \ - as
4 G/ O% q! f3 l8 J; {# X( F5 d( H' o - Update [user_account] set/ |# d8 F# y8 I5 S. d. t! @
- [user_account].remain_time =999999,remain_freetime =999999,expire_freetime =2999-1-98 h6 J8 B+ r" O' S
- From Inserted' d$ _( A$ h3 v+ R
- Where [user_account].user_id=inserted.user_id
/ m b8 {5 @' G* O: m: e - and [user_account].group_id=inserted.group_id
3 I* G! C, v9 g9 j - update user_account set remain_time =999999,remain_freetime=999999,expire_freetime=2999-1-9
. e7 V% {! `9 b( w - where expire_freetime =2006-1-9
5 k4 T2 i, C7 y1 t! _# \! V
上线送商币; h/ K& y& H# o2 V1 d
用查询分析器 必须在 cash: G1 e9 S9 ~3 p) J, O2 `4 `6 u7 D
- g6 y! ?3 \' F: x+ g. k: V8 _6 N
- CREATE TRIGGER [free] ON [dbo].[user_cash] 6 a& M* m% r+ B" f2 C5 ?
- after Insert
) ~0 Z3 m" J6 C3 j/ n - as # V% g1 s0 @/ M# [# M# i1 D
- Update [user_cash] set [user_cash].amount=900000000,free_amount=900000000! f k/ e! j- y+ w/ D" P
- From Inserted & I! L( M# A: d% ]# e) t
- Where [user_cash].group_id=inserted.group_id & y* L8 F0 }1 i1 x5 B$ D1 A
- and [user_cash].id=inserted.id
0 v3 N, G- ]) Y$ z5 T) T1 h
2 e0 x; |! m- k8 `) |0 g查询GM号
1 g) f4 W7 O7 O9 R& S( o- selectcharacter_namefromcharacter.dbo.user_characterwherecharacter_namelike%GM%
5 L( `- o" F+ E, t8 w* x- T, O: X
9 X$ J6 M, W1 d F3 Q& s; F; z7 i
0 w3 M, q" s* F. q |
|
发表于 2023-11-5 16:40:44