problem in C-Sro

06/18/2015 14:11 shmantr2018#1

i fixed all bugs it C-Sro Files and DB

But i have problem

if i open hotan and alex i get this error in gameserver

CGameWorld::SpawnNPCAt - Error Spawn NPC

and any monster appear
disappear

and after few minutes gameserver shutdown :(

what is have to do to fix it ?!!

04/09/2016 22:45 forexjsr#2

same error here..help anyone?

04/11/2016 00:12 EdwardTeach+-#3

Hey, i fixed this problem 2 months ago,
Reason is mobs goes more than 50K+, then it's disappear automatically

FIX :

Code:

Declare [MENTION=1720025]Rate[/MENTION] float = 1.0;
UPDATE dbo.Tab_RefNest
SET dwmaxtotalcount = CASE WHEN CONVERT(INT,ROUND(dwmaxtotalcount [MENTION=1720025]Rate[/MENTION],0)) = 0 THEN 1 ELSE CONVERT(INT,ROUND(dwmaxtotalcount [MENTION=1720025]Rate[/MENTION],0)) END
FROM Tab_RefNest as tabrn
JOIN Tab_RefTactics as tabrt on tabrn.dwTacticsID = tabrt.dwTacticsID
JOIN _RefObjCommon as ref on tabrt.dwObjID = ref.ID
WHERE
TypeID1 = 1 AND TypeID2 = 2 AND TypeID3 = 1 AND Rarity = 3 AND [Service] = 1

06/12/2016 22:48 kotsh#4

Thank you Patato :)

i think there is wrong small things , its easy for anyone know well in sql but there who dont know how to fix it so i try to share it for them but its not my query guys its Patato one

Declare @[Only registered and activated users can see links. Click Here To Register...] float = 1.0;
UPDATE dbo.Tab_RefNest
SET dwmaxtotalcount = CASE WHEN CONVERT(INT,ROUND(dwmaxtotalcount @[Only registered and activated users can see links. Click Here To Register...],0)) = 0 THEN 1 ELSE CONVERT(INT,ROUND(dwmaxtotalcount @[Only registered and activated users can see links. Click Here To Register...],0)) END
FROM Tab_RefNest as tabrn
JOIN Tab_RefTactics as tabrt on tabrn.dwTacticsID = tabrt.dwTacticsID
JOIN _RefObjCommon as ref on tabrt.dwObjID = ref.ID
WHERE
TypeID1 = 1 AND TypeID2 = 2 AND TypeID3 = 1 AND Rarity = 3 AND [Service] = 1