red wine storage

How long is wine good after opening? Red 3–5 days, light white and rosé 5–7, sparkling 1–3, Port 28. Plus how to spot bad wine and recork it.