@tooblue tooblue released this Jul 13, 2014 · 18 commits to master since this release

Assets 2
  • Fixed archived logs bug - it's safe to use the "archive" buttons again!
  • Added 'format' field to 'cards' and 'collecting' tables. You can now specify unique file formats for each category and collecting deck.
  • Added an option to reset your password from the login screen.
  • Major UI overhaul - eTCG is now responsive!
  • Fix for cards being sent to wrong collecting deck (the query now checks for an exact match, instead of just a "similar" match).
  • Improved the regex used to match cards and extract deck names.
  • Added 'config.php' to consolidate database credential definitions.
  • Created "Upload" object in 'class_lib.php' to modularize code used to upload card images.
  • Added an include for 'mods.php' within 'func.php'. You can make changes to core 'func.php' methods within 'mods.php' to avoid losing your changes when upgrading eTCG.
  • Switched all mysql (deprecated) to mysqli.
  • Email address removed from "From" email headers in outgoing mail. (So basically, the "Dreamhost" fix is implemented automatically)
  • Additional Fields are now textareas to allow for more flexible data storage.

If you are upgrading from a previous version, you will need to run the following query on your eTCG database to add the new 'format' fields:

ALTER TABLE `cards` ADD `format` VARCHAR(8) NOT NULL DEFAULT 'default' AFTER `autourl`;
ALTER TABLE `collecting` ADD `format` VARCHAR(8) NOT NULL DEFAULT 'default' AFTER `uploadurl`;

Or your can paste the following code into a blank PHP document. Fill out your database information at the top, and make sure you only visit the page once!

<?php
$link = mysqli_connect("localhost", "my_user", "my_password", "world");

if (mysqli_connect_errno()) {
    printf("Connect failed: %s\n", mysqli_connect_error());
    exit();
}

if (mysqli_query($link, "ALTER TABLE `cards` ADD `format` VARCHAR(8) NOT NULL DEFAULT 'default' AFTER `autourl`") === TRUE) {
    printf("'format' field successfully added to 'cards' table.\n");
}

if (mysqli_query($link, "ALTER TABLE `collecting` ADD `format` VARCHAR(8) NOT NULL DEFAULT 'default' AFTER `uploadurl`") === TRUE) {
    printf("'format' field successfully added to 'collecting' table.\n");
}
?>

Also, while the "Upgrade" instructions in the wiki state that you should delete the config.php file, since this is the first version in which it's used you'll actually need to keep it. Copy your database information and password salt from your old class_lib.php file into the new config.php file.