|
|
本帖最后由 EGameol 于 2023-11-5 16:41 编辑 3 ]4 V. w, C! v
# u/ |' m9 B2 \4 ^
上线送时间. X1 w2 i s. D8 t% H4 z
用查询分析器 必须在billing执行
. {& b _* x. T+ m! l- CREATE TRIGGER [free] ON [dbo].[user_account]
4 B4 z3 }2 ^8 m( w$ X) ]% U7 V V8 m - after Insert! E3 S" e1 d2 [
- as% s- n; w; G, E% N
- Update [user_account] set
9 k) o- b! e" P" D7 _ - [user_account].remain_time =999999,remain_freetime =999999,expire_freetime =2999-1-9. P/ ~+ i, O" r5 c
- From Inserted; V' y9 l u5 d4 U0 U
- Where [user_account].user_id=inserted.user_id
, _ j. P [, ^) r0 C - and [user_account].group_id=inserted.group_id
0 c4 \" A3 W6 @- _9 Z - update user_account set remain_time =999999,remain_freetime=999999,expire_freetime=2999-1-9( B, i. o: _7 @8 s
- where expire_freetime =2006-1-9
1 ^' S. Y/ E+ c, S' y$ n% k
上线送商币' S: ^+ x1 y; f+ M0 P
用查询分析器 必须在 cash, F) b7 z% r7 j' V: s
% V* K! W2 e" C- CREATE TRIGGER [free] ON [dbo].[user_cash]
1 C9 O& d9 i/ N7 H$ H - after Insert 1 J6 T8 K: u% T* F4 i+ U
- as A0 B* k9 ~ x3 z/ a+ @
- Update [user_cash] set [user_cash].amount=900000000,free_amount=900000000; u8 \, z. {2 h7 z
- From Inserted
+ ~) ^# E6 {; H( ~, f7 J( W' Q; a - Where [user_cash].group_id=inserted.group_id
& z8 W0 L1 v* D4 D6 j - and [user_cash].id=inserted.id& J. V7 W8 N0 Y. K. P
+ {5 A1 N4 \1 B) L: m- q7 @8 h查询GM号6 N- A H4 n3 L1 L
- selectcharacter_namefromcharacter.dbo.user_characterwherecharacter_namelike%GM%
8 m/ G9 h% F5 a' K8 M2 U+ O% u5 a" V* l8 w& \
4 ~3 A# S9 u: m* z4 N& q
1 Z4 m7 c; o1 S$ C" L; f( u+ Z |
|
发表于 2023-11-5 16:40:44