The following line is a handy tip to allow SIDU from localhost to ssh connect remote site's localhost, when remote database is not allowed connection from a remote IP:

Open a terminal and input the following line:

# ssh -fCTMNS /tmp/sidu_tunnel -p 22 user@remote.ip -L 3307:localhost:3306

You need to check official websites as howto. Here is a quick guide for ubuntu users as howto install Apache2+PHP5, MySQL, PostgreSQL, SQLite, CUBRID, MSSQL

A. Install apache2+php5: windows xampp; ubuntu:
sudo apt-get

Use your existing user table, and only import user_id in to blog_cat.cat = 1001 eg

REPLACE INTO blog_cat(cat,name,info) VALUES
(1001,'blog_staff','{"1":[1,2],"181130":[102,108]}');

staff user id is a json of: catetory and user ids, above means:

cat = 1 (all categories i.e. Admin staff)
user_id = 1, 2

cat = 181130 (i.e. staff or moderators for cat = 181130)
user_id = 102, 108 etc

Default blog will use Topnew MVC and it is using /css/2018.css, 2019.js

However you can overwrite via /blog/blog.css, blog.js

And you can also change view files at: /var/www/app/View/Blog/cat.blade.php, home.blade.php etc

OR you can even make it look totally different via: /blog/index.php:

This table holds all category id (cat) and category name (name or url) and category info (displayed as text)

eg name = news-media
if info = '', info will auto displayed as News Media. So if you want to display something else, you need input here.

cat id 1 .. 99 is reserved for system uses.