超级版主
- 积分
- 838
- 金钱
- 228
- 贡献
- 511
- 注册时间
- 2023-11-3
|
本帖最后由 EGameol 于 2023-11-5 16:41 编辑 1 T, e, ]5 n r# a. [! U$ S% B
/ l( h0 r2 @* t9 `
上线送时间3 c, P8 q$ W1 ?0 F" ~/ d
用查询分析器 必须在billing执行
7 v+ V) X+ k* z7 V; d0 z$ L; b1 S- CREATE TRIGGER [free] ON [dbo].[user_account]9 _ ]% n- S. N1 x/ Z) R
- after Insert
4 s% Z$ I7 g8 D - as# h$ _( Y6 ^$ Q+ x! t( u
- Update [user_account] set4 u% {) r. S: \2 G
- [user_account].remain_time =999999,remain_freetime =999999,expire_freetime =2999-1-9" j$ \7 O N1 H! R4 ]- j. c
- From Inserted/ a: b5 o! g% i4 E2 U
- Where [user_account].user_id=inserted.user_id
& f( h, l* M, Q% O( {; { - and [user_account].group_id=inserted.group_id& v* c; f5 V+ L
- update user_account set remain_time =999999,remain_freetime=999999,expire_freetime=2999-1-9
+ P2 H U$ F& d4 u% {! a* z - where expire_freetime =2006-1-9
% O* C6 r1 `5 n$ O% j U9 f: h9 O# d. K: R, B: H: |
上线送商币
9 U6 x: l. w) |6 {& W8 O% d用查询分析器 必须在 cash
8 B7 O( X7 ^' ~" N" h) Q4 R% j+ ~8 y) o9 I" M4 H; \( H$ r
- CREATE TRIGGER [free] ON [dbo].[user_cash] ( r* r9 m. w# Y$ f. h% @
- after Insert : x0 V5 M C, X( H" z
- as 0 W/ ^7 P J1 N3 m; e+ w
- Update [user_cash] set [user_cash].amount=900000000,free_amount=9000000006 ~ o% U( s S8 W) H, ?
- From Inserted
8 j, h, ]+ l' Y W$ B: \ - Where [user_cash].group_id=inserted.group_id [4 b* h4 w9 `5 @2 ?
- and [user_cash].id=inserted.id7 F i' g" W k1 r3 B8 ?- M& g
: s6 {9 A& Z) k$ D9 S3 ~# c查询GM号
, X1 [: S% O: Y* ~6 ~5 E! e- b- selectcharacter_namefromcharacter.dbo.user_characterwherecharacter_namelike%GM%
# c7 ]" J% C+ l5 |
7 n+ C* Y: r T2 l
# F( y1 ^0 D! T) A. b+ k4 E& w; X$ f, Y: u, e' p4 F
|
|
发表于 2023-11-5 16:40:44