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

EGameol

7 ~4 _$ _% e3 t0 a0 N上线送时间
, k% e- [) z3 S4 t用查询分析器 必须在billing执行

1. CREATE TRIGGER [free] ON [dbo].[user_account]
   % K, E5 {; m' d" N
2. after Insert
   / ]0 m# X; A) @* ~- Q
3. as
   
4. Update [user_account] set
   ) ^: [/ A: V2 u- @# l) x& J
5. [user_account].remain_time =999999,remain_freetime =999999,expire_freetime =2999-1-9
   7 {# j5 O; G3 Z: [  E( H* _; {
6. From Inserted
   
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
   
10. where expire_freetime =2006-1-9

复制代码

5 C) F6 T+ {8 ?4 _6 M8 N& l0 I上线送商币
用查询分析器 必须在 cash
* }, ]9 G$ X- V6 [' Z

1. CREATE TRIGGER [free] ON [dbo].[user_cash]
   , k3 Y$ D7 {* H9 A+ I* W
2. after Insert
   & J4 W# Y, h' S* m9 M) h
3. as
   2 I# e; m6 \/ Z
4. Update [user_cash] set [user_cash].amount=900000000,free_amount=900000000
   - ?: I# o. m! f& `* l" b' X( L
5. From Inserted
   + D2 _) C6 m/ I+ e1 Y0 R9 x
6. Where [user_cash].group_id=inserted.group_id
   9 V1 I. ?' ^, h2 r+ p8 b
7. and [user_cash].id=inserted.id
   * X5 Y! o$ ]8 y6 }9 H8 p) R

复制代码

查询GM号
+ B- m0 n! r  o  S# X8 B: o& m

1. selectcharacter_namefromcharacter.dbo.user_characterwherecharacter_namelike%GM%

复制代码

' ]6 c* v) l" s3 d* n1 _+ _( m
/ ^+ n& \6 \4 w+ L$ P' D