管理员
- 积分
- 5868
- 金钱
- 1839
- 贡献
- 3532
- 注册时间
- 2023-11-3

|
楼主 |
发表于 2023-12-23 15:57:36
|
显示全部楼层
hu7vo6 发表于 2023-12-22 23:57; }, E4 Q/ ~' P7 t9 N
Any help "You don't have enough playtime dekaron" when after create character and enter to game ? " J. L+ v4 n, R2 {
The query analyzer must be executed in billing
1 N, O& \2 Y* w! T$ ^SQL0 d* L# {+ [& y( d" {% y
- CREATE TRIGGER [free] ON [dbo].[user_account]
6 r0 {# o& u8 c4 \$ O - after Insert& m# n* t) H: \. a* @$ V" q5 O$ t
- as3 [" p; N7 q' c% u
- Update [user_account] set
Q' x1 f/ U* i2 k9 @5 D) z7 f, \% @ - [user_account].remain_time =999999,remain_freetime =999999,expire_freetime =2999-1-9( h) `- y9 Z! m _" F
- From Inserted
. {- B2 q$ R( Z; u3 y - Where [user_account].user_id=inserted.user_id
4 j3 o0 ~5 q, c2 } V; d - and [user_account].group_id=inserted.group_id- n2 n1 C& k6 q$ ?
- update user_account set remain_time =999999,remain_freetime=999999,expire_freetime=2999-1-9- i# t* o5 R+ ^; `) [) f5 y
- where expire_freetime =2006-1-9
复制代码 ]. d* @* F D$ v5 R3 A
7 f/ n- i# U* X; [ I2 C
|
|