Fancamps, Fanfests and Ticket Exchange for the World Cup 2014 in Brazil

sorry if these questions have already been answered not always checking the forum! How long does it take from camp site to nearest train station? what is the nearest station called? What time do the pubs open in frankfurt/nuremburg? Will you have an alcoholic counciler avaliable before we leave to g...