Search the Community

Showing results for tags 'sql'.



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 4 results

  1. Hey all, I've migrated my server from one provider to another but on migration I had issues loading the SQL Databases. I've fixed most of the issues but the only issue remaining is for existing players whereby their skills do not load. If they login and start building their skills any progression is also lost which is really frustrating for them. The error which appears is: [11:03:39 AM] WARNING com.wurmonline.server.creatures.Creature: Failed to load and create skills for creature with name Dummy:null java.lang.NullPointerException at com.wurmonline.server.skills.SkillSystem.getTypeFor(SkillSystem.java:453) at com.wurmonline.server.skills.Skill.<init>(Skill.java:181) at com.wurmonline.server.skills.DbSkill.<init>(DbSkill.java:66) at com.wurmonline.server.skills.DbSkills.load(DbSkills.java:122) at com.wurmonline.server.creatures.Creature.loadSkills(Creature.java:12289) at com.wurmonline.server.LoginHandler.handleLogin(LoginHandler.java:1690) at com.wurmonline.server.LoginHandler.login(LoginHandler.java:446) at com.wurmonline.server.LoginHandler.reallyHandle(LoginHandler.java:313) 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:2462) at java.util.TimerThread.mainLoop(Timer.java:555) at java.util.TimerThread.run(Timer.java:505) Any thoughts how to fix this? Many Thanks R
  2. Both SQL and JSON are used in WurmUnlimited, for those wanting to learn how to work with them a good resource is W3Schools.com as they are free, and teach both of those along with many other programming aspects, mostly web oriented. Just be aware that WurmUnlimited for the most part uses Java, NOT JavaScript (except the aforementioned JSON of course) which is a completely different thing. Of the 2 they only teach JavaScript there so while it may be interesting it won't help you do too much modding here.
  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. My dedicated server keeps shutting itself down every couple of days after running into the following error: Nov 24, 2015 1:14:30 PM com.wurmonline.server.Server run INFO: Polling shop demands Nov 24, 2015 1:14:30 PM com.wurmonline.server.economy.LocalSupplyDemand increaseAllDemands WARNING: Failed to increase all demands due to [SQLITE_ERROR] SQL error or missing database (no such function: GREATEST) java.sql.SQLException: [SQLITE_ERROR] SQL error or missing database (no such function: GREATEST) at org.sqlite.core.DB.newSQLException(DB.java:890) at org.sqlite.core.DB.newSQLException(DB.java:901) at org.sqlite.core.DB.throwex(DB.java:868) at org.sqlite.core.NativeDB.prepare(Native Method) at org.sqlite.core.DB.prepare(DB.java:211) at org.sqlite.core.CorePreparedStatement.<init>(CorePreparedStatement.java:40) at org.sqlite.jdbc3.JDBC3PreparedStatement.<init>(JDBC3PreparedStatement.java:29) at org.sqlite.jdbc4.JDBC4PreparedStatement.<init>(JDBC4PreparedStatement.java:18) at org.sqlite.jdbc4.JDBC4Connection.prepareStatement(JDBC4Connection.java:47) at org.sqlite.jdbc3.JDBC3Connection.prepareStatement(JDBC3Connection.java:254) at org.sqlite.jdbc3.JDBC3Connection.prepareStatement(JDBC3Connection.java:226) at com.wurmonline.server.economy.LocalSupplyDemand.increaseAllDemands(LocalSupplyDemand.java:326) at com.wurmonline.server.Server.pollShopDemands(Server.java:2497) at com.wurmonline.server.Server.run(Server.java:2210) at java.util.TimerThread.mainLoop(Timer.java:555) at java.util.TimerThread.run(Timer.java:505) Nov 24, 2015 1:14:35 PM com.wurmonline.server.zones.TilePoller calcRest INFO: Current polltile=0, rest=0 pollmodifier=29053, pollround=33 Nov 24, 2015 1:14:35 PM com.wurmonline.server.zones.TilePoller calcRest INFO: tiles=4194304, mask=4194303 ticksperday=3456000, Nthick=1, rest=738304, manypertick=true Nov 24, 2015 1:14:35 PM com.wurmonline.server.zones.TilePoller checkPolltile INFO: New pollModifier: 42527 eruptions=false Nov 24, 2015 1:14:39 PM com.wurmonline.server.statistics.Statistics run INFO: current mem in use: 1241M free mem: 673M Max mem: 2010M player count: 1 bytes in: 0 bytes out: 0 total in: 6129238 total out: 27261720 Server uptime: 86400 seconds. Unanswered questions:0 Nov 24, 2015 1:14:40 PM com.wurmonline.server.skills.SkillStat$1 run WARNING: Polling 145 skills for stats v2 took 1 ms. Nov 24, 2015 1:14:42 PM com.wurmonline.server.Items countEggs INFO: Current number of eggs is 52 (max eggs is 1000) That took 37.75788 ms. Nov 24, 2015 1:14:47 PM com.wurmonline.server.epic.EpicServerStatus pollExpiredMissions INFO: Deleting last mission for deity 1 since it could not be found Nov 24, 2015 1:14:47 PM com.wurmonline.server.epic.EpicServerStatus pollExpiredMissions INFO: Deleting last mission for deity 2 since it could not be found Nov 24, 2015 1:14:47 PM com.wurmonline.server.epic.EpicServerStatus pollExpiredMissions INFO: Deleting last mission for deity 4 since it could not be found Nov 24, 2015 1:14:58 PM com.wurmonline.server.Server run SEVERE: null java.lang.NullPointerException at com.wurmonline.mesh.GrassData.encodeGrassTileData(GrassData.java:572) at com.wurmonline.server.zones.TilePoller.checkForGrassGrowth(TilePoller.java:763) at com.wurmonline.server.zones.TilePoller.checkEffects(TilePoller.java:404) at com.wurmonline.server.zones.TilePoller.pollNextTile(TilePoller.java:235) at com.wurmonline.server.zones.TilePoller.pollNext(TilePoller.java:165) at com.wurmonline.server.Server.run(Server.java:1709) at java.util.TimerThread.mainLoop(Timer.java:555) at java.util.TimerThread.run(Timer.java:505) Nov 24, 2015 1:14:58 PM com.wurmonline.server.Server run SEVERE: Server is shutting down but there is no information in the Exception so creating a new one java.lang.Exception at com.wurmonline.server.Server.run(Server.java:2471) at java.util.TimerThread.mainLoop(Timer.java:555) at java.util.TimerThread.run(Timer.java:505) Nov 24, 2015 1:14:58 PM com.wurmonline.server.Server shutDown INFO: Shutting down at: java.lang.Exception at com.wurmonline.server.Server.shutDown(Server.java:3278) at com.wurmonline.server.Server.run(Server.java:2473) at java.util.TimerThread.mainLoop(Timer.java:555) at java.util.TimerThread.run(Timer.java:505) Nov 24, 2015 1:14:58 PM com.wurmonline.server.Server shutDown Seems the issue is that the server is trying to use the 'GREATEST' SQL function which Sqlite doesn't support (though you could simply use MAX in it's place to a degree). Any ideas if it's something I can fix on my end (I'd like to keep using sqlite) or if it needs to be patched by the devs?