[RELEASE] TPRP Garages - Buy more garages, Sell garages (Essentialmode NOT esx) Formally Plysken Garages

[Rhodiniium]

Hello all!

Today i bring you a heavily HEAVILY edited version of Plysken Garages, This was a port of his Garages2 script that was made specificly for my old server, Me and Syntasu then heavily modified and edited it to work with FX and then added our own features!

What can this garage do over others?

• One public garage for all to use (limited slots)
• Ability to buy more garages with higher save slots. (configured in DB)
• Saves vehicles modifications.
• Unable to dupe cars.
• You HAVE to register your vehicle at the red blip after purcahse or you will loose your vehicle (handy if you have a licence system.)
• You cant sell your garage if your garage has a car stored.
• If you leave your car out and log off, Your car will be sent back to the public garage.

This resource for me worked brilliantly especially if your all about keeping away from ESX and vRP and want to just use essentialmode as your base.

REQUIRMENTS:

• EssentialMode
• MySQL-Async
• Other dependencies are in the files.

HOW DO I ADD CUSTOM VEHICLES?

• Go to fs_freemode/stores/vehshop.lua and add your vehicles here, Also make sure to add them to your DB aswell!

EDIT: Seen as this uses essentialmode its quite possible that it may work with ESX, Could always try but I cant promise anything.

You will notice there is 4 resources and 1 SQL file.

So please make sure you add all 3 resources to your server.cfg!!

This script comes with its own edited vehicle shop as ofcourse they all have to work in sync, Its nothing spectacular as its actually pretty old now, But wouldnt take much to liven it up.

INSTALLATION!

• Add all four resources to your server.cfg
• Add this in your users table personalvehicle varchar(55) DEFAULT NULL
• Run the SQL file provided in the download.
• Start your server and enjoy!

NOTE: I will only give very breif help with this resources installation, Just follow the installation as stated and you shouldnt have any issues.

Massive thank you to @Plysken_Rayder for origianlly making this script for my server (He gives his permission ofcourse) and also Syntasu for his godly coding skills getting this resource to where it is at now!

IMAGES:

Enjoy <3

DOWNLOADS:
fs_freemode.rar (43.5 KB)
TPRP_basemod.rar (2.7 KB)
TPRP_Garages.rar (7.5 KB)
TPRP_prefecture.rar (4.3 KB)
garages-FIX.sql (12.7 KB)

[Kalbino]

On the SQL there is no user_garage so flags error on cmd for TPRP_basemod

[Rhodiniium]

Updated the SQL redownload then try again

[Kalbino]

Very nice work keep it up buddy and love the feature where garage don’t show unless got a car and then changes colour when car is stored and charges electric cars its awesome.

[FEEL_Mods]

interesting

[FEEL_Mods]

[ERROR] [MySQL] [TPRP_prefecture] An error happens on MySQL for query “[object Object]”: ER_NO_SUCH_TABLE: Table ‘essentialmode.licences’ doesn’t exist

While i do have this table!

Also, i can’t change the vehicles in the databse, it does not read my custom vehicles.

Can you make this for the new eden_garage2 update?

[FEEL_Mods]

We really like the idea. Buying garages etc.

But we also got this error: [ERROR] [MySQL] [TPRP_prefecture] An error happens on MySQL for query “[object Object]”: ER_BAD_FIELD_ERROR: Unknown column ‘personalvehicle’ in ‘field list’

Yes, we deleted old tables and uploaded your SQL.

Not working for now

[Rhodiniium]

is personalvehicle in your users table?

Also ill update the SWL for licence now, I tried my best to pull this from my server without testing so thank you for trying it, Ill work on fix now

[Rhodiniium]

Try the new SQL added to the description

[Rhodiniium]

Also for the personalvehicle add this to your DB.

In your users table add:
personalvehicle varchar(55) DEFAULT NULL

Add it manually.

HOW DO I ADD CUSTOM VEHICLES?

• Go to fs_freemode/stores/vehshop.lua and add your vehicles here, Also make sure to add them to your DB aswell!

[FEEL_Mods]

I see :’)

You use licenCes

And ESX uses linceSes

Will this cause issues? Like for the DMVschool as example.

[Rhodiniium]

Ive not actually tried this with ESX, But it uses essentialmode so it should technicly work with it, You will just have to edit some ESX resources such as dmvschool, policejob etc to use your new DB instead! Shouldnt be too hard to get it working as it should work on a ESX base server

[FEEL_Mods]

Thanks!

But i think i will change yours because i have around 80 resources using ESX databases :’)

I did the new database injections and i do not get errors now
Ill test it out

[Rhodiniium]

Let me know how you get on, Also if your confident in making this work for ESX go ahead i can always add a ESX version in the description Im sure people would be very greatful!

[Rhodiniium]

The sql data is there in the SQL file, Make sure it correctly installed to your DB.

-- Dumping structure for table gta5_gamemode_essential.user_garage
CREATE TABLE IF NOT EXISTS `user_garage` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `identifier` varchar(255) NOT NULL,
  `garage_id` int(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=55 DEFAULT CHARSET=utf8;

[FEEL_Mods]

@Rhodiniium

CREATE TABLE IF NOT EXISTS user_garage ( id int(11) NOT NULL AUTO_INCREMENT, identifier varchar(255) NOT NULL, garage_id int(255) NOT NULL, PRIMARY KEY (id) ) ENGINE=InnoDB AUTO_INCREMENT=55 DEFAULT CHARSET=utf8;

I can buy (stock) vehicles. ← i added 100 custom cars in vehicles database and no stock cars :')

I can buy and sell a garage

But, if i want to store a vehicles got the message ‘this is not your vehicle’ so i go to the car register.
If i register my car i got this error: SCRIPT ERROR: @TPRP_prefecture/server.lua:80: attempt to index a nil value (field ‘?’)
and no registration

[Rhodiniium]

When you purchase the vehicle, on your users table does the personalvehicle chamge from vide to the name of your car?

[FEEL_Mods]

Yes, it’s Sentinel now

[Rhodiniium]

Okay try and register it see if it happens again

[Rhodiniium]

Make sure when adding custom vehicles there addes to both the vehshop.lua and the DB the exact same.

Try it stock first, And then let me know if it works Then we can go from there