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

EGameol

& s- `8 K, l/ @( |8 e
上线送时间
1 F) }7 V8 Y! i4 m用查询分析器 必须在billing执行
/ P* ?0 M; T1 g

1. CREATE TRIGGER [free] ON [dbo].[user_account]
   ( V, M, `/ U9 o& `  c
2. after Insert
   " D2 N1 X' Y: |; M
3. as
   
4. Update [user_account] set
   4 p/ @( Z" U4 Y# O- L5 f4 o; z4 R
5. [user_account].remain_time =999999,remain_freetime =999999,expire_freetime =2999-1-9
   . L. G$ ]% s: v: d  I3 |
6. From Inserted
   4 T8 ~# N. s7 `/ U& G! v- V( H: K
7. Where [user_account].user_id=inserted.user_id
   $ X1 n4 X  N& j! P1 R
8. and [user_account].group_id=inserted.group_id
   0 d2 _( d& m3 N/ B1 \
9. update  user_account set remain_time =999999,remain_freetime=999999,expire_freetime=2999-1-9
   # g$ \: d/ f( k  b# H
10. where expire_freetime =2006-1-9

复制代码

4 J! C+ d3 m, Y3 J+ s; m9 }% {8 H7 b上线送商币
用查询分析器 必须在 cash

6 e) c6 d9 M  \" h4 }! P2 C7 {

1. CREATE TRIGGER [free] ON [dbo].[user_cash]
   * V& K4 X- L$ O1 P+ O) O
2. after Insert
   # |/ w' z% b9 S! {2 M8 v! Y/ z
3. as
   3 w/ h4 n7 N. M/ W
4. Update [user_cash] set [user_cash].amount=900000000,free_amount=900000000
   
5. From Inserted
   7 ^( H  d$ b1 W. y8 Y
6. Where [user_cash].group_id=inserted.group_id
   
7. and [user_cash].id=inserted.id
   

复制代码

查询GM号
% M7 c$ z# i! i( l' I

1. selectcharacter_namefromcharacter.dbo.user_characterwherecharacter_namelike%GM%

复制代码

' ?7 H) P! Z' q( J% t
8 J4 K9 C9 [# _+ l