Guide to Playing as Any Class with Any Race!

[guitargod218]

Well guys, here is another one of my guides. I hope you enjoy it (I'll add in pictures tomorrow, right now I'm a bit too tired to do it). In this guide, I will teach you how to make it so that you can play as any class as any race.

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.'

Then go and put this SQL into the query. There is a link to a mass text replacer at the bottom of the guide, and thank me later for providing it (Thank Illidan1 for the SQL though):

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');

P.S. - If the server goes higher than 70 levels, you'll need to go to Illidan1's guide and get the other levelinfos.

Edit the race and class part for each of the 70 lines, using the list below as a reference to what you want (here, you want to put in the class ID you want and the race ID you want!)

Now, make the character in WoW. Edit it as whatever race you want him to be, and make him look the way you want (I made a Night Elf warrior that I want switched into a mage). Also make a character with the class that you want (Here I'll make a random human mage).



Then, open up your SQL editor, I'll be using Navicat. What you need to do is to go to your character database (mine is logon1), and then go to the characters table.



Next, find the character that you want to have the class switched to. Using the list of class values that I provided below (which is stickied in the discussion section), change the class of the character to whatever you want it to be (for example, if it's a paladin to a mage, you change from a 2 to an .





Then, save your changes and close down Navicat. Restart the server and log in as your new character (a Night Elf Mage, for example, or a Blood Elf Druid :P).



Doing it this way (making the two characters) may be a bit more complicated or longer, but it allows for one to do a cross-race class swtich without have the "I can't talk" bug.

Disclaimers:

As far as I know, this will get rid of whatever he/she is wearing (I know it works because I walked a friend through it 3 days ago, but I didn't see the effects), as well as the stuff on the hotbar, yet will overwrite your spellbook. I haven't done this in about 2 months on my own character, so I'm not sure if that still happens, so I recommend trying it out on a level 1 first.

Also, I didn't write the list that's used to find the class values, so I want to posts saying "ZOMG, u r copy n paster leechur nub, gtfo". Really, that's just annoying as hell.

Link to the List Thread: http://www.mmowned.com/forums/emulat...guy-needs.html
Link to a mass text editor, so you don't have to replace race and class 70 times each: Download Mass Text Replacer 1.6.0 Free Trial - Mass Text Replacer - It lets you search files for a particular phrase and replace it - Softpedia

Our needed list is under "PlayerCreateInfo Class:"

Hope this helps you guys out!

- guitargod218

[BaandrCaaib]

Hmm... your guide has gotten much more complicated since yesterday and a no mention of the fact that what you had yesterday was wrong... and where'd my post go? Did you delete it? Anways, if this works then awesome. Just when you edit ur post you could let ur readers know it's been edited.

[BaandrCaaib]

Wait... omfg... I'm probably gonna sound like a total noob, but where'd my post go? I was gonna edit it but I don't see it so now I gotta double post... yay. Anyways which quote do I paste into the query? And what do I do with the other quote? It's very unclear as to what you're trying to say at that point.

EDIT - Ok, now that I posted I can see the other post... wtf's up with ur thread man?

EDIT 2 - I tried it, I ran the query, made the table, replaced class and race, made a dwarf, replaced his class 1 for warrior with class 7 for shaman, restarted the server, and STILL get "Login failed".

[guitargod218]

I can't delete posts, and yeah, I made the revision because I had remembered I had done this to my server ages ago, and I thought that was the reason why yours wasn't working.

Sorry if this is getting too complicated for you, I can't remember what else I had done to make this work, so if that wasn't it, I honestly don't know.

However, I will be making an AC-Web 7.7 server on my other computer, so I'll have a fresh start to see what I did and how to get this working for you.

Once again, I agree that I should have mentioned that I had edited it, I apologize to you, and I'm gonna work as hard as I can to make this work for you.

Edit: Try adding these lines into your code, and fill in the parts with the words in them (use the list to fill them in):

INSERT INTO `playercreateinfo` VALUES ('99', 'Race', 'Factiontemplate', 'Class', 'MapID', 'MapID', 'X', 'Y', 'Z', 'DisplayID', '54', '57', '57', '57', '57', '57', '90000000', '57', '57', '57', '57', '57', '57');


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');

Your Info:

Race = Race of the character that you want (Dwarf = 3)
FactionTemplate = Faction of the race (Dwarf = 3)
Class = Class I want (Druid = 11)
MapID = Map ID of where you spawn (Eastern Kingdoms=0)
X,Y,Z = The spawn location (-6240.32, 331.033, 382.75
Display ID = 53

By the way, I had posted the guide twice: once in the ascent guides and once in the normal emulation guides. You originally posted here (http://www.mmowned.com/forums/emulat...-any-race.html) and followed up here (http://www.mmowned.com/forums/ascent...tml#post830943). That's why the post disappeared.

[BaandrCaaib]

Well that explains the first missing message. What really weirded me out though was once I posted my first one on this thread then came back I couldn't see it at first, but I see them both now. Anyways thanks for trying so hard, if I could I'd +rep you just for dedication lol. That table you had me make, the "player_levelstats", seems useless, though I could be wrong. The query makes the table but doesn't add any reason for it to ever be utilized. I mean the other tables were all working quite happily before it existed. Just wondering what exactly that does. Well, I can see what it does, but how is it used?

I'll try the new version, but I'm gonna basically be driving for the rest of today (11 hours) and all of tomorrow (8 hours) and will be out of town all week. I'll try to sit down with my server Friday or Saturday, but I don't know how much time I'll have. I'll let you know how it works, or rather whether it does or not lol.

Thanks either way,
~BaandrCaaib

[Appled]

Nice, I have Gnome Hunter
And Human Druid
+rep

[guitargod218]

Yeah, I just added that in because I know it works with it, and I'd rather not see if it will or won't work without it. Have fun on your long road trip, and let me know how it works when you get back.

EDIT: Oh yeah, what level stats does is it will show you the base values of your stats when you level up, i.e. at level 30 your stamina is _____. Level stats tells you that, and without it I'm pretty sure it won't work for a custom class, not 100% sure though.

[BaandrCaaib]

Well I knew what the table did, but how does the game use it? There's nothing telling the database to reference this new table.

[guitargod218]

I have no clue how the game uses it, all I know is that it doesn't hurt the system so I'm keeping it there.

[Redviper2321]

like i said on the other one, great job with the guide, i love my gnome drood

[liamdawise]

i get an error when login in

[liamdawise]

when i log into my char it says log in failer

[liamdawise]

anyone know the problem?

[guitargod218]

Did you do everything I described in this guide?

[BaandrCaaib]

Well I guess I can accept that lol. I'm going to try the update after my dad checks his mail, so I'll post again in a couple minutes.