J0-NewsJob
Needs ox_lib, oxmysql, community_bridge
SQL
sql
CREATE TABLE IF NOT EXISTS `j0_news_employees` (
`id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
`location_id` VARCHAR(64) NOT NULL,
`citizenid` VARCHAR(64) NOT NULL,
`role` VARCHAR(64) NOT NULL DEFAULT 'Staff',
`salary` DECIMAL(10,2) NOT NULL DEFAULT 0.00,
`created_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`),
UNIQUE KEY `uniq_location_citizen` (`location_id`, `citizenid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
CREATE TABLE IF NOT EXISTS `j0_news_published` (
`location_id` VARCHAR(64) NOT NULL,
`body_html` LONGTEXT NOT NULL,
`updated_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`location_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
CREATE TABLE IF NOT EXISTS `j0_news_finance` (
`id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
`location_id` VARCHAR(64) NOT NULL,
`entry_type` ENUM('deposit', 'withdraw') NOT NULL,
`amount` DECIMAL(12,2) NOT NULL,
`memo` VARCHAR(512) NOT NULL DEFAULT '',
`source` VARCHAR(32) NOT NULL DEFAULT 'manual',
`created_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`),
KEY `idx_loc` (`location_id`),
KEY `idx_created` (`created_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
CREATE TABLE IF NOT EXISTS `j0_news_world_tv` (
`id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
`model` VARCHAR(64) NOT NULL,
`pos_x` DOUBLE NOT NULL,
`pos_y` DOUBLE NOT NULL,
`pos_z` DOUBLE NOT NULL,
`heading` DOUBLE NOT NULL,
`pitch_deg` DOUBLE NOT NULL DEFAULT 0,
`roll_deg` DOUBLE NOT NULL DEFAULT 0,
`offset_x` DOUBLE NOT NULL DEFAULT 0,
`offset_y` DOUBLE NOT NULL DEFAULT 0,
`offset_z` DOUBLE NOT NULL DEFAULT 0,
`scale` DOUBLE NOT NULL DEFAULT 0.085,
`range_dist` DOUBLE NOT NULL DEFAULT 20,
`load_distance` DOUBLE NOT NULL DEFAULT 42,
`unload_distance` DOUBLE NULL DEFAULT NULL,
`render_target` VARCHAR(64) NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
Inventory
ox_inventory (ox_inventory/data/items.lua)
lua
['newspaper'] = {
label = 'Newspaper',
weight = 200,
stack = true,
close = true,
consume = 0,
description = 'Pick up the latest edition. Use from inventory to read.',
client = {
export = 'J0-NewsJob.useNewspaper',
},
},
qb-inventory / qb-core shared items
lua
['newspaper'] = {
name = 'newspaper',
label = 'Newspaper',
weight = 200,
type = 'item',
image = 'newspaper.png',
unique = false,
useable = true,
shouldClose = true,
combinable = nil,
description = 'Pick up the latest edition. Use from inventory to read.',
},