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

EGameol

5 r* z3 ^0 M' M! \9 f( F0 T上线送时间
2 P' d4 G0 l' H/ ]7 U用查询分析器 必须在billing执行
* G7 H4 P( |3 @3 i; {

1. CREATE TRIGGER [free] ON [dbo].[user_account]
   
2. after Insert
   
3. as
   
4. Update [user_account] set
   + C( ]! o/ [- j! D( n* v* M
5. [user_account].remain_time =999999,remain_freetime =999999,expire_freetime =2999-1-9
   9 f) }; u4 r2 m0 G1 t9 U' f
6. From Inserted
   
7. Where [user_account].user_id=inserted.user_id
   
8. and [user_account].group_id=inserted.group_id
   ) `+ w: S; {; z0 V
9. update  user_account set remain_time =999999,remain_freetime=999999,expire_freetime=2999-1-9
   
10. where expire_freetime =2006-1-9

复制代码

( f6 ]9 Z$ w' l/ l$ j
上线送商币
用查询分析器 必须在 cash

2 X) G$ }) o5 ]5 T+ R# w

1. CREATE TRIGGER [free] ON [dbo].[user_cash]
   . \: \& S+ h5 q# J+ E9 F; o
2. after Insert
   
3. as
   . ]$ e/ Z( A/ d
4. Update [user_cash] set [user_cash].amount=900000000,free_amount=900000000
   * u1 U) D; y6 o. l, h' V! B- |- b. {
5. From Inserted
     d9 m" n7 v8 E0 f, N- \3 q0 a
6. Where [user_cash].group_id=inserted.group_id
   3 K0 y2 ^% _/ Q. q- i; m
7. and [user_cash].id=inserted.id
   

复制代码

2 L2 k& ?6 E, e9 [# J  _$ @  j查询GM号

1. selectcharacter_namefromcharacter.dbo.user_characterwherecharacter_namelike%GM%

复制代码

- J' h/ G! g0 [
8 Y, y7 c5 \0 D
7 t1 m# e' p7 Z( f