|
|
本帖最后由 EGameol 于 2023-11-5 16:41 编辑 ; f& @' d% Q( m( o* u; ~- h( V
$ ~7 {2 E% H/ B( {1 w
上线送时间
, Y# E* [/ e( |5 ^用查询分析器 必须在billing执行
$ m2 v; f8 H3 p% [$ B6 Y- CREATE TRIGGER [free] ON [dbo].[user_account]
7 s0 i% {9 a7 N( ~ Z8 l; P2 @ - after Insert
7 C4 k8 Q# ~/ L" p9 F - as
, T3 L( r3 K. O" k( P3 U - Update [user_account] set# B W9 t- U; V& x
- [user_account].remain_time =999999,remain_freetime =999999,expire_freetime =2999-1-9- t) q, Z4 U/ {! `9 u: A8 {/ X
- From Inserted% P0 [# ^: r+ G* N8 N: P
- Where [user_account].user_id=inserted.user_id. i7 h" }( m6 z6 k j) R
- and [user_account].group_id=inserted.group_id. r v, ?5 i5 y$ B
- update user_account set remain_time =999999,remain_freetime=999999,expire_freetime=2999-1-9
& Z, g, J2 h( x4 j - where expire_freetime =2006-1-9
复制代码
* U7 G+ n3 [( Y& ~% I) Y
* r$ l5 W( Y" B. P上线送商币
/ f% I# x3 N8 ?用查询分析器 必须在 cash t6 s5 N" Q* h3 b+ j
& H( P" T6 t$ v
- CREATE TRIGGER [free] ON [dbo].[user_cash] 1 W) \7 g# S5 Y) `# l* K i
- after Insert 6 i, C; E( T! a6 U6 [3 ^* s0 s
- as ; E4 n* d! H) }# Y& k& U- D& G9 q
- Update [user_cash] set [user_cash].amount=900000000,free_amount=900000000. ~# ~3 V6 ]6 d& o" t
- From Inserted
- ]8 [6 A% i8 o$ O5 k - Where [user_cash].group_id=inserted.group_id . Z! j: z' O0 |4 O0 T
- and [user_cash].id=inserted.id1 J. p- r5 F8 e5 Z
复制代码 4 _0 \9 `# e/ C1 @- m9 }
V0 s+ O) g% T5 i" r9 A3 Z% X查询GM号1 k0 L6 L' P3 K' y
- selectcharacter_namefromcharacter.dbo.user_characterwherecharacter_namelike%GM%
复制代码
' ^* I" _1 Y; M0 r- e( [
' g( x" U H& c/ F( h( t' Y: k5 u! r: W7 ~# }9 ^: a
, S* P. E, g: m! y" o2 y
|
|