Database, clean.

05/24/2015 01:52 RoyalDevil1337#1

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

05/24/2015 11:53 Crayon*#2

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

05/24/2015 23:35 RoyalDevil1337#3

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