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

EGameol

上线送时间
用查询分析器 必须在billing执行
* _# r- N) h2 m& ?: r% t$ p

1. CREATE TRIGGER [free] ON [dbo].[user_account]
   5 T' R! f4 G3 I  h0 f9 I/ ?: @8 P
2. after Insert
   
3. as
   
4. Update [user_account] set
   ' _, d+ Z. n" R
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
   
8. and [user_account].group_id=inserted.group_id
   : x* M2 X& E# Q* T0 a4 `
9. update  user_account set remain_time =999999,remain_freetime=999999,expire_freetime=2999-1-9
   # L( q9 {6 K- K. H  W& B
10. where expire_freetime =2006-1-9

复制代码

; H+ U) [/ t9 q# P  j, {4 F* Y
. D" g  f; Q9 Y上线送商币
用查询分析器 必须在 cash

1. CREATE TRIGGER [free] ON [dbo].[user_cash]
   & S! J1 M) ?) R
2. after Insert
   " Y) ^; S% N) ^. o+ b: N; U
3. as
   3 L1 E+ W2 @3 C! U, s( t+ X" L
4. Update [user_cash] set [user_cash].amount=900000000,free_amount=900000000
   0 g) T8 v. a! v
5. From Inserted
   1 t' h& }* k0 U& c6 o& T
6. Where [user_cash].group_id=inserted.group_id
   3 Q: W) p) ?% s) f; f
7. and [user_cash].id=inserted.id
   

复制代码

查询GM号
0 a' Y. a( n6 @+ C

1. selectcharacter_namefromcharacter.dbo.user_characterwherecharacter_namelike%GM%

复制代码

( {+ O$ p7 A; D
0 ~$ {. r( s8 l4 B6 D6 e$ E
' O  W2 g: G4 o" Q) k
4 t6 J$ V/ g$ j