Mendownload sNews

Meng-ekstrak file zip

Selesai download, diekstrak ya ….

Membuat Database

Masuk ke sesi pembuatan database, silahkan login ke MySQL/phpmyadmin webhosting Anda. Buat sebuah database dengan nama terserah Anda. Contoh : snews.

Suntikan perintah sql berikut ini :

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′);

Membuat database baru

Suntik perintah SQL ke database

Kemudian upload semua file kehosting mu. Gak punya hosting ? Beli dong ! Eh, cari yang gratisan juga boleh, selama mendukung PHP dan MySql. sNews tidak terlalu memakan banyak space.

Selesai. Lihat homepage Anda, login ke Admin Panel untuk melakukan setting.

Memodifikasi Template

Default template bawaan paket download adalah Minimal Template. Anda dapat membuat sendiri template sesuai keinginan dengan mudah. Mari kita coba bersama. Cari korban contoh template yang akan kita ‘permak’ menjadi template sNews. Jika sudah terbiasa dengan css dan html, lebih baik lagi jika Anda mengkreasi sendiri template. Kita cari jalan mudah. Oke ?! …bersambung… (buat ripiu dulu) :ngacir:

Tags: Blogging, menginstal snews, snews, snews tips