Execute the following SQL code in your database:
Copy CREATE TABLE `okokgarage_pgarages` (
`garagename` VARCHAR( 250 ) NULL DEFAULT NULL,
`coords` VARCHAR( 250 ) NULL DEFAULT NULL,
`type` VARCHAR( 50 ) NULL DEFAULT NULL,
`owners` VARCHAR( 250 ) NULL DEFAULT NULL
);
CREATE TABLE `okokgarage_companies` (
`company_name` VARCHAR( 50 ) NOT NULL,
`owner` VARCHAR( 255 ) NULL DEFAULT NULL,
`owner_name` VARCHAR( 50 ) NULL DEFAULT NULL,
`money` INT( 11 ) NULL DEFAULT NULL,
`employees` LONGTEXT NULL DEFAULT NULL,
`total_sales` INT( 11 ) NULL DEFAULT NULL,
`sales_history` LONGTEXT NULL DEFAULT NULL,
CONSTRAINT `employees` CHECK (json_valid( `employees` ))
);
CREATE TABLE `okokgarage_sharedgarages` (
`owner` VARCHAR( 255 ) NULL DEFAULT NULL,
`ownername` VARCHAR( 50 ) NULL DEFAULT NULL,
`sharedwith` LONGTEXT NULL DEFAULT NULL
);
Copy ALTER TABLE `owned_vehicles`
ADD COLUMN `parking` VARCHAR( 60 ) NULL DEFAULT NULL,
ADD COLUMN `doorcondition` VARCHAR( 255 ) NULL DEFAULT NULL,
ADD COLUMN `windowcondition` VARCHAR( 255 ) NULL DEFAULT NULL,
ADD COLUMN `tyrecondition` VARCHAR( 255 ) NULL DEFAULT NULL,
ADD COLUMN `favourite` TINYINT( 1 ) NULL DEFAULT 0 ,
ADD COLUMN `impoundTime` VARCHAR( 255 ) NULL DEFAULT NULL,
ADD COLUMN `location` VARCHAR( 255 ) NULL DEFAULT NULL,
ADD COLUMN `reason` VARCHAR( 255 ) NULL DEFAULT NULL,
ADD COLUMN `sharedwith` LONGTEXT NULL DEFAULT '[]' ,
ADD COLUMN `vehiclename` varchar ( 23 ) NULL DEFAULT NULL
;
Copy ALTER TABLE `player_vehicles`
ADD COLUMN `parking` VARCHAR( 60 ) NULL DEFAULT NULL,
ADD COLUMN `doorcondition` VARCHAR( 255 ) NULL DEFAULT NULL,
ADD COLUMN `windowcondition` VARCHAR( 255 ) NULL DEFAULT NULL,
ADD COLUMN `tyrecondition` VARCHAR( 255 ) NULL DEFAULT NULL,
ADD COLUMN `favourite` TINYINT( 1 ) NULL DEFAULT 0 ,
ADD COLUMN `impoundTime` VARCHAR( 255 ) NULL DEFAULT NULL,
ADD COLUMN `location` VARCHAR( 255 ) NULL DEFAULT NULL,
ADD COLUMN `reason` VARCHAR( 255 ) NULL DEFAULT NULL,
ADD COLUMN `sharedwith` LONGTEXT NULL DEFAULT '[]' ,
ADD COLUMN `vehiclename` varchar ( 23 ) NULL DEFAULT NULL
;
Once triggered, the only way for a player to recover their vehicle is to go to the police station and pay to get the vehicle back in their garage.
Copy TriggerServerEvent ( "okokGarage:setVehicleStolen" , plate)
Set the Discord Webhook URL (to enable logs)