auto assignment module, confirmation url, database query fixes