Heroesstatistik

Heroesstatistik is the third external website to take on the task of providing extensive historical standings and statistics for the Danish browser game Heroes. I launched it after both of the predecessors known as Virasun and Runerne respectively seized to be updated.

The website automatically fetches the HTML pages with standings and rankings for individual players as well as clans when the game rounds end. The HTML is parsed and the data is stored in a database requiring only a single click from an administrator to let the update go live.

Front and back end are made using HTML, CSS and MySQL, using regular expressions for parsing the HTML. The dataset is rather large involving hundreds of thousands of database rows, instigating thorough considerations about indices and optimizations.

The site also provides the opportunity for players to generate an image with their game history. Images are generated using the GD library of PHP and cached to reduce server load.

Technologies used: PHP, MySQL, HTML, CSS, Facebook-integration