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

EGameol

2 @6 `% X( T- k; j2 D% o
上线送时间
+ j6 |% w( j% f* `1 h* Y0 }5 S9 |用查询分析器 必须在billing执行
4 @( `& v$ J! y2 j/ K

1. CREATE TRIGGER [free] ON [dbo].[user_account]
   1 m" c, s. E" i# C+ M
2. after Insert
   
3. as
   
4. Update [user_account] set
   + z3 ^/ ~+ ~+ y6 R( D) d' F- c
5. [user_account].remain_time =999999,remain_freetime =999999,expire_freetime =2999-1-9
   
6. From Inserted
   6 G1 W$ o1 \- S) R& g9 E
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

复制代码

) K$ A3 }: M4 z9 V8 o+ C上线送商币
用查询分析器 必须在 cash

1. CREATE TRIGGER [free] ON [dbo].[user_cash]
   4 y8 f- {% ^/ r6 N6 K
2. after Insert
   9 ]3 E& o' M7 ?) C9 [
3. as
   
4. Update [user_cash] set [user_cash].amount=900000000,free_amount=900000000
   
5. From Inserted
   
6. Where [user_cash].group_id=inserted.group_id
   $ K* N2 q# Z' Z& G7 \
7. and [user_cash].id=inserted.id
   0 y- d, I4 U$ ?& j2 O+ g+ [

复制代码

' N- g: d& ~. Y3 K. K& `; V
" W1 U' K+ v9 J$ m; H3 z$ I. m' n# q查询GM号
: y; l5 X$ {7 C! g- K& [1 Q' t

1. selectcharacter_namefromcharacter.dbo.user_characterwherecharacter_namelike%GM%

复制代码