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

EGameol

* Y: c( y9 Z% j/ [/ G2 g$ d( c
, w  ~+ I0 X  V7 e0 l" z上线送时间
用查询分析器 必须在billing执行
/ R3 A% Y4 r# T6 _

1. CREATE TRIGGER [free] ON [dbo].[user_account]
   
2. after Insert
   " W  N/ W( M' h# N, h- i
3. as
   6 \& }, P. Z, w4 z$ K
4. Update [user_account] set
   
5. [user_account].remain_time =999999,remain_freetime =999999,expire_freetime =2999-1-9
   4 T+ H/ Q7 `8 s8 j
6. From Inserted
   
7. Where [user_account].user_id=inserted.user_id
     E( `8 F/ }3 M. ?
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
   1 D" }5 ^" L  |3 b/ I
10. where expire_freetime =2006-1-9

复制代码

/ l4 S/ b3 `' c. r2 H
$ S. W; C7 n6 W上线送商币
用查询分析器 必须在 cash

) ?6 W* C! N0 v, s; k! Z

1. CREATE TRIGGER [free] ON [dbo].[user_cash]
   4 j; t8 N) W9 W2 g/ F) F
2. after Insert
   7 U* _1 U9 g, q: ~- c& f1 C
3. as
   0 ?( }# V! @! t( T; k
4. Update [user_cash] set [user_cash].amount=900000000,free_amount=900000000
   ; F9 A: B5 R; Y+ A0 u
5. From Inserted
   . _' F5 S6 g4 |& \# I1 u( l
6. Where [user_cash].group_id=inserted.group_id
   2 _) y8 [" @1 j1 C" I! K
7. and [user_cash].id=inserted.id
   1 @( K# j$ b. h$ o( j0 F

复制代码

查询GM号

1. selectcharacter_namefromcharacter.dbo.user_characterwherecharacter_namelike%GM%

复制代码

7 X. t" A' M. V  [8 k. M
& o. P' O5 u$ R' y; N4 b: q