Cleaning Object Database.

[Genesis]

Does anyone know how to remove UNUSED vehicles with NO items in inventory WITHOUT removing epoch buildables? By using an SQL query or something?..

 

10:19:04 "HIVE: found 3400 objects"
10:19:04 "HIVE: Commence Object Streaming..."
10:19:05 "HIVE: got 1148 Epoch Objects and 2252 Vehicles"

 

I have my max vehicle spawn rate at 350 and I know that people can buy vehicles but this is too much.

Please remember that I do not want to remove any epoch buildables whatsoever.

 

Thanks in advance! -Genny

[cen]

That's not the real vehicle count on your server.

 

Define "Unused"

[Genesis]

As in unused I mean the vehicle has not been accessed or updated in "X" amount of days.

[Genesis]

 

 

DELETE FROM

`Object_DATA`

WHERE

`Object_DATA`.`Classname` NOT LIKE 'Tent%'

AND `Object_DATA`.`Classname` NOT LIKE '%Locked'

AND `Object_DATA`.`Classname` NOT LIKE 'Land%'

AND `Object_DATA`.`Classname` NOT LIKE 'Cinder%'

AND `Object_DATA`.`Classname` NOT LIKE 'Wood%'

AND `Object_DATA`.`Classname` NOT LIKE 'Metal%'

AND `Object_DATA`.`Classname` NOT LIKE '%Storage%'

AND `Object_DATA`.`Classname` NOT IN ('OutHouse_DZ', 'GunRack_DZ', 'WorkBench_DZ', 'Sandbag1_DZ', 'FireBarrel_DZ', 'DesertCamoNet_DZ', 'StickFence_DZ', 'LightPole_DZ', 'DeerStand_DZ', 'ForestLargeCamoNet_DZ', 'Plastic_Pole_EP1_DZ', 'Hedgehog_DZ', 'FuelPump_DZ', 'Fort_RazorWire', 'SandNest_DZ', 'ForestCamoNet_DZ', 'Fence_corrugated_DZ', 'CanvasHut_DZ', 'Generator_DZ')

AND `Object_DATA`.`LastUpdated` < NOW() - INTERVAL 7 DAY;

Found what i've been looking for! =D

[Genesis]

 

 

DELETE FROM

`Object_DATA`

WHERE

`Object_DATA`.`Classname` NOT LIKE 'Tent%'

AND `Object_DATA`.`Classname` NOT LIKE '%Locked'

AND `Object_DATA`.`Classname` NOT LIKE 'Land%'

AND `Object_DATA`.`Classname` NOT LIKE 'Cinder%'

AND `Object_DATA`.`Classname` NOT LIKE 'Wood%'

AND `Object_DATA`.`Classname` NOT LIKE 'Metal%'

AND `Object_DATA`.`Classname` NOT LIKE '%Storage%'

AND `Object_DATA`.`Classname` NOT IN ('OutHouse_DZ', 'GunRack_DZ', 'WorkBench_DZ', 'Sandbag1_DZ', 'FireBarrel_DZ', 'DesertCamoNet_DZ', 'StickFence_DZ', 'LightPole_DZ', 'DeerStand_DZ', 'ForestLargeCamoNet_DZ', 'Plastic_Pole_EP1_DZ','Hedgehog_DZ', 'FuelPump_DZ', 'Fort_RazorWire', 'SandNest_DZ', 'ForestCamoNet_DZ', 'Fence_corrugated_DZ', 'CanvasHut_DZ', 'Generator_DZ')

AND `Object_DATA`.`Inventory` = '[[[],[]],[[],[]],[[],[]]]'