CodeM mMinerjob ESX QB

[ThaC]

Preview

---

CodeM mMinerjob | discord.gg/zj3QsUfxWs | FiveM ESX QB

Tebex

---

Link

Documentation

---

mMinerjob | CodeM

---

Code is accessible	No
Subscription-based	No
Lines (approximately)	2000-3000
Requirements	ESX - QB
Support	Yes

[AiakosCodem]

Looks good

[sixtentinayt]

looking perfect

[Lucidb]

perfect

[SavanaScripts]

awesome

[Yusufkaracolak]

nice script

[Runa_and_Rebell]

There is an error with the SQL query, fix it quickly, you forgot something and your ticket system doesn’t work

CREATE TABLE IF NOT EXISTS codem_minerjob (
identifier longtext DEFAULT NULL,
name longtext DEFAULT NULL,
level int(11) DEFAULT NULL,
xp int(11) DEFAULT NULL,
gatheredOres int(11) DEFAULT NULL,
createdAt int(11) DEFAULT NULL,
totalEarnings int(11) DEFAULT NULL,
avatar longtext DEFAULT NULL,
dailyMissions longtext DEFAULT NULL,
latestWorks longtext DEFAULT NULL,
completedShipments int(11) DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

[ script:oxmysql] Unknown column ‘completedShipments’ in ‘field list’
[ script:oxmysql] Error: codem-minerjob was unable to execute a query!
[ script:oxmysql] Query: INSERT INTO codem_minerjob (identifier, xp, level, name, gatheredOres, createdAt, totalEarnings, avatar, dailyMissions, latestWorks, completedShipments) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
[ script:oxmysql] [“char1:”,0,1," “,0,1707391509,0,”“,”{"resetAt":1707477909,"data":{"process_ore":{"label":"Verarbeiten Sie mindestens 10 Erze im Verarbeitungsbereich.","header":"Mindestens 10 Erze verarbeiten","max":10,"process":0,"xp":2500},"gather_diamonds":{"label":"Sammeln Sie 10 Diamanten in verlassenen Minen","header":"Diamanten an meinem Hals","max":10,"process":0,"xp":2500},"gather_mine":{"label":"Bauen Sie mindestens 1 Mine in beliebigen Bergbaugebieten ab.","header":"Mindestens 1 Mine abbauen","max":1,"process":0,"xp":1250}}}“,”",0]

[Runa_and_Rebell]

Second mistake, people don’t get their XP written into the database, so you have to do it again

[M0s3n3]

How you solve this problem ?

[Runa_and_Rebell]

Even as it is now, it doesn’t work anyway, so people have to do it again because once you’ve completed tasks you don’t get the XP

[Runa_and_Rebell]

Unfortunately, the XP issue wasn’t resolved during the update and you still can’t get it

Another error found if you have set the ox_inventory you cannot access the trunk of the truck

[ThaC]

Problems are solved in the new update and i m sorry for that.

[Runa_and_Rebell]

What kind of esx version are you doing this on because it still doesn’t work for us, it doesn’t save it into the database and you can’t set much so that it isn’t saved

[Redenity]

Looks nice

[Otoban044]

malesef deniyorum sildim gene yükledim kazma işlemi toplama işlemi yapmıyor