searching for Patch scripts - level stats

naseem · October 17, 2008

cant find player_levelstats and player_classlevelstats for 255 for current wow verison. i'v searched in the forum but the search filter is not helping.

can any 1 post a patch scrip for 255 player_levelstats and player_classlevelstats?

Gamona · October 17, 2008

mangos only has stats up to lv 70.. for players and pets..

but you can simply update your database with custom content...by yourself

Inflames · October 17, 2008

i think you can make this stats by using Excel

sparc · October 18, 2008

Hi

Here are some procedures to calculate stats.

pet_levelstats

DELIMITER $$

DROP PROCEDURE IF EXISTS `sp_PetExtraLevelStats` $$
CREATE PROCEDURE `sp_PetExtraLevelStats` ()
BEGIN

 -- Declaration des constantes/maximum/limites
 DECLARE intMaxHP       INT   DEFAULT 65535;
 DECLARE intMaxMana     INT   DEFAULT 65535;
 DECLARE intMaxArmor    INT   DEFAULT 65535;
 DECLARE intMaxStats    INT   DEFAULT 600;
 DECLARE sngHPInc       FLOAT DEFAULT 0.05;    -- Increment of 5% per level, adjust to whatever you like
 DECLARE sngManaInc     FLOAT DEFAULT 0.05;    -- Increment of 5% per level, adjust to whatever you like
 DECLARE sngArmorInc    FLOAT DEFAULT 0.05;    -- Increment of 5% per level, adjust to whatever you like
 DECLARE sngStatsInc    FLOAT DEFAULT 0.05;    -- Increment of 5% per level, adjust to whatever you like
 DECLARE intStartLvl    INT   DEFAULT 70;      -- Starting level,70 is the default
 DECLARE intFinishLvl   INT   DEFAULT 80;      -- Finishing level, 80 is the default

 -- Declaration des variables de base
 DECLARE intRecordDone  INT   DEFAULT 0;
 DECLARE intCreature    INT   DEFAULT 0;
 DECLARE intLevel       INT   DEFAULT 0;
 DECLARE intClass       INT   DEFAULT 0;
 DECLARE intCurrHP      INT   DEFAULT 0;
 DECLARE intCurrMana    INT   DEFAULT 0;
 DECLARE intCurrArmor   INT   DEFAULT 0;
 DECLARE intCurrSTR     INT   DEFAULT 0;
 DECLARE intCurrAGI     INT   DEFAULT 0;
 DECLARE intCurrSTA     INT   DEFAULT 0;
 DECLARE intCurrINT     INT   DEFAULT 0;
 DECLARE intCurrSPI     INT   DEFAULT 0;


 -- Declaration de l'algorythme
 DECLARE curPetStat  CURSOR FOR SELECT `creature_entry`, `level`, `hp`, `mana`, `armor`, `str`, `agi`, `sta`, `inte`, `spi` FROM pet_levelstats;
 DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET intRecordDone = 1;


 OPEN curPetStat;

 REPEAT

   FETCH curPetStat INTO intCreature, intLevel, intCurrHP, intCurrMana, intCurrArmor, intCurrSTR, intCurrAGI, intCurrSTA, intCurrINT, intCurrSPI;

   IF intLevel = intStartLvl THEN
      REPEAT
        -- ce que nous allons faire pour le lvl suivant
        SET intLevel = intLevel + 1;
        -- Delete the entry for the next level (this is so we don't have to check whether we need UPDATE or INSERT statement
        DELETE FROM pet_levelstats WHERE `creature_entry` = intCreature AND `level` = intLevel;

        -- Calcule du suivant H{
        IF (ROUND(intCurrHP * (1 + sngHPInc))) <= intMaxHP THEN
          SET intCurrHP = ROUND(intCurrHP * (1 + sngHPInc));
        ELSE
          SET intCurrHP = intMaxHP;  -- Making sure we don't exceed the database limit
        END IF;
        -- Calcule des Mana suivant
        IF (ROUND(intCurrMana * (1 + sngManaInc))) <= intMaxMana THEN
          SET intCurrMana = ROUND(intCurrMana * (1 + sngManaInc));
        ELSE
          SET intCurrMana = intMaxMana;
        END IF;
        -- Calcule de l'armure suivant
        IF (ROUND(intCurrArmor * (1 + sngArmorInc))) <= intMaxArmor THEN
          SET intCurrArmor = ROUND(intCurrArmor * (1 + sngArmorInc));
        ELSE
          SET intCurrArmor = intMaxArmor;
        END IF;
        -- Calcule du suivant STR
        IF (ROUND(intCurrSTR * (1 + sngStatsInc))) <= intMaxStats THEN
          SET intCurrSTR = ROUND(intCurrSTR * (1 + sngStatsInc));
        ELSE
          SET intCurrSTR = intMaxStats;
        END IF;
        -- Calcule du suivant AGI
        IF (ROUND(intCurrAGI * (1 + sngStatsInc))) <= intMaxStats THEN
          SET intCurrAGI = ROUND(intCurrAGI * (1 + sngStatsInc));
        ELSE
          SET intCurrAGI = intMaxStats;
        END IF;
        -- Calcule du suivant STA
        IF (ROUND(intCurrSTA * (1 + sngStatsInc))) <= intMaxStats THEN
          SET intCurrSTA = ROUND(intCurrSTA * (1 + sngStatsInc));
        ELSE
          SET intCurrSTA = intMaxStats;
        END IF;
        -- Calcule du suivant INT
        IF (ROUND(intCurrINT * (1 + sngStatsInc))) <= intMaxStats THEN
          SET intCurrINT = ROUND(intCurrINT * (1 + sngStatsInc));
        ELSE
          SET intCurrINT = intMaxStats;
        END IF;
        -- Calcule du suivant SPI
        IF (ROUND(intCurrSPI * (1 + sngStatsInc))) <= intMaxStats THEN
          SET intCurrSPI = ROUND(intCurrSPI * (1 + sngStatsInc));
        ELSE
          SET intCurrSPI = intMaxStats;
        END IF;

        -- Insertion dans la table
        INSERT INTO pet_levelstats
        (`creature_entry`, `level`, `hp`, `mana`, `armor`, `str`, `agi`, `sta`, `inte`, `spi`)
        VALUES
        (intCreature, intLevel, intCurrHP, intCurrMana, intCurrArmor, intCurrSTR, intCurrAGI, intCurrSTA, intCurrINT, intCurrSPI);
      UNTIL intLevel = intFinishLvl END REPEAT;
   END IF;
 UNTIL intRecordDone END REPEAT;

 -- on ferme l'algorythme
 CLOSE curPetStat;

END $$

DELIMITER ;
call sp_PetExtraLevelStats();

sparc · October 18, 2008

player_classlevelstats

DELIMITER $$

DROP PROCEDURE IF EXISTS `sp_CharExtraclassLevelStats` $$
CREATE PROCEDURE `sp_CharExtraclassLevelStats` ()
BEGIN

 -- Declaration des constantes/maximum/limites
 DECLARE intMaxHP       INT   DEFAULT 65535;
 DECLARE intMaxMana     INT   DEFAULT 65535;
 DECLARE sngHPInc       FLOAT DEFAULT 0.05;    -- Increment of 5% per level, adjust to whatever you like
 DECLARE sngManaInc     FLOAT DEFAULT 0.05;    -- Increment of 5% per level, adjust to whatever you like
 DECLARE intStartLvl    INT   DEFAULT 70;      -- Starting level,70 is the default
 DECLARE intFinishLvl   INT   DEFAULT 80;      -- Finishing level, 80 is the default

 -- Declaration des variables de base
 DECLARE intRecordDone  INT   DEFAULT 0;
 DECLARE intClass       INT   DEFAULT 0;
 DECLARE intLevel       INT   DEFAULT 0;
 DECLARE intCurrHP      INT   DEFAULT 0;
 DECLARE intCurrMana    INT   DEFAULT 0;



 -- Declaration de l'algorythme
 DECLARE curPlayerStat  CURSOR FOR SELECT `class`, `level`, `basehp`, `basemana` FROM player_classlevelstats;
 DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET intRecordDone = 1;

 OPEN curPlayerStat;

 REPEAT

   FETCH curPlayerStat INTO intClass, intLevel, intCurrHP, intCurrMana;

   IF intLevel = intStartLvl THEN
      REPEAT
        -- nous allons faire cela pour le lvl suivant
        SET intLevel = intLevel + 1;
        -- Delete the entry for the next level (this is so we don't have to check whether we need UPDATE or INSERT statement
        DELETE FROM player_classlevelstats WHERE `class` = intClass AND `level` = intLevel;

        -- Calcule du suivant H{
        IF (ROUND(intCurrHP * (1 + sngHPInc))) <= intMaxHP THEN
          SET intCurrHP = ROUND(intCurrHP * (1 + sngHPInc));
        ELSE
          SET intCurrHP = intMaxHP;  -- Making sure we don't exceed the database limit
        END IF;
        -- Calcule des Mana suivant
        IF (ROUND(intCurrMana * (1 + sngManaInc))) <= intMaxMana THEN
          SET intCurrMana = ROUND(intCurrMana * (1 + sngManaInc));
        ELSE
          SET intCurrMana = intMaxMana;
        END IF;


        -- Insertion dans la table
        INSERT INTO player_classlevelstats
        (`class`, `level`, `basehp`, `basemana`)
        VALUES
        (intClass, intLevel, intCurrHP, intCurrMana);
      UNTIL intLevel = intFinishLvl END REPEAT;
   END IF;
 UNTIL intRecordDone END REPEAT;

 -- on ferme l'algorythme
 CLOSE curPlayerStat;

END $$

DELIMITER ;
call sp_CharExtraclassLevelStats();

sparc · October 18, 2008

and player_levelstats

DELIMITER $$

DROP PROCEDURE IF EXISTS `sp_CharExtraLevelStats` $$
CREATE PROCEDURE `sp_CharExtraLevelStats` ()
BEGIN

 -- Declaration des constantes/maximum/limites
 DECLARE intMaxStats    INT   DEFAULT 255;
 DECLARE sngStatsInc    FLOAT DEFAULT 0.05;    -- Increment of 5% per level, adjust to whatever you like
 DECLARE intStartLvl    INT   DEFAULT 70;      -- Starting level,70 is the default
 DECLARE intFinishLvl   INT   DEFAULT 80;      -- Finishing level, 80 is the default

 -- Declaration des variabes de base
 DECLARE intRecordDone  INT   DEFAULT 0;
 DECLARE intRace        INT   DEFAULT 0;
 DECLARE intClass       INT   DEFAULT 0;
 DECLARE intLevel       INT   DEFAULT 0;
 DECLARE intCurrSTR     INT   DEFAULT 0;
 DECLARE intCurrAGI     INT   DEFAULT 0;
 DECLARE intCurrSTA     INT   DEFAULT 0;
 DECLARE intCurrINT     INT   DEFAULT 0;
 DECLARE intCurrSPI     INT   DEFAULT 0;


 -- Declaration des algorythme
 DECLARE curPlayerStat  CURSOR FOR SELECT `race`, `class`, `level`, `str`, `agi`, `sta`, `inte`, `spi` FROM player_levelstats;
 DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET intRecordDone = 1;


 OPEN curPlayerStat;

 REPEAT

   FETCH curPlayerStat INTO intRace, intClass, intLevel, intCurrSTR, intCurrAGI, intCurrSTA, intCurrINT, intCurrSPI;

   IF intLevel = intStartLvl THEN
      REPEAT
        -- Nous allons faire cela pour le lvl suivant
        SET intLevel = intLevel + 1;
        -- Delete the entry for the next level (this is so we don't have to check whether we need UPDATE or INSERT statement
        DELETE FROM player_levelstats WHERE `race` = intRace AND `class` = intClass AND `level` = intLevel;

        -- Calcule du suivant STR
        IF (ROUND(intCurrSTR * (1 + sngStatsInc))) <= intMaxStats THEN
          SET intCurrSTR = ROUND(intCurrSTR * (1 + sngStatsInc));
        ELSE
          SET intCurrSTR = intMaxStats;
        END IF;
        -- Calcule du suivant AGI
        IF (ROUND(intCurrAGI * (1 + sngStatsInc))) <= intMaxStats THEN
          SET intCurrAGI = ROUND(intCurrAGI * (1 + sngStatsInc));
        ELSE
          SET intCurrAGI = intMaxStats;
        END IF;
        -- Calcule du suivant STA
        IF (ROUND(intCurrSTA * (1 + sngStatsInc))) <= intMaxStats THEN
          SET intCurrSTA = ROUND(intCurrSTA * (1 + sngStatsInc));
        ELSE
          SET intCurrSTA = intMaxStats;
        END IF;
        -- Calcule du suivant INT
        IF (ROUND(intCurrINT * (1 + sngStatsInc))) <= intMaxStats THEN
          SET intCurrINT = ROUND(intCurrINT * (1 + sngStatsInc));
        ELSE
          SET intCurrINT = intMaxStats;
        END IF;
        -- Calcule du suivant SPI
        IF (ROUND(intCurrSPI * (1 + sngStatsInc))) <= intMaxStats THEN
          SET intCurrSPI = ROUND(intCurrSPI * (1 + sngStatsInc));
        ELSE
          SET intCurrSPI = intMaxStats;
        END IF;

        -- insertion dans la table
        INSERT INTO player_levelstats
        (`race`, `class`, `level`, `str`, `agi`, `sta`, `inte`, `spi`)
        VALUES
        (intRace, intClass, intLevel, intCurrSTR, intCurrAGI, intCurrSTA, intCurrINT, intCurrSPI);
      UNTIL intLevel = intFinishLvl END REPEAT;
   END IF;
 UNTIL intRecordDone END REPEAT;

 -- on ferme l'algorythme
 CLOSE curPlayerStat;

END $$

DELIMITER ;
call sp_CharExtraLevelStats();

naseem · October 18, 2008

thank u for the help! but when i try to execute the script i get this error

(0 row(s) affected, 1 warning(s))

Execution Time : 00:00:00:000

Transfer Time : 00:00:00:000

Total Time : 00:00:00:000

Error Code : 1044

Access denied for user 'root'@'%' to database 'mangos'

Execution Time : 00:00:00:000

Transfer Time : 00:00:00:000

Total Time : 00:00:00:000

Error Code : 1305

PROCEDURE mangos.sp_CharExtraclassLevelStats does not exist

Execution Time : 00:00:00:000

Transfer Time : 00:00:00:000

Total Time : 00:00:00:000

naseem · October 18, 2008

can some 1 tell me whyi get this msg when i try to execute the script for player level stats or the others?

Error Code : 1044

Access denied for user 'root'@'%' to database 'mangos'

naseem · October 25, 2008

and player_levelstats

DELIMITER $$

DROP PROCEDURE IF EXISTS `sp_CharExtraLevelStats` $$
CREATE PROCEDURE `sp_CharExtraLevelStats` ()
BEGIN

 -- Declaration des constantes/maximum/limites
 DECLARE intMaxStats    INT   DEFAULT 255;
 DECLARE sngStatsInc    FLOAT DEFAULT 0.05;    -- Increment of 5% per level, adjust to whatever you like
 DECLARE intStartLvl    INT   DEFAULT 70;      -- Starting level,70 is the default
 DECLARE intFinishLvl   INT   DEFAULT 80;      -- Finishing level, 80 is the default

 -- Declaration des variabes de base
 DECLARE intRecordDone  INT   DEFAULT 0;
 DECLARE intRace        INT   DEFAULT 0;
 DECLARE intClass       INT   DEFAULT 0;
 DECLARE intLevel       INT   DEFAULT 0;
 DECLARE intCurrSTR     INT   DEFAULT 0;
 DECLARE intCurrAGI     INT   DEFAULT 0;
 DECLARE intCurrSTA     INT   DEFAULT 0;
 DECLARE intCurrINT     INT   DEFAULT 0;
 DECLARE intCurrSPI     INT   DEFAULT 0;


 -- Declaration des algorythme
 DECLARE curPlayerStat  CURSOR FOR SELECT `race`, `class`, `level`, `str`, `agi`, `sta`, `inte`, `spi` FROM player_levelstats;
 DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET intRecordDone = 1;


 OPEN curPlayerStat;

 REPEAT

   FETCH curPlayerStat INTO intRace, intClass, intLevel, intCurrSTR, intCurrAGI, intCurrSTA, intCurrINT, intCurrSPI;

   IF intLevel = intStartLvl THEN
      REPEAT
        -- Nous allons faire cela pour le lvl suivant
        SET intLevel = intLevel + 1;
        -- Delete the entry for the next level (this is so we don't have to check whether we need UPDATE or INSERT statement
        DELETE FROM player_levelstats WHERE `race` = intRace AND `class` = intClass AND `level` = intLevel;

        -- Calcule du suivant STR
        IF (ROUND(intCurrSTR * (1 + sngStatsInc))) <= intMaxStats THEN
          SET intCurrSTR = ROUND(intCurrSTR * (1 + sngStatsInc));
        ELSE
          SET intCurrSTR = intMaxStats;
        END IF;
        -- Calcule du suivant AGI
        IF (ROUND(intCurrAGI * (1 + sngStatsInc))) <= intMaxStats THEN
          SET intCurrAGI = ROUND(intCurrAGI * (1 + sngStatsInc));
        ELSE
          SET intCurrAGI = intMaxStats;
        END IF;
        -- Calcule du suivant STA
        IF (ROUND(intCurrSTA * (1 + sngStatsInc))) <= intMaxStats THEN
          SET intCurrSTA = ROUND(intCurrSTA * (1 + sngStatsInc));
        ELSE
          SET intCurrSTA = intMaxStats;
        END IF;
        -- Calcule du suivant INT
        IF (ROUND(intCurrINT * (1 + sngStatsInc))) <= intMaxStats THEN
          SET intCurrINT = ROUND(intCurrINT * (1 + sngStatsInc));
        ELSE
          SET intCurrINT = intMaxStats;
        END IF;
        -- Calcule du suivant SPI
        IF (ROUND(intCurrSPI * (1 + sngStatsInc))) <= intMaxStats THEN
          SET intCurrSPI = ROUND(intCurrSPI * (1 + sngStatsInc));
        ELSE
          SET intCurrSPI = intMaxStats;
        END IF;

        -- insertion dans la table
        INSERT INTO player_levelstats
        (`race`, `class`, `level`, `str`, `agi`, `sta`, `inte`, `spi`)
        VALUES
        (intRace, intClass, intLevel, intCurrSTR, intCurrAGI, intCurrSTA, intCurrINT, intCurrSPI);
      UNTIL intLevel = intFinishLvl END REPEAT;
   END IF;
 UNTIL intRecordDone END REPEAT;

 -- on ferme l'algorythme
 CLOSE curPlayerStat;

END $$

DELIMITER ;
call sp_CharExtraLevelStats();

I'm having trouble executing this script inside the DB i get Root access problem is there away around this problem?

STWoW · November 15, 2008

I'm sorry for reviving this a bit; But what language are these scripts written in please? My scripting guy doesn't seem to recognize it.

Thank you very much.

DasBlub · November 15, 2008

I'm sorry for reviving this a bit; But what language are these scripts written in please? My scripting guy doesn't seem to recognize it.
Thank you very much.

this are mysql stored procedures (sp)

subhuman_bob · November 15, 2008

Disclaimer: I have not personally tried these, but maybe they will help: http://udbforums.org/index.php?topic=11170.0

LilaLauneTeddy · November 27, 2008

Hi

Here are some procedures to calculate stats.

pet_levelstats

DELIMITER $$

DROP PROCEDURE IF EXISTS `sp_PetExtraLevelStats` $$
CREATE PROCEDURE `sp_PetExtraLevelStats` ()
BEGIN

 -- Declaration des constantes/maximum/limites
 DECLARE intMaxHP       INT   DEFAULT 65535;
 DECLARE intMaxMana     INT   DEFAULT 65535;
 DECLARE intMaxArmor    INT   DEFAULT 65535;
 DECLARE intMaxStats    INT   DEFAULT 600;
 DECLARE sngHPInc       FLOAT DEFAULT 0.05;    -- Increment of 5% per level, adjust to whatever you like
 DECLARE sngManaInc     FLOAT DEFAULT 0.05;    -- Increment of 5% per level, adjust to whatever you like
 DECLARE sngArmorInc    FLOAT DEFAULT 0.05;    -- Increment of 5% per level, adjust to whatever you like
 DECLARE sngStatsInc    FLOAT DEFAULT 0.05;    -- Increment of 5% per level, adjust to whatever you like
 DECLARE intStartLvl    INT   DEFAULT 70;      -- Starting level,70 is the default
 DECLARE intFinishLvl   INT   DEFAULT 80;      -- Finishing level, 80 is the default

 -- Declaration des variables de base
 DECLARE intRecordDone  INT   DEFAULT 0;
 DECLARE intCreature    INT   DEFAULT 0;
 DECLARE intLevel       INT   DEFAULT 0;
 DECLARE intClass       INT   DEFAULT 0;
 DECLARE intCurrHP      INT   DEFAULT 0;
 DECLARE intCurrMana    INT   DEFAULT 0;
 DECLARE intCurrArmor   INT   DEFAULT 0;
 DECLARE intCurrSTR     INT   DEFAULT 0;
 DECLARE intCurrAGI     INT   DEFAULT 0;
 DECLARE intCurrSTA     INT   DEFAULT 0;
 DECLARE intCurrINT     INT   DEFAULT 0;
 DECLARE intCurrSPI     INT   DEFAULT 0;


 -- Declaration de l'algorythme
 DECLARE curPetStat  CURSOR FOR SELECT `creature_entry`, `level`, `hp`, `mana`, `armor`, `str`, `agi`, `sta`, `inte`, `spi` FROM pet_levelstats;
 DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET intRecordDone = 1;


 OPEN curPetStat;

 REPEAT

   FETCH curPetStat INTO intCreature, intLevel, intCurrHP, intCurrMana, intCurrArmor, intCurrSTR, intCurrAGI, intCurrSTA, intCurrINT, intCurrSPI;

   IF intLevel = intStartLvl THEN
      REPEAT
        -- ce que nous allons faire pour le lvl suivant
        SET intLevel = intLevel + 1;
        -- Delete the entry for the next level (this is so we don't have to check whether we need UPDATE or INSERT statement
        DELETE FROM pet_levelstats WHERE `creature_entry` = intCreature AND `level` = intLevel;

        -- Calcule du suivant H{
        IF (ROUND(intCurrHP * (1 + sngHPInc))) <= intMaxHP THEN
          SET intCurrHP = ROUND(intCurrHP * (1 + sngHPInc));
        ELSE
          SET intCurrHP = intMaxHP;  -- Making sure we don't exceed the database limit
        END IF;
        -- Calcule des Mana suivant
        IF (ROUND(intCurrMana * (1 + sngManaInc))) <= intMaxMana THEN
          SET intCurrMana = ROUND(intCurrMana * (1 + sngManaInc));
        ELSE
          SET intCurrMana = intMaxMana;
        END IF;
        -- Calcule de l'armure suivant
        IF (ROUND(intCurrArmor * (1 + sngArmorInc))) <= intMaxArmor THEN
          SET intCurrArmor = ROUND(intCurrArmor * (1 + sngArmorInc));
        ELSE
          SET intCurrArmor = intMaxArmor;
        END IF;
        -- Calcule du suivant STR
        IF (ROUND(intCurrSTR * (1 + sngStatsInc))) <= intMaxStats THEN
          SET intCurrSTR = ROUND(intCurrSTR * (1 + sngStatsInc));
        ELSE
          SET intCurrSTR = intMaxStats;
        END IF;
        -- Calcule du suivant AGI
        IF (ROUND(intCurrAGI * (1 + sngStatsInc))) <= intMaxStats THEN
          SET intCurrAGI = ROUND(intCurrAGI * (1 + sngStatsInc));
        ELSE
          SET intCurrAGI = intMaxStats;
        END IF;
        -- Calcule du suivant STA
        IF (ROUND(intCurrSTA * (1 + sngStatsInc))) <= intMaxStats THEN
          SET intCurrSTA = ROUND(intCurrSTA * (1 + sngStatsInc));
        ELSE
          SET intCurrSTA = intMaxStats;
        END IF;
        -- Calcule du suivant INT
        IF (ROUND(intCurrINT * (1 + sngStatsInc))) <= intMaxStats THEN
          SET intCurrINT = ROUND(intCurrINT * (1 + sngStatsInc));
        ELSE
          SET intCurrINT = intMaxStats;
        END IF;
        -- Calcule du suivant SPI
        IF (ROUND(intCurrSPI * (1 + sngStatsInc))) <= intMaxStats THEN
          SET intCurrSPI = ROUND(intCurrSPI * (1 + sngStatsInc));
        ELSE
          SET intCurrSPI = intMaxStats;
        END IF;

        -- Insertion dans la table
        INSERT INTO pet_levelstats
        (`creature_entry`, `level`, `hp`, `mana`, `armor`, `str`, `agi`, `sta`, `inte`, `spi`)
        VALUES
        (intCreature, intLevel, intCurrHP, intCurrMana, intCurrArmor, intCurrSTR, intCurrAGI, intCurrSTA, intCurrINT, intCurrSPI);
      UNTIL intLevel = intFinishLvl END REPEAT;
   END IF;
 UNTIL intRecordDone END REPEAT;

 -- on ferme l'algorythme
 CLOSE curPetStat;

END $$

DELIMITER ;
call sp_PetExtraLevelStats();

THX sparc, it works all fine

marxy · November 8, 2010

pet leveltstas table changed mabye someone have little sql for it to?

Sign In

searching for Patch scripts - level stats

Recommended Posts

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Recently Browsing 0 members

Contact Us

Repositories

Important Information