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

EGameol

3 P  ?6 B/ z" X7 ~! c+ _" \上线送时间
9 M+ f8 C. O5 k: n用查询分析器 必须在billing执行

1. CREATE TRIGGER [free] ON [dbo].[user_account]
   ! k  Y! ^# H- y, ]6 G
2. after Insert
   " ?- `% m" b- Q! `
3. as
   ' |( ~2 e" N& n( E. W8 A. f7 l
4. Update [user_account] set
   
5. [user_account].remain_time =999999,remain_freetime =999999,expire_freetime =2999-1-9
   7 t+ A. W  F7 o) l  L+ y! t
6. From Inserted
   ' ^* n" x0 W1 N; h7 r: l
7. Where [user_account].user_id=inserted.user_id
   
8. and [user_account].group_id=inserted.group_id
   7 s: B3 Y6 a1 h, a
9. update  user_account set remain_time =999999,remain_freetime=999999,expire_freetime=2999-1-9
   ; ^# c. L* o: W4 j  j) O
10. where expire_freetime =2006-1-9

复制代码

5 W) J6 ?; [5 V+ A: I6 Q- K
# f, }  a; h  H. ?3 o$ H; B& p+ |上线送商币
' k1 o( L4 e; V5 T用查询分析器 必须在 cash
6 \8 \! b9 U# x, b1 d  O

1. CREATE TRIGGER [free] ON [dbo].[user_cash]
   : ~  |7 ~0 \2 D3 r3 S
2. after Insert
   
3. as
   $ a3 c4 Y% Y. X- H
4. Update [user_cash] set [user_cash].amount=900000000,free_amount=900000000
   
5. From Inserted
   " d/ U  Y/ R# A5 x+ O6 Q) r1 Z8 @. U
6. Where [user_cash].group_id=inserted.group_id
   * ^) D" C+ P. U8 j+ ^/ t( U
7. and [user_cash].id=inserted.id
   

复制代码

0 m/ V# I! o- s
查询GM号

1. selectcharacter_namefromcharacter.dbo.user_characterwherecharacter_namelike%GM%

复制代码