diff options
| author | Ovah <dreadkiller@gmx.de> | 2020-02-08 20:47:46 +0100 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2020-02-08 20:47:46 +0100 |
| commit | 98d6c501d7c1a7a632c6ff8b1d46c7d0d4ae5b37 (patch) | |
| tree | 8b4e5fc77bacc7bf22681ce229b09c0741ccbeb9 /sql | |
| parent | 58313fc33092236b4eedbbfb25e10ab42bec6b0e (diff) | |
Core/Vehicles: implement vehicle seat addon table to specify seat ori… (#24112)
* 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 <giacomopoz@gmail.com>
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/3.3.5/2020_02_08_01_world.sql | 18 |
1 files changed, 18 insertions, 0 deletions
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 |