>why is it that mages with this spell up can only see other
>mages aura's? Why can they not see a warriors or paladins even
>a healers?

The spell is called detect magic not detect mana. Paladins and warriors are not magical beings.