Script Buy and manage your own trucker logistics

[sabadell]

where is the sql? cant find it

 

[ALEN TL]

where is the sql? cant find it

Automatically gets executed. It is in the server side of the script

 

[prolog]

thanks for sharing

 

[Eranio]

no income from Hired drivers

 

[ivan2381997]

hello am getting error,something about try compare number with nil,am using esx legacy,oxmysql

 

[Rivvy81]

Fixed menu not opening. Added english language in the menu, the html side. Added the required vehicles so as to make it work.
*** Hidden text: cannot be quoted. ***

Both the script and the vehicles are added here so you can access it.

Nice

 

[Rivvy81]

Fixed menu not opening. Added english language in the menu, the html side. Added the required vehicles so as to make it work.
*** Hidden text: cannot be quoted. ***

Both the script and the vehicles are added here so you can access it.

Nice.

 

[nukepug]

Hey,

im trying to install this. The server side tried to instal the Sql but it got an error. So i did i manually en crossed it out in server side. But i dont got the menu to work in this version. If i use esx_vex_driver ican open the menu, add money, buy trucks etc

it gives me this when i do it on auto
[ scriptxmysql] SCRIPT ERROR in promise (unhandled): Error: esx_vex_trucker was unable to execute a query!
[ scriptxmysql] 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` (

But i cant start missions it gives me this error

[ script:es_extended] [INFO] Player "Nuke Z" has connected to the server. ID: 1
[script:esx_vex_truck] SCRIPT ERROR: @esx_vex_trucker/server.lua:361: attempt to compare nil with number
[script:esx_vex_truck] > handler (@esx_vex_trucker/server.lua:361)
[script:esx_vex_truck] > query_default (@oxmysql/dist/server/build.js:16108)
[script:esx_vex_truck] > processTicksAndRejections (node:internal/process/task_queues:96)

it refers to this

[script:esx_vex_truck] > handler (@esx_vex_trucker/server.lua:361)
if tonumber(query_users[1].fragile) >= tonumber(query[1].fragile) then

[script:esx_vex_truck] > query_default (@oxmysql/dist/server/build.js:16108)
// src/server/db/query.js
var query_default;
var init_query = __esm({
"src/server/db/query.js"() {
init_config();
init_utils();
init_pool();
query_default = async (type, invokingResource, query, parameters, cb) => {
if (!isReady)
serverReady();
let result, executionTime;
try {
[query, parameters, cb] = parseArguments(invokingResource, query, parameters, cb);
scheduleTick();
[result, _, executionTime] = await pool_default.query(query, parameters);
if (executionTime >= mysql_slow_query_warning || mysql_debug)
console.log(`^3[${mysql_debug ? "DEBUG" : "WARNING"}] ${invokingResource} took ${executionTime}ms to execute a query!
${query} ${JSON.stringify(parameters)}^0`);
} catch (err) {
throw new Error(`${invokingResource} was unable to execute a query!
${err.message}
${err.sql || `${query} ${JSON.stringify(parameters)}`}`);
}
if (cb)
cb(response(type, result)); -----------------------------------------------------------------------THIS LINE
else
return response(type, result);
};
}
});


FIX only works with MYSQL not OXY

 

[H3XX1TT]

my drivers not working and earn money for the business....

 

[Danascapone]

Automatically gets executed. It is in the server side of the script

mate, i just fucking got a problem, before its automatically executed in DB sql. Now i fucking get error CREATE TABLE IF NOT EXISTS all tables shows in console, why not they now automatically executed in db?? can you explain me please?

 

[Danascapone]

SCRIPT ERROR in promise (unhandled): Error: esx_vex_trucker was unable to execute a query!
[ scriptxmysql] 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` (
[ scriptxmysql] `driver_id` INT(10) UNSIGNE...' at line 19
[ scriptxmysql] CREATE TABLE IF NOT EXISTS `trucker_available_contracts` (
[ scriptxmysql] `contract_id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
[ scriptxmysql] `contract_type` BIT(1) NOT NULL DEFAULT b'0',
[ scriptxmysql] `contract_name` VARCHAR(50) NOT NULL DEFAULT '' COLLATE 'utf8mb4_general_ci',
[ scriptxmysql] `coords_index` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',
[ scriptxmysql] `price_per_km` INT(10) UNSIGNED NOT NULL DEFAULT '0',
[ scriptxmysql] `cargo_type` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
[ scriptxmysql] `fragile` BIT(1) NOT NULL DEFAULT b'0',
[ scriptxmysql] `valuable` BIT(1) NOT NULL DEFAULT b'0',
[ scriptxmysql] `fast` BIT(1) NOT NULL DEFAULT b'0',
[ scriptxmysql] `truck` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci',
[ scriptxmysql] `trailer` VARCHAR(50) NOT NULL COLLATE 'utf8mb4_general_ci',
[ scriptxmysql] PRIMARY KEY (`contract_id`) USING BTREE
[ scriptxmysql] )
[ scriptxmysql] COLLATE='utf8mb4_general_ci'
[ scriptxmysql] ENGINE=InnoDB
[ scriptxmysql] ;
[ scriptxmysql]
[ scriptxmysql] CREATE TABLE IF NOT EXISTS `trucker_drivers` (
[ scriptxmysql] `driver_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
[ scriptxmysql] `user_id` VARCHAR(50) NULL DEFAULT NULL,
[ scriptxmysql] `name` VARCHAR(50) NOT NULL DEFAULT '' COLLATE 'utf8mb4_general_ci',
[ scriptxmysql] `product_type` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
[ scriptxmysql] `distance` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
[ scriptxmysql] `valuable` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
[ scriptxmysql] `fragile` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
[ scriptxmysql] `fast` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
[ scriptxmysql] `price` INT(10) UNSIGNED NOT NULL DEFAULT '0',
[ scriptxmysql] `price_per_km` INT(10) UNSIGNED NOT NULL DEFAULT '0',
[ scriptxmysql] `img` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci',
[ scriptxmysql] PRIMARY KEY (`driver_id`) USING BTREE
[ scriptxmysql] )
[ scriptxmysql] COLLATE='utf8mb4_general_ci'
[ scriptxmysql] ENGINE=InnoDB
[ scriptxmysql] ;
[ scriptxmysql]
[ scriptxmysql] CREATE TABLE IF NOT EXISTS `trucker_loans` (
[ scriptxmysql] `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
[ scriptxmysql] `user_id` VARCHAR(50) NOT NULL,
[ scriptxmysql] `loan` INT(10) UNSIGNED NOT NULL DEFAULT '0',
[ scriptxmysql] `remaining_amount` INT(10) UNSIGNED NOT NULL DEFAULT '0',
[ scriptxmysql] `day_cost` INT(10) UNSIGNED NOT NULL DEFAULT '0',
[ scriptxmysql] `taxes_on_day` INT(10) UNSIGNED NOT NULL DEFAULT '0',
[ scriptxmysql] `timer` INT(10) UNSIGNED NOT NULL DEFAULT '0',
[ scriptxmysql] PRIMARY KEY (`id`) USING BTREE
[ scriptxmysql] )
[ scriptxmysql] COLLATE='utf8mb4_general_ci'
[ scriptxmysql] ENGINE=InnoDB
[ scriptxmysql] ;
[ scriptxmysql]
[ scriptxmysql] CREATE TABLE IF NOT EXISTS `trucker_trucks` (
[ scriptxmysql] `truck_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
[ scriptxmysql] `user_id` VARCHAR(50) NOT NULL,
[ scriptxmysql] `truck_name` VARCHAR(50) NOT NULL COLLATE 'utf8mb4_general_ci',
[ scriptxmysql] `driver` INT(10) UNSIGNED NULL DEFAULT NULL,
[ scriptxmysql] `body` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '1000',
[ scriptxmysql] `engine` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '1000',
[ scriptxmysql] `transmission` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '1000',
[ scriptxmysql] `wheels` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '1000',
[ scriptxmysql] PRIMARY KEY (`truck_id`) USING BTREE
[ scriptxmysql] )
[ scriptxmysql] COLLATE='utf8mb4_general_ci'
[ scriptxmysql] ENGINE=InnoDB
[ scriptxmysql] ;
[ scriptxmysql]
[ scriptxmysql] CREATE TABLE IF NOT EXISTS `trucker_users` (
[ scriptxmysql] `user_id` VARCHAR(50) NOT NULL,
[ scriptxmysql] `money` INT(10) UNSIGNED NOT NULL DEFAULT '0',
[ scriptxmysql] `total_earned` INT(10) UNSIGNED NOT NULL DEFAULT '0',
[ scriptxmysql] `finished_deliveries` INT(10) UNSIGNED NOT NULL DEFAULT '0',
[ scriptxmysql] `exp` INT(10) UNSIGNED NOT NULL DEFAULT '0',
[ scriptxmysql] `traveled_distance` DOUBLE UNSIGNED NOT NULL DEFAULT '0',
[ scriptxmysql] `skill_points` INT(10) UNSIGNED NOT NULL DEFAULT '0',
[ scriptxmysql] `product_type` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
[ scriptxmysql] `distance` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
[ scriptxmysql] `valuable` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
[ scriptxmysql] `fragile` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
[ scriptxmysql] `fast` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
[ scriptxmysql] `loan_notify` BIT(1) NOT NULL DEFAULT b'0',
[ scriptxmysql] PRIMARY KEY (`user_id`) USING BTREE
[ scriptxmysql] )
[ scriptxmysql] COLLATE='utf8mb4_general_ci'
[ scriptxmysql] ENGINE=InnoDB
[ scriptxmysql] ;
[ scriptxmysql]
[ scriptxmysql] []
[ scriptxmysql] > <unknown> (@oxmysql/dist/build.js:21745)
[ scriptxmysql] > processTicksAndRejections (node:internal/process/task_queues:96)
[ scriptxmysql] > async rawQuery (@oxmysql/dist/build.js:21734)
[ scriptxmysql]
[ scriptxmysql] SCRIPT ERROR in promise (unhandled): Error: esx_vex_trucker was unable to execute a query!
[ scriptxmysql] Table 'esxlegacy_93b1bf.trucker_available_contracts' doesn't exist
[ scriptxmysql] SELECT COUNT(contract_id) as qtd FROM trucker_available_contracts []
[ scriptxmysql] > <unknown> (@oxmysql/dist/build.js:21745)
[ scriptxmysql] > processTicksAndRejections (node:internal/process/task_queues:96)
[ scriptxmysql] > async rawQuery (@oxmysql/dist/build.js:21734)
[ scriptxmysql]
[ scriptxmysql]
[ scriptxmysql]
[ scriptxmysql]

Hidden link for visitors, to see Log in or register now.

Clear Console Announcement

 

[LastNexus]

Thanks for the share

 

[lolkhoo123]

Fixed menu not opening. Added english language in the menu, the html side. Added the required vehicles so as to make it work.
*** Hidden text: cannot be quoted. ***

Both the script and the vehicles are added here so you can access it.

 

[MadSloth]

Fixed menu not opening. Added english language in the menu, the html side. Added the required vehicles so as to make it work.
*** Hidden text: cannot be quoted. ***

Both the script and the vehicles are added here so you can access it.

 

[Phoenix17]

Yo is there a QB Version of this?

 

[Pqviin]

Hi, cool script but i can't start a job. The live consol says:

[script:esx_vex_truck] SCRIPT ERROR: @esx_vex_trucker/server.lua:247: attempt to compare nil with number
[script:esx_vex_truck] > handler (@esx_vex_trucker/server.lua:247)
[script:esx_vex_truck] > <unknown> (@oxmysql/dist/build.js:21729)
[script:esx_vex_truck] > processTicksAndRejections (node:internal/process/task_queues:96)
[script:esx_vex_truck] > async rawQuery (@oxmysql/dist/build.js:21719)

 

[C3nSure]

Fixed menu not opening. Added english language in the menu, the html side. Added the required vehicles so as to make it work.
*** Hidden text: cannot be quoted. ***

Both the script and the vehicles are added here so you can access it.

 

[lahyene01]

Hi, cool script but i can't start a job. The live consol says:

[script:esx_vex_truck] SCRIPT ERROR: @esx_vex_trucker/server.lua:247: attempt to compare nil with number
[script:esx_vex_truck] > handler (@esx_vex_trucker/server.lua:247)
[script:esx_vex_truck] > <unknown> (@oxmysql/dist/build.js:21729)
[script:esx_vex_truck] > processTicksAndRejections (node:internal/process/task_queues:96)
[script:esx_vex_truck] > async rawQuery (@oxmysql/dist/build.js:21719)

you managed to correct this error because I have the same ... :/

 

[03357039937]

Fixed menu not opening. Added english language in the menu, the html side. Added the required vehicles so as to make it work.
*** Hidden text: cannot be quoted. ***

Both the script and the vehicles are added here so you can access it.

 

[gameadictive]

Im using the new renzu_garage main branch wich uses keys as items using ox_inventory.

Anyone have some idea about how to make that function work too in the vex_trucker script?