[RELEASE] renzu_vehicleshop | Advanced Vehicle Shop

@pirot
It looks like you are not using the latest version.
Line does not matched to latest branch.

@Raul_Rojas

Copy the config for police job

And change it accordingly to your needs
Job, coords and the model cars

2 Likes

Is there a way to stop the radio while watching the cars? :slightly_smiling_face:

sure i will make a function for that.

1 Like

also after I added the show room display cars extension I have to restart the folder for the cars to appear, do you know if there is a way to prevent that? appreciate your help :slight_smile:

1 Like

hey renzu i installed this and it wont save the cars to owned vehicles its asking for tables it never created and the ones i made dont suffice i guess

ive tried so many different things including reinstalling it but it still wont work what am i missing why doesnt it just work as far as i know everything is up to date

1 Like

Your missing a job column from sql.

@woodit
Can you explain more?

Ofcourse you need to restart the script to make changes? :thinking:

I mean evertime I start the server after everthing is started then I have to restart the “renzu_vehicleshop” folder to make the display cars show in the shop (the parked cars at the shop)

1 Like

what column? in which area of the database cause ive gone through everything it uses

1 Like

somehow i cant repro your report,

“upon player loaded, the cars at showroom does not spawned right?”
my side does spawned them :thinking:

@Whiskey99
This must be a Mysql version issue.
can you put a NULL value to Job column?

1 Like

that didnt fix it and im running mariadb 10.6 so its up to date i think

drop the job column

reimport this

ALTER TABLE owned_vehicles

ADD job varchar(32) NULL DEFAULT ‘civ’;

This cause was your Mysql sql_mode is strict mode.
i will update the sql files in github to prevent this error :cheese:

1 Like

ty renzu

2 Likes

it said it couldnt do civ cause it wasnt recognized by default or something so i tried to make it myself and it still didnt work

and how would i get out of strict mode?

p.s. ive just started learning how to properly code and will be going to school for it so any advice and help is graciously accepted

what server error it produce this time?
your sql columns looks fine now with job.
try removing null

you dont need to turn it off its a default for securities.

but @ my.ini find sql_mode
i suggest not to edit it, if you insert wrong syntax your mysql server wont start at all

1 Like

it was the same error i can ss it if you want

1 Like

change the length of

owned_vehicles.owner from 22 to 64

this seems a default length for steam ID not licensed ID from esx_vehicleshop

image

2 Likes