API tools faq
paste
telosse

UpgradeCharSheetGuide

telosse
Apr 5th, 2017
164
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 7.20 KB | None | 0 0
raw download clone embed print report
  1. Change ' with ' and add NULL and 'YourCharacterName' at first
  2.  
  3. Occupational:
  4. (NULL, 'Regene Adlei MacGhabhann', 'SkillName', 'Occupational', 'DetailsAnyUsuallyHowYouGetThis', '1', 'ThreeLetterStatsOrSOCIAL', '', '', '000'),
  5.  
  6. Military:
  7. ('SkillName', 'Military', 'DetailsAnyUsuallyHowYouGetThis', '1', 'ThreeLetterStats', '', 'ArmorOrMeleeOrRanged', '000'),
  8.  
  9. Equipment:
  10. ('EquipName', 'Equipment', 'DetailsLikeAbove', 'ValueOfPlusOrMinus', '', '', '', '000'),
  11.  
  12. Stats: Phy Str Spd Agl Poi Prw Int Arc Per
  13. ('ThreeLetterStats', 'Equipment', 'DetailsLikeAbove', 'ValueOfPlusOrMinus', '', '', '', '000'),
  14.  
  15. Others: Spells, Language, Race, Archetype, ArchetypeBenefit, Ability
  16. ('WhateverNameAsLongSameWithTheOneAtEisen', 'SaidCategory', 'DetailsBlabla', '', '', '', '', '000'),
  17.  
  18.  
  19. Example:
  20. INSERT INTO `x_CharSheet` (`ID`, `xEntityName`, `xItemName`, `xItemCategory`, `xItemDetails`, `xItemAX`, `xItemBX`, `xItemCX`, `xItemDX`, `xSession`) VALUES
  21. (NULL, 'Regene Adlei MacGhabhann', 'Human', 'Race', 'Cygnaran, Midlunder', '', '', '', '', '000'),
  22. (NULL, 'Regene Adlei MacGhabhann', 'Gifted', 'Archetype', 'Starting', '', '', '', '', '000'),
  23. (NULL, 'Regene Adlei MacGhabhann', 'Warcaster', 'Career', 'Starting', '', '', '', '', '000'),
  24. (NULL, 'Regene Adlei MacGhabhann', 'Gunmage', 'Career', 'Starting', '', '', '', '', '000'),
  25. (NULL, 'Regene Adlei MacGhabhann', 'Magic Sensitivity', 'ArchetypeBenefit', 'Starting', '', '', '', '', '000'),
  26. (NULL, 'Regene Adlei MacGhabhann', 'Cygnaran', 'Language', 'Starting', '', '', '', '', '000'),
  27. (NULL, 'Regene Adlei MacGhabhann', 'Llaelese', 'Language', 'Starting', '', '', '', '', '000'),
  28. (NULL, 'Regene Adlei MacGhabhann', 'Ordic', 'Language', 'HouseRule Human', '', '', '', '', '000'),
  29. (NULL, 'Regene Adlei MacGhabhann', 'Phy', 'Stats', 'Starting', '1', '', '', '', '000'),
  30. (NULL, 'Regene Adlei MacGhabhann', 'Agl', 'Stats', 'Starting', '1', '', '', '', '000'),
  31. (NULL, 'Regene Adlei MacGhabhann', 'Int', 'Stats', 'Starting', '1', '', '', '', '000'),
  32. (NULL, 'Regene Adlei MacGhabhann', 'Arc', 'Stats', 'Starting', '1', '', '', '', '000'),
  33. (NULL, 'Regene Adlei MacGhabhann', 'Arc', 'Stats', 'Starting', '1', '', '', '', '000'),
  34. (NULL, 'Regene Adlei MacGhabhann', 'Poi', 'Stats', 'Starting', '1', '', '', '', '000'),
  35. (NULL, 'Regene Adlei MacGhabhann', 'Bond', 'Ability', 'Starting', '', '', '', '', '000'),
  36. (NULL, 'Regene Adlei MacGhabhann', 'Craft Rune Shot', 'Ability', 'Starting', '', '', '', '', '000'),
  37. (NULL, 'Regene Adlei MacGhabhann', 'Fast Reload', 'Ability', 'Starting', '', '', '', '', '000'),
  38. (NULL, 'Regene Adlei MacGhabhann', 'Bond', 'Ability', 'HouseRule Human', '', '', '', '', '000'),
  39. (NULL, 'Regene Adlei MacGhabhann', 'Boundless Charge', 'Spells', 'Starting Warcaster', '', '', '', '', '000'),
  40. (NULL, 'Regene Adlei MacGhabhann', 'Refuge', 'Spells', 'Starting Warcaster, Swap with Convection', '', '', '', '', '000'),
  41. (NULL, 'Regene Adlei MacGhabhann', 'Rune Shot: Accuracy', 'Spells', 'Starting Gun Mage', '', '', '', '', '000'),
  42. (NULL, 'Regene Adlei MacGhabhann', 'Rune Shot: Brutal', 'Spells', 'Starting Gun Mage', '', '', '', '', '000'),
  43. (NULL, 'Regene Adlei MacGhabhann', 'Rune Shot: Thunderbolt', 'Spells', 'Starting Gun Mage', '', '', '', '', '000'),
  44. (NULL, 'Regene Adlei MacGhabhann', 'Hand Weapon', 'Military', 'Starting Warcaster', '1', 'Prw', '', '', '000'),
  45. (NULL, 'Regene Adlei MacGhabhann', 'Unarmed Combat', 'Military', 'Starting Warcaster, Swap with Pistol', '1', 'Prw', '', '', '000'),
  46. (NULL, 'Regene Adlei MacGhabhann', 'Rifle', 'Military', 'Starting Gun Mage', '1', 'Poi', '', '', '000'),
  47. (NULL, 'Regene Adlei MacGhabhann', 'Detection', 'Occupational', 'Starting Warcaster', '1', 'Per', '', '', '000'),
  48. (NULL, 'Regene Adlei MacGhabhann', 'Lore (Thamarite)', 'Occupational', 'Starting Warcaster, Swap with Command', '1', 'Int', '', '', '000'),
  49. (NULL, 'Regene Adlei MacGhabhann', 'Detection', 'Occupational', 'Starting Gun Mage', '1', 'Per', '', '', '000'),
  50. (NULL, 'Regene Adlei MacGhabhann', 'Intimidation', 'Occupational', 'Starting Gun Mage', '1', 'Social', '', '', '000'),
  51. (NULL, 'Regene Adlei MacGhabhann', 'Sneak', 'Occupational', 'HouseRule Human', '1', 'Agl', '', '', '000'),
  52.  
  53. (NULL, 'Regene Adlei MacGhabhann', 'Coin Crown', 'Equipment', 'Starting Gunmage', '25', '', '', '', '000'),
  54. (NULL, 'Regene Adlei MacGhabhann', 'Rifle, Magelock (2H)', 'Equipment', 'Starting Gunmage', '1', '', '', 'Ranged', '000'),
  55. (NULL, 'Regene Adlei MacGhabhann', 'Rifle, Magelock (1H)', 'Equipment', 'Starting Gunmage', '0', '', '', 'Ranged', '000'),
  56. (NULL, 'Regene Adlei MacGhabhann', 'Firearm Ammunition (Rune Shots)', 'Equipment', 'Starting Gunmage', '10', '', '', '', '000'),
  57. (NULL, 'Regene Adlei MacGhabhann', 'Warcaster Armor, Medium', 'Equipment', 'Starting Gunmage', '1', '', '', 'Armor', '000'),
  58. (NULL, 'Regene Adlei MacGhabhann', 'Ammo Bandolier', 'Equipment', 'Starting Gunmage', '1', '', '', '', '000'),
  59. (NULL, 'Regene Adlei MacGhabhann', 'Rune Shot Casting Kit', 'Equipment', 'Starting Gunmage', '1', '', '', '', '000'),
  60. (NULL, 'Regene Adlei MacGhabhann', 'Trench Knife (U)', 'Equipment', 'Initial Purchase', '1', '', '', 'Melee', '000'),
  61. (NULL, 'Regene Adlei MacGhabhann', 'Trench Knife (HW)', 'Equipment', 'Initial Purchase', '0', '', '', 'Melee', '000'),
  62. (NULL, 'Regene Adlei MacGhabhann', 'Coin Crown', 'Equipment', 'Purchase Trench Knife', '-10', '', '', '', '000'),
  63.  
  64. From:
  65.  
  66. Race: Human (Cygnaran, Midlunder) -> ('Human', 'Race', 'Cygnaran, Midlunder', '', '', '', '', '000'),
  67. Archetype: Gifted -> ('Gifted', 'Archetype', 'Starting', '', '', '', '', '000'),
  68. Career 1: Warcaster -> ('Career', 'Warcaster', 'Starting', '', '', '', '', '000'),
  69. Career 2: Gun Mage -> ('Career', 'Gunmage', 'Starting', '', '', '', '', '000'),
  70. Archetype Benefit: Magic Sensitivity
  71. Language: Cygnaran [Starting Human]
  72. Language: Llaelese [Starting Human]
  73. Language: Ordic [Starting Human; Houserule]
  74. Stats Upgrade: PHY [Starting Human; Houserule]
  75. Stats Upgrade: AGL [Starting Human; Houserule]
  76. Stats Upgrade: INT [Starting Human; Houserule]
  77. Stats Upgrade: Arc [Starting PC]
  78. Stats Upgrade: Arc [Starting PC]
  79. Stats Upgrade: Poi [Starting PC]
  80. Ability: Bond [Starting Warcaster]
  81. Ability: Craft Rune Shot [Starting Gun Mage]
  82. Ability: Fast Reload [Starting Gun Mage]
  83. Ability: Bond [Starting Human; Houserule]
  84. Spell: Boundless Charge [Starting Warcaster]
  85. Spell: Refuge [Starting Warcaster; Swap with Convection]
  86. Spell: Rune Shot: Accuracy [Starting Gun Mage]
  87. Spell: Rune Shot: Brutal [Starting Gun Mage]
  88. Spell: Rune Shot: Thunderbolt [Starting Gun Mage]
  89. Military: Hand Weapon [Starting Warcaster]
  90. Military: Unarmed Combat [Starting Warcaster; Swap with Pistol]
  91. Military: Rifle [Starting Gun Mage]
  92. Occupational: Detection [Starting Warcaster]
  93. Occupational: Lore (Thamarite Cultist) [Starting Warcaster; Swap with Command]
  94. Occupational: Detection [Starting Gun Mage]
  95. Occupational: Intimidation [Starting Gun Mage]
  96. Occupational: Sneak [Starting Human; Houserule]
  97. Equipments: Medium Warcaster Armor [Starting Warcaster]
  98. Equipments: Coin Crown - 25gc [Starting Gun Mage]
  99. Equipments: Rifle, Magelock - 1 [Starting Gun Mage]
  100. Equipments: Firearms Ammunition (Rune Shots) - 10 [Starting Gun Mage]
  101. Equipments: Ammo Bandolier - 1 [Starting Gun Mage]
  102. Equipments: Rune Shot Casting Kit [Starting Gun Mage]
  103. Equipments: Trench Knife [Starting Purchase]
Advertisement
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!