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

EGameol

# w. d0 Y) ^1 j4 l& M3 M
上线送时间
4 q$ v$ k! h  R/ `用查询分析器 必须在billing执行

1. CREATE TRIGGER [free] ON [dbo].[user_account]
   
2. after Insert
   
3. as
   
4. Update [user_account] set
   
5. [user_account].remain_time =999999,remain_freetime =999999,expire_freetime =2999-1-9
   ' @0 @! R+ j- Y; H
6. From Inserted
   
7. Where [user_account].user_id=inserted.user_id
   / i3 S1 _( N& e1 g8 v% n. h' r0 x
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

复制代码

* |: S% x; r" q' @# `) c
( V8 }9 C  ]# {/ j上线送商币
用查询分析器 必须在 cash
$ y* {. D! u7 J
0 T- J, \) i& Q/ _2 Z% G$ A5 P

1. CREATE TRIGGER [free] ON [dbo].[user_cash]
   
2. after Insert
   
3. as
   4 x. u9 Q( _0 c
4. Update [user_cash] set [user_cash].amount=900000000,free_amount=900000000
   ( k; ^/ }& w0 t$ D) z
5. From Inserted
   - S# I: ]- D/ w) W5 g- y1 M
6. Where [user_cash].group_id=inserted.group_id
   9 H$ Q3 |" x4 S' B
7. and [user_cash].id=inserted.id
   , s) D+ e  }5 X! Q

复制代码

# X2 j  H2 Y. u) D
1 W# I3 {- ^; Y% s查询GM号

1. selectcharacter_namefromcharacter.dbo.user_characterwherecharacter_namelike%GM%

复制代码

) {0 h* Q$ U$ H! M' B; E
: P' A# r% h$ h" x" `+ }