Flare Bible Study

http://flare.hispattern.com

An App Intended for Presentations and Fit for Scriptural Research

Here you will find an app that can map cross references and subjects at the same time, in a couple of ways. You will need to create your own additional data maps using the respective JSON files.

Currently flare uses only public domain bible translations:

• American Standard-ASV1901 (ASV)
• Bible in Basic English (BBE)
• Darby English Bible (DARBY)
• King James Version (KJV)
• Webster's Bible (WBT)
• World English Bible (WEB)
• Young's Literal Translation (YLT)

Contributing cross references: At a bare minimum, you will need to know some basic JSON programming to create new content. Feel free to use the additional JSON files at http://flare.hispattern.com for a launching point.

Contributing Code: JavaScript, jQuery, JSON are the primary technologies used, with HTML and CSS for layout and styling. However AJAX, PHP, and MySQL are also involved.

---

To Get Started, You'll Need:

1. WAMP or LAMP (I'm running Apache2 with a localhost setup in Linux for development)
2. MySQL (I'm running mysqlnd 5.0.12-dev)
3. PHP7 (I'm running PHP 7.2)
4. All of the sql files beginning with t_ at https://github.com/scrollmapper/bible_databases/tree/master/sql

---

Todo's:

By the 3rd Quarter of 2019:

• Create similar editing interface to create JSON files with the visual aid. they are currently programmed one line at a time.
• Get out of the demo stage for JSON data - I've created the cross referencing in para.json and flare-OldTestamentJesus1.json on my own.

In the 4th Quarter of 2019:

• Convert the project using Vue Native for mobile
  • Convert to using JSON or SQLite bible databases for use in Android

---

Technical Summary:

• / (HTML)
  • index.html is the latest chart being developed, the data is only demo data and not fully fledged out.
  • Jesus-in-the-old-testament.html (HTML) this uses the hierarchical edge bundling chart (hierarchical many to many relationships) which is great for subject mapping and for presentations. A copy of this page can host different chart data by modifying the JSON file name near the end of the document.
• /assets/css/ (CSS)
  • flare.css contains:
    • Flare specific CSS for both HTML pages
    • Dashboard style mods (near the end of the document)
  • style.css contains dashboard specific CSS.
  • components.css contains dashboard specific CSS
• /assets/js/ (JavaScript)
  • flare.js contains:
    • D3.js v4 Arc Chart functionality, extended from bibviz interesting history: bible viz.
  • flare-biblestudy.js contains:
    • D3.js v3 Hierarchical Edge Bundling Chart functionality
    • REGEX functions for identifying bible verses on the page
    • AJAX for returning HTML on ajax.php upon making an HTTP GET request.
  • functions.js contains primarily dashboard functionality, but the end of the file also has document ready javascript used by both HTML pages.
• /assets/json/ (JSON)
  • para.json contains demo data used for cross references in index.html. This is the one you can modify for your own cross reference threads.
  • flare-OldTestamentJesus1.json contains demo data for cross references and subject mapping in . They are called from their respective pages.
  • kjv.json contains bible stats based on data from the King James translation.
• /assets/database/ (PHP/MySQL)
  • ajax.php uses HTTP GET parameters to wrap specified scriptures in HTML. Creates a Librarian object, prepares statements, and specifies the translation to query. un-comment the error checking statements (don't move them) to troubleshoot
  • bible_to_sql_service.php Librarian extends Servant. Only upon successful preparation of a statement can Librarian query the database. use the construct function in Servant to specify host, user, password, and database. **Both classes contain extra functions for testing

---

Bible Database Setup

bible_database sql files

You will need to import the t_ sql files from https://github.com/scrollmapper/bible_databases/tree/master/sql into the database you create for the project.

phpMyAdmin

The easiest way to do this is use phpMyAdmin:

1. Create a database named bible_db

2. Create a user named bible (or name them whatever you want for that matter. Just modify the Servant class construct function accordingly (bible_to_sql_service.php).

3. Edit privileges for your user using the database bible_db, and grant all data and structure privileges.

4. Import the sql files into the database (be sure to select the database first) using the import tab.

5. Make sure you modify the Servant class construct function (bible_to_sql_service.php) to match your host, user, password, and database.

MySQL Statements

First login with your root account.

1. Create a localhost user: for example, with the name bible (replace YOURPASSWORDHERE with your own, but keep the hyphens):

CREATE USER 'bible'@'localhost' IDENTIFIED BY 'YOURPASSWORDHERE';

2. Create a database named bible_db:

CREATE DATABASE bible_db;

3. Grant just enough privileges for the user bible to manage the database:

GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, CREATE TEMPORARY TABLES, CREATE VIEW, EVENT, TRIGGER, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, EXECUTE ON bible_db.* TO 'bible'@'localhost';

4. Import the SQL files into the database. For example, using a shell / bash command line from within the sql file containing folder: this uses the mysql root user to import the king james version sql file into a database named bible_db

mysql -u root -p bible_db < t_kjv.sql

5. Make sure you modify the Servant class construct function (bible_to_sql_service.php) to match your host, user, password, and database.

Setup Troubleshooting for PHP & MySQL

Un-comment the logging statements in ajax.php, so the top of the file looks like this: <?php ini_set('display_errors', 1);/// prints ERROR LOGGING to the page error_reporting(E_ALL);/// prints ERROR LOGGING to the page

Reload your page and use the errors to correct or ask for help.

---

Sources:

Flare is based on features from these projects:

• (Scriptures) PHP and MySQL from my PHP7 complient fork of scrollmapper/bible_databases
• (SQL Databases) The SQL bible databases, also available in my PHP7 complient fork of scrollmapper/bible_databases
• (Charts) D3.js Data Visualization library https://github.com/d3/d3
  • A D3.js v4 Arc Chart with bible chapter lengths first visualized in a colaboration between Carnegie Mellon professor Chris Harrison and Lutheren pastor Christoph Römhild. The Flare arc chart (flare.js) used in index.html is based on https://github.com/danielgtaylor/bibviz/blob/master/web/contents/scripts/main.js
    • Other resources: https://observablehq.com/@d3/arc-diagram and https://www.d3-graph-gallery.com/arc
  • A D3.js v3 Hierarchical Edge Bundling chart (JavaScript) from https://observablehq.com/@d3/hierarchical-edge-bundling
• (REGEX) jQuery Biblify a very robust way to find verses on a page, and originally built to replace the text with links to pages with the scritpures using AJAX.
• (Dashboard Styles and Functionality) Flare uses a modified version of the Stisla dashboard theme

---

LICENSE:

Flare is under the MIT License