# 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
Simple Blog. When logged into your site, you''ll be able to create new entries from the front end. This can also be turned into a News publishing or PR publishing system. View example blog
\r\n
Easy Comments. When logged into your site, your registered site users can comment on your posts. View example
\r\n
RSS Feeds. Your site visitors can stay up to date using your site feeds. View RSS feed
\r\n
Automatic User Registration. Those that wish to comment on blogs must first create an account. This comes pre-configured with a "Captcha" anti-robot registration feature. View registration form
\r\n
QuickEdit. When you''re logged into the manager, you can edit a page directly from the front end! More about CMS features
\r\n
Integrated Site Search. Allows visitors to search only the pages you wish them to search. Uses Ajax to display results without loading a new page. Highlight feature
\r\n
Powerful Navigation Builder. Duplicate or build virtually any navigation system with our dynamic menu builder code. The menu above, for example. More about menu features
Custom "page not found (404)" page. Help visitors who go astray to find what they''re looking for. View 404 page
\r\n
Contact Us form. A highly configurable contact form you should customize to point to the right email address. Comes pre-configured to prevent mail-form-injection so your site does not become a source for spam. View form
\r\n
Newest documents list. Shows your visitor the most recently added pages (configurable). Highlight example
\r\n
\r\n
To log into the MODx Control Panel and start customizing this site, point your browser to [(site_url)]manager/.
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.
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, '', '
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.
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.
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.
"This is a blockquote. Use this for quotes and references to texts from other places. You can also use the class .box to create a similar boxed effect..."
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
For basic instructions on integrating custom templates into MODx, please see the Designer''s Guide.
\r\n
For an introduction to working in MODx from the content editors perspectve, see the Content Editor''s Guide.
\r\n
For a detailed overview of the backend "manager" and setting up Users and Groups, please peruse the Administration Guide.
\r\n
For developers, architecture and API documentation can be found in the Developer''s Guide.
\r\n
And if someone has installed this site for you, but you''re curious as to the steps they went through, please see the Getting Started Guide.
\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.
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.
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.
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.
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[+logouttext+]\r\n\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', 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
You''re already logged in
\r\nDo you wish to [+logouttext+]?\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\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 (9, 'footer', 'Site Template Footer', 0, 1, 0, '[(site_name)] is powered by MODx CMS |\r\n Design by Andreas Viklund\r\nDesigned by ziworks\r\n\r\n\r\n\r\n
\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','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;