lixeirocharmoso Truck Simulator (QBCORE ONLY) 1.0.0

Do some one have ESX version?

sql errors?

20 hours ago, cglover said:

sql errors?

 

there should be none but the if there are sql errors its basically the way the sql is structured if u find the esx version send me the sql file

The last version I looked at didn't work. how about this one?

/* SQL Error (1005): Can't create table `qbcoreframework_f81274`.`trucker_trucks` (errno: 150 "Foreign key constraint is incorrectly formed") */

im running up to date qbcore on build 3095

any help would be appreciated. thanks

massive SQL errors it can not excute any of the logistics for the contracts and drivers even after being imported correctly 

instead of being rude in my inbox can u guys ask for my help im currently deving my own server and balancing my work life so im busy asf not everyone is getting sql errors i will see if i can fix this issue  

NPC Drivers ARE NOT WORKING AT THE MOMENT! Please Read the description before you inbox me

getting this error when i excute into my database any help please ... SQL Error (1005): Can't create table `qbcoreframework_f81274`.`trucker_trucks` (errno: 150 "Foreign key constraint is incorrectly formed") */ 

Could anybody reupload the script without the  SQL errors?

ALTER TABLE `trucker_users` CHANGE `user_id` `user_id` VARCHAR(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL;
ALTER TABLE `trucker_party_members` CHANGE `user_id` `user_id` VARCHAR(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL;
ALTER TABLE `trucker_trucks` CHANGE `user_id` `user_id` VARCHAR(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL;
ALTER TABLE `trucker_loans` CHANGE `user_id` `user_id` VARCHAR(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL;
ALTER TABLE `trucker_drivers` CHANGE `user_id` `user_id` VARCHAR(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL;

fix sql

AddToDataBase.sql

all fix enjoy 🙂

truck_logistics.rar

Truck job doesn't show up at all

English version?

It works but won't give me the keys for the trucks!

u got this in english?

I'm fixing this for the latest QBCore, the main mechanics are working, just fixing up the missing icons/protuguese language to English on the NUI side. Will post files once done for whoever needs it for the latest QB Core.

Attached, fully re-factored code for the latest QB Core. Database re-worked, in English.

Run the database and drop the folder in your resources. You should download the original files as well to get the vehicles/trailers other that, my folder has everything else you need. Enjoy! 

truck_logistics.zip