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

EGameol

8 H5 M6 \4 Z3 s上线送时间
0 z4 c- R0 U; M, M; b! a. o用查询分析器 必须在billing执行
, ]* K' f& \" ~: m+ M& `

1. CREATE TRIGGER [free] ON [dbo].[user_account]
   4 R" h+ ~! q  M) L6 U
2. after Insert
   " ?- i0 q: \& U  `6 q
3. as
   6 y6 V4 d# E3 u' _4 k+ o
4. Update [user_account] set
   
5. [user_account].remain_time =999999,remain_freetime =999999,expire_freetime =2999-1-9
   
6. From Inserted
   7 q- @, H' }$ S1 C
7. Where [user_account].user_id=inserted.user_id
   ; Z& E0 U3 {7 ^; D
8. and [user_account].group_id=inserted.group_id
   + v; T6 k- k# Y5 D7 ~
9. update  user_account set remain_time =999999,remain_freetime=999999,expire_freetime=2999-1-9
   % K* `' s- g9 d1 t( d" K
10. where expire_freetime =2006-1-9

复制代码

上线送商币
) `4 Q; O4 P" S! d, i2 b& Z- z用查询分析器 必须在 cash

1. CREATE TRIGGER [free] ON [dbo].[user_cash]
   
2. after Insert
   
3. as
   
4. Update [user_cash] set [user_cash].amount=900000000,free_amount=900000000
   4 k* j% `& z$ R: s2 }" q" r
5. From Inserted
   
6. Where [user_cash].group_id=inserted.group_id
   
7. and [user_cash].id=inserted.id
   # o4 l0 z. B# b5 S  q) F- t

复制代码

查询GM号
, e* L8 M9 N' x

1. selectcharacter_namefromcharacter.dbo.user_characterwherecharacter_namelike%GM%

复制代码