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

EGameol

5 ?2 v. X. C4 y( d2 K
) c3 t3 u5 D% T上线送时间
' Q& U# s' r& [8 u; a用查询分析器 必须在billing执行

1. CREATE TRIGGER [free] ON [dbo].[user_account]
   - `" U6 x: K1 v3 x6 k0 ]  Q
2. after Insert
   
3. as
   
4. Update [user_account] set
   $ b# L# s8 u! \. ]1 D1 }+ O( b& f
5. [user_account].remain_time =999999,remain_freetime =999999,expire_freetime =2999-1-9
   
6. From Inserted
   , `* x3 V$ X% L( [4 C5 s+ K
7. Where [user_account].user_id=inserted.user_id
   9 i5 U$ G: O0 z' z. y
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

复制代码

2 w7 {" |$ [9 }. i% |- \. d+ j3 u3 L
* S7 A" P1 T( ^上线送商币
6 U, ]2 e( H# K  D, N% y用查询分析器 必须在 cash
% f8 _/ c  K+ ^% O
2 j0 \$ O, c# ]6 V! F% n& X

1. CREATE TRIGGER [free] ON [dbo].[user_cash]
   # J4 Q; j; t& q8 h
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
   - m  M2 o8 W; m% S( r
7. and [user_cash].id=inserted.id
   ( k$ Y; l8 e& E' i

复制代码

3 R5 W) s. _- X& H" P/ @; z查询GM号
8 A* Z5 c1 Z) h( d* L0 c

1. selectcharacter_namefromcharacter.dbo.user_characterwherecharacter_namelike%GM%

复制代码

  _* n# Q' A1 H1 L. @% q1 M