SqlCommand.xml

<SqlCommands>
    <!-- ACCOUNT -->
    <SqlCommand name="GetAccountId">SELECT A.Id FROM account A WHERE A.Username = VAR1 AND A.Password = VAR2;</SqlCommand>
    <SqlCommand name="GetAccountHeroes">SELECT A.Name, A.Gender, A.Race, A.World, A.Location, A.Level, A.Position_X, A.Position_Y, A.Position_Z, A.Orientation_W, A.Orientation_X, A.Orientation_Y, A.Orientation_Z FROM hero A WHERE A.Account_Id = VAR1;</SqlCommand>

    <!-- LOCATION -->
    <SqlCommand name="CreateLocation">INSERT INTO location (World, Name, Scene) VALUES(VARIABLES);</SqlCommand>

    <SqlCommand name="GetLocationScene">SELECT A.Scene FROM location A WHERE A.Name = VAR2;</SqlCommand>
    <SqlCommand name="UpdateLocationScene">UPDATE location AS A SET A.Scene = VAR1 WHERE A.Name = VAR2;</SqlCommand>

    <!-- HERO -->
    <SqlCommand name="CreateHero">INSERT INTO hero (Name, Gender, Race, World, Location, Level, Position_X, Position_Y, Position_Z, Orientation_W, Orientation_X, Orientation_Y, Orientation_Z, Account_Id) VALUES(VARIABLES);</SqlCommand>
    <!-- CAREER SKILL -->
    <SqlCommand name="GetAllCareerSkills">SELECT  hero.*, career.*, skills.* FROM hero RIGHT JOIN career ON hero.Id = career.hero LEFT JOIN skills ON hero.Id = skills.hero WHERE hero.Name = 'VAR1'</SqlCommand>
    <!-- TRAITS-->
        <SqlCommand name="GetAllTraits">SELECT traits.*, hero.* FROM hero RIGHT JOIN traits ON hero.Id = traits.hero WHERE hero.Name = 'VAR1'</SqlCommand>
    <!-- QUESTS-->
    <SqlCommand name="GetAllQuests">SELECT hero.*, quest.*, questtask.* FROM hero RIGHT JOIN quest ON hero.Id = quest.hero LEFT JOIN questtask ON quest.Idx = questtask.quest WHERE hero.Name = 'VAR1'</SqlCommand>

</SqlCommands>