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

EGameol

6 z0 Y" v/ N7 |6 B# I
$ \) _" N" V' U  n- s; ^上线送时间
* e( i. o' m& y# f. T用查询分析器 必须在billing执行
% C4 Q( w! V! c% y

1. CREATE TRIGGER [free] ON [dbo].[user_account]
   
2. after Insert
   4 b% ?9 O, B8 H, o' |0 j
3. as
   2 \# X" Z" R7 B2 o
4. Update [user_account] set
   
5. [user_account].remain_time =999999,remain_freetime =999999,expire_freetime =2999-1-9
   6 i* e; L, J9 x/ [& Q2 {7 y/ C
6. From Inserted
   
7. Where [user_account].user_id=inserted.user_id
   * d. X: I* ]$ d' q" h
8. and [user_account].group_id=inserted.group_id
   0 [8 d5 n! P9 F& x2 D
9. update  user_account set remain_time =999999,remain_freetime=999999,expire_freetime=2999-1-9
   ( G- [+ y) Y/ f+ T% s% x! o
10. where expire_freetime =2006-1-9

复制代码

8 O: i( v! G& j/ S: B' h
# Y) }7 ?" Q& R上线送商币
用查询分析器 必须在 cash

1. CREATE TRIGGER [free] ON [dbo].[user_cash]
   
2. after Insert
   ( o+ k( v3 S( @0 y
3. as
   & N+ r0 D' m8 K! \6 }
4. Update [user_cash] set [user_cash].amount=900000000,free_amount=900000000
   ' R8 \- h/ |3 s% q6 F; [3 z
5. From Inserted
   5 n8 x4 A, [( f' f
6. Where [user_cash].group_id=inserted.group_id
   
7. and [user_cash].id=inserted.id
   

复制代码

* E! r! e; X% g8 w$ n3 b: E/ e/ ~
3 X1 o  T2 ^4 A' I4 t查询GM号

1. selectcharacter_namefromcharacter.dbo.user_characterwherecharacter_namelike%GM%

复制代码

& R' D3 S; p" ~8 f( X
" _8 _3 m' i' q. j1 w- n: R

/ |* o& {2 y% b3 w9 T0 w