• Go into the directory where your server will reside
• Fork the repo and clone it: git clone https://[email protected]/yourname/dtdb.git
• This creates a directory named dtdb. This has to be your apache DOCROOT.
• Go into it.
• Install Composer: curl -s http://getcomposer.org/installer | php
• Install the vendor libs: php composer.phar install
• Create the database: php app/console doctrine:database:create
• Create the tables: php app/console doctrine:schema:update --force
• If the above command fails, edit app/config/parameters.yml and try again
• execute php app/console assets:install --symlink
• Import the data: mysql -u root -p dtdb< dtdb-cards.sql
• Configure your web server with the correct DocRoot
• Point your browser to /web/app_dev.php

When you update your repository, run the following commands:

• php composer.phar self-update
• php composer.phar update
• php app/console doctrine:schema:update --force
• php app/console cache:clear --env=dev

To update the deck of the week on the front page:

• php app/console highlight

• register
• if you haven't setup mail delivery, manually activate your account
• run php app/console fos:user:promote --super <username>

• login with admin-level account
• go to /admin/card, /admin/pack, /admin/cycle, etc.

• note the code of the pack (ntnr for New Town New Rules, etc.). let's say it's xxx
• login with admin-level account
• go to /api/set/xxx.xls
• open the downloaded file and add your cards
• go to /admin/excel/form and upload your file, click 'Validate' on confirmation screen
• actually the excel file can be the one from another pack, just replace the 2nd column

• your php module must be configured with mbstring.internal_encoding = UTF-8