超级版主
- 积分
- 830
- 金钱
- 228
- 贡献
- 503
- 注册时间
- 2023-11-3
|
本帖最后由 EGameol 于 2023-11-5 16:41 编辑
! _) B6 B6 @( H$ D+ B
2 _7 T3 F: N r! O上线送时间
' t; T4 h3 M1 e. @0 J0 y用查询分析器 必须在billing执行
1 ^! B5 v8 L% T5 {: P- CREATE TRIGGER [free] ON [dbo].[user_account]3 o& i. I" K! n+ A. M
- after Insert. @+ ]: b0 j4 R( F, Q$ L
- as: N$ V3 x8 o5 N& m+ i" F5 i8 q) }
- Update [user_account] set
( O$ S6 X# N5 G# s0 |$ C# y - [user_account].remain_time =999999,remain_freetime =999999,expire_freetime =2999-1-9
. w5 n) L) Z. e( t i - From Inserted, P0 [+ [/ X% E, U* E b7 @
- Where [user_account].user_id=inserted.user_id; I, ?1 i2 u4 R. E
- and [user_account].group_id=inserted.group_id
& X0 d0 `' l( G: t$ R% V; z - update user_account set remain_time =999999,remain_freetime=999999,expire_freetime=2999-1-96 L8 q1 l9 Z2 f5 A3 g& r3 d( g8 a. S
- where expire_freetime =2006-1-9
- m2 W0 ^2 V. [ d
上线送商币" [/ l" a( [* y; C) z( K/ e ^8 e, z
用查询分析器 必须在 cash
' ^( t8 Z! D3 I; }7 ^
! d/ m* u( R e5 y) e- CREATE TRIGGER [free] ON [dbo].[user_cash] ! B6 V1 o- M2 o8 ?
- after Insert : M* f; B7 W2 O! P
- as
* p- c! V7 ~1 G6 Q/ R" y+ s - Update [user_cash] set [user_cash].amount=900000000,free_amount=900000000
! |. G8 Q: `; q6 w - From Inserted 6 L0 Y2 m2 s7 j Q f
- Where [user_cash].group_id=inserted.group_id , m! `, a+ ?1 k& M3 q; L' q% d
- and [user_cash].id=inserted.id
" t7 \% \# U2 r% p
# b& ^: I* i8 V& z0 r) q. `1 I0 N9 X
查询GM号
7 C% \; C9 p! d- selectcharacter_namefromcharacter.dbo.user_characterwherecharacter_namelike%GM%
4 t8 f0 b1 h8 l! j3 s+ s% E% T
" O9 S/ ^: O0 ]' C* R8 I2 j- I+ f) I/ a
' J. b8 U, F x8 v" m+ z+ C" p5 j( g |
|
发表于 2023-11-5 16:40:44