API tools faq
paste
Advertisement
D3Reap3R

Tutorial: SQL Queries

D3Reap3R
Jan 9th, 2013
294
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 26.56 KB | None | 0 0
raw download clone embed print report
  1. SET @CLASS = 12;
  2. SET @RACE = 1;
  3. SET @MAP = 0;
  4. SET @ZONE = 12;
  5. SET @POSX = -8949.95;
  6. SET @POSY = -132.493;
  7. SET @POSZ = 83.5312;
  8. SET @POSO = 0;
  9. DELETE FROM `playercreateinfo` WHERE (race = @RACE AND class = @CLASS);
  10. INSERT INTO `playercreateinfo` (`race`, `class`, `map`, `zone`, `position_x`, `position_y`, `position_z`, `orientation`) VALUES (@RACE, @CLASS, @MAP, @ZONE, @POSX, @POSY, @POSZ, @POSO);
  11. DELETE FROM `playercreateinfo_action` WHERE (race = @RACE AND class = @CLASS);
  12. INSERT INTO `playercreateinfo_action` (`race`, `class`, `button`, `action`, `type`) VALUES (@RACE, @CLASS, 0, 6603, 0);
  13. INSERT INTO `playercreateinfo_action` (`race`, `class`, `button`, `action`, `type`) VALUES (@RACE, @CLASS, 72, 6603, 0);
  14. INSERT INTO `playercreateinfo_action` (`race`, `class`, `button`, `action`, `type`) VALUES (@RACE, @CLASS, 73, 78, 0);
  15. INSERT INTO `playercreateinfo_action` (`race`, `class`, `button`, `action`, `type`) VALUES (@RACE, @CLASS, 82, 59752, 0);
  16. INSERT INTO `playercreateinfo_action` (`race`, `class`, `button`, `action`, `type`) VALUES (@RACE, @CLASS, 84, 6603, 0);
  17. INSERT INTO `playercreateinfo_action` (`race`, `class`, `button`, `action`, `type`) VALUES (@RACE, @CLASS, 96, 6603, 0);
  18. INSERT INTO `playercreateinfo_action` (`race`, `class`, `button`, `action`, `type`) VALUES (@RACE, @CLASS, 108, 6603, 0);
  19. DELETE FROM `playercreateinfo_spell` WHERE (race = @RACE AND class = @CLASS);
  20. INSERT INTO `playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES (@RACE, @CLASS, 61437, 'Opening');
  21. INSERT INTO `playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES (@RACE, @CLASS, 20597, 'Sword Specialization');
  22. INSERT INTO `playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES (@RACE, @CLASS, 9125, 'Generic');
  23. INSERT INTO `playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES (@RACE, @CLASS, 9116, 'Shield');
  24. INSERT INTO `playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES (@RACE, @CLASS, 9078, 'Cloth');
  25. INSERT INTO `playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES (@RACE, @CLASS, 9077, 'Leather');
  26. INSERT INTO `playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES (@RACE, @CLASS, 8737, 'Mail');
  27. INSERT INTO `playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES (@RACE, @CLASS, 8386, 'Attacking');
  28. INSERT INTO `playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES (@RACE, @CLASS, 7355, 'Stuck');
  29. INSERT INTO `playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES (@RACE, @CLASS, 7267, 'Grovel');
  30. INSERT INTO `playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES (@RACE, @CLASS, 20598, 'The Human Spirit');
  31. INSERT INTO `playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES (@RACE, @CLASS, 20599, 'Diplomacy');
  32. INSERT INTO `playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES (@RACE, @CLASS, 59752, 'Every Man for Himself');
  33. INSERT INTO `playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES (@RACE, @CLASS, 58985, 'Perception');
  34. INSERT INTO `playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES (@RACE, @CLASS, 45927, 'Summon Friend');
  35. INSERT INTO `playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES (@RACE, @CLASS, 32215, 'Victorious State');
  36. INSERT INTO `playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES (@RACE, @CLASS, 22810, 'Opening - No Text');
  37. INSERT INTO `playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES (@RACE, @CLASS, 22027, 'Remove Insignia');
  38. INSERT INTO `playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES (@RACE, @CLASS, 21652, 'Closing');
  39. INSERT INTO `playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES (@RACE, @CLASS, 21651, 'Opening');
  40. INSERT INTO `playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES (@RACE, @CLASS, 20864, 'Mace Specialization');
  41. INSERT INTO `playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES (@RACE, @CLASS, 7266, 'Duel');
  42. INSERT INTO `playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES (@RACE, @CLASS, 6603, 'Attack');
  43. INSERT INTO `playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES (@RACE, @CLASS, 78, 'Heroic Strike');
  44. INSERT INTO `playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES (@RACE, @CLASS, 668, 'Language Common');
  45. INSERT INTO `playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES (@RACE, @CLASS, 522, 'SPELLDEFENSE (DND)');
  46. INSERT INTO `playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES (@RACE, @CLASS, 204, 'Defense');
  47. INSERT INTO `playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES (@RACE, @CLASS, 203, 'Unarmed');
  48. INSERT INTO `playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES (@RACE, @CLASS, 201, 'One-Handed Swords');
  49. INSERT INTO `playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES (@RACE, @CLASS, 198, 'One-Handed Maces');
  50. INSERT INTO `playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES (@RACE, @CLASS, 196, 'One-Handed Axes');
  51. INSERT INTO `playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES (@RACE, @CLASS, 107, 'Block');
  52. INSERT INTO `playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES (@RACE, @CLASS, 81, 'Dodge');
  53. INSERT INTO `playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES (@RACE, @CLASS, 1843, 'Disarm');
  54. INSERT INTO `playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES (@RACE, @CLASS, 2382, 'Generic');
  55. INSERT INTO `playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES (@RACE, @CLASS, 6478, 'Opening');
  56. INSERT INTO `playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES (@RACE, @CLASS, 6477, 'Opening');
  57. INSERT INTO `playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES (@RACE, @CLASS, 6247, 'Opening');
  58. INSERT INTO `playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES (@RACE, @CLASS, 6246, 'Closing');
  59. INSERT INTO `playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES (@RACE, @CLASS, 6233, 'Closing');
  60. INSERT INTO `playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES (@RACE, @CLASS, 5301, 'Defensive State (DND)');
  61. INSERT INTO `playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES (@RACE, @CLASS, 3365, 'Opening');
  62. INSERT INTO `playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES (@RACE, @CLASS, 3050, 'Detect');
  63. INSERT INTO `playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES (@RACE, @CLASS, 2479, 'Honorless Target');
  64. INSERT INTO `playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES (@RACE, @CLASS, 2457, 'Battle Stance');
  65. INSERT INTO `playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES (@RACE, @CLASS, 202, 'Two-Handed Swords');
  66. DELETE FROM `player_classlevelstats` WHERE class = @CLASS;
  67. INSERT INTO `player_classlevelstats` (`class`, `level`, `basehp`, `basemana`) VALUES (@CLASS, 1, 20, 0);
  68. INSERT INTO `player_classlevelstats` (`class`, `level`, `basehp`, `basemana`) VALUES (@CLASS, 2, 29, 0);
  69. INSERT INTO `player_classlevelstats` (`class`, `level`, `basehp`, `basemana`) VALUES (@CLASS, 3, 38, 0);
  70. INSERT INTO `player_classlevelstats` (`class`, `level`, `basehp`, `basemana`) VALUES (@CLASS, 4, 47, 0);
  71. INSERT INTO `player_classlevelstats` (`class`, `level`, `basehp`, `basemana`) VALUES (@CLASS, 5, 56, 0);
  72. INSERT INTO `player_classlevelstats` (`class`, `level`, `basehp`, `basemana`) VALUES (@CLASS, 6, 65, 0);
  73. INSERT INTO `player_classlevelstats` (`class`, `level`, `basehp`, `basemana`) VALUES (@CLASS, 7, 74, 0);
  74. INSERT INTO `player_classlevelstats` (`class`, `level`, `basehp`, `basemana`) VALUES (@CLASS, 8, 83, 0);
  75. INSERT INTO `player_classlevelstats` (`class`, `level`, `basehp`, `basemana`) VALUES (@CLASS, 9, 92, 0);
  76. INSERT INTO `player_classlevelstats` (`class`, `level`, `basehp`, `basemana`) VALUES (@CLASS, 10, 101, 0);
  77. INSERT INTO `player_classlevelstats` (`class`, `level`, `basehp`, `basemana`) VALUES (@CLASS, 11, 100, 0);
  78. INSERT INTO `player_classlevelstats` (`class`, `level`, `basehp`, `basemana`) VALUES (@CLASS, 12, 109, 0);
  79. INSERT INTO `player_classlevelstats` (`class`, `level`, `basehp`, `basemana`) VALUES (@CLASS, 13, 118, 0);
  80. INSERT INTO `player_classlevelstats` (`class`, `level`, `basehp`, `basemana`) VALUES (@CLASS, 14, 128, 0);
  81. INSERT INTO `player_classlevelstats` (`class`, `level`, `basehp`, `basemana`) VALUES (@CLASS, 15, 139, 0);
  82. INSERT INTO `player_classlevelstats` (`class`, `level`, `basehp`, `basemana`) VALUES (@CLASS, 16, 151, 0);
  83. INSERT INTO `player_classlevelstats` (`class`, `level`, `basehp`, `basemana`) VALUES (@CLASS, 17, 154, 0);
  84. INSERT INTO `player_classlevelstats` (`class`, `level`, `basehp`, `basemana`) VALUES (@CLASS, 18, 168, 0);
  85. INSERT INTO `player_classlevelstats` (`class`, `level`, `basehp`, `basemana`) VALUES (@CLASS, 19, 183, 0);
  86. INSERT INTO `player_classlevelstats` (`class`, `level`, `basehp`, `basemana`) VALUES (@CLASS, 20, 199, 0);
  87. INSERT INTO `player_classlevelstats` (`class`, `level`, `basehp`, `basemana`) VALUES (@CLASS, 21, 206, 0);
  88. INSERT INTO `player_classlevelstats` (`class`, `level`, `basehp`, `basemana`) VALUES (@CLASS, 22, 224, 0);
  89. INSERT INTO `player_classlevelstats` (`class`, `level`, `basehp`, `basemana`) VALUES (@CLASS, 23, 243, 0);
  90. INSERT INTO `player_classlevelstats` (`class`, `level`, `basehp`, `basemana`) VALUES (@CLASS, 24, 253, 0);
  91. INSERT INTO `player_classlevelstats` (`class`, `level`, `basehp`, `basemana`) VALUES (@CLASS, 25, 274, 0);
  92. INSERT INTO `player_classlevelstats` (`class`, `level`, `basehp`, `basemana`) VALUES (@CLASS, 26, 296, 0);
  93. INSERT INTO `player_classlevelstats` (`class`, `level`, `basehp`, `basemana`) VALUES (@CLASS, 27, 309, 0);
  94. INSERT INTO `player_classlevelstats` (`class`, `level`, `basehp`, `basemana`) VALUES (@CLASS, 28, 333, 0);
  95. INSERT INTO `player_classlevelstats` (`class`, `level`, `basehp`, `basemana`) VALUES (@CLASS, 29, 348, 0);
  96. INSERT INTO `player_classlevelstats` (`class`, `level`, `basehp`, `basemana`) VALUES (@CLASS, 30, 374, 0);
  97. INSERT INTO `player_classlevelstats` (`class`, `level`, `basehp`, `basemana`) VALUES (@CLASS, 31, 401, 0);
  98. INSERT INTO `player_classlevelstats` (`class`, `level`, `basehp`, `basemana`) VALUES (@CLASS, 32, 419, 0);
  99. INSERT INTO `player_classlevelstats` (`class`, `level`, `basehp`, `basemana`) VALUES (@CLASS, 33, 448, 0);
  100. INSERT INTO `player_classlevelstats` (`class`, `level`, `basehp`, `basemana`) VALUES (@CLASS, 34, 468, 0);
  101. INSERT INTO `player_classlevelstats` (`class`, `level`, `basehp`, `basemana`) VALUES (@CLASS, 35, 499, 0);
  102. INSERT INTO `player_classlevelstats` (`class`, `level`, `basehp`, `basemana`) VALUES (@CLASS, 36, 521, 0);
  103. INSERT INTO `player_classlevelstats` (`class`, `level`, `basehp`, `basemana`) VALUES (@CLASS, 37, 545, 0);
  104. INSERT INTO `player_classlevelstats` (`class`, `level`, `basehp`, `basemana`) VALUES (@CLASS, 38, 581, 0);
  105. INSERT INTO `player_classlevelstats` (`class`, `level`, `basehp`, `basemana`) VALUES (@CLASS, 39, 609, 0);
  106. INSERT INTO `player_classlevelstats` (`class`, `level`, `basehp`, `basemana`) VALUES (@CLASS, 40, 649, 0);
  107. INSERT INTO `player_classlevelstats` (`class`, `level`, `basehp`, `basemana`) VALUES (@CLASS, 41, 681, 0);
  108. INSERT INTO `player_classlevelstats` (`class`, `level`, `basehp`, `basemana`) VALUES (@CLASS, 42, 715, 0);
  109. INSERT INTO `player_classlevelstats` (`class`, `level`, `basehp`, `basemana`) VALUES (@CLASS, 43, 761, 0);
  110. INSERT INTO `player_classlevelstats` (`class`, `level`, `basehp`, `basemana`) VALUES (@CLASS, 44, 799, 0);
  111. INSERT INTO `player_classlevelstats` (`class`, `level`, `basehp`, `basemana`) VALUES (@CLASS, 45, 839, 0);
  112. INSERT INTO `player_classlevelstats` (`class`, `level`, `basehp`, `basemana`) VALUES (@CLASS, 46, 881, 0);
  113. INSERT INTO `player_classlevelstats` (`class`, `level`, `basehp`, `basemana`) VALUES (@CLASS, 47, 935, 0);
  114. INSERT INTO `player_classlevelstats` (`class`, `level`, `basehp`, `basemana`) VALUES (@CLASS, 48, 981, 0);
  115. INSERT INTO `player_classlevelstats` (`class`, `level`, `basehp`, `basemana`) VALUES (@CLASS, 49, 1029, 0);
  116. INSERT INTO `player_classlevelstats` (`class`, `level`, `basehp`, `basemana`) VALUES (@CLASS, 50, 1079, 0);
  117. INSERT INTO `player_classlevelstats` (`class`, `level`, `basehp`, `basemana`) VALUES (@CLASS, 51, 1131, 0);
  118. INSERT INTO `player_classlevelstats` (`class`, `level`, `basehp`, `basemana`) VALUES (@CLASS, 52, 1185, 0);
  119. INSERT INTO `player_classlevelstats` (`class`, `level`, `basehp`, `basemana`) VALUES (@CLASS, 53, 1241, 0);
  120. INSERT INTO `player_classlevelstats` (`class`, `level`, `basehp`, `basemana`) VALUES (@CLASS, 54, 1299, 0);
  121. INSERT INTO `player_classlevelstats` (`class`, `level`, `basehp`, `basemana`) VALUES (@CLASS, 55, 1359, 0);
  122. INSERT INTO `player_classlevelstats` (`class`, `level`, `basehp`, `basemana`) VALUES (@CLASS, 56, 1421, 0);
  123. INSERT INTO `player_classlevelstats` (`class`, `level`, `basehp`, `basemana`) VALUES (@CLASS, 57, 1485, 0);
  124. INSERT INTO `player_classlevelstats` (`class`, `level`, `basehp`, `basemana`) VALUES (@CLASS, 58, 1551, 0);
  125. INSERT INTO `player_classlevelstats` (`class`, `level`, `basehp`, `basemana`) VALUES (@CLASS, 59, 1619, 0);
  126. INSERT INTO `player_classlevelstats` (`class`, `level`, `basehp`, `basemana`) VALUES (@CLASS, 60, 1689, 0);
  127. INSERT INTO `player_classlevelstats` (`class`, `level`, `basehp`, `basemana`) VALUES (@CLASS, 61, 1902, 0);
  128. INSERT INTO `player_classlevelstats` (`class`, `level`, `basehp`, `basemana`) VALUES (@CLASS, 62, 2129, 0);
  129. INSERT INTO `player_classlevelstats` (`class`, `level`, `basehp`, `basemana`) VALUES (@CLASS, 63, 2357, 0);
  130. INSERT INTO `player_classlevelstats` (`class`, `level`, `basehp`, `basemana`) VALUES (@CLASS, 64, 2612, 0);
  131. INSERT INTO `player_classlevelstats` (`class`, `level`, `basehp`, `basemana`) VALUES (@CLASS, 65, 2883, 0);
  132. INSERT INTO `player_classlevelstats` (`class`, `level`, `basehp`, `basemana`) VALUES (@CLASS, 66, 3169, 0);
  133. INSERT INTO `player_classlevelstats` (`class`, `level`, `basehp`, `basemana`) VALUES (@CLASS, 67, 3455, 0);
  134. INSERT INTO `player_classlevelstats` (`class`, `level`, `basehp`, `basemana`) VALUES (@CLASS, 68, 3774, 0);
  135. INSERT INTO `player_classlevelstats` (`class`, `level`, `basehp`, `basemana`) VALUES (@CLASS, 69, 4109, 0);
  136. INSERT INTO `player_classlevelstats` (`class`, `level`, `basehp`, `basemana`) VALUES (@CLASS, 70, 4444, 0);
  137. INSERT INTO `player_classlevelstats` (`class`, `level`, `basehp`, `basemana`) VALUES (@CLASS, 71, 4720, 0);
  138. INSERT INTO `player_classlevelstats` (`class`, `level`, `basehp`, `basemana`) VALUES (@CLASS, 72, 5013, 0);
  139. INSERT INTO `player_classlevelstats` (`class`, `level`, `basehp`, `basemana`) VALUES (@CLASS, 73, 5325, 0);
  140. INSERT INTO `player_classlevelstats` (`class`, `level`, `basehp`, `basemana`) VALUES (@CLASS, 74, 5656, 0);
  141. INSERT INTO `player_classlevelstats` (`class`, `level`, `basehp`, `basemana`) VALUES (@CLASS, 75, 6008, 0);
  142. INSERT INTO `player_classlevelstats` (`class`, `level`, `basehp`, `basemana`) VALUES (@CLASS, 76, 6381, 0);
  143. INSERT INTO `player_classlevelstats` (`class`, `level`, `basehp`, `basemana`) VALUES (@CLASS, 77, 6778, 0);
  144. INSERT INTO `player_classlevelstats` (`class`, `level`, `basehp`, `basemana`) VALUES (@CLASS, 78, 7198, 0);
  145. INSERT INTO `player_classlevelstats` (`class`, `level`, `basehp`, `basemana`) VALUES (@CLASS, 79, 7646, 0);
  146. INSERT INTO `player_classlevelstats` (`class`, `level`, `basehp`, `basemana`) VALUES (@CLASS, 80, 8121, 0);
  147. DELETE FROM `player_levelstats` WHERE (race = @RACE AND class = @CLASS);
  148. INSERT INTO `player_levelstats` (`race`, `class`, `level`, `str`, `agi`, `sta`, `inte`, `spi`) VALUES (@RACE, @CLASS, 1, 23, 20, 22, 20, 20);
  149. INSERT INTO `player_levelstats` (`race`, `class`, `level`, `str`, `agi`, `sta`, `inte`, `spi`) VALUES (@RACE, @CLASS, 2, 24, 21, 23, 20, 20);
  150. INSERT INTO `player_levelstats` (`race`, `class`, `level`, `str`, `agi`, `sta`, `inte`, `spi`) VALUES (@RACE, @CLASS, 3, 26, 22, 24, 20, 21);
  151. INSERT INTO `player_levelstats` (`race`, `class`, `level`, `str`, `agi`, `sta`, `inte`, `spi`) VALUES (@RACE, @CLASS, 4, 27, 22, 26, 20, 21);
  152. INSERT INTO `player_levelstats` (`race`, `class`, `level`, `str`, `agi`, `sta`, `inte`, `spi`) VALUES (@RACE, @CLASS, 5, 28, 23, 27, 20, 21);
  153. INSERT INTO `player_levelstats` (`race`, `class`, `level`, `str`, `agi`, `sta`, `inte`, `spi`) VALUES (@RACE, @CLASS, 6, 30, 24, 28, 20, 21);
  154. INSERT INTO `player_levelstats` (`race`, `class`, `level`, `str`, `agi`, `sta`, `inte`, `spi`) VALUES (@RACE, @CLASS, 7, 31, 25, 29, 21, 22);
  155. INSERT INTO `player_levelstats` (`race`, `class`, `level`, `str`, `agi`, `sta`, `inte`, `spi`) VALUES (@RACE, @CLASS, 8, 32, 26, 30, 21, 22);
  156. INSERT INTO `player_levelstats` (`race`, `class`, `level`, `str`, `agi`, `sta`, `inte`, `spi`) VALUES (@RACE, @CLASS, 9, 34, 26, 32, 21, 22);
  157. INSERT INTO `player_levelstats` (`race`, `class`, `level`, `str`, `agi`, `sta`, `inte`, `spi`) VALUES (@RACE, @CLASS, 10, 35, 27, 33, 21, 23);
  158. INSERT INTO `player_levelstats` (`race`, `class`, `level`, `str`, `agi`, `sta`, `inte`, `spi`) VALUES (@RACE, @CLASS, 11, 36, 28, 34, 21, 23);
  159. INSERT INTO `player_levelstats` (`race`, `class`, `level`, `str`, `agi`, `sta`, `inte`, `spi`) VALUES (@RACE, @CLASS, 12, 38, 29, 35, 21, 23);
  160. INSERT INTO `player_levelstats` (`race`, `class`, `level`, `str`, `agi`, `sta`, `inte`, `spi`) VALUES (@RACE, @CLASS, 13, 39, 30, 37, 21, 24);
  161. INSERT INTO `player_levelstats` (`race`, `class`, `level`, `str`, `agi`, `sta`, `inte`, `spi`) VALUES (@RACE, @CLASS, 14, 41, 31, 38, 21, 24);
  162. INSERT INTO `player_levelstats` (`race`, `class`, `level`, `str`, `agi`, `sta`, `inte`, `spi`) VALUES (@RACE, @CLASS, 15, 42, 32, 39, 21, 24);
  163. INSERT INTO `player_levelstats` (`race`, `class`, `level`, `str`, `agi`, `sta`, `inte`, `spi`) VALUES (@RACE, @CLASS, 16, 44, 33, 41, 21, 25);
  164. INSERT INTO `player_levelstats` (`race`, `class`, `level`, `str`, `agi`, `sta`, `inte`, `spi`) VALUES (@RACE, @CLASS, 17, 45, 34, 42, 22, 25);
  165. INSERT INTO `player_levelstats` (`race`, `class`, `level`, `str`, `agi`, `sta`, `inte`, `spi`) VALUES (@RACE, @CLASS, 18, 47, 34, 43, 22, 25);
  166. INSERT INTO `player_levelstats` (`race`, `class`, `level`, `str`, `agi`, `sta`, `inte`, `spi`) VALUES (@RACE, @CLASS, 19, 48, 35, 45, 22, 26);
  167. INSERT INTO `player_levelstats` (`race`, `class`, `level`, `str`, `agi`, `sta`, `inte`, `spi`) VALUES (@RACE, @CLASS, 20, 50, 36, 46, 22, 26);
  168. INSERT INTO `player_levelstats` (`race`, `class`, `level`, `str`, `agi`, `sta`, `inte`, `spi`) VALUES (@RACE, @CLASS, 21, 51, 37, 48, 22, 26);
  169. INSERT INTO `player_levelstats` (`race`, `class`, `level`, `str`, `agi`, `sta`, `inte`, `spi`) VALUES (@RACE, @CLASS, 22, 53, 38, 49, 22, 27);
  170. INSERT INTO `player_levelstats` (`race`, `class`, `level`, `str`, `agi`, `sta`, `inte`, `spi`) VALUES (@RACE, @CLASS, 23, 54, 39, 51, 22, 27);
  171. INSERT INTO `player_levelstats` (`race`, `class`, `level`, `str`, `agi`, `sta`, `inte`, `spi`) VALUES (@RACE, @CLASS, 24, 56, 40, 52, 23, 28);
  172. INSERT INTO `player_levelstats` (`race`, `class`, `level`, `str`, `agi`, `sta`, `inte`, `spi`) VALUES (@RACE, @CLASS, 25, 58, 41, 53, 23, 28);
  173. INSERT INTO `player_levelstats` (`race`, `class`, `level`, `str`, `agi`, `sta`, `inte`, `spi`) VALUES (@RACE, @CLASS, 26, 59, 42, 55, 23, 28);
  174. INSERT INTO `player_levelstats` (`race`, `class`, `level`, `str`, `agi`, `sta`, `inte`, `spi`) VALUES (@RACE, @CLASS, 27, 61, 43, 56, 23, 29);
  175. INSERT INTO `player_levelstats` (`race`, `class`, `level`, `str`, `agi`, `sta`, `inte`, `spi`) VALUES (@RACE, @CLASS, 28, 63, 44, 58, 23, 29);
  176. INSERT INTO `player_levelstats` (`race`, `class`, `level`, `str`, `agi`, `sta`, `inte`, `spi`) VALUES (@RACE, @CLASS, 29, 64, 45, 59, 23, 30);
  177. INSERT INTO `player_levelstats` (`race`, `class`, `level`, `str`, `agi`, `sta`, `inte`, `spi`) VALUES (@RACE, @CLASS, 30, 66, 46, 61, 24, 30);
  178. INSERT INTO `player_levelstats` (`race`, `class`, `level`, `str`, `agi`, `sta`, `inte`, `spi`) VALUES (@RACE, @CLASS, 31, 68, 47, 62, 24, 30);
  179. INSERT INTO `player_levelstats` (`race`, `class`, `level`, `str`, `agi`, `sta`, `inte`, `spi`) VALUES (@RACE, @CLASS, 32, 69, 48, 64, 24, 31);
  180. INSERT INTO `player_levelstats` (`race`, `class`, `level`, `str`, `agi`, `sta`, `inte`, `spi`) VALUES (@RACE, @CLASS, 33, 71, 50, 66, 24, 31);
  181. INSERT INTO `player_levelstats` (`race`, `class`, `level`, `str`, `agi`, `sta`, `inte`, `spi`) VALUES (@RACE, @CLASS, 34, 73, 51, 67, 24, 32);
  182. INSERT INTO `player_levelstats` (`race`, `class`, `level`, `str`, `agi`, `sta`, `inte`, `spi`) VALUES (@RACE, @CLASS, 35, 74, 52, 69, 24, 32);
  183. INSERT INTO `player_levelstats` (`race`, `class`, `level`, `str`, `agi`, `sta`, `inte`, `spi`) VALUES (@RACE, @CLASS, 36, 76, 53, 70, 25, 33);
  184. INSERT INTO `player_levelstats` (`race`, `class`, `level`, `str`, `agi`, `sta`, `inte`, `spi`) VALUES (@RACE, @CLASS, 37, 78, 54, 72, 25, 33);
  185. INSERT INTO `player_levelstats` (`race`, `class`, `level`, `str`, `agi`, `sta`, `inte`, `spi`) VALUES (@RACE, @CLASS, 38, 80, 55, 74, 25, 34);
  186. INSERT INTO `player_levelstats` (`race`, `class`, `level`, `str`, `agi`, `sta`, `inte`, `spi`) VALUES (@RACE, @CLASS, 39, 82, 56, 75, 25, 34);
  187. INSERT INTO `player_levelstats` (`race`, `class`, `level`, `str`, `agi`, `sta`, `inte`, `spi`) VALUES (@RACE, @CLASS, 40, 83, 57, 77, 25, 35);
  188. INSERT INTO `player_levelstats` (`race`, `class`, `level`, `str`, `agi`, `sta`, `inte`, `spi`) VALUES (@RACE, @CLASS, 41, 85, 58, 79, 26, 35);
  189. INSERT INTO `player_levelstats` (`race`, `class`, `level`, `str`, `agi`, `sta`, `inte`, `spi`) VALUES (@RACE, @CLASS, 42, 87, 60, 80, 26, 35);
  190. INSERT INTO `player_levelstats` (`race`, `class`, `level`, `str`, `agi`, `sta`, `inte`, `spi`) VALUES (@RACE, @CLASS, 43, 89, 61, 82, 26, 36);
  191. INSERT INTO `player_levelstats` (`race`, `class`, `level`, `str`, `agi`, `sta`, `inte`, `spi`) VALUES (@RACE, @CLASS, 44, 91, 62, 84, 26, 36);
  192. INSERT INTO `player_levelstats` (`race`, `class`, `level`, `str`, `agi`, `sta`, `inte`, `spi`) VALUES (@RACE, @CLASS, 45, 93, 63, 85, 26, 37);
  193. INSERT INTO `player_levelstats` (`race`, `class`, `level`, `str`, `agi`, `sta`, `inte`, `spi`) VALUES (@RACE, @CLASS, 46, 95, 64, 87, 27, 37);
  194. INSERT INTO `player_levelstats` (`race`, `class`, `level`, `str`, `agi`, `sta`, `inte`, `spi`) VALUES (@RACE, @CLASS, 47, 97, 66, 89, 27, 38);
  195. INSERT INTO `player_levelstats` (`race`, `class`, `level`, `str`, `agi`, `sta`, `inte`, `spi`) VALUES (@RACE, @CLASS, 48, 99, 67, 91, 27, 38);
  196. INSERT INTO `player_levelstats` (`race`, `class`, `level`, `str`, `agi`, `sta`, `inte`, `spi`) VALUES (@RACE, @CLASS, 49, 101, 68, 93, 27, 39);
  197. INSERT INTO `player_levelstats` (`race`, `class`, `level`, `str`, `agi`, `sta`, `inte`, `spi`) VALUES (@RACE, @CLASS, 50, 103, 69, 94, 28, 40);
  198. INSERT INTO `player_levelstats` (`race`, `class`, `level`, `str`, `agi`, `sta`, `inte`, `spi`) VALUES (@RACE, @CLASS, 51, 105, 71, 96, 28, 40);
  199. INSERT INTO `player_levelstats` (`race`, `class`, `level`, `str`, `agi`, `sta`, `inte`, `spi`) VALUES (@RACE, @CLASS, 52, 107, 72, 98, 28, 41);
  200. INSERT INTO `player_levelstats` (`race`, `class`, `level`, `str`, `agi`, `sta`, `inte`, `spi`) VALUES (@RACE, @CLASS, 53, 109, 73, 100, 28, 41);
  201. INSERT INTO `player_levelstats` (`race`, `class`, `level`, `str`, `agi`, `sta`, `inte`, `spi`) VALUES (@RACE, @CLASS, 54, 111, 74, 102, 29, 42);
  202. INSERT INTO `player_levelstats` (`race`, `class`, `level`, `str`, `agi`, `sta`, `inte`, `spi`) VALUES (@RACE, @CLASS, 55, 113, 76, 103, 29, 42);
  203. INSERT INTO `player_levelstats` (`race`, `class`, `level`, `str`, `agi`, `sta`, `inte`, `spi`) VALUES (@RACE, @CLASS, 56, 115, 77, 105, 29, 43);
  204. INSERT INTO `player_levelstats` (`race`, `class`, `level`, `str`, `agi`, `sta`, `inte`, `spi`) VALUES (@RACE, @CLASS, 57, 117, 78, 107, 29, 43);
  205. INSERT INTO `player_levelstats` (`race`, `class`, `level`, `str`, `agi`, `sta`, `inte`, `spi`) VALUES (@RACE, @CLASS, 58, 119, 79, 109, 30, 44);
  206. INSERT INTO `player_levelstats` (`race`, `class`, `level`, `str`, `agi`, `sta`, `inte`, `spi`) VALUES (@RACE, @CLASS, 59, 121, 81, 111, 30, 44);
  207. INSERT INTO `player_levelstats` (`race`, `class`, `level`, `str`, `agi`, `sta`, `inte`, `spi`) VALUES (@RACE, @CLASS, 60, 123, 82, 113, 30, 45);
  208. INSERT INTO `player_levelstats` (`race`, `class`, `level`, `str`, `agi`, `sta`, `inte`, `spi`) VALUES (@RACE, @CLASS, 61, 125, 83, 115, 30, 46);
  209. INSERT INTO `player_levelstats` (`race`, `class`, `level`, `str`, `agi`, `sta`, `inte`, `spi`) VALUES (@RACE, @CLASS, 62, 127, 85, 117, 31, 46);
  210. INSERT INTO `player_levelstats` (`race`, `class`, `level`, `str`, `agi`, `sta`, `inte`, `spi`) VALUES (@RACE, @CLASS, 63, 129, 86, 119, 31, 47);
  211. INSERT INTO `player_levelstats` (`race`, `class`, `level`, `str`, `agi`, `sta`, `inte`, `spi`) VALUES (@RACE, @CLASS, 64, 132, 88, 121, 31, 47);
  212. INSERT INTO `player_levelstats` (`race`, `class`, `level`, `str`, `agi`, `sta`, `inte`, `spi`) VALUES (@RACE, @CLASS, 65, 134, 89, 123, 32, 48);
  213. INSERT INTO `player_levelstats` (`race`, `class`, `level`, `str`, `agi`, `sta`, `inte`, `spi`) VALUES (@RACE, @CLASS, 66, 136, 90, 125, 32, 49);
  214. INSERT INTO `player_levelstats` (`race`, `class`, `level`, `str`, `agi`, `sta`, `inte`, `spi`) VALUES (@RACE, @CLASS, 67, 138, 92, 127, 32, 49);
  215. INSERT INTO `player_levelstats` (`race`, `class`, `level`, `str`, `agi`, `sta`, `inte`, `spi`) VALUES (@RACE, @CLASS, 68, 140, 93, 129, 32, 50);
  216. INSERT INTO `player_levelstats` (`race`, `class`, `level`, `str`, `agi`, `sta`, `inte`, `spi`) VALUES (@RACE, @CLASS, 69, 143, 95, 131, 33, 50);
  217. INSERT INTO `player_levelstats` (`race`, `class`, `level`, `str`, `agi`, `sta`, `inte`, `spi`) VALUES (@RACE, @CLASS, 70, 145, 96, 133, 33, 51);
  218. INSERT INTO `player_levelstats` (`race`, `class`, `level`, `str`, `agi`, `sta`, `inte`, `spi`) VALUES (@RACE, @CLASS, 71, 148, 97, 140, 33, 53);
  219. INSERT INTO `player_levelstats` (`race`, `class`, `level`, `str`, `agi`, `sta`, `inte`, `spi`) VALUES (@RACE, @CLASS, 72, 156, 99, 143, 33, 54);
  220. INSERT INTO `player_levelstats` (`race`, `class`, `level`, `str`, `agi`, `sta`, `inte`, `spi`) VALUES (@RACE, @CLASS, 73, 162, 101, 148, 33, 55);
  221. INSERT INTO `player_levelstats` (`race`, `class`, `level`, `str`, `agi`, `sta`, `inte`, `spi`) VALUES (@RACE, @CLASS, 74, 162, 102, 148, 34, 55);
  222. INSERT INTO `player_levelstats` (`race`, `class`, `level`, `str`, `agi`, `sta`, `inte`, `spi`) VALUES (@RACE, @CLASS, 75, 165, 104, 150, 34, 56);
  223. INSERT INTO `player_levelstats` (`race`, `class`, `level`, `str`, `agi`, `sta`, `inte`, `spi`) VALUES (@RACE, @CLASS, 76, 171, 106, 156, 34, 57);
  224. INSERT INTO `player_levelstats` (`race`, `class`, `level`, `str`, `agi`, `sta`, `inte`, `spi`) VALUES (@RACE, @CLASS, 77, 171, 108, 157, 35, 58);
  225. INSERT INTO `player_levelstats` (`race`, `class`, `level`, `str`, `agi`, `sta`, `inte`, `spi`) VALUES (@RACE, @CLASS, 78, 174, 109, 159, 35, 58);
  226. INSERT INTO `player_levelstats` (`race`, `class`, `level`, `str`, `agi`, `sta`, `inte`, `spi`) VALUES (@RACE, @CLASS, 79, 181, 111, 165, 35, 59);
  227. INSERT INTO `player_levelstats` (`race`, `class`, `level`, `str`, `agi`, `sta`, `inte`, `spi`) VALUES (@RACE, @CLASS, 80, 184, 113, 168, 36, 60);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
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!