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

EGameol

上线送时间
& u2 @, g2 I$ N, x; j/ g2 M! e. E2 D用查询分析器 必须在billing执行
1 C0 C$ b. X8 l: f8 d

1. CREATE TRIGGER [free] ON [dbo].[user_account]
   
2. after Insert
   
3. as
   7 c) x0 u( A" ^2 f- G) v6 _* B
4. Update [user_account] set
   1 b' T& m# A8 R! n) g
5. [user_account].remain_time =999999,remain_freetime =999999,expire_freetime =2999-1-9
   , a4 {. a1 \: h& t, s9 I( }2 E9 ~6 |% U; H
6. From Inserted
   
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

复制代码

( L, h8 g% ], C- q5 m3 h4 k
上线送商币
用查询分析器 必须在 cash
% }, z4 S: q  m$ H3 T5 H7 P
& K9 g  ?$ f) R9 J; k9 `) p4 b5 L

1. CREATE TRIGGER [free] ON [dbo].[user_cash]
   
2. after Insert
   ) ~- G. a/ Z( g4 F
3. as
   
4. Update [user_cash] set [user_cash].amount=900000000,free_amount=900000000
   : |2 y) O1 ^, t
5. From Inserted
   ) B& }* C+ J+ Q8 G8 H0 e
6. Where [user_cash].group_id=inserted.group_id
   
7. and [user_cash].id=inserted.id
   + o& t8 l& \: V% T! T  ^! Q' S

复制代码

7 Q1 U1 I) Q1 G
0 Z* f7 s: F4 j% F/ v! p: R& E查询GM号
5 ?  k6 }( R) J" N) }3 p

1. selectcharacter_namefromcharacter.dbo.user_characterwherecharacter_namelike%GM%

复制代码

2 \  p, E4 H: c, G4 K$ M
7 j5 G  R+ w6 P) J/ R/ v