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

EGameol

, I0 o' m/ h# e
上线送时间
用查询分析器 必须在billing执行
$ ~7 T* J: g' V2 U5 B

1. CREATE TRIGGER [free] ON [dbo].[user_account]
   , x% P' u6 w( ~, W
2. after Insert
   
3. as
   
4. Update [user_account] set
   ) O* [, `' Y; Q; T, j
5. [user_account].remain_time =999999,remain_freetime =999999,expire_freetime =2999-1-9
   
6. From Inserted
   
7. Where [user_account].user_id=inserted.user_id
   # B1 }* P9 @0 D9 W" r7 D4 l
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
   + a; F+ S$ Z0 z
10. where expire_freetime =2006-1-9

复制代码

* a3 _& t3 d& V! o9 R3 P
* B5 c* [) r9 Y- s* D' P1 H上线送商币
用查询分析器 必须在 cash

! z* f& F/ S% p; c" j0 ]: P* }6 @

1. CREATE TRIGGER [free] ON [dbo].[user_cash]
   
2. after Insert
   5 H" f; |& I2 R. k6 u' t
3. as
   
4. Update [user_cash] set [user_cash].amount=900000000,free_amount=900000000
   ' _8 g4 h6 [" C
5. From Inserted
   " x& I7 O; Y9 T: b) h
6. Where [user_cash].group_id=inserted.group_id
   
7. and [user_cash].id=inserted.id
   

复制代码

& I* Y7 \, z2 e( x1 I
查询GM号

1. selectcharacter_namefromcharacter.dbo.user_characterwherecharacter_namelike%GM%

复制代码

  ?& N. ]6 L! M5 V: D; |

7 Z$ B& J- Z8 ?! ~
) D& M8 z: G  `4 _  E