Jump to content
  • Action bars and food for new characters.


    Necrovoice
    • Status: Completed
      Main Category: Database
      Sub-Category: Minor
      Version: 21.11 Milestone: 21 Priority: Normal
      Implemented Version: 21.2

    Newly created characters show food in tool bar and dont start with any, some start with food but dont show in tool bar,

    I was messing around today and noticed that a small hand full of race/class combinations show food in their tool bar yet they should not start with any. Death Knights on the other hand start with food but don't show the item in the tool bar. I am working on a fix and should have one ready in the next few days.


    User Feedback

    Recommended Comments

    This is 1 of 2 suggestions to update the bars issue showing food that players no longer start with. I will add the addition of the food icon for death knights shortly.
    [code]DELETE FROM `mangos`.`playercreateinfo_action` WHERE `race` = '10' AND `class` = '4' AND `button` = '11' AND `action` = '20857' AND `type` = '128';
    DELETE FROM `mangos`.`playercreateinfo_action` WHERE `race` = '10' AND `class` = '9' AND `button` = '11' AND `action` = '20857' AND `type` = '128';
    DELETE FROM `mangos`.`playercreateinfo_action` WHERE `race` = '5' AND `class` = '4' AND `button` = '11' AND `action` = '4604' AND `type` = '128';
    DELETE FROM `mangos`.`playercreateinfo_action` WHERE `race` = '1' AND `class` = '9' AND `button` = '11' AND `action` = '4604' AND `type` = '128';
    DELETE FROM `mangos`.`playercreateinfo_action` WHERE `race` = '10' AND `class` = '8' AND `button` = '11' AND `action` = '20857' AND `type` = '128';
    DELETE FROM `mangos`.`playercreateinfo_action` WHERE `race` = '10' AND `class` = '5' AND `button` = '11' AND `action` = '20857' AND `type` = '128';
    DELETE FROM `mangos`.`playercreateinfo_action` WHERE `race` = '10' AND `class` = '2' AND `button` = '11' AND `action` = '20857' AND `type` = '128';
    DELETE FROM `mangos`.`playercreateinfo_action` WHERE `race` = '8' AND `class` = '3' AND `button` = '11' AND `action` = '4604' AND `type` = '128';
    DELETE FROM `mangos`.`playercreateinfo_action` WHERE `race` = '10' AND `class` = '3' AND `button` = '11' AND `action` = '20857' AND `type` = '128';
    DELETE FROM `mangos`.`playercreateinfo_action` WHERE `race` = '6' AND `class` = '7' AND `button` = '11' AND `action` = '4604' AND `type` = '128';
    DELETE FROM `mangos`.`playercreateinfo_action` WHERE `race` = '5' AND `class` = '1' AND `button` = '83' AND `action` = '4604' AND `type` = '128';
    DELETE FROM `mangos`.`playercreateinfo_action` WHERE `race` = '7' AND `class` = '6' AND `button` = '83' AND `action` = '41751' AND `type` = '128';[/code]

    Link to comment
    Share on other sites

    Here is the correction in its entirety. I would submit, but it looks like some of it was already done by the Implemented Version tag. Let me know what you would like me to do with this final product.

     

    /*
    remove unnecessary action food bar icon
    */
    
    DELETE FROM `playercreateinfo_action` WHERE `race` = '10' AND `class` = '9' AND `button` = '11' AND `action` = '20857' AND `type` = '128'; 
    DELETE FROM `playercreateinfo_action` WHERE `race` = '10' AND `class` = '8' AND `button` = '11' AND `action` = '20857' AND `type` = '128'; 
    DELETE FROM `playercreateinfo_action` WHERE `race` = '10' AND `class` = '5' AND `button` = '11' AND `action` = '20857' AND `type` = '128';
    DELETE FROM `playercreateinfo_action` WHERE `race` = '10' AND `class` = '4' AND `button` = '11' AND `action` = '20857' AND `type` = '128'; 
    DELETE FROM `playercreateinfo_action` WHERE `race` = '10' AND `class` = '2' AND `button` = '11' AND `action` = '20857' AND `type` = '128'; 
    DELETE FROM `playercreateinfo_action` WHERE `race` = '10' AND `class` = '3' AND `button` = '11' AND `action` = '20857' AND `type` = '128'; 
    DELETE FROM `playercreateinfo_action` WHERE `race` = '8' AND `class` = '3' AND `button` = '11' AND `action` = '4604' AND `type` = '128'; 
    DELETE FROM `playercreateinfo_action` WHERE `race` = '7' AND `class` = '6' AND `button` = '83' AND `action` = '41751' AND `type` = '128'; 
    DELETE FROM `playercreateinfo_action` WHERE `race` = '6' AND `class` = '7' AND `button` = '11' AND `action` = '4604' AND `type` = '128';
    DELETE FROM `playercreateinfo_action` WHERE `race` = '5' AND `class` = '4' AND `button` = '11' AND `action` = '4604' AND `type` = '128';
    DELETE FROM `playercreateinfo_action` WHERE `race` = '5' AND `class` = '1' AND `button` = '83' AND `action` = '4604' AND `type` = '128'; 
    DELETE FROM `playercreateinfo_action` WHERE `race` = '1' AND `class` = '9' AND `button` = '11' AND `action` = '4604' AND `type` = '128'; 
    
    
    /*
    Add food icon to deathknight action bar
    */
    
    Update `playercreateinfo_action` set `button` = '10' where `race` = '1' and `class` = '6' and `button` = '11'
    INSERT INTO `playercreateinfo_action` (`race`, `class`, `button`, `action`, `type`) VALUES('1','6','11','41751','128');
    INSERT INTO `playercreateinfo_action` (`race`, `class`, `button`, `action`, `type`) VALUES('2','6','11','41751','128');
    INSERT INTO `playercreateinfo_action` (`race`, `class`, `button`, `action`, `type`) VALUES('3','6','11','41751','128');
    INSERT INTO `playercreateinfo_action` (`race`, `class`, `button`, `action`, `type`) VALUES('4','6','11','41751','128');
    INSERT INTO `playercreateinfo_action` (`race`, `class`, `button`, `action`, `type`) VALUES('5','6','11','41751','128');
    INSERT INTO `playercreateinfo_action` (`race`, `class`, `button`, `action`, `type`) VALUES('6','6','11','41751','128');
    INSERT INTO `playercreateinfo_action` (`race`, `class`, `button`, `action`, `type`) VALUES('8','6','11','41751','128');
    INSERT INTO `playercreateinfo_action` (`race`, `class`, `button`, `action`, `type`) VALUES('10','6','11','41751','128');

     
     

    Edited by Necrovoice
    Link to comment
    Share on other sites


×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue. Privacy Policy Terms of Use