SiteBuilder 2

1
SiteBuilder 2

• Introduction

2
Used Technology

• Originally developed with
• PHP 4
• MySQL
• Apache
• Basically the only main requirement with current
  version is PHP 4 or PHP 5
• Tested only with MySQL, but supports also Oracle
  8, Interbase / FireBird, PostgreSQL, SQLite and
  MS-SQL
• Some SQL commands might be needed to be changed
  little

3
Main Features

• Database abstraction layer with ezSQL
• Proprietary template engine
• WYSIWYG content editor
• HTMLArea
• User administration
• Module support
• Language support

4
Further Development

• New features can be added by simple module
  support
• Modules have to be programmed in PHP
• Existing modules
• Product catalog shopping cart
• Newsletter
• Gallery
• Seminar registration
• Calendar
• Resource reservation

5
File Hierarchy

• /documents/Files manageable through
  administrative interface. For example
  PDF-documents, content images, other
  downloadable, but changing material
• /images/Static images used in the html
  templates.
• /html/Html templates used in the template
  engine.
• /htmlarea/HtmlArea files.
• /php/All function libraries, modules and other
  php files needed by index.php
• /styles/Needed stylesheets.
• /sql/Required sql to create needed tables.
  Contains default site, which well go through.

6
Template Naming Scheme

• Templates under /html/ folder
• Admin interface templates start with admin_
  (admin_filename.html)
• Language specific templates under
• /html/en/
• /html/se/ folders
• Public files starting with public_
  (public_filename.html). This is new naming scheme
  and not used in most of older sites.

7
Template structure

• Templates totally normal html files
• Paths relative to root directory of site (if you
  want to test functionality or edit in DreamWeaver
  with visible images move images, styles and
  javascript folders temporiralily under /html/
  folder)
• Dynamic parts defined by custom object tags
• output-gttitle
• output-gtcontent
• etc.

8
Template Wrapping

• More complex dynamic parts can be achieved by
  wrapping templates
• For example the default three level navigation is
  achieved with wrapping
• Wrapping can be used also for other purposes
• Display items in dynamic module lists
• Display customized parts in the layout

9
Template Wrapping Example

• Main layout template (public_template.html)
• 1st level navigation item (public_1st_navi.html)
• 1st level navigation item (public_1st_navi.html)
• 2nd level navigation item (public_2nd_navi.html)
• 3rd level navigation item (public_3rd_navi.html)
• 2nd level navigation item (public_2nd_navi.html)
• 1st level navigation item (public_1st_navi.html)
• Basically each navigation level has their own
  Template Wrapper files

10
Database Structure

• Database structure is very simple and in problem
  situations easily fixed with PhpMyAdmin
• Four main tables
• Preview contains unpublished preview versions
  of the content pages
• Pages contains public versions of the content
  pages
• Adminusers contains administrative users data
• Adminrights contains rights for individual
  admin users on any single page
• Modules might use extra tables, but tables
  mentioned above are the only main tables of the
  SiteBuilder
• Database backups should be automatized! Once in
  day preferred!

11
Configuration

• Configuration is completely made in the
  config.php located in the php directory
• Database connectivity
• Site root URL
• Document, template and styles folder paths
• Allowed, uploadable document types
• Feedback email parameters
• Any module specific parameters
• Required includes in correct order

12
SiteBuilder Core Files

• The core of each SiteBuilder installation is its
  index.php file in the root directory
• Printing functionality is achieved by print.php
  file, which is a cleaned version of index.php and
  using very simple template without navigation
• Administrative interface is launched from
  cadmin.php

13
Site Creation Process with SiteBuilder 2

• Create database
• Create needed tables from example SQLs in /sql/
  folder
• Edit configuration file
• Copy files to server
• Change directory rights
• Launch site / administrative tool
• Start modifying template and content!

14
Database Creation

• Preferrably use PhpMyAdmin to create database
• Run SQL that creates needed table structures and
  inserts administrative superuser in the users
  table
• Preferably use the default site as it provides
  you with skeleton for the new site
• Most of the pages dont need to be created from
  scratch, just modify existing ones

15
Edit Configuration File

• Database connection
• DBNAME '' / Database name /
• DBHOST 'localhost' / MySQL Server host name
  /
• DBUSER '' / Database username /
• DBPASSWD '' / Database password /
• Site root URL
• SITE_ROOT 'http//'._SERVER'SERVER_NAME'.'/s
  itebuilder2' / Siteroot /

16
Copy Files and Verify Directory Rights

• Copy whole SiteBuilder 2 folder into the
  webserver
• Verify that SITE_ROOT is set accordingly
• Write rights needed for /documents/ directory so
  that file uploads through administrative
  interface are possible

17
Test Installation

• Go to according URL on your webserver and see if
  the installation is working
• If everything is ok, launch administrative
  interface using default admin account (admin /
  nimda)
• Feel free to start modifying content and template!