• VIP Yearly: 30 euro until end of January!

    We wish everyone a healthy, blessed 2025! We are here to stay, join our community and see the difference.

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

  • Post hidden due to user being banned.

HeiligeHallen

Member
Jun 16, 2024
17
1
3
Credits
189
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