Vehicle Overview

[shinkicker]

Can anyone explain to me how the vehicle tables map in Bliss?

I honestly don't know yet.

 

[king2k]

there are 3 tables involved.

vehicle - list of available vehicles (can set min/max damage and fuel)
world_vehicle - spawn locations (world_id is the map. see world table. Also the spawn chance can be adjusted here)
instance_vehicle - this is the table with ingame vehicles

I use this query to get an overview of the spawned vehicles:

select
iv.id,
v.class_name,
iv.worldspace,
iv.inventory,
iv.parts,
fuel,
iv.damage,
iv.last_updated,
iv.created
from instance_vehicle iv
inner join
world_vehicle wv on iv.world_vehicle_id = wv.id
inner join
vehicle v on wv.vehicle_id = v.id
where iv.instance_id = 1
order by v.class_name

query taken from the bliss admin tool..
Adjust the instance_id accordingly.

 

[JoSchaap]

bliss also has views nowadays