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

EGameol

上线送时间
用查询分析器 必须在billing执行
3 ~3 B/ q' S; n0 C1 ]3 K! f

1. CREATE TRIGGER [free] ON [dbo].[user_account]
   
2. after Insert
   
3. as
   ! A) r! A+ T* y# A: c/ K
4. Update [user_account] set
   9 [- a* t/ Y3 r! U! s" D* y
5. [user_account].remain_time =999999,remain_freetime =999999,expire_freetime =2999-1-9
   
6. From Inserted
   ) j8 o& e5 M. Y2 M: w" R4 E
7. Where [user_account].user_id=inserted.user_id
   , V- U! Z3 D  W6 t" T
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
   
10. where expire_freetime =2006-1-9

复制代码

, r) c; N) Z; f
上线送商币
- y: s6 N8 r7 u: ^. t用查询分析器 必须在 cash

1. CREATE TRIGGER [free] ON [dbo].[user_cash]
   2 e! Q  Q" _0 Z+ v2 W+ }
2. after Insert
   - x" {/ Q7 g/ u9 u5 k
3. as
   8 w9 r; z+ M8 q/ z6 Q/ _, b5 [
4. Update [user_cash] set [user_cash].amount=900000000,free_amount=900000000
   * J) I- h# a2 w
5. From Inserted
   
6. Where [user_cash].group_id=inserted.group_id
   * [* L% j: w& F/ Q& M
7. and [user_cash].id=inserted.id
   $ I% Q( k3 k, |- \

复制代码

. u- k& B; x4 i) f; G2 G, J
查询GM号
, J- W8 u) W- D9 h9 @( [

1. selectcharacter_namefromcharacter.dbo.user_characterwherecharacter_namelike%GM%

复制代码

, o. ?9 W$ }0 o; z/ E4 j

$ L7 @9 i& G, p7 j5 W$ c9 V! m