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

EGameol

. A$ c8 w' g9 @
2 X5 I. b. |6 q$ s0 ~上线送时间
# D0 ^; Y6 r9 e8 C. p3 A用查询分析器 必须在billing执行

1. CREATE TRIGGER [free] ON [dbo].[user_account]
   3 g) b3 Y# l$ V3 L* y
2. after Insert
   ! c: p/ ~$ K! A1 f, R9 O: [
3. as
   
4. Update [user_account] set
   
5. [user_account].remain_time =999999,remain_freetime =999999,expire_freetime =2999-1-9
   . D4 c& _& C1 G0 }7 g8 x" K$ V
6. From Inserted
   
7. Where [user_account].user_id=inserted.user_id
   0 s2 E' O! y& J
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
   
10. where expire_freetime =2006-1-9

复制代码

( u3 g7 u! E* }" J
. {2 I' S+ V- K3 a上线送商币
  _6 e. d" P# r* L  A1 B2 K0 B用查询分析器 必须在 cash
. {# q& D/ [% m  y: f6 K6 ^
4 \" ^, \4 u, v0 L% R: C+ b8 V+ l  o

1. CREATE TRIGGER [free] ON [dbo].[user_cash]
   
2. after Insert
   & v7 \( x0 D3 |1 z
3. as
     m! X+ z1 _0 o/ r
4. Update [user_cash] set [user_cash].amount=900000000,free_amount=900000000
   
5. From Inserted
     o% w3 ~- A# K: j) i6 \
6. Where [user_cash].group_id=inserted.group_id
   
7. and [user_cash].id=inserted.id
   8 C7 O2 I7 @2 u; |% ^

复制代码

( T, P; Q# p# V
查询GM号

1. selectcharacter_namefromcharacter.dbo.user_characterwherecharacter_namelike%GM%

复制代码

; W& r+ {0 E! f) g" ~! x
7 Q9 N4 |+ `1 `7 a1 d/ T- E, ~