|
|
本帖最后由 EGameol 于 2023-11-5 16:41 编辑 + Y7 R1 L' F# W' H
7 I$ k! K& X9 A) K
上线送时间# L( v! ^! q4 e, @7 w" w! l s }
用查询分析器 必须在billing执行
- n# l( G. l% Y6 i% m* d- CREATE TRIGGER [free] ON [dbo].[user_account]
8 |$ q* e9 ?! I' k4 \3 b: E+ r; k# ? - after Insert5 N4 W0 l0 j1 q4 [" ^4 i
- as" |# `! u9 _( a. V. }
- Update [user_account] set
6 v, I" V+ j; W - [user_account].remain_time =999999,remain_freetime =999999,expire_freetime =2999-1-95 ?6 _7 J& B: D" V+ p
- From Inserted
* Z D* A* Y$ o6 m8 r - Where [user_account].user_id=inserted.user_id
' H Y e7 T$ J' n% F; O( X - and [user_account].group_id=inserted.group_id0 E: f3 A) D7 w4 t, _ E6 h+ p
- update user_account set remain_time =999999,remain_freetime=999999,expire_freetime=2999-1-9# O' h1 T. m1 |
- where expire_freetime =2006-1-9
. ~8 r" M' H6 M$ {. r! w% L, ^; |& Q+ }% _3 k0 p# }- r: u
上线送商币3 Q( l3 B' G- N" M: P
用查询分析器 必须在 cash
" V+ i2 `0 |! K5 Z1 p+ j f: p" H0 G
- CREATE TRIGGER [free] ON [dbo].[user_cash] * y% s& e) [% b- E7 g, T G
- after Insert
# o: H* u( O# \& G8 ]( o; c - as
. y0 h, G3 W. O) J' K7 r8 t0 T - Update [user_cash] set [user_cash].amount=900000000,free_amount=900000000' t! ~8 ]0 p h& A7 ^
- From Inserted
' \! {& m( w3 s. g: x( j - Where [user_cash].group_id=inserted.group_id 0 ]/ J# q% B- ^
- and [user_cash].id=inserted.id( @3 m3 B5 h9 Z) k, c
4 k' q% B. x2 M
查询GM号
# s; O& j) h4 L7 E% f7 c L& \- selectcharacter_namefromcharacter.dbo.user_characterwherecharacter_namelike%GM%
$ C/ V r' P& t+ ]9 K& S5 f
7 X, D% n6 f! Q7 F
, F$ X5 N, D3 {1 \# l; ]- L8 O4 Z Z, p; \- r) ?% G4 U
|
|
发表于 2023-11-5 16:40:44