CMS8 New proc [CMS8_appitemorderbysectiondata1]

CMS8_appitemorderbysectiondata1.sql

This allows you to do ordering of applicationitems, using [sectiondata1] as a 'group'

CMS8 CMS8Config settings

        public static string Websitevirtual = "";
        public static string Websiteroot = "";
        public static long GlobalSiteID = 0;

        public static string Connectionstring = "";
        public static string DevConnectionstring = "";

        public static string Streampath = "";
        public static bool Adminsite = false;
        public static bool Https = false;
        public static bool SingleWebRoot = false;

        public static bool FolderPaths = false;
        public static bool NoHomePath = false;

        public static string LibFolderVRoot = "";
        public static string AssetsFolderVRoot = "";

        public static int Location = 1;
        public static long Site = 0;
        public static string PageExtention = "";
        public static string SearchCatalog = "";
        public static bool UseWindowsSearch = false;

        public static bool IsStagingSite = false;
        public static bool UseRegisteredUsers = false;
        public static string PublicLoginAction = "";
        public static string PublicLogoutAction = "";
        public static string PublicLoginPage = "";
        public static string PublicLogoutPage = "";

        public static string GooglemapsKey = "";
        public static int GoogleVersion = 2;

        public static bool SmtpSSL = true;

        public static string ApplicationVPath = "";

        public static bool UseDevConn = false;
        public static string StagingCacheFolder = "";
        public static string Filetypelist = "rtf|doc|docx|pdf|xls|xlsx|tiff|ppt|pptx|mp3|flv|wmv|wma|mov|mpg|gif|png|jpg|jpeg|vcf|m4a|xml";
        public static string Imagetypelist = "gif|png|jpg|jpeg|swf";
        public static int MaxfilesizeKB = 10000;
        public static int MaximagesizeKB = 1000;
        public static int Thumbwidth = 200;
        public static int Thumbheight = 160;
        public static bool NTLogin = false;
        public static bool Testing = false;
        public static bool UseSchedules = false;
        public static bool UsePublicUsers = false;
        public static bool Testlogging = false;
        public static bool Cachelogging = false;
        public static bool Showbugtracker = false;
        public static bool AllowUTF8Paths = false;
        public static bool SetLowercasePaths = false;
        public static bool SinglePageNav = false;
        public static int Maxnavlevel = 4;
        public static bool InsertTwoVersions = false;
        public static bool ShowStaging = false;
        public static bool ShowTrace = false;
        public static bool UseChromelessPlayer = false;

        public static bool TinyRelativePaths = false;

        public static string Logfolder = "";
        public static string UploadFolder = "";
        public static string LibFolderRoot = "";
        public static string AssetsFolderRoot = "";
        public static string Logouturl = "";
        public static string Loginurl = "";

        public static string PublicCSSPath = "";

        public static string WebmasterEmailAddress = "";
        public static string WebmasterEmailName = "";
        public static string SiteEmailAddress = "";
        public static string SiteEmailName = "";

        public static string VideoPlayerButtonColor = "";

CMS8 - [Requester] versus [RequestHandler]

Requester redirects .htmx pages to ~/ pages with a 301 status code. RequestHandler just serves the corresponding page.

CMS8 New temporary Config attribute [NoHomePath]

 CMS8 New temporary Config attribute [NoHomePath]

Because of the transition from home page children that look like this: /default/sitemap.htmx to this: /sitemap.htmx, i have added a new config key [NoHomePath]. The default is false and when set to true it means that the initial folder (which should be "Default") IS omitted, making the pages in the folder appear to be in the root of the site. There is the possibility of a conflict - since pages within this special folder can clash with other folders names - e.g. a page called "Search" in the home folder would clash with a folder named "Search" if folderpaths were being used.

It is my intention to move all the pages in the home folder on existing sites to the simpler form, then remove the [NoHomePath] attribute, after setting it to be the default behaviour.

CMS8 Added fields

CMS8 Fields added:

CMS8Sites - [folderpaths] int not null default(0) - this is a site-specific field that shows that the site uses a folder versus folder and file based url scheme.

e.g. /news/media.htmx vs /news/media/

CMS8Pages - [description] nvarchar(500) not null default '' - this is for the meta tag "Description"

CMS8Applicationitems - [path] nvarchar(500) not null default '' this is not used yet - but will be to allow application items to be reached by path, for better SEO reasons. e.g. .../?/hamilton-on-pole/ rather than ..?itemid=24353

CMSnodes - [home] int not null default(0) - this is to denote which node in a site is the home page.

userproc3_swappcontentversions

userproc3_swappcontentversions, a new stored procedure, added to the CMS so that content swaps can take place

A typical  usage would be this:

 // Push to live
p.Add("@sourcetype", SqlDbType.Int, 4, ParameterDirection.Input, 2);
p.Add("@sourceid", SqlDbType.Int, 4, ParameterDirection.Input, investmentid);
p.Add("@sourceversion", SqlDbType.Int, 4, ParameterDirection.Input, 3);
p.Add("@targetversion", SqlDbType.Int, 4, ParameterDirection.Input, 1);
outcome = db.ExecProcVoidParams("userproc3_swappcontentversions", p);

What this is doing is copying edit content (sourceversion = 3) to live content (targetversion = 1)

Also:

// Refresh from live
p.Add("@sourcetype", SqlDbType.Int, 4, ParameterDirection.Input, 2);
p.Add("@sourceid", SqlDbType.Int, 4, ParameterDirection.Input, investmentid);
p.Add("@sourceversion", SqlDbType.Int, 4, ParameterDirection.Input, 1);
p.Add("@targetversion", SqlDbType.Int, 4, ParameterDirection.Input, 3);
outcome = db.ExecProcVoidParams("userproc3_swappcontentversions", p);

What this is doing is copying live content (sourceversion = 1) to edit content (targetversion = 3)