Two bugs

[Xampy]

Hello!
I've found two bugs:

1) install\dbSCHEMA.txt~line 19:

ALTER TABLE `forum` ADD `guild` int(11) unsigned DEFAULT NULL;

should be:

ALTER TABLE `forums` ADD `guild` int(11) unsigned DEFAULT NULL;

2) injections\character_view\characters\injection.php~line 10:

$characters = $SQL->query( 'SELECT `c`.`name`, `c`.`vocation`, `c`.`world_id` FROM `players` AS `c` LEFT JOIN `players` AS `p` ON `p`.`account_id` = `c`.`account_id` AND c.deleted = 0 AND c.hide_char = 0 WHERE `p`.`id` = '.$player->getId( ).' AND `c`.`id` != '.$player->getId( ).';' )->fetchAll( );

should be:

$characters = $SQL->query( 'SELECT `c`.`name`, `c`.`vocation`, `c`.`world_id` FROM `players` AS `c` LEFT JOIN `players` AS `p` ON `p`.`account_id` = `c`.`account_id` AND c.deleted = 0 AND c.hide_char = 0 AND p.hide_char = 0 WHERE `p`.`id` = '.$player->getId( ).' AND `c`.`id` != '.$player->getId( ).';' )->fetchAll( );

 

[Paxton]

Thanks.