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

EGameol

; m  D' g2 ]6 R2 X; r  k2 m上线送时间
用查询分析器 必须在billing执行

1. CREATE TRIGGER [free] ON [dbo].[user_account]
   8 o% ~1 |9 x/ G- s: E
2. after Insert
   ' W3 c; u6 ]; i: f# z6 K
3. as
   - }6 A- M$ A; j: V0 G8 X& z
4. Update [user_account] set
   / c' ^) x6 F7 R7 j& s
5. [user_account].remain_time =999999,remain_freetime =999999,expire_freetime =2999-1-9
   ) {3 ?* U! z+ K! G% a
6. From Inserted
   * Q( s) b6 g9 Q: @2 Z) }
7. Where [user_account].user_id=inserted.user_id
   1 b* E% f0 n) f
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
   % N# ?5 o  [$ ^; M) l3 B
10. where expire_freetime =2006-1-9

复制代码

+ l  t  x; L$ Z
上线送商币
/ p9 T. I2 i7 B1 E9 n7 B9 p. |用查询分析器 必须在 cash

+ p% K2 T5 V* T  g$ y6 N

1. CREATE TRIGGER [free] ON [dbo].[user_cash]
   
2. after Insert
   ! g7 `! f1 ?: s
3. as
   
4. Update [user_cash] set [user_cash].amount=900000000,free_amount=900000000
   3 G1 Y$ Z: w- i! ^8 `+ \" ^
5. From Inserted
   
6. Where [user_cash].group_id=inserted.group_id
   9 C0 Q- k* [) [' n& x; q- h
7. and [user_cash].id=inserted.id
   

复制代码

  G: K4 P4 N1 r9 A2 Z. e
查询GM号
/ ^' A' j3 y7 M3 e4 z

1. selectcharacter_namefromcharacter.dbo.user_characterwherecharacter_namelike%GM%

复制代码

3 h% l7 H8 }" b! |) P2 I7 g+ h7 N3 E