reddeath30
04-24-2008, 06:15 PM
Sorry for the double post.... I felt that this belonged in both tutorial and server chat sections
When i first got into the private servers I realized that there was no easy way to max out most of these skills. At least I havent found any easy ways to do it in the very short time as a sysop/gm on my own private server. But I am an IT professional with over 14 years of PC Networking, Coding, & Database experience. So the first thing I did was download Navicat as it is an extremely reliable tool to use to edit the Ascent databases. Next thing i did was open the databases and started fooling around. I discovered that everything is code and query based. I spent the good part of the week mapping all of the Skill codes and the structure of how the database reads it. To make a long story short (oops too late) I mapped out all of the codes and posted it below.
Explanation:
Here is what the skills field of a newly created Night Elf hunter looks like
45;3;100;50;1;100;51;5;5;95;4;100;126;5;5;162;1;10 0;163;5;5;173;4;100;183;5;5;414;1;1;415;1;1;
as you can see the numbers mean absolutely nothing to the normal eye. Here is what they mean to me-> the first number is 45, looking at the list below it tells me that this character has the Bows skill and that it is levelled to 3 out of a possible 100. All you do is Log the character out, change the 3 to 350 and change the 100 to 350, log back in and Voila! your bow skill is now 350.
One thing to be carefull of, is to actually go to the different weapons trainers and actually just learn the skill so you know it will work and your not giving Shamans sword skills or anything like that....
The same thing applies for tradeskills as it is contained in the same skills field in the database. Again remember that you start out with only 2 possible tradeskills. It is possible for you to increase the number of tradeskills that a character can have, but if you exceed it, you will have unstable results as the queries in the more advanced sections of the database can only understand the 2 tradeskills. Reputation is a bit more tricky as there are a set of 4 numbers to deal with instead of 3.
WEAPONS & SECONDARY SKILLS
43 swords
44 axes
45 bows
46 guns
54 maces
55 two handed swords
95 defense
136 staves
160 two handed maces
162 unarmed
172 two handed axes
173 daggers
176 thrown
226 crossbows
228 wands
229 polearms
762 riding
TRADESKILL CODES
129 First Aid
171 Alchemy
164 Blacksmithing
165 Leatherworking
182 Herbalism
185 Cooking
186 Mining
197 Tailoring
202 Engineering
333 Enchanting
356 Fishing
393 Skinning
755 Jewelcrafting
I have included a sample of reputation codes that you can just copy and paste into the reputation field for each faction both Horde and Alliance that will give you Exhaulted status for EVERYONE.
Im only going to paste a very small segment of the total data for a new character:
21,0,500,500,46,0,0,0,47,1,3100,3100,54,1,3100,310 0,59,0,0,0,67,2,-42000,-42000,68,2,-42000,-42000,69,1,4000,4000,70,2
As you can see this one is fairly complex with the negative numbers and all that but here is the Explanation:
As you can the code has alot of numbers that make sense but dont, well here is the sense, taking the first set of numbers. (sets of 4 numbers this time)
21,0,500,500
The first number is the reputation code 21 which in my list is booty bay
the next code is 0 which equals non existent (just doesnt show on your list in game) If the number was 1 it would show, if it were 2 it would show as At war. the next number is 500, which is the multiplier, or factor(dont worry about it you dont have to know this) the last number is your score. So if you were maximum exhaulted with Booty bay it would look like this:
21,1,500,43000
What a pain in the butt this was to figure out, so i have made it easy on everyone. at the bottom of this i have posted code that will make your character maximum exhaulted for both factions horde and alliance and are labelled as such.
REPUTATION CODES
id 21 = booty bay
id 46 = blacksmithing armorsmithing
id 47 = ironforge
id 54 = gnomeregan exiles
id 59 = thorium brotherhood
id 67 = horde
id 68 = undercity
id 69 = darnassas
id 70 = syndicate
id 72 = stormwind
id 76 = ogrimmar
id 81 = thunder bluff
id 83 = leatherworking elemental
id 86 = leatherworking dragonhyde
id 87 = bloodsail buccaneers
id 92 = gelkis clan centaur
id 93 = magram clan centaur
id 169 = ?unknown?
id 270 = zandalar tribe
id 289 = blacksmith weaponsmith
id 349 = ravenholdt
id 369 = gadgetzan
id 469 = opens "Alliance" heading
id 470 = ratchet
id 471 = wildhammer clan
id 509 = the league of arathor
id 510 = the defilers
id 529 = argent dawn
id 530 = darkspear trolls
id 549 = leatherworking tribal
id 550 = engineering - goblin
id 551 = engineering - gnome
id 569 = blacksmithing hammersmithing
id 570 = blacksmithing axesmithing
id 571 = blacksmithing swordsmithing
id 574 = caer darrow
id 576 = timbermaw hold
id 577 = everlook
id 589 = wintersaber trainers
id 609 = cenarion circle
id 729 = frostwolf clan
id 730 = stormpike guard
id 749 = hydraxian waterlords
id 809 = shen'dralar
id 889 = warsong outriders
id 890 = silverwing sentinals
id 891 = opens "Other" heading
id 892 =
id 909 = darkmoon fair
id 910 = brood of nozdormu
id 911 = silvermoon city
id 922 = Tranquillien
id 930 = exodar
id 932 = the aldor
id 933 = the consortium
id 934 = the scryers
id 935 = the sha'tar
id 936 = shows the Shatrath city heading
id 941 = the mag'har
id 942 = cenarion expedition
id 946 = honor hold
id 947 = thrallmar
id 967 = the violet eye
id 970 = sporeggar
id 978 = kurenai
id 989 = keepers of time
id 990 = the scale of the sands
id 1005 = friendly - hidden
id 1011 = lower city
id 1012 = ashtongue deathsworn
id 1015 = netherwing
id 1031 = sha'tari skyguard
id 1038 = ogri'la
Alliance:
21,1,500,43000,46,0,0,0,47,1,3100,43000,54,1,4000, 43900,59,1,0,43000,67,1,0,42000,68,1,0,85000,69,1, 3100,43000,70,1,10000,63000,72,1,3100,43000,76,1,0 ,85000,81,1,0,85000,83,0,2999,2999,86,0,2999,2999, 87,1,6500,56000,92,1,2000,43000,93,1,2000,43000,16 9,0,500,500,270,1,0,43000,289,0,0,0,349,1,0,43000, 369,1,500,43000,469,0,3300,3300,470,1,500,43000,47 1,1,150,43000,509,1,0,43000,510,1,0,85000,529,1,20 0,43000,530,1,0,85000,549,0,2999,2999,550,0,2999,2 999,551,0,2999,2999,569,0,0,0,570,0,0,0,571,0,0,0, 574,1,0,43000,576,1,3500,50000,577,0,500,43000,589 ,1,0,43000,609,1,0,43000,729,1,0,85000,730,1,0,430 00,749,1,0,43000,809,1,0,43000,889,1,0,85000,890,1 ,0,43000,891,0,0,0,892,1,0,85000,909,1,0,43000,910 ,1,0,85000,911,1,0,85000,922,1,0,85000,930,1,3000, 43000,932,1,0,43000,933,1,0,43000,934,1,0,43000,93 5,1,0,43000,936,1,0,0,941,1,0,85000,942,1,0,43000, 946,1,0,43000,947,1,0,85000,967,1,0,43000,970,1,25 00,48000,978,1,0,43000,989,1,0,43000,990,1,0,43000 ,1005,1,3000,43000,1011,1,0,43000,1012,1,0,43000,1 015,1,0,85000,1031,1,0,43000,1038,1,0,43000,
Horde:
21,1,500,43000,46,0,0,0,47,1,3100,88100,54,1,4000, 89000,59,1,0,43000,67,1,0,43000,68,1,0,42500,69,1, 3100,88100,70,1,10000,63000,72,1,3100,88100,76,1,0 ,39900,81,1,0,39900,83,0,2999,2999,86,0,2999,2999, 87,1,6500,56000,92,1,2000,43000,93,1,2000,43000,16 9,0,500,500,270,1,0,43000,289,0,0,0,349,1,0,43000, 369,1,500,43000,469,0,3300,3300,470,1,500,43000,47 1,1,150,85150,509,1,0,85000,510,1,0,43000,529,1,20 0,43000,530,1,0,39000,549,0,2999,2999,550,0,2999,2 999,551,0,2999,2999,569,0,0,0,570,0,0,0,571,0,0,0, 574,1,0,43000,576,1,3500,50000,577,0,500,43000,589 ,1,0,85000,609,1,0,43000,729,1,0,43000,730,1,0,850 00,749,1,0,43000,809,1,0,43000,889,1,0,43000,890,1 ,0,85000,891,0,0,0,892,1,0,85000,909,1,0,43000,910 ,1,0,85000,911,1,0,42600,922,1,0,85000,930,1,3000, 88000,932,1,0,43000,933,1,0,43000,934,1,0,43000,93 5,1,0,43000,936,1,0,0,941,1,0,85000,942,1,0,43000, 946,1,0,85000,947,1,0,85000,967,1,0,43000,970,1,25 00,48000,978,1,0,85000,989,1,0,43000,990,1,0,43000 ,1005,1,3000,43000,1011,1,0,43000,1012,1,0,43000,1 015,1,0,85000,1031,1,0,43000,1038,1,0,43000,
Here is the code to paste into the Taximask field to get all flight paths, for some reason however i was not able to get the Area 52 path, it just kept saying that no flight paths were known that were attached, so oh well, better than going around and getting em all manually
2382670042 2148078929 805356359 2572156952 2284129281 262248 4 0
Here is the code to paste into the exploration_data field that will giva all maps fully explored and uncovered
1943719486,3782072279,3824146431,4159176022,117432 7839,3954720654,4294948859,3701389054,4026232943,2 012021223,4292852223,4243035871,4225286094,2002190 073,3750662132,2143329247,4274766964,1963897587,42 25759179,930703346,4294967200,538517423,4292607868 ,3882218527,1191051235,4229955586,4024424123,84446 170,1868824576,4224343039,3355957287,546193408,107 3745921,537588608,1074855936,4291035136,2140986624 ,4292869600,1140660035,2919233183,2139006989,16275 62811,1610598399,2080327927,1419230747,854327140,1 645214468,536886772,1073741824,537071616,107374182 4,536870912,1073741824,536870912,1073741824,536870 912,1073741824,536870912,1073741824,536870912,1073 741824,536870912,1073741824,1073741824,
Enjoy!
When i first got into the private servers I realized that there was no easy way to max out most of these skills. At least I havent found any easy ways to do it in the very short time as a sysop/gm on my own private server. But I am an IT professional with over 14 years of PC Networking, Coding, & Database experience. So the first thing I did was download Navicat as it is an extremely reliable tool to use to edit the Ascent databases. Next thing i did was open the databases and started fooling around. I discovered that everything is code and query based. I spent the good part of the week mapping all of the Skill codes and the structure of how the database reads it. To make a long story short (oops too late) I mapped out all of the codes and posted it below.
Explanation:
Here is what the skills field of a newly created Night Elf hunter looks like
45;3;100;50;1;100;51;5;5;95;4;100;126;5;5;162;1;10 0;163;5;5;173;4;100;183;5;5;414;1;1;415;1;1;
as you can see the numbers mean absolutely nothing to the normal eye. Here is what they mean to me-> the first number is 45, looking at the list below it tells me that this character has the Bows skill and that it is levelled to 3 out of a possible 100. All you do is Log the character out, change the 3 to 350 and change the 100 to 350, log back in and Voila! your bow skill is now 350.
One thing to be carefull of, is to actually go to the different weapons trainers and actually just learn the skill so you know it will work and your not giving Shamans sword skills or anything like that....
The same thing applies for tradeskills as it is contained in the same skills field in the database. Again remember that you start out with only 2 possible tradeskills. It is possible for you to increase the number of tradeskills that a character can have, but if you exceed it, you will have unstable results as the queries in the more advanced sections of the database can only understand the 2 tradeskills. Reputation is a bit more tricky as there are a set of 4 numbers to deal with instead of 3.
WEAPONS & SECONDARY SKILLS
43 swords
44 axes
45 bows
46 guns
54 maces
55 two handed swords
95 defense
136 staves
160 two handed maces
162 unarmed
172 two handed axes
173 daggers
176 thrown
226 crossbows
228 wands
229 polearms
762 riding
TRADESKILL CODES
129 First Aid
171 Alchemy
164 Blacksmithing
165 Leatherworking
182 Herbalism
185 Cooking
186 Mining
197 Tailoring
202 Engineering
333 Enchanting
356 Fishing
393 Skinning
755 Jewelcrafting
I have included a sample of reputation codes that you can just copy and paste into the reputation field for each faction both Horde and Alliance that will give you Exhaulted status for EVERYONE.
Im only going to paste a very small segment of the total data for a new character:
21,0,500,500,46,0,0,0,47,1,3100,3100,54,1,3100,310 0,59,0,0,0,67,2,-42000,-42000,68,2,-42000,-42000,69,1,4000,4000,70,2
As you can see this one is fairly complex with the negative numbers and all that but here is the Explanation:
As you can the code has alot of numbers that make sense but dont, well here is the sense, taking the first set of numbers. (sets of 4 numbers this time)
21,0,500,500
The first number is the reputation code 21 which in my list is booty bay
the next code is 0 which equals non existent (just doesnt show on your list in game) If the number was 1 it would show, if it were 2 it would show as At war. the next number is 500, which is the multiplier, or factor(dont worry about it you dont have to know this) the last number is your score. So if you were maximum exhaulted with Booty bay it would look like this:
21,1,500,43000
What a pain in the butt this was to figure out, so i have made it easy on everyone. at the bottom of this i have posted code that will make your character maximum exhaulted for both factions horde and alliance and are labelled as such.
REPUTATION CODES
id 21 = booty bay
id 46 = blacksmithing armorsmithing
id 47 = ironforge
id 54 = gnomeregan exiles
id 59 = thorium brotherhood
id 67 = horde
id 68 = undercity
id 69 = darnassas
id 70 = syndicate
id 72 = stormwind
id 76 = ogrimmar
id 81 = thunder bluff
id 83 = leatherworking elemental
id 86 = leatherworking dragonhyde
id 87 = bloodsail buccaneers
id 92 = gelkis clan centaur
id 93 = magram clan centaur
id 169 = ?unknown?
id 270 = zandalar tribe
id 289 = blacksmith weaponsmith
id 349 = ravenholdt
id 369 = gadgetzan
id 469 = opens "Alliance" heading
id 470 = ratchet
id 471 = wildhammer clan
id 509 = the league of arathor
id 510 = the defilers
id 529 = argent dawn
id 530 = darkspear trolls
id 549 = leatherworking tribal
id 550 = engineering - goblin
id 551 = engineering - gnome
id 569 = blacksmithing hammersmithing
id 570 = blacksmithing axesmithing
id 571 = blacksmithing swordsmithing
id 574 = caer darrow
id 576 = timbermaw hold
id 577 = everlook
id 589 = wintersaber trainers
id 609 = cenarion circle
id 729 = frostwolf clan
id 730 = stormpike guard
id 749 = hydraxian waterlords
id 809 = shen'dralar
id 889 = warsong outriders
id 890 = silverwing sentinals
id 891 = opens "Other" heading
id 892 =
id 909 = darkmoon fair
id 910 = brood of nozdormu
id 911 = silvermoon city
id 922 = Tranquillien
id 930 = exodar
id 932 = the aldor
id 933 = the consortium
id 934 = the scryers
id 935 = the sha'tar
id 936 = shows the Shatrath city heading
id 941 = the mag'har
id 942 = cenarion expedition
id 946 = honor hold
id 947 = thrallmar
id 967 = the violet eye
id 970 = sporeggar
id 978 = kurenai
id 989 = keepers of time
id 990 = the scale of the sands
id 1005 = friendly - hidden
id 1011 = lower city
id 1012 = ashtongue deathsworn
id 1015 = netherwing
id 1031 = sha'tari skyguard
id 1038 = ogri'la
Alliance:
21,1,500,43000,46,0,0,0,47,1,3100,43000,54,1,4000, 43900,59,1,0,43000,67,1,0,42000,68,1,0,85000,69,1, 3100,43000,70,1,10000,63000,72,1,3100,43000,76,1,0 ,85000,81,1,0,85000,83,0,2999,2999,86,0,2999,2999, 87,1,6500,56000,92,1,2000,43000,93,1,2000,43000,16 9,0,500,500,270,1,0,43000,289,0,0,0,349,1,0,43000, 369,1,500,43000,469,0,3300,3300,470,1,500,43000,47 1,1,150,43000,509,1,0,43000,510,1,0,85000,529,1,20 0,43000,530,1,0,85000,549,0,2999,2999,550,0,2999,2 999,551,0,2999,2999,569,0,0,0,570,0,0,0,571,0,0,0, 574,1,0,43000,576,1,3500,50000,577,0,500,43000,589 ,1,0,43000,609,1,0,43000,729,1,0,85000,730,1,0,430 00,749,1,0,43000,809,1,0,43000,889,1,0,85000,890,1 ,0,43000,891,0,0,0,892,1,0,85000,909,1,0,43000,910 ,1,0,85000,911,1,0,85000,922,1,0,85000,930,1,3000, 43000,932,1,0,43000,933,1,0,43000,934,1,0,43000,93 5,1,0,43000,936,1,0,0,941,1,0,85000,942,1,0,43000, 946,1,0,43000,947,1,0,85000,967,1,0,43000,970,1,25 00,48000,978,1,0,43000,989,1,0,43000,990,1,0,43000 ,1005,1,3000,43000,1011,1,0,43000,1012,1,0,43000,1 015,1,0,85000,1031,1,0,43000,1038,1,0,43000,
Horde:
21,1,500,43000,46,0,0,0,47,1,3100,88100,54,1,4000, 89000,59,1,0,43000,67,1,0,43000,68,1,0,42500,69,1, 3100,88100,70,1,10000,63000,72,1,3100,88100,76,1,0 ,39900,81,1,0,39900,83,0,2999,2999,86,0,2999,2999, 87,1,6500,56000,92,1,2000,43000,93,1,2000,43000,16 9,0,500,500,270,1,0,43000,289,0,0,0,349,1,0,43000, 369,1,500,43000,469,0,3300,3300,470,1,500,43000,47 1,1,150,85150,509,1,0,85000,510,1,0,43000,529,1,20 0,43000,530,1,0,39000,549,0,2999,2999,550,0,2999,2 999,551,0,2999,2999,569,0,0,0,570,0,0,0,571,0,0,0, 574,1,0,43000,576,1,3500,50000,577,0,500,43000,589 ,1,0,85000,609,1,0,43000,729,1,0,43000,730,1,0,850 00,749,1,0,43000,809,1,0,43000,889,1,0,43000,890,1 ,0,85000,891,0,0,0,892,1,0,85000,909,1,0,43000,910 ,1,0,85000,911,1,0,42600,922,1,0,85000,930,1,3000, 88000,932,1,0,43000,933,1,0,43000,934,1,0,43000,93 5,1,0,43000,936,1,0,0,941,1,0,85000,942,1,0,43000, 946,1,0,85000,947,1,0,85000,967,1,0,43000,970,1,25 00,48000,978,1,0,85000,989,1,0,43000,990,1,0,43000 ,1005,1,3000,43000,1011,1,0,43000,1012,1,0,43000,1 015,1,0,85000,1031,1,0,43000,1038,1,0,43000,
Here is the code to paste into the Taximask field to get all flight paths, for some reason however i was not able to get the Area 52 path, it just kept saying that no flight paths were known that were attached, so oh well, better than going around and getting em all manually
2382670042 2148078929 805356359 2572156952 2284129281 262248 4 0
Here is the code to paste into the exploration_data field that will giva all maps fully explored and uncovered
1943719486,3782072279,3824146431,4159176022,117432 7839,3954720654,4294948859,3701389054,4026232943,2 012021223,4292852223,4243035871,4225286094,2002190 073,3750662132,2143329247,4274766964,1963897587,42 25759179,930703346,4294967200,538517423,4292607868 ,3882218527,1191051235,4229955586,4024424123,84446 170,1868824576,4224343039,3355957287,546193408,107 3745921,537588608,1074855936,4291035136,2140986624 ,4292869600,1140660035,2919233183,2139006989,16275 62811,1610598399,2080327927,1419230747,854327140,1 645214468,536886772,1073741824,537071616,107374182 4,536870912,1073741824,536870912,1073741824,536870 912,1073741824,536870912,1073741824,536870912,1073 741824,536870912,1073741824,1073741824,
Enjoy!