[VSRO] NEED A PROFESSIONAL TO FIX THIS HORRIBLE ISSUE

[multiuses]

my DB was having the pet dc
a friend told me to delete the 2 keys of _Char Tab in relationship..
when i deleted them i met another problem
my game server alwas get this error :
.
CGObj::GetTID() GetDataPermanent Error
CGObj::GetTID() GetDataPermanent Error
CGObj::GetTID() GetDataPermanent Error
CGObj::GetTID() GetDataPermanent Error
CGObj::GetTID() GetDataPermanent Error

i cant spawn mobs too when i get this error
i need a Professional person to tell me how to fix this
please if anyone knows how to fix this problem please share

[Serenduk]

too many mobs spawned do /worldstatus i bet over 50k turn mob spawn down on 1 game server

[zChopper]

Thers a query somewhere around here, let me searchh.

[zikor1337]

PHP Code:

USE [SRO_VT_SHARD]
GO
UPDATE dbo.Tab_RefNest SET dwmaxtotalcount = dwmaxtotalcount/2 


and

PHP Code:

USE [SRO_VT_SHARD]
GO
UPDATE dbo.Tab_RefNest SET dwmaxtotalcount = 1  where dwdelaytimemax = '21600' ; 


and

PHP Code:

USE SRO_VT_SHARD_INIT
--B1
UPDATE Tab_RefNest SET dwMaxTotalCount=1 WHERE dwTacticsID=32100 --B1 Unique
--B2
UPDATE Tab_RefNest SET dwMaxTotalCount=1 WHERE dwTacticsID=32200 --Camp 8 Unique
UPDATE Tab_RefNest SET dwMaxTotalCount=1 WHERE dwTacticsID=32300 --Camp 11 Unique
UPDATE Tab_RefNest SET dwMaxTotalCount=1 WHERE dwTacticsID=32400 --Camp 11 Unique
--B3
UPDATE Tab_RefNest SET dwMaxTotalCount=1 WHERE dwTacticsID=32500
UPDATE Tab_RefNest SET dwMaxTotalCount=1 WHERE dwTacticsID=32600
UPDATE Tab_RefNest SET dwMaxTotalCount=1 WHERE dwTacticsID=32700
UPDATE Tab_RefNest SET dwMaxTotalCount=1 WHERE dwTacticsID=32800 


[6_lucifer_6]

Originally Posted by zikor1337

PHP Code:

USE [SRO_VT_SHARD]
GO
UPDATE dbo.Tab_RefNest SET dwmaxtotalcount = dwmaxtotalcount/2 


and

PHP Code:

USE [SRO_VT_SHARD]
GO
UPDATE dbo.Tab_RefNest SET dwmaxtotalcount = 1  where dwdelaytimemax = '21600' ; 


and

PHP Code:

USE SRO_VT_SHARD_INIT
--B1
UPDATE Tab_RefNest SET dwMaxTotalCount=1 WHERE dwTacticsID=32100 --B1 Unique
--B2
UPDATE Tab_RefNest SET dwMaxTotalCount=1 WHERE dwTacticsID=32200 --Camp 8 Unique
UPDATE Tab_RefNest SET dwMaxTotalCount=1 WHERE dwTacticsID=32300 --Camp 11 Unique
UPDATE Tab_RefNest SET dwMaxTotalCount=1 WHERE dwTacticsID=32400 --Camp 11 Unique
--B3
UPDATE Tab_RefNest SET dwMaxTotalCount=1 WHERE dwTacticsID=32500
UPDATE Tab_RefNest SET dwMaxTotalCount=1 WHERE dwTacticsID=32600
UPDATE Tab_RefNest SET dwMaxTotalCount=1 WHERE dwTacticsID=32700
UPDATE Tab_RefNest SET dwMaxTotalCount=1 WHERE dwTacticsID=32800 


taken from rage zone..

[zikor1337]

Originally Posted by 6_lucifer_6

taken from rage zone..

Of course, lol ... I have text files where I keep such queries. It was originally taken from Rage Zone.

You would have write them on your own, right?

Gosh , get the **** out and stop being a ****** .

[carmenjason]

USE SRO_VT_SHARD
UPDATE Tab_RefNest SET dwmaxtotalcount=dwmaxtotalcount/2
WHERE dwTacticsID NOT BETWEEN 41000 AND 43860
AND dwTacticsID NOT BETWEEN 32100 AND 32800