sNews 1.5 Readme

(Developers Version 1.5.26) Release Candidate

Welcome to sNews 1.5 - a single file, template independant, PHP and MySQL powered, standards valid Content Management System.

Before installing please check minimum system requirements:

Apache Server with mod_rewrite module enabled
PHP: Hypertext Preprocessor version 4.x or above
MySQL database

These applications are freely available, and can be installed both on Windows and Linux OS (detailed info can be obtained at their websites). Note that sNews 1.5 won't work on Windows server because it uses different methods of URL rewriting.

Install sNews v1.5 through these 3 easy steps:

1. Copy the files

Copy all the files from sNews 1.5 package to your server and CHMOD 777 your folder where you'll upload your images (eg. img).

2. Setup the Database

Create the MySQL database with this code:

CREATE TABLE articles (
	id int(11) primary key auto_increment,
	title varchar(100) default NULL,
	seftitle varchar(100) default NULL,
  	`text` longtext,
  	`date` datetime default NULL,
  	category int(8) NOT NULL default '0',
  	position int(6) default NULL,
  	displaytitle char(3) NOT NULL default 'YES',
  	displayinfo char(3) NOT NULL default 'YES',
  	commentable varchar(5) NOT NULL default '',
  	published int(3) NOT NULL default '1',
  	description_meta varchar(100) default NULL,
  	keywords_meta varchar(100) default NULL
);

CREATE TABLE categories (
  	id int(8) primary key auto_increment,
 	name varchar(100) NOT NULL,
 	seftitle varchar(100) NOT NULL,
 	description varchar(100) NOT NULL,
 	published varchar(4) NOT NULL default 'YES',
 	catorder smallint(6) NOT NULL default '0'
);

CREATE TABLE comments (
 	id int(11) primary key auto_increment,
 	articleid int(11) default '0',
 	name varchar(50),
 	url varchar(100) NOT NULL,
 	comment text,
 	time datetime NOT NULL default '0000-00-00 00:00:00',
 	approved varchar(5) NOT NULL default 'True'
);

CREATE TABLE settings (
 	id int(8) primary key auto_increment,
 	name varchar(20) NOT NULL,
 	`value` varchar(60) NOT NULL
);

	INSERT INTO settings VALUES (1, 'website_title', 'sNews 1.5');
	INSERT INTO settings VALUES (2, 'home_sef', 'home');
	INSERT INTO settings VALUES (3, 'website_description', 'sNews CMS');
	INSERT INTO settings VALUES (4, 'website_keywords', 'new, site, snews');
	INSERT INTO settings VALUES (5, 'website_email', 'info@mydomain.com');
	INSERT INTO settings VALUES (6, 'contact_subject', 'Contact Form');
	INSERT INTO settings VALUES (7, 'language', 'EN');
	INSERT INTO settings VALUES (8, 'charset', 'UTF-8');
	INSERT INTO settings VALUES (9, 'date_format', 'd.m.Y. H:i');
	INSERT INTO settings VALUES (10, 'article_limit', '3');
	INSERT INTO settings VALUES (11, 'rss_limit', '5');
	INSERT INTO settings VALUES (12, 'display_page', '');
	INSERT INTO settings VALUES (13, 'display_new_on_home', '');
	INSERT INTO settings VALUES (14, 'display_pagination', '');
	INSERT INTO settings VALUES (15, 'num_categories', 'on');
	INSERT INTO settings VALUES (16, 'approve_comments', '');
	INSERT INTO settings VALUES (17, 'comments_order', 'ASC');
	INSERT INTO settings VALUES (18, 'comment_limit', '30');
	INSERT INTO settings VALUES (19, 'word_filter_enable', '');
	INSERT INTO settings VALUES (20, 'word_filter_file', '');
	INSERT INTO settings VALUES (21, 'word_filter_change', '');
	INSERT INTO settings VALUES (22, 'username', 'test');
	INSERT INTO settings VALUES (23, 'password', '098f6bcd4621d373cade4e832627b4f6');

3. Edit Settings

Edit "snews.php" and enter your settings at the top of the file:

full web site address with trailing slash - http://www.your-domain-name.com/
$db['website'] = 'http://localhost/sNews15/';

MySQL Host - provided by hosting company, usually is "localhost":
$db['dbhost'] = 'localhost';

Database Name - created through phpmyadmin or similar database editor:
$db['dbname'] = 'snews15';

Database Username - created through phpmyadmin or similar database editor:
$db['dbuname'] = 'root';

Database password - created through phpmyadmin or similar database editor:
$db['dbpass'] = '';

Database prefix - created through phpmyadmin or similar database editor, used usually when a hosting company provides only one DB:
$db['prefix'] = '';

Done!

You are ready to go!

Default username is test and password is test

Additional info

Bug reports, suggestions, comments, questions:
Solucija Forum