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 
05/24/2015 23:35 RoyalDevil1337#3
Quote:
Originally Posted by Crayon ™ View Post
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 
Thx