[VSRO] NEED A PROFESSIONAL TO FIX THIS HORRIBLE ISSUE

04/02/2012 14:22 multiuses#1

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 :)

04/08/2012 00:14 Serenduk#2

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

04/08/2012 06:22 zChopper#3

Thers a query somewhere around here, let me searchh.

04/08/2012 20:29 zikor1337#4

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

04/09/2012 02:51 6_lucifer_6#5

Quote:

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..

04/09/2012 08:47 zikor1337#6

Quote:

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 :facepalm:, get the fuck out and stop being a retard .

10/11/2012 19:49 carmenjason#7

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