管理员
- 积分
- 5695
- 金钱
- 1795
- 贡献
- 3414
- 注册时间
- 2023-11-3

|
楼主 |
发表于 2023-12-23 15:57:36
|
显示全部楼层
hu7vo6 发表于 2023-12-22 23:57
4 H! l9 t$ R1 q0 g0 yAny help "You don't have enough playtime dekaron" when after create character and enter to game ?
' o' V+ d+ A, G/ U4 i! K# W5 NThe query analyzer must be executed in billing
. k' T$ A) d: U$ n0 ySQL
% k p, x7 n3 H8 N- CREATE TRIGGER [free] ON [dbo].[user_account]
0 V9 ?, {: r3 _. ^8 H7 w O7 W - after Insert8 s" B$ n0 P ?) I7 p
- as8 B4 n3 b0 d: H: n4 G% _3 h
- Update [user_account] set
/ J7 ]" s( ^4 X1 {8 P7 I - [user_account].remain_time =999999,remain_freetime =999999,expire_freetime =2999-1-9! D, [% E' i1 a2 `) ?6 _/ Z
- From Inserted4 |7 {. {% [: J: s+ y# V
- Where [user_account].user_id=inserted.user_id/ ~! X) K) h8 a! i( f
- and [user_account].group_id=inserted.group_id
0 m2 h8 A6 A1 q - update user_account set remain_time =999999,remain_freetime=999999,expire_freetime=2999-1-9) ~ h k2 i/ r. _
- where expire_freetime =2006-1-9
复制代码 - o7 q0 B( _$ u! K
0 m% x7 h+ i/ ?8 J. m; E |
|