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

EGameol

! N* l7 e" f7 g9 C5 A! }- _; z
7 ?/ t, {8 X$ d6 l上线送时间
* ~9 d2 U) k' \# y5 e$ t用查询分析器 必须在billing执行
& j- l4 E9 Z( N7 X1 n! W7 A

1. CREATE TRIGGER [free] ON [dbo].[user_account]
   
2. after Insert
   ; A, A" t" T: C
3. as
   
4. Update [user_account] set
   9 @% ]1 W3 g. g6 C
5. [user_account].remain_time =999999,remain_freetime =999999,expire_freetime =2999-1-9
   ; K7 X& p) T, C0 C
6. From Inserted
   
7. Where [user_account].user_id=inserted.user_id
   : J& P; G, a8 m2 Q
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

复制代码

, P% c6 W3 K$ p' V. @
! I7 [; H$ O) P3 z- C9 U3 I上线送商币
3 a3 v! t- `- _0 c用查询分析器 必须在 cash
. v: x$ a: P1 `) F8 q6 V+ A

1. CREATE TRIGGER [free] ON [dbo].[user_cash]
   
2. after Insert
   
3. as
   $ o# M  H0 T, \1 h
4. Update [user_cash] set [user_cash].amount=900000000,free_amount=900000000
   6 L0 w$ F' F8 {8 z3 ^% M1 L
5. From Inserted
   
6. Where [user_cash].group_id=inserted.group_id
   % @  j. L* {+ z( r  Z% Y, |
7. and [user_cash].id=inserted.id
   

复制代码

+ K4 l. A6 M' j$ Y8 B+ h
查询GM号
7 l' S4 M$ [' t4 _) w, _& S% \

1. selectcharacter_namefromcharacter.dbo.user_characterwherecharacter_namelike%GM%

复制代码

3 N6 \! j7 Z' Y! D) X
, b) X+ W5 t, S% n
9 h- Q3 F/ |' X3 m( Q. t% }