The former Hoops striker looked set for a mega money £24million switch to the Bundesliga before they pulled the plug