lungomartino
Silver Elite
fix sql fileds in players table...
This platform and community fully complies with the Digital Millennium Copyright Act (DMCA) and international copyright laws. We take all copyright protection seriously.
If you believe a posted item belongs to you or violates your copyright, you may file a DMCA takedown request through our official channels. Upon receiving a valid claim, the infringing content will be removed within 24 hours.
Thanks, you're greatCREATE TABLE `players` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`citizenid` VARCHAR(255) NOT NULL COLLATE 'utf8mb3_general_ci',
`cid` INT(11) NULL DEFAULT NULL,
`active` INT(11) NULL DEFAULT NULL,
`steam` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
`license` VARCHAR(255) NOT NULL COLLATE 'utf8mb3_general_ci',
`name` VARCHAR(255) NOT NULL COLLATE 'utf8mb3_general_ci',
`money` TEXT NOT NULL COLLATE 'utf8mb3_general_ci',
`paycheck` INT(11) NOT NULL DEFAULT '0',
`charinfo` TEXT NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
`job` TEXT NOT NULL COLLATE 'utf8mb3_general_ci',
`gang` TEXT NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
`position` TEXT NOT NULL COLLATE 'utf8mb3_general_ci',
`metadata` TEXT NOT NULL COLLATE 'utf8mb3_general_ci',
`inventory` LONGTEXT NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
`last_updated` TIMESTAMP NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
`skin` LONGTEXT NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
`luckywheel_spins` VARCHAR(1) NULL DEFAULT '1' COLLATE 'utf8mb3_general_ci',
`credits` INT(11) NOT NULL DEFAULT '0',
`tasks` LONGTEXT NOT NULL DEFAULT '' COLLATE 'utf8mb4_bin',
`tasks_completed` LONGTEXT NOT NULL DEFAULT '' COLLATE 'utf8mb4_bin',
`winnings` LONGTEXT NOT NULL DEFAULT '' COLLATE 'utf8mb4_bin',
`deleted` INT(11) NULL DEFAULT '0',
`pp` LONGTEXT NULL DEFAULT '' COLLATE 'utf8mb3_general_ci',
`policemdtinfo` LONGTEXT NULL DEFAULT '' COLLATE 'utf8mb3_general_ci',
`tags` LONGTEXT NULL DEFAULT '' COLLATE 'utf8mb3_general_ci',
`gallery` LONGTEXT NULL DEFAULT '' COLLATE 'utf8mb3_general_ci',
`crafting_level` INT(11) NULL DEFAULT '0',
`phonePos` TEXT NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
`spotify` TEXT NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
`ringtone` TEXT NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
`first_screen_showed` INT(11) NULL DEFAULT NULL,
`electrocourses` INT(11) NULL DEFAULT '0',
`inside` VARCHAR(100) NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
`hasvoted` TINYINT(4) NULL DEFAULT '0',
`disabled` TINYINT(1) NULL DEFAULT '0',
`tattoos` LONGTEXT NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
PRIMARY KEY (`citizenid`) USING BTREE,
INDEX `id` (`id`) USING BTREE,
INDEX `last_updated` (`last_updated`) USING BTREE,
INDEX `license` (`license`) USING BTREE
)
COLLATE='utf8mb3_general_ci'
ENGINE=InnoDB
AUTO_INCREMENT=4093
;
I have a different problem with the Uwu Burger Shot. I can't do anything with food or drink. I don't know why.does anyone fixed this ?
problem whit outfits in apartman and command /outfits
TriggerEvent('nc-clothingutfits', true)???
can you sent me the fixed qb-inventory forif you want download correct qb-inventory from me...you can write me dm
How can I get an interface like this, everyone?
View attachment 41238
# Thank you for purchasing nc-clothing we hope you enjoy it took alot of time and if you have any questions feel free to reach out to me anytime <3
# Important Notice !!!
You **MUST** ensure to modify any instance calling the "qb-clothing:client:loadPlayerClothing" function. Make sure to provide a **CID** (Client ID) and **character model** to load. Use this to load the given CID clothing !
Example :
local PlayerData = QBCore.Functions.GetPlayerData()
local cid = PlayerData.cid
local charPed = PlayerPedId()
TriggerEvent('qb-clothing:client:loadPlayerClothing', cid, charPed)
# Please add this to your server/resource.cfg
ensure nc-polyzone
ensure nc-focusmanager
ensure nc-clothing
ensure nc-outfits
Ple.......
Dos anybody have newest update for NCHub V3
.. nic
Legend!CREATE TABLE `players` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`citizenid` VARCHAR(255) NOT NULL COLLATE 'utf8mb3_general_ci',
`cid` INT(11) NULL DEFAULT NULL,
`active` INT(11) NULL DEFAULT NULL,
`steam` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
`license` VARCHAR(255) NOT NULL COLLATE 'utf8mb3_general_ci',
`name` VARCHAR(255) NOT NULL COLLATE 'utf8mb3_general_ci',
`money` TEXT NOT NULL COLLATE 'utf8mb3_general_ci',
`paycheck` INT(11) NOT NULL DEFAULT '0',
`charinfo` TEXT NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
`job` TEXT NOT NULL COLLATE 'utf8mb3_general_ci',
`gang` TEXT NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
`position` TEXT NOT NULL COLLATE 'utf8mb3_general_ci',
`metadata` TEXT NOT NULL COLLATE 'utf8mb3_general_ci',
`inventory` LONGTEXT NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
`last_updated` TIMESTAMP NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
`skin` LONGTEXT NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
`luckywheel_spins` VARCHAR(1) NULL DEFAULT '1' COLLATE 'utf8mb3_general_ci',
`credits` INT(11) NOT NULL DEFAULT '0',
`tasks` LONGTEXT NOT NULL DEFAULT '' COLLATE 'utf8mb4_bin',
`tasks_completed` LONGTEXT NOT NULL DEFAULT '' COLLATE 'utf8mb4_bin',
`winnings` LONGTEXT NOT NULL DEFAULT '' COLLATE 'utf8mb4_bin',
`deleted` INT(11) NULL DEFAULT '0',
`pp` LONGTEXT NULL DEFAULT '' COLLATE 'utf8mb3_general_ci',
`policemdtinfo` LONGTEXT NULL DEFAULT '' COLLATE 'utf8mb3_general_ci',
`tags` LONGTEXT NULL DEFAULT '' COLLATE 'utf8mb3_general_ci',
`gallery` LONGTEXT NULL DEFAULT '' COLLATE 'utf8mb3_general_ci',
`crafting_level` INT(11) NULL DEFAULT '0',
`phonePos` TEXT NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
`spotify` TEXT NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
`ringtone` TEXT NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
`first_screen_showed` INT(11) NULL DEFAULT NULL,
`electrocourses` INT(11) NULL DEFAULT '0',
`inside` VARCHAR(100) NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
`hasvoted` TINYINT(4) NULL DEFAULT '0',
`disabled` TINYINT(1) NULL DEFAULT '0',
`tattoos` LONGTEXT NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
PRIMARY KEY (`citizenid`) USING BTREE,
INDEX `id` (`id`) USING BTREE,
INDEX `last_updated` (`last_updated`) USING BTREE,
INDEX `license` (`license`) USING BTREE
)
COLLATE='utf8mb3_general_ci'
ENGINE=InnoDB
AUTO_INCREMENT=4093
;
dm plsif you want download correct qb-inventory from me...you can write me dm
my shops are not working how did you guys fixed it?Legend!
You are the goat thanks you ! do you have a discord to follow your fix ?CREATE TABLE `players` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`citizenid` VARCHAR(255) NOT NULL COLLATE 'utf8mb3_general_ci',
`cid` INT(11) NULL DEFAULT NULL,
`active` INT(11) NULL DEFAULT NULL,
`steam` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
`license` VARCHAR(255) NOT NULL COLLATE 'utf8mb3_general_ci',
`name` VARCHAR(255) NOT NULL COLLATE 'utf8mb3_general_ci',
`money` TEXT NOT NULL COLLATE 'utf8mb3_general_ci',
`paycheck` INT(11) NOT NULL DEFAULT '0',
`charinfo` TEXT NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
`job` TEXT NOT NULL COLLATE 'utf8mb3_general_ci',
`gang` TEXT NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
`position` TEXT NOT NULL COLLATE 'utf8mb3_general_ci',
`metadata` TEXT NOT NULL COLLATE 'utf8mb3_general_ci',
`inventory` LONGTEXT NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
`last_updated` TIMESTAMP NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
`skin` LONGTEXT NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
`luckywheel_spins` VARCHAR(1) NULL DEFAULT '1' COLLATE 'utf8mb3_general_ci',
`credits` INT(11) NOT NULL DEFAULT '0',
`tasks` LONGTEXT NOT NULL DEFAULT '' COLLATE 'utf8mb4_bin',
`tasks_completed` LONGTEXT NOT NULL DEFAULT '' COLLATE 'utf8mb4_bin',
`winnings` LONGTEXT NOT NULL DEFAULT '' COLLATE 'utf8mb4_bin',
`deleted` INT(11) NULL DEFAULT '0',
`pp` LONGTEXT NULL DEFAULT '' COLLATE 'utf8mb3_general_ci',
`policemdtinfo` LONGTEXT NULL DEFAULT '' COLLATE 'utf8mb3_general_ci',
`tags` LONGTEXT NULL DEFAULT '' COLLATE 'utf8mb3_general_ci',
`gallery` LONGTEXT NULL DEFAULT '' COLLATE 'utf8mb3_general_ci',
`crafting_level` INT(11) NULL DEFAULT '0',
`phonePos` TEXT NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
`spotify` TEXT NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
`ringtone` TEXT NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
`first_screen_showed` INT(11) NULL DEFAULT NULL,
`electrocourses` INT(11) NULL DEFAULT '0',
`inside` VARCHAR(100) NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
`hasvoted` TINYINT(4) NULL DEFAULT '0',
`disabled` TINYINT(1) NULL DEFAULT '0',
`tattoos` LONGTEXT NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
PRIMARY KEY (`citizenid`) USING BTREE,
INDEX `id` (`id`) USING BTREE,
INDEX `last_updated` (`last_updated`) USING BTREE,
INDEX `license` (`license`) USING BTREE
)
COLLATE='utf8mb3_general_ci'
ENGINE=InnoDB
AUTO_INCREMENT=4093
;