What would cause truck to make a clicking sound when trying to crank, has a brand new battery and the cables get real hot

What is your question?

All lights and dash lights come on as normal, just a clicking noise, but won't turn over. It has been sitting for about 2 years. Someone else was driving it and he told me it overheated. I think the water pump went then. also the warning light on the dash says check charging system

What makes this problem better or worse?

nothing is helping

How long has your 2008 Ford Explorer Sport Trac had this problem?

2 years