Installations
Step 1 ➡ Dependencies
Step 2 ➡ Resources in server.cfg
Step 3 ➡ Database
Step 4 ➡ Click on Config
Last updated
Last updated
ensure sfvehicleshopALTER TABLE `vehicles` ADD `class` VARCHAR(2) NULL DEFAULT NULL AFTER `category`, ADD `shop` VARCHAR(16) NOT NULL DEFAULT 'vehicle' AFTER `class`, ADD `display` INT(2) NOT NULL DEFAULT '1' AFTER `shop`, ADD `limitSold` INT(11) NOT NULL DEFAULT '0' AFTER `display`, ADD `sold` INT(11) NOT NULL DEFAULT '0' AFTER `limitSold`;
CREATE TABLE `vehicle_classes` (
`name` varchar(60) NOT NULL,
`label` varchar(60) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
ALTER TABLE `vehicle_classes` ADD PRIMARY KEY (`name`);
INSERT INTO `vehicle_classes` (`name`, `label`) VALUES
('A', 'Class A'),
('B', 'Class B'),
('C', 'Class C'),
('D', 'Class D'),
('E', 'Class E'),
('F', 'Class F'),
('S', 'Class S'),
('S+', 'Class S+');CREATE TABLE `vehicle_categories` (
`name` varchar(60) NOT NULL,
`label` varchar(60) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
ALTER TABLE `vehicle_categories` ADD PRIMARY KEY (`name`);
CREATE TABLE `vehicle_classes` (
`name` varchar(60) NOT NULL,
`label` varchar(60) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
ALTER TABLE `vehicle_classes` ADD PRIMARY KEY (`name`);
CREATE TABLE `vehicles` (
`id` int(11) NOT NULL,
`name` varchar(60) NOT NULL,
`model` varchar(60) NOT NULL,
`price` int(11) NOT NULL,
`category` varchar(60) DEFAULT NULL,
`class` varchar(2) DEFAULT NULL,
`shop` varchar(16) NOT NULL DEFAULT 'vehicle',
`display` int(2) NOT NULL DEFAULT 1,
`limitSold` int(11) NOT NULL DEFAULT 0,
`sold` int(11) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
ALTER TABLE `vehicles` ADD PRIMARY KEY (`id`);
ALTER TABLE `vehicles` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1;
INSERT INTO `vehicle_categories` (`name`, `label`) VALUES
('compacts', 'Compacts'),
('coupes', 'Coupés'),
('motorcycles', 'Motos'),
('muscle', 'Muscle'),
('offroad', 'Off Road'),
('sedans', 'Sedans'),
('sports', 'Sports'),
('sportsclassics', 'Sports Classics'),
('super', 'Super'),
('suvs', 'SUVs'),
('vans', 'Vans');
INSERT INTO `vehicle_classes` (`name`, `label`) VALUES
('A', 'Class A'),
('B', 'Class B'),
('C', 'Class C'),
('D', 'Class D'),
('E', 'Class E'),
('F', 'Class F'),
('S', 'Class S'),
('S+', 'Class S+');INSERT INTO `vehicles` (`name`, `model`, `price`, `category`, `class`, `shop`, `display`, `limitSold`, `sold`) VALUES
('Adder', 'adder', 90000, 'super', 'A', 'vehicle', 1, 2, 2),
('Akuma', 'AKUMA', 7500, 'motorcycles', NULL, 'vehicle', 1, 1, 1),
('Alpha', 'alpha', 60000, 'sports', NULL, 'vehicle', 1, 0, 0),
('Speeder', 'speeder', 220000, 'boat', '', 'boat', 1, 0, 0),
('Tug', 'tug', 210000, 'boat', '', 'boat', 1, 0, 0),
('Nimbus', 'nimbus', 1000000, 'plane', '', 'plane', 1, 0, 0),
('Miljet', 'miljet', 2000000, 'plane', '', 'plane', 1, 0, 0),
('Luxor', 'luxor', 3000000, 'plane', '', 'plane', 1, 0, 0),
('SuperVolito', 'supervolito', 1000000, 'plane', '', 'plane', 1, 0, 0),
('Police', 'police', 10000, 'police', 'B', 'vehiclePolice', 1, 0, 1);