[Guide] How to make any Race be any Class and play it

[Illidan1]

Hello guys, here i am going to tell
you how to be any race and any class
on that race

Follow the Steps below for this to work

Step 1 : Ok open a Note Pad and put the Following Sql Format in it

Remember everything in red you must change

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');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '71', '2165', '3339', '32', '37', '52', '149', '149');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '72', '2213', '3390', '32', '37', '53', '151', '151');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '73', '2260', '3441', '32', '37', '53', '153', '154');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '74', '2308', '3492', '32', '38', '54', '156', '156');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '75', '2355', '3543', '33', '38', '55', '158', '158');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '76', '2403', '3594', '33', '38', '55', '160', '160');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '77', '2450', '3645', '33', '39', '56', '163', '163');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '78', '2498', '3696', '33', '39', '56', '165', '165');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '79', '2545', '3747', '34', '39', '57', '167', '167');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '80', '2593', '3798', '34', '40', '57', '170', '169');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '81', '2640', '3849', '34', '40', '58', '172', '171');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '82', '2688', '3900', '34', '40', '59', '174', '174');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '83', '2735', '3951', '35', '41', '59', '177', '176');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '84', '2783', '4002', '35', '41', '60', '179', '178');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '85', '2830', '4053', '35', '41', '60', '181', '180');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '86', '2878', '4104', '35', '42', '61', '184', '182');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '87', '2925', '4155', '35', '42', '61', '186', '185');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '88', '2973', '4206', '36', '42', '62', '188', '187');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '89', '3020', '4257', '36', '42', '63', '191', '189');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '90', '3068', '4308', '36', '43', '63', '193', '191');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '91', '3115', '4359', '36', '43', '64', '195', '194');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '92', '3163', '4410', '37', '43', '64', '198', '196');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '93', '3210', '4461', '37', '44', '65', '200', '198');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '94', '3258', '4512', '37', '44', '65', '202', '200');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '95', '3305', '4563', '37', '44', '66', '205', '202');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '96', '3353', '4614', '38', '45', '67', '207', '205');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '97', '3400', '4665', '38', '45', '67', '209', '207');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '98', '3448', '4716', '38', '45', '68', '212', '209');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '99', '3495', '4767', '38', '46', '68', '214', '211');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '100', '3543', '4818', '39', '46', '69', '216', '214');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '101', '3590', '4869', '39', '46', '69', '219', '216');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '102', '3638', '4920', '39', '47', '70', '221', '218');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '103', '3685', '4971', '39', '47', '71', '223', '220');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '104', '3733', '5022', '39', '47', '71', '226', '222');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '105', '3780', '5073', '40', '48', '72', '228', '225');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '106', '3828', '5124', '40', '48', '72', '230', '227');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '107', '3875', '5175', '40', '48', '73', '233', '229');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '108', '3923', '5226', '40', '49', '73', '235', '231');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '109', '3970', '5277', '41', '49', '74', '237', '234');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '110', '4018', '5328', '41', '49', '75', '240', '236');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '111', '4065', '5379', '41', '50', '75', '242', '238');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '112', '4113', '5430', '41', '50', '76', '244', '240');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '113', '4160', '5481', '42', '50', '76', '247', '242');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '114', '4208', '5532', '42', '51', '77', '249', '245');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '115', '4255', '5583', '42', '51', '77', '251', '247');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '116', '4303', '5634', '42', '51', '78', '254', '249');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '117', '4350', '5685', '43', '52', '79', '255', '251');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '118', '4398', '5736', '43', '52', '79', '255', '253');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '119', '4445', '5787', '43', '52', '80', '255', '255');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '120', '4493', '5838', '43', '53', '80', '255', '255');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '121', '4540', '5889', '44', '53', '81', '255', '255');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '122', '4588', '5940', '44', '53', '81', '255', '255');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '123', '4635', '5991', '44', '54', '82', '255', '255');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '124', '4683', '6042', '44', '54', '83', '255', '255');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '125', '4730', '6093', '44', '54', '83', '255', '255');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '126', '4778', '6144', '45', '55', '84', '255', '255');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '127', '4825', '6195', '45', '55', '84', '255', '255');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '128', '4873', '6246', '45', '55', '85', '255', '255');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '129', '4920', '6297', '45', '56', '85', '255', '255');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '130', '4968', '6348', '46', '56', '86', '255', '255');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '131', '5015', '6399', '46', '56', '87', '255', '255');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '132', '5063', '6450', '46', '57', '87', '255', '255');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '133', '5110', '6501', '46', '57', '88', '255', '255');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '134', '5158', '6552', '47', '57', '88', '255', '255');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '135', '5205', '6603', '47', '58', '89', '255', '255');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '136', '5253', '6654', '47', '58', '89', '255', '255');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '137', '5300', '6705', '47', '58', '90', '255', '255');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '138', '5348', '6756', '48', '59', '91', '255', '255');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '139', '5395', '6807', '48', '59', '91', '255', '255');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '140', '5443', '6858', '48', '59', '92', '255', '255');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '141', '5490', '6909', '48', '60', '92', '255', '255');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '142', '5538', '6960', '48', '60', '93', '255', '255');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '143', '5585', '7011', '49', '60', '93', '255', '255');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '144', '5633', '7062', '49', '60', '94', '255', '255');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '145', '5680', '7113', '49', '61', '95', '255', '255');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '146', '5728', '7164', '49', '61', '95', '255', '255');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '147', '5775', '7215', '50', '61', '96', '255', '255');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '148', '5823', '7266', '50', '62', '96', '255', '255');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '149', '5870', '7317', '50', '62', '97', '255', '255');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '150', '5918', '7368', '50', '62', '98', '255', '255');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '151', '5965', '7419', '51', '63', '98', '255', '255');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '152', '6013', '7470', '51', '63', '99', '255', '255');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '153', '6060', '7521', '51', '63', '99', '255', '255');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '154', '6108', '7572', '51', '64', '100', '255', '255');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '155', '6155', '7623', '52', '64', '100', '255', '255');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '156', '6203', '7674', '52', '64', '101', '255', '255');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '157', '6250', '7725', '52', '65', '102', '255', '255');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '158', '6298', '7776', '52', '65', '102', '255', '255');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '159', '6345', '7827', '52', '65', '103', '255', '255');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '160', '6393', '7878', '53', '66', '103', '255', '255');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '161', '6440', '7929', '53', '66', '104', '255', '255');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '162', '6488', '7980', '53', '66', '104', '255', '255');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '163', '6535', '8031', '53', '67', '105', '255', '255');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '164', '6583', '8082', '54', '67', '106', '255', '255');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '165', '6630', '8133', '54', '67', '106', '255', '255');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '166', '6678', '8184', '54', '68', '107', '255', '255');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '167', '6725', '8235', '54', '68', '107', '255', '255');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '168', '6773', '8286', '55', '68', '108', '255', '255');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '169', '6820', '8337', '55', '69', '108', '255', '255');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '170', '6868', '8388', '55', '69', '109', '255', '255');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '171', '6915', '8439', '55', '69', '110', '255', '255');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '172', '6963', '8490', '56', '70', '110', '255', '255');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '173', '7010', '8541', '56', '70', '111', '255', '255');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '174', '7058', '8592', '56', '70', '111', '255', '255');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '175', '7105', '8643', '56', '71', '112', '255', '255');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '176', '7153', '8694', '57', '71', '112', '255', '255');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '177', '7200', '8745', '57', '71', '113', '255', '255');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '178', '7248', '8796', '57', '72', '114', '255', '255');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '179', '7295', '8847', '57', '72', '114', '255', '255');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '180', '7343', '8898', '57', '72', '115', '255', '255');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '181', '7390', '8949', '58', '73', '115', '255', '255');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '182', '7438', '9000', '58', '73', '116', '255', '255');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '183', '7485', '9051', '58', '73', '116', '255', '255');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '184', '7533', '9102', '58', '74', '117', '255', '255');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '185', '7580', '9153', '59', '74', '118', '255', '255');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '186', '7628', '9204', '59', '74', '118', '255', '255');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '187', '7675', '9255', '59', '75', '119', '255', '255');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '188', '7723', '9306', '59', '75', '119', '255', '255');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '189', '7770', '9357', '60', '75', '120', '255', '255');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '190', '7818', '9408', '60', '76', '120', '255', '255');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '191', '7865', '9459', '60', '76', '121', '255', '255');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '192', '7913', '9510', '60', '76', '122', '255', '255');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '193', '7960', '9561', '61', '77', '122', '255', '255');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '194', '8008', '9612', '61', '77', '123', '255', '255');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '195', '8055', '9663', '61', '77', '123', '255', '255');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '196', '8103', '9714', '61', '78', '124', '255', '255');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '197', '8150', '9765', '61', '78', '124', '255', '255');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '198', '8198', '9816', '62', '78', '125', '255', '255');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '199', '8245', '9867', '62', '78', '126', '255', '255');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '200', '8293', '9918', '62', '79', '126', '255', '255');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '201', '8340', '9969', '62', '79', '127', '255', '255');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '202', '8388', '10020', '63', '79', '127', '255', '255');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '203', '8435', '10071', '63', '80', '128', '255', '255');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '204', '8483', '10122', '63', '80', '128', '255', '255');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '205', '8530', '10173', '63', '80', '129', '255', '255');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '206', '8578', '10224', '64', '81', '130', '255', '255');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '207', '8625', '10275', '64', '81', '130', '255', '255');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '208', '8673', '10326', '64', '81', '131', '255', '255');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '209', '8720', '10377', '64', '82', '131', '255', '255');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '210', '8768', '10428', '65', '82', '132', '255', '255');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '211', '8815', '10479', '65', '82', '132', '255', '255');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '212', '8863', '10530', '65', '83', '133', '255', '255');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '213', '8910', '10581', '65', '83', '134', '255', '255');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '214', '8958', '10632', '65', '83', '134', '255', '255');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '215', '9005', '10683', '66', '84', '135', '255', '255');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '216', '9053', '10734', '66', '84', '135', '255', '255');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '217', '9100', '10785', '66', '84', '136', '255', '255');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '218', '9148', '10836', '66', '85', '136', '255', '255');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '219', '9195', '10887', '67', '85', '137', '255', '255');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '220', '9243', '10938', '67', '85', '138', '255', '255');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '221', '9290', '10989', '67', '86', '138', '255', '255');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '222', '9338', '11040', '67', '86', '139', '255', '255');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '223', '9385', '11091', '68', '86', '139', '255', '255');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '224', '9433', '11142', '68', '87', '140', '255', '255');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '225', '9480', '11193', '68', '87', '140', '255', '255');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '226', '9528', '11244', '68', '87', '141', '255', '255');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '227', '9575', '11295', '69', '88', '142', '255', '255');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '228', '9623', '11346', '69', '88', '142', '255', '255');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '229', '9670', '11397', '69', '88', '143', '255', '255');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '230', '9718', '11448', '69', '89', '143', '255', '255');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '231', '9765', '11499', '70', '89', '144', '255', '255');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '232', '9813', '11550', '70', '89', '144', '255', '255');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '233', '9860', '11601', '70', '90', '145', '255', '255');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '234', '9908', '11652', '70', '90', '146', '255', '255');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '235', '9955', '11703', '70', '90', '146', '255', '255');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '236', '10003', '11754', '71', '91', '147', '255', '255');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '237', '10050', '11805', '71', '91', '147', '255', '255');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '238', '10098', '11856', '71', '91', '148', '255', '255');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '239', '10145', '11907', '71', '92', '148', '255', '255');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '240', '10193', '11958', '72', '92', '149', '255', '255');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '241', '10240', '12009', '72', '92', '150', '255', '255');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '242', '10288', '12060', '72', '93', '150', '255', '255');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '243', '10335', '12111', '72', '93', '151', '255', '255');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '244', '10383', '12162', '73', '93', '151', '255', '255');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '245', '10430', '12213', '73', '94', '152', '255', '255');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '246', '10478', '12264', '73', '94', '152', '255', '255');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '247', '10525', '12315', '73', '94', '153', '255', '255');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '248', '10573', '12366', '74', '95', '154', '255', '255');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '249', '10620', '12417', '74', '95', '154', '255', '255');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '250', '10668', '12468', '74', '95', '155', '255', '255');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '251', '10715', '12519', '74', '96', '155', '255', '255');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '252', '10763', '12570', '74', '96', '156', '255', '255');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '253', '10810', '12621', '75', '96', '156', '255', '255');
INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '254', '10858', '12672', '75', '96', '157', '255', '255');



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

Step 2 : INSERT INTO `player_levelstats` VALUES ('Race', '8', '2', '77', '160', '19', '18', '21', '22', '28'); = The ID of the Race you wont (Remember you must do this all the way down)

Race ID \/

1 Human
2 Orc
3 Dwarf
4 Night Elf
5 Undead
6 Tauren
7 Gnome
8 Troll
10 Blood Elf
11 Draenis

Step 3 : INSERT INTO `player_levelstats` VALUES ('Race', 'Class', '2', '77', '160', '19', '18', '21', '22', '28'); = The Class Id (Remember You must do this all the way down)

Class ID \/

1 Warrior
2 Paladin
3 Hunter
4 Rogue
5 Priest
7 Shaman
8 Mage
9 Warlock
11 Druid

Step 4 : 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'); = the Id of the Race you are making (Look up for Race ID's)

Step 5 : 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'); = the Faction ID of your race (Look down for Faction Ids)


Factiontemplate ID

1 Human
2 Orc
3 Dwarf
4 Night Elf
5 Undead
6 Tauren
115 Gnome
116 Troll
1610 Blood Elf
1629 Draenis

Step 6 : 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'); = The Id of the Class you wont your Race to be (Look up to see a list of Clss Id's)

Step 7 : 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'); = The Map Id of were your Character is going to be spawned when you first login

Step 8 : 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'); = The Map Id of were your Character is going to be spawned when you first login

Step 9 : 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'); = The "X" position of were your Character is going to be spawned when you first login

Step 10 : 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'); = The "Y" position of were your Character is going to be spawned when you first login

Step 11 : 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'); = The "Z" position of were your Character is going to be spawned when you first login

Step 12 : 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'); = The Display Id of your Race (Look down to look for Display For your Race)

Race Display Id \/

1563 (Gnome)
49 (Human)
51 (Orc)
53 (Dwarf)
55 (Night Elf)
57 (Undead)
59 (Tauren)
1478 (Troll)
15476 (Blood Elf)
16125 (Drenia)

Step 12 : in the note pad go to File > Save as And then save it on your Desktop or somewhere you know were it is

Naming it : Name it "Custom.sql"
Make sure you have the ".sql" at the end of the name,
and then look on your Desktop for a "sql" that is called custom and then Go into your Database Editor
And execute that into it

Making the Character : Ok now we have to make the character, Go into Your Database in find the
Table Called "Characters" Open it and then you will see this Sql Format \/

INSERT INTO `characters` (`guid`,`acct`,`name`,`race`,`class`,`gender`,`level`,`xp`,`exploration_data`,`skills`,`watched_faction_index`,`selected_pvp_title`,`available_pvp_titles`,`gold`,`ammo_id`,`available_prof_points`,`available_talent_points`,`current_hp`,`current_power`,`pvprank`,`bytes`,`bytes2`,`player_flags`,`player_bytes`,`positionX`,`positionY`,`positionZ`,`orientation`,`mapId`,`zoneId`,`taximask`,`banned`,`banReason`,`timestamp`,`online`,`bindpositionX`,`bindpositionY`,`bindpositionZ`,`bindmapId`,`bindzoneId`,`isResting`,`restState`,`restTime`,`playedtime`,`deathstate`,`TalentResetTimes`,`first_login`,`forced_rename_pending`,`publicNote`,`officerNote`,`guildid`,`guildRank`,`charterId`,`totalstableslots`,`instance_id`,`entrypointmap`,`entrypointx`,`entrypointy`,`entrypointz`,`entrypointo`,`entrypointinstance`,`taxi_path`,`taxi_lastnode`,`taxi_mountid`,`transporter`,`transporter_xdiff`,`transporter_ydiff`,`transporter_zdiff`,`spells`,`deleted_spells`,`reputation`,`actions`,`auras`,`finished_quests`,`lastDailyReset`,`killsToday`,`killsYesterday`,`killsLifeTime`,`honorToday`,`honorYesterday`,`honorPoints`,`difficulty`)

You will Only need to fill in th Follow Sql Formats

guid`,`acct`,`name`,`race`,`class`,`gender`,`level

Guid = Any high number that is not taken
Acct = The Number of the Account (If your Admin of Server it will be 1-5) Go to the table "Accounts" to find what account Number you are
Name = the name of your Character
Race = The Race Id of your Character

Race ID's

1 Human
2 Orc
3 Dwarf
4 Night Elf
5 Undead
6 Tauren
7 Gnome
8 Troll
10 Blood Elf
11 Draenis

Class = The class Id of your Race

Class Id's

1 Warrior
2 Paladin
3 Hunter
4 Rogue
5 Priest
7 Shaman
8 Mage
9 Warlock
11 Druid

Gender = the Sex of your Race

Gender Id's

0 = Male
1 = Female

Level = the Level of your Character (Make it 1)

And then your Done, Restart your Server, Logon your new Character
And there ya go

Pictures \/
Night Elf Mage



In game



Thank you fro your time, I hope this help's you, Have fun being random Races / Classes

I will be adding Every Race with Every Class as well

[Summer]

lol look's cool xD

can you help ?

i got my server up now and im have chrispee's db but every thing on that db is for free :S how do i mod this ? so thay buy the item's

[Illidan1]

Go into Your Database and find the Table called
"Items" And scroll along and you will have to change all the "Buyprice" and
"Sellprice" your self

[Summer]

okey Thx =) I Would give you rep but i cant :S

[Summer]

cant you just send item table to me ? =)

[Hazshadow]

Thanks Illidan +rep

[Gastricpenguin]

1) Posted before (not only do you have to use the search button, but you need to actually look...)
1.5) Doing this can drastically affect your database. If you do not have a backup, you pretty much just ****ed yourself.

2) There is a much simpler way of doing this. Its called clicking on the [ Create Character ] Button.

[Illidan1]

1) Posted before (not only do you have to use the search button, but you need to actually look...)
1.5) Doing this can drastically affect your database. If you do not have a backup, you pretty much just ****ed yourself.

2) There is a much simpler way of doing this. Its called clicking on the [ Create Character ] Button.

Humm Could you give me link to the other 1 please

And true i guess it could screw yah Database

And lol you can't [ Create Character ] a Blood elf Druid =)

[Daxo]

Humm Could you give me link to the other 1 please

And true i guess it could screw yah Database

And lol you can't [ Create Character ] a Blood elf Druid =)

True dat... i should play on your server

[Le Froid]

i posted this before on http://www.mmowned.com/forums/ascent...bo-ascent.html
but thanks for bringing a newer version back because before you didnt need to add to player levelstats(mine was up to rev 1000 something then it didnt work) so +rep

[sticksx]

thank's =)

[LTGH]

Traxxas edit dont dubble post... i did and got a warning from an admin befor.

EDIT: Is it that hard to create a tauren rogue? :'(

[Glynbeard]

I had to find most of those values by myself back in the day :/.

[jtmurkz]

When i go to "Execute Batch File" its Says ERROR then some random stuff and then it says finished unsuccessfully! Please help i really want a mix up
Thanks

[Bernossy]

Nice guide but can't your character get really buggy because of that?
I remember reading a similar guide back then and someone stated you should be really careful with this... :confused: