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

Not work at ESX Legacy



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

it isnt available anymore or?[/video]

thanks for your work continue

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

Does this work for qb? and the link is dead :(

thank u so much bro

Great work on the leak, much appreciated!

wow thank yu <3 man

:confused: SQL needed ... why dont but in it ?

‼️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)[/txadmin]

SQL is in the server side. It will automatically be executed.

Very nice share, thank you