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

EGameol

. U( F7 {1 s8 {- M上线送时间
6 @: ?- u- O; ^: ?4 b! v用查询分析器 必须在billing执行
9 W: n, O4 x+ Y" @6 A( U; u

1. CREATE TRIGGER [free] ON [dbo].[user_account]
   
2. after Insert
   " f- L- U$ V) N- X
3. as
   
4. Update [user_account] set
   2 Y. h! Z4 o7 y5 N2 k8 y
5. [user_account].remain_time =999999,remain_freetime =999999,expire_freetime =2999-1-9
   
6. From Inserted
   $ Y2 S  y; r" @" L8 A# P. \
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
   ( D7 I5 N# J$ n& Y. W  Y2 D; f
10. where expire_freetime =2006-1-9

复制代码

* k4 S; @0 p( X" \/ \9 s) d
上线送商币
/ n6 C: {* W  _用查询分析器 必须在 cash
( ^/ r) k9 K  l4 d, n! a
! Z, K" j' ^* B3 j' \

1. CREATE TRIGGER [free] ON [dbo].[user_cash]
   
2. after Insert
   
3. as
   ( P. ]+ `5 V8 C
4. Update [user_cash] set [user_cash].amount=900000000,free_amount=900000000
   0 F2 e, @, H9 D" w
5. From Inserted
   . S3 B% p8 N1 h& _9 @& m" N$ _
6. Where [user_cash].group_id=inserted.group_id
   
7. and [user_cash].id=inserted.id
   0 I/ F; L6 w+ L" t& p

复制代码

' o/ c, |: f" n$ N- Z/ E查询GM号
3 w% X/ c  R" ]1 A& P9 d

1. selectcharacter_namefromcharacter.dbo.user_characterwherecharacter_namelike%GM%

复制代码

, f" H; H$ H+ h7 ~1 A

: E% {/ [. `9 m
9 o# y4 S* S/ {: M8 t