sqlcommand

<?xml version="1.0" encoding="UTF-8"?>
<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>
   <SqlCommand name="GetHero">SELECT hero.Id FROM hero WHERE hero.Name = VAR1</SqlCommand>
   <!-- CAREER SKILL -->
   <SqlCommand name="GetAllCareerSkills">SELECT hero.Id, hero.Name, career.idx as careeridx, career.tier, career.unlocked, career.codedef AS careercodedef, skills.idx AS skillidx, skills.codedef AS skillcodedef, skills.progress FROM hero RIGHT JOIN career ON hero.Id = career.hero LEFT JOIN skills ON hero.Id = skills.hero WHERE hero.Name = VAR1;</SqlCommand>
   <!-- QUESTS-->
   <SqlCommand name="GetAllQuests">SELECT hero.Id, hero.Name, quest.idx as questidx, quest.uniqueid, quest.codedef, quest.iscompleted, questtask.idx as questtaskidx, questtask.questcodedef, quest.codedef, questtask.progress, questtask.goal,  questtask.progress,questtask.iscompleted FROM hero RIGHT JOIN quest ON hero.Id = quest.hero LEFT JOIN questtask ON quest.Idx = questtask.questcodedef WHERE hero.Name = VAR1;</SqlCommand>
   <SqlCommand name="CreateQuest">INSERT INTO quest (hero, uniqueid, codedef, iscompleted) VALUES
(VARIABLES);</SqlCommand>
   <SqlCommand name="CreateQuestTask">INSERT INTO questtask (hero, questcodedef, task, codedef, progress, goal, iscompleted) VALUES
(VARIABLES);</SqlCommand>
   <SqlCommand name="GetQuest">SELECT hero.Id, hero.Name, quest.idx, quest.codedef, quest.hero FROM hero JOIN quest ON hero.Name = VAR1 AND hero.Id = quest.hero AND quest.codedef=VAR2;</SqlCommand>
   <!--SKILLS -->
   <SqlCommand name="GetAllSkills">SELECT hero.Id, hero.Name, skills.idx, skills.codedef, skills.hero FROM hero JOIN skills ON hero.Name = VAR1 AND hero.Id = skills.hero;</SqlCommand>
   <SqlCommand name="GetSkill">SELECT hero.Id, hero.Name, skills.idx, skills.codedef, skills.hero FROM hero JOIN skills ON hero.Name = VAR1 AND hero.Id = skills.hero AND skills.codedef=VAR2;</SqlCommand>
   <SqlCommand name="CreateSkill">INSERT INTO skills (hero, skill, progress) VALUES(VARIABLES);</SqlCommand>
   <!-- TRAITS-->
   <SqlCommand name="GetAllTraits">SELECT hero.Id, hero.Name, traits.idx as traitidx, traits.active_traits, traits.available_traits FROM hero RIGHT JOIN traits ON hero.Id = traits.hero WHERE hero.Name = VAR1;</SqlCommand>
   <SqlCommand name="GetTrait">SELECT hero.Id, hero.Name, traits.idx, traits.hero FROM hero JOIN traits ON hero.Name = VAR1 AND hero.Id = traits.hero;</SqlCommand>
   <SqlCommand name="CreateTrait">INSET INTO skills (hero, active_traits, avaiable_traits) VALUES(VARIABLES);</SqlCommand>
   <SqlCommand name="UpdateActiveTrait">UPDATE traits.SET active_traits = VAR1 WHERE traits.hero = VAR2;</SqlCommand>
   <!-- CAREER -->
   <SqlCommand name="GetCareer">SELECT hero.Id, hero.Name, careers.idx, careers.hero FROM hero JOIN careers ON hero.Name = VAR1 AND hero.Id = careers.hero;</SqlCommand>
   <SqlCommand name="CreateCareer">INSET INTO careers (description, tier, hero,unlocked, codedef) VALUES(VARIABLES);</SqlCommand>

</SqlCommands>