|
|
本帖最后由 EGameol 于 2023-11-5 16:41 编辑 8 i" Z$ P: p9 l5 ^2 U
! H: [( }8 V+ H
上线送时间9 P) B. `0 u' }& j, Y/ h! M
用查询分析器 必须在billing执行% }# z6 [3 ^7 r# Q& ^
- CREATE TRIGGER [free] ON [dbo].[user_account]
& X2 m' T" Z# I3 P' i7 J3 j - after Insert, K& H; Y% s8 F/ Q C: C5 @
- as
' R, d1 m4 B" p- R4 l i - Update [user_account] set
. c% _( V# ?+ I! A7 S6 U$ P- P - [user_account].remain_time =999999,remain_freetime =999999,expire_freetime =2999-1-9
- r* V9 V) C% e' ^- x - From Inserted: K$ z! t! s7 i7 @9 j
- Where [user_account].user_id=inserted.user_id& e, z' L( _( [& m. ?: I, u
- and [user_account].group_id=inserted.group_id
0 B9 e, `2 {) s' {9 D - update user_account set remain_time =999999,remain_freetime=999999,expire_freetime=2999-1-9& o$ ]4 f/ S; [
- where expire_freetime =2006-1-9
+ v! R1 A) h2 P; f
上线送商币) y" q u1 E9 k. y8 P9 j
用查询分析器 必须在 cash' f( F! S) H* H
: ^; o5 u( j$ @- M, [4 J- CREATE TRIGGER [free] ON [dbo].[user_cash]
( z- }! e( _3 j8 T3 q( I; p - after Insert 9 F2 \. x6 @! }6 @5 Y! v
- as 5 l8 u" f6 G- `% v# E" E) `2 R
- Update [user_cash] set [user_cash].amount=900000000,free_amount=900000000# Z- T6 o9 b( @1 E3 }8 n1 k- I! n
- From Inserted ' p: ^) \& Z$ j6 C9 s7 Y
- Where [user_cash].group_id=inserted.group_id
# O$ s! f) W- a# R - and [user_cash].id=inserted.id: y9 w7 t! V1 n' l$ {' d; R
7 z4 W4 ?- d3 N* Q. I8 ]5 a. b1 x
查询GM号
0 T2 t( C b3 m- selectcharacter_namefromcharacter.dbo.user_characterwherecharacter_namelike%GM%
% ]9 K1 Y$ o/ S5 g
- `- a; F x. U( o( r
# }& }* o5 V2 a- R. r# N8 ` |
|
发表于 2023-11-5 16:40:44