Database, clean.

RoyalDevil1337 · 05/24/2015, 01:52

Hey mates,

I'm using a released database (has a lot of features i like) and there are some lines in refobjcommon that service = 0, and doesn't exist in the media, also have links to refobjitem etc.

My question: How do i clean those tables from not needed stuff like this?
Thanks in advance

Crayon* · 05/24/2015, 11:53

You can use a query of "DELETE" command, but it will be messed up.
Better to ignore these lines, the gameserver will not read it and it will never affect anything!
Query :-

PHP Code:


			
USE SRO_VT_SHARD

DELETE FROM _RefObjItem where ID = (SELECT Link FROM _RefObjCommon where Service = 0)

DELETE FROM _RefObjCommon where Service = 0

RoyalDevil1337 · 05/24/2015, 23:35

Quote:

Originally Posted by Crayon ™

You can use a query of "DELETE" command, but it will be messed up.
Better to ignore these lines, the gameserver will not read it and it will never affect anything!
Query :-

PHP Code:

USE SRO_VT_SHARD DELETE FROM _RefObjItem where ID = (SELECT Link FROM _RefObjCommon where Service = 0) DELETE FROM _RefObjCommon where Service = 0

Thx