(UPDATE-11/12/2019) [Release] [ESX] Shops with bars (V.1.7) (OLD ESX)

i get this error and my shops are empty can anyone help

i have error
when i buy item from shop… its not showing in my inventory

Hello, I got ESX with the menu default, list and dialog… I recently installed esx shops, basicneeds and optialneeds but the problem is I can buy bread but I cant eat/use it. Just like cigarettes, water etc. And I can’t give money to someone through the inventory. @David_Carneiro

*Sorry for my bad english ;p

1 Like

I’m trying to add bandages to the store. I’ve put it in the database in shops. Doesn’t it just load from that? Its not appearing in the shop

1 Like

That bug must be from esx_menu then :frowning_face:

You also need to add to basic needs code or it wont work

For those that want a github version of this script, here it is, if you modify something please give some type of credit

NEW UPDATE is out boys, nightclubs added to the shops.

Great update :smiley:

1 Like

how to add the emoji’s ? im using zaphosting phpmyadmin database and everytime when i try to add :hamburger: before the items DB hamburger Label it returns as ? Hamburger.
Tried spaces in between and without capital letters and restarted server and client couple of times but nothing changes.

I am having a issue in my server were the shops dont have anything for some people they have to re log to see the things in the shops it is random shops that do it one time it will work the next it will not does any one know how to fix this?

1 Like

There is a issue with the included SQL for shops

ID 44 is duplicated

INSERT INTO `shops` (id, store, item, price) VALUES
(1, 'TwentyFourSeven', 'bread', 30),
(2, 'TwentyFourSeven', 'water', 15),
(3, 'RobsLiquor', 'bread', 30),
(4, 'RobsLiquor', 'water', 15),
(5, 'LTDgasoline', 'bread', 30),
(6, 'LTDgasoline', 'water', 15),
(7, 'TwentyFourSeven', 'chocolate', 10),
(8, 'RobsLiquor', 'chocolate', 10),
(9, 'LTDgasoline', 'chocolate', 10),
(10, 'TwentyFourSeven', 'sandwich', 10),
(11, 'RobsLiquor', 'sandwich', 10),
(12, 'LTDgasoline', 'sandwich', 10),
(13, 'TwentyFourSeven', 'hamburger', 15),
(14, 'RobsLiquor', 'hamburger', 15),
(15, 'LTDgasoline', 'hamburger', 15),
(16, 'TwentyFourSeven', 'cupcake', 10),
(17, 'RobsLiquor', 'cupcake', 10),
(18, 'LTDgasoline', 'cupcake', 10),
(19, 'TwentyFourSeven', 'cocacola', 15),
(20, 'RobsLiquor', 'cocacola', 15),
(21, 'LTDgasoline', 'cocacola', 15),
(22, 'TwentyFourSeven', 'icetea', 10),
(23, 'RobsLiquor', 'icetea', 10),
(24, 'LTDgasoline', 'icetea', 10),
(25, 'TwentyFourSeven', 'coffe', 10),
(26, 'RobsLiquor', 'coffe', 10),
(27, 'LTDgasoline', 'coffe', 10),
(28, 'TwentyFourSeven', 'milk', 15),
(29, 'RobsLiquor', 'milk', 15),
(30, 'LTDgasoline', 'milk', 15),
(31, 'RobsLiquor', 'cigarett', 15),
(32, 'RobsLiquor', 'lighter', 10),
(33, 'LTDgasoline', 'cigarett', 15),
(34, 'LTDgasoline', 'lighter', 10),
(35, 'TwentyFourSeven', 'cigarett', 15),
(36, 'TwentyFourSeven', 'lighter', 10),
(37, 'Bar', 'beer', 30),
(38, 'Bar', 'wine', 25),
(39, 'Bar', 'vodka', 60),
(40, 'Bar', 'tequila', 40),
(41, 'Bar', 'whisky', 50),
(42, 'Bar', 'cigarett', 30),
(43, 'Bar', 'lighter', 25),
(44, 'Disco', 'beer', 30),
(45, 'Disco', 'wine', 25),
(46, 'Disco', 'vodka', 60),
(47, 'Disco', 'tequila', 40),
(48, 'Disco', 'whisky', 50),
(49, 'Disco', 'cigarett', 30),
(50, 'Disco', 'lighter', 25)
;

this is the fixed SQL

2 Likes

Same issue as many other users. Your header shows up for the shops, but no items show up. Yes I already looked for tobacco in the config. It’s not there…

Here is the error being given:

Error resuming coroutine: client/main.lua:45: attempt to index a nil value (field 'Math')
stack traceback:
    client/main.lua:45: in function 'OpenShopMenu'
    client/main.lua:174: in function <client/main.lua:165>
1 Like

Using the latest github update instead of the 1.5 update changes the error entirely to what @LiveWithRusty is experiencing. Guess we will see if downgrading fixes the errors.

1 Like

Hello guys i have a problem when i come in the store. I see the marker but when i come there i cant open the marker? with any key? he say nothing i have all of the scripts…

can anyone help me?

1 Like

If you press " E " and nothing shows up its because you messed something on the database, be careful with the database, because if one thing goes wrong nothing works, same goes to basicneeds sir! xD

@Cowboy_Gaming
@mrdigital01
@x0Z3ro0x

I don’t know what was wrong, my players never had that type of problem, but I’ll soon launch a new update with more items for the NightClubs and a couple of extra things, I’ll run some tests for those errors!

thanks for the feedback boys! xD

SQL UPDATED, thanks @mrdigital01
GitHub updated

No worries, was just checking out your script because it saves A LOT of time. Thank you for your hard work. We unfortunately had to put in a default esx_shops and start adding to it for our needs. Which is no problem just takes longer :slight_smile:

I will be happy to test anything you need, however following your instructions to a T and NOT modifying anything resulting in the errors above. Best of luck on your script!

1 Like

Srry my fault i main when u stay in the marker nothing happens no message that say press e to open menu or something can you help with that?

1 Like

Theres another SQL I forgot to post buddy.

It’s in the items.sql your missing two columns the limit and can_remove

You have those filled out for each item but dont have the columns defined at the top

1 Like