|
|
本帖最后由 EGameol 于 2023-11-5 16:41 编辑 * g" Q/ T. _ N; |7 j
4 @; Z& |7 a7 O6 h; w" c上线送时间8 d8 g4 o A1 L9 `0 A, w% q |
用查询分析器 必须在billing执行
, d$ z* U! j8 a) f `8 @- CREATE TRIGGER [free] ON [dbo].[user_account]
P& {/ Y4 R4 i) P2 Q% |( S* d! D$ J- ` - after Insert$ y. R: J. \ s
- as7 R9 h( |1 u. A' k- z) T
- Update [user_account] set% ?# s0 ]/ u* `) \+ k' ^
- [user_account].remain_time =999999,remain_freetime =999999,expire_freetime =2999-1-9
, J. C4 K* v! O1 Y0 s& | - From Inserted
: s! j* }! y0 y$ e$ @4 x - Where [user_account].user_id=inserted.user_id
& W' e% V8 L F4 x! B - and [user_account].group_id=inserted.group_id% l1 h9 g9 r$ V# z# I e, p) \( f2 K3 A
- update user_account set remain_time =999999,remain_freetime=999999,expire_freetime=2999-1-9' A$ ]! Y( h' J# g. _" s/ B
- where expire_freetime =2006-1-9
* k8 i8 ^9 q5 Q8 e0 Z! z2 R/ h
$ K0 l# B ~2 k" @上线送商币, h+ U+ M% S4 g, g7 G7 L
用查询分析器 必须在 cash. {2 _; @6 Q2 N0 }! Z3 y U
$ |& Z* |( W" V" y
- CREATE TRIGGER [free] ON [dbo].[user_cash]
. X8 O T2 ~) }$ k; f2 z6 n - after Insert ' r! V! L6 L4 o* Z% O& p( I" U
- as
2 b5 @9 }, B+ P' k; ^ - Update [user_cash] set [user_cash].amount=900000000,free_amount=900000000+ s: z* u4 x( c4 z
- From Inserted 1 r' M5 r2 T7 X: l% Z
- Where [user_cash].group_id=inserted.group_id
: R. Z9 |# G: Y9 M' ]6 E7 a - and [user_cash].id=inserted.id
8 E+ [$ s$ g0 z: m+ i* B
$ q) \. ^: m8 x8 P查询GM号. O# r7 W% z( Z, j: y$ z: K
- selectcharacter_namefromcharacter.dbo.user_characterwherecharacter_namelike%GM%
: p4 F- C7 z s# M# |# h- s0 Q
# Y, |/ V! ]5 N9 b6 [- L
3 J; j9 g+ W9 D1 }# B) b1 Y+ { |
|
发表于 2023-11-5 16:40:44