Skip to content

ChooJeremy/PoxBrain

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

98 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

PoxBrain

PoxBrain is a database to aid users through the complex game of PoxNora! There have been many other sites like this created, such as PoxPulse and PoxBase, but they all haven't been updated for quite a while and have lost active support, so PoxBrain aims to be the new PoxNora aid. This project is no longer being worked on since I am no longer actively playing the game. If you're interested, feel free ot take it up!

Design inspired by NetrunnerDB

Features

  • A page that shows details about a rune, ability, mechanic or condition
  • Search suggestions as you type on the search bar. Potential search suggestions are loaded locally.
  • Ability to search for runes, sorted by relevancy to search results.
  • Filter search results by rarity, faction and rune Type
  • Accounts for users.
    • Users are able to track their collection on PoxNora in PoxBrain
    • Display owned amount of search suggestions and results

Planned Features

In no particular order,

  • Work with PoxBox to display rune price on PoxBox
  • Accounts for users.
    • Collection statistics for themselves
    • Anonymous aggregated statistics
    • JS code to 'shard' runes that are extras, with certain criterias
    • Show runes that are worth 'sharding' based on PoxBox price. Show other runes that are best sent to PoxBox instead.
    • Other ways to browse their collection than the editor in PoxNora
  • BattleGroups creation and sharing
    • Writeups like NetrunnerDB for their own BG
    • Linking with collection to show which rune you own and don't
    • JS code to create a new BG on PoxNora based on the BG shown in PoxBrain
  • Achievement Helper
    • Enter achievement conditions and find runes that fit that criteria
    • Link with user accounts to only show runes that the user owns

Contributing

Download the repo. You'll need a server, we currently use a LAMP stack. We also currently use SendGrid to send our emails, namely the emails for accounts. You can either follow and create a SendGrid account as well, or utilize your own, or choose to remove the feature entirely. If you choose not to use SendGrid, you can edit the codes that send email, all of which are located under the /accounts/ folder. If you choose to use SendGrid, you'll need an API key to be specified, in the same place that we specify our database connection below. You'll have to initalize the database with the required tables. The SQL code required to generate these tables (imported from phpmyadmin) can be found at dbinit.sql You'll also need to specify how to connect to the sql database. Currently the codes use mysqli to connect. You'll have to create a mysqlaccess.php file in the root folder, with the following structure:

<?php
$host = "127.0.0.1";
$user = "username";
$pass = "mypassword";
$db = "dbname";
$port = 80;
$sendGridAPIKey = "SG.yoursendgridapikey";

$userdb = "user_accounts";
$mysqli = mysqli_connect($host, $user, $pass, $db, $port)or die(mysql_error());

require 'vendor/vendor/autoload.php';

$authDB = new PDO('mysql:dbname='.$userdb.';host='.$host.';port='.$port.';charset=utf8mb4', $user, $pass);
$auth = new \Delight\Auth\Auth($authDB);
?>

This will allow all the codes to use your database. Once you've started the database, you'll need to update it. Simply run update.php (preferably from the command line, so you get the echo'ed messages as they come) to populate the database with the necessary information. You may receive a message saying something like $_SERVER["REMOTE_ADDR"] is not defined, ignore it, it's basically saying it can't find the other party's IP address (normal as you're running from the own machine). Once done, the website should run normally. PHP Auth is inside the repo already, located under ./vendor/vendor/delight-im

Note: this repo contains a .htaccess so that it can be installed directly into the server www/ directory. If installed correctly with .htaccess files enabled, it will return 404 on attempts to access files that do not pertain to the site.

About

A database for an online game, PoxNora

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published