Error when i relogg my character!

[Denblinde]

Hello, i thinking if someone knows this error or something like this because if i throw all my items on the ground and relogg i got them back and get a error... its like a rollback on the server every time i relogg...

 

[Ninja]

You shouldn't have those errors in your console if you used the correct mysql schema.

 

[Denblinde]

You shouldn't have those errors in your console if you used the correct mysql schema.

then where can i get the right msql schema?

 

[Ninja]

then where can i get the right msql schema?

Depends on the TFS version you are using.

 

[Denblinde]

Depends on the TFS version you are using.

Im using TFS_02 i think xD

 

[Ninja]

CREATE TABLE `player_depotitems`
(
    `player_id` INT NOT NULL,
    `sid` INT NOT NULL COMMENT 'any given range eg 0-100 will be reserved for depot lockers and all > 100 will be then normal items inside depots',
    `pid` INT NOT NULL DEFAULT 0,
    `itemtype` INT NOT NULL,
    `count` INT NOT NULL DEFAULT 0,
    `attributes` BLOB NOT NULL,
    FOREIGN KEY (`player_id`) REFERENCES `players`(`id`) ON DELETE CASCADE,
    UNIQUE KEY (`player_id`, `sid`)
) ENGINE = InnoDB;

CREATE TABLE `bans`
(
    `type` INT NOT NULL COMMENT 'this field defines if its ip, accountban or namelock',
    `ip` INT UNSIGNED NOT NULL DEFAULT 0,
    `mask` INT UNSIGNED NOT NULL DEFAULT 4294967295,
    `player` INT UNSIGNED NOT NULL DEFAULT 0,
    `account` INT UNSIGNED NOT NULL DEFAULT 0,
    `time` INT UNSIGNED NOT NULL DEFAULT 0,
    `reason_id` INT NOT NULL DEFAULT 0,
    `action_id` INT NOT NULL DEFAULT 0,
    `comment` VARCHAR(60) NOT NULL DEFAULT '',
    `banned_by` INT UNSIGNED NOT NULL DEFAULT 0
) ENGINE = InnoDB;

These are in the mysql schema for TFS 0.2, execute these in phpMyAdmin. Assuming that you're using 0.2 of course