[release] start with all skills (not spells) menu

User Tag List

Results 1 to 9 of 9
  1. #1
    Nesox's Avatar ★ Elder ★
    Reputation
    1280
    Join Date
    Mar 2007
    Posts
    1,238
    Thanks G/R
    0/3
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    [release] start with all skills (not spells)

    Hi ive been working on this for some days now and i thought i would share this so u dont have to spend several hours for this.. im currently working on spells too but it takes alot of time ive done 4 classes so far got 5 more when those are done ill make anoter thread for the spells, hope you Enjoy! :wave:

    -------------------------
    Table of Content
    -------------------------
    1.1 - Druid
    1.2 - Hunter
    1.3 - Mage
    1.4 - Pala
    1.5 - Priest
    1.6 - Rogue
    1.7 - Shaman
    1.8 - Warlock
    1.9 - Warrior
    -------------------------

    1.1 - Druid
    Code:
    /*Nightelf Druid*/
    
    DELETE FROM playercreateinfo_skills where indexid = 42;
    
    INSERT INTO playercreateinfo_skills VALUES ('42','574','1','1');	
    INSERT INTO playercreateinfo_skills VALUES ('42','573','1','1');	
    INSERT INTO playercreateinfo_skills VALUES ('42','134','1','1');	
    INSERT INTO playercreateinfo_skills VALUES ('42','762','300','300');	
    INSERT INTO playercreateinfo_skills VALUES ('42','173','350','350');		
    INSERT INTO playercreateinfo_skills VALUES ('42','95','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('42','54','350','350');	
    INSERT INTO playercreateinfo_skills VALUES ('42','160','350','350');	
    INSERT INTO playercreateinfo_skills VALUES ('42','136','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('42','162','350','350');
    
    /*Tauren Druid*/
    
    DELETE FROM playercreateinfo_skills where indexid = 43;
    
    INSERT INTO playercreateinfo_skills VALUES ('43','574','1','1');	
    INSERT INTO playercreateinfo_skills VALUES ('43','573','1','1');	
    INSERT INTO playercreateinfo_skills VALUES ('43','134','1','1');	
    INSERT INTO playercreateinfo_skills VALUES ('43','762','300','300');	
    INSERT INTO playercreateinfo_skills VALUES ('43','173','350','350');	
    INSERT INTO playercreateinfo_skills VALUES ('43','95','350','350');	
    INSERT INTO playercreateinfo_skills VALUES ('43','54','350','350');	
    INSERT INTO playercreateinfo_skills VALUES ('43','160','350','350');	
    INSERT INTO playercreateinfo_skills VALUES ('43','136','350','350');	
    INSERT INTO playercreateinfo_skills VALUES ('43','162','350','350');
    1.2 - Hunter
    Code:
    /*Orc Hunter*/
    
    DELETE FROM playercreateinfo_skills where indexid = 11;
    
    INSERT INTO playercreateinfo_skills VALUES ('11','50','1','1');
    INSERT INTO playercreateinfo_skills VALUES ('11','163','1','1');
    INSERT INTO playercreateinfo_skills VALUES ('11','51','1','1');
    INSERT INTO playercreateinfo_skills VALUES ('11','762','300','300');
    INSERT INTO playercreateinfo_skills VALUES ('11','44','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('11','172','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('11','45','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('11','226','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('11','173','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('11','95','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('11','46','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('11','229','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('11','136','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('11','43','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('11','55','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('11','176','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('11','162','350','350');
    
    /*Dwarf Hunter*/
    
    DELETE FROM playercreateinfo_skills where indexid = 12;
    
    INSERT INTO playercreateinfo_skills VALUES ('12','50','1','1');
    INSERT INTO playercreateinfo_skills VALUES ('12','163','1','1');
    INSERT INTO playercreateinfo_skills VALUES ('12','51','1','1');
    INSERT INTO playercreateinfo_skills VALUES ('12','762','300','300');
    INSERT INTO playercreateinfo_skills VALUES ('12','44','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('12','172','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('12','45','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('12','226','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('12','173','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('12','95','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('12','46','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('12','229','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('12','136','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('12','43','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('12','55','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('12','176','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('12','162','350','350');
    
    /*Nightelf*/
    
    DELETE FROM playercreateinfo_skills where indexid = 15;
    
    INSERT INTO playercreateinfo_skills VALUES ('15','50','1','1');
    INSERT INTO playercreateinfo_skills VALUES ('15','163','1','1');
    INSERT INTO playercreateinfo_skills VALUES ('15','51','1','1');
    INSERT INTO playercreateinfo_skills VALUES ('15','762','300','300');
    INSERT INTO playercreateinfo_skills VALUES ('15','44','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('15','172','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('15','45','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('15','226','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('15','173','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('15','95','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('15','46','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('15','229','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('15','136','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('15','43','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('15','55','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('15','176','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('15','162','350','350');
    
    /*Tauren Hunter*/
    
    DELETE FROM playercreateinfo_skills where indexid = 16;
    
    INSERT INTO playercreateinfo_skills VALUES ('16','50','1','1');
    INSERT INTO playercreateinfo_skills VALUES ('16','163','1','1');
    INSERT INTO playercreateinfo_skills VALUES ('16','51','1','1');
    INSERT INTO playercreateinfo_skills VALUES ('16','762','300','300');
    INSERT INTO playercreateinfo_skills VALUES ('16','44','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('16','172','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('16','45','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('16','226','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('16','173','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('16','95','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('16','46','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('16','229','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('16','136','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('16','43','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('16','55','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('16','176','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('16','162','350','350');
    
    /*Troll Hunter*/
    
    DELETE FROM playercreateinfo_skills where indexid = 17;
    
    INSERT INTO playercreateinfo_skills VALUES ('17','50','1','1');
    INSERT INTO playercreateinfo_skills VALUES ('17','163','1','1');
    INSERT INTO playercreateinfo_skills VALUES ('17','51','1','1');
    INSERT INTO playercreateinfo_skills VALUES ('17','762','300','300');
    INSERT INTO playercreateinfo_skills VALUES ('17','44','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('17','172','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('17','45','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('17','226','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('17','173','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('17','95','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('17','46','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('17','229','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('17','136','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('17','43','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('17','55','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('17','176','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('17','162','350','350');
    
    /*Draenie Hunter*/
    
    DELETE FROM playercreateinfo_skills where indexid = 46;
    
    INSERT INTO playercreateinfo_skills VALUES ('46','50','1','1');
    INSERT INTO playercreateinfo_skills VALUES ('46','163','1','1');
    INSERT INTO playercreateinfo_skills VALUES ('46','51','1','1');
    INSERT INTO playercreateinfo_skills VALUES ('46','762','300','300');
    INSERT INTO playercreateinfo_skills VALUES ('46','44','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('46','172','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('46','45','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('46','226','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('46','173','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('46','95','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('46','46','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('46','229','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('46','136','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('46','43','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('46','55','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('46','176','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('46','162','350','350');
    
    /*Bloodelf Hunter*/
    
    DELETE FROM playercreateinfo_skills where indexid = 51;
    
    INSERT INTO playercreateinfo_skills VALUES ('51','50','1','1');
    INSERT INTO playercreateinfo_skills VALUES ('51','163','1','1');
    INSERT INTO playercreateinfo_skills VALUES ('51','51','1','1');
    INSERT INTO playercreateinfo_skills VALUES ('51','762','300','300');
    INSERT INTO playercreateinfo_skills VALUES ('51','44','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('51','172','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('51','45','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('51','226','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('51','173','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('51','95','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('51','46','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('51','229','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('51','136','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('51','43','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('51','55','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('51','176','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('51','162','350','350');
    1.3 - Mage
    Code:
    /*Human Mage*/
    
    DELETE FROM playercreateinfo_skills where indexid = 34;
    
    INSERT INTO playercreateinfo_skills VALUES ('34','8','1','1');
    INSERT INTO playercreateinfo_skills VALUES ('34','6','1','1');
    INSERT INTO playercreateinfo_skills VALUES ('34','237','1','1');
    INSERT INTO playercreateinfo_skills VALUES ('34','762','300','300');
    INSERT INTO playercreateinfo_skills VALUES ('34','173','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('34','95','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('34','136','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('34','43','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('34','173','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('34','162','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('34','228','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('34','415','1','1');
    
    /*Undead Mage*/
    
    DELETE FROM playercreateinfo_skills where indexid = 35;
    
    INSERT INTO playercreateinfo_skills VALUES ('35','8','1','1');
    INSERT INTO playercreateinfo_skills VALUES ('35','6','1','1');
    INSERT INTO playercreateinfo_skills VALUES ('35','237','1','1');
    INSERT INTO playercreateinfo_skills VALUES ('35','762','300','300');
    INSERT INTO playercreateinfo_skills VALUES ('35','173','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('35','95','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('35','136','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('35','43','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('35','173','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('35','162','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('35','228','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('35','415','1','1');
    
    /*Gnome Mage*/
    
    DELETE FROM playercreateinfo_skills where indexid = 36;
    
    INSERT INTO playercreateinfo_skills VALUES ('36','8','1','1');
    INSERT INTO playercreateinfo_skills VALUES ('36','6','1','1');
    INSERT INTO playercreateinfo_skills VALUES ('36','237','1','1');
    INSERT INTO playercreateinfo_skills VALUES ('36','762','300','300');
    INSERT INTO playercreateinfo_skills VALUES ('36','173','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('36','95','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('36','136','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('36','43','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('36','173','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('36','162','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('36','228','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('36','415','1','1');
    
    /*Troll Mage*/
    
    DELETE FROM playercreateinfo_skills where indexid = 37;
    
    INSERT INTO playercreateinfo_skills VALUES ('37','8','1','1');
    INSERT INTO playercreateinfo_skills VALUES ('37','6','1','1');
    INSERT INTO playercreateinfo_skills VALUES ('37','237','1','1');
    INSERT INTO playercreateinfo_skills VALUES ('37','762','300','300');
    INSERT INTO playercreateinfo_skills VALUES ('37','173','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('37','95','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('37','136','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('37','43','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('37','173','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('37','162','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('37','228','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('37','415','1','1');
    
    /*Draenie Mage*/
    
    DELETE FROM playercreateinfo_skills where indexid = 49;
    
    INSERT INTO playercreateinfo_skills VALUES ('49','8','1','1');
    INSERT INTO playercreateinfo_skills VALUES ('49','6','1','1');
    INSERT INTO playercreateinfo_skills VALUES ('49','237','1','1');
    INSERT INTO playercreateinfo_skills VALUES ('49','762','300','300');
    INSERT INTO playercreateinfo_skills VALUES ('49','173','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('49','95','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('49','136','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('49','43','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('49','173','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('49','162','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('49','228','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('49','415','1','1');
    
    /*Bloodelf Mage*/
    
    DELETE FROM playercreateinfo_skills where indexid = 54;
    
    INSERT INTO playercreateinfo_skills VALUES ('54','8','1','1');
    INSERT INTO playercreateinfo_skills VALUES ('54','6','1','1');
    INSERT INTO playercreateinfo_skills VALUES ('54','237','1','1');
    INSERT INTO playercreateinfo_skills VALUES ('54','762','300','300');
    INSERT INTO playercreateinfo_skills VALUES ('54','173','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('54','95','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('54','136','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('54','43','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('54','173','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('54','162','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('54','228','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('54','415','1','1');
    1.4 - Pala
    Code:
    /*Human Paladin*/
    
    DELETE FROM playercreateinfo_skills where indexid = 9;
    
    INSERT INTO `playercreateinfo_skills` VALUES ('9', '183', '375', '375');
    INSERT INTO `playercreateinfo_skills` VALUES ('9', '754', '375', '375');
    INSERT INTO `playercreateinfo_skills` VALUES ('9', '433', '375', '375');
    INSERT INTO `playercreateinfo_skills` VALUES ('9', '98', '300', '300');
    INSERT INTO `playercreateinfo_skills` VALUES ('9', '415', '375', '375');
    INSERT INTO `playercreateinfo_skills` VALUES ('9', '95', '375', '375');
    INSERT INTO `playercreateinfo_skills` VALUES ('9', '160', '375', '375');
    INSERT INTO `playercreateinfo_skills` VALUES ('9', '413', '375', '375');
    INSERT INTO `playercreateinfo_skills` VALUES ('9', '414', '375', '375');
    INSERT INTO `playercreateinfo_skills` VALUES ('9', '54', '375', '375');
    INSERT INTO `playercreateinfo_skills` VALUES ('9', '162', '375', '375');
    INSERT INTO `playercreateinfo_skills` VALUES ('9', '44', '375', '375');
    INSERT INTO `playercreateinfo_skills` VALUES ('9', '172', '350', '350');
    INSERT INTO `playercreateinfo_skills` VALUES ('9', '43', '350', '350');
    INSERT INTO `playercreateinfo_skills` VALUES ('9', '55', '350', '350');
    INSERT INTO `playercreateinfo_skills` VALUES ('9', '184', '1', '1');
    INSERT INTO `playercreateinfo_skills` VALUES ('9', '267', '1', '1');
    INSERT INTO `playercreateinfo_skills` VALUES ('9', '594', '1', '1');
    INSERT INTO `playercreateinfo_skills` VALUES ('9', '229', '350', '350');
    INSERT INTO `playercreateinfo_skills` VALUES ('9', '762', '300', '300');
    
    /*Dwarf Paladin*/
    
    DELETE FROM playercreateinfo_skills where indexid = 10;
    
    INSERT INTO `playercreateinfo_skills` VALUES ('10', '183', '375', '375');
    INSERT INTO `playercreateinfo_skills` VALUES ('10', '754', '375', '375');
    INSERT INTO `playercreateinfo_skills` VALUES ('10', '433', '375', '375');
    INSERT INTO `playercreateinfo_skills` VALUES ('10', '98', '300', '300');
    INSERT INTO `playercreateinfo_skills` VALUES ('10', '415', '375', '375');
    INSERT INTO `playercreateinfo_skills` VALUES ('10', '95', '375', '375');
    INSERT INTO `playercreateinfo_skills` VALUES ('10', '160', '375', '375');
    INSERT INTO `playercreateinfo_skills` VALUES ('10', '413', '375', '375');
    INSERT INTO `playercreateinfo_skills` VALUES ('10', '414', '375', '375');
    INSERT INTO `playercreateinfo_skills` VALUES ('10', '54', '375', '375');
    INSERT INTO `playercreateinfo_skills` VALUES ('10', '162', '375', '375');
    INSERT INTO `playercreateinfo_skills` VALUES ('10', '44', '375', '375');
    INSERT INTO `playercreateinfo_skills` VALUES ('10', '172', '350', '350');
    INSERT INTO `playercreateinfo_skills` VALUES ('10', '43', '350', '350');
    INSERT INTO `playercreateinfo_skills` VALUES ('10', '55', '350', '350');
    INSERT INTO `playercreateinfo_skills` VALUES ('10', '184', '1', '1');
    INSERT INTO `playercreateinfo_skills` VALUES ('10', '267', '1', '1');
    INSERT INTO `playercreateinfo_skills` VALUES ('10', '594', '1', '1');
    INSERT INTO `playercreateinfo_skills` VALUES ('10', '229', '350', '350');
    INSERT INTO `playercreateinfo_skills` VALUES ('10', '762', '300', '300');
    
    /*Draenie Paladin*/
    
    DELETE FROM playercreateinfo_skills where indexid = 45;
    
    INSERT INTO `playercreateinfo_skills` VALUES ('45', '183', '375', '375');
    INSERT INTO `playercreateinfo_skills` VALUES ('45', '754', '375', '375');
    INSERT INTO `playercreateinfo_skills` VALUES ('45', '433', '375', '375');
    INSERT INTO `playercreateinfo_skills` VALUES ('45', '98', '300', '300');
    INSERT INTO `playercreateinfo_skills` VALUES ('45', '415', '375', '375');
    INSERT INTO `playercreateinfo_skills` VALUES ('45', '95', '375', '375');
    INSERT INTO `playercreateinfo_skills` VALUES ('45', '160', '375', '375');
    INSERT INTO `playercreateinfo_skills` VALUES ('45', '413', '375', '375');
    INSERT INTO `playercreateinfo_skills` VALUES ('45', '414', '375', '375');
    INSERT INTO `playercreateinfo_skills` VALUES ('45', '54', '375', '375');
    INSERT INTO `playercreateinfo_skills` VALUES ('45', '162', '375', '375');
    INSERT INTO `playercreateinfo_skills` VALUES ('45', '44', '375', '375');
    INSERT INTO `playercreateinfo_skills` VALUES ('45', '172', '350', '350');
    INSERT INTO `playercreateinfo_skills` VALUES ('45', '43', '350', '350');
    INSERT INTO `playercreateinfo_skills` VALUES ('45', '55', '350', '350');
    INSERT INTO `playercreateinfo_skills` VALUES ('45', '184', '1', '1');
    INSERT INTO `playercreateinfo_skills` VALUES ('45', '267', '1', '1');
    INSERT INTO `playercreateinfo_skills` VALUES ('45', '594', '1', '1');
    INSERT INTO `playercreateinfo_skills` VALUES ('45', '229', '350', '350');
    INSERT INTO `playercreateinfo_skills` VALUES ('45', '762', '300', '300');
    
    /*Bloodelf Paladin*/
    
    DELETE FROM playercreateinfo_skills where indexid = 50;
    
    INSERT INTO `playercreateinfo_skills` VALUES ('50', '183', '375', '375');
    INSERT INTO `playercreateinfo_skills` VALUES ('50', '754', '375', '375');
    INSERT INTO `playercreateinfo_skills` VALUES ('50', '433', '375', '375');
    INSERT INTO `playercreateinfo_skills` VALUES ('50', '98', '300', '300');
    INSERT INTO `playercreateinfo_skills` VALUES ('50', '415', '375', '375');
    INSERT INTO `playercreateinfo_skills` VALUES ('50', '95', '375', '375');
    INSERT INTO `playercreateinfo_skills` VALUES ('50', '160', '375', '375');
    INSERT INTO `playercreateinfo_skills` VALUES ('50', '413', '375', '375');
    INSERT INTO `playercreateinfo_skills` VALUES ('50', '414', '375', '375');
    INSERT INTO `playercreateinfo_skills` VALUES ('50', '54', '375', '375');
    INSERT INTO `playercreateinfo_skills` VALUES ('50', '162', '375', '375');
    INSERT INTO `playercreateinfo_skills` VALUES ('50', '44', '375', '375');
    INSERT INTO `playercreateinfo_skills` VALUES ('50', '172', '350', '350');
    INSERT INTO `playercreateinfo_skills` VALUES ('50', '43', '350', '350');
    INSERT INTO `playercreateinfo_skills` VALUES ('50', '55', '350', '350');
    INSERT INTO `playercreateinfo_skills` VALUES ('50', '184', '1', '1');
    INSERT INTO `playercreateinfo_skills` VALUES ('50', '267', '1', '1');
    INSERT INTO `playercreateinfo_skills` VALUES ('50', '594', '1', '1');
    INSERT INTO `playercreateinfo_skills` VALUES ('50', '229', '350', '350');
    INSERT INTO `playercreateinfo_skills` VALUES ('50', '762', '300', '300');
    1.5 - Priest
    Code:
    /*Human Priest*/
    
    DELETE FROM playercreateinfo_skills where indexid = 25;
    
    INSERT INTO playercreateinfo_skills VALUES ('25','183','375','375');
    INSERT INTO playercreateinfo_skills VALUES ('25','220','375','375');
    INSERT INTO playercreateinfo_skills VALUES ('25','228','375','375');
    INSERT INTO playercreateinfo_skills VALUES ('25','109','300','300');
    INSERT INTO playercreateinfo_skills VALUES ('25','415','375','375');
    INSERT INTO playercreateinfo_skills VALUES ('25','673','375','375');
    INSERT INTO playercreateinfo_skills VALUES ('25','95','375','375');
    INSERT INTO playercreateinfo_skills VALUES ('25','54','375','375');
    INSERT INTO playercreateinfo_skills VALUES ('25','162','375','375');
    INSERT INTO playercreateinfo_skills VALUES ('25','762','300','300');
    INSERT INTO playercreateinfo_skills VALUES ('25','173','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('25','136','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('25','78','1','1');
    INSERT INTO playercreateinfo_skills VALUES ('25','613','1','1');
    INSERT INTO playercreateinfo_skills VALUES ('25','56','1','1');
    
    /*Dwarf Priest*/
    
    DELETE FROM playercreateinfo_skills where indexid = 26;
    
    INSERT INTO playercreateinfo_skills VALUES ('26','183','375','375');
    INSERT INTO playercreateinfo_skills VALUES ('26','220','375','375');
    INSERT INTO playercreateinfo_skills VALUES ('26','228','375','375');
    INSERT INTO playercreateinfo_skills VALUES ('26','109','300','300');
    INSERT INTO playercreateinfo_skills VALUES ('26','415','375','375');
    INSERT INTO playercreateinfo_skills VALUES ('26','673','375','375');
    INSERT INTO playercreateinfo_skills VALUES ('26','95','375','375');
    INSERT INTO playercreateinfo_skills VALUES ('26','54','375','375');
    INSERT INTO playercreateinfo_skills VALUES ('26','162','375','375');
    INSERT INTO playercreateinfo_skills VALUES ('26','762','300','300');
    INSERT INTO playercreateinfo_skills VALUES ('26','173','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('26','136','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('26','78','1','1');
    INSERT INTO playercreateinfo_skills VALUES ('26','613','1','1');
    INSERT INTO playercreateinfo_skills VALUES ('26','56','1','1');
    
    /*Nightelf Priest*/
    
    DELETE FROM playercreateinfo_skills where indexid = 27;
    
    INSERT INTO playercreateinfo_skills VALUES ('27','183','375','375');
    INSERT INTO playercreateinfo_skills VALUES ('27','220','375','375');
    INSERT INTO playercreateinfo_skills VALUES ('27','228','375','375');
    INSERT INTO playercreateinfo_skills VALUES ('27','109','300','300');
    INSERT INTO playercreateinfo_skills VALUES ('27','415','375','375');
    INSERT INTO playercreateinfo_skills VALUES ('27','673','375','375');
    INSERT INTO playercreateinfo_skills VALUES ('27','95','375','375');
    INSERT INTO playercreateinfo_skills VALUES ('27','54','375','375');
    INSERT INTO playercreateinfo_skills VALUES ('27','162','375','375');
    INSERT INTO playercreateinfo_skills VALUES ('27','762','300','300');
    INSERT INTO playercreateinfo_skills VALUES ('27','173','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('27','136','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('27','78','1','1');
    INSERT INTO playercreateinfo_skills VALUES ('27','613','1','1');
    INSERT INTO playercreateinfo_skills VALUES ('27','56','1','1');
    
    /*Undead Priest*/
    
    DELETE FROM playercreateinfo_skills where indexid = 28;
    
    INSERT INTO playercreateinfo_skills VALUES ('28','183','375','375');
    INSERT INTO playercreateinfo_skills VALUES ('28','220','375','375');
    INSERT INTO playercreateinfo_skills VALUES ('28','228','375','375');
    INSERT INTO playercreateinfo_skills VALUES ('28','109','300','300');
    INSERT INTO playercreateinfo_skills VALUES ('28','415','375','375');
    INSERT INTO playercreateinfo_skills VALUES ('28','673','375','375');
    INSERT INTO playercreateinfo_skills VALUES ('28','95','375','375');
    INSERT INTO playercreateinfo_skills VALUES ('28','54','375','375');
    INSERT INTO playercreateinfo_skills VALUES ('28','162','375','375');
    INSERT INTO playercreateinfo_skills VALUES ('28','762','300','300');
    INSERT INTO playercreateinfo_skills VALUES ('28','173','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('28','136','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('28','78','1','1');
    INSERT INTO playercreateinfo_skills VALUES ('28','613','1','1');
    INSERT INTO playercreateinfo_skills VALUES ('28','56','1','1');
    
    
    /*Troll Priest*/
    
    DELETE FROM playercreateinfo_skills where indexid = 29;
    
    INSERT INTO playercreateinfo_skills VALUES ('29','183','375','375');
    INSERT INTO playercreateinfo_skills VALUES ('29','220','375','375');
    INSERT INTO playercreateinfo_skills VALUES ('29','228','375','375');
    INSERT INTO playercreateinfo_skills VALUES ('29','109','300','300');
    INSERT INTO playercreateinfo_skills VALUES ('29','415','375','375');
    INSERT INTO playercreateinfo_skills VALUES ('29','673','375','375');
    INSERT INTO playercreateinfo_skills VALUES ('29','95','375','375');
    INSERT INTO playercreateinfo_skills VALUES ('29','54','375','375');
    INSERT INTO playercreateinfo_skills VALUES ('29','162','375','375');
    INSERT INTO playercreateinfo_skills VALUES ('29','762','300','300');
    INSERT INTO playercreateinfo_skills VALUES ('29','173','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('29','136','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('29','78','1','1');
    INSERT INTO playercreateinfo_skills VALUES ('29','613','1','1');
    INSERT INTO playercreateinfo_skills VALUES ('29','56','1','1');
    
    /*Draenie Priest*/
    
    DELETE FROM playercreateinfo_skills where indexid = 47;
    
    INSERT INTO playercreateinfo_skills VALUES ('47','183','375','375');
    INSERT INTO playercreateinfo_skills VALUES ('47','220','375','375');
    INSERT INTO playercreateinfo_skills VALUES ('47','228','375','375');
    INSERT INTO playercreateinfo_skills VALUES ('47','109','300','300');
    INSERT INTO playercreateinfo_skills VALUES ('47','415','375','375');
    INSERT INTO playercreateinfo_skills VALUES ('47','673','375','375');
    INSERT INTO playercreateinfo_skills VALUES ('47','95','375','375');
    INSERT INTO playercreateinfo_skills VALUES ('47','54','375','375');
    INSERT INTO playercreateinfo_skills VALUES ('47','162','375','375');
    INSERT INTO playercreateinfo_skills VALUES ('47','762','300','300');
    INSERT INTO playercreateinfo_skills VALUES ('47','173','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('47','136','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('47','78','1','1');
    INSERT INTO playercreateinfo_skills VALUES ('47','613','1','1');
    INSERT INTO playercreateinfo_skills VALUES ('47','56','1','1');
    
    /*Bloodelf Priest*/
    
    DELETE FROM playercreateinfo_skills where indexid = 53;
    
    INSERT INTO playercreateinfo_skills VALUES ('53','183','375','375');
    INSERT INTO playercreateinfo_skills VALUES ('53','220','375','375');
    INSERT INTO playercreateinfo_skills VALUES ('53','228','375','375');
    INSERT INTO playercreateinfo_skills VALUES ('53','109','300','300');
    INSERT INTO playercreateinfo_skills VALUES ('53','415','375','375');
    INSERT INTO playercreateinfo_skills VALUES ('53','673','375','375');
    INSERT INTO playercreateinfo_skills VALUES ('53','95','375','375');
    INSERT INTO playercreateinfo_skills VALUES ('53','54','375','375');
    INSERT INTO playercreateinfo_skills VALUES ('53','162','375','375');
    INSERT INTO playercreateinfo_skills VALUES ('53','762','300','300');
    INSERT INTO playercreateinfo_skills VALUES ('53','173','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('53','136','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('53','78','1','1');
    INSERT INTO playercreateinfo_skills VALUES ('53','613','1','1');
    INSERT INTO playercreateinfo_skills VALUES ('53','56','1','1');
    1.6 - Rogue
    Code:
    /*Human Rogue*/
    
    DELETE FROM playercreateinfo_skills where indexid = 18;
    
    INSERT INTO playercreateinfo_skills VALUES ('18','253','1','1');
    INSERT INTO playercreateinfo_skills VALUES ('18','38','1','1');
    INSERT INTO playercreateinfo_skills VALUES ('18','39','1','1');
    INSERT INTO playercreateinfo_skills VALUES ('18','762','300','300');
    INSERT INTO playercreateinfo_skills VALUES ('18','45','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('18','226','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('18','173','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('18','95','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('18','46','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('18','54','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('18','43','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('18','176','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('18','162','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('18','415','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('18','414','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('18','2842','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('18','1804','350','350');
    
    /*Orc Rogue*/
    
    DELETE FROM playercreateinfo_skills where indexid = 19;
    
    INSERT INTO playercreateinfo_skills VALUES ('19','253','1','1');
    INSERT INTO playercreateinfo_skills VALUES ('19','38','1','1');
    INSERT INTO playercreateinfo_skills VALUES ('19','39','1','1');
    INSERT INTO playercreateinfo_skills VALUES ('19','762','300','300');
    INSERT INTO playercreateinfo_skills VALUES ('19','45','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('19','226','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('19','173','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('19','95','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('19','46','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('19','54','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('19','43','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('19','176','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('19','162','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('19','415','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('19','414','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('19','2842','350','350');	
    INSERT INTO playercreateinfo_skills VALUES ('19','1804','350','350');
    
    /*Dwarf Rogue*/
    
    DELETE FROM playercreateinfo_skills where indexid = 20;
    
    INSERT INTO playercreateinfo_skills VALUES ('20','253','1','1');
    INSERT INTO playercreateinfo_skills VALUES ('20','38','1','1');
    INSERT INTO playercreateinfo_skills VALUES ('20','39','1','1');
    INSERT INTO playercreateinfo_skills VALUES ('20','762','300','300');
    INSERT INTO playercreateinfo_skills VALUES ('20','45','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('20','226','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('20','173','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('20','95','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('20','46','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('20','54','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('20','43','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('20','176','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('20','162','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('20','415','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('20','414','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('20','2842','350','350');	
    INSERT INTO playercreateinfo_skills VALUES ('20','1804','350','350');	
    
    /*Nightelf Rogue*/
    
    DELETE FROM playercreateinfo_skills where indexid = 21;
    
    INSERT INTO playercreateinfo_skills VALUES ('21','253','1','1');
    INSERT INTO playercreateinfo_skills VALUES ('21','38','1','1');
    INSERT INTO playercreateinfo_skills VALUES ('21','39','1','1');
    INSERT INTO playercreateinfo_skills VALUES ('21','762','300','300');
    INSERT INTO playercreateinfo_skills VALUES ('21','45','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('21','226','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('21','173','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('21','95','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('21','46','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('21','54','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('21','43','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('21','176','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('21','162','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('21','415','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('21','414','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('21','2842','350','350');	
    INSERT INTO playercreateinfo_skills VALUES ('21','1804','350','350');	
    
    /*Undead Rogue*/
    
    DELETE FROM playercreateinfo_skills where indexid = 22;
    
    INSERT INTO playercreateinfo_skills VALUES ('22','253','1','1');
    INSERT INTO playercreateinfo_skills VALUES ('22','38','1','1');
    INSERT INTO playercreateinfo_skills VALUES ('22','39','1','1');
    INSERT INTO playercreateinfo_skills VALUES ('22','762','300','300');
    INSERT INTO playercreateinfo_skills VALUES ('22','45','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('22','226','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('22','173','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('22','95','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('22','46','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('22','54','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('22','43','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('22','176','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('22','162','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('22','415','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('22','414','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('22','2842','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('22','1804','350','350');	
    
    /*Gnome Rogue*/
    
    DELETE FROM playercreateinfo_skills where indexid = 23;
    
    INSERT INTO playercreateinfo_skills VALUES ('23','253','1','1');
    INSERT INTO playercreateinfo_skills VALUES ('23','38','1','1');
    INSERT INTO playercreateinfo_skills VALUES ('23','39','1','1');
    INSERT INTO playercreateinfo_skills VALUES ('23','762','300','300');
    INSERT INTO playercreateinfo_skills VALUES ('23','45','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('23','226','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('23','173','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('23','95','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('23','46','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('23','54','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('23','43','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('23','176','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('23','162','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('23','415','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('23','414','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('23','2842','350','350');	
    INSERT INTO playercreateinfo_skills VALUES ('23','1804','350','350');	
    
    /*Troll Rogue*/
    
    DELETE FROM playercreateinfo_skills where indexid = 24;
    
    INSERT INTO playercreateinfo_skills VALUES ('24','253','1','1');
    INSERT INTO playercreateinfo_skills VALUES ('24','38','1','1');
    INSERT INTO playercreateinfo_skills VALUES ('24','39','1','1');
    INSERT INTO playercreateinfo_skills VALUES ('24','762','300','300');
    INSERT INTO playercreateinfo_skills VALUES ('24','45','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('24','226','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('24','173','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('24','95','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('24','46','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('24','54','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('24','43','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('24','176','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('24','162','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('24','415','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('24','414','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('24','2842','350','350');	
    INSERT INTO playercreateinfo_skills VALUES ('24','1804','350','350');	
    
    /*Bloodelf Rogue*/
    
    DELETE FROM playercreateinfo_skills where indexid = 52;
    
    INSERT INTO playercreateinfo_skills VALUES ('52','253','1','1');
    INSERT INTO playercreateinfo_skills VALUES ('52','38','1','1');
    INSERT INTO playercreateinfo_skills VALUES ('52','39','1','1');
    INSERT INTO playercreateinfo_skills VALUES ('55','762','300','300');
    INSERT INTO playercreateinfo_skills VALUES ('52','45','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('52','226','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('52','173','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('52','95','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('52','46','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('52','54','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('52','43','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('52','176','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('52','162','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('52','415','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('52','414','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('52','2842','350','350');	
    INSERT INTO playercreateinfo_skills VALUES ('52','1804','350','350');
    1.7 - Shaman
    Code:
    /*Orc Shaman*/
    
    DELETE FROM playercreateinfo_skills where indexid = 30;
    
    INSERT INTO playercreateinfo_skills VALUES ('30','375','1','1');
    INSERT INTO playercreateinfo_skills VALUES ('30','373','1','1');
    INSERT INTO playercreateinfo_skills VALUES ('30','374','1','1');
    INSERT INTO playercreateinfo_skills VALUES ('30','762','300','300');
    INSERT INTO playercreateinfo_skills VALUES ('30','44','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('30','172','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('30','173','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('30','95','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('30','160','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('30','54','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('30','136','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('30','162','350','350');
    
    /*Tauren Shaman*/
    
    DELETE FROM playercreateinfo_skills where indexid = 31;
    
    INSERT INTO playercreateinfo_skills VALUES ('31','375','1','1');
    INSERT INTO playercreateinfo_skills VALUES ('31','373','1','1');
    INSERT INTO playercreateinfo_skills VALUES ('31','374','1','1');
    INSERT INTO playercreateinfo_skills VALUES ('31','762','300','300');
    INSERT INTO playercreateinfo_skills VALUES ('31','44','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('31','172','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('31','173','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('31','95','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('31','160','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('31','54','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('31','136','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('31','162','350','350');
    
    /*Troll Shaman*/
    
    DELETE FROM playercreateinfo_skills where indexid = 32;
    
    INSERT INTO playercreateinfo_skills VALUES ('32','375','1','1');
    INSERT INTO playercreateinfo_skills VALUES ('32','373','1','1');
    INSERT INTO playercreateinfo_skills VALUES ('32','374','1','1');
    INSERT INTO playercreateinfo_skills VALUES ('32','762','300','300');
    INSERT INTO playercreateinfo_skills VALUES ('32','44','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('32','172','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('32','173','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('32','95','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('32','160','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('32','54','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('32','136','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('32','162','350','350');
    
    /*Draenie Shaman*/
    
    DELETE FROM playercreateinfo_skills where indexid = 48;
    
    INSERT INTO playercreateinfo_skills VALUES ('48','375','1','1');
    INSERT INTO playercreateinfo_skills VALUES ('48','373','1','1');
    INSERT INTO playercreateinfo_skills VALUES ('48','374','1','1');
    INSERT INTO playercreateinfo_skills VALUES ('48','762','300','300');
    INSERT INTO playercreateinfo_skills VALUES ('48','44','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('48','172','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('48','173','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('48','95','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('48','160','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('48','54','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('48','136','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('48','162','350','350');
    1.8 - Warlock
    Code:
    /*Human Warlock*/
    
    DELETE FROM playercreateinfo_skills where indexid = 38;
    
    INSERT INTO playercreateinfo_skills VALUES ('38','354','1','1');
    INSERT INTO playercreateinfo_skills VALUES ('38','593','1','1');
    INSERT INTO playercreateinfo_skills VALUES ('38','355','1','1');
    INSERT INTO playercreateinfo_skills VALUES ('38','415','1','1');
    INSERT INTO playercreateinfo_skills VALUES ('38','762','300','300');
    INSERT INTO playercreateinfo_skills VALUES ('38','173','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('38','95','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('38','136','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('38','43','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('38','162','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('38','228','350','350');
    
    /*Orc Warlock*/
    
    DELETE FROM playercreateinfo_skills where indexid = 39;
    
    INSERT INTO playercreateinfo_skills VALUES ('39','354','1','1');
    INSERT INTO playercreateinfo_skills VALUES ('39','593','1','1');
    INSERT INTO playercreateinfo_skills VALUES ('39','355','1','1');
    INSERT INTO playercreateinfo_skills VALUES ('39','415','1','1');
    INSERT INTO playercreateinfo_skills VALUES ('39','762','300','300');
    INSERT INTO playercreateinfo_skills VALUES ('39','173','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('39','95','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('39','136','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('39','43','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('39','162','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('39','228','350','350');
    
    
    /*Undead Warlock*/
    
    DELETE FROM playercreateinfo_skills where indexid = 40;
    
    INSERT INTO playercreateinfo_skills VALUES ('40','354','1','1');
    INSERT INTO playercreateinfo_skills VALUES ('40','593','1','1');
    INSERT INTO playercreateinfo_skills VALUES ('40','355','1','1');
    INSERT INTO playercreateinfo_skills VALUES ('40','415','1','1');
    INSERT INTO playercreateinfo_skills VALUES ('40','762','300','300');
    INSERT INTO playercreateinfo_skills VALUES ('40','173','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('40','95','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('40','136','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('40','43','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('40','162','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('40','228','350','350');
    
    /*Gnome Warlock*/
    
    DELETE FROM playercreateinfo_skills where indexid = 41;
    
    INSERT INTO playercreateinfo_skills VALUES ('41','354','1','1');
    INSERT INTO playercreateinfo_skills VALUES ('41','593','1','1');
    INSERT INTO playercreateinfo_skills VALUES ('41','355','1','1');
    INSERT INTO playercreateinfo_skills VALUES ('41','415','1','1');
    INSERT INTO playercreateinfo_skills VALUES ('41','762','300','300');
    INSERT INTO playercreateinfo_skills VALUES ('41','173','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('41','95','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('41','136','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('41','43','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('41','162','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('41','228','350','350');
    
    /*Bloodelf Warlock*/
    
    DELETE FROM playercreateinfo_skills where indexid = 55;
    
    INSERT INTO playercreateinfo_skills VALUES ('55','354','1','1');
    INSERT INTO playercreateinfo_skills VALUES ('55','593','1','1');
    INSERT INTO playercreateinfo_skills VALUES ('55','355','1','1');
    INSERT INTO playercreateinfo_skills VALUES ('55','415','1','1');
    INSERT INTO playercreateinfo_skills VALUES ('55','762','300','300');
    INSERT INTO playercreateinfo_skills VALUES ('55','173','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('55','95','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('55','136','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('55','43','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('55','162','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('55','228','350','350');

    [release] start with all skills (not spells)
  2. #2
    Nesox's Avatar ★ Elder ★
    Reputation
    1280
    Join Date
    Mar 2007
    Posts
    1,238
    Thanks G/R
    0/3
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    1.9 - Warrior
    Code:
    /*Human Warrior*/
    
    DELETE FROM playercreateinfo_skills where indexid = 1;
    
    INSERT INTO playercreateinfo_skills VALUES ('1','45','350','350'); 	
    INSERT INTO playercreateinfo_skills VALUES ('1','226','350','350'); 	
    INSERT INTO playercreateinfo_skills VALUES ('1','173','350','350');	
    INSERT INTO playercreateinfo_skills VALUES ('1','229','350','350');	
    INSERT INTO playercreateinfo_skills VALUES ('1','176','350','350');	
    INSERT INTO playercreateinfo_skills VALUES ('1','136','350','350');	
    INSERT INTO playercreateinfo_skills VALUES ('1','46','350','350');	
    INSERT INTO playercreateinfo_skills VALUES ('1','55','350','350');	
    INSERT INTO playercreateinfo_skills VALUES ('1','43','350','350');	
    INSERT INTO playercreateinfo_skills VALUES ('1','172','350','350');	
    INSERT INTO playercreateinfo_skills VALUES ('1','44','375','375');	
    INSERT INTO playercreateinfo_skills VALUES ('1','162','375','375');	
    INSERT INTO playercreateinfo_skills VALUES ('1','54','375','375');		
    INSERT INTO playercreateinfo_skills VALUES ('1','414','375','375');	
    INSERT INTO playercreateinfo_skills VALUES ('1','413','375','375');	
    INSERT INTO playercreateinfo_skills VALUES ('1','160','375','375');	
    INSERT INTO playercreateinfo_skills VALUES ('1','95','375','375');	
    INSERT INTO playercreateinfo_skills VALUES ('1','415','375','375');	
    INSERT INTO playercreateinfo_skills VALUES ('1','98','300','300');	
    INSERT INTO playercreateinfo_skills VALUES ('1','433','375','375');	
    INSERT INTO playercreateinfo_skills VALUES ('1','754','375','375');	
    INSERT INTO playercreateinfo_skills VALUES ('1','183','375','375');	
    INSERT INTO playercreateinfo_skills VALUES ('1','762','300','300');	
    INSERT INTO playercreateinfo_skills VALUES ('1','594','1','1');		 	
    INSERT INTO playercreateinfo_skills VALUES ('1','184','1','1');		
    INSERT INTO playercreateinfo_skills VALUES ('1','26','1','1');		
    INSERT INTO playercreateinfo_skills VALUES ('1','256','1','1');		
    INSERT INTO playercreateinfo_skills VALUES ('1','257','1','1');		
    
    /*Orc Warrior*/
    
    DELETE FROM playercreateinfo_skills where indexid = 2;
    
    INSERT INTO playercreateinfo_skills VALUES ('2','45','350','350');	
    INSERT INTO playercreateinfo_skills VALUES ('2','226','350','350');	
    INSERT INTO playercreateinfo_skills VALUES ('2','173','350','350');	
    INSERT INTO playercreateinfo_skills VALUES ('2','229','350','350');	
    INSERT INTO playercreateinfo_skills VALUES ('2','176','350','350');	
    INSERT INTO playercreateinfo_skills VALUES ('2','136','350','350');	
    INSERT INTO playercreateinfo_skills VALUES ('2','46','350','350');	
    INSERT INTO playercreateinfo_skills VALUES ('2','55','350','350');	
    INSERT INTO playercreateinfo_skills VALUES ('2','43','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('2','172','350','350');	
    INSERT INTO playercreateinfo_skills VALUES ('2','44','375','375');	
    INSERT INTO playercreateinfo_skills VALUES ('2','162','375','375');	
    INSERT INTO playercreateinfo_skills VALUES ('2','54','375','375');	
    INSERT INTO playercreateinfo_skills VALUES ('2','414','375','375');	
    INSERT INTO playercreateinfo_skills VALUES ('2','413','375','375');	
    INSERT INTO playercreateinfo_skills VALUES ('2','160','375','375');	
    INSERT INTO playercreateinfo_skills VALUES ('2','95','375','375');	
    INSERT INTO playercreateinfo_skills VALUES ('2','415','375','375');	
    INSERT INTO playercreateinfo_skills VALUES ('2','98','300','300');	
    INSERT INTO playercreateinfo_skills VALUES ('2','433','375','375');	
    INSERT INTO playercreateinfo_skills VALUES ('2','754','375','375');	
    INSERT INTO playercreateinfo_skills VALUES ('2','183','375','375');	
    INSERT INTO playercreateinfo_skills VALUES ('2','762','300','300');	
    INSERT INTO playercreateinfo_skills VALUES ('2','594','1','1');		
    INSERT INTO playercreateinfo_skills VALUES ('2','257','1','1');		
    INSERT INTO playercreateinfo_skills VALUES ('2','184','1','1');		
    INSERT INTO playercreateinfo_skills VALUES ('2','26','1','1');		
    INSERT INTO playercreateinfo_skills VALUES ('2','256','1','1');		
    INSERT INTO playercreateinfo_skills VALUES ('2','257','1','1');	 	
    
    /*Dwarf Warrior*/
    
    DELETE FROM playercreateinfo_skills where indexid = 3;
    
    INSERT INTO playercreateinfo_skills VALUES ('3','45','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('3','226','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('3','173','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('3','229','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('3','176','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('3','136','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('3','46','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('3','55','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('3','43','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('3','172','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('3','44','375','375');
    INSERT INTO playercreateinfo_skills VALUES ('3','162','375','375');
    INSERT INTO playercreateinfo_skills VALUES ('3','54','375','375');
    INSERT INTO playercreateinfo_skills VALUES ('3','414','375','375');
    INSERT INTO playercreateinfo_skills VALUES ('3','413','375','375');
    INSERT INTO playercreateinfo_skills VALUES ('3','160','375','375');
    INSERT INTO playercreateinfo_skills VALUES ('3','95','375','375');
    INSERT INTO playercreateinfo_skills VALUES ('3','415','375','375');
    INSERT INTO playercreateinfo_skills VALUES ('3','98','300','300');
    INSERT INTO playercreateinfo_skills VALUES ('3','433','375','375');
    INSERT INTO playercreateinfo_skills VALUES ('3','754','375','375');
    INSERT INTO playercreateinfo_skills VALUES ('3','183','375','375');
    INSERT INTO playercreateinfo_skills VALUES ('3','762','300','300');
    INSERT INTO playercreateinfo_skills VALUES ('3','594','1','1');
    INSERT INTO playercreateinfo_skills VALUES ('3','257','1','1');
    INSERT INTO playercreateinfo_skills VALUES ('3','184','1','1');
    INSERT INTO playercreateinfo_skills VALUES ('3','26','1','1');
    INSERT INTO playercreateinfo_skills VALUES ('3','256','1','1');
    INSERT INTO playercreateinfo_skills VALUES ('3','257','1','1');
    
    /*Nightelf Warrior*/
    
    DELETE FROM playercreateinfo_skills where indexid = 4;
    
    INSERT INTO playercreateinfo_skills VALUES ('4','45','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('4','226','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('4','173','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('4','229','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('4','176','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('4','136','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('4','46','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('4','55','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('4','43','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('4','172','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('4','44','375','375');
    INSERT INTO playercreateinfo_skills VALUES ('4','162','375','375');
    INSERT INTO playercreateinfo_skills VALUES ('4','54','375','375');
    INSERT INTO playercreateinfo_skills VALUES ('4','414','375','375');
    INSERT INTO playercreateinfo_skills VALUES ('4','413','375','375');
    INSERT INTO playercreateinfo_skills VALUES ('4','160','375','375');
    INSERT INTO playercreateinfo_skills VALUES ('4','95','375','375');
    INSERT INTO playercreateinfo_skills VALUES ('4','415','375','375');
    INSERT INTO playercreateinfo_skills VALUES ('4','98','300','300');
    INSERT INTO playercreateinfo_skills VALUES ('4','433','375','375');
    INSERT INTO playercreateinfo_skills VALUES ('4','754','375','375');
    INSERT INTO playercreateinfo_skills VALUES ('4','183','375','375');
    INSERT INTO playercreateinfo_skills VALUES ('4','762','300','300');
    INSERT INTO playercreateinfo_skills VALUES ('4','594','1','1');
    INSERT INTO playercreateinfo_skills VALUES ('4','257','1','1');
    INSERT INTO playercreateinfo_skills VALUES ('4','184','1','1');
    INSERT INTO playercreateinfo_skills VALUES ('4','26','1','1');
    INSERT INTO playercreateinfo_skills VALUES ('4','256','1','1');
    INSERT INTO playercreateinfo_skills VALUES ('4','257','1','1');
    
    /*Undead Warrior*/
    
    DELETE FROM playercreateinfo_skills where indexid = 5;
    
    INSERT INTO playercreateinfo_skills VALUES ('5','45','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('5','226','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('5','173','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('5','229','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('5','176','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('5','136','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('5','46','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('5','55','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('5','43','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('5','172','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('5','44','375','375');
    INSERT INTO playercreateinfo_skills VALUES ('5','162','375','375');
    INSERT INTO playercreateinfo_skills VALUES ('5','54','375','375');
    INSERT INTO playercreateinfo_skills VALUES ('5','414','375','375');
    INSERT INTO playercreateinfo_skills VALUES ('5','413','375','375');
    INSERT INTO playercreateinfo_skills VALUES ('5','160','375','375');
    INSERT INTO playercreateinfo_skills VALUES ('5','95','375','375');
    INSERT INTO playercreateinfo_skills VALUES ('5','415','375','375');
    INSERT INTO playercreateinfo_skills VALUES ('5','98','300','300');
    INSERT INTO playercreateinfo_skills VALUES ('5','433','375','375');
    INSERT INTO playercreateinfo_skills VALUES ('5','754','375','375');
    INSERT INTO playercreateinfo_skills VALUES ('5','183','375','375');
    INSERT INTO playercreateinfo_skills VALUES ('5','762','300','300');
    INSERT INTO playercreateinfo_skills VALUES ('5','594','1','1');
    INSERT INTO playercreateinfo_skills VALUES ('5','257','1','1');
    INSERT INTO playercreateinfo_skills VALUES ('5','184','1','1');
    INSERT INTO playercreateinfo_skills VALUES ('5','26','1','1');
    INSERT INTO playercreateinfo_skills VALUES ('5','256','1','1');
    INSERT INTO playercreateinfo_skills VALUES ('5','257','1','1');
    
    /*Tauren Warrior*/
    
    DELETE FROM playercreateinfo_skills where indexid = 6;
    
    INSERT INTO playercreateinfo_skills VALUES ('6','45','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('6','226','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('6','173','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('6','229','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('6','176','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('6','136','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('6','46','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('6','55','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('6','43','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('6','172','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('6','44','375','375');
    INSERT INTO playercreateinfo_skills VALUES ('6','162','375','375');
    INSERT INTO playercreateinfo_skills VALUES ('6','54','375','375');
    INSERT INTO playercreateinfo_skills VALUES ('6','414','375','375');
    INSERT INTO playercreateinfo_skills VALUES ('6','413','375','375');
    INSERT INTO playercreateinfo_skills VALUES ('6','160','375','375');
    INSERT INTO playercreateinfo_skills VALUES ('6','95','375','375');
    INSERT INTO playercreateinfo_skills VALUES ('6','415','375','375');
    INSERT INTO playercreateinfo_skills VALUES ('6','98','300','300');
    INSERT INTO playercreateinfo_skills VALUES ('6','433','375','375');
    INSERT INTO playercreateinfo_skills VALUES ('6','754','375','375');
    INSERT INTO playercreateinfo_skills VALUES ('6','183','375','375');
    INSERT INTO playercreateinfo_skills VALUES ('6','762','300','300');
    INSERT INTO playercreateinfo_skills VALUES ('6','594','1','1');
    INSERT INTO playercreateinfo_skills VALUES ('6','257','1','1');
    INSERT INTO playercreateinfo_skills VALUES ('6','184','1','1');
    INSERT INTO playercreateinfo_skills VALUES ('6','26','1','1');
    INSERT INTO playercreateinfo_skills VALUES ('6','256','1','1');
    INSERT INTO playercreateinfo_skills VALUES ('6','257','1','1');
    
    /*Gnome Warrior*/
    
    DELETE FROM playercreateinfo_skills where indexid = 7;
    
    INSERT INTO playercreateinfo_skills VALUES ('7','45','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('7','226','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('7','173','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('7','229','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('7','176','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('7','136','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('7','46','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('7','55','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('7','43','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('7','172','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('7','44','375','375');
    INSERT INTO playercreateinfo_skills VALUES ('7','162','375','375');
    INSERT INTO playercreateinfo_skills VALUES ('7','54','375','375');
    INSERT INTO playercreateinfo_skills VALUES ('7','414','375','375');
    INSERT INTO playercreateinfo_skills VALUES ('7','413','375','375');
    INSERT INTO playercreateinfo_skills VALUES ('7','160','375','375');
    INSERT INTO playercreateinfo_skills VALUES ('7','95','375','375');
    INSERT INTO playercreateinfo_skills VALUES ('7','415','375','375');
    INSERT INTO playercreateinfo_skills VALUES ('7','98','300','300');
    INSERT INTO playercreateinfo_skills VALUES ('7','433','375','375');
    INSERT INTO playercreateinfo_skills VALUES ('7','754','375','375');
    INSERT INTO playercreateinfo_skills VALUES ('7','183','375','375');
    INSERT INTO playercreateinfo_skills VALUES ('7','762','300','300');
    INSERT INTO playercreateinfo_skills VALUES ('7','594','1','1');
    INSERT INTO playercreateinfo_skills VALUES ('7','257','1','1');
    INSERT INTO playercreateinfo_skills VALUES ('7','184','1','1');
    INSERT INTO playercreateinfo_skills VALUES ('7','26','1','1');
    INSERT INTO playercreateinfo_skills VALUES ('7','256','1','1');
    INSERT INTO playercreateinfo_skills VALUES ('7','257','1','1');
    
    /*Troll Warrior*/
    
    DELETE FROM playercreateinfo_skills where indexid = 8;
    
    INSERT INTO playercreateinfo_skills VALUES ('8','45','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('8','226','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('8','173','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('8','229','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('8','176','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('8','136','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('8','46','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('8','55','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('8','43','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('8','172','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('8','44','375','375');
    INSERT INTO playercreateinfo_skills VALUES ('8','162','375','375');
    INSERT INTO playercreateinfo_skills VALUES ('8','54','375','375');
    INSERT INTO playercreateinfo_skills VALUES ('8','414','375','375');
    INSERT INTO playercreateinfo_skills VALUES ('8','413','375','375');
    INSERT INTO playercreateinfo_skills VALUES ('8','160','375','375');
    INSERT INTO playercreateinfo_skills VALUES ('8','95','375','375');
    INSERT INTO playercreateinfo_skills VALUES ('8','415','375','375');
    INSERT INTO playercreateinfo_skills VALUES ('8','98','300','300');
    INSERT INTO playercreateinfo_skills VALUES ('8','433','375','375');
    INSERT INTO playercreateinfo_skills VALUES ('8','754','375','375');
    INSERT INTO playercreateinfo_skills VALUES ('8','183','375','375');
    INSERT INTO playercreateinfo_skills VALUES ('8','762','300','300');
    INSERT INTO playercreateinfo_skills VALUES ('8','594','1','1');
    INSERT INTO playercreateinfo_skills VALUES ('8','257','1','1');
    INSERT INTO playercreateinfo_skills VALUES ('8','184','1','1');
    INSERT INTO playercreateinfo_skills VALUES ('8','26','1','1');
    INSERT INTO playercreateinfo_skills VALUES ('8','256','1','1');
    INSERT INTO playercreateinfo_skills VALUES ('8','257','1','1');
    
    /*Draenie Warrior*/
    
    DELETE FROM playercreateinfo_skills where indexid = 44;
    
    INSERT INTO playercreateinfo_skills VALUES ('44','45','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('44','226','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('44','173','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('44','229','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('44','176','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('44','136','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('44','46','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('44','55','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('44','43','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('44','172','350','350');
    INSERT INTO playercreateinfo_skills VALUES ('44','44','375','375');
    INSERT INTO playercreateinfo_skills VALUES ('44','162','375','375');
    INSERT INTO playercreateinfo_skills VALUES ('44','54','375','375');
    INSERT INTO playercreateinfo_skills VALUES ('44','414','375','375');
    INSERT INTO playercreateinfo_skills VALUES ('44','413','375','375');
    INSERT INTO playercreateinfo_skills VALUES ('44','160','375','375');
    INSERT INTO playercreateinfo_skills VALUES ('44','95','375','375');
    INSERT INTO playercreateinfo_skills VALUES ('44','415','375','375');
    INSERT INTO playercreateinfo_skills VALUES ('44','98','300','300');
    INSERT INTO playercreateinfo_skills VALUES ('44','433','375','375');
    INSERT INTO playercreateinfo_skills VALUES ('44','754','375','375');
    INSERT INTO playercreateinfo_skills VALUES ('44','183','375','375');
    INSERT INTO playercreateinfo_skills VALUES ('44','762','300','300');
    INSERT INTO playercreateinfo_skills VALUES ('44','594','1','1');
    INSERT INTO playercreateinfo_skills VALUES ('44','257','1','1');
    INSERT INTO playercreateinfo_skills VALUES ('44','184','1','1');
    INSERT INTO playercreateinfo_skills VALUES ('44','26','1','1');
    INSERT INTO playercreateinfo_skills VALUES ('44','256','1','1');
    INSERT INTO playercreateinfo_skills VALUES ('44','257','1','1');
    So that's it! heres a link to a rar with all the batch files
    Filebeam - Free Fast File Hosting

  3. #3
    Herleybob's Avatar Contributor
    Reputation
    178
    Join Date
    Jul 2007
    Posts
    663
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Very nice. I am going to use this. +Rep

    Nom Nom Nom :P

  4. #4
    Nesox's Avatar ★ Elder ★
    Reputation
    1280
    Join Date
    Mar 2007
    Posts
    1,238
    Thanks G/R
    0/3
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Originally Posted by herleybob View Post
    Very nice. I am going to use this. +Rep
    thank you

  5. #5
    2dgreengiant's Avatar ★ Elder ★


    Reputation
    1190
    Join Date
    Feb 2007
    Posts
    7,129
    Thanks G/R
    1/1
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Indeed this is very good + rep also
    If you need me you have my skype, if you don't have my skype then you don't need me.

  6. #6
    Nesox's Avatar ★ Elder ★
    Reputation
    1280
    Join Date
    Mar 2007
    Posts
    1,238
    Thanks G/R
    0/3
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Originally Posted by 2dgreengiant View Post
    Indeed this is very good + rep also
    ty, ill be doing spells soon but its gonna take several days more before they are done

  7. #7
    kdulep's Avatar Member
    Reputation
    1
    Join Date
    Jun 2008
    Posts
    1
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    You are about to delete languages skills. And seems that your IDs is not compatible with Ascent.

    BTW it is not easier to (Ascent), change if you have anything else

    Code:
    update playercreateinfo_skills set level=400, maxlevel=400 where skillid in (39,43,44,45,46,50,54,55,78,136,142,160,172,173,176,184,226,237,256,257,261,267,355,473,613)
    and add only missing by default skills ;P

  8. #8
    AzolexX's Avatar Contributor
    Reputation
    179
    Join Date
    May 2007
    Posts
    587
    Thanks G/R
    0/1
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Man 2x+Rep
    This is going to be used in Battleground Database,ty.

    Great job/work.

    Find about scripting, programming and music! My blog: https://worldofsmth.wordpress.com!

  9. #9
    forces's Avatar Member
    Reputation
    16
    Join Date
    Jan 2008
    Posts
    47
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Epic to the max. +Rep
    C++ SKILL[||||||||||||]

Similar Threads

  1. [Release] Start with all items in slot id's (Tier 7 and more)
    By cosminelu16 in forum WoW EMU General Releases
    Replies: 17
    Last Post: 07-31-2009, 10:27 PM
  2. Start with all skills
    By Supah in forum World of Warcraft Emulator Servers
    Replies: 4
    Last Post: 07-29-2008, 11:22 AM
  3. [Release] Start with all class spells, talent spells not included
    By Power of Illuminati in forum World of Warcraft Emulator Servers
    Replies: 16
    Last Post: 07-17-2008, 04:39 AM
  4. Start with all your class spells ??
    By Galadios in forum World of Warcraft Emulator Servers
    Replies: 3
    Last Post: 07-02-2008, 01:48 PM
  5. [Release] Start with all Class spells!
    By latruwski in forum World of Warcraft Emulator Servers
    Replies: 21
    Last Post: 12-19-2007, 08:53 AM
All times are GMT -5. The time now is 01:09 AM. Powered by vBulletin® Version 4.2.3
Copyright © 2024 vBulletin Solutions, Inc. All rights reserved. User Alert System provided by Advanced User Tagging (Pro) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
Digital Point modules: Sphinx-based search