[Guide] Working way to play any class with any race

[coreykrauss13]

I have tried Guitargod218's guide to try to playing with any class on any race, and i have not found success. I started to look through my database and found found out how to do it. Ill add screen shots ASAP.

First open a new Query and put this into it and run it.

CREATE TABLE `player_levelstats` (
`race` tinyint(3) unsigned NOT NULL,
`class` tinyint(3) unsigned NOT NULL,
`level` tinyint(3) unsigned NOT NULL,
`hp` smallint(5) unsigned NOT NULL,
`mana` smallint(5) unsigned NOT NULL,
`str` tinyint(3) unsigned NOT NULL,
`agi` tinyint(3) unsigned NOT NULL,
`sta` tinyint(3) unsigned NOT NULL,
`int` tinyint(3) unsigned NOT NULL,
`spi` tinyint(3) unsigned NOT NULL,
PRIMARY KEY (`race`,`class`,`level`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 PACK_KEYS=0 COMMENT='Stores levels stats.'

That will make a new table for this. NEW TABLE!



Then make a new Query and put this into it, but make sure to change the race to the race you need and the class to the class you want. For example if you want a Blood Elf Warrior, you would take out the Race and put in 10 and take out the class and put 1.

For a mass text editor go here LINK
For the list of Races/Classes go to LINK

INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '1', '62', '135', '19', '18', '21', '27', '21');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '2', '77', '160', '19', '18', '21', '22', '28');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '3', '92', '186', '19', '18', '22', '23', '29');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '4', '107', '213', '19', '19', '22', '25', '30');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '5', '122', '241', '19', '19', '22', '26', '32');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '6', '137', '270', '20', '19', '22', '27', '33');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '7', '152', '300', '20', '19', '23', '28', '34');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '8', '167', '316', '20', '19', '23', '29', '35');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '9', '182', '363', '20', '19', '23', '31', '36');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '10', '197', '396', '20', '20', '24', '32', '38');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '11', '212', '430', '20', '20', '24', '33', '39');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '12', '227', '465', '20', '20', '24', '35', '40');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '13', '242', '501', '20', '20', '25', '36', '41');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '14', '257', '538', '21', '20', '25', '37', '43');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '15', '272', '576', '21', '21', '25', '39', '44');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '16', '287', '615', '21', '21', '26', '40', '45');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '17', '302', '640', '21', '21', '26', '41', '47');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '18', '317', '696', '21', '21', '26', '43', '48');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '19', '332', '723', '21', '21', '27', '44', '49');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '20', '347', '781', '21', '22', '27', '46', '51');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '21', '362', '810', '22', '22', '27', '47', '52');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '22', '377', '870', '22', '22', '28', '49', '54');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '23', '392', '901', '22', '22', '28', '50', '55');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '24', '408', '963', '22', '23', '29', '52', '57');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '25', '425', '996', '22', '23', '29', '53', '58');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '26', '443', '1060', '22', '23', '29', '55', '60');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '27', '462', '1110', '22', '23', '30', '57', '61');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '28', '482', '1146', '23', '23', '30', '58', '63');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '29', '503', '1212', '23', '24', '31', '60', '64');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '30', '525', '1263', '23', '24', '31', '62', '66');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '31', '548', '1299', '23', '24', '31', '63', '68');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '32', '572', '1365', '23', '24', '32', '65', '69');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '33', '597', '1416', '23', '25', '32', '67', '71');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '34', '623', '1452', '24', '25', '33', '68', '73');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '35', '650', '1503', '24', '25', '33', '70', '74');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '36', '678', '1554', '24', '26', '34', '72', '76');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '37', '707', '1620', '24', '26', '34', '74', '78');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '38', '737', '1671', '24', '26', '34', '76', '80');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '39', '768', '1722', '25', '26', '35', '78', '81');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '40', '800', '1758', '25', '27', '35', '79', '83');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '41', '833', '1809', '25', '27', '36', '81', '85');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '42', '867', '1860', '25', '27', '36', '83', '87');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '43', '902', '1911', '25', '27', '37', '85', '89');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '44', '938', '1962', '25', '28', '37', '87', '91');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '45', '975', '2013', '26', '28', '38', '89', '93');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '46', '1013', '2064', '26', '28', '38', '91', '95');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '47', '1052', '2115', '26', '29', '39', '93', '97');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '48', '1092', '2181', '26', '29', '39', '96', '99');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '49', '1133', '2232', '27', '29', '40', '98', '101');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '50', '1175', '2268', '27', '30', '40', '100', '103');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '51', '1218', '2319', '27', '30', '41', '102', '105');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '52', '1262', '2370', '27', '30', '41', '104', '107');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '53', '1307', '2421', '27', '31', '42', '106', '109');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '54', '1353', '2472', '28', '31', '43', '109', '111');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '55', '1400', '2523', '28', '31', '43', '111', '114');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '56', '1448', '2574', '28', '32', '44', '113', '116');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '57', '1497', '2625', '28', '32', '44', '116', '118');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '58', '1547', '2676', '29', '32', '45', '118', '120');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '59', '1598', '2727', '29', '33', '45', '121', '123');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '60', '1650', '2778', '29', '33', '46', '123', '125');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '61', '1690', '2829', '29', '33', '47', '125', '127');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '62', '1738', '2880', '30', '34', '47', '128', '129');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '63', '1785', '2931', '30', '34', '48', '130', '131');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '64', '1833', '2982', '30', '34', '48', '132', '134');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '65', '1880', '3033', '30', '35', '49', '135', '136');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '66', '1928', '3084', '31', '35', '49', '137', '138');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '67', '1975', '3135', '31', '35', '50', '139', '140');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '68', '2023', '3186', '31', '36', '51', '142', '143');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '69', '2070', '3237', '31', '36', '51', '144', '145');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '70', '2118', '3288', '31', '36', '52', '146', '147');

You will need to go to LINK if your server goes higher then 70.

After you run the Query above, go to your database and find the table "playercreateinfo" and open it.

Once opened make a new record, + symbol if using navicat.

When you have made the new record fill in the index number with the next highest number, then the id for your class, and race. Then find another record of the same race and copy all the info into the correct boxes. When you get to the part where it says base strength and base agility and all that you can put any numbers into there. Finish entering all that information, and when done close that window.

Then copy this Query but make sure to change Race and Class to the ones you want.. Example, take out Race and put in 10, and take out class and put in 1.. for a blood elf warrior.

INSERT INTO `playercreateinfo_bars` VALUES ('Race', 'Class', '1', '133', '0', '0');
INSERT INTO `playercreateinfo_bars` VALUES ('Race', 'Class', '2', '168', '0', '0');
INSERT INTO `playercreateinfo_bars` VALUES ('Race', 'Class', '0', '6603', '0', '0');
INSERT INTO `playercreateinfo_bars` VALUES ('Race', 'Class', '10', '159', '128', '0');
INSERT INTO `playercreateinfo_bars` VALUES ('Race', 'Class', '11', '2070', '128', '0');

Then start your server and create a character that is the race you want. Then log off and shut down your server. Go into your character tab and choose that character and change his class to the class you want. There you go! Start you server back up and log in as it. But there is one problem, changing, lets say a blood elf rogue to warrior, can cause some problems, like when i did that i got no EXP and i could not talk, i have yet to fix that, but when i do, i will up date THIS PART and add some screen shots. Thank You.

P.S. i have yet to try any other classes and races other then blood elf warrior. will update when i have found out fixes to those problems.

[moffett]

id love to see some SS

[Kalypso29]

*Nods* at moffet

[gothicdude1044]

i made a blood elf druid that knows all languages but when i use gm commands or just try to say something it says cant speak that language.




Welcome to Insane Wow

[freeride474]

I get the error "Login Failed" and on my ascent-world.exe it says guid 15 level 70 class 3 race 5 levelinfo not found!

[bawls1992]

Great guide, lots of halp!! the trick to talking is macros, other than that mine isnt glitched. tons of jealous friends =D

[kreegoth]

Theres a more stable way to do it but it involves getting rid of another race. Like i have a completely working undead paladin and a blood elf warrior on mine if you can have a GM cast on you .learnsk 698 300 300 or learnsk 699 300 300 depending on what faction you are ... Then you should be able to talk np.

[mmhelm]

If this hasn't already been posted put spell # 817 in the table that defines what spells the character starts off with or have someone else with gm prims learn you the spell this will teach you Language: old tongue which will let you talk to all languages and understand evryone.