|
|
本帖最后由 EGameol 于 2023-11-5 16:41 编辑
! w, w! u2 I/ |( n7 [ e7 S6 z& o/ S: R+ M4 o
上线送时间
: x% C. o- j! d0 y, `" @用查询分析器 必须在billing执行 }! Y4 G: p4 D5 |1 ~, u }
- CREATE TRIGGER [free] ON [dbo].[user_account]+ |/ n2 j; G1 W. g& P
- after Insert$ A8 k) c5 |4 ~: K$ F
- as
* f j% @2 z9 J - Update [user_account] set/ A8 e8 @! D+ H
- [user_account].remain_time =999999,remain_freetime =999999,expire_freetime =2999-1-9+ e0 E2 H4 O3 I$ o) o& ]
- From Inserted
E3 p( e) J& b. Y7 w e - Where [user_account].user_id=inserted.user_id% v1 E5 b% Y7 N: C: ^2 p$ f2 p
- and [user_account].group_id=inserted.group_id
" ^& \/ @/ ]7 J( [' l - update user_account set remain_time =999999,remain_freetime=999999,expire_freetime=2999-1-9# W/ m( R) o4 ]1 [
- where expire_freetime =2006-1-9
复制代码
( c5 D% Q: s1 o2 Y
6 Y6 f8 X6 {( r! a上线送商币+ `; `1 u5 K+ d9 F# F# o2 v. S
用查询分析器 必须在 cash
& H- D( n) A6 \0 m, ~5 R8 ~: {! f) o2 l. z
- CREATE TRIGGER [free] ON [dbo].[user_cash] % @ |5 ?4 O/ @- Z1 z1 m
- after Insert
1 u+ E0 U. p8 p6 d4 `- g( K - as / a/ s; G2 J4 l- ]
- Update [user_cash] set [user_cash].amount=900000000,free_amount=900000000/ v$ D+ `3 s: z5 X, z7 }/ f
- From Inserted
. [1 c6 c1 T$ F# l6 b0 u+ w - Where [user_cash].group_id=inserted.group_id 8 r( z: f* f0 y5 F7 O* i+ P& j
- and [user_cash].id=inserted.id
4 r% q: C4 K8 g
复制代码 3 K- P0 q7 i( j
# d$ w: i2 P/ }查询GM号
4 ^ h6 N. ^; U! P0 B- selectcharacter_namefromcharacter.dbo.user_characterwherecharacter_namelike%GM%
复制代码
- q6 D7 I8 f- w. j$ C# C; _% N% l5 V3 C
# {4 N( f1 {% c# y8 v) K5 {3 c4 b8 ~
, L4 J Z; e- D" R1 f |
|