? Comments - Answer Overflow

Explore posts from servers

•Created by ? on 8/16/2024 in #help-me

Any way to merge .sqlite files?

Unfortunately I don't see a "Unsolved" or "Not resolved" tag to mark this post as unresolved

14 replies

DHDistant Horizons

•Created by ? on 8/16/2024 in #help-me

Any way to merge .sqlite files?

So I think it's possible but not worth efforts in my case, anyway, thank you a lot for your assistance! @majo24

14 replies

DHDistant Horizons

•Created by ? on 8/16/2024 in #help-me

Any way to merge .sqlite files?

using System;
using Microsoft.Data.Sqlite;

namespace merge_databases
{
    internal class Program
    {
        static void Main()
        {
            using SqliteConnection //oldDb = new(@"Data Source=C:\Users\0x3F\AppData\Roaming\.minecraft\Distant_Horizons_server_data\MERGE_OLD\overworld\DistantHorizons.sqlite"),
                newDb = new(@"Data Source=C:\Users\0x3F\AppData\Roaming\.minecraft\Distant_Horizons_server_data\MERGE_NEW\overworld\DistantHorizons.sqlite");
            //oldDb.Open();
            newDb.Open();

            SqliteCommand command = newDb.CreateCommand();
            command.CommandText = "SELECT * FROM FullData";

            using SqliteDataReader reader = command.ExecuteReader();
            
            while(reader.Read())
            {
                Console.Write(reader.GetString(0));
            }

            Console.ReadKey();
        }
    }
}

using System;
using Microsoft.Data.Sqlite;

namespace merge_databases
{
    internal class Program
    {
        static void Main()
        {
            using SqliteConnection //oldDb = new(@"Data Source=C:\Users\0x3F\AppData\Roaming\.minecraft\Distant_Horizons_server_data\MERGE_OLD\overworld\DistantHorizons.sqlite"),
                newDb = new(@"Data Source=C:\Users\0x3F\AppData\Roaming\.minecraft\Distant_Horizons_server_data\MERGE_NEW\overworld\DistantHorizons.sqlite");
            //oldDb.Open();
            newDb.Open();

            SqliteCommand command = newDb.CreateCommand();
            command.CommandText = "SELECT * FROM FullData";

            using SqliteDataReader reader = command.ExecuteReader();
            
            while(reader.Read())
            {
                Console.Write(reader.GetString(0));
            }

            Console.ReadKey();
        }
    }
}

Okay, well... I was able to open the database and read some data but I get hundreds of "random" digits I have no idea what to do with... I think it'd be easier if I'll just re-explore the terrain I explored after renaming the server, it would be a 20-30 mins hustle but I have a feeling programming a merging tool would take me days...

14 replies

DHDistant Horizons

•Created by ? on 8/16/2024 in #help-me

Any way to merge .sqlite files?

I get exception errors because no such table exists and I dunno what are table names in the .sqlite file

14 replies

DHDistant Horizons

•Created by ? on 8/16/2024 in #help-me

Any way to merge .sqlite files?

command.CommandText = "select * from DistantHorizons"; // no such table as "DistantHorizons"

command.CommandText = "select * from DistantHorizons"; // no such table as "DistantHorizons"

Thank you @majo24@Miki_P98 I am close to create something in C# but I don't know much about SQL, how can I know what's the table name?

14 replies

DHDistant Horizons

•Created by ? on 8/16/2024 in #help-me

Any way to merge .sqlite files?

Give me some time, I am trying on some C# solution :Loading:

14 replies

DHDistant Horizons

•Created by ? on 8/16/2024 in #help-me

Any way to merge .sqlite files?

Uh, I know nothing about Python but I used to create applications in C#, is that possible to do in C# ? Or C++ ?

14 replies

DHDistant Horizons

•Created by ? on 1/25/2024 in #help-me

java.lang.IndexOutOfBoundsException: QuadTree GetOrSet failed

After restarting, the game and DH works fine though

3 replies

DHDistant Horizons

•Created by ? on 1/25/2024 in #help-me

java.lang.IndexOutOfBoundsException: QuadTree GetOrSet failed

§uERROR: Distant Horizons renderer has encountered an exception!
Renderer is now disabled to prevent further issues.
Exception detail: java.lang.IndexOutOfBoundsException: QuadTree GetOrSet failed. Position out of bounds, min pos: (0, -6334), max pos: (8192, 1858), min detail level: 6, max detail level: 13. Given Position: {13*1,-1} = block pos: {0*8192,-8192}

§uERROR: Distant Horizons renderer has encountered an exception!
Renderer is now disabled to prevent further issues.
Exception detail: java.lang.IndexOutOfBoundsException: QuadTree GetOrSet failed. Position out of bounds, min pos: (0, -6334), max pos: (8192, 1858), min detail level: 6, max detail level: 13. Given Position: {13*1,-1} = block pos: {0*8192,-8192}

3 replies

DHDistant Horizons