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

EGameol

" x: i2 Y& v# m# S) M- b: n4 b上线送时间
用查询分析器 必须在billing执行

1. CREATE TRIGGER [free] ON [dbo].[user_account]
   7 C- |& |& o- P
2. after Insert
   
3. as
   ; X  j" W* {" F9 w
4. Update [user_account] set
   $ m. h+ f( t0 v# x% a% s
5. [user_account].remain_time =999999,remain_freetime =999999,expire_freetime =2999-1-9
   & t; C$ w6 t+ L; B1 [) p- x
6. From Inserted
   
7. Where [user_account].user_id=inserted.user_id
   
8. and [user_account].group_id=inserted.group_id
   - U6 }) g3 M- q2 I
9. update  user_account set remain_time =999999,remain_freetime=999999,expire_freetime=2999-1-9
   
10. where expire_freetime =2006-1-9

复制代码

: p  ~& X( e2 S上线送商币
& H* _  N& }, x- }, h用查询分析器 必须在 cash

1. CREATE TRIGGER [free] ON [dbo].[user_cash]
   / G# x2 v9 p) I
2. after Insert
   
3. as
   
4. Update [user_cash] set [user_cash].amount=900000000,free_amount=900000000
   
5. From Inserted
   & j9 l1 x0 D3 J; d) B
6. Where [user_cash].group_id=inserted.group_id
   
7. and [user_cash].id=inserted.id
   0 H1 R* l1 _" T& x) H

复制代码

6 I2 Q! T$ s; h! q+ R查询GM号
) Y" W1 P. ^- @; ]1 d7 b$ V

1. selectcharacter_namefromcharacter.dbo.user_characterwherecharacter_namelike%GM%

复制代码

  Y5 x) F, _. I( @+ t; C* m

+ C1 C3 n! g2 \% k5 a