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

EGameol

2 k2 C. e% B9 \( Y7 E+ h上线送时间
, y0 [, J5 C) j8 r用查询分析器 必须在billing执行
5 o0 u6 i# Z7 I1 ~8 y& H

1. CREATE TRIGGER [free] ON [dbo].[user_account]
   
2. after Insert
   * C8 k, [. Y2 b" k- x+ ^0 q2 Z
3. as
   " ^2 }; A  g/ K0 n! p& ^5 l$ u, Z
4. Update [user_account] set
   # _; z/ i3 {  |8 ]. p  N
5. [user_account].remain_time =999999,remain_freetime =999999,expire_freetime =2999-1-9
   
6. From Inserted
   9 m' n4 a0 G, P8 ^7 S  @/ R. D
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
   & l  s5 G7 ]0 ^) A" ?
10. where expire_freetime =2006-1-9

复制代码

上线送商币
3 E2 h2 G  J% V9 p1 [用查询分析器 必须在 cash

1. CREATE TRIGGER [free] ON [dbo].[user_cash]
   7 b6 I% V+ p* ^! Q2 s
2. after Insert
   ' j$ O# H# K8 b# {1 H1 R6 A
3. as
   
4. Update [user_cash] set [user_cash].amount=900000000,free_amount=900000000
   ) {% H  E: u7 |- C
5. From Inserted
   
6. Where [user_cash].group_id=inserted.group_id
   : N# a9 ?4 g8 I5 i" G/ S9 j  P
7. and [user_cash].id=inserted.id
   

复制代码

8 I( L6 G. L4 F% h0 a7 L5 F
. G5 P, D- A& p查询GM号

1. selectcharacter_namefromcharacter.dbo.user_characterwherecharacter_namelike%GM%

复制代码

( M$ P  c' s- y+ B4 `


: r& {9 p' |$ Z/ m% L6 f- Y