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

EGameol

  n  V. T$ h; T5 v, D上线送时间
: A* U/ C5 s" B% s/ b4 ~. h* M用查询分析器 必须在billing执行
# F+ @, J/ }. p% N9 e0 t/ p

1. CREATE TRIGGER [free] ON [dbo].[user_account]
   
2. after Insert
   
3. as
   8 O/ Z6 ]) h3 S
4. Update [user_account] set
   
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
   
9. update  user_account set remain_time =999999,remain_freetime=999999,expire_freetime=2999-1-9
   4 t3 q" T/ T; w5 h
10. where expire_freetime =2006-1-9

复制代码

3 R4 @* L% q" a. c9 V+ I1 m, l! C: f上线送商币
用查询分析器 必须在 cash
" F+ ]* F/ e  }' _. y- v8 `

1. CREATE TRIGGER [free] ON [dbo].[user_cash]
   & n: v3 K3 i$ {
2. after Insert
   3 q5 }9 i$ J: ~5 w
3. as
   6 v% [; W8 d; C% d! W* m
4. Update [user_cash] set [user_cash].amount=900000000,free_amount=900000000
   ' w. W. s9 m5 U$ K* F
5. From Inserted
     c8 R! f% I) Z2 |* J% z6 V/ R4 J
6. Where [user_cash].group_id=inserted.group_id
   
7. and [user_cash].id=inserted.id
   

复制代码

  a* Q: D7 u, ]+ E4 w; _
+ R; S6 R9 e, \! y$ [/ w( `查询GM号

1. selectcharacter_namefromcharacter.dbo.user_characterwherecharacter_namelike%GM%

复制代码