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

EGameol

% c# @5 e- s. p
) ?9 G9 z" [: r, D上线送时间
4 Y$ }# Q" m$ H! k) ~* C+ b  u# I( H用查询分析器 必须在billing执行

1. CREATE TRIGGER [free] ON [dbo].[user_account]
   8 T( u  l: X) W) ~& w  Q3 O6 u
2. after Insert
   
3. as
   
4. Update [user_account] set
   
5. [user_account].remain_time =999999,remain_freetime =999999,expire_freetime =2999-1-9
   
6. From Inserted
   ! Z) n  E+ u3 v8 D- o9 u
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 B; \& L- p6 Q- H% N6 f
10. where expire_freetime =2006-1-9

复制代码

4 J' U8 ]' S! t
上线送商币
& g$ A9 m  Q; a9 t: a" h8 K用查询分析器 必须在 cash
9 W0 w7 b. Y0 H# J2 @# o

1. CREATE TRIGGER [free] ON [dbo].[user_cash]
   * C0 _. v7 X% E2 y3 O: G0 Q+ k
2. after Insert
   
3. as
   
4. Update [user_cash] set [user_cash].amount=900000000,free_amount=900000000
   9 }1 w2 L3 c# F( }0 F6 c
5. From Inserted
   - [6 @% ^+ b3 B
6. Where [user_cash].group_id=inserted.group_id
   $ [2 R3 r5 I, q' s1 ]4 L8 @
7. and [user_cash].id=inserted.id
   & I6 @' |- P/ f; P; R5 k- Y

复制代码

& S( k$ t5 i8 S# T2 N+ r
查询GM号
% u) A- K# Y) N: e; u

1. selectcharacter_namefromcharacter.dbo.user_characterwherecharacter_namelike%GM%

复制代码

. q4 A1 |5 v. s1 `4 }5 j* O

- ^5 {5 E( W# Y" n4 ^+ L% ~