Bonjour !
Aujourd'hui j'ai modifié mon dernier patch Ajout des pouvoirs manquants aux maîtres.
Pour ne plus devoir passer par les maîtres mais avoir les pouvoirs Dès la création du personnage !
Donc lorsque vous créer votre perso , pouf .. Vous avez les pouvoirs qui manquaient
Cordialement ,
[code=sql]
-- --------------------------------------------------------------- Humain ---------------------------------------------------------------
-- ....... Guerrier
INSERT INTO `playercreateinfo_spell` VALUES ('1', '1', '71', 'Humain guerrier');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '1', '2458', 'Humain guerrier');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '1', '25275', 'Humain guerrier');
-- ....... Paladin
INSERT INTO `playercreateinfo_spell` VALUES ('1', '2', '7328', 'Humain paladin');
-- ....... Démoniste
INSERT INTO `playercreateinfo_spell` VALUES ('1', '9', '688', 'Humain Demoniste');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '9', '691', 'Humain Demoniste');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '9', '712', 'Humain Demoniste');
INSERT INTO `playercreateinfo_spell` VALUES ('1', '9', '697', 'Humain Demoniste');
-- --------------------------------------------------------------- Nain ---------------------------------------------------------------
-- ....... Guerrier
INSERT INTO `playercreateinfo_spell` VALUES ('3', '1', '71', 'Nain guerrier');
INSERT INTO `playercreateinfo_spell` VALUES ('3', '1', '2458', 'Nain guerrier');
INSERT INTO `playercreateinfo_spell` VALUES ('3', '1', '25275', 'Nain guerrier');
-- ....... Paladin
INSERT INTO `playercreateinfo_spell` VALUES ('3', '2', '7328', 'Nain paladin');
-- ....... Chasseur
INSERT INTO `playercreateinfo_spell` VALUES ('3', '3', '883', 'Nain Chasseur');
INSERT INTO `playercreateinfo_spell` VALUES ('3', '3', '1515', 'Nain Chasseur');
INSERT INTO `playercreateinfo_spell` VALUES ('3', '3', '6991', 'Nain Chasseur');
INSERT INTO `playercreateinfo_spell` VALUES ('3', '3', '982', 'Nain Chasseur');
-- --------------------------------------------------------------- Elfe de la Nuit ---------------------------------------------------------------
-- ....... Guerrier
INSERT INTO `playercreateinfo_spell` VALUES ('4', '1', '71', 'Elfe guerrier');
INSERT INTO `playercreateinfo_spell` VALUES ('4', '1', '2458', 'Elfe guerrier');
INSERT INTO `playercreateinfo_spell` VALUES ('4', '1', '25275', 'Elfe guerrier');
-- ....... Chasseur
INSERT INTO `playercreateinfo_spell` VALUES ('4', '3', '883', 'Elfe Chasseur');
INSERT INTO `playercreateinfo_spell` VALUES ('4', '3', '1515', 'Elfe Chasseur');
INSERT INTO `playercreateinfo_spell` VALUES ('4', '3', '6991', 'Elfe Chasseur');
INSERT INTO `playercreateinfo_spell` VALUES ('4', '3', '982', 'Elfe Chasseur');
-- ....... Druide
INSERT INTO `playercreateinfo_spell` VALUES ('4', '11', '768', 'Elfe Druide');
INSERT INTO `playercreateinfo_spell` VALUES ('4', '11', '783', 'Elfe Druide');
INSERT INTO `playercreateinfo_spell` VALUES ('4', '11', '1066', 'Elfe Druide');
INSERT INTO `playercreateinfo_spell` VALUES ('4', '11', '9634', 'Elfe Druide');
INSERT INTO `playercreateinfo_spell` VALUES ('4', '11', '5487', 'Elfe Druide');
-- --------------------------------------------------------------- Gnome ---------------------------------------------------------------
-- ....... Guerrier
INSERT INTO `playercreateinfo_spell` VALUES ('7', '1', '71', 'Gnome guerrier');
INSERT INTO `playercreateinfo_spell` VALUES ('7', '1', '2458', 'Gnome guerrier');
INSERT INTO `playercreateinfo_spell` VALUES ('7', '1', '25275', 'Gnome guerrier');
-- ....... Démoniste
INSERT INTO `playercreateinfo_spell` VALUES ('7', '9', '688', 'Gnome Demoniste');
INSERT INTO `playercreateinfo_spell` VALUES ('7', '9', '691', 'Gnome Demoniste');
INSERT INTO `playercreateinfo_spell` VALUES ('7', '9', '712', 'Gnome Demoniste');
INSERT INTO `playercreateinfo_spell` VALUES ('7', '9', '697', 'Gnome Demoniste');
-- --------------------------------------------------------------- Draenei ---------------------------------------------------------------
-- ....... Guerrier
INSERT INTO `playercreateinfo_spell` VALUES ('11', '1', '71', 'Draenei guerrier');
INSERT INTO `playercreateinfo_spell` VALUES ('11', '1', '2458', 'Draenei guerrier');
INSERT INTO `playercreateinfo_spell` VALUES ('11', '1', '25275', 'Draenei guerrier');
-- ....... Paladin
INSERT INTO `playercreateinfo_spell` VALUES ('11', '2', '7328', 'Draenei paladin');
-- ....... Chasseur
INSERT INTO `playercreateinfo_spell` VALUES ('11', '3', '883', 'Draenei Chasseur');
INSERT INTO `playercreateinfo_spell` VALUES ('11', '3', '1515', 'Draenei Chasseur');
INSERT INTO `playercreateinfo_spell` VALUES ('11', '3', '6991', 'Draenei Chasseur');
INSERT INTO `playercreateinfo_spell` VALUES ('11', '3', '982', 'Draenei Chasseur');
-- ....... Chaman
INSERT INTO `playercreateinfo_spell` VALUES ('11', '7', '8155', 'Draenei Chasseur');
INSERT INTO `playercreateinfo_spell` VALUES ('11', '7', '6365', 'Draenei Chasseur');
-- --------------------------------------------------------------- Orc ---------------------------------------------------------------
-- ....... Guerrier
INSERT INTO `playercreateinfo_spell` VALUES ('2', '1', '71', 'Orc guerrier');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '1', '2458', 'Orc guerrier');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '1', '25275', 'Orc guerrier');
-- ....... Chaman
INSERT INTO `playercreateinfo_spell` VALUES ('2', '7', '8155', 'Orc Chasseur');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '7', '6365', 'Orc Chasseur');
-- ....... Chasseur
INSERT INTO `playercreateinfo_spell` VALUES ('2', '3', '883', 'Orc Chasseur');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '3', '1515', 'Orc Chasseur');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '3', '6991', 'Orc Chasseur');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '3', '982', 'Orc Chasseur');
-- ....... Démoniste
INSERT INTO `playercreateinfo_spell` VALUES ('2', '9', '688', 'Orc Demoniste');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '9', '691', 'Orc Demoniste');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '9', '712', 'Orc Demoniste');
INSERT INTO `playercreateinfo_spell` VALUES ('2', '9', '697', 'Orc Demoniste');
-- --------------------------------------------------------------- Tauren ---------------------------------------------------------------
-- ....... Guerrier
INSERT INTO `playercreateinfo_spell` VALUES ('6', '1', '71', 'Tauren guerrier');
INSERT INTO `playercreateinfo_spell` VALUES ('6', '1', '2458', 'Tauren guerrier');
INSERT INTO `playercreateinfo_spell` VALUES ('6', '1', '25275', 'Tauren guerrier');
-- ....... Druide
INSERT INTO `playercreateinfo_spell` VALUES ('6', '11', '768', 'Tauren Druide');
INSERT INTO `playercreateinfo_spell` VALUES ('6', '11', '783', 'Tauren Druide');
INSERT INTO `playercreateinfo_spell` VALUES ('6', '11', '1066', 'Tauren Druide');
INSERT INTO `playercreateinfo_spell` VALUES ('6', '11', '9634', 'Tauren Druide');
INSERT INTO `playercreateinfo_spell` VALUES ('6', '11', '5487', 'Tauren Druide');
-- ....... Chaman
INSERT INTO `playercreateinfo_spell` VALUES ('6', '7', '8155', 'Tauren Chasseur');
INSERT INTO `playercreateinfo_spell` VALUES ('6', '7', '6365', 'Tauren Chasseur');
-- ....... Chasseur
INSERT INTO `playercreateinfo_spell` VALUES ('6', '3', '883', 'Tauren Chasseur');
INSERT INTO `playercreateinfo_spell` VALUES ('6', '3', '1515', 'Tauren Chasseur');
INSERT INTO `playercreateinfo_spell` VALUES ('6', '3', '6991', 'Tauren Chasseur');
INSERT INTO `playercreateinfo_spell` VALUES ('6', '3', '982', 'Tauren Chasseur');
-- --------------------------------------------------------------- Troll ---------------------------------------------------------------
-- ....... Guerrier
INSERT INTO `playercreateinfo_spell` VALUES ('8', '1', '71', 'Troll guerrier');
INSERT INTO `playercreateinfo_spell` VALUES ('8', '1', '2458', 'Troll guerrier');
INSERT INTO `playercreateinfo_spell` VALUES ('8', '1', '25275', 'Troll guerrier');
-- ....... Chasseur
INSERT INTO `playercreateinfo_spell` VALUES ('8', '3', '883', 'Troll Chasseur');
INSERT INTO `playercreateinfo_spell` VALUES ('8', '3', '1515', 'Troll Chasseur');
INSERT INTO `playercreateinfo_spell` VALUES ('8', '3', '6991', 'Troll Chasseur');
INSERT INTO `playercreateinfo_spell` VALUES ('8', '3', '982', 'Troll Chasseur');
-- ....... Chaman
INSERT INTO `playercreateinfo_spell` VALUES ('8', '7', '8155', 'Troll Chasseur');
INSERT INTO `playercreateinfo_spell` VALUES ('8', '7', '6365', 'Troll Chasseur');
-- --------------------------------------------------------------- Elfe de Sang ---------------------------------------------------------------
-- ....... Paladin
INSERT INTO `playercreateinfo_spell` VALUES ('10', '2', '7328', 'Blood paladin');
-- ....... Chasseur
INSERT INTO `playercreateinfo_spell` VALUES ('10', '3', '883', 'Blood Chasseur');
INSERT INTO `playercreateinfo_spell` VALUES ('10', '3', '1515', 'Blood Chasseur');
INSERT INTO `playercreateinfo_spell` VALUES ('10', '3', '6991', 'Blood Chasseur');
INSERT INTO `playercreateinfo_spell` VALUES ('10', '3', '982', 'Blood Chasseur');
-- ....... Démoniste
INSERT INTO `playercreateinfo_spell` VALUES ('10', '9', '688', 'Blood Demoniste');
INSERT INTO `playercreateinfo_spell` VALUES ('10', '9', '691', 'Blood Demoniste');
INSERT INTO `playercreateinfo_spell` VALUES ('10', '9', '712', 'Blood Demoniste');
INSERT INTO `playercreateinfo_spell` VALUES ('10', '9', '697', 'Blood Demoniste');
[/code]
Édition :
Ajout du SQL sous CODE aussi