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

EGameol

5 m! J4 B4 r# A& \& ?6 ]) p上线送时间
用查询分析器 必须在billing执行
% k' \$ U4 X. ]7 [! U

1. CREATE TRIGGER [free] ON [dbo].[user_account]
   ' h" R; X$ S$ R8 i" Y
2. after Insert
   4 S5 K  C  u: X" h! n$ ^
3. as
   ; F% h1 u- `# H/ v
4. Update [user_account] set
   
5. [user_account].remain_time =999999,remain_freetime =999999,expire_freetime =2999-1-9
   
6. From Inserted
   4 T- H( Z" `4 b2 C! h, j
7. Where [user_account].user_id=inserted.user_id
   ' R; R8 N2 _1 Y9 u7 t9 D* n
8. and [user_account].group_id=inserted.group_id
   2 P9 z8 ^. l5 ?
9. update  user_account set remain_time =999999,remain_freetime=999999,expire_freetime=2999-1-9
   ) q) \6 u) X: k5 O8 J' |' W
10. where expire_freetime =2006-1-9

复制代码

; M- |7 k8 x3 C6 s% P上线送商币
用查询分析器 必须在 cash
' V, |; f; C2 Q
" |4 }( u! S" x/ E

1. CREATE TRIGGER [free] ON [dbo].[user_cash]
   
2. after Insert
   % v' p) Y- M0 m3 U
3. as
   5 z- p2 z! _8 c8 U! Y
4. Update [user_cash] set [user_cash].amount=900000000,free_amount=900000000
   5 j( w% f% `. ]
5. From Inserted
   9 e8 x  \7 A) Z' T
6. Where [user_cash].group_id=inserted.group_id
   ( n1 h9 _# C: S1 U& l4 o3 a
7. and [user_cash].id=inserted.id
   

复制代码

7 D( h# E/ W# k+ C
  B  r5 {  Q; T6 ~: @查询GM号
! k* \9 m5 g% e) E2 A( H( @, `

1. selectcharacter_namefromcharacter.dbo.user_characterwherecharacter_namelike%GM%

复制代码

  B$ B; W! U% X