Neville was in total disgrace. Professor McGonagall was so furious with him she had banned him from all future Hogsmeade visits, given him a detention, and forbidden anyone to give him the password into the tower. Poor Neville was forced to wait outside the common room every night for somebody to let him in, while the security trolls leered unpleasantly at him.
What really gets me about this scene, is John’s tortured look after Moriarty asks Sherlock whether he thinks the consulting-criminal-thing is brilliant.
He’s checking Sherlock’s face.
“Brilliant” is what John tells Sherlock after his deductions, it’s how John feels about him. And he’s afraid that Sherlock thinks he’s stupid in return. That he’ll call Moriarty brilliant and amazing and everything John secretly wants to hear Sherlock tell HIM. John, with a bomb strapped to his heart, looks up to check if Sherlock thinks Moriarty is brilliant. And Martin Freeman really sells that emotion.