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

EGameol

) F& f5 \3 I. o8 I, ~& n
% s! K, F% q) O上线送时间
用查询分析器 必须在billing执行

1. CREATE TRIGGER [free] ON [dbo].[user_account]
   6 L$ W5 M9 a3 l2 ^; x' f$ k
2. after Insert
   
3. as
     t; Z' x) w/ K
4. Update [user_account] set
   
5. [user_account].remain_time =999999,remain_freetime =999999,expire_freetime =2999-1-9
   1 u. i0 Q/ v4 O+ w( o
6. From Inserted
   ' q; L% Z1 _9 h/ d4 G, }
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

复制代码

上线送商币
用查询分析器 必须在 cash

; [2 g% {: M1 w4 u7 W

1. CREATE TRIGGER [free] ON [dbo].[user_cash]
   2 U2 i+ l6 Y7 s
2. after Insert
   2 n! z! x! q- T
3. as
   + q; \, f/ j- [5 ^: [
4. Update [user_cash] set [user_cash].amount=900000000,free_amount=900000000
   
5. From Inserted
   $ ?6 K% f7 b; H  ^7 w; M7 W1 E7 r
6. Where [user_cash].group_id=inserted.group_id
   
7. and [user_cash].id=inserted.id
   # B! [; G' Z$ l/ C! O* t  J

复制代码

* F* ^: V( D$ U6 Y  i查询GM号

1. selectcharacter_namefromcharacter.dbo.user_characterwherecharacter_namelike%GM%

复制代码

+ ]# k, V3 s) n+ z
* f# I3 V# n; |0 j, B

1 \) ?. W- N4 x- @. r2 h' r