Don't waste your time learning to use complex CMS if you don't need advanced options. This simple CMS made for PHP/Mysql contains only three tables. You can add more modules as your site growns programed by you. SPP version 0.1 is free (GNU Lesser). Includes search, and sitemap, if you need those functions request it(version 0.4 not uploaded yet).
When to use SPP
Your hosting is slow or your site is popular,you are an PHP programmer and need something basic, you have few pages, is not important sections, categories.
Requirements:
PHP (was created for php 4 but should work with version 5.x replace <? for <?php and use $_GET,$_POST... instead of using globals), Mysql 4, javascrip, 3 MB on your web server or more.
Features
- You can execute php inside your pages
- Very simple and fast one page is generated in fractions of second not several seconds as Joomla for example.
- Creates pages with description and keywords
- Password protected pages
- Deny access by IP
Installing
Download SPP, unrar the rar file, then upload the files to your web server using FTP, finally execute install.php from the administrative folder : something like **adminxx y execute install.php, but for this step you will need a valid mysql database, an user and a password. Install.php will try to create the database with three tables.
Note: If installation fails edit const.php and execute blank.sql using Phpmyadmin.
path: zadminxx\install\blank.sql
After of creating tables, execute install.php again, the administrative user will be inserted in a table.
You will need to create an user and password, with this password you will be able to access to the administrative folder to create, edit, delete pages with a WYSWYG editor , FCKEDITOR, also is included a simple file manager.
Administrator login at
zadminxx/index.php
Adminitrative interface
Creating a page
Inside the administrative folder, after of using your user and password, write a title, content, descript and a identifier for the url, the identifier is a varible passed to index.php, example:
http://www.cromosoft.net/spp/?dir=main
Here the template is index2.php
http://www.cromosoft.net/spp/index2.php?dir=main
Customise your template (index.php)
Save an html file as php, this file should include two includes: header.php and cuerpo.php , the first file will create the header section with title, keywords and description, the second file will create the content of a web page. By hand copy and paste your urls into your template.
Brief manual of SPP
The file install.php must be deleted for security with installfinish.php and only should be used during the installation or to reset the password if this was forgeted.
Customizing template of your web site
You can edit the file index.php, this file exists in the root of spp, "the template" , be carefull of not deleting these includes: header.php that is at the beginning and the other include cuerpo.php, the include header.php must be at the begining of your template. The template won't include any meta tags, the include header.php will create it for you from your database .
The position of the include:cuerpo.php is more flexible, if after of editing index.php the content isn't displayed, restore the original file index.php. If you never edited an html file you could request help. The file cuerpo.php will show the dinamic content of your page. If you want you could create so many templates as you want inside the same folder, you only should change the file who is being loaded with different parameters, examples:
index.php?dir=hola , plantilla2.php?dir=hola , but always should exists the file index.php by default this file is executed in a web server with PHP.
Restricting access for special pages(only will be visible for users with password)
You can protect content of your web site of unwanted visitors, for doing it follow these easy steps:
- When you create a page select the option "Is Public this page?", select No
- create users and passwords in the file usuarios.php , this file is on root folder of SPP, of this way:
jose:supassword
mario:ento45td
The user is separed by : of the assigned password, the file should be saved as php file:
<?php
jose:supassword
mario:ento45td
?>
Recovering password of administrator
The password of administrator isn't saved in a file, is stored in the MySql table: user_admin, if you forget it, you need to create a new user with a password executing the file install.php if you deleted it after installing you should upload it to your web server again.
Locking an account for security because there were failed login attemps
Administration of pages will be locked by default 6 seconds if you introduce an user with invalid password, you can change this time editing the file const.inc.php , changing the parameter: $segundos_bloqueo
Restricting access to pages by checking IP
Follow these two steps, if you don't want that a page is visible inside a network or specific IP:
- Edit the file ip_ban.php, this file is at the root of SPP, example:
<?php //add a line per IP o range
200.37
68.45.89.20
?>
- Select in properties of a page: ¿Lock this page for IP range? , choose SI or Yes
Inside a page created with SPP is posible to execute PHP scripts, with this option you should copy and paste any source code, in properties select this page has PHP scripts? select Yes or Si.
Error 1: You installed in your server SPP, but there is no any editor WYSWYG, but there is an error that says, page was not foud or in spanish, no se encontró la página:
Solution:
If the error is "was not fould the page" probable there are files that are missing of the editor FCKEditor, please upload the files again.
If the error is es Forbidenn, the permits of the files are not valid, probable you didn't use FTP instead you unzipped the files inside the same server to save time, the files created from a Control panel aren't the same as the used by a regular user, the web server will deny access to these. Delete files of folder FCKeditor and upload it again but using FTP.
I paste content to the editor FCKeditor, but the editor is very low.
PPS uses javascript and requires a powerfull processor in your computer, you can create pages of a max size of 16MB per page, but if you experience slow response, wait few seconds and click HTML source and work only with source code of your page. If you are working with pages of more 100000 characters you could experience slow response with processors slower than Pentium 3. Edit the page in other program and paste the source code.
Error 2: A few of scripts of SPP are using <? instead of <?php and your scripts will not run, check it, it was reported with versions 5.x, run an automated replace of <? for <?php for every file.
For creating a page, write the title, an identifier or identificador for every page, this will be shown on the url. The content will have only formatted text, you can copy and paste formatted text from your applications thanks to the editor FCKeditor.
If you require to include files with images use the same editor, or user the file manager or "Administrador de Archivos", in this case you will be able to manipulate files but not links.
For inserting PHP source code, change "view HTML" or "Fuente HTML", and insert the php tags , after of finishing come back to the normal view and insert visible elements. Select "SI" or Yes with the option ¿It has PHP scripts?. The source code between
won't be visible only when you execute the page.
Transfering SPP to other web server
Files of SPP should be copied, including the administrative folder adminxx and files of the external folder: index.php, const.php, autenticate.php, header.php, ip_ban.php and usuarios.php.
After of copying the files, you should make a copy of the database used for SPP, this database only has three tables: contenidos, catalog y user_admin. The most important is contenidos because this table has content of your web pages. For making a copy and restoring it you can use PhpMyadmin, EMS Mysql, MySQL Commander, etc. If you make changed in the database(password, name, user) update the file const.php , this file is en la raiz de los scripts.
-About the folder UserFiles
This folder is used for storing uploaded files from your Internet browser. PPS uses this folder according with rules of FCKeditor, but this folder should not be necessarily on the root of your web site. You can create several installations of PPS but different folders and databases should be used, for example here we have two installations of PPS:
http://www.servidor.com/algo/spp1/UserFiles
http://www.servidor.com/algo/spp2/UserFiles
- If you update FCKEditor, take in consideration that you should update the file FCKeditor/editor/filemanager/browser/default/connectors/php/config.php , that by defauld says::
$Config['UserFilesPath'] ='/UserFiles/';
and must be included this value for $Config['UserFilesPath']:
$Config['UserFilesPath'] =$_COOKIE['path_upfiles345'];
Also for the file FCKeditor/editor/filemanager/upload/php/config.php
-To customize the size of the editor, please edit the file FCKeditor.php
SPP version 0.1 is free, but please consider including a link to www.cromosoft.com
