Installing sNews 1.6

Once you have verified your system meets the System Requirements and you’ve downloaded the sNews package, you’re ready to install sNews!

sNews 1.6 can be installed in 3 simple steps:

1. Setup the Database
Most hosts have a utility that allows you to populate your database.
Create the MySQL database tables with the following code:
[If you are going to use a prefix on your tables, now is the time to put it in place. eg, CREATE TABLE snews_articles ( ]

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(255) default NULL,
  	keywords_meta varchar(255) default NULL
);
CREATE TABLE categories (
  	id int(8) primary key auto_increment,
 	name varchar(100) NOT NULL,
 	seftitle varchar(100) NOT NULL,
 	description varchar(255) 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.6');
	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', '098f6bcd4621d373cade4e832627b4f6');
	INSERT INTO settings VALUES (23, 'password', '098f6bcd4621d373cade4e832627b4f6');
	INSERT INTO settings VALUES (24, 'system_email', 'admin@mydomain.com');
	INSERT INTO settings VALUES (25, 'system_name', 'Site Admin');

2. Edit Settings
Open the snews.php file with your preferred text editor 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/sNews/’;

MySQL Host – provided by hosting company, usually is “localhost”:
$db[‘dbhost’] = ‘localhost’;

Database Name – created through phpmyadmin or similar database editor:
$db[‘dbname’] = ‘snews’;

Database Username – created through phpmyadmin or similar database editor:
$db[‘dbuname’] = ‘username’;

Database password – created through phpmyadmin or similar database editor:
$db[‘dbpass’] = ‘password’;

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

3. Upload Files
Copy all the files from sNews 1.6 package to your server and CHMOD 777 the folder where you will upload your images (eg. img).

You’re Done!
You are now ready to experience the world of sNews CMS!
The default username is test and password is test. remember to change these when you first login!
Login to start adding content and managing your new sNews CMS powered website!

Should you experience any issues installing sNews, please take a moment to view the Help Section. If you cannot find the information you require, visit the sNews Forums where the sNews crew will be able to offer their assistance.

Have fun!