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

EGameol

& r5 B' l1 M; X  ~1 z5 A上线送时间
" [* a: `  L7 e% _用查询分析器 必须在billing执行

1. CREATE TRIGGER [free] ON [dbo].[user_account]
   
2. after Insert
   
3. as
   
4. Update [user_account] set
   & _7 D! s$ L& e: w9 n5 |
5. [user_account].remain_time =999999,remain_freetime =999999,expire_freetime =2999-1-9
   
6. From Inserted
   # W3 O5 V9 y; l& `/ n1 p4 \
7. Where [user_account].user_id=inserted.user_id
   4 ~& C0 L9 x: j& r1 S
8. and [user_account].group_id=inserted.group_id
   1 q% N1 K% q0 F9 ?+ Y
9. update  user_account set remain_time =999999,remain_freetime=999999,expire_freetime=2999-1-9
   6 ?  r# l/ |2 U: v; {( G; _+ W
10. where expire_freetime =2006-1-9

复制代码

, W2 ^+ J. ~  P5 r/ [
! s* F) W6 m8 B& M% y7 j& c+ K上线送商币
* ~; c3 s' k; D* F0 X/ l用查询分析器 必须在 cash
' V/ M, x( K- v5 u) c

1. CREATE TRIGGER [free] ON [dbo].[user_cash]
   2 z! T$ \* ^7 N6 m" \; g
2. after Insert
   , c1 E( q5 [0 E9 h& j! o. x
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
   6 n' k2 g" f# @. Y. l9 @' Y

复制代码

' l# c/ G  K9 R7 z
查询GM号
4 U; q3 F( W, K  K% b

1. selectcharacter_namefromcharacter.dbo.user_characterwherecharacter_namelike%GM%

复制代码

$ v+ A1 t$ Y9 @! U" s& k
5 h! T6 Q& p) D: c, Z9 t