App for collecting and viewing tetris results
Clone or download
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Type Name Latest commit message Commit time
Failed to load latest commit information.
assets
bin
config
dev
lib
reports
sql
templates
test
vendor/redisent-master
.gitignore
.travis.yml
CHANGELOG.md
Dockerfile
IDEAS.md
README.md
VERSION
apple-touch-icon-114x114-precomposed.png
apple-touch-icon-144x144-precomposed.png
apple-touch-icon-57x57-precomposed.png
apple-touch-icon-72x72-precomposed.png
apple-touch-icon-precomposed.png
apple-touch-icon.png
favicon.ico
health.php
index.php
match.php
matchinfo.php
php.ini
playerinfo.php

README.md

Tetris-DB

web scripts for collecting and viewing Tetris data from The New Tetris on Nintendo 64

build status

test

./bin/test

Screenshots

Index Match Entry Console Summary Report Individual Report Options Individual Report Calendar Collection Report Lines Collection Report Match Strength report Performance Rarity Report Win Expectancy Report

run locally with docker

docker run --rm -it -e -p 9000:80 dokku/tetris-db:0.12.0

browse: http://localhost:9000

app/db initial installation

# create app
ssh tom@dokku.dev "dokku apps:create tetris-db"

# create db
ssh tom@dokku.dev "sudo dokku plugin:install https://github.com/dokku/dokku-mariadb.git mariadb"
ssh tom@dokku.dev "dokku mariadb:create tetris-db"

# load data snapshot into db
aws --profile personal s3 cp s3://tph-etc/tetris-data/tnt.sql .
scp tnt-data.sql tom@dokku.dev:~/
ssh tom@dokku.dev "dokku mariadb:import tetris-db < tnt-data.sql"

# link db to app
dokku mariadb:link tetris-db tetris-db

build/release

docker build . -t dokku/tetris-db:0.12.0
docker save dokku/tetris-db:0.12.0 | bzip2 | ssh tom@dokku.dev "bunzip2 | sudo docker load"
ssh tom@dokku.dev "dokku tags:deploy tetris-db 0.12.0"

tls

ssh tom@dokku.dev "sudo dokku plugin:install https://github.com/dokku/dokku-letsencrypt.git"

ssh tom@dokku.dev "dokku config:set --no-restart tetris-db DOKKU_LETSENCRYPT_EMAIL=tphummel@gmail.com"

ssh tom@dokku.dev "dokku letsencrypt tetris-db"

Routes/Views

  • index.php
  • match.php
  • rptSummary.php

rptCollab.php rptPerfDist.php rptPerformance.php

matchinfo.php playerinfo.php

helpers

lib/statPower.php comprank.php lib/points.inc.php lib/grade.php lib/rankings.inc.php

templates

header.php footer.php

old/archived/dev

rptCareer.php rptCollabOld.php editmatch.php manageplayer.php include/location, match, player, playermatch