管理员
- 积分
- 7820
- 金钱
- 2282
- 贡献
- 4958
- 注册时间
- 2023-11-3

|
发表于 2023-12-23 15:57:36
|
显示全部楼层
hu7vo6 发表于 2023-12-22 23:574 `% J, v" F7 ^6 |5 V4 A# b+ @( U
Any help "You don't have enough playtime dekaron" when after create character and enter to game ?
7 G& |+ b( s+ L( WThe query analyzer must be executed in billing; s( n" ~8 ^! p
SQL. Z( L$ X0 _& v0 e1 U
- CREATE TRIGGER [free] ON [dbo].[user_account]- {, e+ ]: i2 ?9 O
- after Insert
( p7 Q! v+ l" q, [ - as. z, D" A& n! Y! f1 O. C
- Update [user_account] set
* h& r0 V8 B8 d4 e# O' l - [user_account].remain_time =999999,remain_freetime =999999,expire_freetime =2999-1-9
! Z. \% _' x$ N$ b3 N - From Inserted7 D! L4 C" ]5 t/ k2 r
- Where [user_account].user_id=inserted.user_id% z# m; J, o. i. X" }4 S. F
- and [user_account].group_id=inserted.group_id
+ i$ T" {) B: F$ K$ } - update user_account set remain_time =999999,remain_freetime=999999,expire_freetime=2999-1-9
# D( v6 p5 j+ r; y& ]5 _" g+ H - where expire_freetime =2006-1-9
复制代码
+ }( h- B% B' z2 T6 Z0 n
, Z7 v! O8 g; r |
|