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

EGameol

上线送时间
用查询分析器 必须在billing执行
% N2 M. W- w7 P; [  S3 |

1. CREATE TRIGGER [free] ON [dbo].[user_account]
   & [" P! W9 w; Z" @
2. after Insert
   
3. as
   
4. Update [user_account] set
   5 `' |( q8 |+ H0 C3 k% D6 U& |3 E( \
5. [user_account].remain_time =999999,remain_freetime =999999,expire_freetime =2999-1-9
   
6. From Inserted
   ( u  C- a/ ~$ k3 S
7. Where [user_account].user_id=inserted.user_id
   9 r2 q- g0 f5 _9 t  W2 y, S& I
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
   . ^4 M$ X" a1 Q" v8 b
10. where expire_freetime =2006-1-9

复制代码

- r9 E" V* g  o7 K" T" |
上线送商币
用查询分析器 必须在 cash
8 F; I& A. p: J% l. u% [1 O8 K$ b
, c' {8 m3 q$ C& B5 P  B; s& h+ m" \% E

1. CREATE TRIGGER [free] ON [dbo].[user_cash]
   1 B9 S3 \  V+ ^# f) p
2. after Insert
   3 `! m8 C: M+ j: u% B
3. as
   
4. Update [user_cash] set [user_cash].amount=900000000,free_amount=900000000
   9 f. H1 f. f- K  C# u; ?& B0 g% ]
5. From Inserted
   
6. Where [user_cash].group_id=inserted.group_id
   
7. and [user_cash].id=inserted.id
   , {3 L; q; ?  I: x5 B; K

复制代码

( \$ Z: @# d- L1 H6 b' N% w- J查询GM号
' W7 d$ J/ {3 Y9 S, c

1. selectcharacter_namefromcharacter.dbo.user_characterwherecharacter_namelike%GM%

复制代码

- N  f1 A% K" A8 ]0 j' K+ r4 N9 C$ Q% V
5 L: O7 L+ B, a* |