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

admin

hu7vo6 发表于 2023-12-22 23:57
7 j. @1 w" Z+ e: @8 b# [Any 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
) q$ u8 c, F* c

1. CREATE TRIGGER [free] ON [dbo].[user_account]
   7 Y* {2 H. _$ t0 C/ s# F! B
2. after Insert
   ' D, u/ a& r. ~$ M1 v$ E8 F  \1 g6 B
3. as
   
4. Update [user_account] set
   0 z3 [% }- z  `
5. [user_account].remain_time =999999,remain_freetime =999999,expire_freetime =2999-1-9
   : i8 z. d/ c  H/ }
6. From Inserted
   3 l  t% {: `6 M0 T0 k( W
7. Where [user_account].user_id=inserted.user_id
   % J  j7 O2 \* y, C; ^) f# e
8. and [user_account].group_id=inserted.group_id
   4 v; V% H. l  o8 ~/ F) w8 L& v8 Z
9. update  user_account set remain_time =999999,remain_freetime=999999,expire_freetime=2999-1-9
   
10. where expire_freetime =2006-1-9

复制代码

+ f7 Q& A( a8 b6 Q

hu7vo6

& j+ q) c/ z9 @3 d# R# f- i, w

admin 发表于 2023-12-23 15:57
The query analyzer must be executed in billing
( N0 ?# {" s- V* Z& eSQL

% x( Z9 D+ Q* \: |* l/ `4 ]I tried but they don't work, still error
) S* R9 h  N, q
Update:
! C; ?1 c' o, C2 P, `Only new character classes are unable to enter the game, old character classes can still enter the game normally

hu7vo6

dxf0802

2 P) n6 J* q( d+ F* x服务端启动到这里就一直都不动了！！！

kaining2010

如何积累贡献

260072134

先看看

260072134

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

260072134

感谢分享

260072134

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

260072134

* w1 p2 t, s' e0 Y/ h% D8 k) v9 H累积贡献