increased vendor emails length
showing user on tickets assigned
updated sql script