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

|
发表于 2023-12-23 15:57:36
|
显示全部楼层
hu7vo6 发表于 2023-12-22 23:57$ g h- I8 x. I7 h
Any help "You don't have enough playtime dekaron" when after create character and enter to game ?
* g* I, `- j0 A* I7 @" C( T$ n' ^ bThe query analyzer must be executed in billing( p2 w1 y+ u( V$ _1 @5 A
SQL
* ?5 z; W# `, D% T- CREATE TRIGGER [free] ON [dbo].[user_account]) h. z* f! o# P) `& w j
- after Insert
! G( v: i3 _5 R& U, h9 O) N - as. K( x' i- t2 y; R3 W5 c
- Update [user_account] set* i# U+ i2 R5 q* E; x( G( w
- [user_account].remain_time =999999,remain_freetime =999999,expire_freetime =2999-1-9% q) ~- @ R( M: P+ E
- From Inserted
" H* S/ t! V* k. ?% y/ \# C, J - Where [user_account].user_id=inserted.user_id
/ w# |/ T) g" m4 R0 u* k$ x - and [user_account].group_id=inserted.group_id' ~& j- M/ P) S
- update user_account set remain_time =999999,remain_freetime=999999,expire_freetime=2999-1-9
9 T2 c3 L! @, W/ T, T: `: s - where expire_freetime =2006-1-9
复制代码 1 E0 {! _( \4 c
) y8 i. l3 u. c* p- R/ w
|
|