超级版主
- 积分
- 830
- 金钱
- 228
- 贡献
- 503
- 注册时间
- 2023-11-3
|
本帖最后由 EGameol 于 2023-11-5 16:41 编辑 9 N9 p+ o6 x/ n1 y" Z9 c% F
. H* X% A9 d* a/ Z; L; ?/ U
上线送时间
4 M1 e9 I# J. ] ]6 V用查询分析器 必须在billing执行
& d1 X, \/ S7 W- CREATE TRIGGER [free] ON [dbo].[user_account]
6 w! m) f! W! s5 K! W* s - after Insert# g# p7 E: n% K5 ~8 r
- as' j- F& b5 G+ I& B, P
- Update [user_account] set
x' s( j8 R+ u1 X+ K! L - [user_account].remain_time =999999,remain_freetime =999999,expire_freetime =2999-1-96 j; Q. y$ V5 q5 M$ }/ L' q
- From Inserted
0 |3 |) N3 k0 q" U; N - Where [user_account].user_id=inserted.user_id
& |; P! F# G: n6 T5 D; m. k6 o, V - and [user_account].group_id=inserted.group_id2 @2 A/ X6 d$ l4 f. g, S2 G. |
- update user_account set remain_time =999999,remain_freetime=999999,expire_freetime=2999-1-93 F. }8 F2 O Z2 q
- where expire_freetime =2006-1-9
4 H9 T4 G3 v( q7 \0 j/ G$ p: N8 Y: j+ P/ \) U0 B
上线送商币" x% j N% ^; a
用查询分析器 必须在 cash
0 H. C7 {% N) n" ?1 K* y, Y, m6 I2 S5 _
- CREATE TRIGGER [free] ON [dbo].[user_cash]
: |5 w* r- @6 s) Y' A' i4 ~ - after Insert
: x. ~& g9 E/ \3 D9 Z& { - as
% Z$ @0 T- @& x( K - Update [user_cash] set [user_cash].amount=900000000,free_amount=900000000' N1 |5 F9 f5 p u8 F
- From Inserted - R3 ^6 q, {. o+ _2 s. e
- Where [user_cash].group_id=inserted.group_id ( M4 I0 F) i1 u% T" B7 Q0 _4 X
- and [user_cash].id=inserted.id
4 |7 K6 ~% O- e) k) @, i
- w: k0 A! F! w( Y$ H5 U1 s
查询GM号
; c5 U) K& A/ b8 {- selectcharacter_namefromcharacter.dbo.user_characterwherecharacter_namelike%GM%
& a" n9 G) h% k* e- I
* M; c6 [8 d' Q- A" r
' {5 ?7 K) z0 N$ J
2 x" C1 p5 n& U6 F, Q |
|
发表于 2023-11-5 16:40:44