<?php
$host = "localhost";
$user = "root";
$password = "root";
$db_name = "temp_char";
$dump_dir = "./dump";

$link = mysql_connect($host, $user, $password) or die("Сервер базы данных не доступен");
$db = mysql_select_db($db_name) or die("База данных не доступна");

function dump_sql($dump_dir, $guid)
{
    $table_name =
    array(
    0 => "characters",
    1 => "character_queststatus",
    2 => "character_reputation",
    3 => "character_spell",
    4 => "character_spell_cooldown",
    5 => "character_action",
    6 => "character_aura",
    7 => "character_homebind",
    8 => "character_skills",
    9 => "character_inventory",
    10 => "item_instance",
    11 => "character_pet",
    12 => "character_gifts",
    13 => "pet_spell",
    14 => "pet_spell_cooldown",
    15 => "pet_aura",
    16 => "mail",
    17 => "mail_items");

    $dump_tables =
    array(
    0 => "SELECT * FROM characters WHERE guid = ",
    1 => "SELECT * FROM character_queststatus WHERE guid = ",
    2 => "SELECT * FROM character_reputation WHERE guid = ",
    3 => "SELECT * FROM character_spell WHERE guid = ",
    4 => "SELECT * FROM character_spell_cooldown WHERE guid = ",
    5 => "SELECT * FROM character_action WHERE guid = ",
    6 => "SELECT * FROM character_aura WHERE guid = ",
    7 => "SELECT * FROM character_homebind WHERE guid = ",
    8 => "SELECT * FROM character_skills WHERE guid = ",
    9 => "SELECT * FROM character_inventory WHERE guid = ",
    10 => "SELECT * FROM item_instance WHERE owner_guid  = ",
    11 => "SELECT * FROM character_pet WHERE owner = ",
    12 => "SELECT * FROM character_gifts WHERE guid = ",
    13 => "SELECT * FROM pet_spell WHERE guid IN (SELECT id FROM character_pet  WHERE owner = ",
    14 => "SELECT * FROM pet_spell_cooldown WHERE guid IN (SELECT id FROM character_pet  WHERE owner = ",
    15 => "SELECT * FROM pet_aura WHERE guid IN (SELECT id FROM character_pet  WHERE owner = ",
    16 => "SELECT * FROM mail WHERE receiver = ",
    17 => "SELECT * FROM mail_items WHERE receiver = ");

    $count  = 0;
    while($count < 18)
    {
        $fp = fopen($dump_dir."/"."player_guid-".$guid.".sql", "a");
        if ($fp)
        {
            fwrite ($fp, $query);
            if ($count > 12 && $count < 16)
                $rows = $dump_tables[$count].$guid.");";
            else $rows = $dump_tables[$count].$guid.";";
            $r = mysql_query($rows) or die("Ошибка при выполнении запроса: ".mysql_error());
            while($row = mysql_fetch_row($r))
            {
                $query = "";
                foreach ($row as $field)
                {
                    if (is_null($field))
                        $field = "NULL";
                    else
                        $field = "'".mysql_escape_string($field)."'";
                    if ( $query == "")
                        $query = $field;
                    else
                        $query = $query.', '.$field;
                }
                $query = "INSERT INTO `".$table_name[$count]."` VALUES (".$query.");\n";
                fwrite ($fp, $query);
            }
        }
        $count++;
    }

    fclose ($fp);
    unlink($dump_dir."/player_guid-".$guid."sql");
}

dump_sql('.', "6");
?>