[Release] [ESX] Shops with bars (V.1.2) (NOT WORKING)



It does what the tittle says, it is the esx_shops it more items and the bars, it uses some extra script to make the blips on the map but that script is here too

I have this for some time now, I modified some code but everything is working fine.


  • Essentialmode 5
  • Es_extended
  • esx_status


  1. Download the file
  2. Stop the server
  3. Add all the files to [esx] folder in the resources folder
  4. Add the sql files to the database
  5. Add the 2 resource names to the server.cfg
  6. Clean the cache and start the server

This is the order how you should have your server.cfg with this scripts

start esx_status
start esx_basicneeds
start esx_shops

You have here some screenshots

Blips on the map


If you need help you have here my discord


Download here:
V.1.2esx_shops_with_bars.1.2.rar (146.8 KB)
(RECOMMENDED: Delete or clean the shops table and delete old items on items table, make sure to do a backup of those same tables)
V.1.1esx_shops_with_bars.1.1.rar (198.6 KB)
(RECOMMENDED: Delete or clean the shops table and delete old items on items table, make sure to do a backup of those same tables)
V.1.0esx_shops_with_bars.rar (196.3 KB)

*Change Log

  • V.1.1:

    • Sql files fixed.
    • Config.lua of shops fixed.
    • Lighter and Cigarett added.
    • You can only use the cigarett if you have an lighter.
  • V.1.2:

    • Now you don’t need esx_map anymore.
    • Now you don’t need esx_optionalneeds anymore.
    • Sql files once again fixed and rewrote with the new stuff.
    • Added milk wich removes the drunk effect a little bite if you drink it.
    • I have compressed the code and scripts so now only uses 2, you still need esx_status of course.


  • The Bahamamas club is closed you can use other script to get in, for example: drz_interiors

ESX Buy Food exc [HELP pls]
[Release] EssentialMode base

Did you made this? I’ve seen it on ESX Discord.


Yes, just go to #fx_scripts scroll up a little bite you will find this scripts uploaded by me


Thanks! :slight_smile:


Cant seem to get the menu to pop up. I see the marker. Tried changing the keybind still nothing.


I have the same issue.


Are there any animations/effects to the player consuming the alcohol?


@Scott_Wren @Deveraux
Do you have esx_status? If so do you have it before those 4 on the server.cfg? And check is the 4 are correct with the folder name. xD


Yes the player does the animation of drunk


Yep - I have the default optionalneeds working, just couldn’t get this one going.


Did you add the sql files from esx_shops and esx_basicneeds to the database?


Yep - I even tried yelling at my PC.


Ahahah that was a good one xD

  • Did the sql file gave any error?

  • how do you have your start order on server.cfg? (Including esx_status)


Nope, it didn’t throw any errors when linking to the DB.

Start of the list is below:

Default scripts

start mapmanager
start chat
start spawnmanager
start sessionmanager
start fivem
start hardcap
start rconlog
start baseevents
start anticheat


start mysql-async
start essentialmode
start es_admin2
start esplugin_mysql

Extended defaults

start es_extended
start scoreboard
start esx_menu_dialog
start esx_menu_default
start esx_menu_list
start esx_status
start esx_map
start esx_basicneeds
start esx_optionalneeds
start esx_shops
start esx_service
start esx_voice
start esx_identity
start esx_animations
start esx_aiomenu
start esx_moneywash


Ok the order is good
In your item table on the database do you have the items? Example: bread, water


Hello my table does not want to take utf8mb4_bin


Try this sir. Xd

-- Estrutura da tabela items

id int(11) NOT NULL,
  name varchar(255) COLLATE utf8mb4_bin NOT NULL,
  label varchar(255) COLLATE utf8mb4_bin NOT NULL,
  limit int(11) NOT NULL DEFAULT -1,
  rare int(11) NOT NULL DEFAULT 0,
  can_remove int(11) NOT NULL DEFAULT 1

-- Extraindo dados da tabela items

INSERT INTO items (id, name, label, limit, rare, can_remove) VALUES
('bread', '🍞Bread', -1, 0, 1),
('water', '💦Water', -1, 0, 1),
('wine', '🍷Wine', -1, 0, 1),
('beer', '🍺Beer', -1, 0, 1),
('vodka', '🍹Vodka', -1, 0, 1),
('chocolate', '🍫Chocolate', -1, 0, 1),
('sandwich', '🌯Sandwich', -1, 0, 1),
('hamburger', '🍔Hamburger', -1, 0, 1),
('tequila', '🍸Tequila', -1, 0, 1),
('whisky', '🥃Whisky', -1, 0, 1),
('cupcake', 'ðŸregisteredCupcake', -1, 0, 1),
('cocacola', '🥛Coca-Cola', -1, 0, 1),
('icetea', '🍶Ice-Tea', -1, 0, 1),
('redbull', '☕Coffe', -1, 0, 1);

-- Indexes for dumped tables

-- Indexes for table items

-- AUTO_INCREMENT for dumped tables

-- AUTO_INCREMENT for table items


Super this works thank you very much the friend


the basic needs bars dont showup for me and the shops when i go to them i click e and nothing happens

  • Do you have esx_status installed and starting before those 4 on server.cfg?

  • Did you add esx_shops.sql and esx_basicnneds.sql to the database?

  • Do you have everything correctlly installed? For example in the database do you have all the items?

  • Any error on console?