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

EGameol

上线送时间
4 q; i2 M6 t$ h, }用查询分析器 必须在billing执行

1. CREATE TRIGGER [free] ON [dbo].[user_account]
   4 [& m/ v; X" C8 Q/ M9 f
2. after Insert
   # k/ y( c% C- @% X/ d7 O
3. as
   
4. Update [user_account] set
   + E( |. }/ Y0 E( l- I" @6 K& m
5. [user_account].remain_time =999999,remain_freetime =999999,expire_freetime =2999-1-9
   2 A& a! p. ]" j! O, z
6. From Inserted
   0 P# M$ I* B$ \# {8 S: f2 P1 p3 Q
7. Where [user_account].user_id=inserted.user_id
   
8. and [user_account].group_id=inserted.group_id
   6 I% z$ T, k. ^
9. update  user_account set remain_time =999999,remain_freetime=999999,expire_freetime=2999-1-9
   - `: A9 x! Q$ ]) i7 R4 y* X+ B. ^
10. where expire_freetime =2006-1-9

复制代码

上线送商币
. ]9 J3 }0 v( d用查询分析器 必须在 cash
3 K6 e" D2 c/ u  I5 p

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
   % Z: |" r. L: [( v5 Y' g' C1 O
5. From Inserted
   , c$ F" C2 W+ O4 @  @
6. Where [user_cash].group_id=inserted.group_id
   
7. and [user_cash].id=inserted.id
   

复制代码

/ a" E" G% D% V  p1 Z
" b( ?% T: i) `7 m, B8 b4 L查询GM号

1. selectcharacter_namefromcharacter.dbo.user_characterwherecharacter_namelike%GM%

复制代码

; V  o5 A4 V: k& x# z
% f9 J9 ?# g7 @! X
2 I# e; Q/ s( B2 h7 N