Solved Loot bugged shit & SQL help

[president vankk]

Hello, atm I got some problems with loot and a big problem with SQL.. Like:

- Loot:
It's not like tibia RL with green message.

Screenshot: http://4.imgland.net/EmD4Lc.png

PS: In the config.lua I alright got this:

monsterLootMessage = 3
monsterLootMessageType = 19

- SQL:
When someone enter in the servers it's getting this error:

http://4.imgland.net/meTJ7e.png

Did you have this table to send to me? Thanks.

 

[Ninja]

monsterLootMessageType = 29

CREATE TABLE `player_inboxitems` 
(
    `player_id` int(11) NOT NULL, 
    `sid` int(11) NOT NULL, 
    `pid` int(11) NOT NULL DEFAULT '0', 
    `itemtype` smallint(6) NOT NULL, 
    `count` smallint(5) NOT NULL DEFAULT '0', 
    `attributes` blob NOT NULL, 
    UNIQUE KEY `player_id_2` (`player_id`,`sid`), 
    KEY `player_id` (`player_id`), 
    FOREIGN KEY (`player_id`) REFERENCES `players`(`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

 

[president vankk]

@ninja

thanks, s2.