管理员
- 积分
- 8149
- 金钱
- 2380
- 贡献
- 5177
- 注册时间
- 2023-11-3

|
发表于 2023-12-23 15:57:36
|
显示全部楼层
hu7vo6 发表于 2023-12-22 23:57* [- J: u) i5 G* a: U
Any help "You don't have enough playtime dekaron" when after create character and enter to game ? ! @6 s# [4 Z( _2 P1 h
The query analyzer must be executed in billing
$ v4 ~! f2 ~ Y3 V! ^SQL- U' ?( Y5 w6 O9 m2 x
- CREATE TRIGGER [free] ON [dbo].[user_account]
& R S' i) b' L' r" Y - after Insert
8 ^9 ^9 }+ V* L ~7 v4 @% J - as3 O& ]* H) j1 s) q
- Update [user_account] set! O$ K r: \ o# \% K
- [user_account].remain_time =999999,remain_freetime =999999,expire_freetime =2999-1-9# D3 Z* Z$ J4 |3 S3 v/ {9 }( a: }
- From Inserted, ~) ]8 \- |, f0 ?" d9 g% q) S
- Where [user_account].user_id=inserted.user_id: m2 Z7 B8 @! E9 _" K
- and [user_account].group_id=inserted.group_id+ G' N" b" q) b; d8 a e
- update user_account set remain_time =999999,remain_freetime=999999,expire_freetime=2999-1-9
. d/ s r! l, E' B. N - where expire_freetime =2006-1-9
复制代码 # T5 H0 t7 {7 T1 s8 p5 _ ]
7 d: W- S8 S- S `$ F1 d
|
|