Try that then sir xD
i only found this one
and this one
and this one
wich database program are you using? heidisql? phpmyadmin?
Something odd I edited the name nothing changed so I changed it back, and break, water etc is no longer usable.
1 Like
just remove the items and add them back
and you only need to change the label section, because its that one that appears on the menu
Yeah trust me I done that they are just no longer usable.
1 Like
Ahm ok? Very weird 
Yeah I figured it out, thanks anyway.
1 Like
Nice, thanks for using this
i tried renstallin evrrything seemed to work sorry for bothering
1 Like
Ok so when trying to add this to my server, after having downloaded this and not touched anything:
When trying to import the esx_basic needs sql file i get the error message
SQL query:
--
-- Indexes for dumped tables
--
--
-- Indexes for table `items`
--
ALTER TABLE `items`
ADD PRIMARY KEY (`id`);
MySQL said: Documentation
#1068 - Multiple primary key defined
when trying to import the esx_shops sql i get the error message:
SQL query:
–
– Extraindo dados da tabela shops
INSERT INTO shops (id, name, 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, ‘Bar’, ‘wine’, 50),
(8, ‘Bar’, ‘beer’, 50),
(9, ‘Bar’, ‘vodka’, 50),
(10, ‘TwentyFourSeven’, ‘chocolate’, 20),
(11, ‘RobsLiquor’, ‘chocolate’, 20),
(12, ‘LTDgasoline’, ‘chocolate’, 20),
(13, ‘TwentyFourSeven’, ‘sandwich’, 30),
(14, ‘RobsLiquor’, ‘sandwich’, 30),
(15, ‘LTDgasoline’, ‘sandwich’, 30),
(16, ‘TwentyFourSeven’, ‘hamburger’, 30),
(17, ‘RobsLiquor’, ‘hamburger’, 30),
(18, ‘LTDgasoline’, ‘hamburger’, 30),
(19, ‘Bar’, ‘tequila’, 40),
(20, ‘Bar’, ‘whisky’, 40),
(21, ‘TwentyFourSeven’, ‘cupcake’, 15),
(22, ‘RobsLiquor’, ‘cupcake’, 15),
(23, ‘LTDgasoline’, ‘cupcake’, 15),
(24, ‘TwentyFourSeven’, ‘cocacola’, 25),
(25, ‘RobsLiquor’, ‘cocacola’, 25),
(26, ‘LTDgasoline’, 'cocaco[…]
MySQL said: Documentation
#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 ‘’ at line 45
Like i said i have modified nothing, i was just trying to insert the sql files into my database. I use phpmyadmin as being apart of Zaphosting. Please help me
1 Like
This one is the sql from shops is this one that you’re having problems with sir?
The one from shops and the one from basic needs
1 Like
Did you delete the old shops table and the old items from items table?
I had, i have now done a fresh install of my game files, but i am still getting the above error messages
1 Like
Let me get home so i can help better, can you wait a few hours sir?
I am off work at 2:30est, i can be available at that time for the assistance
1 Like
V.1.2 Comming very soon with some good news and features
Stay tuned guys
**[Release] Shops with bars (V.1.2) (NEW UPDATE)
What have i added or done you ask?
Nothing too serious once again, just some improvements in the code and added a few more things
You can find the download of the new version on the post itself
- Change Log:
- 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.
Hope you like this new update
More stuff comming soon just working on other projects rn but i will be updating this, i have a few ideas for this
i downloaded the update and rebooted & joined (i use zap-hosting btw) and the shops menu showed nothing! any ideas man?
1 Like
The items are in the database base and the shops table too?
Do you have any extra items on your shops?
Check the config.lua for any unsual item that you don’t have.