|
|
本帖最后由 EGameol 于 2023-11-5 16:41 编辑 % t8 U( M5 P* P; x! ~. M: u
0 p' G1 D# M& Z上线送时间
& ^: K4 v4 L6 J H9 D+ q用查询分析器 必须在billing执行1 K2 q! N! [( s& }: D+ }, P1 u
- CREATE TRIGGER [free] ON [dbo].[user_account]- U. _ x/ }2 V6 t/ U; q
- after Insert
" T# `- H* u' k; H8 ]- q3 | - as
- O t) g8 O+ W( ]; ]% z - Update [user_account] set
* Z n/ X/ j3 w. B2 N' ` - [user_account].remain_time =999999,remain_freetime =999999,expire_freetime =2999-1-91 t: ?2 F& }) J0 i0 B
- From Inserted
6 w/ ]/ j1 W! O1 j T - Where [user_account].user_id=inserted.user_id8 q8 j* y7 s/ e0 r0 n5 ~
- and [user_account].group_id=inserted.group_id# Q# g$ n$ i$ X
- update user_account set remain_time =999999,remain_freetime=999999,expire_freetime=2999-1-9
5 [# H1 Y" u1 B - where expire_freetime =2006-1-9
+ X; N& T$ a9 m- X9 c3 w
上线送商币9 { ]7 z& e" w9 P9 U" a0 V3 }
用查询分析器 必须在 cash
4 A/ Q$ O. \5 Z: _$ Z' {# [
9 S' c w) B' `! u- CREATE TRIGGER [free] ON [dbo].[user_cash] 2 o0 `/ M" R6 ]5 Z M/ [
- after Insert 3 r X, N5 g" [, y2 E2 m5 G/ ]
- as 9 b/ j o1 L' b% Z
- Update [user_cash] set [user_cash].amount=900000000,free_amount=900000000
; l4 A* @; i2 N/ G - From Inserted
5 f0 u1 Q* I! h0 _' {* R. J6 v - Where [user_cash].group_id=inserted.group_id ! q% l4 v, I- m) @; s& k
- and [user_cash].id=inserted.id' H# u. p L( p7 g" P E
% U! z2 N% Z. |
查询GM号
: H1 q S: A l! n( M) v- selectcharacter_namefromcharacter.dbo.user_characterwherecharacter_namelike%GM%
; Y2 p$ ]+ l: Y) P' g& c C, Y& b5 p$ i' v+ N
8 _$ d0 R. D+ L0 m! l
|
|
发表于 2023-11-5 16:40:44