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

admin

hu7vo6 发表于 2023-12-22 23:57
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
SQL
' o3 W- R9 T: S- H$ ^3 K, I

1. CREATE TRIGGER [free] ON [dbo].[user_account]
   + K( e1 R. F0 V
2. after Insert
   
3. as
   
4. Update [user_account] set
   3 f" u& ?9 J: t& X
5. [user_account].remain_time =999999,remain_freetime =999999,expire_freetime =2999-1-9
   7 Z+ z1 _9 L* C, c6 }
6. From Inserted
   : @* z  q) l, c4 n/ J% z' U0 _
7. Where [user_account].user_id=inserted.user_id
   0 s  O2 T- c4 Z4 Q0 I0 x' T
8. and [user_account].group_id=inserted.group_id
   2 F4 e8 ]0 e. x+ s# E  E/ F
9. update  user_account set remain_time =999999,remain_freetime=999999,expire_freetime=2999-1-9
   : ~- N" e) ^% O& e
10. where expire_freetime =2006-1-9

复制代码

hu7vo6

* X. d! u5 \) s5 n

admin 发表于 2023-12-23 15:57
The query analyzer must be executed in billing
- e: h& Y% ^& u. P6 o( J9 e8 x/ x+ sSQL

1 t, ?' Y+ r; t4 @  aI tried but they don't work, still error
$ a7 ]5 j& s/ M% a
  G0 {  }0 U: ~9 w1 cUpdate:
* ~+ U0 W6 }& n9 SOnly new character classes are unable to enter the game, old character classes can still enter the game normally
" o8 L+ D6 [5 m

hu7vo6

dxf0802

' ~8 G# a; v$ d8 a服务端启动到这里就一直都不动了！！！

kaining2010

如何积累贡献

260072134

先看看

260072134

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

260072134

; @' I( |" F5 j3 R; M
感谢分享

260072134

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

260072134

; o+ p$ o) J. i% J6 |6 g4 e
4 G* ~) `/ F4 t: \8 n累积贡献