[ phpMyFAQ 1.4.0 Documentation ]

  1. Introduction
    1. License
    2. Support
    3. Copyright
    4. Donations
  2. Installation
    1. Requirements
    2. Preparations
    3. Install-Script
    4. First Steps
    5. Notes
  3. Upgrading
    1. Upgrading from phpMyFAQ 1.1.x or 1.2.x
    2. Upgrading phpMyFAQ 1.3.x
    3. Modifying templates for phpMyFAQ 1.3.x
    4. Upgrading phpMyFAQ 1.4.x
  4. Administration
    1. User Administration
    2. Record Administration
    3. Category Administration
    4. News Administration
    5. Edit open questions
    6. Rating Statistics
    7. Cookies
    8. View Sessions
    9. View Adminlog
    10. Change passwords
    11. Edit configuration
    12. Backups
    13. Export your FAQ
    14. Logout
  5. Customising phpMyFAQ 1.4.x
    1. The file template/index.tpl
    2. The file template/style.css
    3. More Templates
  6. One more thing

1. Introduction

phpMyFAQ is a multilingual, completely database-driven FAQ-system. A MySQL database is used to store all data, PHP 4.1.0 (or higher) is needed in order to access this data. phpMyFAQ also offers a Content Management-System, flexible multi-user support, a news-system, user-tracking, language modules, enhanced automatic content negotiation, templates, extensive XML-support, PDF-support, a backup-system and an easy to use installation script.

This documentation should help you with installing and administrating phpMyFAQ.

back to top


1.a. License

phpMyFAQ is published unter the Mozilla Public License Version 1.1 (MPL). This license guarantees you the free usage of phpMyFAQ, access to the sourcecode and the right to modify and distribute phpMyFAQ.

The only restrictions apply to the copyright, which remains at all times at Thorsten Rinne. Any modified versions of phpMyFAQ will also fall under the terms of MPL. Any other program, that may only be accessing certain functions of phpMyFAQ is not affected by these restrictions and may be distributed under any type of license.

A commercial usage or commercially distribution of phpMyFAQ, e.g. on CD-ROMs, is allowed, as long as the conditions mentioned above are met.

We decided to use MPL as the licensing model for phpMyFAQ because we feel that it is a good compromise between the protection of the openness and free distribution on the one hand and the interaction with other software regardless of its licensing model. When compared to other licensing models its text is short and easily comprehensible, even for newcomers.

This documentation is licensed under a Creative Commons License.

back to top


1.b. Support

If you should run into any problems using phpMyFAQ check out our support forums at forum.phpmyfaq.de. There is no support by phone or email, please refrain from calling us.

back to top


1.c. Copyright

© 2001 - 2004 by Thorsten Rinne under the Mozilla Public License. All rights reserved.

back to top


1.d. Donations

If you find phpMyFAQ useful and want to express your appreciation, have a look at my amazon.de Wishlist. I also accept online donations through PayPal. Please use the button below to make a donation online:

back to top


2.Installation

2.a. Requirements for phpMyFAQ

phpMyFAQ addresses a MySQL database via PHP. In order to install it you will need a webserver that meets the following requirements:

You can only run phpMyFAQ successfully, when the PHP directive safe_mode is set to off, further constraints affect the directives open_basedir and disable_functions, which can be set in the central php.ini or the httpd.conf respectively.

In case PHP runs as module of the Apache, you will have to be able to do a chown on the files before installation. The files and directories must be owned by the Apache user.

You can determine which versions your webserver is running by creating a file called info.php with the following content:

<?php phpinfo(); ?>

Upload this file to your webspace and open it using your browser. You will now be prompted the PHP and MySQL version numbers. The installation-script also checks which versions of PHP and MySQL are installed on your server. Should you not meet the requirements, you cannot start the installation process.

In case you only have PHP3 or PHP 4.0.x installed you cannot use phpMyFAQ.

phpMyFAQ uses a WYSIWYG online editor. It uses a non-standard feature based on JavaScript implemented in Mozilla Firefox 0.7+ (any platform), Mozilla 1.3+ (any platform) and Internet Explorer 5.5+ for Windows, therefore the editor will only work in one of these browsers. You have to enable JavaScript.

back to top


2.b. Preparations

Please unzip the downloaded archive on your harddisk.

You can modify the layout of phpMyFAQ using templates. A description of how this is done can be found below. Copy all unzipped files to your webserver in a directory using FTP. A good choice would be the directory faq/.
Important:
Writing permission for your script is needed in this directory to be able to configure the files data.php and config.php during installation. This is the case if you're running PHP as CGI or as mod_php with disabled safe-mode. The installation script will stop when your webserver isn't configured as needed.

back to top


2.c. Install-Script

Open your browser and type in the following URL:

http://www.yourdomain.com/faq/install/installer.php

Substitute www.yourdomain.com with your actual domain name. When the site is loaded enter the address of your MySQL server (e.g. db.provider.com), your MySQL username and password as well as the database name. The datebase must be availible before running the installation script. You can leave the prefix-field empty. If you are planning on using multiple FAQs in one database you will have to use a tableprefix, though (i.e. sport for a sports-FAQ, weather for a weather-FAQ, etc.). Please note that only letters and an underline: "_" can be used as the prefix. When using multiple FAQs you need to install them independently into different directories (e.g. faq1/, faq2/. faq3/ etc.). In addition you can enter your language, default here is English. Furthermore you should register your name, your email address and - very importantly - your password. You must enter the password twice and it have to be at least six places long. Then click the button "install" to initialize the tables in your database.

back to top


2.d. First Steps

You can enter the public area of your FAQ by entering

http://www.yourdomain.com/faq/index.php

into your browser's address field. Your FAQ will be empty and presented in the the standard layout.

To configure phpMyFAQ point your browser to

http://www.yourdomain.com/faq/admin/index.php

Use the username admin and your selected password for your first login into the admin section.

back to top


2.e. Notes

Regarding the search-function:
Fulltext-search will only work if there are some entries in the database (5 or more). The term you are looking for should also not be in more than 50% of all your entries, or it will automatically be excluded from search. This is not a bug, but rather a feature of MySQL.

Automatic content negotiation
To set the default language in your browser you have to set a variable that gets passed to the web server. How this is done depends on the browser you are using.

PHP settings:
If you're able to edit the php.ini file, please check that the variable file_upload = On is set; otherwise the file upload will not work for the attachments.

back to top


3. Upgrading

Upgrading to phpMyFAQ 1.4.x is possible from the following versions:

We recommend a new and fresh install due to the many changes between phpMyFAQ 1.3.x and 1.4.x.

back to top


3.a. Upgrading from phpMyFAQ 1.1.x or 1.2.x

There's only a difficult way to update a rather old version of phpMyFAQ. You have to update to phpMyFAQ 1.3.14 first and then you can update it to 1.4.0.

We recommend a new and fresh install due to the many changes in phpMyFAQ 1.3.x and 1.4.x.

back to top


3.b. Upgrading phpMyFAQ 1.3.x

Upgrading from 1.3.x to 1.4.x is a major upgrade. Please make a full backup before you run the upgrade! Updating from phpMyFAQ 1.3.x is fairly simple. Via FTP delete all files except:

Copy the new files to your webspace and open the following URL in your browser:

http://www.yourdomain.com/faq/install/update.php

Choose your installed phpMyFAQ version and click the button of the update script, your version will automatically be updated. It is possible that your attached images or documents are gone. You have to reinsert them in the new Image Manager. Additionally you have to reorder your categories.

After that you have to convert the BBCode from phpMyFAQ 1.3.x into XHTML code. This will be done by a convert script. Open the following URL in your browser:

http://www.yourdomain.com/faq/install/bbcode2xhtml.php

Maybe this update will work some seconds due to the fact that in all entries the BBCode have to converted into XHTML.

back to top


3.c. Modifying templates for phpMyFAQ 1.3.x

Since phpMyFAQ 1.4.0 supports untabled XHTML, you have to rewrite your templates from the scratch. Please use the new templates included with version 1.4.0 and adjust your layout to avoid any problems.

back to top


3.d. Upgrading phpMyFAQ 1.4.x

Updating phpMyFAQ 1.4.x is fairly simple. Via FTP copy all new files from the update zip file except:

Open the following URL in your browser:

http://www.yourdomain.com/faq/install/update.php

Choose your installed phpMyFAQ version and click the button of the update script, your version will automatically be updated.

back to top


4. Administration

The administration of phpMyFAQ is completely browser-based. The admin area can be found under this URL:

http://www.yourdomain.com/faq/admin/index.php

If you have lost your password, there you can reset it. A new random password will be generated and sent to you via e-mail. Please change it after your successful login with the generated password.

After entering your username and password you can log into the system. On the startpage you can see the admin menu on the left, some statistics about visits, entries and comments on the right. The menu contains the following sections:

back to top


4.a. User Administration

phpMyFAQ offers a flexible management of privileges (or rights) for different users in the admin area. It is possible to assign different priviledges to real people (represented by the term users). Those priviledges are very detailed and specific, so that you could allow a certain user to edit but not to delete an entry. It is very important to contemplate which user shall get which priviledges. You could edit an entry by completely deleting all content, which would be equivalent to deleting the whole entry. The number of possible users is not limited by phpMyFAQ.

In the main screen of the user administration you'll see an overview of all active user profiles, whereas a combination of "1" and "0" represents the priviledges of a user. A "1" symbolizes that a user has this priviledge, a "0" shows that a user cannot perform a certain action. The order is essentially the same as the listing of the "Rights" when creating or editing a user.

Keep in mind that new users have no priviledges at all, you will have to assign them by editing the user's profile. The admin user cannot be deleted, nor can the name be changed.

back to top


4.b. Record Administration

You can create entries directly in the admin area. Created entries are NOT published by default. The meaning of the fields is as follows:

You can edit and delete all records as well.

back to top


4.c. Category Administration

phpMyFAQ lets you create different sections and subsections for your FAQ. You can also re-arrange your categories in a different order.

back to top


4.d. News Administration

phpMyFAQ offers you the ability to post news on the starting page of your FAQ. In the administration area you can create new items, edit existing news or delete them.

back to top


4.e. Edit open questions

phpMyFAQ lets visitors contribute to the FAQ by asking questions. Every visitor is able to view these open questions in the public area, and may give an answer. If you wish to get rid of open questions you can do so using this section. Alternatively you can take over a question and answer it yourself and hereby add it to the FAQ.

back to top


4.f. Rating statistics

Below every entry visitors have the chance to rate the overall quality of an article by giving ratings from 1 to 5 (whereas 1 is the worst, 5 the best rating). In the statistics the average rating and number of votes becomes visible for every rated entry. To give you a quick overview entries with an average rating of 2 or worse are displayed in red, an average above 4 results in a green number.

back to top


4.g. Cookies

phpMyFAQ can save the login information to the admin area as a cookie on your computer. Although this feature may be very comfortable it is a potential security hole. Only use cookies if you are the only person using the computer.

back to top


4.h. View Sessions

This functions lets you keep track of your visitors. Every visitor is assigned an id when coming to your starting page, that identifies him during his whole visit. Using the information gathered here you could reconstruct the way visitors use your FAQ and make neccessary adjustments to your categories, content or keywords. There is also a search function that you can use to look for a certain IP, the number of minimum actions or the date of a visit.

back to top


4.i. View Adminlog

The adminlog allows you to track any actions taken by users in the admin area of phpMyFAQ. If you feel you have an intruder in the system you can find out for sure by checking the admin log.

back to top


4.j. Change passwords

This section lets you change your password. It is possible to deny this function for a certain user, which is very reasonable for group accounts. In order to change the password you need to have "Change Password" enabled for this user.

back to top


4.k. Edit configuration

Here you can edit the general settings of phpMyFAQ. However, colours or layout cannot be modified here.

Should you want to enter multiple email addresses in the configuration separate them by a comma (",").

back to top


4.l. Backups

Using the backup function it is possible to create a copy of the database to a single file. This makes it possible to restore the FAQ after a possible "crash" or to move the FAQ from one server to another. It is recommended to make regular backups of your FAQ.

back to top


4.m. Export your FAQ

Maybe you want to show the news, the Top 10 or the latest records on your website. For this reason you can export these parts to RSS feeds. RSS is a Web content syndication format. Its name is an acronym for Really Simple Syndication. RSS is dialect of XML.

You'll find a PHP script on our download page, that reads the RSS feeds and you can include it on your website. You have to build the RSS files at the point Export your FAQ in the admin area. You'll find the files in the directory xml/. The following files will be created:

nach oben


4.n. Logout

Clicking on Logout will end the current session. It is recommended to logout before closing the browser to prevent exploits.

back to top


5. Customising phpMyFAQ 1.4.x

Since phpMyFAQ 1.2.0 and later code and layout are almost completely seperated. The layout is based on several templates, that you can modify to suit your own needs. The most important files for phpMyFAQ's layout can be found in the directory template/. All original templates are XHTML 1.0 valid and we don't use tables for layout reasons.

Note: You can change the layout of the admin area using the CSS file style.css.

back to top


5.a. The file template/index.tpl

The default layout of phpMyFAQ is saved in the index.tpl file. This is a normal HTML-file including some variables in curly brackets, serving as placeholders for content.

Example:

<span class="useronline">{userOnline}</span>

The template-parser of the FAQ converts the placeholder {userOnline} to the actual number of visitors online.

You can change the template as you wish, but you may want to keep the original template in case something goes wrong. Theoretically you can use any editor for changing the templates, test using Dreamweaver were successful. Modifying the files with Microsoft Frontpage, Adobe GoLive or NetObjects Fusion may mess up the template, since they alter the source-code.

back to top


5.b. The file template/style.css

All formattings such as fonts, colors and the like can be modified in the CSS-file style.css. More info can be found at the official W3C website.

back to top


5.c. More Templates

You need an other template design or more XHTML/CSS features? Then visit the website of the author from the main template and get what you deserve.

back to top


6. One more thing

Thank you for using phpMyFAQ! :-)

Author: Thorsten Rinne
Basic translation by: Stephan Hochhaus
Last Change: 2004-07-30

© 2001-2004 Thorsten Rinne

This documentation is licensed under a Creative Commons License.

back to top