|
本帖最后由 EGameol 于 2023-11-5 16:41 编辑
# E4 y- N, R5 N8 U3 m# t' x! ?" {0 G* z1 B- w$ U+ ?) {
上线送时间
* M0 l, p5 [- {5 l Z' G& B" I用查询分析器 必须在billing执行
9 h& p D9 ?! v3 I! u- CREATE TRIGGER [free] ON [dbo].[user_account]
1 c7 Z+ j. L6 ] _9 A* @ - after Insert6 Z0 s. W) }; t/ W8 i
- as
5 \( v }8 D1 _7 \ }2 H D - Update [user_account] set
& e! V" q- C, H- }# ? - [user_account].remain_time =999999,remain_freetime =999999,expire_freetime =2999-1-9( g+ F; p" p, g( P# G
- From Inserted, n- q6 x/ \. e* e# T9 |
- Where [user_account].user_id=inserted.user_id
& p4 b5 z }1 o$ h2 Z: _3 z/ ] - and [user_account].group_id=inserted.group_id
) i5 s) w7 @2 |2 P' x- d - update user_account set remain_time =999999,remain_freetime=999999,expire_freetime=2999-1-9( G& ?+ D A5 {0 ~9 j3 L( K) ~
- where expire_freetime =2006-1-9
复制代码 7 {; h" v3 }/ l q
% a2 @7 [' z+ H* E7 @: U
上线送商币2 |* f) A/ ~' x! f9 M
用查询分析器 必须在 cash% m+ z. X; S4 X5 n5 A' v
6 s7 N, j, O, G5 u0 j- CREATE TRIGGER [free] ON [dbo].[user_cash]
% _3 S% B2 k) Z$ J" _ - after Insert 6 |, W4 ]5 P4 g1 s. Y, r' g1 U
- as
$ ?# n/ @1 O. F; u3 G4 ]: r - Update [user_cash] set [user_cash].amount=900000000,free_amount=9000000001 r, B- g2 `' s/ R- L! J. n
- From Inserted
! k5 r; c9 L( l, q - Where [user_cash].group_id=inserted.group_id 9 U2 I6 l, {) u K/ L7 s
- and [user_cash].id=inserted.id4 a% H. @0 f, H+ J
复制代码
/ M4 h6 r0 D2 J( `
4 S# y% C9 I" V1 b" O) q z查询GM号
& I1 h$ h4 t& l. N; l% C4 t# B, t F- selectcharacter_namefromcharacter.dbo.user_characterwherecharacter_namelike%GM%
复制代码 7 u5 O! p: h# o; z) T: o2 O& H
N. l6 ?" \( g i3 Z
* E( D2 I7 J3 G9 J- Y8 ?/ e& A- c5 n
|
|