Epilogue of Glitch City Laboratories (2003 - 2020)
You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
 
 
 
 
 
Adrian Malacoda eff22ff325 Bolden names of successor websites. 1 month ago
epilogue Prefix image paths with `images` subdirectory (which does not yet exist) 1 month ago
forum add "added submissions" boards from Submit-A-Glitch to exclusion filter 1 month ago
mysql2sqlite@2a759df790 Add mysql2sqlite submodule and script for making a sqlite database out of the mysql dumps. This will be used to create html archives of the forum. 2 months ago
static Add pagination to forums archives. 1 month ago
templates Bolden names of successor websites. 1 month ago
wiki Rudimentary support for building wiki archives. The content is dumped to html but the wikitext isn't parsed yet. 2 months ago
.gitignore Add rudimentary script for generating the forum archive. 2 months ago
.gitmodules Add mysql2sqlite submodule and script for making a sqlite database out of the mysql dumps. This will be used to create html archives of the forum. 2 months ago
README.md Rudimentary support for building wiki archives. The content is dumped to html but the wikitext isn't parsed yet. 2 months ago
deploy_archives Implement rudimentary wikitext renderer and buff deploy_archives script to be able to deploy the wiki archive, as well as sql/sqlite/xml data dumps. 2 months ago
get_pms.php Fix up PM export script 2 months ago
setup.py Begin work on redirector webapp. The logic for redirecting wiki pages -seems- consistent with how the archives are generated but... nginx is normalizing the %2Fs into slashes and therefore not able to access any files with that escape sequence (e.g. Gold%2FSilver). Might need to find another character to escape / with. 2 months ago

README.md

Glitch City Laboratories (2003 - 2020) - Epilogue

This repository contains the tickets, scripts, and documentation for the end of Glitch City Laboratories.

Installation

pip install -e .

Standalone Epilogue Scripts

deploy_archives

Run this once the archives have been built to tar them up and scp them to the server.

Wiki Data (wiki directory)

wiki_pages

Not a script, just a listing of all the pages in the wiki (as of the 27 July 2020 lockdown). Use this and Special:Export to create an XML dump of wiki pages and place it in the wiki directory.

find_pages

Run this locally (it uses the MediaWiki HTTP API). Finds all pages in categories related to Pokemon generations 1 - 4 that have been edited since 31 March 2020.

Forum Data (forum directory)

dump_forum_data

Run this on a server with access to a Glitch City Laboratories database. It will dump the table schemas and data into several .sql files. Place these in the forum directory.

create_sqlite_database

Run this locally, after the dump_forum_data script has been run on the Glitch City Laboratories server and the dumps copied to the forum directory (same directory as this script). A file called forum.sqlite will be generated from the MariaDB dumps. This sqlite database is required for generating the static archive later.

Make sure the mysql2sqlite submodule is initialized and install mawk for the best results.

Epilogue Package

Misc Scripts

get_pms.php

This is installed on Glitch City Laboratories and allows any logged-in user to export their PM inbox into a HTML export.