/* Windfury totems rank 4 and 5 */
UPDATE `creature_template` SET `minhealth` = '3016',
`maxhealth` = '3016',
`minmana` = '300',
`maxmana` = '300',
`rangedattackpower` = '100',
`spell1` = '25581',
`spell2` = '25583',
`ScriptName` = 'generic_creature' WHERE `creature_template`.`entry` =15496 LIMIT 1 ;


UPDATE `creature_template` SET `minhealth` = '4016',
`maxhealth` = '4016',
`minmana` = '325',
`maxmana` = '325',
`rangedattackpower` = '100',
`spell1` = '25582',
`spell2` = '25584',
`ScriptName` = 'generic_creature' WHERE `creature_template`.`entry` =15497 LIMIT 1 ;


/*Fire resistance totem rank 4*/
UPDATE `creature_template` SET `subname` = NULL WHERE `creature_template`.`entry` =15487 LIMIT 1 ;
UPDATE `creature_template` SET `minlevel` = '68',
`maxlevel` = '68',
`minhealth` = '5484',
`maxhealth` = '5484',
`minmana` = '300',
`maxmana` = '300',
`faction` = '116',
`attackpower` = '100',
`rangedattackpower` = '100',
`spell1` = '25562',
`ScriptName` = 'generic_creature' WHERE `creature_template`.`entry` =15487 LIMIT 1 ;

/*Frost resistance totem rank 4*/
UPDATE `creature_template` SET `minlevel` = '67',
`maxlevel` = '67',
`minhealth` = '5356',
`maxhealth` = '5356',
`minmana` = '300',
`maxmana` = '300',
`faction` = '116',
`speed` = '0.01',
`mindmg` = '115',
`maxdmg` = '148.35',
`attackpower` = '100',
`baseattacktime` = '1430',
`rangeattacktime` = '1573',
`minrangedmg` = '71.7288',
`maxrangedmg` = '98.6271',
`rangedattackpower` = '100',
`spell1` = '25559',
`ScriptName` = 'generic_creature' WHERE `creature_template`.`entry` =15486 LIMIT 1 ;

/*Strength totem rank 6*/
UPDATE `creature_template` SET `minhealth` = '5',
`maxhealth` = '5',
`minmana` = '300',
`maxmana` = '300',
`faction` = '6',
`speed` = '0.01',
`attackpower` = '100',
`baseattacktime` = '1850',
`rangeattacktime` = '1850',
`spell1` = '25527',
`ScriptName` = 'generic_creature' WHERE `creature_template`.`entry` =15479 LIMIT 1 ;


/*Mana spring totem rank 5*/
UPDATE `creature_template` SET `minlevel` = '65',
`maxlevel` = '65',
`minhealth` = '5231',
`maxhealth` = '5231',
`minmana` = '300',
`maxmana` = '300',
`faction` = '2',
`speed` = '0.01',
`attackpower` = '100',
`baseattacktime` = '1430',
`rangeattacktime` = '1573',
`rangedattackpower` = '100',
`spell1` = '25569',
`ScriptName` = 'generic_creature' WHERE `creature_template`.`entry` =15489 LIMIT 1 ;


/* Magma totem rank 5*/

UPDATE `creature_template` SET `minlevel` = '65',
`maxlevel` = '65',
`minhealth` = '5231',
`maxhealth` = '5231',
`minmana` = '300',
`maxmana` = '300',
`faction` = '6',
`speed` = '0.01',
`minrangedmg` = '70.4704',
`maxrangedmg` = '96.8968',
`rangedattackpower` = '100',
`spell1` = '25551',
`ScriptName` = 'generic_creature' WHERE `creature_template`.`entry` =15484 LIMIT 1 ;




/*Stoneclaw Totem (Rank 7)*/
UPDATE `creature_template` SET `minlevel` = '67',
`maxlevel` = '67',
`minhealth` = '5484',
`maxhealth` = '5484',
`minmana` = '300',
`maxmana` = '300',
`faction` = '116',
`speed` = '0.01',
`attackpower` = '100',
`baseattacktime` = '1430',
`rangeattacktime` = '1573',
`rangedattackpower` = '100',
`spell1` = '25513',
`ScriptName` = 'generic_creature' WHERE `creature_template`.`entry` =15478 LIMIT 1 ;



/*Fire nova totems rank 1 - 7*/
UPDATE `creature_template` SET `spell2` = '8443' WHERE `creature_template`.`entry` =5879 LIMIT 1 ;
UPDATE `creature_template` SET `spell2` = '8504' WHERE `creature_template`.`entry` =6110 LIMIT 1 ;
UPDATE `creature_template` SET `spell2` = '8505' WHERE `creature_template`.`entry` =6111 LIMIT 1 ;
UPDATE `creature_template` SET `spell2` = '11310' WHERE `creature_template`.`entry` =7844 LIMIT 1 ;
UPDATE `creature_template` SET `spell2` = '11311' WHERE `creature_template`.`entry` =7845 LIMIT 1 ;

UPDATE `creature_template` SET `minlevel` = '61',
`maxlevel` = '61',
`minhealth` = '3748',
`maxhealth` = '3748',
`minmana` = '300',
`maxmana` = '300',
`faction` = '6',
`speed` = '0.01',
`mindmg` = '105',
`maxdmg` = '135.45',
`attackpower` = '100',
`baseattacktime` = '1470',
`rangeattacktime` = '1617',
`minrangedmg` = '67.2672',
`maxrangedmg` = '92.4924',
`rangedattackpower` = '100',
`spell1` = '25535',
`spell2` = '25538',
`ScriptName` = 'generic_creature' WHERE `creature_template`.`entry` =15482 LIMIT 1 ;

UPDATE `creature_template` SET `minlevel` = '70',
`minhealth` = '7300',
`minmana` = '300',
`maxmana` = '300',
`faction` = '6',
`speed` = '0.01',
`attackpower` = '100',
`baseattacktime` = '1470',
`rangeattacktime` = '1617',
`minrangedmg` = '67.2672',
`maxrangedmg` = '92.4924',
`rangedattackpower` = '100',
`spell1` = '25537',
`spell2` = '25539',
`ScriptName` = 'generic_creature' WHERE `creature_template`.`entry` =15483 LIMIT 1 ;

/*Windwall totem rank 4*/
UPDATE `creature_template` SET `minlevel` = '65',
`maxlevel` = '65',
`minhealth` = '5612',
`maxhealth` = '5612',
`minmana` = '300',
`maxmana` = '300',
`faction` = '168',
`speed` = '0.01',
`mindmg` = '119',
`maxdmg` = '153.51',
`minrangedmg` = '73.7264',
`maxrangedmg` = '101.374',
`combat_reach` = '2.56',
`spell1` = '25576',
`ScriptName` = 'generic_creature' WHERE `creature_template`.`entry` =15492 LIMIT 1 ;

/*Wrath of air totem rank 1*/
UPDATE `creature_template` SET `minlevel` = '68',
`minhealth` = '5406',
`maxhealth` = '5406',
`minmana` = '300',
`maxmana` = '300',
`faction` = '6',
`speed` = '0.01',
`attackpower` = '100',
`baseattacktime` = '1420',
`rangeattacktime` = '1562',
`rangedattackpower` = '100',
`spell1` = '2895',
`ScriptName` = 'generic_creature' WHERE `creature_template`.`entry` =15447 LIMIT 1 ;

/* Earth Elemental Totem (Rank 1)*/
UPDATE `creature_template` SET `minhealth` = '5400',
`maxhealth` = '5400',
`minmana` = '300',
`maxmana` = '300',
`attackpower` = '100',
`baseattacktime` = '1420',
`rangeattacktime` = '1562',
`rangedattackpower` = '100',
`faction` = '116',
`speed` = '0.01',
`spell1` = '40132',
`ScriptName` = 'generic_creature' WHERE `creature_template`.`entry` =15430 LIMIT 1 ;

/*Nature resistance totem Rank 4*/
UPDATE `creature_template` SET `minlevel` = '69',
`maxlevel` = '69',
`minhealth` = '5',
`maxhealth` = '5',
`minmana` = '300',
`maxmana` = '300',
`faction` = '116',
`mindmg` = '121',
`maxdmg` = '156.09',
`attackpower` = '100',
`baseattacktime` = '1410',
`rangeattacktime` = '1551',
`minrangedmg` = '74.448',
`maxrangedmg` = '102.366',
`rangedattackpower` = '100',
`spell1` = '25573',
`ScriptName` = 'generic_creature' WHERE `creature_template`.`entry` =15490 LIMIT 1 ;

/*Tranquil Air totem*/

UPDATE `creature_template` SET `minlevel` = '50',
`maxlevel` = '50',
`minmana` = '300',
`maxmana` = '300',
`faction` = '6',
`attackpower` = '100',
`rangedattackpower` = '100',
`combat_reach` = '2.56',
`spell1` = '25909',
`ScriptName` = 'generic_creature' WHERE `creature_template`.`entry` =15803 LIMIT 1 ;

/* Totem of Wrath*/
UPDATE `creature_template` SET `minlevel` = '50',
`maxlevel` = '50',
`minhealth` = '3543',
`maxhealth` = '3543',
`minmana` = '300',
`maxmana` = '300',
`faction` = '6',
`speed` = '0.01',
`spell1` = '30708',
`ScriptName` = 'generic_creature' WHERE `creature_template`.`entry` =17539 LIMIT 1 ;

/*Earthbind totem*/
UPDATE `creature_template` SET `minlevel` = '70',
`maxlevel` = '70',
`minmana` = '300',
`maxmana` = '300',
`faction` = '1650',
`speed` = '0.01',
`baseattacktime` = '1880',
`rangeattacktime` = '2068',
`rangedattackpower` = '100',
`combat_reach` = '2.56',
`spell1` = '6474',
`ScriptName` = 'generic_creature' WHERE `creature_template`.`entry` =22486 LIMIT 1 ;

/*Healing Stream totem rank 6*/
UPDATE `creature_template` SET `minhealth` = '5',
`maxhealth` = '5',
`minmana` = '300',
`maxmana` = '300',
`faction` = '6',
`rangedattackpower` = '100',
`spell1` = '25566' WHERE `creature_template`.`entry` =15488 LIMIT 1 ;


/****** FINAL FIX try again.******/
UPDATE `creature_template` SET `faction` = '168' WHERE `creature_template`.`entry` =15447 LIMIT 1 ;

UPDATE `creature_template` SET `faction` = '2',
`speed` = '0.01',
`attackpower` = '100',
`baseattacktime` = '1410',
`rangeattacktime` = '1551',
`maxgold` = '25' WHERE `creature_template`.`entry` =15497 LIMIT 1 ;