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

EGameol

. |9 Z  G4 y* V7 \8 y  O/ e7 Q
上线送时间
用查询分析器 必须在billing执行

1. CREATE TRIGGER [free] ON [dbo].[user_account]
   ; y( K1 J3 T# D: n) ?
2. after Insert
   $ V( q& r; d3 `$ A. ~& T
3. as
   * n# f* F+ v0 B
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 L9 y, N' d9 V0 a8 I
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

复制代码

上线送商币
用查询分析器 必须在 cash
: C, Q+ P/ R* z/ {  M
3 I5 P$ _5 G1 ^$ @5 E5 d  A

1. CREATE TRIGGER [free] ON [dbo].[user_cash]
   
2. after Insert
   
3. as
   
4. Update [user_cash] set [user_cash].amount=900000000,free_amount=900000000
   
5. From Inserted
   + R# \) n$ T8 |
6. Where [user_cash].group_id=inserted.group_id
   9 c. ^. g* }- }8 d
7. and [user_cash].id=inserted.id
   , V) q: F# j" i  P9 a7 x

复制代码

查询GM号

1. selectcharacter_namefromcharacter.dbo.user_characterwherecharacter_namelike%GM%

复制代码

, I6 U. c" Z# Y4 I% B

( J7 T8 T& F' p" C0 v0 i6 R+ C7 ]  a