CMSQLite is devided into front-end and back-end. To maintain your web page you need to login into the back-end.
In CMSQLite everything is about "articles". They are the content of each web page. That means: Every article stands for a web page. The pages are linked and displayed using the menu.
To generate your indivdual page first thing you need to do is to create at least one Artikel. The article with ID 1 that is the first article you create is called as your start (home) page.
All other articles are linked by the menu itmes and can be shown by clicking on the itmes.
The "Overview"-page is the start page of your back-end and shows all available articles. From the menu you will find the following administration tasks
Create new articles for your web page. At first you should enter a name for the article. Afterwards enter text into the text area.
document title | required: the title of your document (file name) |
document description | optional: Enter some desciption for the document. It is an advantage for serach engine optimisation |
document keywords | optional: Enter some key words for the document. It is an advantage for serach engine optimisation |
category | Choose a category for the document (read more in the section categories) |
published | Do you want to publish the document? If not the document will not be displayed within the frontend. This might lead to an error-page in the front end |
start date | Set a date when the doucment should be published. |
end date | Set a date when the document should be off line |
To style your text use the menu itmes from the text editor. The editor looks and beahves similar to a wordprocessor. Use your mouse and hover over the icons to see what they do.
To save your article hit the "save" icon (the small floppy disk-symbol) in the menu bar of the editor.
Create a new article and choose the category "News". Create your text-
To make your article more user friendly for example in the module "latest news" style your content with a "readon" link.
After writing your first paragraph click the button for readon from the menu bar of the editor (little icon with green arrow pointing to the right). A red line will be integrated into your text. This line splits your introduction text from the main text.
CMSQLite automatically splits your article in the newspage and the latest news module and inserts a "readon..."-link at this position.
In the overview-page click the title of your article. The "Edit Article"-view is displayed. Wait until the text editor is loaded and start to edit your text.
To save your article hit the "save"-icon (a small floppy disk) in the menu bar of the editor.
Categories are used to:
Create categories of your choice. For the output currently only the category "News" is relevant as all articles from this category will be output in the news page and the module latest news.
CKEDitor contains a spellchecker.
All (lucky) Firefox users can use the Firefox-Plugin. The spellcheck is enabled by default. To see suggestions you need to press the "CTRL" key while right-clicking to the underlinded word.
InternetExplorer-users surrender this function but can use the CKEDitor-spellchekcer supported by the web service "Spellchecker.net". Click on the icon for the spellcheck (you will find it in the first row the 5th block from the menu). An interface from the web service "SpellChecker.net" will be loaded. Please note that SpellChecker.net is responsible for the quality of the checking.
To insert pictures into your text you have to upload them to your server first.
As of CMSQLite version 1.2 the editor contains an integrated file browser. Click on the icon for the "image". A dialog appears. Hit the button "browse server" to enable the file browser. You can now search for the picture you want to integrate. Click on the picture or the "insert" link to insert the picture into your text.
You can also use the "mediaexplorer" from the "media"-menu. After uploading the pictures to the server you integrate them into your text. Either use the integrated file browser or enter in the field for the URL the complete path to the picture incl. your Domain. Example: http://www.YourDomain.com/media/YourFolder/YourPicture.jpg
The picture is implemented at the current cursor position. For more information about administrating your media read the "media administration" section
The media administration integrated into CMSQLite supports PDF and ZIP file formats. Befor you can integrate a link to the files into a text the files need to be uploaded to the server. Therefor you can easily use the "media explorer". As soon as the files are on the server you can integrate a link to this file.
As of CMSQLite version 1.2 the editor contains a Link-browser for easy integration of links into text.
Mark the word that represents the link (e.g. download, or the file name itself). Click on the icon for "edit/insert link" from the menu bar of the editor.
For external links choose "URL" as link type and "http://" as the protocoll. Enter in the field URL the full path to the file on the server incl. your domain. E.g. www.YourDomain.com/media/YourFolder/YourFile.zip
To link to an article or to a file click on the icon for "edit/insert link" and click on the button "browse server". The CMSQLite file browser opens and shows a list of articles and available ZIP and PDF files. Choose the desired file/article. You must choose < other > from the protocoll drop down list.
Since version 1.2 CMSQLite supports so called "page modules". These are little add-ons to make your page more attractive and to give it some more functionallity. E.g. the contact form is such a page module, or the site map module.
Choose from the menu "insert page module". At the cursors position the text { { mod_modulename } } is integrated (e.g. mod_contact, if you choose the contact module). Later on the contact form will appear right at this position.
To give you the ability to use more than just on menu in your web page you can create several menu modules. E.g. you need a main navigation and a foot navigation. So you will create a "main" module for the main navigation an a modul "foot" for the foot navigation. Main naivgation gets the ID 1 and the foot navigation ID 2.
To add menu itmes to the menu modules you click on the drop down list with the languages in the column "Edit" and choose the language for which you would like to add some items. The "edit menu" view will be opened. Now you are able to edit and enter main navigation items and sub items. CMSQLite support 2 navigation levels.
How to add additonal menu points read this section. To assign a menu item with an article choose the required article from the drop down list. Click the save button at the end of the page.
The implementation of the module within the "index"-template happens by adding the following code at the location where you need the menu module:
< ?php $HTML->generateMenu($langId, 1); ?>
as of version 1.2 use the following code:
< ?php $HTML->generateMenu($langId, 1, $contentId); ?>
(remove spaces when copying the text)
The number "1" stands for the menu module with ID=1, in our example for the "main" menu. If you want to generate the "foot" menu then replace the 1 simply with a 2 and that's it. Now the "foot" menu will be generated.
Find the menu you want to change from the main menu. Edit the text for the menu items in the text-fields. Don't forget to hit the "save" button at the end of the page to make the changes effective.
You can define the order of the menu items. Therefor you need to define a unique number to each of the menus in the column "order". CMSQLite does not automatically update the other fields and menu itmes so you need to enter them by hand.
Please obey that submenus have their own ordering which is independent from the main menu.
Save the new order by hitting the "save" button at the end of the page.
To present content (so your "articles") in different designs you can create new PHP-pages and register those as new "page modules". Page modules are PHP/HTML-code-blocks or even complete web pages that need to be programmed. E.g. you want to have a different page layout as the index-page. Create a new php-file which contains your new design (following the CMSQLite template design rules) and name it content.php.
Now regsiter this page module in the menu "modules" -> "page modules" and enter the new name. Save your settings. If you create new menu items you can assign a new page module to this menu item. The article will now be presented in the new page module (e.g. content.php)
As a standard CMSQLite contains the index-modul and the contact-modul. Use these as a reference for your own projects. Additonal informationen are available on www.CMSQLite.de
These are little "Applications" or Add-ons that can be integrated into the page itself. E.g. the contact form that is part of the standard installation is such an application. You will find a drop-down menu called "Modules" in the task bar of the editor. Click on in and choose the module you whish to integrate into your page. A place holder is integrated into the text at the cursor's position. This looks as an example like this { {mod_contact} }
When the visitor now looks at the page this part is automatically replaced by CMSQlite with the module. In case of the example the contact form is displayed.
Content modules must be programmed in PHP or can be downloaded from CMSQLite's homepage. Read the online manual to learn how to create your own module.
Below every menu item you can find a green arrow. Use these arrows to insert new menu items.
To insert main menu items use the green arrow at the end of the table.
Click the arrow and you will get to the page "Create menu point". Enter the name of the menu point into the first field. Enter the ordering into the second field. CMSQLite suggests a value but you can override it.
From the drop-down menu choose the page module. "index" is the standard, but you can choose also other modules from the menu. Read more about it in the tutorials on the webpage of www.CMSQLite.de
Last but not least choose an article or enter a url to which this menu item should point.
Administrating youe media is comfortable in CMSQLite. It supports ZIP, PDF, JPG, GIF and PNG file formats. You can create your own folders and subfolders to organise and save your media assets.
In the first field you can choose the file you want to upload to the server. Click browse to find your file on your local hard drive. Click on open if you have found the item you whish to upload and choose the upload button to start the upload. The file is now transfered to the server. After the upload process the page is updated and you should see your asset.
Create a new folder by entering a name into the field and click the button "create folder".
Folders that are not empty can not be deleted. So you need to delete first of all the files inside the folder before you can delete the folder. Alternativly use a FTP-Program..
You can edit your page meta definitions in this section. You can enter the key-words, the description and other information that are relevant for your web page header.
Besides CMSQLite supports the (currently) free available visitors analysing tool GOOGLE-Analytics. If you whish to use it you need to register at Googles page. You will receive a special Javascript Code for your webpage. Copy it from the Google page and paste it into the required fild., den Sie in das dafür vorgesehen Feld hinein kopieren. Diese Code wird nun automatisch allen Seiten angefügt. Die Auswertung erfolgt über Google-Analytics.
Introduction
CMSQLite is multilingual. Before the content is displayed it checks the browser language and sets it to show the content. If there is no translation for an article available it will be displayed in the standard language you set during the installation process.
Changing the language manually
If you want to allow users to change languages you need to create a link on your webpage that transfers the language code within the URL.
E.g. you want to point to the english content then you have to call the webpage with the following link: http://www.YourDomain.com/index.php?lang=en
You can of course integrate such links into drop-down menus or use the href-tag from an image. You just have to do this once as CMSQLite save the language and will display all content in this language.
Additional languages in CMSQLite
If you want to add more languages to CMSQlite you need to place the ISO-language code inside the "settings.php"-file. You will find the file in the root directory of your webpage.
Download the file with a FTP-Program and change the file with any text editor.
Look for the line: $arrayLanguages = array("de", "en");
Add the required languages to the array as follows: $arrayLanguages = array("de", "en", "es");
to add for example Sspanish language
Save the file and upload it back to your webspace. You now have to translate your content to the new language.
Translations
You can translate articles and menus.
translate articles: Click on the overview the article title from the article you want to translate. In the edit-view you can find a drop-down menu to choose the language you want to translate the text into.
Choose the language. A new page will open and you can find the original text in the upper section inside a bluw box and the text you want to translate in the lower editor box.
If you save the translation it will become a new article that you will find in the overview. Now you can change and edit these articles as if they would be regular articles.
translate menus: To translate menus you need to choose "menumodules" from the "modules" menu. All your menu modules will be displayed. Within the table you will find column "translate to" and a drop-down menu to choose a language for the menu module that is not allready translated! Choose the language and translate all the menu points into the new language.
Don't forget to save your work, before you leave the page!
Please note: After you have translated the menu CMSQLite interprets the translated menu as a complete seperate menu. Changing anything within the standard menu will not automatically change translations. That means you need to maintain each menu spearatly.
The reason: Not all content should be shown in all languages. So you can manage your content for each language separately.