FIVEM Los Santos Trucker Simulator / Trucker Logistics script (ETS, ATS) (1 Viewer)

[jlaw]

need this for my rp server thanks

 

[3ckiii]

here I leave the new link https://mega.nz/file/YRImTTQR#5MI_SdsXyxkXckMaLqodH-TWBdjy1zFSSMYSiqpayC4

Not work at ESX Legacy

vex_trucker/server.lua:246: attempt to compare nil with number

 

[gebakkenrusty]

[video=youtube]

Download

it isnt available anymore or?

 

[.lwwilliam]

thanks for your work continue

 

[moscow_sergej]

everyone is wondering, was anyone able to configure this script to make it work?

 

[nathanck]

Does this work for qb? and the link is dead

 

[scooby0014]

thank u so much bro

 

[ribeiro]

Great work on the leak, much appreciated!

 

[yanhesap_927]

wow thank yu <3 man

 

[maxhero]

here I leave the new link https://mega.nz/file/YRImTTQR#5MI_SdsXyxkXckMaLqodH-TWBdjy1zFSSMYSiqpayC4

SQL needed ... why dont but in it ?

 

[maxhero]

ESX not QB i find some solution maybe you can try put this for SQL manual.... i tried for QBcore but dont working ....


CREATE TABLE IF NOT EXISTS `trucker_available_contracts` (
`contract_id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
`contract_type` BIT(1) NOT NULL DEFAULT b'0',
`contract_name` VARCHAR(50) NOT NULL DEFAULT '' COLLATE 'utf8mb4_general_ci',
`coords_index` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',
`price_per_km` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`cargo_type` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
`fragile` BIT(1) NOT NULL DEFAULT b'0',
`valuable` BIT(1) NOT NULL DEFAULT b'0',
`fast` BIT(1) NOT NULL DEFAULT b'0',
`truck` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci',
`trailer` VARCHAR(50) NOT NULL COLLATE 'utf8mb4_general_ci',
PRIMARY KEY (`contract_id`) USING BTREE
)
COLLATE='utf8mb4_general_ci'
ENGINE=InnoDB
;
CREATE TABLE IF NOT EXISTS `trucker_drivers` (
`driver_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
`user_id` VARCHAR(50) NULL DEFAULT NULL,
`name` VARCHAR(50) NOT NULL DEFAULT '' COLLATE 'utf8mb4_general_ci',
`product_type` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
`distance` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
`valuable` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
`fragile` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
`fast` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
`price` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`price_per_km` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`img` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci',
PRIMARY KEY (`driver_id`) USING BTREE
)
COLLATE='utf8mb4_general_ci'
ENGINE=InnoDB
;
CREATE TABLE IF NOT EXISTS `trucker_loans` (
`id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
`user_id` VARCHAR(50) NOT NULL,
`loan` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`remaining_amount` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`day_cost` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`taxes_on_day` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`timer` INT(10) UNSIGNED NOT NULL DEFAULT '0',
PRIMARY KEY (`id`) USING BTREE
)
COLLATE='utf8mb4_general_ci'
ENGINE=InnoDB
;
CREATE TABLE IF NOT EXISTS `trucker_trucks` (
`truck_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
`user_id` VARCHAR(50) NOT NULL,
`truck_name` VARCHAR(50) NOT NULL COLLATE 'utf8mb4_general_ci',
`driver` INT(10) UNSIGNED NULL DEFAULT NULL,
`body` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '1000',
`engine` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '1000',
`transmission` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '1000',
`wheels` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '1000',
PRIMARY KEY (`truck_id`) USING BTREE
)
COLLATE='utf8mb4_general_ci'
ENGINE=InnoDB
;
CREATE TABLE IF NOT EXISTS `trucker_users` (
`user_id` VARCHAR(50) NOT NULL,
`money` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`total_earned` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`finished_deliveries` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`exp` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`traveled_distance` DOUBLE UNSIGNED NOT NULL DEFAULT '0',
`skill_points` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`product_type` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
`distance` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
`valuable` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
`fragile` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
`fast` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
`loan_notify` BIT(1) NOT NULL DEFAULT b'0',
PRIMARY KEY (`user_id`) USING BTREE
)
COLLATE='utf8mb4_general_ci'
ENGINE=InnoDB
;


Errors : its not QB ........

[ TXADMIN] txaReportResources
[ resources] Stopping resource vex_trucker
[ c-scripting-core] Creating script environments for vex_trucker
[ resources] Started resource vex_trucker
[ script:monitor] [txAdmin] Sending resources list to txAdmin.
[ script:vex_trucker] SCRIPT ERROR: @vex_trucker/server.lua:15: vex_trucker was unable to execute a query!
[ script:vex_trucker] Query: CREATE TABLE IF NOT EXISTS `trucker_available_contracts` (
[ script:vex_trucker] `contract_id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
[ script:vex_trucker] `contract_type` BIT(1) NOT NULL DEFAULT b'0',
[ script:vex_trucker] `contract_name` VARCHAR(50) NOT NULL DEFAULT '' COLLATE 'utf8mb4_general_ci',
[ script:vex_trucker] `coords_index` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',
[ script:vex_trucker] `price_per_km` INT(10) UNSIGNED NOT NULL DEFAULT '0',
[ script:vex_trucker] `cargo_type` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
[ script:vex_trucker] `fragile` BIT(1) NOT NULL DEFAULT b'0',
[ script:vex_trucker] `valuable` BIT(1) NOT NULL DEFAULT b'0',
[ script:vex_trucker] `fast` BIT(1) NOT NULL DEFAULT b'0',
[ script:vex_trucker] `truck` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci',
[ script:vex_trucker] `trailer` VARCHAR(50) NOT NULL COLLATE 'utf8mb4_general_ci',
[ script:vex_trucker] PRIMARY KEY (`contract_id`) USING BTREE
[ script:vex_trucker] )
[ script:vex_trucker] COLLATE='utf8mb4_general_ci'
[ script:vex_trucker] ENGINE=InnoDB
[ script:vex_trucker] ;
[ script:vex_trucker]
[ script:vex_trucker] CREATE TABLE IF NOT EXISTS `trucker_drivers` (
[ script:vex_trucker] `driver_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
[ script:vex_trucker] `user_id` VARCHAR(50) NULL DEFAULT NULL,
[ script:vex_trucker] `name` VARCHAR(50) NOT NULL DEFAULT '' COLLATE 'utf8mb4_general_ci',
[ script:vex_trucker] `product_type` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
[ script:vex_trucker] `distance` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
[ script:vex_trucker] `valuable` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
[ script:vex_trucker] `fragile` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
[ script:vex_trucker] `fast` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
[ script:vex_trucker] `price` INT(10) UNSIGNED NOT NULL DEFAULT '0',
[ script:vex_trucker] `price_per_km` INT(10) UNSIGNED NOT NULL DEFAULT '0',
[ script:vex_trucker] `img` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci',
[ script:vex_trucker] PRIMARY KEY (`driver_id`) USING BTREE
[ script:vex_trucker] )
[ script:vex_trucker] COLLATE='utf8mb4_general_ci'
[ script:vex_trucker] ENGINE=InnoDB
[ script:vex_trucker] ;
[ script:vex_trucker]
[ script:vex_trucker] CREATE TABLE IF NOT EXISTS `trucker_loans` (
[ script:vex_trucker] `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
[ script:vex_trucker] `user_id` VARCHAR(50) NOT NULL,
[ script:vex_trucker] `loan` INT(10) UNSIGNED NOT NULL DEFAULT '0',
[ script:vex_trucker] `remaining_amount` INT(10) UNSIGNED NOT NULL DEFAULT '0',
[ script:vex_trucker] `day_cost` INT(10) UNSIGNED NOT NULL DEFAULT '0',
[ script:vex_trucker] `taxes_on_day` INT(10) UNSIGNED NOT NULL DEFAULT '0',
[ script:vex_trucker] `timer` INT(10) UNSIGNED NOT NULL DEFAULT '0',
[ script:vex_trucker] PRIMARY KEY (`id`) USING BTREE
[ script:vex_trucker] )
[ script:vex_trucker] COLLATE='utf8mb4_general_ci'
[ script:vex_trucker] ENGINE=InnoDB
[ script:vex_trucker] ;
[ script:vex_trucker]
[ script:vex_trucker] CREATE TABLE IF NOT EXISTS `trucker_trucks` (
[ script:vex_trucker] `truck_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
[ script:vex_trucker] `user_id` VARCHAR(50) NOT NULL,
[ script:vex_trucker] `truck_name` VARCHAR(50) NOT NULL COLLATE 'utf8mb4_general_ci',
[ script:vex_trucker] `driver` INT(10) UNSIGNED NULL DEFAULT NULL,
[ script:vex_trucker] `body` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '1000',
[ script:vex_trucker] `engine` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '1000',
[ script:vex_trucker] `transmission` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '1000',
[ script:vex_trucker] `wheels` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '1000',
[ script:vex_trucker] PRIMARY KEY (`truck_id`) USING BTREE
[ script:vex_trucker] )
[ script:vex_trucker] COLLATE='utf8mb4_general_ci'
[ script:vex_trucker] ENGINE=InnoDB
[ script:vex_trucker] ;
[ script:vex_trucker]
[ script:vex_trucker] CREATE TABLE IF NOT EXISTS `trucker_users` (
[ script:vex_trucker] `user_id` VARCHAR(50) NOT NULL,
[ script:vex_trucker] `money` INT(10) UNSIGNED NOT NULL DEFAULT '0',
[ script:vex_trucker] `total_earned` INT(10) UNSIGNED NOT NULL DEFAULT '0',
[ script:vex_trucker] `finished_deliveries` INT(10) UNSIGNED NOT NULL DEFAULT '0',
[ script:vex_trucker] `exp` INT(10) UNSIGNED NOT NULL DEFAULT '0',
[ script:vex_trucker] `traveled_distance` DOUBLE UNSIGNED NOT NULL DEFAULT '0',
[ script:vex_trucker] `skill_points` INT(10) UNSIGNED NOT NULL DEFAULT '0',
[ script:vex_trucker] `product_type` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
[ script:vex_trucker] `distance` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
[ script:vex_trucker] `valuable` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
[ script:vex_trucker] `fragile` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
[ script:vex_trucker] `fast` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
[ script:vex_trucker] `loan_notify` BIT(1) NOT NULL DEFAULT b'0',
[ script:vex_trucker] PRIMARY KEY (`user_id`) USING BTREE
[ script:vex_trucker] )
[ script:vex_trucker] COLLATE='utf8mb4_general_ci'
[ script:vex_trucker] ENGINE=InnoDB
[ script:vex_trucker] ;
[ script:vex_trucker]
[ script:vex_trucker]
[ script:vex_trucker] []
[ script:vex_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:vex_trucker] `driver_id` INT(10) UNSIGNE...' at line 19
[ script:vex_trucker] > fn (@vex_trucker/server.lua:15)
[ script:vex_trucker] > logError (@oxmysql/dist/build.js:26282)
[ script:vex_trucker] > rawQuery (@oxmysql/dist/build.js:26458)
[ script:vex_trucker] > processTicksAndRejections (node:internal/process/task_queues:96)
[ script:vex_trucker] SCRIPT ERROR: @vex_trucker/server.lua:197: vex_trucker was unable to execute a query!
[ script:vex_trucker] Query: SELECT COUNT(driver_id) as qtd FROM trucker_drivers WHERE user_id IS NULL
[ script:vex_trucker] []
[ script:vex_trucker] Unknown column 'user_id' in 'where clause'
[ script:vex_trucker] > fn (@vex_trucker/server.lua:197)
[ script:vex_trucker] > logError (@oxmysql/dist/build.js:26282)
[ script:vex_trucker] > rawQuery (@oxmysql/dist/build.js:26458)
[ script:vex_trucker] > processTicksAndRejections (node:internal/process/task_queues:96)
[ script:vex_trucker] SCRIPT ERROR: @vex_trucker/server.lua:230: vex_trucker was unable to execute a query!
[ script:vex_trucker] Query: SELECT d.driver_id, d.user_id, d.name, d.product_type, d.distance, d.valuable, d.fragile, d.fast, d.price, d.price_per_km
[ script:vex_trucker] FROM trucker_trucks t
[ script:vex_trucker] INNER JOIN trucker_drivers d ON (t.driver = d.driver_id)
[ script:vex_trucker] WHERE t.driver <> 0 AND t.driver IS NOT NULL
[ script:vex_trucker] []
[ script:vex_trucker] Unknown column 'd.user_id' in 'field list'
[ script:vex_trucker] > fn (@vex_trucker/server.lua:230)
[ script:vex_trucker] > logError (@oxmysql/dist/build.js:26282)
[ script:vex_trucker] > rawQuery (@oxmysql/dist/build.js:26458)
[ script:vex_trucker] > processTicksAndRejections (node:internal/process/task_queues:96)
[ script:vex_trucker] SCRIPT ERROR: @vex_trucker/server.lua:270: attempt to index a nil value (global 'ESX')
[ script:vex_trucker] > fn (@vex_trucker/server.lua:270)
[ script:vex_trucker] > rawQuery (@oxmysql/dist/build.js:26449)
[ script:vex_trucker] > processTicksAndRejections (node:internal/process/task_queues:96)
[ script:vex_trucker] SCRIPT ERROR: @vex_trucker/server.lua:150: attempt to index a nil value (global 'ESX')
[ script:vex_trucker] > fn (@vex_trucker/server.lua:150)
[ script:vex_trucker] > rawQuery (@oxmysql/dist/build.js:26449)
[ script:vex_trucker] > processTicksAndRejections (node:internal/process/task_queues:96)