std::ostringstream ss; ss<<"select `minhealth`, `maxhealth`, `minmana`, `maxmana`,`mindmg`, `maxdmg`, `spell1`, `spell2`, `spell3`, `spell4`, from `creature_template` where entry='"<Fetch(); // can have 0 NewSummon->SetHealth(fields[0].GetUInt32()); NewSummon->SetMaxHealth(fields[1].GetUInt32()); NewSummon->SetPower(POWER_MANA, fields[2].GetUInt32()); NewSummon->SetMaxPower(POWER_MANA, fields[3].GetUInt32()); NewSummon->SetFloatValue(UNIT_FIELD_MINDAMAGE, fields[4].GetUInt32()); NewSummon->SetFloatValue(UNIT_FIELD_MAXDAMAGE, fields[5].GetUInt32()); // can't have 0 if(!fields[6].GetUInt32() || fields[6].GetUInt32() != 0) NewSummon->learnSpell(fields[6].GetUInt32()); if(!fields[7].GetUInt32() || fields[7].GetUInt32() != 0) NewSummon->learnSpell(fields[7].GetUInt32()); if(!fields[8].GetUInt32() || fields[8].GetUInt32() != 0) NewSummon->learnSpell(fields[8].GetUInt32()); if(!fields[9].GetUInt32() || fields[9].GetUInt32() != 0) NewSummon->learnSpell(fields[9].GetUInt32());