Difference between revisions of "DRAFT1846 Implementation Guide"

From BOARD18 Project WIKI
Jump to navigation Jump to search
m
(→‎The DRAFT1846 Database: initial contents)
Line 18: Line 18:


== The DRAFT1846 Database ==
== The DRAFT1846 Database ==
Before starting this task, you will have to create a new (empty) MYSQL database on your DB server. <br>
'''How to do this varies and is beyond the scope of this how to document.'''
But I do suggest that you create '''two''' usernames for access to this database. The first or "root user" should have complete access to the database and should be used to create and load it. <br>
The second or "draft1846 user" should be limited to select, insert and update access. This is the username that you will put in the config.php file in the '''php''' sub directory of the web root directory. <br>
The draft1846 web application will use this second username. It is called "draft1846" in the supplied php/config.php file. <br>
The following commands can be used to create this username '''if the database resides on the web server''':
<pre>
CREATE USER 'draft1846'@'localhost' IDENTIFIED BY 'draft1846';
GRANT SELECT, INSERT, UPDATE ON draft1846.* TO 'draft1846'@'localhost';
</pre>
<span style="color: Green">Many web hosting providers [such as dreamhost] provide web pages that have all the capabilities needed to create a database and its associated usernames.</span>


== Installing DRAFT1846 ==
== Installing DRAFT1846 ==

Revision as of 14:50, 31 May 2020

DRAFT1846 is what could be called an "add on" to BOARD18.
It is the result of a separate project and only applies to one game, 1846.
This guide is directed at someone who wishes to install a copy on their own site.

This guide assume that you already have shell access to a server environment that is running Apache with PHP version 5.3 or later and MySQL version 5.5 or later.
You first have to decide whether to create a new domain for the application or to put it on a sub directory of an existing domain.
In this guide, the directory that you choose to use will be referred to as the web root directory regardless of whether it is really a root or not.

The work of setting up a domain is well documented and quite beyond the scope of this guide. So it will be assumed that this work has been done.

Where To Get DRAFT1846

The latest version of DRAFT1846 is available as a zip file in this folder

The DRAFT1846 Database

Before starting this task, you will have to create a new (empty) MYSQL database on your DB server.
How to do this varies and is beyond the scope of this how to document.

But I do suggest that you create two usernames for access to this database. The first or "root user" should have complete access to the database and should be used to create and load it.
The second or "draft1846 user" should be limited to select, insert and update access. This is the username that you will put in the config.php file in the php sub directory of the web root directory.
The draft1846 web application will use this second username. It is called "draft1846" in the supplied php/config.php file.
The following commands can be used to create this username if the database resides on the web server:

 
CREATE USER 'draft1846'@'localhost' IDENTIFIED BY 'draft1846';
GRANT SELECT, INSERT, UPDATE ON draft1846.* TO 'draft1846'@'localhost';

Many web hosting providers [such as dreamhost] provide web pages that have all the capabilities needed to create a database and its associated usernames.

Installing DRAFT1846

Configuring DRAFT1846

Upgrading DRAFT1846


This page is a stub.
The BOARD18 Project will soon be expanding it.