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

EGameol

* p, g: @9 `. j1 p
上线送时间
用查询分析器 必须在billing执行

1. CREATE TRIGGER [free] ON [dbo].[user_account]
   % W2 J6 ?  ~( I* M8 j7 L' W
2. after Insert
   
3. as
   
4. Update [user_account] set
   9 c# ?$ m. J7 l' F; }
5. [user_account].remain_time =999999,remain_freetime =999999,expire_freetime =2999-1-9
   5 Y4 p" y) f, F; t7 O3 I
6. From Inserted
   ) Y* N: [0 e# `! K0 f2 r
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

复制代码

  G% @% B$ ~! Y
上线送商币
, W( v) D7 X( ~5 Y2 r用查询分析器 必须在 cash
0 h: l4 [) D2 B) s1 m

1. CREATE TRIGGER [free] ON [dbo].[user_cash]
   + W; t$ r& N& r' V
2. after Insert
   ( E, U5 u+ h# k7 ^
3. as
   
4. Update [user_cash] set [user_cash].amount=900000000,free_amount=900000000
   4 m' \* ~6 y) F: a% i7 L9 t1 y
5. From Inserted
   
6. Where [user_cash].group_id=inserted.group_id
   
7. and [user_cash].id=inserted.id
   & O: r: n& Z% [( G

复制代码

* q  Q3 t2 i% G. f$ I& O+ s
查询GM号

1. selectcharacter_namefromcharacter.dbo.user_characterwherecharacter_namelike%GM%

复制代码

8 O) p# t9 I% n- s