13-14职业服务端+数据库+客户端

admin · 发表于 2023-12-23 15:57:36

hu7vo6 发表于 2023-12-22 23:57
7 e0 j, M9 q* }: X9 n) YAny help "You don't have enough playtime dekaron" when after create character and enter to game ?

The query analyzer must be executed in billing
SQL

CREATE TRIGGER [free] ON [dbo].[user_account]
5 T& F9 `- ?, ~' _% R5 Y1 V2 x& N
after Insert. V$ }9 _0 x4 q! P7 l$ {6 t# y
as9 I0 T1 y% R4 Y6 U
Update [user_account] set
+ q: s2 e9 U9 R! t7 l$ y# f5 h' w
[user_account].remain_time =999999,remain_freetime =999999,expire_freetime =2999-1-9- z1 f$ k M; E/ v3 r1 [- b
From Inserted
* g0 G# P, O! ^, R- `/ I: Y$ Q
Where [user_account].user_id=inserted.user_id
1 E, d7 W) n& F3 C" l
and [user_account].group_id=inserted.group_id
5 u8 F0 U! @2 Z
update user_account set remain_time =999999,remain_freetime=999999,expire_freetime=2999-1-9
7 L* n- v. F8 G- ?0 K1 H
where expire_freetime =2006-1-9

复制代码

hu7vo6 · 发表于 2023-12-23 19:25:46

本帖最后由 hu7vo6 于 2023-12-23 19:43 编辑

admin 发表于 2023-12-23 15:57" U4 x7 a |# P) ^+ X
The query analyzer must be executed in billing; h$ o7 [) P/ k3 u7 r+ V/ g
SQL

I tried but they don't work, still error

Update:
Only new character classes are unable to enter the game, old character classes can still enter the game normally

hu7vo6 · 发表于 2024-1-5 02:27:02

dxf0802 · 发表于 2024-1-12 20:18:49

本帖最后由 dxf0802 于 2024-1-12 20:20 编辑

服务端启动到这里就一直都不动了！！！

kaining2010 · 发表于 2024-1-18 14:23:59

如何积累贡献

260072134 · 发表于 2024-1-20 09:12:47

先看看

260072134 · 发表于 2024-1-21 13:23:50

感谢楼主分享！我是来学习的

260072134 · 发表于 2024-1-21 15:14:46

本帖最后由 260072134 于 2024-3-13 13:48 编辑

感谢分享

260072134 · 发表于 2024-1-21 15:47:26

内容比较高深，再次学习下

260072134 · 发表于 2024-1-22 09:58:37

本帖最后由 260072134 于 2024-3-13 13:48 编辑

累积贡献

		自动登录	找回密码
密码			立即注册

[服务端] 13-14职业服务端+数据库+客户端