ESX_shops no database

[Richuncledump]

I cannot find the shops database. I’ve run the sql file and no shops table appears in my database. What am I doing wrong?

[Jamie32]

Why are you using esx_shops there are much better system out today…

USE `essentialmode`;

CREATE TABLE `shops` (
	`id` int(11) NOT NULL AUTO_INCREMENT,
	`store` varchar(100) NOT NULL,
	`item` varchar(100) NOT NULL,
	`price` int(11) NOT NULL,

	PRIMARY KEY (`id`)
);

INSERT INTO `shops` (store, item, price) VALUES
	('TwentyFourSeven','bread',30),
	('TwentyFourSeven','water',15),
	('RobsLiquor','bread',30),
	('RobsLiquor','water',15),
	('LTDgasoline','bread',30),
	('LTDgasoline','water',15)
;

[Richuncledump]

can you point me in the right direction then? I had figured things out after making this post I just needed to refresh heidisql…lmao but if I should not be using esx_shops what should I be using then? Is there a free resource I should be able to find?

[Richuncledump]

So I switched to esx_supermarket and I’m having a hard time adding items. Nothing I try seems to work. I’ve added items to database and still they don’t appear in the shops.

[SQLabs]

ESX shops uses the config.lua, any resource trying to use SQL for it wont work in any esx version made in the past 2-3 years

Mycroft,
ESX-Framework Director

[Richuncledump]

I’ve got the store working now my issue is with disc-inventory not using items. can’t figure out why. trying to find a good inventory that has a hotbar / fast items. Any recommendations?