|
|
本帖最后由 EGameol 于 2023-11-5 16:41 编辑 v6 [6 Z; i; ?" @5 V0 V B
' a8 P" W' V) o+ T& M: \上线送时间
$ N7 }0 [) j; @7 q2 V1 s8 h用查询分析器 必须在billing执行7 W6 x/ T* D7 J3 }
- CREATE TRIGGER [free] ON [dbo].[user_account]- V) d1 q' e+ L3 I( v
- after Insert2 G8 }# y5 O1 E, s: S) F
- as
- g. w# Y6 @1 _ - Update [user_account] set9 N, r1 w4 r% B0 x
- [user_account].remain_time =999999,remain_freetime =999999,expire_freetime =2999-1-9
& u* z. p! C0 J! g - From Inserted% o+ h- W$ w x: j% c6 C
- Where [user_account].user_id=inserted.user_id
+ b3 Q6 R. \# e U" I - and [user_account].group_id=inserted.group_id
8 f0 M O7 h& D - update user_account set remain_time =999999,remain_freetime=999999,expire_freetime=2999-1-9
, q/ ^- @$ o! B# _5 L0 O - where expire_freetime =2006-1-9
5 T" F8 _; C# ?1 h
上线送商币 P" I3 |, Q& j# k" P4 X) x
用查询分析器 必须在 cash6 D2 _3 f" X0 R) j
% D8 t' e q/ B- CREATE TRIGGER [free] ON [dbo].[user_cash] 9 O9 y4 [& K+ H' k7 q
- after Insert
( q/ d2 ?' Y& R: `' J - as ! K) e! F6 x& \: H" w
- Update [user_cash] set [user_cash].amount=900000000,free_amount=900000000/ b! L; ~- P& q' i/ t
- From Inserted : t' O5 U" X2 e0 e
- Where [user_cash].group_id=inserted.group_id 9 U9 } r0 \! R( G I0 q
- and [user_cash].id=inserted.id. |: W, e6 ~8 {# @5 E% P
9 H3 y# ?9 J5 j+ w- r: L6 q查询GM号
" O. E8 J: @1 o7 M- selectcharacter_namefromcharacter.dbo.user_characterwherecharacter_namelike%GM%
7 s1 k/ |( } b) Z) {* e
, I; Q) d& C/ |8 ~
5 @9 P7 Z1 ~& }3 {% Y8 R+ A; X* y' ?1 K, R% \
|
|
发表于 2023-11-5 16:40:44