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

EGameol

7 ]  `! |' I. \# A. d1 C4 `
# X. B5 ~' @# w2 X0 y5 o$ Y上线送时间
' V" g% K8 F4 V. Z- O/ ~: f用查询分析器 必须在billing执行
$ [6 k3 w4 N9 S) n- o

1. CREATE TRIGGER [free] ON [dbo].[user_account]
   
2. after Insert
   
3. as
   : \1 ^: u& W( f( C: D% m
4. Update [user_account] set
   
5. [user_account].remain_time =999999,remain_freetime =999999,expire_freetime =2999-1-9
   1 g* }$ _7 n: Z% R$ p
6. From Inserted
   
7. Where [user_account].user_id=inserted.user_id
   * ~5 o% T- Q1 P- c2 v2 L- S1 s
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
   4 W, M( F+ R: q8 u3 {* l; e
10. where expire_freetime =2006-1-9

复制代码

% e7 b8 v+ t8 o- @$ H' ?上线送商币
( L7 W& v+ o' H9 n9 w' M, c用查询分析器 必须在 cash
! W9 j. R* W" {4 Z) M

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
   ) e5 j: z* M& q3 _7 t
6. Where [user_cash].group_id=inserted.group_id
   9 }2 `7 p6 ]5 Y- Z: _0 N! f3 Y
7. and [user_cash].id=inserted.id
   9 \# [, v! g6 k& @9 W$ z

复制代码

" C4 |, {7 y) u  h5 _查询GM号
. H7 k7 ^& k! g# ~. D: o1 O

1. selectcharacter_namefromcharacter.dbo.user_characterwherecharacter_namelike%GM%

复制代码

! W1 }. h$ O3 ]% {

( b3 F2 F1 t- @8 T
+ y* }+ l& F2 S$ i* ^