How much effect does being overweight have on getting bad knees?

A whole lot! Knees are susceptible to wear and tear (as are all joints, weight bearing joints more so than others). Until your knees are bad you can get away with being a bit overweight, but once you develop a problem, you'd better slim down.