TPU Minecraft Server

[newtekie1]

Yeah, the program should purge records that have been removed from warp.db.

 

[FordGT90Concept]

I updated SQLite library to 4.5 because I updated Visual Studio to 4.5. This means the computer running this needs 4.5:
http://www.microsoft.com/en-us/download/details.aspx?id=30653

If the computer hosting Minecraft server isn't Windows Vista SP2 or newer...I'm going to have to come up with another solution.


I added a /nopurge flag to not purge markers.yml. When it does purge, it removes all categories that aren't in warps.db, players, and offline_players. I hope I got that right.

I would recommend doing a manual update to make sure everything works as expected. If it does not, restore the backup it created and add the /nopurge flag until I can fix it.

 

[Peter1986C]

I checked whether the warp you mentioned is under "Resources" or "resources". It appeared to be the first so you can remove the latter.

 

[FordGT90Concept]

Yeah, I changed the welcome message to Resources a week ago or so and just today noticed they're both still showing. I programmed Warps2DynMap to only inject warps into DynMap, not remove them. Since no one is adding markers that aren't warps, it makes sense to only do warps + players + offline players. That way the markers are fully autonomous (either by DynMap or by my program).

He'll probably use the duplicate Sheep Stable marker to test if the new Warps2DynMap is working so I'll leave it.

 

[FordGT90Concept]

It still looks like it is still doubled up. Did it not work?


Edit: Kard is now completely lit up:
http://tpuminecraft.servebeer.com/?worldname=world&mapname=flatn&zoom=4&x=-1793.75&y=64&z=-1807.25


Edit: Also, no one commented on this:

Should I keep the Oil Platform warp or move it underground and rename it to Public Mine?

 

[Peter1986C]

Move and renbame to Public Mine, I suppose.

 

[Aquinus]

Move and renbame to Public Mine, I suppose.

Fine by me.

 

[FordGT90Concept]

Hmm, so how deep should it be? The floor where the mine starts? About the middle? The bottom? The floor where diamonds start? Somewhere among those?

 

[newtekie1]

I updated SQLite library to 4.5 because I updated Visual Studio to 4.5. This means the computer running this needs 4.5:
http://www.microsoft.com/en-us/download/details.aspx?id=30653

If the computer hosting Minecraft server isn't Windows Vista SP2 or newer...I'm going to have to come up with another solution.


I added a /nopurge flag to not purge markers.yml. When it does purge, it removes all categories that aren't in warps.db, players, and offline_players. I hope I got that right.

I would recommend doing a manual update to make sure everything works as expected. If it does not, restore the backup it created and add the /nopurge flag until I can fix it.

Sorry, I've been under the weather this week and didn't get to this until today.

I updated to .Net 4.5, the servers running Win7 Pro SP1 so no worries there.

But now when I run it I get the following error:

Unhandled Exception: System.IO.FileNotFoundException: Could not load file or assembly 'System.Data.SQLite.dll' or one of its dependencies. The specified module could not be found.

 

[FordGT90Concept]

The warps2dynmap.exe and System.Data.SQLite.dll in the zip need to be in the same directory.

 

[newtekie1]

They are. I copied and pasted the two files from the zip over the two from the old version. You just have forgot a semicolon somewhere.

 

[FordGT90Concept]

I should have known you wouldn't make that mistake. I'm looking into it...


Edit: I downloaded w2d.zip above, created a batch on the desktop with:

warps2dynmap.exe "C:\warps.db" "C:\markers.yml" 3 /show POI Resources

I extracted the two files to the desktop as well and ran the batch. It worked without error. I can't reproduce the error.


Edit: Strange, I deleted the DLL and it still worked. It shouldn't have worked. WTF?


Edit: I changed the program and SQLite to x64 and made sure everything was ship-shape. If this don't work, I gots no ideas.

 

[newtekie1]

Still gave the same error.

 

[FordGT90Concept]

This is against conventional logic but maybe try deleting System.Data.SQLite.dll. When I do, it still works. I even renamed the directory where SQLite.dll is installed to and it still works.

If that doesn't work, maybe providing a current markers.yml and warps.db would help.

 

[newtekie1]

Deleted System.Data.SQLite.dll and still got the same error.

Edit: It is now saying the error is "at warps2dynmap.Program.Main(String[] args)" if that helps any.

 

[FordGT90Concept]

Try this (only need to take the important bits out of it):
*snip*

It's confirmed to happen on all machines that aren't mine. XD

 

[newtekie1]

No change.

 

[FordGT90Concept]

Pretty sure this one will work:
*snip*

This is what is causing all the problems:
http://msdn.microsoft.com/en-us/library/yf1d93sz.aspx

I removed SQLite from the global assembly cache (GAC) so it forces it to find it locally on my computer and, for some reason, that means it forces it to find it locally on all computers. The SQLite devs should have never added SQLite to the GAC.

 

[newtekie1]

Nope.

 

[FordGT90Concept]

What the hell? On my computer, it works fine with both EXE and DLL but the moment I delete the DLL, the EXE displays the same error you're reporting.

I think I might as well just uninstall all the SQLite 4.5 stuff and back down to 4.0. I can't use 4.5 for my other project anyway because my server only has Windows Server 2003 on it.

 

[FordGT90Concept]

Back down to .NET Framework 4.0 and associated SQLite builds:
*snip*

If this don't work...

 

[newtekie1]

It seems like it worked, the log says "Purging obsolete categories" and lists resources and markers, but resources still seems to be there.

 

[FordGT90Concept]

It all looks fixed on Dynmap. "resources" category is gone and "Sheep Stables" is no longer doubled up.


I'm beginning to think that SQLite for 4.5 is just plain broken.

 

[newtekie1]

Odd resources was still there for me for a while. Oh well, it seems to have worked, so excellent!

 

[ChevyOwner]

I did not fell like reading all 107 pages, so did you get any where with the white list? or scrap that idea?