Trucker Logistics script - Trucker Simulator

[Beelzebuth]

Beelzebuth submitted a new resource:

Trucker Logistics script - Trucker Simulator - trucker logistics script

View attachment 703


Script description:

• Euro Truck Simulator game style trucker system, where you can manage your own Truck Logistics;
• Statistics system, where you can see the complete data of your company;
• There are 2 types of deliveries:

1. You deliver with a rental truck;
2. You deliver with your own truck, where you can generate more money;

• The delivery gains are based on the experience you...

Read more about this resource...

 

[Nod32]

Tell me how to install this correctly, otherwise I’m getting errors in the database

script:trucker] SCRIPT ERROR: @trucker/server.lua:15: trucker was unable to execute a query!
[ script:trucker] Query: CREATE TABLE IF NOT EXISTS `trucker_available_contracts` (
[ script:trucker] `contract_id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
[ script:trucker] `contract_type` BIT(1) NOT NULL DEFAULT b'0',
[ script:trucker] `contract_name` VARCHAR(50) NOT NULL DEFAULT '' COLLATE 'utf8mb4_general_ci',
[ script:trucker] `coords_index` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',
[ script:trucker] `price_per_km` INT(10) UNSIGNED NOT NULL DEFAULT '0',
[ script:trucker] `cargo_type` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
[ script:trucker] `fragile` BIT(1) NOT NULL DEFAULT b'0',
[ script:trucker] `valuable` BIT(1) NOT NULL DEFAULT b'0',
[ script:trucker] `fast` BIT(1) NOT NULL DEFAULT b'0',
[ script:trucker] `truck` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci',
[ script:trucker] `trailer` VARCHAR(50) NOT NULL COLLATE 'utf8mb4_general_ci',
[ script:trucker] PRIMARY KEY (`contract_id`) USING BTREE
[ script:trucker] )
[ script:trucker] COLLATE='utf8mb4_general_ci'
[ script:trucker] ENGINE=InnoDB
[ script:trucker] ;
[ script:trucker]
[ script:trucker] CREATE TABLE IF NOT EXISTS "trucker_drivers" (
[ script:trucker] `driver_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
[ script:trucker] `user_id` VARCHAR(50) NULL DEFAULT NULL,
[ script:trucker] `name` VARCHAR(50) NOT NULL DEFAULT '' COLLATE 'utf8mb4_general_ci',
[ script:trucker] `product_type` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
[ script:trucker] `distance` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
[ script:trucker] `valuable` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
[ script:trucker] `fragile` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
[ script:trucker] `fast` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
[ script:trucker] `price` INT(10) UNSIGNED NOT NULL DEFAULT '0',
[ script:trucker] `price_per_km` INT(10) UNSIGNED NOT NULL DEFAULT '0',
[ script:trucker] `img` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci',
[ script:trucker] PRIMARY KEY (`driver_id`) USING BTREE
[ script:trucker] )
[ script:trucker] COLLATE='utf8mb4_general_ci'
[ script:trucker] ENGINE=InnoDB
[ script:trucker] ;
[ script:trucker]
[ script:trucker] CREATE TABLE IF NOT EXISTS `trucker_loans` (
[ script:trucker] `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
[ script:trucker] `user_id` VARCHAR(50) NOT NULL,
[ script:trucker] `loan` INT(10) UNSIGNED NOT NULL DEFAULT '0',
[ script:trucker] `remaining_amount` INT(10) UNSIGNED NOT NULL DEFAULT '0',
[ script:trucker] `day_cost` INT(10) UNSIGNED NOT NULL DEFAULT '0',
[ script:trucker] `taxes_on_day` INT(10) UNSIGNED NOT NULL DEFAULT '0',
[ script:trucker] `timer` INT(10) UNSIGNED NOT NULL DEFAULT '0',
[ script:trucker] PRIMARY KEY (`id`) USING BTREE
[ script:trucker] )
[ script:trucker] COLLATE='utf8mb4_general_ci'
[ script:trucker] ENGINE=InnoDB
[ script:trucker] ;
[ script:trucker]
[ script:trucker] CREATE TABLE IF NOT EXISTS `trucker_trucks` (
[ script:trucker] `truck_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
[ script:trucker] `user_id` VARCHAR(50) NOT NULL,
[ script:trucker] `truck_name` VARCHAR(50) NOT NULL COLLATE 'utf8mb4_general_ci',
[ script:trucker] `driver` INT(10) UNSIGNED NULL DEFAULT NULL,
[ script:trucker] `body` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '1000',
[ script:trucker] `engine` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '1000',
[ script:trucker] `transmission` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '1000',
[ script:trucker] `wheels` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '1000',
[ script:trucker] PRIMARY KEY (`truck_id`) USING BTREE
[ script:trucker] )
[ script:trucker] COLLATE='utf8mb4_general_ci'
[ script:trucker] ENGINE=InnoDB
[ script:trucker] ;
[ script:trucker]
[ script:trucker] CREATE TABLE IF NOT EXISTS `trucker_users` (
[ script:trucker] `user_id` VARCHAR(50) NOT NULL,
[ script:trucker] `money` INT(10) UNSIGNED NOT NULL DEFAULT '0',
[ script:trucker] `total_earned` INT(10) UNSIGNED NOT NULL DEFAULT '0',
[ script:trucker] `finished_deliveries` INT(10) UNSIGNED NOT NULL DEFAULT '0',
[ script:trucker] `exp` INT(10) UNSIGNED NOT NULL DEFAULT '0',
[ script:trucker] `traveled_distance` DOUBLE UNSIGNED NOT NULL DEFAULT '0',
[ script:trucker] `skill_points` INT(10) UNSIGNED NOT NULL DEFAULT '0',
[ script:trucker] `product_type` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
[ script:trucker] `distance` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
[ script:trucker] `valuable` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
[ script:trucker] `fragile` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
[ script:trucker] `fast` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
[ script:trucker] `loan_notify` BIT(1) NOT NULL DEFAULT b'0',
[ script:trucker] PRIMARY KEY (`user_id`) USING BTREE
[ script:trucker] )
[ script:trucker] COLLATE='utf8mb4_general_ci'
[ script:trucker] ENGINE=InnoDB
[ script:trucker] ;
[ script:trucker]
[ script:trucker]
[ script:trucker] []
[ script:trucker] You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'CREATE TABLE IF NOT EXISTS "trucker_drivers" (
[ script:trucker] `driver_id` INT(10) UNSIGNE...' at line 19

 

[loren997]

wow