This script imports missing characters and accounts to be compatible with Znote AAC. This also removes duplicates.

znote_repair_fix_duplicates_players_accounts.sql

INSERT INTO `znote_accounts` (`account_id`, `ip`, `created`, `flag`)
SELECT 
  `a`.`id` AS `account_id`, 
  0 AS `ip`, 
  UNIX_TIMESTAMP(CURDATE()) AS `created`, 
  '' AS `flag`
FROM `accounts` AS `a`
LEFT JOIN `znote_accounts` AS `z`
  ON `a`.`id` = `z`.`account_id` 
WHERE `z`.`created` IS NULL;

INSERT INTO `znote_players` (`player_id`, `created`, `hide_char`, `comment`)
SELECT 
  `p`.`id` AS `player_id`, 
  UNIX_TIMESTAMP(CURDATE()) AS `created`, 
  0 AS `hide_char`, 
  '' AS `comment`
FROM `players` AS `p`
LEFT JOIN `znote_players` AS `z`
  ON `p`.`id` = `z`.`player_id` 
WHERE `z`.`created` IS NULL;

DELETE `d` FROM `znote_accounts` AS `d`
INNER JOIN (
  SELECT `i`.`account_id`, 
  MAX(`i`.`id`) AS `retain`
  FROM `znote_accounts` AS `i` 
  GROUP BY `i`.`account_id` 
  HAVING COUNT(`i`.`id`) > 1
) AS `x`
  ON `d`.`account_id` = `x`.`account_id`
  AND `d`.`id` != `x`.`retain`;
  
DELETE `d` FROM `znote_players` AS `d`
INNER JOIN (
  SELECT `i`.`player_id`, 
  MAX(`i`.`id`) AS `retain`
  FROM `znote_players` AS `i` 
  GROUP BY `i`.`player_id` 
  HAVING COUNT(`i`.`id`) > 1
) AS `x`
  ON `d`.`player_id` = `x`.`player_id`
  AND `d`.`id` != `x`.`retain`;