How to patch?

[jammie]

Hey people,

This is for the armory website.

Everything works fine of the armory but I have one problem. I can't see the characters, when I click on the character name it will said: "File Not Found".

This is my database,

auth = realm database
characters = character database
trinity = world database

I already execute the "characters_patch.sql" file into the characters database.
I use the newest rev. 450 from Shadez. So I don't need any updates.
I didn't patch the two files yet, because I don't know how to patch...

I have read some other comments about the same problem and there is a comment, if the "armory_character_stats" is empty then you must patch that two files in \tools\trinity_core\. I hope someone can explain me how to patch that two files.

This is my configuration.php,

$ArmoryConfig['mysql']['host_armory']     = 'localhost';
$ArmoryConfig['mysql']['user_armory']     = 'root';
$ArmoryConfig['mysql']['pass_armory']     = 'mypassword';
$ArmoryConfig['mysql']['name_armory']     = 'armory';
$ArmoryConfig['mysql']['charset_armory']  = 'UTF8';
$ArmoryConfig['mysql']['host_realmd']     = 'localhost';
$ArmoryConfig['mysql']['user_realmd']     = 'root';
$ArmoryConfig['mysql']['pass_realmd']     = 'mypassword';
$ArmoryConfig['mysql']['name_realmd']     = 'auth';
$ArmoryConfig['mysql']['charset_realmd']  = 'UTF8';

$ArmoryConfig['multiRealm'][1]['id']                 = 1;
$ArmoryConfig['multiRealm'][1]['name']               = 'Trinity';
$ArmoryConfig['multiRealm'][1]['type']               = SERVER_TRINITY;
$ArmoryConfig['multiRealm'][1]['host_characters']    = 'localhost';
$ArmoryConfig['multiRealm'][1]['user_characters']    = 'root';
$ArmoryConfig['multiRealm'][1]['pass_characters']    = 'mypassword';
$ArmoryConfig['multiRealm'][1]['name_characters']    = 'characters';
$ArmoryConfig['multiRealm'][1]['charset_characters'] = 'UTF8';
$ArmoryConfig['multiRealm'][1]['host_world']         = 'localhost';
$ArmoryConfig['multiRealm'][1]['user_world']         = 'root';
$ArmoryConfig['multiRealm'][1]['pass_world']         = 'mypassword';
$ArmoryConfig['multiRealm'][1]['name_world']         = 'characters';
$ArmoryConfig['multiRealm'][1]['charset_world']      = 'UTF8';

I have a little question about the configuration.php too, why doesn't have the ID and TYPE these signs ( ' ' ) ?

And at least you need my debug, these bugs will come when I click on my character name on the armory site from Shadez.

<strong>ERROR</strong> [27-01-2011 16:06:39]: Characters::BuildCharacter : player 2 (Test) has no data in `armory_character_stats` table (SQL update to Characters DB was not applied? / Character was not saved in game? / Server core was not patched?)<br />
<strong>ERROR</strong> [27-01-2011 16:06:39]: Achievements::InitAchievements : wrong player guid (0), ignore.<br />
<strong>ERROR</strong> [27-01-2011 16:06:40]: Achievements::CalculateAchievementPoints : unable to find any completed achievements for player 2<br />
<strong>ERROR</strong> [27-01-2011 16:06:40]: Achievements::CalculateAchievementPoints : unable to find any completed achievements for player 2<br />
<strong>DEBUG</strong> [27-01-2011 16:06:40]: Utils::GetBookmarks : bookmarks for account 5 not found<br />