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

EGameol

" U: M. }+ W- x* J9 K* |2 n
上线送时间
用查询分析器 必须在billing执行
* }# X* M" r9 o- Z% @/ D1 J; ]6 _

1. CREATE TRIGGER [free] ON [dbo].[user_account]
   % P9 g0 a5 [6 h
2. after Insert
   $ Y% g; c5 a1 W# X1 u2 q. r, m+ A
3. as
   3 ~* Q# x" z( Y- k$ t1 K) Z- c
4. Update [user_account] set
   # y# B$ u8 p9 t  U, K. [
5. [user_account].remain_time =999999,remain_freetime =999999,expire_freetime =2999-1-9
   
6. From Inserted
   % G4 ?/ a; `9 C/ S: h6 x2 P
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

复制代码

上线送商币
5 |/ O7 h$ Q9 d* |- m6 u用查询分析器 必须在 cash
+ _' p9 o# D/ c, V: [. k" w+ J

1. CREATE TRIGGER [free] ON [dbo].[user_cash]
   ' b7 r6 D8 F. W( e* \. p# G" M9 y
2. after Insert
   & P7 M% I" `' W4 L' d
3. as
   
4. Update [user_cash] set [user_cash].amount=900000000,free_amount=900000000
   
5. From Inserted
   9 a. q4 x, M( a& D+ V1 l
6. Where [user_cash].group_id=inserted.group_id
   
7. and [user_cash].id=inserted.id
   , u: t: f" ]: E4 e

复制代码

6 I$ r' H1 G4 P, [$ j6 `
查询GM号
6 W6 i3 H2 ]9 q7 m4 v' G: C$ Z

1. selectcharacter_namefromcharacter.dbo.user_characterwherecharacter_namelike%GM%

复制代码

1 F  P* a: f0 C