Solved Mysql error

[ZionOt]

mysql_real_query(): SELECT `player_id` AS `vip` FROM `account_viplist` WHERE `account_id` = 3 AND `world_id` = 0 - MYSQL ERROR: Table 'zion.account_viplist' doesn't exist (1146)

What do i do!?

I need this fixed ASAP Please!

 

[president vankk]

u can use one function called /search.php

CREATE TABLE `account_viplist`
(
    `account_id` INT NOT NULL,
    `world_id` TINYINT(2) UNSIGNED NOT NULL DEFAULT 0,
    `player_id` INT NOT NULL,
    KEY (`account_id`), KEY (`player_id`), KEY (`world_id`), UNIQUE (`account_id`, `player_id`),
    FOREIGN KEY (`account_id`) REFERENCES `accounts`(`id`) ON DELETE CASCADE,
    FOREIGN KEY (`player_id`) REFERENCES `players`(`id`) ON DELETE CASCADE
) ENGINE = InnoDB;

 

[ZionOt]

I did, i didnt see anything that would fix it..thanks so so much!

 

[pikkio]

Please help me i tried use Search button..
MySQL ERROR mysql_real_query: SELECT `id`, `password`, `type`, `premdays`, `lastday`, `key`, `warnings` FROM `accounts` WHERE `id` = 1 LIMIT 1; Unknown column 'type' in 'field list'

 

[Cykotitan]

wrong database schema imported, import forgottenserver.sql (not mysql.sql)