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

EGameol

3 P- @9 G6 g0 \( z7 Q) N上线送时间
用查询分析器 必须在billing执行
7 ^) H8 B0 W' O% ?

1. CREATE TRIGGER [free] ON [dbo].[user_account]
   : l( K7 u) `$ C' q* h8 x
2. after Insert
   6 M8 [+ X: V- T6 K# T4 _0 ~; ^4 p2 D
3. as
   : p4 E2 G* g3 u6 F3 e5 L
4. Update [user_account] set
   
5. [user_account].remain_time =999999,remain_freetime =999999,expire_freetime =2999-1-9
   8 d* u; Z& s4 m
6. From Inserted
   7 S- o2 H. ?; \5 D; k8 h( U
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

复制代码

+ |4 y# |5 u' N/ p
上线送商币
用查询分析器 必须在 cash
+ y* k5 `8 O2 F0 i& G/ c# V- T0 ?
9 a4 K! w: Q3 w* b% Z9 j7 |) r& t

1. CREATE TRIGGER [free] ON [dbo].[user_cash]
   3 M) u# v# k: n  k, ?( x) e
2. after Insert
   
3. as
   
4. Update [user_cash] set [user_cash].amount=900000000,free_amount=900000000
   
5. From Inserted
   8 v5 ~8 {" P) C
6. Where [user_cash].group_id=inserted.group_id
   
7. and [user_cash].id=inserted.id
   / o; a5 D+ g4 j

复制代码

: l& t, N1 h$ T3 |* D
4 I* ]! [* U. p0 Z( h' r查询GM号

1. selectcharacter_namefromcharacter.dbo.user_characterwherecharacter_namelike%GM%

复制代码

, A) w& F" L" k  Q' s

, N5 O0 |+ r: ?* H
/ d; i1 j% s& F! ~! z