How do I add items to my phpMyAdmin Datatable

FiveM Server Development ES/ESX
1

In the instructions for esx_illegal_drugs it says to import esx_illgeal_drugs.sql into my database upon doing so I get and error

image
image1919×873 52.7 KB

here is the files text

USE essentialmode;

INSERT INTO items (name, label, limit) VALUES
(‘weed’, ‘Weed (1G)’, 420),
(‘weed_pooch’, ‘Bag of weed (28G)’, 15),
(‘coke’, ‘Coke (1G)’, 420),
(‘coke_pooch’, ‘Bag of coke (28G)’, 15),
(‘meth’, ‘Meth (1G)’, 420),
(‘meth_pooch’, ‘Bag of meth (28G)’, 15),
(‘opium’, ‘Opium (1G)’, 420),
(‘opium_pooch’, ‘Bag of opium (28G)’, 15)
;

2

Remove USE essentialmode, that database doesn’t exists at Zap

3

can you make a new pastebin for me i tried to remove it still nothing heres my paste
https://pastebin.com/bH3jGn81

4

image

image
image654×839 73.6 KB

5

It lists the issue right there, the items, or at least some of them, are already in your database.

1 Like
6

but where?

7

Alright so i figured it out it was just a bug the item is actually there but its not showing on the table. Apparently this wasent the problem why I still cant collect drugs as a unemployed. hmmm

8

INSERT INTO items (name, label, limit) VALUES
(‘weed’, ‘Weed (1G)’, 420),
(‘weed_pooch’, ‘Bag of weed (28G)’, 15),
(‘coke’, ‘Coke (1G)’, 420),
(‘coke_pooch’, ‘Bag of coke (28G)’, 15),
(‘meth’, ‘Meth (1G)’, 420),
(‘meth_pooch’, ‘Bag of meth (28G)’, 15),
(‘opium’, ‘Opium (1G)’, 420),
(‘opium_pooch’, ‘Bag of opium (28G)’, 15)

9

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.