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

EGameol

( [: X6 m9 E9 h* u1 q7 u7 `
9 r9 B, z) X8 T/ y3 k4 S; x上线送时间
/ `& |7 d: d' Y" C! K( `, m# o/ a用查询分析器 必须在billing执行
) A1 W( J0 d8 i9 F) R& ]

1. CREATE TRIGGER [free] ON [dbo].[user_account]
   
2. after Insert
   3 c. ^% w1 I3 P/ j$ G
3. as
   
4. Update [user_account] set
   ( g  ~. N  @8 h* o& G
5. [user_account].remain_time =999999,remain_freetime =999999,expire_freetime =2999-1-9
   : \% q5 s8 Y) O% ]/ Y$ N2 P0 C  b. W
6. From Inserted
   4 a# M# ~( A! E$ O7 Y8 v5 h# ~+ q+ D
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
   * |; y3 @7 U" e+ q
10. where expire_freetime =2006-1-9

复制代码

1 M$ V! D# [% i  b% b4 f上线送商币
  F. ]( b, ~$ b& |' Q5 K) ^' c用查询分析器 必须在 cash
5 T! z/ M3 p4 |
9 m$ T" ]# ]+ ^( t5 Q% w

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
   
5. From Inserted
   
6. Where [user_cash].group_id=inserted.group_id
   
7. and [user_cash].id=inserted.id
   

复制代码

9 @4 u0 X" E  ?6 h6 X. n
5 h) b# h' [; C; c查询GM号

1. selectcharacter_namefromcharacter.dbo.user_characterwherecharacter_namelike%GM%

复制代码

# N# u5 ^: q! \