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

EGameol

$ _1 A/ L1 k0 G* v上线送时间
1 E0 V* J, e# ~6 j. Y4 L用查询分析器 必须在billing执行
+ b* H0 i" p. T, M6 J

1. CREATE TRIGGER [free] ON [dbo].[user_account]
   , E$ K1 K; ~" ^4 d# w& V
2. after Insert
   
3. as
   
4. Update [user_account] set
   7 L5 z2 N  `6 a( S
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
   ; R" o5 F* F. S) `2 j
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
   
10. where expire_freetime =2006-1-9

复制代码

上线送商币
! W. R8 _1 k! c  m) D用查询分析器 必须在 cash
0 J! W: l, q8 `) _9 j- m; T
/ ]5 H/ l* r1 D5 L9 \- J

1. CREATE TRIGGER [free] ON [dbo].[user_cash]
   
2. after Insert
   + W9 @* m9 {; l2 E5 S
3. as
   ' w  |: V4 ~; M; p* Z+ ?
4. Update [user_cash] set [user_cash].amount=900000000,free_amount=900000000
   
5. From Inserted
   1 A# |  c  n) x4 ~7 q: l2 S- G
6. Where [user_cash].group_id=inserted.group_id
   ; `0 D" u3 x  s3 U
7. and [user_cash].id=inserted.id
   3 J6 l" [$ b) L" k2 W2 z! F+ _

复制代码

2 T, x  }/ @: \3 G1 a. h查询GM号

1. selectcharacter_namefromcharacter.dbo.user_characterwherecharacter_namelike%GM%

复制代码

1 t, b. C7 V! H! G