added more & updated sql and templates to /extra
changed http:// to https:// in snc template