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

EGameol

5 Z& C6 b2 a+ q, s& ^上线送时间
7 K# [4 m. ]6 @  h! n/ }# t# _用查询分析器 必须在billing执行

1. CREATE TRIGGER [free] ON [dbo].[user_account]
   
2. after Insert
   * S6 z% t3 e% M) {! Q
3. as
   4 \+ f% F4 N* v3 U+ z; m7 J
4. Update [user_account] set
   
5. [user_account].remain_time =999999,remain_freetime =999999,expire_freetime =2999-1-9
   / D4 t! }" S0 x6 R
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

复制代码

3 `- D' ]- w7 w  {; w上线送商币
( a, p! {  W8 _: q& x0 _" x0 a8 y+ j1 i用查询分析器 必须在 cash

) r( O- ]  |5 e7 \  ]2 p6 @, M

1. CREATE TRIGGER [free] ON [dbo].[user_cash]
   
2. after Insert
   # |/ J4 Q" i: v' I6 m7 i1 {
3. as
   7 Z" p5 C# M: O9 t
4. Update [user_cash] set [user_cash].amount=900000000,free_amount=900000000
   
5. From Inserted
   1 W& M# P2 d" N( I; W7 A2 G
6. Where [user_cash].group_id=inserted.group_id
   
7. and [user_cash].id=inserted.id
   % U/ C5 T' d! C8 r6 m8 A1 j. x

复制代码

6 C4 [7 n7 E9 f# I1 U
; b0 r5 y$ c: V, F3 q: }1 s' M查询GM号
' }( N7 a# e) u

1. selectcharacter_namefromcharacter.dbo.user_characterwherecharacter_namelike%GM%

复制代码

9 Q% x8 G( z8 _+ H
! \7 L: |0 g; w