UPDATED 08-30-2014 !
Added mana +1 for each level from 80-255 for creature class 2 and creature class 8 !
I found a thread on another forum (can't say the name of that forum because it's against the rules) and the guy wanted creature_classlevelstats. He said that creatures doesn't deal damage if they are above level 100, So i made some level stats for creature class 1, 2, 4, 8 (All creature classes) from level 1 to level 255. The damage is not perfectly calculated i just increased it by 1 for each level but it should be a decent damage at level 255 :)
this SQL does NOT include basehp or basearmor for creatures above level 80. This is only for the damage and mana for your creatures. But it should work fine anyway, Query have now been tested and works perfectly so far :)
Keep in mind:
Before importing any query you should ALWAYS make a backup. So... Make a backup of your creature_classlevelstats table. To make a backup right click on the table and choose "Export database as SQL" and the rest after that is quite self-explanatory.
So, Here is the query:
Alright, Now the get the amount of mana that you want your creature to have you can use this query:
(Query created by Rochet2 and modified by me so it only adds mana. All credits goes to Rochet2 for this amazing query !)
Replace the green values !Code:-- Instructions: -- Set the NPC Entry and stats you want it to have below. SET @NPC_ENTRY := 58500, -- This is your NPC's Entry @NPC_MANA := 12345; -- This is the mana value you want your NPC to have. -- DO NOT CHANGE ANYTHING BELOW, UNLESS YOU KNOW WHAT YOU ARE DOING. -- Getting NPC datas: SET @NPC_CLASS := (SELECT `unit_class` FROM creature_template WHERE Entry = @NPC_ENTRY), @NPC_LEVEL := ROUND(((SELECT `minlevel` FROM creature_template WHERE Entry = @NPC_ENTRY)+(SELECT `maxlevel` FROM creature_template WHERE Entry = @NPC_ENTRY))/2, 0), @EXP := (SELECT `exp` FROM creature_template WHERE Entry = @NPC_ENTRY); -- Getting base HP from a HP column defined by exp. SET -- Getting base mana @GET_MA_COL := (SELECT basemana FROM creature_classlevelstats WHERE `level` = @NPC_LEVEL and `class` = @NPC_CLASS); -- Getting base armor -- Running the update with all the data collected: UPDATE creature_template SET Mana_mod = (@NPC_MANA/@GET_MA_COL) WHERE Entry = @NPC_ENTRY;