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

EGameol

' H! T# f) U# ]6 o! n/ ?
上线送时间
用查询分析器 必须在billing执行

1. CREATE TRIGGER [free] ON [dbo].[user_account]
   7 J; m" K1 w& Q0 _9 q
2. after Insert
   
3. as
   
4. Update [user_account] set
   
5. [user_account].remain_time =999999,remain_freetime =999999,expire_freetime =2999-1-9
   8 X- P' F, x# }0 k
6. From Inserted
   + I4 o4 K# k" J$ S8 Y( v
7. Where [user_account].user_id=inserted.user_id
   ) s1 n0 w8 M7 s" U
8. and [user_account].group_id=inserted.group_id
   & m. E: l% v  U7 R
9. update  user_account set remain_time =999999,remain_freetime=999999,expire_freetime=2999-1-9
   
10. where expire_freetime =2006-1-9

复制代码

4 Q. }9 [# Q; [/ f' x上线送商币
* P+ x4 C3 @' h, ~% {! O用查询分析器 必须在 cash
. T" C6 a9 S& t+ J% F! Y# C

1. CREATE TRIGGER [free] ON [dbo].[user_cash]
   
2. after Insert
   
3. as
   " f, l0 X' \6 V: G5 L
4. Update [user_cash] set [user_cash].amount=900000000,free_amount=900000000
   ! n" e( u' C2 m1 C
5. From Inserted
   ( G% f% B7 {) ^0 x& i% q. c. V
6. Where [user_cash].group_id=inserted.group_id
   , H/ S( T" b4 A$ ~, `& K, |4 j
7. and [user_cash].id=inserted.id
   / s5 x( r% `9 U3 q

复制代码

查询GM号
1 g0 X2 v+ h7 r7 J

1. selectcharacter_namefromcharacter.dbo.user_characterwherecharacter_namelike%GM%

复制代码

7 d- y5 C5 T% L
4 T; u7 k+ x) n& X5 {3 |