diff options
Diffstat (limited to 'install/upgrade.php')
| -rw-r--r-- | install/upgrade.php | 22 |
1 files changed, 22 insertions, 0 deletions
diff --git a/install/upgrade.php b/install/upgrade.php index e145ba7..78f5dff 100644 --- a/install/upgrade.php +++ b/install/upgrade.php @@ -86,6 +86,28 @@ if (isset($_GET['upgrade'])) { } } + if (lower_version($_GET['upgrade'], '0.4.2')) { + try { + $_pdo->query("CREATE TABLE IF NOT EXISTS `".constants::db_prefix."payment` ( + `id` smallint(5) unsigned NOT NULL, + `offerId` smallint(5) unsigned NOT NULL, + `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP + ) ENGINE=InnoDB DEFAULT CHARSET=latin1;"); + + $offers = $_pdo->query("SELECT `id`,`payment_received` FROM `".constants::db_prefix."offer` WHERE `payment_received` IS NOT NULL"); + $offers = $offers->fetchAll(PDO::FETCH_ASSOC); + foreach ($offers as $offer) { + $received = $offer['payment_received']; + $offer = new offer($_pdo, $offer['id']); + $offer->createPayment($received); + } + + $_pdo->query("ALTER TABLE `".constants::db_prefix."offer` DROP `payment_received`;"); + } catch (PDOException $e) { + echo "Altering the database structure failed with a PDOException ({$e->getCode()}): {$e->getMessage()}<br/>" . $e->getTraceAsString(); + } + } + echo "<br/>All done."; } ?> |