# MODx Database Script for New/Upgrade Installations # # Each sql command is separated by double lines # # Dumping data for table `keyword_xref` # REPLACE INTO `{PREFIX}keyword_xref` VALUES ('3','1'); REPLACE INTO `{PREFIX}keyword_xref` VALUES ('4','1'); # # Dumping data for table `documentgroup_names` # REPLACE INTO `{PREFIX}document_groups` VALUES ('1','1','3'); REPLACE INTO `{PREFIX}documentgroup_names` VALUES ('1','Site Admin Pages','0','0'); # # Dumping data for table `site_content` # REPLACE INTO `{PREFIX}site_content` VALUES (1, 'document', 'text/html', 'Home', 'Welcome to MODx', 'Introduction to MODx', 'index', '', 1, 0, 0, 0, 0, 'Create and do amazing things with MODx', '

Install Successful!

\r\n

You have successfully installed and configured MODx. We hope you find this site an adequate starting configuration for many small business, organization or personal websites; just change the template and content, and you''ll be good to go! This site is preconfigured with a variety of options we hope are helpful, relevant and just plain cool for many marketing or personal sites:

\r\n\r\n

To log into the MODx Control Panel and start customizing this site, point your browser to [(site_url)]manager/.

', 1, 4, 1, 1, 1, 1, 1144904400, 1, 1160262629, 0, 0, 0, 0, 0, 'Home', 0, 0, 0, 0, 0, 0, 0); REPLACE INTO `{PREFIX}site_content` VALUES (2, 'document', 'text/html', 'Blog', 'My Blog', '', 'blog', '', 1, 0, 0, 0, 1, '', '[[Ditto? &startID=`2` &summarize=`2` &removeChunk=`Comments` &tpl=`ditto_blog` &paginate=`1` &extenders=`summary,dateFilter` &paginateAlwaysShowLinks=`1` &tagData=`documentTags`]]\r\n\r\n

Showing [+start+] - [+stop+] of [+total+] Articles

\r\n\r\n
[+previous+] [+pages+] [+next+]
\r\n\r\n
 
\r\n\r\n[[Reflect? &dittoSnippetParameters=`startID:2` &groupByYears=`0` &showItems=0` &tplMonth=`reflect_month_tpl`]]', 1, 4, 2, 0, 0, 1, 1144904400, 1, 1159818696, 0, 0, 0, 0, 0, 'Blog', 0, 0, 0, 0, 0, 0, 0); REPLACE INTO `{PREFIX}site_content` VALUES (3, 'document', 'text/html', 'Add a Blog Entry', 'Add a Blog Entry', '', 'add-a-blog-entry', '', 1, 0, 0, 2, 0, '', '[!NewsPublisher? &folder=`2` &canpost=`Site Admins` &formtpl=`FormBlog` &footertpl=`Comments` &makefolder=`1` &rtcontent=`tvblogContent`!]', 0, 4, 2, 0, 0, 1, 1144904400, 3, 1144904400, 0, 0, 0, 0, 0, 'Add Blog Entry', 1, 0, 0, 1, 0, 0, 0); REPLACE INTO `{PREFIX}site_content` VALUES (4, 'document', 'text/html', '[*loginName*]', 'Login to Enable to Comments', '', 'login', '', 1, 0, 0, 0, 0, '', '

In order to comment on blog entries, you must be a registered user of [(site_name)]. If you haven''t already registered, you can request an account.

\r\n
[!WebLogin? &tpl=`FormLogin` &loginhomeid=`2`!]
', 1, 4, 11, 0, 0, 1, 1144904400, 1, 1144904400, 0, 0, 0, 0, 0, '[*loginName*]', 0, 0, 0, 0, 0, 0, 1); REPLACE INTO `{PREFIX}site_content` VALUES (5, 'document', 'text/html', 'Request an Account', 'Sign Up for Full Site Privileges', '', 'request-an-account', '', 1, 0, 0, 0, 0, '', '[[WebSignup? &tpl=`FormSignup` &groups=`Registered Users`]]', 1, 4, 3, 0, 0, 1, 1144904400, 1, 1158320704, 0, 0, 0, 0, 0, '', 0, 0, 0, 0, 0, 0, 1); REPLACE INTO `{PREFIX}site_content` VALUES (6, 'document', 'text/html', 'Contact Us', 'Contact [(site_name)]', '', 'contact-us', '', 1, 0, 0, 0, 0, '', '[!eForm? &formid=`ContactForm` &subject=`[+subject+]` &to=`[(email_sender)]` &ccsender=`1` &tpl=`ContactForm` &report=`ContactFormReport` &invalidClass=`invalidValue` &requiredClass=`requiredValue` &cssStyle=`ContactStyles` &gotoid=`46` !]\r\n', 0, 4, 14, 1, 0, 1, 1144904400, 1, 1159303922, 0, 0, 0, 0, 0, 'Contact us', 0, 0, 0, 0, 0, 0, 0); REPLACE INTO `{PREFIX}site_content` VALUES (7, 'document', 'text/html', '404 - Document Not Found', 'Uh oh ... it''s a 404! (Page Not Found)', '', 'doc-not-found', '', 1, 0, 0, 0, 0, '', '

Looks like you tried to go somewhere that does not exist... perhaps you need to login or you''d like one of the following pages instead:

\r\n\r\n[[Wayfinder? &startId=`0` &showDescription=`1`]]\r\n\r\n

Want to find it the old fashioned way? Use the site search at the top of this site to find what you seek.

\r\n\r\n', 1, 4, 4, 0, 1, 1, 1144904400, 1, 1159301173, 0, 0, 0, 0, 0, '', 0, 0, 0, 0, 0, 0, 1); REPLACE INTO `{PREFIX}site_content` VALUES (8, 'document', 'text/html', 'Search Results', 'Your Search Results', '', 'search-results', '', 1, 0, 0, 0, 0, '', '[!AjaxSearch? &AS_showForm=`0` &ajaxSearch=`0`!]', 0, 4, 5, 0, 0, 1, 1144904400, 1, 1158613055, 0, 0, 0, 0, 0, '', 1, 0, 0, 0, 0, 0, 1); REPLACE INTO `{PREFIX}site_content` VALUES (9, 'document', 'text/html', 'Mini-Blog HOWTO', 'How to Start Posting with MODx Mini-Blogs', '', 'article-1126081344', '', 1, 0, 0, 2, 1, '', '

Setting up a mini-blog is relatively simple. Here''s what you need to do to get started with making new posts:

\r\n
    \r\n
  1. Login to the MODx Control Panel.
  2. \r\n
  3. Create a new Webuser by clicking the Users > Manage web users link.
  4. \r\n
  5. Make sure to check the Site Admins Webuser Group at the bottom of the page.
  6. \r\n \r\n
  7. Go to the login page and login using this newly created Webuser information.
  8. \r\n
  9. You should now notice a new Add a Blog Entry menu item that automatically appeared under the Blog Page link in the right column.
  10. \r\n
\r\n{{Comments}}', 1, 4, 0, 1, 1, -1, 1144904400, 1, 1160171764, 0, 0, 0, 0, 0, '', 0, 0, 0, 0, 0, 0, 1); REPLACE INTO `{PREFIX}site_content` VALUES (11, 'document', 'text/xml', 'RSS Feed', '[(site_name)] RSS Feed', '', 'feed.rss', '', 1, 0, 0, 0, 0, '', '[[Ditto? &startID=`2` &format=`rss` &summarize=`20` &total=`20` &commentschunk=`Comments`]]', 0, 0, 6, 0, 0, 1, 1144904400, 1, 1160062859, 0, 0, 0, 0, 0, '', 0, 0, 0, 0, 0, 0, 1); REPLACE INTO `{PREFIX}site_content` VALUES (14, 'document', 'text/html', 'Content Management', 'Ways to manage content', '', 'cms', '', 1, 0, 0, 15, 0, '', '

Manage your content in the backend

\r\n

The Manager is a skinnable feature-packed tool for admin users. You can add extra users and limit what functions they can access. MODx''s Manager makes creating content and managing templates and reusable elements easy. Modules can be added to work with other datasets or make management tasks easier.

\r\n

Manage your content in the frontend

\r\n

The QuickEdit bar lets manager users edit content whilst browsing the site. Most content fields and template variables can be edited quickly and easily.

\r\n

Enable web users to add content

\r\n

Custom data entry is easy to code using the MODx API - so you can design forms and collect whatever information you need.

', 0, 4, 3, 1, 1, 1, 1144904400, 1, 1158331927, 0, 0, 0, 0, 0, 'Manage Content', 0, 0, 0, 0, 0, 0, 0); REPLACE INTO `{PREFIX}site_content` VALUES (15, 'document', 'text/html', 'MODx Features', 'MODx Features', '', 'features', '', 1, 0, 0, 0, 1, '', '[!Wayfinder?startId=`[*id*]` &outerClass=`topnav`!]', 1, 4, 7, 1, 1, 1, 1144904400, 1, 1158452722, 0, 0, 0, 1144777367, 1, 'Features', 0, 0, 0, 0, 0, 0, 0); REPLACE INTO `{PREFIX}site_content` VALUES (16, 'document', 'text/html', 'Ajax', 'Ajax and Web 2.0 ready', '', 'ajax', '', 1, 1159264800, 0, 15, 0, '', 'Ajax ready out-of-the-box\r\n

MODx empowers users to build engaging sites today, with its pre-integrated Mootools javascript library.

\r\n\r\n

Check out the Ajax-powered search in this example site. The libraries are also used with QuickEdit, our front-end editing tool.

\r\n\r\n

Smart integration means the scripts are only included in the document head when needed - no unnecessary bloat on simple pages!

\r\n\r\nWeb 2.0 today\r\n

MODx makes child''s play of building content managed sites with validating, accessible CSS layouts - so web standards compliance is easy. (You can create a site with excessively nested tables too, if you really want to).

\r\n', 1, 4, 1, 1, 1, 1, 1144904400, 1, 1159307504, 0, 0, 0, 0, 0, 'Ajax', 0, 0, 0, 0, 0, 0, 0); REPLACE INTO `{PREFIX}site_content` VALUES (18, 'document', 'text/html', 'Just a pretend, older post', 'This post should in fact be archived', '', 'article-1128398162', '', 1, 0, 0, 2, 0, '', '

Not so exciting, after all, eh?

\r\n', 1, 4, 2, 1, 1, -1, 1144904400, 1, 1159306886, 0, 0, 0, 0, 0, '', 0, 0, 0, 0, 0, 0, 1); REPLACE INTO `{PREFIX}site_content` VALUES (22, 'document', 'text/html', 'Menus and Lists', 'Flexible Menus and Lists', '', 'menus', '', 1, 1159178400, 0, 15, 0, '', '

Your documents - listed how you want them

\r\n

MODx''s document data structure has been designed to allow many different routines to redisplay the information in ways that suit your needs, such as a dynamic menu in your template.

\r\n

Since the last release of MODx, the community has produced many great snippets - reusable functions that you can call in your content or template. Two of the most widely useful are Ditto and Wayfinder.

\r\n

Wayfinder - the menu builder

\r\n

Allows you to template every part of the menu. On this site, Wayfinder is being used to generate the drop-down menus, but many types of menus and sitemaps are possible. Wayfinder updates and support.

\r\n

Ditto - the document lister

\r\n

Uses include listing the most recent blog posts, producing a site map, listing related documents (using a TV filter) and generating an RSS feed. You could even write a menu with it. On this site, Ditto is being used for the blog posts list on the Blog page, and the list on the right of some templates. Ditto updates and support.

\r\n

Unlimited Customization

\r\n

If you can''t quite get your desired effect using templating and the many options of Ditto and Wayfinder, you can write your own routine, or look for other snippets in the MODx repository. MODx''s fields for Menu Title, summaries, menu position etc can be used via the API to produce anything you can imagine.

', 1, 4, 2, 1, 1, 1, 1144904400, 1, 1160148522, 0, 0, 0, 0, 0, 'Menus and Lists', 0, 0, 0, 0, 0, 0, 0); REPLACE INTO `{PREFIX}site_content` VALUES (24, 'document', 'text/html', 'Extendable by design', 'Extendable by design', '', 'extendable', '', 1, 1159092732, 0, 15, 0, '', '

The MODx community has created many add-ons which can be found in the Repository, from image galleries and e-commerce to smaller utilities.

\r\n\r\n

Template Variables with Bindings

\r\n

TVs - Template Variables - are powerful extra fields that you can use with your documents. As an example of an advanced template element that returns a different thing dependent on code or data, we created an @BINDING for the name of the Login menu item. This changes the menu name from Login to Logout based on your logged in state. The @BINDING as follows was placed in the default value as:\r\n@EVAL if ($modx->getLoginUserID()) return ''Logout''; else return ''Login'';

\r\n\r\n

Using Scriptaculous

\r\n

We used some simple effects to highlight various things on the front/home page to demonstrate how easy it is to create a useful way to draw attention to things. To see them in action on the home page, click the Integrated Site Search, Related Links or Newest Documents headers.

\r\n\r\n

Custom Forms

\r\n

To demonstrate how to link to custom forms, we customized the calls to the Webuser Registration system and the Login system.

\r\n\r\n

And more

\r\n

Rich Text Editor for blog entries. To make it easier to format blog posts with simple text formatting, we modified the blog to use a custom RTE-enabled Template Variable (TV).

\r\n\r\n

Smart-Summary logic. When splitting the full blog/news posts you simply insert a "<!-- splitter -->" where you want the break to occur. In addition, if that leaves any important tags open, it will try to match them and close them so it doesn''t mess up your site layout with unclosed OL, UL or DIV tags.

', 1, 4, 4, 1, 1, 2, 1144904400, 1, 1159309971, 0, 0, 0, 0, 0, 'Extendability', 0, 0, 0, 0, 0, 0, 0); REPLACE INTO `{PREFIX}site_content` VALUES (32, 'document', 'text/html', 'Design', 'Site Design', '', 'design', '', 1, 0, 0, 0, 0, '', '

Credits

\r\n

The default site''s themes are based off of validating XHTML/CSS designs by Andreas Viklund, ziworks | Web Solutions and MODxHost. \r\n\r\n

Style examples

\r\n

This page was created to show some of the styles built into this template. It also shows the alternative content page layout, where the left sidebar has been removed to let the content fill the entire width of the layout.

\r\n

Style List (show/hide)

\r\n', 1, 4, 10, 1, 1, 2, 1144904400, 1, 1160112322, 0, 0, 0, 1144912754, 1, 'Design', 0, 0, 0, 0, 0, 0, 0); REPLACE INTO `{PREFIX}site_content` VALUES (33, 'document', 'text/html', 'Getting Help', 'Getting Help with MODx', '', 'geting-help', '', 1, 0, 0, 0, 0, '', '

The team behind MODx strives to constantly add to and refine the documentation to help you get up to speed with MODx:

\r\n\r\n\r\n

And don''t forget, you can always learn and ask questions at the MODx forums. \r\n', 1, 4, 8, 1, 1, 2, 1144904400, 2, 1144904400, 0, 0, 0, 0, 0, 'Getting Help', 0, 0, 0, 0, 0, 0, 0); REPLACE INTO `{PREFIX}site_content` VALUES (37, 'document', 'text/html', '[*loginName*]', 'The page you''re trying to reach requires a login', '', 'blog-login', '', 1, 0, 0, 0, 0, '', '

In order to add a blog entry, you must be logged in as a Site Admin webuser. Also, commenting on posts requires a login. Contact the site owner for permissions to create new post, or create a web user account to automatically receive commenting privileges. If you already have an account, please login below.

\r\n\r\n[!WebLogin? &tpl=`FormLogin` &loginhomeid=`3`!]', 1, 4, 12, 0, 0, 1, 1144904400, 1, 1158599931, 0, 0, 0, 0, 0, '', 0, 0, 0, 0, 0, 0, 1); REPLACE INTO `{PREFIX}site_content` VALUES (39, 'document', 'text/html', 'Template Examples', 'Templates', 'Templates', 'templates', '', 1, 0, 0, 0, 1, '', '

This page provides a simple way to explore alternate layouts and stylesheets. To change the overall template, use the first set of links. To alter the stylesheets, use the second set of options.

\r\n\r\n

Change Layout Templates:

\r\n[!Wayfinder?startId=`[*id*]` &outerClass=`topnav`!]
\r\n\r\n

Switch CSS Themes:

\r\n{{styles}}', 1, 4, 9, 1, 0, 1, 1144904400, 1, 1159978559, 0, 0, 0, 1144628721, 1, 'Templates', 0, 0, 0, 0, 0, 0, 0); REPLACE INTO `{PREFIX}site_content` VALUES (42, 'document', 'text/html', 'MODxCSS Wide', 'MODxCSS Wide', 'MODxCSS Wide', 'modxcss_wide', '', 1, 0, 0, 39, 0, '', '

This page provides a simple way to explore alternate layouts and stylesheets. To change the overall template, use the first set of links. To alter the stylesheets, use the second set of options.

\r\n\r\n

Change Layout Templates:

\r\n[!Wayfinder?startId=`[*parent*]` &outerClass=`topnav`!]
\r\n\r\n

Switch CSS Themes:

\r\n{{styles}}', 1, 3, 9, 1, 0, 1, 1144904400, 1, 1159978559, 0, 0, 0, 1144628721, 1, 'MODxCSS Wide', 0, 0, 0, 0, 0, 0, 0); REPLACE INTO `{PREFIX}site_content` VALUES (43, 'document', 'text/html', 'MODxCSS', 'MODxCSS', 'MODxCSS', 'modxcss', '', 1, 0, 0, 39, 0, '', '

This page provides a simple way to explore alternate layouts and stylesheets. To change the overall template, use the first set of links. To alter the stylesheets, use the second set of options.

\r\n\r\n

Change Layout Templates:

\r\n[!Wayfinder?startId=`[*parent*]` &outerClass=`topnav`!]
\r\n\r\n

Switch CSS Themes:

\r\n{{styles}}', 1, 1, 9, 1, 0, 1, 1144904400, 1, 1159978559, 0, 0, 0, 1144628721, 1, 'MODxCSS', 0, 0, 0, 0, 0, 0, 0); REPLACE INTO `{PREFIX}site_content` VALUES (44, 'reference', 'text/html', 'MODxHost', 'MODxHost', 'MODxHost', 'modxhost_tpl', '', 1, 0, 0, 39, 0, '', 'index.php?id=39', 0, 0, 1, 1, 0, 1, 1144904400, 1, 1158505455, 0, 0, 0, 1144967650, 1, 'MODxHost', 0, 0, 0, 0, 0, 0, 0); REPLACE INTO `{PREFIX}site_content` VALUES (46, 'document', 'text/html', 'Thank You', '', '', 'thank-you', '', 1, 0, 0, 0, 0, '', '

Thank You!

\r\n

We do appreciate your feedback. Your comments have been submitted to our office and hopefully someone will bother to actually read it. You should also receive a copy of the message in your inbox.

\r\n

Please be assured that we will do our best not to ignore you, but if today''s a Monday please try again in a few days.

\r\n', 1, 4, 13, 1, 1, 1, 1159302141, 1, 1159302892, 0, 0, 0, 1159302182, 1, '', 0, 0, 0, 0, 0, 0, 1); # # Dumping data for table `site_htmlsnippets` # REPLACE INTO `{PREFIX}site_htmlsnippets` VALUES (1, 'WebLoginSideBar', 'WebLogin Sidebar Template', 0, 2, 0, ' \r\n\r\n
\r\n \r\n\r\n\r\n\r\n\r\n
\r\n\r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n
User:
Password:
\r\n \r\n \r\n \r\n \r\n \r\n
\r\n
\r\n
Forget Password?
\r\n
\r\n
\r\n
\r\n\r\n[+logouttext+]\r\n
\r\n\r\n
\r\n\r\n\r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n
Enter the email address of your account
below to receive your password:
\r\n
\r\n
\r\n\r\n', 0); REPLACE INTO `{PREFIX}site_htmlsnippets` VALUES (2, 'FormBlog', 'Input Form for creating new blog entries', 0, 3, 0, '
\r\n
\r\n

Publishing Details

\r\n

Note: Leaving the Publish Date empty will immediately publish your blog entry.

\r\n \r\n
\r\n
\r\n\r\n \r\n
\r\n \r\n
\r\n

The Content

\r\n

The Summary field is optional, but is used as a short version for RSS feeds and summary views on the main blog page.

\r\n
\r\n \r\n
\r\n \r\n
\r\n

You''re Done

\r\n \r\n \r\n
\r\n
\r\n\r\n', 0); REPLACE INTO `{PREFIX}site_htmlsnippets` VALUES (3, 'FormLogin', 'Custom login form for Weblogins', 0, 2, 0, ' \r\n\r\n
\r\n \r\n
\r\n

Your Login Details

\r\n \r\n \r\n \r\n \r\n Forget Your Password?\r\n
\r\n
\r\n
\r\n\r\n

You''re already logged in

\r\nDo you wish to [+logouttext+]?\r\n
\r\n\r\n
\r\n
\r\n

It happens to everyone...

\r\n \r\n \r\n \r\n \r\n
\r\n
\r\n', 0); REPLACE INTO `{PREFIX}site_htmlsnippets` VALUES (4, 'FormSignup', 'For the weblogin signup', 0, 2, 0, ' \r\n\r\n
\r\n
\r\n

User Details

\r\n

Items marked by * are required

\r\n \r\n \r\n \r\n
\r\n \r\n
\r\n

Password

\r\n \r\n \r\n
\r\n \r\n
\r\n

Optional Account Profile Info

\r\n \r\n \r\n
\r\n \r\n
\r\n

Bot-Patrol

\r\n

Enter the word/number combination shown in the image below.

\r\n \r\n \"If\r\n
\r\n \r\n
\r\n \r\n
\r\n
\r\n\r\n\r\n
\r\n\r\n

Signup completed successfully!
\r\nYour account was created. A copy of your signup information was sent to your email address.

\r\n', 0); REPLACE INTO `{PREFIX}site_htmlsnippets` VALUES (5, 'FormBlogComments', 'Comment to show up beneath a blog for registered user comments', 0, 3, 0, '\r\n

Enter your comments in the space below (registered site users only):

\r\n[!UserComments? &canpost=`Registered Users, Site Admins` &makefolder=`0` &postcss=`comment` &titlecss=`commentTitle` &numbercss=`commentNum` &altrowcss=`commentAlt` &authorcss=`commentAuthor` &ownercss=`commentMe` &sortorder=`0`!]', 0); REPLACE INTO `{PREFIX}site_htmlsnippets` VALUES (6, 'nl_sidebar', 'Default Template TPL for Ditto', 0, 3, 0, '[+title+]
\r\n[+longtitle+]

', 0); REPLACE INTO `{PREFIX}site_htmlsnippets` VALUES (7, 'styles', 'Stylesheet switcher list', 0, 1, 0, '
The CSS Themes can only be used on the MODxCSS and MODxCSSW Layouts
\r\n\r\n', 0); REPLACE INTO `{PREFIX}site_htmlsnippets` VALUES (8, 'ditto_blog', 'Blog Template', 0, 3, 0, '
\r\n\

[+title+]

\r\n
By [+author+] on [+date+]. Comments\r\n ([!Jot?&docid=`[+id+]`&action=`count-comments`!])
Tags: [+tagLinks+]
\r\n [+summary+]\r\n \r\n
', 0); REPLACE INTO `{PREFIX}site_htmlsnippets` VALUES (9, 'footer', 'Site Template Footer', 0, 1, 0, '[(site_name)] is powered by MODx CMS |\r\n Design by Andreas Viklund\r\n\r\n\r\n\r\n\r\n
MODx - The XHTML, CSS and Ajax CMS and PHP Application Framework
', 0); REPLACE INTO `{PREFIX}site_htmlsnippets` VALUES (10, 'meta', 'Site Template Meta', 0, 1, 0, '

Valid XHTML

Valid css

MODx

', 0); REPLACE INTO `{PREFIX}site_htmlsnippets` VALUES (11, 'mh.InnerRowTpl', 'Inner row template for ModxHost top menu', 0, 8, 0, '[+wf.linktext+][+wf.wrapper+]', 0); REPLACE INTO `{PREFIX}site_htmlsnippets` VALUES (12, 'mh.InnerTpl', 'Inner nesting template for ModxHost top menu', 0, 8, 0, '', 0); REPLACE INTO `{PREFIX}site_htmlsnippets` VALUES (13, 'mh.OuterTpl', 'Outer nesting template for ModxHost top menu', 0, 8, 0, ' ', 0); REPLACE INTO `{PREFIX}site_htmlsnippets` VALUES (14, 'mh.RowTpl', 'Row template for ModxHost top menu', 0, 8, 0, '
  • [+wf.linktext+][+wf.wrapper+]
  • ', 0); REPLACE INTO `{PREFIX}site_htmlsnippets` VALUES (15, 'Comments', 'Comments (Jot) showing beneath a blog entry.', 0, 3, 0, '
    \r\n[!Jot? &customfields=`name,email` &subscribe=`1` &pagination=`4` &badwords=`dotNet` &canmoderate=`Site Admins` !]\r\n
    ', 0); REPLACE INTO `{PREFIX}site_htmlsnippets` VALUES (16, 'ContactForm', '', 0, 5, 0, '

    [+validationmessage+]

    \r\n\r\n
    \r\n\r\n
    \r\n

    Contact Form

    \r\n\r\n \r\n\r\n \r\n\r\n \r\n\r\n \r\n \r\n\r\n \r\n\r\n \r\n\r\n
    \r\n\r\n
    \r\n', 0); REPLACE INTO `{PREFIX}site_htmlsnippets` VALUES (17, 'ContactFormReport', '', 0, 5, 0, '

    This is a response sent by [+name+] using the feedback form on the website. The details of the message follow below:

    \r\n\r\n\r\n

    Name: [+name+]

    \r\n

    Email: [+email+]

    \r\n

    Regarding: [+subject+]

    \r\n

    comments:
    [+message+]

    \r\n\r\n

    You can use this link to reply: [+email+]

    \r\n', 0); REPLACE INTO `{PREFIX}site_htmlsnippets` VALUES (18, 'reflect_month_tpl', 'For the yearly archive. Use with Ditto.', 0, 3, 0, '[+month+] [+year+]', 0); REPLACE INTO `{PREFIX}site_htmlsnippets` VALUES (19, 'ContactStyles', 'Styles for form validation', 0, 5, 0, '', 0); # # Dumping data for table `site_keywords` # REPLACE INTO `{PREFIX}site_keywords` VALUES ('1','MODx'); REPLACE INTO `{PREFIX}site_keywords` VALUES ('2','content management system'); REPLACE INTO `{PREFIX}site_keywords` VALUES ('3','Front End Editing'); REPLACE INTO `{PREFIX}site_keywords` VALUES ('4','login'); # # Dumping data for table `site_templates` # REPLACE INTO `{PREFIX}site_templates` VALUES ('1','MODxCSS','MODx CSS template','0','1','','0','\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n[(site_name)] | [*pagetitle*]\r\n\r\n\r\n\r\n\r\n\r\n
    \r\n
    \r\n
    \r\n

    [(site_name)]

    \r\n

    {{slogan}}

    \r\n
    \r\n

    Main menu

    \r\n
    [!Wayfinder?startId=`0` &hereClass=`current` &level=`1` &outerClass=`topnav`!]
    \r\n
    \r\n
    \r\n
    \r\n
    \r\n

    Menu

    \r\n [!Wayfinder?startId=`0` &hereClass=`` &selfClass=`current` &outerClass=`sidemenu`!]\r\n
    \r\n

    Search

    \r\n [[AjaxSearch? &AS_landing=`8` &moreResultsPage=`8` &showMoreResults=`1` &addJscript=`0` &extract=`0` &AS_showResults=`0`]]\r\n

    News

    \r\n [[Ditto? &startID=`2` &summarize=`1` &total=`1` &commentschunk=`Comments` &tpl=`nl_sidebar` &showarch=`0` &truncLen=`100` &truncSplit=`0`]]\r\n

    Login

    \r\n
    [!WebLogin? &tpl=`FormLogin` &loginhomeid=`[(site_start)]`!]
    \r\n

    Styles

    \r\n {{styles}}
    \r\n
    \r\n

    [*longtitle*]

    \r\n [*#content*]
    \r\n
    \r\n

    {{footer}}

    \r\n

    MySQL: [^qt^], [^q^] request(s), PHP: [^p^], total: [^t^], document retrieved\r\n from [^s^].

    \r\n
    \r\n
    \r\n\r\n\r\n','0'); REPLACE INTO `{PREFIX}site_templates` VALUES ('3','MODxCSS Wide','Wide Template','0','1','','0','\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n[(site_name)] | [*pagetitle*]\r\n\r\n\r\n\r\n\r\n\r\n
    \r\n
    \r\n
    \r\n

    [(site_name)]

    \r\n

    {{slogan}}

    \r\n
    \r\n

    Main menu

    \r\n
    [!Wayfinder?startId=`0` &hereClass=`current` &level=`1` &outerClass=`topnav`!]
    \r\n
    \r\n
    \r\n
    \r\n

    [*longtitle*]

    \r\n [*#content*]
    \r\n
    \r\n

    {{footer}}

    \r\n

    MySQL: [^qt^], [^q^] request(s), PHP: [^p^], total: [^t^], document retrieved\r\n from [^s^].

    \r\n
    \r\n
    \r\n\r\n\r\n','0'); REPLACE INTO `{PREFIX}site_templates` VALUES ('4','MODxHost','MODxHost Template','0','1','','0','\r\n\r\n\r\n\r\n [(site_name)] | [*pagetitle*]\r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n\r\n\r\n\r\n
    \r\n
    \r\n
    \r\n
    \r\n
    \r\n
    \r\n

    [(site_name)]

    \r\n
    \r\n

    News:

    \r\n [[Ditto? &startID=`2` &summarize=`2` &total=`20` &commentschunk=`Comments` &tpl=`nl_sidebar` &showarch=`0` &truncLen=`100` &truncSplit=`0`]]\r\n
    \r\n

    Most Recent:

    \r\n [[ListIndexer?LIn_root=0]]
    \r\n

    Login:

    \r\n
    [!WebLogin? &tpl=`FormLogin` &loginhomeid=`[(site_start)]`!]
    \r\n

    Meta:

    \r\n

    Valid XHTML

    \r\n

    Valid css

    \r\n

    MODx

    \r\n
    \r\n \r\n
    \r\n \r\n
    \r\n \r\n
    \r\n
    \r\n
    \r\n
    \r\n

    [*longtitle*]

    \r\n [*#content*]
    \r\n \r\n
    \r\n \r\n
    \r\n \r\n
    \r\n \r\n
    \r\n \r\n
    \r\n
    \r\n

    [(site_name)]

    \r\n
    SEARCH[!AjaxSearch? ajaxSearch=`1` &AS_landing=`8` &moreResultsPage=`8` &showMoreResults=`1` &addJscript=`0` &extract=`0` &AS_showResults=`0`!]
    \r\n
    [[Wayfinder?startId=`0` &outerTpl=`mh.OuterTpl` &innerTpl=`mh.InnerTpl` &rowTpl=`mh.RowTpl` &innerRowTpl=`mh.InnerRowTpl` &firstClass=`first` &hereClass=``]]
    \r\n \r\n
    \r\n \r\n
    \r\n
    \r\n

    Powered\r\n by MODx  Template © 2006\r\n modXhost.com
    \r\n MySQL: [^qt^], [^q^] request(s), PHP: [^p^], total: [^t^], document retrieved\r\n from [^s^].

    \r\n
    \r\n \r\n
    \r\n \r\n
    \r\n\r\n\r\n','0'); REPLACE INTO `{PREFIX}site_templates` VALUES ('5','MODxHostWithComments','MODxHost Template with comments','0','3','','0','\r\n\r\n\r\n\r\n [(site_name)] | [*pagetitle*]\r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n\r\n\r\n\r\n\r\n
    \r\n
    \r\n
    \r\n
    \r\n
    \r\n
    \r\n

    [(site_name)]

    \r\n
    \r\n

    News:

    \r\n [[Ditto? &startID=`2` &summarize=`2` &total=`20` &commentschunk=`Comments` &tpl=`nl_sidebar` &showarch=`0` &truncLen=`100` &truncSplit=`0`]]\r\n
    \r\n

    Most Recent:

    \r\n [[ListIndexer?LIn_root=0]]
    \r\n

    Login:

    \r\n
    [!WebLogin? &tpl=`FormLogin` &loginhomeid=`[(site_start)]`!]
    \r\n

    Meta:

    \r\n

    Valid XHTML

    \r\n

    Valid css

    \r\n

    MODx

    \r\n
    \r\n \r\n
    \r\n \r\n
    \r\n \r\n
    \r\n
    \r\n
    \r\n
    \r\n

    [*longtitle*]

    \r\n [*#content*]\r\n
    \r\n \r\n[!Jot? &customfields=`name,email` &subscribe=`1` &pagination=`10`!]\r\n
    \r\n \r\n
    \r\n \r\n
    \r\n \r\n
    \r\n \r\n
    \r\n
    \r\n

    [(site_name)]

    \r\n
    SEARCH[!AjaxSearch? ajaxSearch=`1` &AS_landing=`8` &moreResultsPage=`8` &showMoreResults=`1` &addJscript=`0` &extract=`0` &AS_showResults=`0`!]
    \r\n
    [[Wayfinder?startId=`0` &outerTpl=`mh.OuterTpl` &innerTpl=`mh.InnerTpl` &rowTpl=`mh.RowTpl` &innerRowTpl=`mh.InnerRowTpl` &firstClass=`first` &hereClass=``]]
    \r\n \r\n
    \r\n \r\n
    \r\n
    \r\n

    Powered\r\n by MODx  Template © 2006\r\n modXhost.com
    \r\n MySQL: [^qt^], [^q^] request(s), PHP: [^p^], total: [^t^], document retrieved\r\n from [^s^].

    \r\n
    \r\n \r\n
    \r\n \r\n
    \r\n\r\n\r\n','0'); # # Dumping data for table `site_tmplvars` # REPLACE INTO `{PREFIX}site_tmplvars` VALUES ('1','richtext','blogContent','blogContent','RTE for the new blog entries','0','0','0','','0','richtext','&w=383px&h=450px&edt=TinyMCE',''); REPLACE INTO `{PREFIX}site_tmplvars` VALUES ('2','text','loginName','loginName','Conditional name for the Login menu item','0','0','0','','0','','','@EVAL if ($modx->getLoginUserID()) return \'Logout\'; else return \'Login\';'); REPLACE INTO `{PREFIX}site_tmplvars` VALUES ('3','text','documentTags','Tags','Space delimited tags for the current document','0','3','0','','0','','',''); # # Dumping data for table `modx2352_site_tmplvar_contentvalues` # REPLACE INTO `{PREFIX}site_tmplvar_contentvalues` VALUES ('1','3','9','demo miniblog howto tutorial posting'); REPLACE INTO `{PREFIX}site_tmplvar_contentvalues` VALUES ('2','3','18','demo older posting'); # # Dumping data for table `site_tmplvar_templates` # REPLACE INTO `{PREFIX}site_tmplvar_templates` VALUES ('1','1','1'); REPLACE INTO `{PREFIX}site_tmplvar_templates` VALUES ('1','3','2'); REPLACE INTO `{PREFIX}site_tmplvar_templates` VALUES ('1','4','3'); REPLACE INTO `{PREFIX}site_tmplvar_templates` VALUES ('2','1','1'); REPLACE INTO `{PREFIX}site_tmplvar_templates` VALUES ('2','3','2'); REPLACE INTO `{PREFIX}site_tmplvar_templates` VALUES ('2','4','3'); REPLACE INTO `{PREFIX}site_tmplvar_templates` VALUES ('3','3','0'); REPLACE INTO `{PREFIX}site_tmplvar_templates` VALUES ('3','4','0'); REPLACE INTO `{PREFIX}site_tmplvar_templates` VALUES ('3','1','0'); REPLACE INTO `{PREFIX}site_tmplvar_templates` VALUES ('3','5','0'); # # Dumping data for table `system_settings` # REPLACE INTO `{PREFIX}system_settings` VALUES('error_page', '7'); REPLACE INTO `{PREFIX}system_settings` VALUES('unauthorized_page', '4'); # # Dumping data for table `web_groups` # REPLACE INTO `{PREFIX}web_groups` VALUES ('1','1','1'); # # Dumping data for table `web_user_attributes` # REPLACE INTO `{PREFIX}web_user_attributes` VALUES ('1','1','Site Admin','0','you@yourdomain.com','','','0','0','0','25','1129049624','1129063123','0','f426f3209310abfddf2ee00e929774b4','0','0','','','','','',''); # # Dumping data for table `web_users` # REPLACE INTO `{PREFIX}web_users` VALUES ('1','siteadmin','5f4dcc3b5aa765d61d8327deb882cf99',''); # # Dumping data for table `webgroup_access` # REPLACE INTO `{PREFIX}webgroup_access` VALUES ('1','1','1'); # # Dumping data for table `webgroup_names` # REPLACE INTO `{PREFIX}webgroup_names` VALUES ('1','Site Admins'); REPLACE INTO `{PREFIX}webgroup_names` VALUES ('2','Registered Users'); # # Dumping data for table `categories` # REPLACE INTO `{PREFIX}categories` VALUES ('1','MODx default templates'); REPLACE INTO `{PREFIX}categories` VALUES ('2','User Management'); REPLACE INTO `{PREFIX}categories` VALUES ('3','News, Blogs and Catalogs'); REPLACE INTO `{PREFIX}categories` VALUES ('4','Navigation'); REPLACE INTO `{PREFIX}categories` VALUES ('5','Forms and Mail'); REPLACE INTO `{PREFIX}categories` VALUES ('6','Core and Manager'); REPLACE INTO `{PREFIX}categories` VALUES ('7','Frontend'); REPLACE INTO `{PREFIX}categories` VALUES ('8','MODxHost Menu'); REPLACE INTO `{PREFIX}categories` VALUES ('9','Demo Content'); REPLACE INTO `{PREFIX}categories` VALUES ('10','Search'); # # Table structure for table `jot_content` # CREATE TABLE IF NOT EXISTS `{PREFIX}jot_content` (`id` int(10) NOT NULL auto_increment, `title` varchar(255) default NULL, `tagid` varchar(50) default NULL, `published` int(1) NOT NULL default '0', `uparent` int(10) NOT NULL default '0', `parent` int(10) NOT NULL default '0', `flags` varchar(25) default NULL, `secip` varchar(32) default NULL, `sechash` varchar(32) default NULL, `content` mediumtext, `customfields` mediumtext, `mode` int(1) NOT NULL default '1', `createdby` int(10) NOT NULL default '0', `createdon` int(20) NOT NULL default '0', `editedby` int(10) NOT NULL default '0', `editedon` int(20) NOT NULL default '0', `deleted` int(1) NOT NULL default '0', `deletedon` int(20) NOT NULL default '0', `deletedby` int(10) NOT NULL default '0', `publishedon` int(20) NOT NULL default '0', `publishedby` int(10) NOT NULL default '0', PRIMARY KEY (`id`), KEY `parent` (`parent`), KEY `secip` (`secip`), KEY `tagidx` (`tagid`), KEY `uparent` (`uparent`)) TYPE=MyISAM; # # Dumping data for table `jot_content` # REPLACE INTO `{PREFIX}jot_content` VALUES ('9','The first comment','','1','9','0','','87.211.130.14','edb75dab198ff302efbf2f60e548c0b3','This is the first comment.','','0','0','1160420310','0','0','0','0','0','0','0'); REPLACE INTO `{PREFIX}jot_content` VALUES ('10','Second comment','','1','9','0','','87.211.130.14','edb75dab198ff302efbf2f60e548c0b3','This is the second comment and uses an alternate row color. I also supplied a name, but i\'m not logged in.','Armand','0','0','1160420453','0','0','0','0','0','0','0'); REPLACE INTO `{PREFIX}jot_content` VALUES ('11','No abuse','','1','9','0','','87.211.130.14','edb75dab198ff302efbf2f60e548c0b3','Notice that I can\'t abuse html, , or [+placeholder+] tags.\r\n\r\nA new line also doesn\'t come unnoticed.','Armand','0','0','1160420681','0','0','0','0','0','0','0'); REPLACE INTO `{PREFIX}jot_content` VALUES ('12','Posting when logged in','','1','9','0','','87.211.130.14','58fade927c1df50ba6131f2b0e53c120','When you are logged in your own posts have a special color so you can easily spot them from the comment view. \r\n\r\nThe form also does not display any guest fields when logged in.','','0','-1','1160421310','0','0','0','0','0','0','0'); REPLACE INTO `{PREFIX}jot_content` VALUES ('13','Managers','','1','9','0','','87.211.130.14','91e230cf219e3ade10f32d6a41d0bd4d','Comments posted when only logged in as a manager user will use your manager name.\r\n\r\nModerators options are always shown when you are logged in as manager user.','','0','1','1160421487','0','0','0','0','0','0','0'); REPLACE INTO `{PREFIX}jot_content` VALUES ('14','Moderation','','1','9','0','','87.211.130.14','58fade927c1df50ba6131f2b0e53c120','In this setup the Site Admins group is defined as being the moderator for this particular comment view. These users will have extra moderation options \r\n\r\nManager users, Moderators or Trusted users can post bad words like: dotNet.','','0','-1','1160422081','0','0','0','0','0','0','0'); REPLACE INTO `{PREFIX}jot_content` VALUES ('15','I\'m untrusted','','0','9','0','','87.211.130.14','edb75dab198ff302efbf2f60e548c0b3','Untrusted users however can NOT post bad words like: dotNet. When they do the posts will be unpublished.','','0','0','1160422167','0','0','0','0','0','0','0'); # # Table structure for table `jot_subscriptions` # CREATE TABLE IF NOT EXISTS `{PREFIX}jot_subscriptions` (`id` mediumint(10) NOT NULL auto_increment, `uparent` mediumint(10) NOT NULL default '0', `tagid` varchar(50) NOT NULL default '', `userid` mediumint(10) NOT NULL default '0', PRIMARY KEY (`id`), KEY `uparent` (`uparent`), KEY `tagid` (`tagid`), KEY `userid` (`userid`)) TYPE=MyISAM;