管理员
- 积分
- 8419
- 金钱
- 2427
- 贡献
- 5394
- 注册时间
- 2023-11-3

|
发表于 2023-12-23 15:57:36
|
显示全部楼层
hu7vo6 发表于 2023-12-22 23:57: u5 E" C1 Q/ Z# s3 f
Any help "You don't have enough playtime dekaron" when after create character and enter to game ? , v8 h( ~5 ~8 ^5 @& M+ a
The query analyzer must be executed in billing1 U" K6 L$ g# S( h6 l
SQL; l, H- W* ?3 ?7 m
- CREATE TRIGGER [free] ON [dbo].[user_account], l+ S& v) q& g9 f* S8 r9 f
- after Insert
0 A( Z: Y$ [/ P4 F$ X7 P1 B - as- [/ D. s; S* B# k+ |: p {
- Update [user_account] set
% j$ q' Y7 C8 b3 o; k$ w9 d+ A/ I - [user_account].remain_time =999999,remain_freetime =999999,expire_freetime =2999-1-9
' y" |6 _4 c: ^# a - From Inserted8 c) O C# i e, h& \" E
- Where [user_account].user_id=inserted.user_id8 S/ n: p9 r: w4 `5 g
- and [user_account].group_id=inserted.group_id! A# q7 Y% n, Q2 q# c* ?3 t: J
- update user_account set remain_time =999999,remain_freetime=999999,expire_freetime=2999-1-91 Y3 e& [$ i' Y% R0 d
- where expire_freetime =2006-1-9
复制代码
; z. K1 }) g% P3 _ R5 q. r8 ~0 @) `
|
|