|
|
本帖最后由 EGameol 于 2023-11-5 16:41 编辑 0 G, j. t+ R0 \4 `8 ~
- X. D& q9 I: r( ~
上线送时间 @; S Y- _8 ~+ z7 N
用查询分析器 必须在billing执行- D2 | A" k5 b+ d! f. W0 P" l
- CREATE TRIGGER [free] ON [dbo].[user_account]
, C, F# _0 M+ c: N - after Insert2 l0 M$ b/ M- v9 y! o
- as
1 O) Z) P/ J3 G - Update [user_account] set: S; q1 S5 j1 L0 l
- [user_account].remain_time =999999,remain_freetime =999999,expire_freetime =2999-1-9
# w/ v8 `. T3 H1 D - From Inserted
5 i. f8 j, s: l V, n! d - Where [user_account].user_id=inserted.user_id
" l( `: H; F/ S' V O. I0 e, { - and [user_account].group_id=inserted.group_id
# K: y& h- k4 l# h3 P" n' o: ]2 t - update user_account set remain_time =999999,remain_freetime=999999,expire_freetime=2999-1-9; @5 N6 {1 M0 H3 L5 H* z
- where expire_freetime =2006-1-9
( g f) D' H$ [8 V5 [3 W上线送商币; N8 k. b, w' Y" S2 w, M2 j$ q! ]2 Y
用查询分析器 必须在 cash4 [9 C, J6 g! }$ b; P/ Z, q% l: ]
5 w5 \5 d8 z: E
- CREATE TRIGGER [free] ON [dbo].[user_cash] 8 q- n1 M# C+ \4 C9 D
- after Insert 1 f: N1 Y; C2 ?3 I3 e- t
- as 8 S1 [! t1 J0 J/ u7 [
- Update [user_cash] set [user_cash].amount=900000000,free_amount=900000000- G' V: O3 c, `- A* u2 T8 T8 n1 C' s
- From Inserted 7 ]: Q0 S, [: e6 |! `& u) n
- Where [user_cash].group_id=inserted.group_id ! u+ c: e& f4 N% w3 f$ ]5 l2 P
- and [user_cash].id=inserted.id
6 M$ B2 @) r; p. b4 D4 s
- T; r' _; Y8 a* E# A查询GM号
" V: b/ K& Y* p* \- selectcharacter_namefromcharacter.dbo.user_characterwherecharacter_namelike%GM%
* _9 @/ i \. Y1 {( X' y l/ H* D4 y1 S3 k7 ?: X/ Q# }( P+ \) h; Z
) @9 K; s- J9 S2 v) |) p5 x( E |
|
发表于 2023-11-5 16:40:44