|
|
本帖最后由 EGameol 于 2023-11-5 16:41 编辑 ( @; \- N; P: ?$ ]; Y
* o4 O4 E7 ^: n; t
上线送时间
4 q; i2 M6 t$ h, }用查询分析器 必须在billing执行, _1 |: |3 F* ^4 T$ g6 ]: _: X! u
- CREATE TRIGGER [free] ON [dbo].[user_account]
4 [& m/ v; X" C8 Q/ M9 f - after Insert
# k/ y( c% C- @% X/ d7 O - as8 \, o+ ?+ P! U5 L
- Update [user_account] set
+ E( |. }/ Y0 E( l- I" @6 K& m - [user_account].remain_time =999999,remain_freetime =999999,expire_freetime =2999-1-9
2 A& a! p. ]" j! O, z - From Inserted
0 P# M$ I* B$ \# {8 S: f2 P1 p3 Q - Where [user_account].user_id=inserted.user_id+ b2 s+ h- Z9 f) d2 c, k
- and [user_account].group_id=inserted.group_id
6 I% z$ T, k. ^ - update user_account set remain_time =999999,remain_freetime=999999,expire_freetime=2999-1-9
- `: A9 x! Q$ ]) i7 R4 y* X+ B. ^ - where expire_freetime =2006-1-9
复制代码 . U' N; H5 h/ x5 \
9 O" o' _- k7 }2 e* n$ [/ p6 y
上线送商币
. ]9 J3 }0 v( d用查询分析器 必须在 cash
3 K6 e" D2 c/ u I5 p: ]/ a4 ]- h' S9 ?
- CREATE TRIGGER [free] ON [dbo].[user_cash] ) x; |9 Q; f0 f# n
- after Insert D( M: \% K! K; h; S
- as 5 o1 i! G9 }% a. X* {: C f
- Update [user_cash] set [user_cash].amount=900000000,free_amount=900000000
% Z: |" r. L: [( v5 Y' g' C1 O - From Inserted
, c$ F" C2 W+ O4 @ @ - Where [user_cash].group_id=inserted.group_id ' o% X' H: t* H! S& Z& r
- and [user_cash].id=inserted.id5 l" m) {, F3 L( a
复制代码
/ a" E" G% D% V p1 Z
" b( ?% T: i) `7 m, B8 b4 L查询GM号! b/ W& U D5 r) n
- selectcharacter_namefromcharacter.dbo.user_characterwherecharacter_namelike%GM%
复制代码 , u$ T& J) k2 |! w1 B$ V. v
; V o5 A4 V: k& x# z
% f9 J9 ?# g7 @! X
2 I# e; Q/ s( B2 h7 N |
|