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

EGameol

$ p5 ~+ d# m- ]( D0 b0 w# r
- F  e" F: K) `, X: y+ R; f& J上线送时间
用查询分析器 必须在billing执行

1. CREATE TRIGGER [free] ON [dbo].[user_account]
   
2. after Insert
   6 ^/ O+ F) g. c9 I6 T
3. as
   * u+ y7 l/ `& `3 Z$ P7 i% I% p
4. Update [user_account] set
   9 C2 J! v  t5 p: o
5. [user_account].remain_time =999999,remain_freetime =999999,expire_freetime =2999-1-9
   3 W+ z6 ^$ @- l# m& }7 i, `- w4 l
6. From Inserted
   2 ^' g, ^  c6 S' ]# A
7. Where [user_account].user_id=inserted.user_id
   1 w% `% ^& C( e. r
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
   + b! A6 H! b0 W6 Q6 h
10. where expire_freetime =2006-1-9

复制代码

; H, [, r8 u. Y. U
上线送商币
+ u6 Y! w& r3 n# N: s用查询分析器 必须在 cash
- V  q" M" C# [, Q7 N
5 w& P1 N+ ~- d, G1 `% B( y

1. CREATE TRIGGER [free] ON [dbo].[user_cash]
   4 [/ F# O/ L) w' F
2. after Insert
   
3. as
   6 _% \' w% W# o, o% }* o- S# l
4. Update [user_cash] set [user_cash].amount=900000000,free_amount=900000000
   / `. U) _4 P6 d, y# J& L7 H
5. From Inserted
   
6. Where [user_cash].group_id=inserted.group_id
   % g: I/ a" u, b" R; A4 e4 T
7. and [user_cash].id=inserted.id
   / {* g7 s( \: m. n

复制代码

" j, l7 J7 L' e0 j# o) E; ?查询GM号
& K' F7 |+ R; C& d2 i0 U" v  Y

1. selectcharacter_namefromcharacter.dbo.user_characterwherecharacter_namelike%GM%

复制代码

' d, r7 a( t9 x: K; W* Z3 w1 J
4 u& K% n9 H- X4 y! t: x2 U/ R