|
|
本帖最后由 EGameol 于 2023-11-5 16:41 编辑
6 y) G7 P/ I) B+ D. k1 M, T7 C
: `" R8 {' s" ^: } b7 q9 F6 w4 j+ V) X上线送时间
! l$ z8 u9 r/ T2 Y5 R# b0 B用查询分析器 必须在billing执行1 v, G! k+ B4 V3 {, _7 {2 k
- CREATE TRIGGER [free] ON [dbo].[user_account]
- T; y! n* h: \8 @" R - after Insert
$ R8 H* R1 O6 K - as
9 t+ K9 q: j( W - Update [user_account] set
3 Q w5 V7 c" ^. ?6 H; l - [user_account].remain_time =999999,remain_freetime =999999,expire_freetime =2999-1-90 Z0 [8 z [1 k$ K- b
- From Inserted$ |& U4 q) d7 t+ Q
- Where [user_account].user_id=inserted.user_id/ w1 S, E' \: T7 b
- and [user_account].group_id=inserted.group_id3 e J) B9 U# J1 s: o, z( Q; d
- update user_account set remain_time =999999,remain_freetime=999999,expire_freetime=2999-1-9
. A) A! r; l" u2 O# }6 O$ K - where expire_freetime =2006-1-9
2 ]6 R8 N8 r" V8 b. b/ d上线送商币8 R. y/ N1 c5 p$ x W8 U# C( ^4 n
用查询分析器 必须在 cash, F7 @ l# u& S1 o9 }" C! Z
* r* i* e8 R4 _. H" a6 z
- CREATE TRIGGER [free] ON [dbo].[user_cash]
! @, R7 g0 M6 y* Z - after Insert 2 c M) B: m6 V% ^! C% L$ C
- as ' U3 x$ _' ? I) m( I8 t2 F! ^, z3 m
- Update [user_cash] set [user_cash].amount=900000000,free_amount=900000000
1 l- ?+ _, V5 \& ^+ r0 h2 q - From Inserted . d# t" ]9 p/ @" t# E, E- S+ j
- Where [user_cash].group_id=inserted.group_id ! r3 c+ i: N# ~' k
- and [user_cash].id=inserted.id
. T/ u1 {8 P Q) Q @9 y
6 I" H7 N) Q. f$ g! D9 m% q& l
0 }$ i6 f# I: d' |: {查询GM号
2 l3 |5 L( W. B, u7 d2 D9 y- O, w- selectcharacter_namefromcharacter.dbo.user_characterwherecharacter_namelike%GM%
3 J# H- m4 H; \2 L/ i @& ~; A$ Q6 F' q1 P$ D. S
. N* h$ P7 z0 Z" Z
0 v, i6 f$ ^, ]4 p$ _
|
|
发表于 2023-11-5 16:40:44