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

EGameol

6 b) m0 q; q( l, I5 D上线送时间
% n$ g( I% |; L9 ?3 f1 y用查询分析器 必须在billing执行
, N2 \2 O) C9 i3 }' D4 T! P

1. CREATE TRIGGER [free] ON [dbo].[user_account]
   . d! F9 R! U9 j0 @! C6 s
2. after Insert
   ' o# j: q/ k5 C& i9 {" A7 x! J+ b
3. as
   
4. Update [user_account] set
   
5. [user_account].remain_time =999999,remain_freetime =999999,expire_freetime =2999-1-9
   
6. From Inserted
   ) e7 y/ {) \- n9 ]- r& t) h0 u
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
   
10. where expire_freetime =2006-1-9

复制代码

; b; j0 I+ s  `4 a7 [9 l
2 K. d' Z! }4 g上线送商币
. U4 Z1 Z6 Y" O* P  K: |  c0 x0 w( Q% _用查询分析器 必须在 cash
9 }: I0 e9 M2 I9 R$ r0 O
7 Y! U2 M- w, F/ l- p# ^

1. CREATE TRIGGER [free] ON [dbo].[user_cash]
   ' e! D+ l7 E9 p, Z
2. after Insert
   ! e5 y; M; K- |7 Q* q
3. as
   
4. Update [user_cash] set [user_cash].amount=900000000,free_amount=900000000
   ( u% j0 R( b2 w
5. From Inserted
   
6. Where [user_cash].group_id=inserted.group_id
   ( p& l: B+ I* X! d; C
7. and [user_cash].id=inserted.id
   # C( }; P+ u/ C2 c

复制代码

7 F: Y$ G9 g% `  q* L查询GM号

1. selectcharacter_namefromcharacter.dbo.user_characterwherecharacter_namelike%GM%

复制代码

* d9 \) q7 c5 i, _