Action Log - Quick Reference

&insert:/OpenForum/AddOn/ActionLog/service-definition.wiki.fragment;

&insert:/OpenForum/AddOn/Alert/service-definition.wiki.fragment;

Content Editor - Quick Reference

The content editor is a two panel editor. It is intended for pages that just contain text and images rather than those that are part of a web application.

Editor Panels

The two panels can be resized by dragging the separator between them.

The left hand panel gives an over view of the page being edited at the top, a list of pages to edit in the middle and a view of the image library at the bottom.

The right hand panel gives a view of the page content for editing. At the top is the title as shown on the browser tab and below are the sections of the page.

Adding Blocks

Above and below each page section are + buttons that will add content either above or below existing elements of content. There are also up and down buttons to move the content up and down the sections in the page.

On clicking + you are presented with a list of blocks that can be added to the page.

For simple formatted text and images, the WYSIWYG block allows you to enter text and type set it adding text styles, links and lists etc.

Images

To add an image into the WYSIWYG panel, find the image in the image library in the left hand pane or select to upload one. Drag the image into the WYSIWYG content block. Click on it to set any alternative text or its placement in the text.

A number of other block types are available that add either configurable page elements or page layouts.

Preview and Publish

To see how your page will look once published, click on Preview at the top of the left hand pane. This will save the page to a space for unpublished pages and make the page visible in another browser tab. Saving the page once the preview has been opened will automatically update the preview tab.

Once you are happy with your page, click Publish and the page will be published to the live area of your website.

New Pages

To create a new page select Create A New Page. In the popup window, enter the new pages title and optionally select a category. Select Create New Page and a new page will be added to the list and the editor for the page opened.

API Reference

&insert:/OpenForum/AddOn/ImageProcessor/service-definition.wiki.fragment;

Mailer Quick Reference

Notes

Menu Editor - Quick Reference

A menu bar editor.

&title;

The Publisher AddOn enables the publishing of packages from the developent area of a site into prodction.

All text files in the package (page and sub pages) are translated before publishing. References to Development are removed so a path /MyPage becomes /MyPage

Deletions are not processed immediately, but placed in a deletions script file to run later.

Special files

development-translation.sjs - This is an optional script that will translate the contents of files. The script is passed the contents of each text file as the variable data and is expected to return the transformed version.
publish-config.json - Can contain a list of files to exclude eg.
do-not-release.txt - Marks a page as not to be published. Should contain text stateing the reason
process-deletions.sjs - A script that is generated with files to be deleted after publishing
release-notes.html.fragment - Notes generated during the release are saved here

Released Packages - Quick Reference

The Release AddOn enables the releaseing of packages for use on other sites.

Special files

pre-release.sjs - This script is run on the releasing server before the release package is built
release-excludes-files.json - A list of files to exclude from the release. This can include regex like .*-test.js
release-info.json - Contains release information
install.sjs - Run on the server where the package is installed after the package has been installed

&title;

Server Side

Include DB.sjs on your sjs file

var DB = js.getObject("/OpenForum/AddOn/SQL","DB.sjs"); DB.setAlias("your database name"); // Create a new DB object for each database you need access to

Create a Simple DB Select

var sql = { action: "select", table: "my_table", columns: <a href="/OpenForum/Editor?pageName=/OpenForum/AddOn/SQL/QuickReference/ "column_a", "column_b" "target="editor" style="color: red" title="The page /OpenForum/Editor?pageName=/OpenForum/AddOn/SQL/QuickReference/ "column_a", "column_b" does not exist. Click to create it."> "column_a", "column_b" </a> }; var rows = DB.execute( SQL );

Create a DB Select that returns all columns

var sql = { action: "select", table: "my_table" }; var rows = DB.execute( SQL );

Create a Simple DB Insert

var sql = { action: "insert", table: "my_table", data: { column_a: "value a", column_b: "value b" } }; DB.execute( SQL );

Create a Simple DB Insert that returns a column

var sql = { action: "insert", table: "my_table", data: { column_a: "value a", column_b: "value b" }, returnColumn: "column_c" }; var returnedColumn = DB.execute( SQL );

Create a Simple DB Delete

var sql = { action: "delete", table: "my_table", where: { column_a: "value a", column_b: "value b" } }; DB.execute( SQL );

Create a Simple DB Upsert

var sql = { action: "upsert", table: "my_table", data: { column_a: "value a", column_b: "value b", column_c: "value c", column_d: "value d" }, where: { column_a: "value a", column_b: "value b" } }; DB.execute( SQL );

Create a Simple DB Query

var sql = { query: "select column_c, column_d from my_table where a = { {valueA} } and b = { {valueB} } data: { valueA: "value a", valueB: "value b" } }; DB.execute( SQL );

&insert:/OpenForum/AddOn/Update/service-definition.wiki.fragment;

OpenForum Add Ons

ActionLog

Alert

ContentEditor

DataLogger

Developer

ImageProcessor

Mailer

Notes

MenuEditor

Publisher

ReleasedPackages

RemoteAdministration

RemoteLogger

SQL

ServiceBuilder

Update