超级版主
- 积分
- 898
- 金钱
- 228
- 贡献
- 571
- 注册时间
- 2023-11-3
|
本帖最后由 EGameol 于 2023-11-5 16:41 编辑 5 @2 X, t4 w9 d; [% `! l1 o# a2 }
/ |. y+ i0 E" g% b1 C @
上线送时间
: g* B `( i& b/ W9 p3 s& d用查询分析器 必须在billing执行
/ ^9 ~5 \- ^; O- CREATE TRIGGER [free] ON [dbo].[user_account]" d! N1 ?' a% W3 R6 L P
- after Insert
6 s* Y6 v4 P- \ - as0 O$ X: p3 A- [% o% B4 y' s
- Update [user_account] set- U' c' ]' T0 ?: S9 w% z: [/ N
- [user_account].remain_time =999999,remain_freetime =999999,expire_freetime =2999-1-9
: n4 p+ I$ j% N; I - From Inserted! [; h) W( M4 N {7 V1 u
- Where [user_account].user_id=inserted.user_id
+ G8 ~8 F" [' F! h - and [user_account].group_id=inserted.group_id
- c+ Z0 v X& A7 j9 C/ N5 K - update user_account set remain_time =999999,remain_freetime=999999,expire_freetime=2999-1-98 O3 G3 p: _9 a) a
- where expire_freetime =2006-1-9
复制代码
! o' |5 W8 I7 L8 v; Y+ S
b' V9 D0 \$ r6 P# N: {上线送商币1 {' P/ ~7 V8 \- y
用查询分析器 必须在 cash
9 w+ J/ E# P- ?0 g6 v( w; P- L& D0 n( o! a$ }, K0 y* Y" I) N
- CREATE TRIGGER [free] ON [dbo].[user_cash] 8 w7 j- G: X* U7 V- f6 H
- after Insert
9 F* x/ j/ m9 a# c+ j - as ( t N) s6 l i3 h( _' T% ?
- Update [user_cash] set [user_cash].amount=900000000,free_amount=900000000
- m: M" Y; |9 I) Q [' @ - From Inserted 9 v8 v3 P g: g4 p
- Where [user_cash].group_id=inserted.group_id
& Q" Y4 L K% B: X; G1 F8 N, H - and [user_cash].id=inserted.id
( i# \9 n' {1 A! O5 W( P3 j5 I
复制代码 4 ?+ W' S% V1 y, t
3 f4 k2 d. ~) V$ N% e7 b0 R" E G
查询GM号) m t3 R3 l/ d! U% H' o4 b
- selectcharacter_namefromcharacter.dbo.user_characterwherecharacter_namelike%GM%
复制代码 : N7 X/ E2 N7 h5 U( _, [5 f
& B+ a! ?* e! d1 `. g0 o
, s& n. l/ Z' q4 l# U0 m) f+ j% m* ]% x1 B5 T2 B. ^. W: A
|
|