World Quest Requuest

[Mariuskens]

Hello, I would like some help to perform a series of functions to improve the experience of the server I am developing.

I have the functions of the Teleport Gate if you need the post and look, then I leave some ideas that I have: D

CREATE TABLE IF NOT EXISTS `Boss` (
    `floor_0` int(11) NOT NULL DEFAULT '1',
    `floor_1` int(11) NOT NULL DEFAULT '0',
    `floor_2` int(11) NOT NULL DEFAULT '0',
    `floor_3` int(11) NOT NULL DEFAULT '0',
    `floor_4` int(11) NOT NULL DEFAULT '0',
    `floor_5` int(11) NOT NULL DEFAULT '0',
    `floor_6` int(11) NOT NULL DEFAULT '0',
    `floor_7` int(11) NOT NULL DEFAULT '0',
    `floor_8` int(11) NOT NULL DEFAULT '0',
    `floor_9` int(11) NOT NULL DEFAULT '0',
    `floor_10` int(11) NOT NULL DEFAULT '0',
    `floor_11` int(11) NOT NULL DEFAULT '0',
    `floor_12` int(11) NOT NULL DEFAULT '0',
    `floor_13` int(11) NOT NULL DEFAULT '0',
    `floor_14` int(11) NOT NULL DEFAULT '0',   
    `floor_15` int(11) NOT NULL DEFAULT '0'
) ENGINE=InnoDB;

using something from this table i want add a function to check if someone kill a monster (Boss) add to this table "1"
1 = Monster killed one time and cant be increased this number (for example 2 or more, to no broke the script)
when server startup need check if the table from floors have some opened (1) to remove a specific door (item_id + coordinates) to give pass to all players if want run a boss room.
After that inject to player/players kill that monster (STORAGE) to open a reward chest, the (STORAGE) need the same to open a Teleport Gate to travel to anothers locations.

Teleport Gate:

• Free travel to Floor 1
• Avaiable travel to nexts floors if table (Boss) have open nexts floors
• Floor 1 counts to Floor_0 always opened to travel (1)