Installation

1. Drag and drop the possible_turfs folder into your [standalone] directory

2. Run the SQL from /import/ into your server database.

   CREATE TABLE possible_turfs (
       name VARCHAR(255) PRIMARY KEY,
       owner VARCHAR(255) DEFAULT NULL
   );
   
   CREATE TABLE possible_turf_wins (
       zoneName VARCHAR(255),
       gang VARCHAR(255),
       wins INT DEFAULT 0,
       turf_points INT DEFAULT 0,
       PRIMARY KEY (zoneName, gang)
   );
   
   CREATE TABLE possible_turf_kills (
       id INT AUTO_INCREMENT PRIMARY KEY,
       killer_id INT NOT NULL,
       victim_id INT NOT NULL,
       killer_name VARCHAR(255) NOT NULL,
       victim_name VARCHAR(255) NOT NULL,
       killer_gang VARCHAR(255) NOT NULL,
       victim_gang VARCHAR(255) NOT NULL,
       zone_name VARCHAR(255) NOT NULL,
       kill_time TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
       weapon_hash VARCHAR(50),
       distance FLOAT DEFAULT 0.0,
       INDEX idx_killer (killer_id),
       INDEX idx_victim (victim_id),
       INDEX idx_zone (zone_name),
       INDEX idx_gangs (killer_gang, victim_gang),
       INDEX idx_time (kill_time)
   );
   
   CREATE TABLE possible_turf_deaths (
       id INT AUTO_INCREMENT PRIMARY KEY,
       killer_id INT NOT NULL,
       victim_id INT NOT NULL,
       killer_name VARCHAR(255) NOT NULL,
       victim_name VARCHAR(255) NOT NULL,
       killer_gang VARCHAR(255) NOT NULL,
       victim_gang VARCHAR(255) NOT NULL,
       zone_name VARCHAR(255) NOT NULL,
       death_time TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
       weapon_hash VARCHAR(50),
       distance FLOAT DEFAULT 0.0,
       INDEX idx_killer (killer_id),
       INDEX idx_victim (victim_id),
       INDEX idx_zone (zone_name),
       INDEX idx_gangs (killer_gang, victim_gang),
       INDEX idx_time (death_time)
   );
   

QBCore, QBox & ESX.

• ox_lib
• oxmysql
• ox_inventory
• ox_target