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

EGameol

上线送时间
用查询分析器 必须在billing执行

1. CREATE TRIGGER [free] ON [dbo].[user_account]
   9 s4 |1 b# J6 q
2. after Insert
   " G5 s" \, F- O  a7 l" }" G; w
3. as
   
4. Update [user_account] set
   6 P9 R8 e' B$ d& M4 H9 \0 m
5. [user_account].remain_time =999999,remain_freetime =999999,expire_freetime =2999-1-9
   ' I% R) k' L$ U7 C: H/ ~- K
6. From Inserted
   # s7 W3 t2 U* g+ ~8 A5 H2 U
7. Where [user_account].user_id=inserted.user_id
   6 i+ s; X1 n  W8 t' q1 d' U
8. and [user_account].group_id=inserted.group_id
   5 c; \7 z( i- ]& z7 C9 z
9. update  user_account set remain_time =999999,remain_freetime=999999,expire_freetime=2999-1-9
   
10. where expire_freetime =2006-1-9

复制代码

# L$ K' }8 x4 U" x' Z上线送商币
( G2 ]5 I+ [7 q& Z用查询分析器 必须在 cash
1 C8 J( \4 s# Y

1. CREATE TRIGGER [free] ON [dbo].[user_cash]
   7 C& o7 h6 |4 N4 f! `
2. after Insert
   % ?& W( h) N0 z" K  _0 u. N
3. as
   9 X; W# M7 {( I5 d: \  \
4. Update [user_cash] set [user_cash].amount=900000000,free_amount=900000000
   
5. From Inserted
   7 @, u* Q# U6 |
6. Where [user_cash].group_id=inserted.group_id
   4 `7 V2 _, @4 T+ G5 U: S* C- @
7. and [user_cash].id=inserted.id
   

复制代码

查询GM号

1. selectcharacter_namefromcharacter.dbo.user_characterwherecharacter_namelike%GM%

复制代码

& Q/ \9 f( E- K. ^1 u