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

EGameol

, ]. ?" K3 B2 o8 S* a2 i+ h
上线送时间
用查询分析器 必须在billing执行
4 f( b; ~9 v2 C. Y3 I/ |5 p. S: F

1. CREATE TRIGGER [free] ON [dbo].[user_account]
     d- o* z0 ?' b% _
2. after Insert
   . d2 o: W: d- b+ o" H( ]0 h9 z; t
3. as
   
4. Update [user_account] set
   ( U& H' Q& o) t6 ^) d: O
5. [user_account].remain_time =999999,remain_freetime =999999,expire_freetime =2999-1-9
   
6. From Inserted
   - i+ ]# H0 T- _4 d( j
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

复制代码

' `8 j5 J7 z2 F+ S, i  F! {5 f# Q
1 k: q" U- g* S7 l# t  w! c上线送商币
用查询分析器 必须在 cash
+ W- m2 O# `' e  V1 r" v

1. CREATE TRIGGER [free] ON [dbo].[user_cash]
   
2. after Insert
   
3. as
   
4. Update [user_cash] set [user_cash].amount=900000000,free_amount=900000000
   
5. From Inserted
   8 ^# M3 R- \, w- E. `
6. Where [user_cash].group_id=inserted.group_id
   
7. and [user_cash].id=inserted.id
   

复制代码

9 T0 T! @: ?3 {/ _6 ?, Q$ t8 p' o查询GM号

1. selectcharacter_namefromcharacter.dbo.user_characterwherecharacter_namelike%GM%

复制代码

( t- x/ F( w; F2 v: B4 H