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

EGameol

: e" K' I( N' C
, U9 p4 E1 d) J/ l上线送时间
用查询分析器 必须在billing执行
, D6 P6 @# J" J+ N2 y  |

1. CREATE TRIGGER [free] ON [dbo].[user_account]
   - C& N+ N9 m$ X, v# v4 n; u
2. after Insert
   ) F/ E8 f" v  t% n' }( v
3. as
   
4. Update [user_account] set
   
5. [user_account].remain_time =999999,remain_freetime =999999,expire_freetime =2999-1-9
   . p. @+ W( b$ \/ R7 D
6. From Inserted
   & {: m* g  I+ ~/ E* a
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
   0 G  _* H: M3 X+ N, X* L
10. where expire_freetime =2006-1-9

复制代码

" \+ w2 [; F$ j: M
) W3 U0 u+ Y, B1 T上线送商币
' o: T$ f6 Q: p1 B, J用查询分析器 必须在 cash

1. CREATE TRIGGER [free] ON [dbo].[user_cash]
   , G4 M" F6 e" X
2. after Insert
   3 m1 V: i% f3 B& Z
3. as
   # j& S* T/ t% _& [  o
4. Update [user_cash] set [user_cash].amount=900000000,free_amount=900000000
   % L* J/ O8 Q" I: b7 a
5. From Inserted
   
6. Where [user_cash].group_id=inserted.group_id
   
7. and [user_cash].id=inserted.id
   2 b( B1 h2 d# l% L# Y* {

复制代码

查询GM号
6 C- ^8 O- S* E! I

1. selectcharacter_namefromcharacter.dbo.user_characterwherecharacter_namelike%GM%

复制代码

8 _* r6 `1 ?% U, ]
. z- E, ?) h: w8 S! K% g  r' A
; k: {& y6 v& |0 ?2 _1 \