# Installation

## 1. Download Resource

Download the purchased resource from [**CFX Portal**](https://portal.cfx.re/assets/granted-assets) - the official site of FiveM with purchased resources.

***

## 2. Import Database Tables

This is a very important step - without it, the script will not work properly.
\
Depending on the framework you are using (ESX or QB-Core), select the appropriate section below and **paste the SQL code into your database**.

{% hint style="warning" %}

## Not sure how to do it?

No worries - we've prepared a short guide that shows you step by step how to import an SQL file into your database:\
👉 [**Click here to view the tutorial.**](https://docs.vames-store.com/helpful/basic-server-knowledge/how-to-import-sql-to-database)
{% endhint %}

<details>

<summary>Database for ESX</summary>

```sql
ALTER TABLE users ADD COLUMN `tattoos` LONGTEXT DEFAULT NULL;

CREATE TABLE IF NOT EXISTS `vms_business` (
  `id` varchar(50) NOT NULL DEFAULT '',
  `type` varchar(50) NOT NULL DEFAULT '',
  `owner` mediumtext DEFAULT NULL,
  `employees` longtext DEFAULT '{}',
  `stock` longtext DEFAULT '{}',
  `data` longtext DEFAULT '{}',
  `announcements` longtext DEFAULT '{}',
  `orders` longtext DEFAULT '{}',
  `history` longtext DEFAULT '{}'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
```

</details>

<details>

<summary>Database for QB-Core</summary>

```sql
ALTER TABLE players ADD COLUMN `tattoos` LONGTEXT DEFAULT NULL;

CREATE TABLE IF NOT EXISTS `vms_business` (
  `id` varchar(50) NOT NULL DEFAULT '',
  `type` varchar(50) NOT NULL DEFAULT '',
  `owner` mediumtext DEFAULT NULL,
  `employees` longtext DEFAULT '{}',
  `stock` longtext DEFAULT '{}',
  `data` longtext DEFAULT '{}',
  `announcements` longtext DEFAULT '{}',
  `orders` longtext DEFAULT '{}',
  `history` longtext DEFAULT '{}'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
```

</details>

***

## 3. Add Required Items

The script uses its own items.
\
Depending on what inventory you are using, select the appropriate section and add these items to either your item file or database.

<details>

<summary>Items for esx inventory</summary>

```sql
INSERT INTO `items` (`name`, `label`, `weight`, `rare`, `can_remove`) VALUES
    ("tattoo_machine", "Tattoo Machine", 10, 0, 1),
    ("tattoo_laser", "Tattoo Laser", 10, 0, 1),
    ("tattoo_ink", 'Tattoo Ink', 10, 0, 1);
```

</details>

<details>

<summary>Items for ox_inventory</summary>

```lua
['tattoo_machine'] = {
    label = 'Tattoo Machine',
    weight = 1,
    stack = true
},

['tattoo_laser'] = {
    label = 'Tattoo Laser',
    weight = 1,
    stack = true
},

['tattoo_ink'] = {
    label = 'Tattoo Ink',
    weight = 1,
    stack = true
}
```

</details>

<details>

<summary>Items for qb-inventory / qs-inventory / origen_inventory</summary>

```lua
['tattoo_machine'] = {
    ["name"] = 'tattoo_machine',
    ["label"] = "Tattoo Machine",
    ["weight"] = 10,
    ["type"] = "item",
    ["image"] = "tattoo_machine.png",
    ["unique"] = false,
    ["useable"] = true,
    ["shouldClose"] = false,
    ["combinable"] = nil,
    ["description"] = ""
},

['tattoo_laser'] = {
    ["name"] = 'tattoo_laser',
    ["label"] = "Tattoo Laser",
    ["weight"] = 10,
    ["type"] = "item",
    ["image"] = "tattoo_laser.png",
    ["unique"] = false,
    ["useable"] = true,
    ["shouldClose"] = false,
    ["combinable"] = nil,
    ["description"] = ""
},

['tattoo_ink'] = {
    ["name"] = 'tattoo_ink',
    ["label"] = "Tattoo Ink",
    ["weight"] = 10,
    ["type"] = "item",
    ["image"] = "tattoo_ink.png",
    ["unique"] = false,
    ["useable"] = true,
    ["shouldClose"] = false,
    ["combinable"] = nil,
    ["description"] = ""
},
```

</details>

***

## 4. Register Jobs

Some functions work only if the player has a proper job.
\
In this section, you will find ready-made job that you need to add in your framework (ESX/QB).

<details>

<summary>Jobs for ESX</summary>

```sql
INSERT INTO `jobs` (name, label) VALUES
    ('tattoo1', 'Tattoo Shop (1)'),
    ('tattoo2', 'Tattoo Shop (2)'),
    ('tattoo3', 'Tattoo Shop (3)'),
    ('tattoo4', 'Tattoo Shop (4)'),
    ('tattoo5', 'Tattoo Shop (5)'),
    ('tattoo6', 'Tattoo Shop (6)');

INSERT INTO `job_grades` (job_name, grade, name, label, salary, skin_male, skin_female) VALUES
    ('tattoo1', 0, 'trainee', 'Trainee', 150, '{}', '{}'),
    ('tattoo1', 1, 'employee', 'Employee', 200, '{}', '{}'),
    ('tattoo1', 2, 'manager', 'Manager', 300, '{}', '{}'),
    ('tattoo1', 3, 'boss', 'Boss', 350, '{}', '{}'),
    ('tattoo2', 0, 'trainee', 'Trainee', 150, '{}', '{}'),
    ('tattoo2', 1, 'employee', 'Employee', 200, '{}', '{}'),
    ('tattoo2', 2, 'manager', 'Manager', 300, '{}', '{}'),
    ('tattoo2', 3, 'boss', 'Boss', 350, '{}', '{}'),
    ('tattoo3', 0, 'trainee', 'Trainee', 150, '{}', '{}'),
    ('tattoo3', 1, 'employee', 'Employee', 200, '{}', '{}'),
    ('tattoo3', 2, 'manager', 'Manager', 300, '{}', '{}'),
    ('tattoo3', 3, 'boss', 'Boss', 350, '{}', '{}'),
    ('tattoo4', 0, 'trainee', 'Trainee', 150, '{}', '{}'),
    ('tattoo4', 1, 'employee', 'Employee', 200, '{}', '{}'),
    ('tattoo4', 2, 'manager', 'Manager', 300, '{}', '{}'),
    ('tattoo4', 3, 'boss', 'Boss', 350, '{}', '{}'),
    ('tattoo5', 0, 'trainee', 'Trainee', 150, '{}', '{}'),
    ('tattoo5', 1, 'employee', 'Employee', 200, '{}', '{}'),
    ('tattoo5', 2, 'manager', 'Manager', 300, '{}', '{}'),
    ('tattoo5', 3, 'boss', 'Boss', 350, '{}', '{}'),
    ('tattoo6', 0, 'trainee', 'Trainee', 150, '{}', '{}'),
    ('tattoo6', 1, 'employee', 'Employee', 200, '{}', '{}'),
    ('tattoo6', 2, 'manager', 'Manager', 300, '{}', '{}'),
    ('tattoo6', 3, 'boss', 'Boss', 350, '{}', '{}');
```

</details>

<details>

<summary>Jobs for QB-Core</summary>

```lua
['tattoo1'] = {
    label = 'Tattoo Shop (1)',
    defaultDuty = true,
    offDutyPay = false,
    grades = {
        ['0'] = {
            name = 'recruit',
            payment = 50
        },
        ['1'] = {
            name = 'employee',
            payment = 250
        },
        ['2'] = {
            name = 'manager',
            payment = 250,
        },
        ['3'] = {
            name = 'boss',
            payment = 250,
        },
    },
},
['tattoo2'] = {
    label = 'Tattoo Shop (2)',
    defaultDuty = true,
    offDutyPay = false,
    grades = {
        ['0'] = {
            name = 'recruit',
            payment = 50
        },
        ['1'] = {
            name = 'employee',
            payment = 250
        },
        ['2'] = {
            name = 'manager',
            payment = 250,
        },
        ['3'] = {
            name = 'boss',
            payment = 250,
        },
    },
},
['tattoo3'] = {
    label = 'Tattoo Shop (3)',
    defaultDuty = true,
    offDutyPay = false,
    grades = {
        ['0'] = {
            name = 'recruit',
            payment = 50
        },
        ['1'] = {
            name = 'employee',
            payment = 250
        },
        ['2'] = {
            name = 'manager',
            payment = 250,
        },
        ['3'] = {
            name = 'boss',
            payment = 250,
        },
    },
},
['tattoo4'] = {
    label = 'Tattoo Shop (4)',
    defaultDuty = true,
    offDutyPay = false,
    grades = {
        ['0'] = {
            name = 'recruit',
            payment = 50
        },
        ['1'] = {
            name = 'employee',
            payment = 250
        },
        ['2'] = {
            name = 'manager',
            payment = 250,
        },
        ['3'] = {
            name = 'boss',
            payment = 250,
        },
    },
},
['tattoo5'] = {
    label = 'Tattoo Shop (5)',
    defaultDuty = true,
    offDutyPay = false,
    grades = {
        ['0'] = {
            name = 'recruit',
            payment = 50
        },
        ['1'] = {
            name = 'employee',
            payment = 250
        },
        ['2'] = {
            name = 'manager',
            payment = 250,
        },
        ['3'] = {
            name = 'boss',
            payment = 250,
        },
    },
},
['tattoo6'] = {
    label = 'Tattoo Shop (6)',
    defaultDuty = true,
    offDutyPay = false,
    grades = {
        ['0'] = {
            name = 'recruit',
            payment = 50
        },
        ['1'] = {
            name = 'employee',
            payment = 250
        },
        ['2'] = {
            name = 'manager',
            payment = 250,
        },
        ['3'] = {
            name = 'boss',
            payment = 250,
        },
    },
},

```

</details>

***

## 5. Start Resource

To start a resource in your `server.cfg`, ensure that it begins after your framework has been initiated. For instance, if you are using a framework like `es_extended`, you should start resource after it, like so:

```python
start [core] # For example, here is your framework (esx/qb-core)

# Here you run your other resources like esx_policejob etc.

# VMS Resources
start vms_tattooshop
```

Ensure there are no syntax errors or incorrect paths in your `server.cfg`.