管理员
- 积分
- 7051
- 金钱
- 2010
- 贡献
- 4518
- 注册时间
- 2023-11-3

|
楼主 |
发表于 2023-12-23 15:57:36
|
显示全部楼层
hu7vo6 发表于 2023-12-22 23:57% ?$ g7 ?$ H! m9 G, \" V3 R1 a4 p
Any help "You don't have enough playtime dekaron" when after create character and enter to game ? ! @' M9 Q+ `! [0 O5 W- }1 V
The query analyzer must be executed in billing
# j" T+ H) a3 M. G3 T' ZSQL
@: ^) k& ~. k$ z$ u- CREATE TRIGGER [free] ON [dbo].[user_account]
) |3 ~1 Z- j0 n - after Insert
+ G1 r3 p6 o4 @6 m& H* t* }4 j5 e - as- i4 L7 Y; G! j* r; k% U3 t. O5 d
- Update [user_account] set d8 p. p+ S, y3 B8 h
- [user_account].remain_time =999999,remain_freetime =999999,expire_freetime =2999-1-9- ?/ M# @; R- h
- From Inserted
% S1 D& u1 p4 s: |$ h - Where [user_account].user_id=inserted.user_id
5 n* k1 x0 |4 L V. U - and [user_account].group_id=inserted.group_id
8 G# q0 F+ G. h6 E - update user_account set remain_time =999999,remain_freetime=999999,expire_freetime=2999-1-9" v! n. B& L8 a. W
- where expire_freetime =2006-1-9
复制代码
" h1 w- C9 R, E% d; [
& ^ p' d& M! {* A" h) r/ `4 `0 M |
|