make general advisories view
bugfixes to views
also add type of advisory
fix my insanely bad pun
prevent two advisories from getting the same ID
exclude pending advisories