$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'];