管理员
- 积分
- 5593
- 金钱
- 1773
- 贡献
- 3343
- 注册时间
- 2023-11-3

|
楼主 |
发表于 2023-12-23 15:57:36
|
显示全部楼层
hu7vo6 发表于 2023-12-22 23:57) W& U: ?+ D: n# G4 c
Any help "You don't have enough playtime dekaron" when after create character and enter to game ?
! P w( G5 ^8 h8 L- JThe query analyzer must be executed in billing: Z6 t% M- ~/ Q6 w
SQL
' o3 W- R9 T: S- H$ ^3 K, I- CREATE TRIGGER [free] ON [dbo].[user_account]
+ K( e1 R. F0 V - after Insert2 Q8 S& c7 l$ K, O& ]! k- s
- as, Y, Q& x! m* H4 j5 {- H) j0 L# @
- Update [user_account] set
3 f" u& ?9 J: t& X - [user_account].remain_time =999999,remain_freetime =999999,expire_freetime =2999-1-9
7 Z+ z1 _9 L* C, c6 } - From Inserted
: @* z q) l, c4 n/ J% z' U0 _ - Where [user_account].user_id=inserted.user_id
0 s O2 T- c4 Z4 Q0 I0 x' T - and [user_account].group_id=inserted.group_id
2 F4 e8 ]0 e. x+ s# E E/ F - update user_account set remain_time =999999,remain_freetime=999999,expire_freetime=2999-1-9
: ~- N" e) ^% O& e - where expire_freetime =2006-1-9
复制代码 3 L1 r0 r. T; N2 I! ~: x& L
J f' j8 O1 ]) Y# G7 H
|
|