$con = new AngoraMySQL();
}
$con->setCon(base64_decode($data['dbHost']), base64_decode($data['dbUsername']), base64_decode($data['dbPassword']), base64_decode($data['dbDatabase']));
$data['dbPrefixDecoded'] = base64_decode($data['dbPrefix']);
$dbTables['config'] = $data['dbPrefixDecoded'] . "config";
$dbTables['admin'] = $data['dbPrefixDecoded'] . "admin";
$dbTables['trash'] = $data['dbPrefixDecoded'] . "trash";
$dbTables['reply'] = $data['dbPrefixDecoded'] . "reply";
$dbTables['posts'] = $data['dbPrefixDecoded'] . "posts";
$dbTables['censored'] = $data['dbPrefixDecoded'] . "censored";
$dbTables['smilies'] = $data['dbPrefixDecoded'] . "smilies";
$dbTables['ip'] = $data['dbPrefixDecoded'] . "ip";
$dbTables['backupLog'] = $data['dbPrefixDecoded'] . "backupLog";
unset($data['dbPrefixDecoded']);
$con->connect();
$con->getRows("Select * from " . $dbTables['config'] . ";");
foreach ($con->queryResult as $res) {
$config['id'] = $res['id'];
$config['guestbookTheme'] = $res['guestbookTheme'];
$config['guestbookLang'] = $res['guestbookLang'];
$config['adminLang'] = $res['adminLang'];
$config['mobileTheme'] = $res['mobileTheme'];
$config['metaDescription'] = $res['metaDescription'];
$config['metaKeywords'] = $res['metaKeywords'];
$config['offline'] = $res['offline'];
$config['offlineMessage'] = $res['offlineMessage'];
$config['checkCaptcha'] = $res['checkCaptcha'];
$config['reCaptcha'] = $res['reCaptcha'];
$config['reCaptchapubk'] = $res['reCaptchapubk'];
$config['reCaptchaprvk'] = $res['reCaptchaprvk'];
$config['pagesFormat'] = $res['pagesFormat'];
$db_backup = $pre . "backup";
$dbTables['config'] = $installCheck['prefix'] . "config";
$dbTables['admin'] = $installCheck['prefix'] . "admin";
$dbTables['trash'] = $installCheck['prefix'] . "trash";
$dbTables['reply'] = $installCheck['prefix'] . "reply";
$dbTables['posts'] = $installCheck['prefix'] . "posts";
$dbTables['censored'] = $installCheck['prefix'] . "censored";
$dbTables['smilies'] = $installCheck['prefix'] . "smilies";
$dbTables['ip'] = $installCheck['prefix'] . "ip";
$dbTables['backupLog'] = $installCheck['prefix'] . "backupLog";
echo "<div class=\"title\">" . $lang['convertTables'] . "</div>";
$con->connect();
// Posts table
$resultPosts = true;
$queryMsg = "Select * from {$db_posts}";
$con->getRows($queryMsg);
foreach ($con->queryResult as $res) {
if ($res['publish'] == "true") {
$newPublish = 1;
} else {
$newPublish = 0;
}
$queryMsg = "Insert into " . $dbTables['posts'] . "\n\t\t\t\t\t(id, name, country, date, location, email, message, useragent, rating, publish, ip)\n\t\t\t\t\t values (\n\t\t\t\t\t'" . secureVar($res['id'], 'sql') . "',\n\t\t\t\t\t'" . secureVar($res['name'], 'sql') . "',\n\t\t\t\t\t'" . secureVar($res['flag'], 'sql') . "',\n\t\t\t\t\t'" . secureVar($res['date'], 'sql') . "',\n\t\t\t\t\t'" . secureVar($res['country'], 'sql') . "',\n\t\t\t\t\t'" . secureVar($res['email'], 'sql') . "',\n\t\t\t\t\t'" . secureVar($res['message'], 'sql') . "',\n\t\t\t\t\t'" . secureVar($res['useragent'], 'sql') . "',\n\t\t\t\t\t'" . secureVar($res['stars'], 'sql') . "',\n\t\t\t\t\t'" . secureVar($newPublish, 'sql') . "',\n\t\t\t\t\t'" . secureVar($res['ip'], 'sql') . "');";
if (!$con->modify($queryMsg)) {
$resultPosts = false;
$con->printError();
}
}
echo 'Posts.....';
if ($resultPosts) {
echo $lang['ok'];
