Abra sua data base e execute este comando:

CREATE TABLE tiles ( 
    id       INTEGER NOT NULL,
    world_id INTEGER NOT NULL
                     DEFAULT '0',
    house_id INTEGER NOT NULL,
    x        INTEGER NOT NULL,
    y        INTEGER NOT NULL,
    z        INTEGER NOT NULL,
    UNIQUE ( id, world_id ),
    FOREIGN KEY ( house_id, world_id ) REFERENCES houses ( id, world_id ) 
);

Caso ñ saiba executar um comando na data base, segue um tutorial: http://www.tibiaking.com/forum/topic/33611-tutorial-resolvendo-qualquer-erro-na-data-base/

 

Isso deve resolver o erro que aparece na distro.

 

 

Agora para resolver o problema que reseta o player, execute este comando na sua data base:

DROP TRIGGER IF EXISTS `oncreate_players`;
DELIMITER //
CREATE TRIGGER `oncreate_players` AFTER INSERT ON `players`
 FOR EACH ROW BEGIN INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 0, 10); INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 1, 10); INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 2, 10); INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 3, 10); INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 4, 10); INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 5, 10); INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 6, 10); END
//
DELIMITER ;
DROP TRIGGER IF EXISTS `ondelete_players`;
DELIMITER //
CREATE TRIGGER `ondelete_players` BEFORE DELETE ON `players`
 FOR EACH ROW BEGIN DELETE FROM `bans` WHERE `type` = 2 AND `value` = OLD.`id`; UPDATE `houses` SET `owner` = 0 WHERE `owner` = OLD.`id`; END
//
DELIMITER ;

Se ajudei, REP+

lek agora deu esses erros

mysql_real_query(): SELECT * from 'bans' WHERE 'value' =385437 and 'type' =3 and active = 1 and <'expires' > 1418152075 or 'expires' <= 0> LIMIT 1 - MYSQL ERROR:Table 'baiak.bans' doesn't exist <1146>

 

mysql_real_query(): select 'pid', 'sid' 'itemtype', 'count', 'attributes' from player_depotitems' where 'player_id' = 9 order by 'sid' desc - mysql error: table 'baiak.player_depotitems' doesn't exist >1146>

 

error while saving player: Test Baiak. 

 

 

me ajud te dou REP+

 

 

 

Ta faltando a table bans:

CREATE TABLE bans ( 
    id          INTEGER         PRIMARY KEY
                                NOT NULL,
    type        INTEGER         NOT NULL,
    value       INTEGER         NOT NULL,
    param       INTEGER         NOT NULL
                                DEFAULT '4294967295',
    active      BOOLEAN         NOT NULL
                                DEFAULT 'TRUE',
    expires     INTEGER         NOT NULL,
    added       INTEGER         NOT NULL,
    admin_id    INTEGER         NOT NULL
                                DEFAULT '0',
    comment     TEXT            NOT NULL,
    reason      INTEGER         NOT NULL
                                DEFAULT '0',
    [action]    INTEGER         NOT NULL
                                DEFAULT '0',
    [statement] VARCHAR( 255 )  NOT NULL
                                DEFAULT '''' 
);

 

E a table player_depotitems:

CREATE TABLE player_depotitems ( 
    player_id  INTEGER NOT NULL,
    sid        INTEGER NOT NULL,
    pid        INTEGER NOT NULL
                       DEFAULT '0',
    itemtype   INTEGER NOT NULL,
    count      INTEGER NOT NULL
                       DEFAULT '0',
    attributes BLOB    NOT NULL,
    UNIQUE ( player_id, sid ),
    FOREIGN KEY ( player_id ) REFERENCES players ( id ) 
);

 

Executa esses comandos.

Editado Dezembro 9, 2014 10 anos por danihcv (veja o histórico de edições)

@Poseidon001

 

Vá em sua database, nos chars samples (Knight sample etc...)

 

Clique em editar e veja se na linha save está o numero 1 se não tiver coloque 1 em todos os samples e de execute.

@Poseidon001

 

Vá em sua database, nos chars samples (Knight sample etc...)

 

Clique em editar e veja se na linha save está o numero 1 se não tiver coloque 1 em todos os samples e de execute.

Obg Consegui

 

Ta faltando a table bans:

CREATE TABLE bans ( 
    id          INTEGER         PRIMARY KEY
                                NOT NULL,
    type        INTEGER         NOT NULL,
    value       INTEGER         NOT NULL,
    param       INTEGER         NOT NULL
                                DEFAULT '4294967295',
    active      BOOLEAN         NOT NULL
                                DEFAULT 'TRUE',
    expires     INTEGER         NOT NULL,
    added       INTEGER         NOT NULL,
    admin_id    INTEGER         NOT NULL
                                DEFAULT '0',
    comment     TEXT            NOT NULL,
    reason      INTEGER         NOT NULL
                                DEFAULT '0',
    [action]    INTEGER         NOT NULL
                                DEFAULT '0',
    [statement] VARCHAR( 255 )  NOT NULL
                                DEFAULT '''' 
);

 

E a table player_depotitems:

CREATE TABLE player_depotitems ( 
    player_id  INTEGER NOT NULL,
    sid        INTEGER NOT NULL,
    pid        INTEGER NOT NULL
                       DEFAULT '0',
    itemtype   INTEGER NOT NULL,
    count      INTEGER NOT NULL
                       DEFAULT '0',
    attributes BLOB    NOT NULL,
    UNIQUE ( player_id, sid ),
    FOREIGN KEY ( player_id ) REFERENCES players ( id ) 
);

 

Executa esses comandos.

Obg Pelos commandos. Vlw REP+ aos 2    

Marque como a melhor resposta, para mostrar que foi resolvido.

 

Abraços!