Esx_weashop + clips after buying a license the weapon shop UI won't show

Lundka · June 3, 2019, 12:53pm

So basically if I go to weapon shop and press E in the marker the shop won’t show up and I have no clue what’s the problem

ZerefGG · June 3, 2019, 12:56pm

go back to the marker, press E and click F8, there must be an error, share it here

Lundka · June 3, 2019, 1:02pm

here you go

Lundka · June 3, 2019, 1:09pm

in case you need this also
main.lua (5.6 KB)

ZerefGG · June 3, 2019, 1:09pm

do you have a weashop table inside you database?
because in the line 65, there is a function that calls “items” from config.lua file.

it’s empty and i believe it gets items from the database.

you need to upload this to your database

github.com

ESX-Org/esx_weaponshop/blob/master/esx_weaponshop.sql

USE `essentialmode`;

CREATE TABLE `weashops` (
	`id` int(11) NOT NULL AUTO_INCREMENT,
	`zone` varchar(255) NOT NULL,
	`item` varchar(255) NOT NULL,
	`price` int(11) NOT NULL,

	PRIMARY KEY (`id`)
);

INSERT INTO `licenses` (`type`, `label`) VALUES
	('weapon', "Permis de port d'arme")
;

INSERT INTO `weashops` (`zone`, `item`, `price`) VALUES
	('GunShop','WEAPON_PISTOL', 300),
	('BlackWeashop','WEAPON_PISTOL', 500),
	('GunShop', 'WEAPON_FLASHLIGHT', 60),
	('BlackWeashop', 'WEAPON_FLASHLIGHT', 70),

This file has been truncated. show original

Lundka · June 3, 2019, 1:13pm

I have weapons in my database

ZerefGG · June 3, 2019, 1:15pm

what’s the table name?

Lundka · June 3, 2019, 1:16pm

weashops

ZerefGG · June 3, 2019, 1:27pm

share your config.lua file or just go and use the esx_weashop from github.

Lundka · June 3, 2019, 1:30pm

@ZerefGG okay I changed table name to weashop but now any items aren’t showing up

Lundka · June 3, 2019, 1:31pm

config.lua (1.3 KB)

ZerefGG · June 3, 2019, 1:47pm

why?, it must be weashops
just download the master version from github and it will work just fine.
https://github.com/ESX-Org/esx_weaponshop/archive/master.zip

ZerefGG · June 3, 2019, 1:49pm

wait wait wait,
the error comes from your database.
change “name” to “zone”
id, zone, item, price
instead of
id, name…

Lundka · June 4, 2019, 3:31pm

And how do I change it?

Lundka · June 4, 2019, 3:56pm

@ZerefGG

I changed column name to zone and this happened now

ZerefGG · June 4, 2019, 10:55pm

dude you changed tables and rows names why?
remove everything related to esx_weashop (database and folder) and reinstall it by following the instructions
https://github.com/ESX-Org/esx_weaponshop#installation
and everything will work fine

Lundka · June 5, 2019, 3:25pm

but there are no clips

RicardoRivera · September 4, 2020, 7:13am

I am having issues view weapons after a clean install of the resource…can anybody send me the sql for the original esx_weaponshops? for some reason my ‘weapons’ table is empty but the otheres are full. can buy guns though