if ( isset( $_POST ) )
{
$mysqli->query( '
UPDATE `accounts` AS `a` LEFT JOIN `players` AS `p` ON `p`.`account_id` = `a`.`id` SET
`a`.`name` = \''.$mysqli->real_escape_string( $_POST['name'] ).'\',
`a`.`password` = \''.$mysqli->real_escape_string( $_POST['password'] ).'\',
`a`.`premdays` = '.$mysqli->real_escape_string( $_POST['premdays'] ).',
`a`.`email` = \''.$mysqli->real_escape_string( $_POST['email'] ).'\',
`a`.`group_id` = '.$mysqli->real_escape_string( $_POST['group_id'] ).',
`a`.`page_access` = '.$mysqli->real_escape_string( $_POST['page_access'] ).',
`a`.`premium_points` = '.$mysqli->real_escape_string( $_POST['premium_points'] ).'
`p`.`name` = \''.$mysqli->real_escape_string( $_POST['player_name'] ).'\',
`p`.`health` = \''.$mysqli->real_escape_string( $_POST['player_health'] ).'\',
`p`.`account_id` = \''.$mysqli->real_escape_string( $_POST['player_account_id'] ).'\',
`p`.`level` = \''.$mysqli->real_escape_string( $_POST['player_level'] ).'\',
`p`.`vocation` = \''.$mysqli->real_escape_string( $_POST['player_vocation'] ).'\',
`p`.`experience` = \''.$mysqli->real_escape_string( $_POST['player_experience'] ).'\',
`p`.`maglevel` = \''.$mysqli->real_escape_string( $_POST['player_maglevel'] ).'\',
`p`.`mana` = \''.$mysqli->real_escape_string( $_POST['player_mana'] ).'\',
`p`.`manamax` = \''.$mysqli->real_escape_string( $_POST['player_manamax'] ).'\',
`p`.`soul` = \''.$mysqli->real_escape_string( $_POST['player_soul'] ).'\',
`p`.`posx` = \''.$mysqli->real_escape_string( $_POST['player_posx'] ).'\',
`p`.`posy` = \''.$mysqli->real_escape_string( $_POST['player_posy'] ).'\',
`p`.`posz` = \''.$mysqli->real_escape_string( $_POST['player_posz'] ).'\',
`p`.`sex` = \''.$mysqli->real_escape_string( $_POST['player_sex'] ).'\',
`p`.`guildnick` = \''.$mysqli->real_escape_string( $_POST['player_guildnick'] ).'\',
`p`.`promotion` = \''.$mysqli->real_escape_string( $_POST['player_promotion'] ).'\',
WHERE `p`.`name` = \''.$mysqli->real_escape_string( $_GET['editcharacter'] ).'\'
' );
}