<?php
require '../config.php';
require '../engine/database/connect.php';
?>
<h1>Znote AAC shop points to Gesior and Modern shop points</h1>
<p>Convert donation/shop points from previous Znote AAC installation to Gesior/Modern:</p>
<?php
$accounts = mysql_select_multi("SELECT `account_id`, `points` FROM `znote_accounts` WHERE `points`>'0';");
$accountids = array();
foreach ($accounts as $acc) $accountids[] = $acc['account_id'];
$accidlist = join(',',$accountids);
if ($accounts !== false) echo "<p>Detected: ". count($accounts) ." accounts who have points in old system.</p>";
else die("<h1>All accounts already converted. :)</h1>");
$znote_accounts = mysql_select_multi("SELECT `id`, `premium_points` FROM `accounts` WHERE `id` IN ($accidlist);");
if (count($accounts) !== count($znote_accounts)) die("<h1><font color='red'>Failed to syncronize accounts. You need to convert all accounts to Gesior/Modern first!</font></h1>");
// Order old accounts by id.
$idaccounts = array();
foreach ($accounts as $acc) {
$idaccounts[$acc['account_id']] = $acc['points'];
}
foreach ($znote_accounts as $acc) {
mysql_update("UPDATE `accounts` SET `premium_points`='". ($acc['premium_points'] + $idaccounts[$acc['id']]) ."' WHERE `id`='". $acc['id'] ."' LIMIT 1;");
}
mysql_update("UPDATE `znote_accounts` SET `points`='0';");
echo "<h1><font color='green'>Successfully converted all points!</font></h1>";
?>