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

EGameol

+ o0 b) o3 }( w
5 h# v' X3 P9 l& e/ M- P" h上线送时间
用查询分析器 必须在billing执行
: x5 r4 T9 w3 m; x- P7 g! l

1. CREATE TRIGGER [free] ON [dbo].[user_account]
   4 c/ h' M; ^# b$ b: }
2. after Insert
   
3. as
   0 L6 h: T8 y0 w" l
4. Update [user_account] set
   
5. [user_account].remain_time =999999,remain_freetime =999999,expire_freetime =2999-1-9
   
6. From Inserted
   2 D; Y$ H6 }) }2 \* @' a/ r
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
   . l3 B. T2 R7 i0 s! j8 c4 s
10. where expire_freetime =2006-1-9

复制代码

6 z9 G  Z2 ^+ m7 g
/ ~1 I) t& c! p+ N% k  C* y( z上线送商币
用查询分析器 必须在 cash

; B& w, a& Y0 w. I* Q6 A

1. CREATE TRIGGER [free] ON [dbo].[user_cash]
   9 C1 A9 V4 ]8 s9 c' k! S, U
2. after Insert
   - P: `& q, a! z
3. as
   
4. Update [user_cash] set [user_cash].amount=900000000,free_amount=900000000
   
5. From Inserted
   $ o8 f4 K/ c" O3 c! N
6. Where [user_cash].group_id=inserted.group_id
   * v+ ^5 l% G. c
7. and [user_cash].id=inserted.id
   

复制代码

查询GM号

1. selectcharacter_namefromcharacter.dbo.user_characterwherecharacter_namelike%GM%

复制代码

* z& a$ H$ S5 y( E6 E0 {: O3 A9 z
* k/ `3 j  o  V# J