挑战上线自动送点卡.商城币.和查询GM号SQL执行语句

EGameol

* {/ L: ^0 o( I! Z7 k; I  ^4 {上线送时间
用查询分析器 必须在billing执行
+ i. O% P& v% x5 T* V. U9 C' u

1. CREATE TRIGGER [free] ON [dbo].[user_account]
   7 ~! u7 ]  S# B
2. after Insert
   * N# @& g7 Y  R- q1 Z- Z* r
3. as
   
4. Update [user_account] set
   ( M2 v$ g6 ^6 n0 d) n+ E0 N
5. [user_account].remain_time =999999,remain_freetime =999999,expire_freetime =2999-1-9
   * `: l0 m+ p: P! r- g
6. From Inserted
   & p# U- g, N  w
7. Where [user_account].user_id=inserted.user_id
   
8. and [user_account].group_id=inserted.group_id
   
9. update  user_account set remain_time =999999,remain_freetime=999999,expire_freetime=2999-1-9
   ; W- z% _) [5 |' V5 P: q! ^, D
10. where expire_freetime =2006-1-9

复制代码

$ R( q3 H$ j9 p8 d+ {. W
0 G. b; h8 s. R. M% \( O上线送商币
用查询分析器 必须在 cash

' N! I" ^7 `, @+ v& @

1. CREATE TRIGGER [free] ON [dbo].[user_cash]
   
2. after Insert
   : J1 T5 S6 K& e& k: C0 g
3. as
   ) E: O; o0 _8 x
4. Update [user_cash] set [user_cash].amount=900000000,free_amount=900000000
   
5. From Inserted
   . }# T4 |, S" ~  o
6. Where [user_cash].group_id=inserted.group_id
   " @" E5 r+ g7 A; X1 L, y) r$ r
7. and [user_cash].id=inserted.id
   + C% G% H+ }1 g( _/ R

复制代码

2 T: z1 Y$ [: R& V: P查询GM号

1. selectcharacter_namefromcharacter.dbo.user_characterwherecharacter_namelike%GM%

复制代码

5 |" p3 i- y, n  j% ]
6 `1 |6 I6 E7 [# `1 @$ f2 Z; d