From 98d6c501d7c1a7a632c6ff8b1d46c7d0d4ae5b37 Mon Sep 17 00:00:00 2001 From: Ovah Date: Sat, 8 Feb 2020 20:47:46 +0100 Subject: Core/Vehicles: implement vehicle seat addon table to specify seat ori… (#24112) MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit * Core/Vehicles: implement vehicle seat addon table to specify seat orientation offsets and exit positions in form of offsets or absolute positions * converted Traveler's Tundra Mammoth to seat addon table data * first follow batch * whoopsie * Core/Vehicles: go from local copies to pointers * Update and rename 2020_99_99_99_world.sql to 2020_02_08_01_world.sql Co-authored-by: Giacomo Pozzoni --- sql/updates/world/3.3.5/2020_02_08_01_world.sql | 18 ++++++++++++++++++ 1 file changed, 18 insertions(+) create mode 100644 sql/updates/world/3.3.5/2020_02_08_01_world.sql (limited to 'sql/updates') diff --git a/sql/updates/world/3.3.5/2020_02_08_01_world.sql b/sql/updates/world/3.3.5/2020_02_08_01_world.sql new file mode 100644 index 00000000000..00bf33bb853 --- /dev/null +++ b/sql/updates/world/3.3.5/2020_02_08_01_world.sql @@ -0,0 +1,18 @@ +-- +DROP TABLE IF EXISTS `vehicle_seat_addon`; +CREATE TABLE `vehicle_seat_addon` ( + `SeatEntry` INT(4) UNSIGNED NOT NULL COMMENT 'VehicleSeatEntry.dbc identifier', + `SeatOrientation` FLOAT(6) DEFAULT 0 COMMENT 'Seat Orientation override value', + `ExitParamX` FLOAT(10) DEFAULT 0, + `ExitParamY` FLOAT(10) DEFAULT 0, + `ExitParamZ` FLOAT(10) DEFAULT 0, + `ExitParamO` FLOAT(10) DEFAULT 0, + `ExitParamValue` TINYINT(1) DEFAULT 0, + PRIMARY KEY (`SeatEntry`) +); + +INSERT INTO `vehicle_seat_addon` (`SeatEntry`, `SeatOrientation`, `ExitParamX`, `ExitParamY`, `ExitParamZ`, `ExitParamO`, `ExitParamValue`) VALUES +(2764, 0, -2, 2, 0, 0, 1), -- Traveler's Tundra Mammoth Seat 2 +(2765, 0, -2, -2, 0, 0, 1), -- Traveler's Tundra Mammoth Seat 3 +(2767, 0, -2, 2, 0, 0, 1), -- Traveler's Tundra Mammoth Seat 2 +(2768, 0, -2, -2, 0, 0, 1); -- Traveler's Tundra Mammoth Seat 3 -- cgit v1.2.3