Footy star goes from hero to zero over pub fight