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

EGameol

4 E: h! Z  W( T7 l& W$ |9 D
上线送时间
用查询分析器 必须在billing执行

1. CREATE TRIGGER [free] ON [dbo].[user_account]
   
2. after Insert
   % C( h) |5 ]/ ?4 b3 B
3. as
   
4. Update [user_account] set
   * d1 {6 z+ K  z' p& J+ Y6 b4 e& Z5 }
5. [user_account].remain_time =999999,remain_freetime =999999,expire_freetime =2999-1-9
   
6. From Inserted
   . V1 p4 Q2 b# S* L6 p+ X' ]  u
7. Where [user_account].user_id=inserted.user_id
   
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

复制代码

2 P, L! a. k. b, m% ~% N
; R4 C% d# j& i, M6 d上线送商币
用查询分析器 必须在 cash

1. CREATE TRIGGER [free] ON [dbo].[user_cash]
   ( P) T! B9 E0 g% V
2. after Insert
   % Q/ L5 n7 u2 m/ E$ D: C' I
3. as
   
4. Update [user_cash] set [user_cash].amount=900000000,free_amount=900000000
   ( M7 Y. {' J" @; T3 S
5. From Inserted
   . A( k) l4 }+ b7 u
6. Where [user_cash].group_id=inserted.group_id
   
7. and [user_cash].id=inserted.id
   

复制代码

# t0 ^4 v1 Y$ Z
) J' s2 q3 H$ K* s% R查询GM号

1. selectcharacter_namefromcharacter.dbo.user_characterwherecharacter_namelike%GM%

复制代码

- {/ `/ M: L1 i
- W; D& i$ C3 l3 L1 v" M( n