MMOwned - World of Warcraft Exploits, Hacks, Bots and Guides

Homepage Register FAQ Members Mark Forums Read Advertise Marketplace FPSowned


Go Back   MMOwned - World of Warcraft Exploits, Hacks, Bots and Guides > WoW Emulator Server > Emulator Server Guides > Ascent Guides
Reload this Page [Guide] Working way to play any class with any race
Ascent Guides This section is for WoW emulated server, Ascent guides.
[NO QUESTIONS HERE]

Reply
 
LinkBack Thread Tools
[Guide] Working way to play any class with any race
(#1)
Old
coreykrauss13's Avatar
coreykrauss13 is Offline
Private
Rep Power: 1
Reputation: 5
coreykrauss13 is an unknown quantity at this point
 
Posts: 9
Join Date: Nov 2007
Wow Guides [Guide] Working way to play any class with any race - 06-18-2008

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.



Quote:
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 [Only registered and activated users can see links. ]
For the list of Races/Classes go to [Only registered and activated users can see links. ]

Quote:
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 [Only registered and activated users can see links. ] 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.
Quote:
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.

Last edited by coreykrauss13; 06-19-2008 at 11:14 PM.
Reply With Quote

Donate to remove ads.
(#2)
Old
moffett's Avatar
moffett is Offline
Sergeant
Rep Power: 2
Reputation: 18
moffett is on a distinguished road
 
Posts: 72
Join Date: May 2007
06-19-2008

id love to see some SS
Reply With Quote
(#3)
Old
Kalypso29 is Offline
Site n00b.. (A leecher if I've been here for more than a month and can't earn 5 rep)
Rep Power: 1
Reputation: 1
Kalypso29 is an unknown quantity at this point
 
Posts: 14
Join Date: Jun 2008
06-19-2008

*Nods* at moffet
Reply With Quote
problem with language
(#4)
Old
gothicdude1044's Avatar
gothicdude1044 is Offline
Site n00b.. (A leecher if I've been here for more than a month and can't earn 5 rep)
Rep Power: 1
Reputation: 1
gothicdude1044 is an unknown quantity at this point
 
Posts: 23
Join Date: Feb 2008
Location: gcs fl usa
problem with language - 07-16-2008

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.




[Only registered and activated users can see links. ]
Reply With Quote
(#5)
Old
Superfly's Avatar
Superfly is Offline
Contributor
Rep Power: 3
Reputation: 90
Superfly will become famous soon enough
 
Posts: 179
Join Date: Aug 2006
Location: My Home
07-21-2008

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!


Reply With Quote
(#6)
Old
bawls1992 is Offline
Site n00b.. (A leecher if I've been here for more than a month and can't earn 5 rep)
Rep Power: 0
Reputation: 1
bawls1992 is an unknown quantity at this point
 
Posts: 1
Join Date: Jun 2008
Pirate 07-22-2008

Great guide, lots of halp!! the trick to talking is macros, other than that mine isnt glitched. tons of jealous friends =D
Reply With Quote
(#7)
Old
kreegoth's Avatar
kreegoth is Offline
Knight-Captain
Rep Power: 1
Reputation: 44
kreegoth is on a distinguished road
 
Posts: 387
Join Date: Jun 2008
07-22-2008

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.
Reply With Quote
(#8)
Old
mmhelm is Offline
Master Sergeant
Rep Power: 2
Reputation: 8
mmhelm is an unknown quantity at this point
 
Posts: 75
Join Date: Aug 2007
07-24-2008

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.


My server
worldofdarkness.kicks-ass.net
Reply With Quote
Reply

Donate to remove ads.

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are On




Powered by vBulletin® Version 3.7.2
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
LinkBacks Enabled by vBSEO 3.1.0
vBulletin Skin developed by: vBStyles.com


1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255 256 257 258 259 260 261 262 263 264 265 266 267 268 269 270 271 272 273 274 275 276 277 278 279 280 281 282 283 284 285 286 287 288 289 290 291 292 293 294 295 296 297 298 299 300 301 302 303 304 305 306 307 308 309 310 311 312 313 314 315 316 317 318 319 320 321 322 323 324 325 326 327