Scorpio Framework for PHP

• Resources

  • Categories
  • News
  • Documentation
  • Tutorials
  • Roadmap

• Links

  • Madagasgar.com
  • SourceForge Project Page
  • Download Releases
  • Bug Tracker
  • Feature Requests
  • API Docs

Creating a Scorpio development environment

• You are in »
• Categories /
• Tutorials /

Adding a pre-built component

With the basics up and running you can get on with building your own databases, tables and objects etc. Just be sure to add the database mapping to the config.xml file. Alternatively if you want an idea of what you can do with Scorpio, you can follow these steps to download and setup the Scorpio Article System.

This is a component built using the various tools within Scorpio and designed to use the existing Admin framework.

First step: backup the existing files. Either tar the whole folder or create a ZIP file or just create a copy - just in case.

Change directory to the root scorpio folder:

cd /home/sites/scorpio

And now export the latest version of the article system from SVN. As this is packaged in the same format as the main framework, we can export it directly over the top of the existing files. None of the existing files should be overwritten by this action (unless you created an article set of classes). Note that you need to use --force on the SVN command to have it export into the existing folder.

svn export https://scorpiofwork.svn.sourceforge.net/svnroot/scorpiofwork/components/scorpio.article.plugin/trunk ./ --force

With the files downloaded, we need to update the main config.xml file with a new database reference: "articles". This needs to be added in the database section:

nano -w /home/sites/scorpio/libraries/config.xml

And the code is:

Save the changes and exit nano (Ctrl+O Ctrl+X).

Now we need to setup the database and initialise it. So change to the data/sql folder:

cd /home/sites/scorpio/data/sql

And login to MySQL with a user with CREATE privileges (e.g. root):

mysql -u root -p

Create a new database using the name specified in the config file and switch to it:

create database scorpio_articles;

use scorpio_articles;

Now we can import the initialisation file to setup the basic components of the article system:

\. articlesInit.sql;

And that's it for MySQL via the client.

exit

Before continuing any further, we have to make sure there are no database updates to be applied. Change to the tools folder and then run the dbUpdate.php script and check the status of the databases.

cd /home/sites/scorpio/tools

php dbUpdate.php --status

It should report that scorpio_articles requires updating. First we perform a trial run to ensure that the dbUpdate component has been downloaded correctly:

php dbUpdate.php --update

And then we run and commit the updates:

php dbUpdate.php --update --commit

A check of the status again should show no errors and the last update status of "Success".

php dbUpdate.php --status

With that now complete we can setup the article website and admin area.