# okokMarketplace

[**YouTube Video**](https://www.youtube.com/watch?v=IGhbMxmgESo)

## Installation Guide

#### Execute the following SQL code in your database:

```sql
CREATE TABLE `okokmarketplace_vehicles`  (
    `id` int(255) NOT NULL AUTO_INCREMENT,
    `item_id` varchar(255) NOT NULL,
    `plate` varchar(255) NOT NULL,
    `label` varchar(255) NOT NULL,
    `author_identifier` varchar(255) NOT NULL,
    `author_name` varchar(255) NULL DEFAULT NULL,
    `phone_number` varchar(255) NULL DEFAULT NULL,
    `description` varchar(255) NULL DEFAULT NULL,
    `price` varchar(255) NOT NULL,
    `sold` tinyint(1) NOT NULL DEFAULT 0,
    `start_date` varchar(255) NOT NULL,
    PRIMARY KEY (`id`)
);

CREATE TABLE `okokmarketplace_items`  (
    `id` int(255) NOT NULL AUTO_INCREMENT,
    `item_id` varchar(255) NOT NULL,
    `label` varchar(255) NOT NULL,
    `amount` varchar(255) NULL DEFAULT NULL,
    `author_identifier` varchar(255) NOT NULL,
    `author_name` varchar(255) NULL DEFAULT NULL,
    `phone_number` varchar(255) NULL DEFAULT NULL,
    `description` varchar(255) NULL DEFAULT NULL,
    `price` varchar(255) NOT NULL,
    `sold` tinyint(1) NOT NULL DEFAULT 0,
    `start_date` varchar(255) NOT NULL,
    PRIMARY KEY (`id`)
);

CREATE TABLE `okokmarketplace_blackmarket`  (
    `id` int(255) NOT NULL AUTO_INCREMENT,
    `item_id` varchar(255) NOT NULL,
    `label` varchar(255) NOT NULL,
    `type` varchar(255) NOT NULL,
    `amount` varchar(255) NOT NULL,
    `author_identifier` varchar(255) NOT NULL,
    `author_name` varchar(255) NULL DEFAULT NULL,
    `phone_number` varchar(255) NULL DEFAULT NULL,
    `description` varchar(255) NULL DEFAULT NULL,
    `price` varchar(255) NOT NULL,
    `sold` tinyint(1) NOT NULL DEFAULT 0,
    `start_date` varchar(255) NOT NULL,
    PRIMARY KEY (`id`)
);
```

### Adding images to the items/vehicles

To add items and vehicle images simply drop them in **okokMarketplace/web/icons**.

* The images should be in the **PNG** format;
* Items: the image name should be the same as the item ID, if the item ID is "**bread**", then the image should be "**bread.png**";
* Vehicles: the image name should be the **\<gameName>** of the vehicle (you can find the \<gameName> in the **vehicles.meta** file of each vehicle), examples:
  * If the vehicle \<gameName> is **DS3**, then the image should be "**DS3.png**";
  * If the vehicle \<gameName> is **La Voiture**, then the image should be "**LaVoiture.png**".