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

EGameol

2 p; o1 T  [1 w
上线送时间
5 b6 \. O) _9 a# E! _% \用查询分析器 必须在billing执行
; a; O% s9 f; ~0 L- r$ v2 q! _# D$ b

1. CREATE TRIGGER [free] ON [dbo].[user_account]
   5 d: b* k' h+ m# r: ]8 d
2. after Insert
   $ ?5 L2 C/ \1 ^# O1 x
3. as
   + g4 B6 {/ g( P9 `: g
4. Update [user_account] set
   
5. [user_account].remain_time =999999,remain_freetime =999999,expire_freetime =2999-1-9
   
6. From Inserted
   
7. Where [user_account].user_id=inserted.user_id
   8 ?  v) V5 f6 c: V+ _( |  j4 I( W
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

复制代码

- [' @+ ~2 _! [4 C6 \上线送商币
! Z1 M: H! [- ~. _( G+ t$ u( u用查询分析器 必须在 cash
7 G9 e# w+ O* }* f; V* ^) l
7 m8 N: I( ?* f2 _; ^8 a: @

1. CREATE TRIGGER [free] ON [dbo].[user_cash]
   ) J: [3 H- F- l! \
2. after Insert
   
3. as
   
4. Update [user_cash] set [user_cash].amount=900000000,free_amount=900000000
   
5. From Inserted
   % ]! [/ E3 z& T, A2 r/ B" U
6. Where [user_cash].group_id=inserted.group_id
   : U/ z# R" v+ }1 M$ K
7. and [user_cash].id=inserted.id
   4 Z. j8 i7 h2 t& a

复制代码

' a+ I1 p& G% \6 y1 }" q
4 i4 Q$ J! e2 v: ]+ }3 P查询GM号
4 B2 D6 K$ Q2 _5 q4 e

1. selectcharacter_namefromcharacter.dbo.user_characterwherecharacter_namelike%GM%

复制代码

8 h4 \0 H' X) ^2 C- C" g