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

EGameol

- p2 n5 c! U' v# T: x# P
上线送时间
, Z( E: C) `* m4 C6 x9 \- M用查询分析器 必须在billing执行

1. CREATE TRIGGER [free] ON [dbo].[user_account]
   
2. after Insert
   - S* r/ c) A5 l' x* T
3. as
   " z: S  i3 B' o1 ~, @
4. Update [user_account] set
   # Q5 y$ t0 S3 P  E: M- \% t
5. [user_account].remain_time =999999,remain_freetime =999999,expire_freetime =2999-1-9
   # l$ F5 B6 u/ u$ _$ d# q
6. From Inserted
   8 ]* J5 ^& }6 W9 o3 W9 c# X: K
7. Where [user_account].user_id=inserted.user_id
   
8. and [user_account].group_id=inserted.group_id
   $ ~1 _, i: O2 N$ p+ z: @
9. update  user_account set remain_time =999999,remain_freetime=999999,expire_freetime=2999-1-9
   3 j: |1 U: m' m+ V0 R9 K
10. where expire_freetime =2006-1-9

复制代码

4 g$ ]+ g7 k1 _/ K上线送商币
/ b* i/ Y0 ~* v7 }用查询分析器 必须在 cash

* C' v3 X' Q. H* n5 i+ \

1. CREATE TRIGGER [free] ON [dbo].[user_cash]
   / y- O4 D2 O$ i# |! ]
2. after Insert
   9 |) P8 r* @$ s8 ^: E$ |2 a% K
3. as
   
4. Update [user_cash] set [user_cash].amount=900000000,free_amount=900000000
   6 i6 L5 P6 ?4 A" S; o# |. L8 \1 ~. K
5. From Inserted
   
6. Where [user_cash].group_id=inserted.group_id
   + t6 b9 a3 B/ V; {) G2 O) w" m
7. and [user_cash].id=inserted.id
   

复制代码

  n! I2 ^; ~" C# }  g9 @9 [+ y查询GM号
; s; V, k9 }# o) }

1. selectcharacter_namefromcharacter.dbo.user_characterwherecharacter_namelike%GM%

复制代码

; v  e) \( O+ @* |8 @8 a' E
& O5 I' V, k/ E

" A; U& @5 Y+ |2 D9 b0 q( c4 q