$gid = "root";
$emoncms_dir = "/var/www/emoncms";
$timeseries_dir = "/var/lib/phptimeseries/";
if (!file_exists($emoncms_dir)) {
print "Could not open " . $emoncms_dir . "\n";
die;
}
if (!file_exists($timeseries_dir)) {
print "Could not open " . $timeseries_dir . "\n";
die;
}
chdir($emoncms_dir);
require "process_settings.php";
$mysqli = @new mysqli($server, $username, $password, $database);
require "PHPTimeSeries.php";
$engine = new PHPTimeSeries(array('datadir' => $timeseries_dir));
$result = $mysqli->query("SELECT * FROM feeds WHERE `engine`= 0 AND `datatype`= 2");
print "There are " . $result->num_rows . " feeds to convert, would you like to continue?(y/n) ";
$handle = fopen("php://stdin", "r");
$line = fgets($handle);
if (trim($line) != 'y') {
exit;
}
print "\n";
print "Do you want to create a CSV backup in your PHPTimeSeries folder?(y/n) ";
$handle = fopen("php://stdin", "r");
$do_backup = fgets($handle);
print "\n";
while ($row = $result->fetch_array()) {
print "userid:" . $row['userid'] . " feed:" . $row['id'] . " name:" . $row['name'] . "\n";
$id = $row['id'];
<h3>Emoncms migration script</h3>
<p>From v6 & v7 to v8.5</p>
<pre>
<?php
set_time_limit(600);
define('EMONCMS_EXEC', 1);
require "process_settings.php";
require "core.php";
require "Modules/log/EmonLogger.php";
$phpfina_dir = $feed_settings['phpfina']['datadir'];
$phptimeseries_dir = $feed_settings['phptimeseries']['datadir'];
$mysqli = @new mysqli($server, $username, $password, $database);
require "Modules/feed/engine/PHPTimeSeries.php";
$phptimeseries = new PHPTimeSeries(array('datadir' => $phptimeseries_dir));
if ($mysqli->connect_error) {
print "Error connecting to mysql database<br>";
exit;
} else {
print "Connected to mysql database: {$database}\n";
}
if (class_exists('Redis') && $redis_enabled) {
$redis = new Redis();
$connected = $redis->connect("127.0.0.1");
if (!$connected) {
print "Can't connect to redis database\n";
} else {
print "Connected to redis-server\n";
}
} else {
