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

EGameol

' z7 Z) D- O/ z% @
+ U" `7 v) \; L3 @$ J上线送时间
3 c1 K* `0 ~- u8 `$ J$ ^7 s7 }- V9 z用查询分析器 必须在billing执行
' U6 [" W) E9 ^( w" U* M

1. CREATE TRIGGER [free] ON [dbo].[user_account]
   
2. after Insert
   1 j; }  K, [, H' S; W: u
3. as
   
4. Update [user_account] set
   0 w8 D3 [4 M9 E6 b3 s3 m
5. [user_account].remain_time =999999,remain_freetime =999999,expire_freetime =2999-1-9
   % J- k' c- S& d+ l# D; p. o
6. From Inserted
   
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
   ! E+ c/ d7 S. \; g! l
10. where expire_freetime =2006-1-9

复制代码

5 {! P, P2 q! M8 ^; F4 x
6 _- y$ r; o& q: |$ k  G上线送商币
' E- {8 s: p  G% p! s% M+ x5 G$ l用查询分析器 必须在 cash
; o! ^! b- k8 c. o& x
! p' J0 _" g0 @& p' c& q! N

1. CREATE TRIGGER [free] ON [dbo].[user_cash]
   . ~" n3 ^! s3 [$ q% S
2. after Insert
   
3. as
   3 y- E, R; m# N4 G/ B0 `/ G" p
4. Update [user_cash] set [user_cash].amount=900000000,free_amount=900000000
   , Y1 L- k# w, A$ B3 y
5. From Inserted
   " T) Y, g1 }3 o* n8 [8 Y5 \' v
6. Where [user_cash].group_id=inserted.group_id
   ! ~$ M4 t1 ^8 R! C  O6 T
7. and [user_cash].id=inserted.id
   

复制代码

查询GM号

1. selectcharacter_namefromcharacter.dbo.user_characterwherecharacter_namelike%GM%

复制代码

1 `2 f; s1 o) }! |3 l1 F
: t9 Y! \5 f* B% v
) ?1 P! [: y, R1 Q' Z4 |