1. Welcome to TechPowerUp Forums, Guest! Please check out our forum guidelines for info related to our community.

TPU Minecraft Server

Discussion in 'Games' started by newtekie1, Feb 2, 2011.

  1. newtekie1

    newtekie1 Semi-Retired Folder

    Joined:
    Nov 22, 2005
    Messages:
    20,038 (6.15/day)
    Thanks Received:
    6,102
    Yeah, the program should purge records that have been removed from warp.db.
     
    Last edited: Apr 14, 2013
    Crunching for Team TPU 50 Million points folded for TPU
  2. FordGT90Concept

    FordGT90Concept "I go fast!1!11!1!"

    Joined:
    Oct 13, 2008
    Messages:
    13,795 (6.26/day)
    Thanks Received:
    3,676
    Location:
    IA, USA
    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.
     
    Last edited: Apr 13, 2013
    Crunching for Team TPU
  3. Chevalr1c

    Chevalr1c

    Joined:
    Sep 3, 2010
    Messages:
    3,246 (2.15/day)
    Thanks Received:
    1,424
    Location:
    NL, Europe
    I checked whether the warp you mentioned is under "Resources" or "resources". It appeared to be the first so you can remove the latter.
     
    Crunching for Team TPU
  4. FordGT90Concept

    FordGT90Concept "I go fast!1!11!1!"

    Joined:
    Oct 13, 2008
    Messages:
    13,795 (6.26/day)
    Thanks Received:
    3,676
    Location:
    IA, USA
    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.
     
    Chevalr1c says thanks.
    Crunching for Team TPU
  5. FordGT90Concept

    FordGT90Concept "I go fast!1!11!1!"

    Joined:
    Oct 13, 2008
    Messages:
    13,795 (6.26/day)
    Thanks Received:
    3,676
    Location:
    IA, USA
    Last edited: Apr 13, 2013
    Crunching for Team TPU
  6. Chevalr1c

    Chevalr1c

    Joined:
    Sep 3, 2010
    Messages:
    3,246 (2.15/day)
    Thanks Received:
    1,424
    Location:
    NL, Europe
    Move and renbame to Public Mine, I suppose.
     
    FordGT90Concept and Aquinus say thanks.
    Crunching for Team TPU
  7. Aquinus

    Aquinus Resident Wat-man

    Joined:
    Jan 28, 2012
    Messages:
    6,463 (6.46/day)
    Thanks Received:
    2,188
    Location:
    Concord, NH
    Fine by me.
     
    FordGT90Concept says thanks.
  8. FordGT90Concept

    FordGT90Concept "I go fast!1!11!1!"

    Joined:
    Oct 13, 2008
    Messages:
    13,795 (6.26/day)
    Thanks Received:
    3,676
    Location:
    IA, USA
    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?
     
    Crunching for Team TPU
  9. newtekie1

    newtekie1 Semi-Retired Folder

    Joined:
    Nov 22, 2005
    Messages:
    20,038 (6.15/day)
    Thanks Received:
    6,102
    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:

    Code:
    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 says thanks.
    Crunching for Team TPU 50 Million points folded for TPU
  10. FordGT90Concept

    FordGT90Concept "I go fast!1!11!1!"

    Joined:
    Oct 13, 2008
    Messages:
    13,795 (6.26/day)
    Thanks Received:
    3,676
    Location:
    IA, USA
    The warps2dynmap.exe and System.Data.SQLite.dll in the zip need to be in the same directory.
     
    Crunching for Team TPU
  11. newtekie1

    newtekie1 Semi-Retired Folder

    Joined:
    Nov 22, 2005
    Messages:
    20,038 (6.15/day)
    Thanks Received:
    6,102
    Crunching for Team TPU 50 Million points folded for TPU
  12. FordGT90Concept

    FordGT90Concept "I go fast!1!11!1!"

    Joined:
    Oct 13, 2008
    Messages:
    13,795 (6.26/day)
    Thanks Received:
    3,676
    Location:
    IA, USA
    I should have known you wouldn't make that mistake. :laugh: I'm looking into it...


    Edit: I downloaded w2d.zip above, created a batch on the desktop with:
    Code:
    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.
     
    Last edited: Apr 13, 2013
    Crunching for Team TPU
  13. newtekie1

    newtekie1 Semi-Retired Folder

    Joined:
    Nov 22, 2005
    Messages:
    20,038 (6.15/day)
    Thanks Received:
    6,102
    Still gave the same error.:(
     
    Crunching for Team TPU 50 Million points folded for TPU
  14. FordGT90Concept

    FordGT90Concept "I go fast!1!11!1!"

    Joined:
    Oct 13, 2008
    Messages:
    13,795 (6.26/day)
    Thanks Received:
    3,676
    Location:
    IA, USA
    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.
     
    Crunching for Team TPU
  15. newtekie1

    newtekie1 Semi-Retired Folder

    Joined:
    Nov 22, 2005
    Messages:
    20,038 (6.15/day)
    Thanks Received:
    6,102
    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.
     
    Last edited: Apr 14, 2013
    Crunching for Team TPU 50 Million points folded for TPU
  16. FordGT90Concept

    FordGT90Concept "I go fast!1!11!1!"

    Joined:
    Oct 13, 2008
    Messages:
    13,795 (6.26/day)
    Thanks Received:
    3,676
    Location:
    IA, USA
    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
     
    Last edited: Apr 13, 2013
    Crunching for Team TPU
  17. newtekie1

    newtekie1 Semi-Retired Folder

    Joined:
    Nov 22, 2005
    Messages:
    20,038 (6.15/day)
    Thanks Received:
    6,102
    No change. :(
     
    Crunching for Team TPU 50 Million points folded for TPU
  18. FordGT90Concept

    FordGT90Concept "I go fast!1!11!1!"

    Joined:
    Oct 13, 2008
    Messages:
    13,795 (6.26/day)
    Thanks Received:
    3,676
    Location:
    IA, USA
    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.
     
    Last edited: Apr 13, 2013
    Crunching for Team TPU
  19. newtekie1

    newtekie1 Semi-Retired Folder

    Joined:
    Nov 22, 2005
    Messages:
    20,038 (6.15/day)
    Thanks Received:
    6,102
    Nope. :(
     
    Crunching for Team TPU 50 Million points folded for TPU
  20. FordGT90Concept

    FordGT90Concept "I go fast!1!11!1!"

    Joined:
    Oct 13, 2008
    Messages:
    13,795 (6.26/day)
    Thanks Received:
    3,676
    Location:
    IA, USA
    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.
     
    Crunching for Team TPU
  21. FordGT90Concept

    FordGT90Concept "I go fast!1!11!1!"

    Joined:
    Oct 13, 2008
    Messages:
    13,795 (6.26/day)
    Thanks Received:
    3,676
    Location:
    IA, USA
    Back down to .NET Framework 4.0 and associated SQLite builds:
    *snip*

    If this don't work...
     
    Last edited: Apr 14, 2013
    Crunching for Team TPU
  22. newtekie1

    newtekie1 Semi-Retired Folder

    Joined:
    Nov 22, 2005
    Messages:
    20,038 (6.15/day)
    Thanks Received:
    6,102
    It seems like it worked, the log says "Purging obsolete categories" and lists resources and markers, but resources still seems to be there.
     
    FordGT90Concept says thanks.
    Crunching for Team TPU 50 Million points folded for TPU
  23. FordGT90Concept

    FordGT90Concept "I go fast!1!11!1!"

    Joined:
    Oct 13, 2008
    Messages:
    13,795 (6.26/day)
    Thanks Received:
    3,676
    Location:
    IA, USA
    It all looks fixed on Dynmap. "resources" category is gone and "Sheep Stables" is no longer doubled up. :D


    I'm beginning to think that SQLite for 4.5 is just plain broken.
     
    Last edited: Apr 14, 2013
    Crunching for Team TPU
  24. newtekie1

    newtekie1 Semi-Retired Folder

    Joined:
    Nov 22, 2005
    Messages:
    20,038 (6.15/day)
    Thanks Received:
    6,102
    Odd resources was still there for me for a while. Oh well, it seems to have worked, so excellent!
     
    Crunching for Team TPU 50 Million points folded for TPU
  25. ChevyOwner

    ChevyOwner

    Joined:
    Apr 15, 2013
    Messages:
    67 (0.12/day)
    Thanks Received:
    1
    I did not fell like reading all 107 pages, so did you get any where with the white list? or scrap that idea?
     

Currently Active Users Viewing This Thread: 1 (0 members and 1 guest)

Share This Page