pinging on acceleration is because of a way to lean of mixture, it is also harmful for the engine to be so lean.
Intake manifold gaskets/vacuum leaks are the most common reason for PO171/PO174 at the same time
If you have done all you think you could bring it to a shop then.
