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)