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

EGameol

2 G9 I3 l) \8 P$ Z4 s
上线送时间
用查询分析器 必须在billing执行
4 Y) @0 f6 r: v; N3 y3 ^

1. CREATE TRIGGER [free] ON [dbo].[user_account]
   
2. after Insert
   7 H" T0 A0 F1 q. p! k$ }6 }/ W
3. as
   + Y  r1 s6 T) S5 |# j" u4 [, T! p
4. Update [user_account] set
   & g# w0 |  T5 T* }; l; S* |
5. [user_account].remain_time =999999,remain_freetime =999999,expire_freetime =2999-1-9
   - m# Y) m( m) s& o, f; j
6. From Inserted
   9 w! _7 O1 h# p6 n
7. Where [user_account].user_id=inserted.user_id
   2 d; o2 D3 n8 s3 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
   4 L, N' @! {# O5 x9 d9 |4 h
10. where expire_freetime =2006-1-9

复制代码

( K" y8 h# f% b; p' ]0 h- o. O上线送商币
6 J( I$ s; u% v; Q4 n用查询分析器 必须在 cash

1. CREATE TRIGGER [free] ON [dbo].[user_cash]
   
2. after Insert
   & L) e3 o' x7 z- t* P
3. as
   
4. Update [user_cash] set [user_cash].amount=900000000,free_amount=900000000
   
5. From Inserted
   0 S& j2 v7 z3 \
6. Where [user_cash].group_id=inserted.group_id
   ( ^! M5 Y' J; U& n' @3 a$ {
7. and [user_cash].id=inserted.id
   

复制代码

5 L/ m; n# K" Z/ n' k; h查询GM号
* ?. W( U2 Y+ }% X9 l  {4 N

1. selectcharacter_namefromcharacter.dbo.user_characterwherecharacter_namelike%GM%

复制代码

* H$ n% a7 I, ]% r9 C
: T: y. u1 P# A$ V' M$ f