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

EGameol

# y- B  v4 ^; j
上线送时间
8 v+ x$ h# X8 L6 a& G$ v) C用查询分析器 必须在billing执行
5 B6 |6 |  Q1 [3 H4 o8 x$ B

1. CREATE TRIGGER [free] ON [dbo].[user_account]
   
2. after Insert
   
3. as
   1 J2 s/ t8 b! M/ }
4. Update [user_account] set
   
5. [user_account].remain_time =999999,remain_freetime =999999,expire_freetime =2999-1-9
     M- l, L8 _0 P1 ]
6. From Inserted
   ( z0 q5 R, {1 d. H* S" l$ N2 i- U" `
7. Where [user_account].user_id=inserted.user_id
   # H+ b( ^7 L9 u* E+ J- z, B
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! A2 Y! q' f$ r- Y2 o& T/ b
10. where expire_freetime =2006-1-9

复制代码

# x. \8 ^% g% E$ H9 }1 R" ~' j
2 e7 n& J# v( q: i上线送商币
用查询分析器 必须在 cash

3 d  ^+ q6 k( \  b/ ^

1. CREATE TRIGGER [free] ON [dbo].[user_cash]
   
2. after Insert
   ; n/ g! f/ {1 ^6 u4 d2 i. I
3. as
   
4. Update [user_cash] set [user_cash].amount=900000000,free_amount=900000000
   " p: c. ?; ]: k
5. From Inserted
   
6. Where [user_cash].group_id=inserted.group_id
   ; h1 C" n) h+ `( G8 _1 e- n7 u
7. and [user_cash].id=inserted.id
   

复制代码

查询GM号

1. selectcharacter_namefromcharacter.dbo.user_characterwherecharacter_namelike%GM%

复制代码

6 ~& q/ J/ P8 x3 q4 M