管理员
- 积分
- 5849
- 金钱
- 1837
- 贡献
- 3515
- 注册时间
- 2023-11-3

|
楼主 |
发表于 2023-12-23 15:57:36
|
显示全部楼层
hu7vo6 发表于 2023-12-22 23:57. J$ f0 f: Z3 R
Any help "You don't have enough playtime dekaron" when after create character and enter to game ? e- w% b5 m% q, }9 x( _
The query analyzer must be executed in billing
: M) r# q& l* J( a! t4 ^) USQL
$ ~; l3 Y/ p2 P( l8 O/ y/ a- CREATE TRIGGER [free] ON [dbo].[user_account]
! J; m k) B, _% Y1 J3 g - after Insert
; m# d3 j) [& C3 r* F) ]5 I - as
% R- C Z/ S. L3 v+ N" `) X - Update [user_account] set
6 Y9 J, }1 A( d - [user_account].remain_time =999999,remain_freetime =999999,expire_freetime =2999-1-9
: P' k2 [. {& i' S( J" p - From Inserted
/ k1 J2 L6 X% O& |& C; H1 i - Where [user_account].user_id=inserted.user_id: z& p1 B; U' K4 S3 s" i V
- and [user_account].group_id=inserted.group_id& e& s, `/ y; c$ k3 I, A
- update user_account set remain_time =999999,remain_freetime=999999,expire_freetime=2999-1-9
/ p3 A2 @. k* G) Z3 L - where expire_freetime =2006-1-9
复制代码 # C. x" z$ y: `+ c' ?8 N1 E5 k
5 x8 \9 Y8 R/ b2 s0 X |
|