• We have a new discord! click here to join
    Any faulty links ? Report them in our discord or via our Ticket System!
    We do everything we can to protect the safety of our visitors, if any resource contains malware in any kind of form or obfuscation please report it aswell ♡♡

QBUS [ESX/QB] OSP Farming [ OPEN SOURCE ] [ FULL PACKAGE ] 21.03.2024 UPDATE (6 Viewers)

HeiligeHallen

Member
Jun 16, 2024
18
2
3
Credits
37
USe this my friend ;) ony edit users to players
is there a qb sql?
ALTER TABLE `players` ADD `farming_level` TEXT NOT NULL DEFAULT 0;
CREATE TABLE IF NOT EXISTS `farming_shop` (
`owner` varchar(50) DEFAULT NULL,
`owned_farms` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `osp_plants` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`coords` text DEFAULT NULL,
`type` varchar(50) NOT NULL,
`process` float NOT NULL DEFAULT 0,
`multiplier` int(11) NOT NULL DEFAULT 0,
`water` float NOT NULL DEFAULT 0,
`fertilizer` float NOT NULL DEFAULT 0,
`owner` varchar(50) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=215 DEFAULT CHARSET=utf8mb4;
CREATE TABLE IF NOT EXISTS `farming_order` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`Totalcost` int(11) DEFAULT 0,
`FirstName` varchar(50) DEFAULT NULL,
`LastName` varchar(50) DEFAULT NULL,
`Phonenumber` varchar(50) DEFAULT NULL,
`Alias` varchar(50) DEFAULT NULL,
`apples` int(11) DEFAULT 0,
`oranges` int(11) DEFAULT 0,
`chickens` int(11) DEFAULT 0,
`pigs` int(11) DEFAULT 0,
`mushrooms` int(11) DEFAULT 0,
`cows` int(11) DEFAULT 0,
`wheats` int(11) DEFAULT 0,
`tomatos` int(11) DEFAULT 0,
`cabbages` int(11) DEFAULT 0,
`pumpkins` int(11) DEFAULT 0,
`milks` int(11) DEFAULT 0,
`owner` varchar(50) DEFAULT NULL,
KEY `id` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8 COMMENT='\r\n\r\n';
 
  • Post hidden due to user being banned.
  • Post hidden due to user being banned.
  • Post hidden due to user being banned.
  • Post hidden due to user being banned.
  • Post hidden due to user being banned.
  • Post hidden due to user being banned.

Users who are viewing this thread

Top