Updated Goose Server. New features:

• Supports both Aspereta and Illutia through configuration
• Uses SQLite for storage so no longer requires a separate database server
• C# scripting of items/spells/NPCs
• Easier editing data. Edit via Google Sheets rather than editing SQL directly

Download and install the .NET 8 SDK

If using Illutia click here. If using Aspereta click here.

This will prompt you to copy the sheet. Go to your new sheet, share it to make it visible to everyone.

Open the file GooseSettings.json.

By default the settings are configured for Illutia. If you want the server to run for Aspereta you will need to remove/comment out the section under // Illutia Config. And uncomment the section under // Aspereta Config.

Set up the server to use your data sheet by copying the id out of the URL of your sheet and copying it into the ID in the config DataLinkId.

dotnet "run" --project "Goose/Goose.csproj"

Server runs on port 2006 by default. So configure your client for that port and play. :)

When restarting the server you can run it with updatesql on the end to update automatically.

dotnet "run" --project "Goose/Goose.csproj" updatesql

Otherwise if your character is a GM you can run the /updatesql command.

Via command line you can run sqlite3 Goose/bin/Debug/IllutiaGoose.db and run SQL commands.

Otherwise you can download a tool such as SQLite Browser to open the IllutiaGoose.db file and edit it.

You can run this SQL with your player name, or update the access_status column for your player and set it to 9.

UPDATE players SET access_status=9 WHERE player_name='namegoeshere';