Great job btw.
Next step should be GoPostal I guess. Animation should be picking up parcels from infront of houses
database file is wrong
Static analysis:
1 errors were found during analysis.
- Ending quote ’ was expected. (near “” at position 508)
SQL query:
INSERT INTO
job_grades(job_name,grade,name,label,salary,skin_male,skin_female) VALUES (‘brinks’, 0, ‘employee’, ‘Valores’, 200, '{“tshirt_1”:44,“torso_1”:98,“arms”:14,“pants_1”:47,“glasses_1”:0,“decals_2”:0,“hair_color_2”:0,“shoes_1”:25,“helmet_2”:2,“b_proof_1”:4,“bproof_2”:0,“shoes_2”:0,“bproof_1”:0,“hair_color_1”:0,“face”:2,“glasses_2”:0,“torso_2”:1,“shoes”:25,“hair_1”:0,“skin”:0,“sex”:0,“glasses_1”:0,“pants_2”:1,“hair_2”:0,“bproof_2”:0,“decals_1”:0,“tshirt_2”:0,“helmet_1”:10};MySQL said:
#1064 - 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 ''{"tshirt_1":44,"torso_1":98,"arms":14,"pants_1":47,"glasses_1":0,"decals_2":0,"' at line 2
here is the fixed working one
INSERT INTO
job_grades(job_name,grade,name,label,salary,skin_male,skin_female) VALUES
(‘brinks’, 0, ‘employee’, ‘Driver’, 200, ‘{“tshirt_1”:44,“torso_1”:98,“arms”:14,“pants_1”:47,“glasses_1”:0,“decals_2”:0,“hair_color_2”:0,“shoes_1”:25,“helmet_2”:2,“b_proof_1”:4,“bproof_2”:0,“shoes_2”:0,“bproof_1”:0,“hair_color_1”:0,“face”:2,“glasses_2”:0,“torso_2”:1,“shoes”:25,“hair_1”:0,“skin”:0,“sex”:0,“glasses_1”:0,“pants_2”:1,“hair_2”:0,“bproof_2”:0,“decals_1”:0,“tshirt_2”:0,“helmet_1”:10}’, ‘{}’);
even your fix for the sql is giving same error
Preformatted text``INSERT INTO job_grades (id, job_name, grade, name, label, salary, skin_male, skin_female) VALUES ('','brinks', '0', 'employee', 'Employee', '200', '{“tshirt_1”:44,“torso_1”:98,“arms”:14,“pants_1”:47,“glasses_1”:0,“decals_2”:0,“hair_color_2”:0,“shoes_1”:25,“helmet_2”:2,“b_proof_1”:4,“bproof_2”:0,“shoes_2”:0,“bproof_1”:0,“hair_color_1”:0,“face”:2,“glasses_2”:0,“torso_2”:1,“shoes”:25,“hair_1”:0,“skin”:0,“sex”:0,“glasses_1”:0,“pants_2”:1,“hair_2”:0,“bproof_2”:0,“decals_1”:0,“tshirt_2”:0,“helmet_1”:10}', '{“tshirt_1”:44,“torso_1”:98,“arms”:14,“pants_1”:47,“glasses_1”:0,“decals_2”:0,“hair_color_2”:0,“shoes_1”:25,“helmet_2”:2,“b_proof_1”:4,“bproof_2”:0,“shoes_2”:0,“bproof_1”:0,“hair_color_1”:0,“face”:2,“glasses_2”:0,“torso_2”:1,“shoes”:25,“hair_1”:0,“skin”:0,“sex”:0,“glasses_1”:0,“pants_2”:1,“hair_2”:0,“bproof_2”:0,“decals_1”:0,“tshirt_2”:0,“helmet_1”:10}')``Preformatted text
Correct One
I have a bug, if you press E as you are exiting your truck at the job the cart works and you can pick up the money bag but no text shows up on the back of the truck. so the job cannot be completed
https://plays.tv/video/5d0dbd365bc72472e2/pressing-e-whilst-getting-out-bug
OK installed it on local.
Can anyone send me the resource folder to stream the map ? I’ve tried it but doesn’t work at all.
Dont press E while you exit the truck then LOL Its the same as the old Garbage code nothing i can do.
Actually on line 619 change the false to true and that should get even if you are leaving the truck when you hit E.
Thank you i will do that for the garbage code aswell
Credit to SpikE_Odets on the garbage v2 thread for that 
Anyone please ?
Thanks dude.
Hello friend, could you please explain to me better what I should do with the YMAP file?
I have the following issues:
I did not see the “carts”, my first mission was on the bank of the square, I put the truck on the yellow marker, I pressed “E”, the message was shown to look for the cart to collect the money, I got off the truck, to the safe and found nothing.
The SQL file is incomplete, it’s missing the value of the female skin, this one I was able to correct, I just added the missing values.
Could you help me with what to do with this YMAP file, and with the carts?
I would suggest the author of this instead of using ymap to put in the carts… just update the script to have the script spawn the cart at the location the are driving to. This would solve the issue of having to use a ymap to add in the objects.
in the config for each stop… just add in a pos to spawn the cart. Then when they get say 150m from the destination - spawn the cart - set as mission entity - freeze the entity so none can move it and your set. Once mission is done… you set the object as nolongerneeded and when they drive away it will despawn as they get out of range.
SpikE
1 Like
Inside your folder esx_brinksjob, create a new folder called stream. Then move Bankprops23.ymap into that folder, and it should work.
1 Like