Search the Community

Showing results for tags 'database'.



More search options

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


Forums

  • Official Buildings
    • GM Hall
    • City Hall
    • Game News
    • Public Test Board
  • Back Streets
    • Town Square
    • Community Assistance
    • Village Recruitment Center
    • Suggestions & Ideas
    • The Creative Commons
    • Wood Scraps
  • Northern Freedom Isles
    • Harmony
    • Melody
    • Cadence
    • Northern Freedom Isles Market
  • Southern Freedom Isles
    • Celebration
    • Deliverance
    • Exodus
    • Independence
    • Pristine
    • Release
    • Xanadu
    • Southern Freedom Isles Market
  • Maintenance Buildings
    • Technical Issues
    • Server Bugs
    • Client Bugs
    • Model and Sound Bugs
    • Other Bugs and Issues
    • Wurmpedia / Wiki Maintenance
  • Wurm Unlimited
    • Unlimited Discussion
    • Unlimited Modding
    • Server Listings & Advertisement
    • Technical Issues

Find results in...

Find results that contain...


Date Created

  • Start

    End


Last Updated

  • Start

    End


Filter by number of...

Joined

  • Start

    End


Group


Chaos


Independence


Deliverance


Exodus


Celebration


Xanadu


Release


Pristine


Epic


Cadence


Defiance


Harmony


Melody


Acc1


Acc2


Acc3

Found 9 results

  1. For reasons I cannot understand -- The server is changing the .map files randomly every few days. I assumed originally this was just because the game was keeping the map updated as we make and perform changes but it's not just a few megabytes here or there; Randomly our resource.map file gained 30mb of new data and set all resource tiles to 55 resources remaining. Today we can't even dig the clay that we've been gathering because now the server assumes all resources have been dug straight down to rock tiles. I've adjusted no settings between server restarts. This just happens randomly. I can briefly fix this by replacing these map files with the originals, but I would love to know WHY this keeps happening.
  2. So I came accross a couple of issues when rebuilding the database on Linux. 1. And the most annoying, is that the file format was set to windows only line formatting ... so when you executed the rebuild-dbs file, it just refused to run because of line formatting. Using an app called dos2unix i converted the line formatting, which solved this problem. 2. sqlite3.exe exist ... good job, but what about sqlite3 .... you know, for Linux/Unix types ... sigh -_-... so yea I downloaded a copy of that too. That solved all the database rebuild issues. See link for a download of the new rebuilt-dbs script [0] (with proper line formatting) and a copy of the sqlite3 executable for Linux ... if you don't trust me, just delete the sqlite3 executable, and snag a copy from here [1] that's all I did anyway, but I would be leery of adding executable's to my servers, so ... yea to each their own. [0] https://www.dropbox.com/s/vwswo0o7sbpy5qb/rebuild-dbs_and_sqlite3.zip?dl=0 [1] https://sqlite.org/download.html ~Phreek
  3. As I mentioned in a previous topic me and Slinky were working on a Wurm skills dump to SQL tool. While working on getting the dump to SQL we had to find an easy way to parse the data and put it in to an easy form for making SQL queries... so we made a skills2CSV converter. Since then the tool(s) have evolved and they do a bit more than just convert the raw skill dump to an SQL file. The online tool: http://vwtfoundation.co.uk/wurmimport/ Forum post about our Wurm Database Spreadsheet: http://forum.wurmonline.com/index.php?/topic/132940-wurm-skills-spreadsheet/ Download the Tool To download the tool for further development or testing locally we have now decided to release the tool: http://www.vwtfoundation.co.uk/Wurm/WUChar.zip temporary URL https://www.dropbox.com/s/a2yiv4l988agdrz/WUChar.zip?dl=0 Neither of us are pros at PHP/Javascript/SQLite so please excuse the quality of scripting. Most of it is commented so you should be able to understand what is doing what from where, etc. If you have any advice or input it would be greatly appreciated. The tool is provided as is and neither me nor Slinky will take any responsibility for you using the files. To use the tool simply upload to a PHP 5 enabled web site/server and extract the WUChar.zip contents. You can name the WUChar directory to anything you like. All the rest is pretty self explanatory for people who understand PHP. It would be nice if someone could improve the security and/or convert this to Java so a portable version is available. If you know Java and understand PHP/Javascript/HTML forms and fancy having a crack at making a Java application out of this tool - please do! PLEASE NOTE: Do NOT use the SQL queries on a live server yet. If you do - you do so at your own discretion. There are warnings on the tools but I thought I'd just warn you beforehand. It's still a work in progress but I need people to test it. So far we've had no problem importing our own skills and adding attributes on to our test server and the skills work/update/degrade when you die just fine. To import the SQL file created: Shut down the server to avoid conflicts. If you are hosting the server yourself (or single player) then navigate to "DirectoryForWurmOrServer\<Mapname>\sqlite" e.g. C:\Program Files (x86)\Steam\steamapps\common\Wurm Unlimited\WurmServerLauncher\Adventure\sqlite Copy the UpdateSkills.sql file created with these tools in to this directory. Within this directory is an application called sqlite3.exe. Just double click this application and a command prompt-like window will open with sqlite> displayed. Type in the following, pressing return after each line: .open wurmplayers.db .read Update_Yourplayername_.sql The application will seem unresponsive for a second or two, then return back to the sqlite> prompt. Type the following then press Return: .exit (Thanks to epel for making this point) It should now have now completed the SQL queries and you should now be able to start the server or game again DONE: Insert affinities Insert Faith, Favor, Alignment, Karma and Priest/Follower status along with deity Add to inventory SQL queries (someone is going to have to help with item IDs /rarity/material/etc) - The inventories are kept in a different database, however should you develop a tool that connects to the wurmitems.db file, item ids can be found here on the item_data sheet. Set other character attributes Added so far: Kingdom GM status Bank balance Priest/Follower and Deity status Sleep bonus Karma Grant titles Only grants titles that are given by skills. Gives titles based on gender (which you must specify). Does not add Epic titles. Meditation path. Tested this with changing the server system time, adding time to the server time, and it gives questions dependant on level correctly for all paths, lets you advance properly, special abilities all work, server leaders show up for the paths, everything works as far as we can see... We would like some feedback on this as we've never been really high level on the paths before. We made it so that it generates the SQL file with an "update_", "max_" or "reset_" prefix so you can tell at a glance what the SQL file will do. Just in case you generated a few files. Credit for the inspiration and starting code for the CSV generator (first part of the tool) goes to http://wurmkit.com/.
  4. I am trying to completely delete a player on a non hosted 24/7 dedicated server. I tried to delete the entry in the wurmplayers.db but after making a new character with the same name I am seeing the old character when trying to manage house and container permissions. Any ideas on how to permanently delete that character would be appreciated. Rebuilding the database is absolutely out of the question as everyone would lose what they have worked hard to create.
  5. If you have Problems to rebuild Database with "./rebuild-dbs" - try to: 1) Convert File to UTF8 2) Edit call of SQLITE SQLITE_CMD=./sqlite3 SQLITE_CMD=sqlite3 3) Comment out: # Check that the sqlite3 executable exists #if [ ! -f $SQLITE_CMD ]; then # echo "ERROR: Could not find sqlite executable $SQLITE_CMD" # pauseAndExit 1 #fi
  6. Does anyone know how to check the amount of money the kingdom treasury has in it? I looked in wurmeconomy.db and the 'economy' table seems to be the best bet, but I really don't know. :/ I'm running into a problem where it seems the traders' accounts aren't refilling, so I think the kingdom bank might be empty, but I've no way of checking or refilling it, haha. Thanks! -Llurendt
  7. There must be a way. I would like template "players" that can found a starter for kingdoms without having to make them every time. I just mess around with maps and stuff. I find it funner than actually playing. I have WO for that.
  8. Greetings all I have an issue with my hosted server, the files are only available using ftp, so I download and edit them. I uploaded my custom map, and it seems to work well, then I created a character I wish to make a GM, but when I quit, shut down the server and export the wurmplayers.db file, its empty I use sqlitebrowser I renamed the file and imported a file with a character of the same name, but one that had GM powers, started up the server and logged in, but I got into the same character as before, with the same inventory and all... so my question is : where else are the characters stored, and has anyone been able to make a GM on killservers?
  9. Affects all platforms for Wurm Unlimited builds 828552 and earlier, and Wurm Unlimited Dedicated Server builds 828553 and earlier. Issue The server is unable to add entries to the PERMISSIONSHISTORY table in wurmplayers.db. In the server logs, this can be seen with exceptions similar to the following: WARNING: Failed to add permissions history for object (3540598449154) java.sql.SQLException: [SQLITE_CONSTRAINT] Abort due to constraint violation (NOT NULL constraint failed: PERMISSIONSHISTORY.PK) at org.sqlite.core.DB.newSQLException(DB.java:890) at org.sqlite.core.DB.newSQLException(DB.java:901) at org.sqlite.core.DB.execute(DB.java:810) at org.sqlite.core.DB.executeUpdate(DB.java:847) at org.sqlite.jdbc3.JDBC3PreparedStatement.executeUpdate(JDBC3PreparedStatement.java:86) at com.wurmonline.server.players.PermissionsHistories.dbAddHistoryEvent(PermissionsHistories.java:180) at com.wurmonline.server.players.PermissionsHistories.addHistoryEntry(PermissionsHistories.java:162) at com.wurmonline.server.questions.ManagePermissions.answer(ManagePermissions.java:507) at com.wurmonline.server.creatures.Communicator.reallyHandle(Communicator.java:6330) at com.wurmonline.communication.SocketConnection.tick(SocketConnection.java:615) at com.wurmonline.communication.SocketServer.tick(SocketServer.java:172) at com.wurmonline.server.Server.run(Server.java:2418) at java.util.TimerThread.mainLoop(Timer.java:555) at java.util.TimerThread.run(Timer.java:505) Cause This problem is due to the wrong data type being used as the primary key (INT instead of INTEGER), which means that keys are not auto-created. Fix Warning: The following steps will involve dropping and recreating a database table, and may result in loss of data. It is recommended that a backup be made before attempting to modify the database. It is possible to recreate the permissionshistory table by dropping and recreating it with the correct data type (Sqlite is not able to change data types on existing tables). Make a backup of the world directory (eg. Creative), found in steamapps\common\Wurm Unlimited for the client/server, or steamapps\common\Wurm Unlimited Dedicated Server for the dedicated server. Create a file named patch-20151029-12af395a-permissionshistory.sql in the sqlite directory of the world directory (eg. Creative\sqlite), with the following contents: BEGIN TRANSACTION; CREATE TABLE PERMISSIONSHISTORY_12af395a ( PK INTEGER NOT NULL PRIMARY KEY, OBJECTID BIGINT NOT NULL, EVENTDATE BIGINT NOT NULL, PLAYERID BIGINT NOT NULL, PERFORMER VARCHAR(40) NOT NULL, EVENT VARCHAR(255) NOT NULL ); INSERT INTO PERMISSIONSHISTORY_12af395a SELECT PK, OBJECTID, EVENTDATE, PLAYERID, PERFORMER, EVENT FROM PERMISSIONSHISTORY; DROP TABLE PERMISSIONSHISTORY; ALTER TABLE PERMISSIONSHISTORY_12af395a RENAME TO PERMISSIONSHISTORY; COMMIT; Note that the BEGIN TRANSACTION; and COMMIT; lines will cause the update to fail if executed in an Sqlite browser that performs transactions automatically. Open a command or terminal window and navigate to the directory Execute the following to update the table: sqlite3 wurmplayers.db < patch-20151029-12af395a-permissionshistory.sql Released Fix Should be fixed in build Wurm Unlimited build 836088 (in the publicly available beta branch) and Wurm Unlimited Dedicated Server build 836095, though this will only fix new servers, not existing ones. We are looking at options for a system to implement database schema updates. Edit: Wrong database specified in application instructions, corrected wurmlogin.db to wurmplayers.db. This will not cause issues apart from having a redundant table, but the fix will need to be reapplied. Edit 2: Correction on which servers are fixed