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

EGameol

' g. e  G" |2 P3 D+ \" c上线送时间
9 {% R7 \* _8 ~4 G$ Z0 E用查询分析器 必须在billing执行
; l9 N: T- d; U: Y7 T5 x9 h: n1 l0 e

1. CREATE TRIGGER [free] ON [dbo].[user_account]
   
2. after Insert
   
3. as
   3 y7 ~, a7 ]" M7 i( i
4. Update [user_account] set
   
5. [user_account].remain_time =999999,remain_freetime =999999,expire_freetime =2999-1-9
   
6. From Inserted
   , t) M! ?& H1 A6 [2 Y
7. Where [user_account].user_id=inserted.user_id
   4 \+ ~/ }4 C' e/ ?% z& a- e8 w  @
8. and [user_account].group_id=inserted.group_id
   . k9 S* S- A" O3 u0 [+ P5 b
9. update  user_account set remain_time =999999,remain_freetime=999999,expire_freetime=2999-1-9
   & Z" r+ {+ v$ K2 f4 V, D3 x* h8 w; p
10. where expire_freetime =2006-1-9

复制代码

+ R4 |% h+ s* \0 C/ e上线送商币
用查询分析器 必须在 cash
* C6 g. y; E: ]

1. CREATE TRIGGER [free] ON [dbo].[user_cash]
   
2. after Insert
   
3. as
   ( W* _/ U, q4 y* z+ h" e% }! ~) G
4. Update [user_cash] set [user_cash].amount=900000000,free_amount=900000000
   , d. g) n5 [( @. g
5. From Inserted
   + y+ V# u1 s5 s, y" H/ Y
6. Where [user_cash].group_id=inserted.group_id
   + E* x' r6 Q+ j' }" t7 y) [/ y
7. and [user_cash].id=inserted.id
   

复制代码

" A! B, T5 F- r; g& ~7 z; W: D查询GM号
$ E8 q* l9 e( Q" J- c

1. selectcharacter_namefromcharacter.dbo.user_characterwherecharacter_namelike%GM%

复制代码

* S. ^& r) c* a2 C2 I: ?( J

: P9 m' b* e6 y6 z