Jump to content
  • Implement Health/Mana fixes to server repo


    madmax
    • Status: Completed
      Main Category: Core / Mangos Daemon
      Sub-Category: Code Enhancement
      Version: 0.20(currentmasterbranch) Milestone: 20-newbeginnings Priority: Normal
      Related to:
      Implemented Version: 0.20(currentmasterbranch)
     Share

    Implement Health/Mana fixes to server repo

    These two SQL query's fix the health and mana offsets currently in zero Rel20.

    UPDATE creature_template, creature_template_classlevelstats SET HealthMultiplier = MinLevelHealth/BaseHealthExp0
    WHERE creature_template_classlevelstats.Level = MinLevel;


    UPDATE creature_template, creature_template_classlevelstats SET PowerMultiplier = MinLevelMana/BaseMana
    WHERE creature_template_classlevelstats.Level = MinLevel and BaseMana != 0;

     Share


    User Feedback

    Recommended Comments

    When I use
    [code]
    UPDATE creature_template, creature_template_classlevelstats SET PowerMultiplier = MinLevelMana/BaseMana
    WHERE creature_template_classlevelstats.Level = MinLevel and BaseMana != 0;
    [/code]
    I get "#1054 - Unknown column 'PowerMultiplier' in 'field list'" because the table isn't there (imported the newest Rel20 DB though with all possible updates)

    Link to comment
    Share on other sites



    Create an account or sign in to comment

    You need to be a member in order to leave a comment

    Create an account

    Sign up for a new account in our community. It's easy!

    Register a new account

    Sign in

    Already have an account? Sign in here.

    Sign In Now

×
×
  • 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