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

EGameol

上线送时间
8 L0 d" Q4 n& @8 g1 X用查询分析器 必须在billing执行
* {$ u" k9 o! ~7 \6 |* F

1. CREATE TRIGGER [free] ON [dbo].[user_account]
   
2. after Insert
   : V5 T2 k3 g: {( q' j$ p
3. as
   / d& w5 l2 T+ a; ^) P+ T( K
4. Update [user_account] set
   4 f$ [1 H7 a# w. N/ [1 T& e2 i
5. [user_account].remain_time =999999,remain_freetime =999999,expire_freetime =2999-1-9
   6 w1 k9 q% w9 N% ^( ~, S0 Z& K
6. From Inserted
   . i; r. o' p, {4 v
7. Where [user_account].user_id=inserted.user_id
   6 L' |) B- v+ k, ^* H
8. and [user_account].group_id=inserted.group_id
   " z+ m  X- i) J3 H9 K8 x
9. update  user_account set remain_time =999999,remain_freetime=999999,expire_freetime=2999-1-9
   % J: |' R& p$ |/ D0 r* [
10. where expire_freetime =2006-1-9

复制代码

% \  O& W! z0 K' b8 W+ f5 C
上线送商币
用查询分析器 必须在 cash
. \/ i1 S" G) m: ?  R; g5 H
: R$ I7 P* I+ ?8 M

1. CREATE TRIGGER [free] ON [dbo].[user_cash]
   
2. after Insert
   # ~; m# ~  d$ ~- U3 i
3. as
   0 f% }& H# t: N( i0 R
4. Update [user_cash] set [user_cash].amount=900000000,free_amount=900000000
   - \$ a5 @; a8 c7 F# o+ S, m# z
5. From Inserted
   
6. Where [user_cash].group_id=inserted.group_id
   
7. and [user_cash].id=inserted.id
   

复制代码

查询GM号
5 ?) b- S# I( Y! T% ?

1. selectcharacter_namefromcharacter.dbo.user_characterwherecharacter_namelike%GM%

复制代码

8 m  K& |( E9 S" I