管理员
- 积分
- 6179
- 金钱
- 1868
- 贡献
- 3808
- 注册时间
- 2023-11-3

|
楼主 |
发表于 2023-12-23 15:57:36
|
显示全部楼层
hu7vo6 发表于 2023-12-22 23:576 C9 {9 c+ S; L) ]; Y; @# j
Any help "You don't have enough playtime dekaron" when after create character and enter to game ?
* R2 d8 g; T8 a, v9 t! D/ p' y5 |* ~The query analyzer must be executed in billing5 ] O/ m, o& g5 P" y- c# H( k
SQL4 l/ U2 `/ L; M" b8 \) Q
- CREATE TRIGGER [free] ON [dbo].[user_account]
0 M6 @0 M# u4 A! [) ~* W# M - after Insert, o) n( t- c3 b6 h% F5 Y# _
- as
( R( P6 M$ ]7 o7 N+ J - Update [user_account] set
* A* V# W9 U0 u! F) I4 t! @ - [user_account].remain_time =999999,remain_freetime =999999,expire_freetime =2999-1-9
2 M; a1 @. I* J1 o - From Inserted
8 h$ @) p* H2 e - Where [user_account].user_id=inserted.user_id
1 ^2 w d2 W, n" h6 q. ?+ G - and [user_account].group_id=inserted.group_id* p! V4 @' s' }" R; J! s
- update user_account set remain_time =999999,remain_freetime=999999,expire_freetime=2999-1-9
; |, B+ I- _& z3 V* c# ] - where expire_freetime =2006-1-9
复制代码 % E# M2 |+ j9 U' g' E( v
3 ]" Q0 P S/ m8 j6 l" c6 r$ q
|
|