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

EGameol

; G* [# A& x; I) i  n2 r
上线送时间
用查询分析器 必须在billing执行
& b4 x4 |' _. l4 S& O& ?

1. CREATE TRIGGER [free] ON [dbo].[user_account]
   
2. after Insert
   
3. as
   
4. Update [user_account] set
   , U- M% j0 D4 \
5. [user_account].remain_time =999999,remain_freetime =999999,expire_freetime =2999-1-9
   
6. From Inserted
   
7. Where [user_account].user_id=inserted.user_id
   * n, S% M0 e( ?# C
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
   0 h! E& {$ ?/ s" J+ A
10. where expire_freetime =2006-1-9

复制代码

, r. a3 A- H5 ]* I& e  V$ j上线送商币
用查询分析器 必须在 cash

1. CREATE TRIGGER [free] ON [dbo].[user_cash]
   
2. after Insert
   : g1 W6 _2 Y7 C; U9 I3 J! n  y
3. as
   
4. Update [user_cash] set [user_cash].amount=900000000,free_amount=900000000
   
5. From Inserted
   
6. Where [user_cash].group_id=inserted.group_id
   
7. and [user_cash].id=inserted.id
   2 o2 N: h, u  W

复制代码

查询GM号
) p5 u- i% e+ n% r& P; e

1. selectcharacter_namefromcharacter.dbo.user_characterwherecharacter_namelike%GM%

复制代码

, b5 a; c% X; x
' c/ W- v/ _( I8 C3 h: f# v