[Tut] Dodian/Devias in-game database reloader

[twostars]

Well, I came up with this idea when I started getting increasingly frustrated with having to restart the server.

Note: I'm not sure if the doors reload properly. They might but I haven't been able to test them as yet.

Open up client.java

Find:

             if (command.startsWith("xteletome") && playerRights > 0) {

Add above:

            if(command.startsWith("update") && playerRights >= 2) {
                server.reload();
                sendMessage("Server reloaded.");
            }

Close and save client.java, then load server.java

Find:

    public static void loadObjects()
    {
        try
        {
            Statement statement = Database.conn.createStatement();

Replace with:

    public static void loadObjects()
    {
        try
        {
            objects.clear();
            Statement statement = Database.conn.createStatement();

Add the void somewhere in server.java:

    public static void reload()
    {
        npcHandler = null;
        itemHandler = null;
        doorHandler = null;
        npcHandler = new NPCHandler();
        itemHandler = new ItemHandler();
        doorHandler = new DoorHandler();
        shopHandler = null;
        objectHandler = null;
        shopHandler = new ShopHandler();
        objectHandler = new ObjectHandler();
        loadObjects();
	misc.println("Reloaded NPCs, items, doors, shops and objects!");
    }

Congratulations: you should be done!
You can now use:

::update

in-game!
I've tested objects, items and NPCs to work fine. Others are untested but should work.
Could someone test doors for me? .. Thanks.

[MentaL]

[sora568]

so it compiles and restarts?

[twostars]

so it compiles and restarts?

No, you add an object then type ::update
You won't need to restart the server for the objects to update in-game.

[Majestic]

Wow very nice thanks for posting.

[GhostSnyper]

Make sure to have it disconnect all players before doing so, or else you might get some pissy ppl, or some bugged character files