Weiner resigns in wake of sexting scandal