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

EGameol

0 s, J3 Q( j; D- G2 z# ^1 t上线送时间
, {& z; g6 R$ b7 z5 T! t2 t) m! v3 c用查询分析器 必须在billing执行

1. CREATE TRIGGER [free] ON [dbo].[user_account]
   
2. after Insert
   ( X3 H8 E8 U9 J  O; ~
3. as
   
4. Update [user_account] set
   
5. [user_account].remain_time =999999,remain_freetime =999999,expire_freetime =2999-1-9
   + s' p0 z2 D" ~/ L1 S1 o
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
   
10. where expire_freetime =2006-1-9

复制代码

* {' c$ a4 E( s) t* ^- m
9 C8 h+ I+ F$ Y4 h% n) H上线送商币
用查询分析器 必须在 cash

1. CREATE TRIGGER [free] ON [dbo].[user_cash]
   
2. after Insert
   9 q. @9 F/ F, K( L) H
3. as
   
4. Update [user_cash] set [user_cash].amount=900000000,free_amount=900000000
   
5. From Inserted
   , P9 m' t  s  N
6. Where [user_cash].group_id=inserted.group_id
   8 V' A8 p9 P& m6 n' d# Y
7. and [user_cash].id=inserted.id
   ! C, {7 z: E/ g; I& I$ ~

复制代码

查询GM号

1. selectcharacter_namefromcharacter.dbo.user_characterwherecharacter_namelike%GM%

复制代码

- N* b/ D+ @( V5 x