Character Creation Problem, sql query[Column count doesnt match value count at row 1]

[Nick_Da_Maco]

hey i got a problem.

I compiled ArcEmu 3.0.3 server and i edited the configs , added DBC,maps,vmaps and added the WhyDB tables and stuff...but when i create a new character and click done it doesnt show in my character list and it doesnt save to my database...

When i check ArcEmu-World.exe to see what happend this is what it shows.
ImageShack - Image Hosting :: problemnc8.png

OMG!!! another problem now.

i imported my ACCOUNTS AND CHARACTERS.sql from my old repack i had. and my characters were there but they are naked. and when i try login it says "Login Failed"

please help

[Nick_Da_Maco]

comon peoples i need help lol

[LilleCarl]

if you change to aspire i will help you ^^ i can help you transfer
add my msn [email protected]

[drew77]

empty playercreateinfo table

then add

INSERT INTO playercreateinfo
(`Index`, `race`, `factiontemplate`, `class`, `mapID`, `zoneID`, `positionX`, `positionY`, `positionZ`, `displayID`, `BaseStrength`, `BaseAgility`, `BaseStamina`, `BaseIntellect`, `BaseSpirit`, `BaseHealth`, `BaseMana`, `BaseRage`, `BaseFocus`, `BaseEnergy`, `attackpower`, `mindmg`, `maxdmg`)
VALUES
(1, 1, 1, 1, 0, 12, -8949.95, -132.493, 83.5312, 49, 23, 20, 22, 20, 20, 60, 0, 1000, 0, 0, 29, 5, 6);
INSERT INTO playercreateinfo
(`Index`, `race`, `factiontemplate`, `class`, `mapID`, `zoneID`, `positionX`, `positionY`, `positionZ`, `displayID`, `BaseStrength`, `BaseAgility`, `BaseStamina`, `BaseIntellect`, `BaseSpirit`, `BaseHealth`, `BaseMana`, `BaseRage`, `BaseFocus`, `BaseEnergy`, `attackpower`, `mindmg`, `maxdmg`)
VALUES
(2, 2, 2, 1, 1, 14, -618.518, -4251.67, 38.718, 51, 26, 17, 24, 17, 23, 80, 0, 1000, 0, 0, 35, 6, 7);
INSERT INTO playercreateinfo
(`Index`, `race`, `factiontemplate`, `class`, `mapID`, `zoneID`, `positionX`, `positionY`, `positionZ`, `displayID`, `BaseStrength`, `BaseAgility`, `BaseStamina`, `BaseIntellect`, `BaseSpirit`, `BaseHealth`, `BaseMana`, `BaseRage`, `BaseFocus`, `BaseEnergy`, `attackpower`, `mindmg`, `maxdmg`)
VALUES
(3, 3, 3, 1, 0, 1, -6240.32, 331.033, 382.758, 53, 25, 16, 25, 19, 19, 90, 0, 1000, 0, 0, 33, 5, 6);
INSERT INTO playercreateinfo
(`Index`, `race`, `factiontemplate`, `class`, `mapID`, `zoneID`, `positionX`, `positionY`, `positionZ`, `displayID`, `BaseStrength`, `BaseAgility`, `BaseStamina`, `BaseIntellect`, `BaseSpirit`, `BaseHealth`, `BaseMana`, `BaseRage`, `BaseFocus`, `BaseEnergy`, `attackpower`, `mindmg`, `maxdmg`)
VALUES
(4, 4, 4, 1, 1, 141, 10311.3, 832.463, 1326.41, 55, 20, 25, 21, 20, 20, 50, 0, 1000, 0, 0, 23, 4, 5);
INSERT INTO playercreateinfo
(`Index`, `race`, `factiontemplate`, `class`, `mapID`, `zoneID`, `positionX`, `positionY`, `positionZ`, `displayID`, `BaseStrength`, `BaseAgility`, `BaseStamina`, `BaseIntellect`, `BaseSpirit`, `BaseHealth`, `BaseMana`, `BaseRage`, `BaseFocus`, `BaseEnergy`, `attackpower`, `mindmg`, `maxdmg`)
VALUES
(5, 5, 5, 1, 0, 85, 1676.35, 1677.45, 121.67, 57, 22, 18, 23, 18, 25, 70, 0, 1000, 0, 0, 27, 4, 5);
INSERT INTO playercreateinfo
(`Index`, `race`, `factiontemplate`, `class`, `mapID`, `zoneID`, `positionX`, `positionY`, `positionZ`, `displayID`, `BaseStrength`, `BaseAgility`, `BaseStamina`, `BaseIntellect`, `BaseSpirit`, `BaseHealth`, `BaseMana`, `BaseRage`, `BaseFocus`, `BaseEnergy`, `attackpower`, `mindmg`, `maxdmg`)
VALUES
(6, 6, 6, 1, 1, 215, -2917.58, -257.98, 52.9968, 59, 28, 15, 24, 15, 22, 80, 0, 1000, 0, 0, 39, 6, 7);
INSERT INTO playercreateinfo
(`Index`, `race`, `factiontemplate`, `class`, `mapID`, `zoneID`, `positionX`, `positionY`, `positionZ`, `displayID`, `BaseStrength`, `BaseAgility`, `BaseStamina`, `BaseIntellect`, `BaseSpirit`, `BaseHealth`, `BaseMana`, `BaseRage`, `BaseFocus`, `BaseEnergy`, `attackpower`, `mindmg`, `maxdmg`)
VALUES
(7, 7, 115, 1, 0, 1, -6237.02, 329.659, 382.703, 1563, 18, 23, 21, 23, 20, 50, 0, 1000, 0, 0, 19, 3, 4);
INSERT INTO playercreateinfo
(`Index`, `race`, `factiontemplate`, `class`, `mapID`, `zoneID`, `positionX`, `positionY`, `positionZ`, `displayID`, `BaseStrength`, `BaseAgility`, `BaseStamina`, `BaseIntellect`, `BaseSpirit`, `BaseHealth`, `BaseMana`, `BaseRage`, `BaseFocus`, `BaseEnergy`, `attackpower`, `mindmg`, `maxdmg`)
VALUES
(8, 8, 116, 1, 1, 14, -618.518, -4251.67, 38.718, 1478, 24, 22, 23, 16, 21, 70, 0, 1000, 0, 0, 31, 5, 6);
INSERT INTO playercreateinfo
(`Index`, `race`, `factiontemplate`, `class`, `mapID`, `zoneID`, `positionX`, `positionY`, `positionZ`, `displayID`, `BaseStrength`, `BaseAgility`, `BaseStamina`, `BaseIntellect`, `BaseSpirit`, `BaseHealth`, `BaseMana`, `BaseRage`, `BaseFocus`, `BaseEnergy`, `attackpower`, `mindmg`, `maxdmg`)
VALUES
(9, 1, 1, 2, 0, 12, -8949.95, -132.493, 83.5312, 49, 22, 20, 22, 20, 21, 58, 80, 0, 0, 0, 27, 4, 5);
INSERT INTO playercreateinfo
(`Index`, `race`, `factiontemplate`, `class`, `mapID`, `zoneID`, `positionX`, `positionY`, `positionZ`, `displayID`, `BaseStrength`, `BaseAgility`, `BaseStamina`, `BaseIntellect`, `BaseSpirit`, `BaseHealth`, `BaseMana`, `BaseRage`, `BaseFocus`, `BaseEnergy`, `attackpower`, `mindmg`, `maxdmg`)
VALUES
(10, 3, 3, 2, 0, 1, -6240.32, 331.033, 382.758, 53, 24, 16, 25, 19, 20, 88, 79, 0, 0, 0, 31, 5, 6);
INSERT INTO playercreateinfo
(`Index`, `race`, `factiontemplate`, `class`, `mapID`, `zoneID`, `positionX`, `positionY`, `positionZ`, `displayID`, `BaseStrength`, `BaseAgility`, `BaseStamina`, `BaseIntellect`, `BaseSpirit`, `BaseHealth`, `BaseMana`, `BaseRage`, `BaseFocus`, `BaseEnergy`, `attackpower`, `mindmg`, `maxdmg`)
VALUES
(11, 2, 2, 3, 1, 14, -618.518, -4251.67, 38.718, 51, 23, 20, 23, 17, 24, 76, 82, 0, 0, 0, 25, 4, 5);
INSERT INTO playercreateinfo
(`Index`, `race`, `factiontemplate`, `class`, `mapID`, `zoneID`, `positionX`, `positionY`, `positionZ`, `displayID`, `BaseStrength`, `BaseAgility`, `BaseStamina`, `BaseIntellect`, `BaseSpirit`, `BaseHealth`, `BaseMana`, `BaseRage`, `BaseFocus`, `BaseEnergy`, `attackpower`, `mindmg`, `maxdmg`)
VALUES
(12, 3, 3, 3, 0, 1, -6240.32, 331.033, 382.758, 53, 22, 19, 24, 19, 20, 86, 84, 0, 0, 0, 23, 4, 5);
INSERT INTO playercreateinfo
(`Index`, `race`, `factiontemplate`, `class`, `mapID`, `zoneID`, `positionX`, `positionY`, `positionZ`, `displayID`, `BaseStrength`, `BaseAgility`, `BaseStamina`, `BaseIntellect`, `BaseSpirit`, `BaseHealth`, `BaseMana`, `BaseRage`, `BaseFocus`, `BaseEnergy`, `attackpower`, `mindmg`, `maxdmg`)
VALUES
(15, 4, 4, 3, 1, 141, 10311.3, 832.463, 1326.41, 55, 17, 28, 20, 20, 21, 46, 85, 0, 0, 0, 27, 4, 5);
INSERT INTO playercreateinfo
(`Index`, `race`, `factiontemplate`, `class`, `mapID`, `zoneID`, `positionX`, `positionY`, `positionZ`, `displayID`, `BaseStrength`, `BaseAgility`, `BaseStamina`, `BaseIntellect`, `BaseSpirit`, `BaseHealth`, `BaseMana`, `BaseRage`, `BaseFocus`, `BaseEnergy`, `attackpower`, `mindmg`, `maxdmg`)
VALUES
(16, 6, 6, 3, 1, 215, -2917.58, -257.98, 52.9968, 59, 25, 18, 23, 15, 23, 76, 80, 0, 0, 0, 25, 4, 5);
INSERT INTO playercreateinfo
(`Index`, `race`, `factiontemplate`, `class`, `mapID`, `zoneID`, `positionX`, `positionY`, `positionZ`, `displayID`, `BaseStrength`, `BaseAgility`, `BaseStamina`, `BaseIntellect`, `BaseSpirit`, `BaseHealth`, `BaseMana`, `BaseRage`, `BaseFocus`, `BaseEnergy`, `attackpower`, `mindmg`, `maxdmg`)
VALUES
(17, 8, 116, 3, 1, 14, -618.518, -4251.67, 38.718, 1478, 21, 25, 22, 16, 22, 66, 81, 0, 0, 0, 28, 5, 6);
INSERT INTO playercreateinfo
(`Index`, `race`, `factiontemplate`, `class`, `mapID`, `zoneID`, `positionX`, `positionY`, `positionZ`, `displayID`, `BaseStrength`, `BaseAgility`, `BaseStamina`, `BaseIntellect`, `BaseSpirit`, `BaseHealth`, `BaseMana`, `BaseRage`, `BaseFocus`, `BaseEnergy`, `attackpower`, `mindmg`, `maxdmg`)
VALUES
(18, 1, 1, 4, 0, 12, -8949.95, -132.493, 83.5312, 49, 21, 23, 21, 20, 20, 55, 0, 0, 0, 100, 26, 4, 5);
INSERT INTO playercreateinfo
(`Index`, `race`, `factiontemplate`, `class`, `mapID`, `zoneID`, `positionX`, `positionY`, `positionZ`, `displayID`, `BaseStrength`, `BaseAgility`, `BaseStamina`, `BaseIntellect`, `BaseSpirit`, `BaseHealth`, `BaseMana`, `BaseRage`, `BaseFocus`, `BaseEnergy`, `attackpower`, `mindmg`, `maxdmg`)
VALUES
(19, 2, 2, 4, 1, 14, -618.518, -4251.67, 38.718, 51, 24, 20, 23, 17, 23, 75, 0, 0, 0, 100, 26, 4, 5);
INSERT INTO playercreateinfo
(`Index`, `race`, `factiontemplate`, `class`, `mapID`, `zoneID`, `positionX`, `positionY`, `positionZ`, `displayID`, `BaseStrength`, `BaseAgility`, `BaseStamina`, `BaseIntellect`, `BaseSpirit`, `BaseHealth`, `BaseMana`, `BaseRage`, `BaseFocus`, `BaseEnergy`, `attackpower`, `mindmg`, `maxdmg`)
VALUES
(20, 3, 3, 4, 0, 1, -6240.32, 331.033, 382.758, 53, 23, 19, 24, 19, 19, 85, 0, 0, 0, 100, 24, 4, 5);
INSERT INTO playercreateinfo
(`Index`, `race`, `factiontemplate`, `class`, `mapID`, `zoneID`, `positionX`, `positionY`, `positionZ`, `displayID`, `BaseStrength`, `BaseAgility`, `BaseStamina`, `BaseIntellect`, `BaseSpirit`, `BaseHealth`, `BaseMana`, `BaseRage`, `BaseFocus`, `BaseEnergy`, `attackpower`, `mindmg`, `maxdmg`)
VALUES
(21, 4, 4, 4, 1, 141, 10311.3, 832.463, 1326.41, 55, 18, 28, 20, 20, 20, 45, 0, 0, 0, 100, 28, 5, 6);
INSERT INTO playercreateinfo
(`Index`, `race`, `factiontemplate`, `class`, `mapID`, `zoneID`, `positionX`, `positionY`, `positionZ`, `displayID`, `BaseStrength`, `BaseAgility`, `BaseStamina`, `BaseIntellect`, `BaseSpirit`, `BaseHealth`, `BaseMana`, `BaseRage`, `BaseFocus`, `BaseEnergy`, `attackpower`, `mindmg`, `maxdmg`)
VALUES
(22, 5, 5, 4, 0, 85, 1676.35, 1677.45, 121.67, 57, 20, 21, 22, 18, 25, 65, 0, 0, 0, 100, 23, 4, 5);
INSERT INTO playercreateinfo
(`Index`, `race`, `factiontemplate`, `class`, `mapID`, `zoneID`, `positionX`, `positionY`, `positionZ`, `displayID`, `BaseStrength`, `BaseAgility`, `BaseStamina`, `BaseIntellect`, `BaseSpirit`, `BaseHealth`, `BaseMana`, `BaseRage`, `BaseFocus`, `BaseEnergy`, `attackpower`, `mindmg`, `maxdmg`)
VALUES
(23, 7, 115, 4, 0, 1, -6237.02, 329.659, 382.703, 1563, 16, 26, 20, 23, 20, 45, 0, 0, 0, 100, 24, 4, 5);
INSERT INTO playercreateinfo
(`Index`, `race`, `factiontemplate`, `class`, `mapID`, `zoneID`, `positionX`, `positionY`, `positionZ`, `displayID`, `BaseStrength`, `BaseAgility`, `BaseStamina`, `BaseIntellect`, `BaseSpirit`, `BaseHealth`, `BaseMana`, `BaseRage`, `BaseFocus`, `BaseEnergy`, `attackpower`, `mindmg`, `maxdmg`)
VALUES
(24, 8, 116, 4, 1, 14, -618.518, -4251.67, 38.718, 1478, 22, 25, 22, 16, 21, 65, 0, 0, 0, 100, 29, 5, 6);
INSERT INTO playercreateinfo
(`Index`, `race`, `factiontemplate`, `class`, `mapID`, `zoneID`, `positionX`, `positionY`, `positionZ`, `displayID`, `BaseStrength`, `BaseAgility`, `BaseStamina`, `BaseIntellect`, `BaseSpirit`, `BaseHealth`, `BaseMana`, `BaseRage`, `BaseFocus`, `BaseEnergy`, `attackpower`, `mindmg`, `maxdmg`)
VALUES
(25, 1, 1, 5, 0, 12, -8949.95, -132.493, 83.5312, 49, 20, 20, 20, 22, 23, 52, 160, 0, 0, 0, 10, 2, 3);
INSERT INTO playercreateinfo
(`Index`, `race`, `factiontemplate`, `class`, `mapID`, `zoneID`, `positionX`, `positionY`, `positionZ`, `displayID`, `BaseStrength`, `BaseAgility`, `BaseStamina`, `BaseIntellect`, `BaseSpirit`, `BaseHealth`, `BaseMana`, `BaseRage`, `BaseFocus`, `BaseEnergy`, `attackpower`, `mindmg`, `maxdmg`)
VALUES
(26, 3, 3, 5, 0, 1, -6240.32, 331.033, 382.758, 53, 22, 16, 23, 21, 22, 82, 145, 0, 0, 0, 12, 2, 3);
INSERT INTO playercreateinfo
(`Index`, `race`, `factiontemplate`, `class`, `mapID`, `zoneID`, `positionX`, `positionY`, `positionZ`, `displayID`, `BaseStrength`, `BaseAgility`, `BaseStamina`, `BaseIntellect`, `BaseSpirit`, `BaseHealth`, `BaseMana`, `BaseRage`, `BaseFocus`, `BaseEnergy`, `attackpower`, `mindmg`, `maxdmg`)
VALUES
(27, 4, 4, 5, 1, 141, 10311.3, 832.463, 1326.41, 55, 17, 25, 19, 22, 23, 51, 160, 0, 0, 0, 7, 2, 2);
INSERT INTO playercreateinfo
(`Index`, `race`, `factiontemplate`, `class`, `mapID`, `zoneID`, `positionX`, `positionY`, `positionZ`, `displayID`, `BaseStrength`, `BaseAgility`, `BaseStamina`, `BaseIntellect`, `BaseSpirit`, `BaseHealth`, `BaseMana`, `BaseRage`, `BaseFocus`, `BaseEnergy`, `attackpower`, `mindmg`, `maxdmg`)
VALUES
(28, 5, 5, 5, 0, 85, 1676.35, 1677.45, 121.67, 57, 19, 18, 21, 20, 28, 62, 130, 0, 0, 0, 9, 2, 3);
INSERT INTO playercreateinfo
(`Index`, `race`, `factiontemplate`, `class`, `mapID`, `zoneID`, `positionX`, `positionY`, `positionZ`, `displayID`, `BaseStrength`, `BaseAgility`, `BaseStamina`, `BaseIntellect`, `BaseSpirit`, `BaseHealth`, `BaseMana`, `BaseRage`, `BaseFocus`, `BaseEnergy`, `attackpower`, `mindmg`, `maxdmg`)
VALUES
(29, 8, 116, 5, 1, 14, -618.518, -4251.67, 38.718, 1478, 21, 22, 21, 18, 24, 62, 128, 0, 0, 0, 11, 2, 3);
INSERT INTO playercreateinfo
(`Index`, `race`, `factiontemplate`, `class`, `mapID`, `zoneID`, `positionX`, `positionY`, `positionZ`, `displayID`, `BaseStrength`, `BaseAgility`, `BaseStamina`, `BaseIntellect`, `BaseSpirit`, `BaseHealth`, `BaseMana`, `BaseRage`, `BaseFocus`, `BaseEnergy`, `attackpower`, `mindmg`, `maxdmg`)
VALUES
(30, 2, 2, 7, 1, 14, -618.518, -4251.67, 38.718, 51, 24, 17, 23, 18, 25, 77, 73, 0, 0, 0, 30, 5, 6);
INSERT INTO playercreateinfo
(`Index`, `race`, `factiontemplate`, `class`, `mapID`, `zoneID`, `positionX`, `positionY`, `positionZ`, `displayID`, `BaseStrength`, `BaseAgility`, `BaseStamina`, `BaseIntellect`, `BaseSpirit`, `BaseHealth`, `BaseMana`, `BaseRage`, `BaseFocus`, `BaseEnergy`, `attackpower`, `mindmg`, `maxdmg`)
VALUES
(31, 6, 6, 7, 1, 215, -2917.58, -257.98, 52.9968, 59, 26, 15, 23, 16, 24, 77, 71, 0, 0, 0, 34, 5, 6);
INSERT INTO playercreateinfo
(`Index`, `race`, `factiontemplate`, `class`, `mapID`, `zoneID`, `positionX`, `positionY`, `positionZ`, `displayID`, `BaseStrength`, `BaseAgility`, `BaseStamina`, `BaseIntellect`, `BaseSpirit`, `BaseHealth`, `BaseMana`, `BaseRage`, `BaseFocus`, `BaseEnergy`, `attackpower`, `mindmg`, `maxdmg`)
VALUES
(32, 8, 116, 7, 1, 14, -618.518, -4251.67, 38.718, 1478, 22, 22, 22, 17, 23, 67, 72, 0, 0, 0, 26, 4, 5);
INSERT INTO playercreateinfo
(`Index`, `race`, `factiontemplate`, `class`, `mapID`, `zoneID`, `positionX`, `positionY`, `positionZ`, `displayID`, `BaseStrength`, `BaseAgility`, `BaseStamina`, `BaseIntellect`, `BaseSpirit`, `BaseHealth`, `BaseMana`, `BaseRage`, `BaseFocus`, `BaseEnergy`, `attackpower`, `mindmg`, `maxdmg`)
VALUES
(34, 1, 1, 8, 0, 12, -8949.95, -132.493, 83.5312, 49, 20, 20, 20, 23, 22, 52, 165, 0, 0, 0, 10, 2, 3);
INSERT INTO playercreateinfo
(`Index`, `race`, `factiontemplate`, `class`, `mapID`, `zoneID`, `positionX`, `positionY`, `positionZ`, `displayID`, `BaseStrength`, `BaseAgility`, `BaseStamina`, `BaseIntellect`, `BaseSpirit`, `BaseHealth`, `BaseMana`, `BaseRage`, `BaseFocus`, `BaseEnergy`, `attackpower`, `mindmg`, `maxdmg`)
VALUES
(35, 5, 5, 8, 0, 85, 1676.35, 1677.45, 121.67, 57, 19, 18, 21, 21, 27, 62, 135, 0, 0, 0, 9, 2, 3);
INSERT INTO playercreateinfo
(`Index`, `race`, `factiontemplate`, `class`, `mapID`, `zoneID`, `positionX`, `positionY`, `positionZ`, `displayID`, `BaseStrength`, `BaseAgility`, `BaseStamina`, `BaseIntellect`, `BaseSpirit`, `BaseHealth`, `BaseMana`, `BaseRage`, `BaseFocus`, `BaseEnergy`, `attackpower`, `mindmg`, `maxdmg`)
VALUES
(36, 7, 115, 8, 0, 1, -6237.02, 329.659, 382.703, 1563, 15, 23, 19, 26, 22, 51, 210, 0, 0, 0, 5, 1, 2);
INSERT INTO playercreateinfo
(`Index`, `race`, `factiontemplate`, `class`, `mapID`, `zoneID`, `positionX`, `positionY`, `positionZ`, `displayID`, `BaseStrength`, `BaseAgility`, `BaseStamina`, `BaseIntellect`, `BaseSpirit`, `BaseHealth`, `BaseMana`, `BaseRage`, `BaseFocus`, `BaseEnergy`, `attackpower`, `mindmg`, `maxdmg`)
VALUES
(37, 8, 116, 8, 1, 14, -618.518, -4251.67, 38.718, 1478, 21, 22, 21, 19, 23, 62, 119, 0, 0, 0, 11, 2, 3);
INSERT INTO playercreateinfo
(`Index`, `race`, `factiontemplate`, `class`, `mapID`, `zoneID`, `positionX`, `positionY`, `positionZ`, `displayID`, `BaseStrength`, `BaseAgility`, `BaseStamina`, `BaseIntellect`, `BaseSpirit`, `BaseHealth`, `BaseMana`, `BaseRage`, `BaseFocus`, `BaseEnergy`, `attackpower`, `mindmg`, `maxdmg`)
VALUES
(38, 1, 1, 9, 0, 12, -8949.95, -132.493, 83.5312, 49, 20, 20, 21, 22, 22, 53, 140, 0, 0, 0, 10, 2, 3);
INSERT INTO playercreateinfo
(`Index`, `race`, `factiontemplate`, `class`, `mapID`, `zoneID`, `positionX`, `positionY`, `positionZ`, `displayID`, `BaseStrength`, `BaseAgility`, `BaseStamina`, `BaseIntellect`, `BaseSpirit`, `BaseHealth`, `BaseMana`, `BaseRage`, `BaseFocus`, `BaseEnergy`, `attackpower`, `mindmg`, `maxdmg`)
VALUES
(39, 2, 2, 9, 1, 14, -618.518, -4251.67, 38.718, 51, 23, 17, 23, 19, 25, 73, 109, 0, 0, 0, 13, 2, 3);
INSERT INTO playercreateinfo
(`Index`, `race`, `factiontemplate`, `class`, `mapID`, `zoneID`, `positionX`, `positionY`, `positionZ`, `displayID`, `BaseStrength`, `BaseAgility`, `BaseStamina`, `BaseIntellect`, `BaseSpirit`, `BaseHealth`, `BaseMana`, `BaseRage`, `BaseFocus`, `BaseEnergy`, `attackpower`, `mindmg`, `maxdmg`)
VALUES
(40, 5, 5, 9, 0, 85, 1676.35, 1677.45, 121.67, 57, 19, 18, 22, 20, 27, 63, 110, 0, 0, 0, 9, 2, 3);
INSERT INTO playercreateinfo
(`Index`, `race`, `factiontemplate`, `class`, `mapID`, `zoneID`, `positionX`, `positionY`, `positionZ`, `displayID`, `BaseStrength`, `BaseAgility`, `BaseStamina`, `BaseIntellect`, `BaseSpirit`, `BaseHealth`, `BaseMana`, `BaseRage`, `BaseFocus`, `BaseEnergy`, `attackpower`, `mindmg`, `maxdmg`)
VALUES
(41, 7, 115, 9, 0, 1, -6237.02, 329.659, 382.703, 1563, 15, 23, 20, 25, 22, 43, 185, 0, 0, 0, 5, 1, 2);
INSERT INTO playercreateinfo
(`Index`, `race`, `factiontemplate`, `class`, `mapID`, `zoneID`, `positionX`, `positionY`, `positionZ`, `displayID`, `BaseStrength`, `BaseAgility`, `BaseStamina`, `BaseIntellect`, `BaseSpirit`, `BaseHealth`, `BaseMana`, `BaseRage`, `BaseFocus`, `BaseEnergy`, `attackpower`, `mindmg`, `maxdmg`)
VALUES
(42, 4, 4, 11, 1, 141, 10311.3, 832.463, 1326.41, 55, 18, 25, 19, 22, 22, 53, 100, 0, 0, 0, 16, 3, 4);
INSERT INTO playercreateinfo
(`Index`, `race`, `factiontemplate`, `class`, `mapID`, `zoneID`, `positionX`, `positionY`, `positionZ`, `displayID`, `BaseStrength`, `BaseAgility`, `BaseStamina`, `BaseIntellect`, `BaseSpirit`, `BaseHealth`, `BaseMana`, `BaseRage`, `BaseFocus`, `BaseEnergy`, `attackpower`, `mindmg`, `maxdmg`)
VALUES
(43, 6, 6, 11, 1, 215, -2917.58, -257.98, 52.9968, 59, 26, 15, 22, 17, 24, 74, 67, 0, 0, 0, 32, 5, 6);
INSERT INTO playercreateinfo
(`Index`, `race`, `factiontemplate`, `class`, `mapID`, `zoneID`, `positionX`, `positionY`, `positionZ`, `displayID`, `BaseStrength`, `BaseAgility`, `BaseStamina`, `BaseIntellect`, `BaseSpirit`, `BaseHealth`, `BaseMana`, `BaseRage`, `BaseFocus`, `BaseEnergy`, `attackpower`, `mindmg`, `maxdmg`)
VALUES
(44, 11, 1629, 1, 530, 3524, -3961.64, -13931.2, 100.615, 16125, 24, 17, 21, 21, 22, 50, 0, 1000, 0, 0, 31, 5, 6);
INSERT INTO playercreateinfo
(`Index`, `race`, `factiontemplate`, `class`, `mapID`, `zoneID`, `positionX`, `positionY`, `positionZ`, `displayID`, `BaseStrength`, `BaseAgility`, `BaseStamina`, `BaseIntellect`, `BaseSpirit`, `BaseHealth`, `BaseMana`, `BaseRage`, `BaseFocus`, `BaseEnergy`, `attackpower`, `mindmg`, `maxdmg`)
VALUES
(45, 11, 1629, 2, 530, 3524, -3961.64, -13931.2, 100.615, 16125, 23, 17, 21, 21, 23, 48, 95, 0, 0, 0, 29, 5, 6);
INSERT INTO playercreateinfo
(`Index`, `race`, `factiontemplate`, `class`, `mapID`, `zoneID`, `positionX`, `positionY`, `positionZ`, `displayID`, `BaseStrength`, `BaseAgility`, `BaseStamina`, `BaseIntellect`, `BaseSpirit`, `BaseHealth`, `BaseMana`, `BaseRage`, `BaseFocus`, `BaseEnergy`, `attackpower`, `mindmg`, `maxdmg`)
VALUES
(46, 11, 1629, 3, 530, 3524, -3961.64, -13931.2, 100.615, 16125, 21, 20, 20, 21, 23, 46, 100, 0, 0, 0, 23, 4, 5);
INSERT INTO playercreateinfo
(`Index`, `race`, `factiontemplate`, `class`, `mapID`, `zoneID`, `positionX`, `positionY`, `positionZ`, `displayID`, `BaseStrength`, `BaseAgility`, `BaseStamina`, `BaseIntellect`, `BaseSpirit`, `BaseHealth`, `BaseMana`, `BaseRage`, `BaseFocus`, `BaseEnergy`, `attackpower`, `mindmg`, `maxdmg`)
VALUES
(47, 11, 1629, 5, 530, 3524, -3961.64, -13931.2, 100.615, 16125, 21, 17, 19, 23, 25, 51, 175, 0, 0, 0, 11, 2, 3);
INSERT INTO playercreateinfo
(`Index`, `race`, `factiontemplate`, `class`, `mapID`, `zoneID`, `positionX`, `positionY`, `positionZ`, `displayID`, `BaseStrength`, `BaseAgility`, `BaseStamina`, `BaseIntellect`, `BaseSpirit`, `BaseHealth`, `BaseMana`, `BaseRage`, `BaseFocus`, `BaseEnergy`, `attackpower`, `mindmg`, `maxdmg`)
VALUES
(48, 11, 1629, 7, 530, 3524, -3961.64, -13931.2, 100.615, 16125, 22, 17, 20, 22, 24, 47, 105, 0, 0, 0, 26, 4, 5);
INSERT INTO playercreateinfo
(`Index`, `race`, `factiontemplate`, `class`, `mapID`, `zoneID`, `positionX`, `positionY`, `positionZ`, `displayID`, `BaseStrength`, `BaseAgility`, `BaseStamina`, `BaseIntellect`, `BaseSpirit`, `BaseHealth`, `BaseMana`, `BaseRage`, `BaseFocus`, `BaseEnergy`, `attackpower`, `mindmg`, `maxdmg`)
VALUES
(49, 11, 1629, 8, 530, 3524, -3961.64, -13931.2, 100.615, 16125, 21, 17, 19, 24, 24, 51, 180, 0, 0, 0, 11, 2, 3);
INSERT INTO playercreateinfo
(`Index`, `race`, `factiontemplate`, `class`, `mapID`, `zoneID`, `positionX`, `positionY`, `positionZ`, `displayID`, `BaseStrength`, `BaseAgility`, `BaseStamina`, `BaseIntellect`, `BaseSpirit`, `BaseHealth`, `BaseMana`, `BaseRage`, `BaseFocus`, `BaseEnergy`, `attackpower`, `mindmg`, `maxdmg`)
VALUES
(50, 10, 1610, 2, 530, 3430, 10349.6, -6357.29, 33.4026, 15476, 19, 22, 20, 24, 20, 38, 140, 0, 0, 0, 21, 4, 4);
INSERT INTO playercreateinfo
(`Index`, `race`, `factiontemplate`, `class`, `mapID`, `zoneID`, `positionX`, `positionY`, `positionZ`, `displayID`, `BaseStrength`, `BaseAgility`, `BaseStamina`, `BaseIntellect`, `BaseSpirit`, `BaseHealth`, `BaseMana`, `BaseRage`, `BaseFocus`, `BaseEnergy`, `attackpower`, `mindmg`, `maxdmg`)
VALUES
(51, 10, 1610, 3, 530, 3430, 10349.6, -6357.29, 33.4026, 15476, 17, 25, 19, 24, 20, 45, 145, 0, 0, 0, 24, 4, 5);
INSERT INTO playercreateinfo
(`Index`, `race`, `factiontemplate`, `class`, `mapID`, `zoneID`, `positionX`, `positionY`, `positionZ`, `displayID`, `BaseStrength`, `BaseAgility`, `BaseStamina`, `BaseIntellect`, `BaseSpirit`, `BaseHealth`, `BaseMana`, `BaseRage`, `BaseFocus`, `BaseEnergy`, `attackpower`, `mindmg`, `maxdmg`)
VALUES
(52, 10, 1610, 4, 530, 3430, 10349.6, -6357.29, 33.4026, 15476, 18, 25, 19, 24, 19, 44, 0, 0, 0, 100, 25, 4, 5);
INSERT INTO playercreateinfo
(`Index`, `race`, `factiontemplate`, `class`, `mapID`, `zoneID`, `positionX`, `positionY`, `positionZ`, `displayID`, `BaseStrength`, `BaseAgility`, `BaseStamina`, `BaseIntellect`, `BaseSpirit`, `BaseHealth`, `BaseMana`, `BaseRage`, `BaseFocus`, `BaseEnergy`, `attackpower`, `mindmg`, `maxdmg`)
VALUES
(53, 10, 1610, 5, 530, 3430, 10349.6, -6357.29, 33.4026, 15476, 17, 22, 18, 26, 22, 50, 220, 0, 0, 0, 7, 2, 2);
INSERT INTO playercreateinfo
(`Index`, `race`, `factiontemplate`, `class`, `mapID`, `zoneID`, `positionX`, `positionY`, `positionZ`, `displayID`, `BaseStrength`, `BaseAgility`, `BaseStamina`, `BaseIntellect`, `BaseSpirit`, `BaseHealth`, `BaseMana`, `BaseRage`, `BaseFocus`, `BaseEnergy`, `attackpower`, `mindmg`, `maxdmg`)
VALUES
(54, 10, 1610, 8, 530, 3430, 10349.6, -6357.29, 33.4026, 15476, 17, 22, 18, 27, 21, 50, 225, 0, 0, 0, 7, 2, 2);
INSERT INTO playercreateinfo
(`Index`, `race`, `factiontemplate`, `class`, `mapID`, `zoneID`, `positionX`, `positionY`, `positionZ`, `displayID`, `BaseStrength`, `BaseAgility`, `BaseStamina`, `BaseIntellect`, `BaseSpirit`, `BaseHealth`, `BaseMana`, `BaseRage`, `BaseFocus`, `BaseEnergy`, `attackpower`, `mindmg`, `maxdmg`)
VALUES
(55, 10, 1610, 9, 530, 3430, 10349.6, -6357.29, 33.4026, 15476, 17, 22, 19, 26, 21, 42, 200, 0, 0, 0, 7, 2, 2);
INSERT INTO playercreateinfo
(`Index`, `race`, `factiontemplate`, `class`, `mapID`, `zoneID`, `positionX`, `positionY`, `positionZ`, `displayID`, `BaseStrength`, `BaseAgility`, `BaseStamina`, `BaseIntellect`, `BaseSpirit`, `BaseHealth`, `BaseMana`, `BaseRage`, `BaseFocus`, `BaseEnergy`, `attackpower`, `mindmg`, `maxdmg`)
VALUES
(59, 7, 115, 6, 609, 0, 2360, -5662.03, 426.026, 1563, 18, 23, 21, 23, 20, 50, 0, 0, 0, 0, 30, 4, 5);
INSERT INTO playercreateinfo
(`Index`, `race`, `factiontemplate`, `class`, `mapID`, `zoneID`, `positionX`, `positionY`, `positionZ`, `displayID`, `BaseStrength`, `BaseAgility`, `BaseStamina`, `BaseIntellect`, `BaseSpirit`, `BaseHealth`, `BaseMana`, `BaseRage`, `BaseFocus`, `BaseEnergy`, `attackpower`, `mindmg`, `maxdmg`)
VALUES
(60, 1, 1, 6, 609, 0, 2360, -5662.03, 426.026, 49, 18, 23, 21, 23, 20, 50, 0, 0, 0, 0, 30, 4, 5);
INSERT INTO playercreateinfo
(`Index`, `race`, `factiontemplate`, `class`, `mapID`, `zoneID`, `positionX`, `positionY`, `positionZ`, `displayID`, `BaseStrength`, `BaseAgility`, `BaseStamina`, `BaseIntellect`, `BaseSpirit`, `BaseHealth`, `BaseMana`, `BaseRage`, `BaseFocus`, `BaseEnergy`, `attackpower`, `mindmg`, `maxdmg`)
VALUES
(61, 10, 1610, 6, 609, 0, 2360, -5662.03, 426.026, 15476, 18, 23, 21, 23, 20, 50, 0, 0, 0, 0, 30, 4, 5);
INSERT INTO playercreateinfo
(`Index`, `race`, `factiontemplate`, `class`, `mapID`, `zoneID`, `positionX`, `positionY`, `positionZ`, `displayID`, `BaseStrength`, `BaseAgility`, `BaseStamina`, `BaseIntellect`, `BaseSpirit`, `BaseHealth`, `BaseMana`, `BaseRage`, `BaseFocus`, `BaseEnergy`, `attackpower`, `mindmg`, `maxdmg`)
VALUES
(62, 8, 116, 6, 609, 0, 2360, -5662.03, 426.026, 1478, 18, 23, 21, 23, 20, 50, 0, 0, 0, 0, 30, 4, 5);
INSERT INTO playercreateinfo
(`Index`, `race`, `factiontemplate`, `class`, `mapID`, `zoneID`, `positionX`, `positionY`, `positionZ`, `displayID`, `BaseStrength`, `BaseAgility`, `BaseStamina`, `BaseIntellect`, `BaseSpirit`, `BaseHealth`, `BaseMana`, `BaseRage`, `BaseFocus`, `BaseEnergy`, `attackpower`, `mindmg`, `maxdmg`)
VALUES
(63, 11, 1629, 6, 609, 0, 2360, -5662.03, 426.026, 16125, 18, 23, 21, 23, 20, 50, 0, 0, 0, 0, 30, 4, 5);
INSERT INTO playercreateinfo
(`Index`, `race`, `factiontemplate`, `class`, `mapID`, `zoneID`, `positionX`, `positionY`, `positionZ`, `displayID`, `BaseStrength`, `BaseAgility`, `BaseStamina`, `BaseIntellect`, `BaseSpirit`, `BaseHealth`, `BaseMana`, `BaseRage`, `BaseFocus`, `BaseEnergy`, `attackpower`, `mindmg`, `maxdmg`)
VALUES
(64, 6, 6, 6, 609, 0, 2360, -5662.03, 426.026, 59, 18, 23, 21, 23, 20, 50, 0, 0, 0, 0, 30, 4, 5);
INSERT INTO playercreateinfo
(`Index`, `race`, `factiontemplate`, `class`, `mapID`, `zoneID`, `positionX`, `positionY`, `positionZ`, `displayID`, `BaseStrength`, `BaseAgility`, `BaseStamina`, `BaseIntellect`, `BaseSpirit`, `BaseHealth`, `BaseMana`, `BaseRage`, `BaseFocus`, `BaseEnergy`, `attackpower`, `mindmg`, `maxdmg`)
VALUES
(65, 5, 5, 6, 609, 0, 2360, -5662.03, 426.026, 57, 18, 23, 21, 23, 20, 50, 0, 0, 0, 0, 30, 4, 5);
INSERT INTO playercreateinfo
(`Index`, `race`, `factiontemplate`, `class`, `mapID`, `zoneID`, `positionX`, `positionY`, `positionZ`, `displayID`, `BaseStrength`, `BaseAgility`, `BaseStamina`, `BaseIntellect`, `BaseSpirit`, `BaseHealth`, `BaseMana`, `BaseRage`, `BaseFocus`, `BaseEnergy`, `attackpower`, `mindmg`, `maxdmg`)
VALUES
(66, 4, 4, 6, 609, 0, 2360, -5662.03, 426.026, 55, 18, 23, 21, 23, 20, 50, 0, 0, 0, 0, 30, 4, 5);
INSERT INTO playercreateinfo
(`Index`, `race`, `factiontemplate`, `class`, `mapID`, `zoneID`, `positionX`, `positionY`, `positionZ`, `displayID`, `BaseStrength`, `BaseAgility`, `BaseStamina`, `BaseIntellect`, `BaseSpirit`, `BaseHealth`, `BaseMana`, `BaseRage`, `BaseFocus`, `BaseEnergy`, `attackpower`, `mindmg`, `maxdmg`)
VALUES
(67, 3, 3, 6, 609, 0, 2360, -5662.03, 426.026, 53, 18, 23, 21, 23, 20, 50, 0, 0, 0, 0, 30, 4, 5);
INSERT INTO playercreateinfo
(`Index`, `race`, `factiontemplate`, `class`, `mapID`, `zoneID`, `positionX`, `positionY`, `positionZ`, `displayID`, `BaseStrength`, `BaseAgility`, `BaseStamina`, `BaseIntellect`, `BaseSpirit`, `BaseHealth`, `BaseMana`, `BaseRage`, `BaseFocus`, `BaseEnergy`, `attackpower`, `mindmg`, `maxdmg`)
VALUES
(68, 2, 2, 6, 609, 0, 2360, -5662.03, 426.026, 51, 18, 23, 21, 23, 20, 50, 0, 0, 0, 0, 30, 4, 5);