Magnetism in transition metal substituted ZnO