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

EGameol

' ]% y- U: j, ], T# |8 w- S
5 M2 H3 ]- A" _上线送时间
用查询分析器 必须在billing执行

1. CREATE TRIGGER [free] ON [dbo].[user_account]
   2 N4 R) x) i- {: y9 k1 V
2. after Insert
   8 j, `1 A+ ?& n* t2 f& }6 U- a9 d
3. as
   
4. Update [user_account] set
   8 @/ F2 ]* S$ y- i  }  S
5. [user_account].remain_time =999999,remain_freetime =999999,expire_freetime =2999-1-9
   , X8 |6 Y) H  h! J
6. From Inserted
   / e. C- O8 j! o0 Q. F$ A
7. Where [user_account].user_id=inserted.user_id
   , |1 l% U- v, i/ ^) |( Z
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
   8 g  @, i7 H: ]. P$ q* T" a
10. where expire_freetime =2006-1-9

复制代码

; U7 Q* O3 {8 E9 Q
上线送商币
  v* {3 P% v; B' I. D% F& G用查询分析器 必须在 cash
1 }: @1 m- v7 {( V

1. CREATE TRIGGER [free] ON [dbo].[user_cash]
   ( C2 i- j3 y1 t$ x+ Q: M1 O; Q
2. after Insert
   2 n  z& f% m. Q( E( g5 B+ \6 ]! y
3. as
   
4. Update [user_cash] set [user_cash].amount=900000000,free_amount=900000000
   
5. From Inserted
   4 x0 k$ Q0 c% J  e( l) F; J
6. Where [user_cash].group_id=inserted.group_id
     m! H2 ]6 b$ p2 I& D
7. and [user_cash].id=inserted.id
   : I2 d( f# S: q# w1 p" L

复制代码

& U+ N* x0 S* z9 |# U4 Z% V
; F: R" Z9 f- X. D( ~9 [/ P$ ^查询GM号
; R0 F$ u3 M. ?% F7 q( a

1. selectcharacter_namefromcharacter.dbo.user_characterwherecharacter_namelike%GM%

复制代码

* e4 K! }3 `2 S$ `/ D
' c2 G' ]" ^' D4 C! |. q; P
  E" g/ \9 I' W  c