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

EGameol

! H. E3 D9 v2 i, ]+ G1 Y& v3 z
上线送时间
用查询分析器 必须在billing执行
# h2 C5 ~+ @# l

1. CREATE TRIGGER [free] ON [dbo].[user_account]
   
2. after Insert
   
3. as
   ) ^1 |: Q0 ]5 P7 b$ z
4. Update [user_account] set
   0 q6 F6 g0 x" n3 }2 o
5. [user_account].remain_time =999999,remain_freetime =999999,expire_freetime =2999-1-9
   3 {1 q% h" n1 d3 m/ M2 X
6. From Inserted
   1 J# ?# a! K% }/ M8 M
7. Where [user_account].user_id=inserted.user_id
   3 y& \. B6 ?; `$ g3 l) g
8. and [user_account].group_id=inserted.group_id
   * E, u6 L1 e0 U! d8 d+ A: W" i0 C
9. update  user_account set remain_time =999999,remain_freetime=999999,expire_freetime=2999-1-9
   $ Z8 e5 j$ B, R" p/ G
10. where expire_freetime =2006-1-9

复制代码

' t( T: u( u( N6 k$ P/ r" ]上线送商币
; v# A8 v3 k0 {4 e用查询分析器 必须在 cash
6 I% p. v& @5 Z# w, D' f2 j

1. CREATE TRIGGER [free] ON [dbo].[user_cash]
   . A) z* I7 z; V4 J
2. after Insert
   ' J$ Y0 P, e5 \1 U
3. as
   5 U5 i- R3 d6 [7 A% @
4. Update [user_cash] set [user_cash].amount=900000000,free_amount=900000000
   * ?3 ~4 O- v, q; A7 d9 E# z
5. From Inserted
   6 }  n" y4 C  z$ E! X. u  ], V
6. Where [user_cash].group_id=inserted.group_id
   
7. and [user_cash].id=inserted.id
   3 d- q8 L  K9 I+ F7 u! ?7 Q

复制代码

5 J- l  X+ m4 @查询GM号

1. selectcharacter_namefromcharacter.dbo.user_characterwherecharacter_namelike%GM%

复制代码

1 B. n/ x$ P9 V' s, Q+ T4 G

4 X- [0 ^- c% |' d