/*
Database name - world
table names - creature_template, creature_classlevelstats

*/

DELIMITER //
DROP PROCEDURE IF EXISTS mydh;
CREATE PROCEDURE mydh()
BEGIN
	DECLARE counter INT DEFAULT 1;
	DECLARE creature_maxlevel INT;
	DECLARE creature_minlevel INT;
	DECLARE creature_healthmod INT;
	DECLARE creature_class INT;
	DECLARE creature_damagemod INT;
	DECLARE creature_armormod INT;
	DECLARE creature_manamod INT;
	DECLARE newmax INT;
	DECLARE newmin INT;
	DECLARE var1 INT;
	DECLARE var2 INT;
	DECLARE var3 INT;
	DECLARE var4 INT;
	DECLARE var5 INT;
	DECLARE var6 INT;
	DECLARE var7 INT;
	DECLARE var8 INT;
	DECLARE countertotal INT DEFAULT 43282;
	
	WHILE counter <= countertotal DO
	
		IF (SELECT type FROM creature_template WHERE entry = counter) != 8 AND (SELECT minlevel FROM creature_template WHERE entry = counter) >= 1 AND (SELECT maxlevel from creature_template WHERE entry = counter) <= 4 THEN
		
			SELECT maxlevel FROM creature_template WHERE entry = counter INTO creature_maxlevel;
			SELECT minlevel FROM creature_template WHERE entry = counter INTO creature_minlevel;
			SELECT HealthModifier FROM creature_template WHERE entry = counter INTO creature_healthmod;
			SELECT unit_class FROM creature_template WHERE entry = counter INTO creature_class;
			SELECT DamageModifier FROM creature_template WHERE entry = counter INTO creature_damagemod;
			SELECT ArmorModifier FROM creature_template WHERE entry = counter INTO creature_armormod;
			SELECT ManaModifier FROM creature_template WHERE entry = counter INTO creature_manamod;
			SET newmin = 40;
			SET newmax = 42;
			SELECT basehp0 FROM creature_classlevelstats WHERE level = creature_maxlevel AND class = creature_class INTO var1;
			SELECT basehp0 FROM creature_classlevelstats WHERE level = newmax AND class = creature_class INTO var2;
			SELECT damage_base FROM creature_classlevelstats WHERE level = creature_maxlevel AND class = creature_class INTO var3;
			SELECT damage_base FROM creature_classlevelstats WHERE level = newmax AND class = creature_class INTO var4;
			SELECT basemana FROM creature_classlevelstats WHERE level = creature_maxlevel AND class = creature_class INTO var5;
			SELECT basemana FROM creature_classlevelstats WHERE level = newmax AND class = creature_class INTO var6;
			SELECT basearmor FROM creature_classlevelstats WHERE level = creature_maxlevel AND class = creature_class INTO var7;
			SELECT basearmor FROM creature_classlevelstats WHERE level = newmax AND class = creature_class INTO var8;
			
			UPDATE creature_template SET minlevel = newmin, maxlevel = newmax WHERE entry = counter;
			UPDATE creature_template SET HealthModifier = creature_healthmod(var1 / var2);
			UPDATE creature_template SET DamageModifier = creature_damagemod(var3 / var4);
			UPDATE creature_template SET ArmorModifier = creature_armormod(var5 / var6);
			UPDATE creature_template SET ManaModifier = creature_manamod(var7 / var8);
		END IF;

	SET counter = counter + 1;
	
	END WHILE;
	
END; //

DELIMITER ;