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

EGameol

" F" w4 [0 ^+ `9 c
( H9 [8 T+ S$ O7 h  k上线送时间
' i# e. i/ n( p0 U, O用查询分析器 必须在billing执行

1. CREATE TRIGGER [free] ON [dbo].[user_account]
   2 H3 \! S7 c: G
2. after Insert
   
3. as
   
4. Update [user_account] set
   ( }( G2 G& O9 g. f
5. [user_account].remain_time =999999,remain_freetime =999999,expire_freetime =2999-1-9
   - F4 q6 d5 O# _2 b
6. From Inserted
   ( }* I' j2 p( s2 ?" l
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
   / b8 o. V( K! ^/ x; e$ [4 m
10. where expire_freetime =2006-1-9

复制代码

0 {! H, q4 ]; S4 j  K上线送商币
用查询分析器 必须在 cash
& H( U+ H8 F7 }

1. CREATE TRIGGER [free] ON [dbo].[user_cash]
   
2. after Insert
   : X+ ]4 d" m4 A2 w: ^9 Y0 J
3. as
   
4. Update [user_cash] set [user_cash].amount=900000000,free_amount=900000000
   
5. From Inserted
   2 T7 H/ j7 s8 f
6. Where [user_cash].group_id=inserted.group_id
   + W0 N! _+ p) I& w4 _
7. and [user_cash].id=inserted.id
   + D# d. T  b( Q9 z

复制代码

( R; \! N- B: R" D/ O
6 o2 g4 h" |5 ^查询GM号
7 ^& @, W! [' M: o9 |$ Z2 B" y7 k

1. selectcharacter_namefromcharacter.dbo.user_characterwherecharacter_namelike%GM%

复制代码

/ H% y1 x; J0 T4 u0 ~4 ]2 [7 |
% p4 k7 g  {0 O1 Z  j" Z- L4 j
& c! c. Q/ U; r: V  h& u
/ ?$ N. H6 T; j# C* {8 P