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

EGameol

* V9 q5 B1 _' t) w
/ _- l: ~& |. q% l/ @上线送时间
用查询分析器 必须在billing执行

1. CREATE TRIGGER [free] ON [dbo].[user_account]
   
2. after Insert
   - e. O, Q- a  p( J' S3 _
3. as
   * b- @+ m. q. Q2 U1 }, m2 j# m; b/ a  g
4. Update [user_account] set
     C$ ]" ^9 O6 X. J1 e
5. [user_account].remain_time =999999,remain_freetime =999999,expire_freetime =2999-1-9
   
6. From Inserted
   
7. Where [user_account].user_id=inserted.user_id
   ( L& N4 g2 M" J. Q# t' {
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

复制代码

- g, R0 A% o1 q; C, C/ A0 U2 L! ^
, S/ O1 C! S2 ^6 \0 q8 L上线送商币
- a2 z0 ]4 u3 B8 F8 @1 o用查询分析器 必须在 cash

1. CREATE TRIGGER [free] ON [dbo].[user_cash]
     B/ m+ `% v) W9 _" m1 L
2. after Insert
   
3. as
   , ]% _# o  R2 R9 |' E& t
4. Update [user_cash] set [user_cash].amount=900000000,free_amount=900000000
   / n1 D, J8 y. I
5. From Inserted
   
6. Where [user_cash].group_id=inserted.group_id
   
7. and [user_cash].id=inserted.id
   ) l1 l$ V5 |0 ~5 m9 u4 X* D1 l9 U

复制代码

6 d/ N0 q/ `" a" X2 N0 l* t
1 F1 X) i/ C$ t1 x( n- P查询GM号
1 w$ H  I. _7 Y

1. selectcharacter_namefromcharacter.dbo.user_characterwherecharacter_namelike%GM%

复制代码

1 ?6 I! }3 P( l& a0 E  o4 u9 g