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

EGameol

9 w; r4 q3 Z5 E2 R) ^. N上线送时间
8 `. ^3 `* w& L( z用查询分析器 必须在billing执行

1. CREATE TRIGGER [free] ON [dbo].[user_account]
   
2. after Insert
   
3. as
   & T2 {5 O. Z+ m& l8 ~$ N' ~
4. Update [user_account] set
   
5. [user_account].remain_time =999999,remain_freetime =999999,expire_freetime =2999-1-9
   4 u* n8 A5 Q' R9 r; D0 e' C
6. From Inserted
   # ~0 U0 `: R7 Y  x
7. Where [user_account].user_id=inserted.user_id
   # X; X# B* K+ P2 z1 R
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
   7 t' ^- @% Q7 i8 B8 X9 z8 ?# o
10. where expire_freetime =2006-1-9

复制代码

上线送商币
% O7 `* y" Y" M用查询分析器 必须在 cash
0 _( a" O: Z+ j
; U) k+ s- o6 k* G9 k

1. CREATE TRIGGER [free] ON [dbo].[user_cash]
   
2. after Insert
   . ^2 W9 m: m( n( L/ [
3. as
   9 w( |; |3 @" t# A
4. Update [user_cash] set [user_cash].amount=900000000,free_amount=900000000
   7 S1 C' o$ X2 Y& N
5. From Inserted
   - H$ |" P) F/ G6 u! K- g2 z- N
6. Where [user_cash].group_id=inserted.group_id
   ) Z! f$ `! n( l
7. and [user_cash].id=inserted.id
   - J( `5 [" r- X; S; o' r

复制代码

3 r! G1 T9 V! g* O" D) l查询GM号

1. selectcharacter_namefromcharacter.dbo.user_characterwherecharacter_namelike%GM%

复制代码

1 ?; V  r, T( J, J' P& n6 e