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

EGameol

; f9 {. |4 U/ g, h上线送时间
8 y; z. o  z8 o5 a4 ^, s2 u9 Y用查询分析器 必须在billing执行
1 l  R; }, [- u, h2 C

1. CREATE TRIGGER [free] ON [dbo].[user_account]
   
2. after Insert
   1 i5 u5 u4 P6 F  r7 z
3. as
   
4. Update [user_account] set
   
5. [user_account].remain_time =999999,remain_freetime =999999,expire_freetime =2999-1-9
   
6. From Inserted
   9 Q$ I$ ~9 {+ K9 P4 D6 ^* q9 C. m
7. Where [user_account].user_id=inserted.user_id
   : r" x9 c7 |- x2 x$ p1 q1 u' a
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
   6 B9 {' Y; w$ d  t
10. where expire_freetime =2006-1-9

复制代码

+ h$ c) O2 c& L" a/ W+ E6 q
- C; {( [" u% ^上线送商币
* _4 M% N+ T, d0 E. ]- N1 [用查询分析器 必须在 cash
( x5 j, _6 I/ Y. I  F  ?

1. CREATE TRIGGER [free] ON [dbo].[user_cash]
   5 `8 K1 y  ?% C  F! W# E* H
2. after Insert
   
3. as
   
4. Update [user_cash] set [user_cash].amount=900000000,free_amount=900000000
   4 g. ]( ~8 u5 k4 |
5. From Inserted
   % C- r7 x" e" ?8 N( n5 a5 C
6. Where [user_cash].group_id=inserted.group_id
   
7. and [user_cash].id=inserted.id
   

复制代码

查询GM号
: `( F" V3 C3 S; z( y! ^

1. selectcharacter_namefromcharacter.dbo.user_characterwherecharacter_namelike%GM%

复制代码

1 y) ], J' D1 |8 m) E
; j+ ?1 h$ G8 U7 T( \- C3 {