document.write("
\n"); document.write(" \n"); document.write(" \n"); document.write(" \n"); document.write("\n"); document.write(" \n"); document.write(" \n"); document.write("\n"); document.write("\n"); document.write("\n"); document.write("\n"); document.write("\n"); document.write("\n"); document.write("\n"); document.write(" \n"); document.write("
\n"); document.write(" 
       \n");
document.write("private <\/span>void<\/span> SetBlogRoot<\/span>(<\/span>)<\/span>\n");
document.write("{\n");
document.write("  if<\/span> (_parentId != -1<\/span>) \n");
document.write("    return<\/span>;\n");
document.write("\n");
document.write("  var sql = "select text, id, path from umbracoNode "<\/span> +\n");
document.write("    "inner join cmsContent on cmsContent.nodeId = umbracoNode.id "<\/span> +\n");
document.write("    "inner join cmsContentType on cmsContentType.nodeId = cmsContent.contentType "<\/span> +\n");
document.write("    "where cmsContentType.alias = \'{0}\' and path not like \'%-20%\' and path like \'%{1}%\' "<\/span> +\n");
document.write("    "order by path"<\/span>;\n");
document.write("\n");
document.write("  var userStartNode = (umbraco.BasePages.UmbracoEnsuredPage.CurrentUser.StartNodeId != -1<\/span>)\n");
document.write("    ? ","<\/span> + umbraco.BasePages.UmbracoEnsuredPage.CurrentUser.StartNodeId + ","<\/span>\n");
document.write("    : umbraco.BasePages.UmbracoEnsuredPage.CurrentUser.StartNodeId + ","<\/span>;\n");
document.write("\n");
document.write("  sql = String.Format(sql, GetBlogDocumentType().Alias,\n");
document.write("                                userStartNode);\n");
document.write("  var reader = umbraco.BusinessLogic.Application.SqlHelper.ExecuteReader(sql);\n");
document.write("\n");
document.write("  while<\/span> (reader.Read())\n");
document.write("  {\n");
document.write("    blogParentDDL.Items.Add( new<\/span> ListItem(reader.GetString("text"<\/span>),\n");
document.write("      reader.GetInt("id"<\/span>).ToString()) );\n");
document.write("  }\n");
document.write("\n");
document.write("  _parentId = Int32.Parse(blogParentDDL.Items[0<\/span>].Value);\n");
document.write("\n");
document.write("}\n");
document.write("<\/pre><\/pre>\n");
document.write("	\n");
document.write("	<\/div>\n");
document.write("\n");
document.write("\n");
document.write("  \n");
document.write("  \n");
document.write("  
\n");
document.write("    
\n");
document.write("      \n");
document.write("      <\/a>\n");
document.write("    <\/div>\n");
document.write("  \n");
document.write("    Pastie #854046<\/a> linked directly from Pastie<\/a>.\n");
document.write("  <\/div><\/div>");