SqlCommand.xml

<?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, hero.Race 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>
   <SqlCommand name="GetAllCareerSkillsUpdate">SELECT hero.Id, hero.Name, career.idx as careeridx, career.tier, career.unlocked, career.codedef AS careercodedef FROM hero RIGHT JOIN career ON hero.Id = career.hero WHERE hero.Name = VAR1;</SqlCommand>
   <SqlCommand name="GetAllCareerSkillsMatienance">SELECT career.codedef AS careercodedef FROM hero JOIN career ON hero.Id = career.hero WHERE hero.Name = VAR1 and hero.Id=VAR2</SqlCommand>
   <SqlCommand name="InsertCareer">INSERT INTO career (tier, hero, unlocked, codedef) VALUES(VARIABLES);</SqlCommand>
   <!-- QUESTS -->
   <SqlCommand name="GetAllQuests">SELECT hero.Id, hero.Name, quest.idx as questidx, quest.codedef, quest.iscompleted, questtask.idx as questtaskidx, questtask.questcodedef, questtask.codedef, questtask.progress, questtask.goal, questtask.iscompleted FROM hero RIGHT JOIN quest ON hero.Id = quest.hero LEFT JOIN questtask ON quest.codedef = questtask.questcodedef WHERE hero.Name = 'alex';</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>
   <SqlCommand name="UpdateQuestTaskComplete">UPDATE questtask SET iscompleted = VAR1 WHERE (questtask.codedef = VAR3 AND questtask.hero = VAR4 AND questtask.questcodedef = VAR2 AND questtask.idx ;lth;)</SqlCommand>
   <SqlCommand name="UpdateQuestComplete">UPDATE quest SET iscompleted = VAR1 WHERE (quest.codedef = VAR2 AND quest.hero = VAR3 AND questtask.idx ;lth; );</SqlCommand>
   <SqlCommand name="DeleteQuestTask">DELETE FROM questtask WHERE (questtask.hero = VAR1 AND questtask.questcodedef = VAR2 AND questtask.Idx ;lth; );</SqlCommand>
   <SqlCommand name="DeleteQuest">DELETE FROM quest WHERE (quest.hero = VAR1 AND quest.codedef = VAR2 AND quest.idx ;lth; );</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="GetAllSkillsUpdate">SELECT hero.Id, hero.Name, skills.idx, skills.codedef, skills.progress 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, codedef, 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">INSERT INTO traits (hero, active_traits, available_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">INSERT INTO careers (description, tier, hero,unlocked, codedef) VALUES(VARIABLES);</SqlCommand>
   <!-- STORY -->
   <SqlCommand name="GetPlayerStory">SELECT hero.Id, hero.Name, stories.storycodedef, stories.storypointcodedef, stories.completed FROM hero JOIN stories ON hero.Name = VAR1 AND hero.Id = stories.hero LIMIT 1;</SqlCommand>
   <SqlCommand name="InsertPlayerStory">INSERT INTO stories (hero, storycodedef, storypointcodedef, completed) VALUES(VARIABLES);</SqlCommand>
   <SqlCommand name="UpdateStoryPoint">UPDATE stories SET completed = VAR1 WHERE (stories.hero = VAR2 AND stories.idx ;lth; );</SqlCommand>
   <SqlCommand name="UpdateStory">UPDATE stories SET storycodedef = VAR1, storypointcodedef= VAR2, completed = VAR3 WHERE stories.hero = VAR4;</SqlCommand>
   <!-- CRAFTING/INVENTORY -->
   <SqlCommand name="InsertInventoryAsset">INSERT INTO inventories(hero,location,position,resource,source,progress) VALUES(VARIABLES);</SqlCommand>
   <SqlCommand name="GetInventoryAsset">SELECT hero.Id, hero.Name FROM hero JOIN inventory WHERE hero.Name = VAR1 and hero.Id = inventory.hero and inventory.resource = VAR2 LIMIT 1;</SqlCommand>
   <SqlCommand name="GetAllInventory">SELECT hero.Id, hero.Name, inventory.idx , inventory.location, inventory.position, inventory.resource, inventory.source, inventory.progress FROM hero RIGHT JOIN inventory ON hero.Id = inventory.hero WHERE hero.Name = VAR1;</SqlCommand>
   <SqlCommand name="UpdateInventoryLocation">UPDATE inventory SET location = VAR1, position = VAR2 WHERE (inventory.hero = VAR3 and inventory.resource = VAR4 AND inventory.idx ;lth;);</SqlCommand>
   <SqlCommand name="UpdateInventoryNameAndSource">UPDATE inventory SET resource = VAR1, source = VAR2 WHERE (inventory.hero = VAR3 and inventory.resource = VAR4 AND inventory.idx ;lth;);</SqlCommand>
   <SqlCommand name="DeleteInventory">DELETE FROM inventory WHERE inventory.hero = VAR1 and inventory.resource = VAR2;</SqlCommand>
</SqlCommands>