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

EGameol

上线送时间
用查询分析器 必须在billing执行
" k' Y: E6 w" \- v# b1 K& x: a+ X

1. CREATE TRIGGER [free] ON [dbo].[user_account]
   
2. after Insert
   6 @; V" a0 O5 B: c3 H. j
3. as
   . B: q1 j; Q8 c, [4 n* x2 T; U
4. Update [user_account] set
     Y6 b* d  q& A" ~- I  R/ c: h
5. [user_account].remain_time =999999,remain_freetime =999999,expire_freetime =2999-1-9
   ! {/ J3 @- T* z# C: W* o" i
6. From Inserted
   
7. Where [user_account].user_id=inserted.user_id
   
8. and [user_account].group_id=inserted.group_id
   / t7 X; r+ ]5 ?0 l
9. update  user_account set remain_time =999999,remain_freetime=999999,expire_freetime=2999-1-9
   ' P3 z7 t! r) F# B' R2 _
10. where expire_freetime =2006-1-9

复制代码

  E; q; ?$ q3 u4 V
' s' r5 l5 I) J, p& v9 f8 t上线送商币
, K3 M  l2 k9 F7 \用查询分析器 必须在 cash

1. CREATE TRIGGER [free] ON [dbo].[user_cash]
   
2. after Insert
   9 q9 P) w$ `$ m9 s) O; J  b" m
3. as
   
4. Update [user_cash] set [user_cash].amount=900000000,free_amount=900000000
   
5. From Inserted
   
6. Where [user_cash].group_id=inserted.group_id
   ' A0 K& ^& i2 O5 u  C
7. and [user_cash].id=inserted.id
   5 B" v- O% R0 x& U6 b: n% [

复制代码

" b/ ^( e) }, R查询GM号

1. selectcharacter_namefromcharacter.dbo.user_characterwherecharacter_namelike%GM%

复制代码

& q& T1 h& q8 o
( O9 q7 W% m- ^8 N( G
0 Z! K1 i. F+ ^. F7 B/ P5 }