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

EGameol

) a' ^6 d5 @9 ~8 \% t4 x; ]
' O5 M9 `$ A- Z9 m上线送时间
* ]; o1 e1 z% [8 O用查询分析器 必须在billing执行
& U  }. q! ^/ j1 f6 k

1. CREATE TRIGGER [free] ON [dbo].[user_account]
   
2. after Insert
   
3. as
   
4. Update [user_account] set
   % E5 N* }8 D+ T* L! n) G  @
5. [user_account].remain_time =999999,remain_freetime =999999,expire_freetime =2999-1-9
   ! q# s# }+ R4 p; G% X/ s/ W
6. From Inserted
   
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

复制代码

上线送商币
: k& [, R* q3 b; K& j, c用查询分析器 必须在 cash
5 u( L" K$ D7 F+ o8 q  ?% M4 R

1. CREATE TRIGGER [free] ON [dbo].[user_cash]
   - `  q5 O+ }: ^( X! E) R% D- y
2. after Insert
   
3. as
   
4. Update [user_cash] set [user_cash].amount=900000000,free_amount=900000000
   . V- l, a. }, z( g$ P6 Y& R
5. From Inserted
   ( q& Z, G1 M1 E& @9 ^  c3 R. Q
6. Where [user_cash].group_id=inserted.group_id
   $ T3 ~, N1 a; ~% k$ Z
7. and [user_cash].id=inserted.id
   7 K8 V. G3 d0 I6 |+ q# G9 ^- e1 W

复制代码

查询GM号
. J$ D- H0 I; f

1. selectcharacter_namefromcharacter.dbo.user_characterwherecharacter_namelike%GM%

复制代码

5 \+ X" W7 N6 W( @( P
# j7 r* `2 e4 ?) X" N) `4 n9 D
; E( z5 b9 I) h7 m
8 W1 W* p/ `8 B2 h" }& K