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

admin

hu7vo6 发表于 2023-12-22 23:57
& H4 a. N" S0 RAny help "You don't have enough playtime dekaron" when after create character and enter to game ?

) a5 m) l$ l- nThe query analyzer must be executed in billing
' E. |2 S  ^) R. l) [" b* S) N) lSQL
1 N8 ]/ B5 L( d

1. CREATE TRIGGER [free] ON [dbo].[user_account]
   5 H; O; e: ]1 Y2 ^- b  b1 y
2. after Insert
   ; N& h+ z* Z3 ~. s: a7 F. F/ |* g+ G
3. as
   $ t0 Q9 P0 k: F0 X( x2 |% w+ t2 v
4. Update [user_account] set
   ) S% M: r, b4 Q  T5 [
5. [user_account].remain_time =999999,remain_freetime =999999,expire_freetime =2999-1-9
   5 e/ q3 `. z7 G; W% n* Q' S, R
6. From Inserted
   8 o) |4 Q4 g/ ^1 m1 I
7. Where [user_account].user_id=inserted.user_id
   ! |& }' c- J3 [- B- c! Y
8. and [user_account].group_id=inserted.group_id
   
9. update  user_account set remain_time =999999,remain_freetime=999999,expire_freetime=2999-1-9
   
10. where expire_freetime =2006-1-9

复制代码

0 g3 B7 k$ N- ?$ e' Q7 ~. }

hu7vo6

admin 发表于 2023-12-23 15:57
& N  Z3 _( O& }The query analyzer must be executed in billing
SQL

I tried but they don't work, still error
, T( G- i0 O" o# U& _" ^, _
Update:
: p6 g  ?: Y" \1 A9 m! h3 I* Q) y  VOnly new character classes are unable to enter the game, old character classes can still enter the game normally

6 v: n# o3 _% w* J, h0 F6 H5 U2 i# N

hu7vo6

dxf0802

+ T1 h9 c: \9 @+ a
服务端启动到这里就一直都不动了！！！

kaining2010

如何积累贡献

260072134

先看看

260072134

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

260072134

感谢分享

260072134

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

260072134

7 v9 y* v  {2 J
  r& K2 L: ~5 P3 g8 a2 \8 r累积贡献