adding a nic option to the ip resource and fixing comma syntax in mysql