Smebb

Members
  • Content count

    42
  • Joined

  • Last visited

Community Reputation

6 Neutral

About Smebb

  • Rank
    Villager

Profile Information

  • Gender
    Male
  • Location
    UK

Accounts

  • Pristine
    Smebb
  • Acc1
    Henric

Recent Profile Visitors

645 profile views
  1. [RELEASE] Wurm Skills Dump to CSV to SQL Tool

    Updated the original post with a temporary URL until we get hosting fixed.
  2. Wurm CSV to SQL Converter Down?

    Yeah sorry, Slinky had a dispute with the host over traffic to the web site I'll update the tool thread for the source until we get hosting back up.
  3. Is there a way to change this without modifying the server.jar? Like is there a config option in any of the files or something? We can't find the setting for it anywhere and we'd prefer not to modify the server files in any way. from com.wurmonline.server.statistics.ChallengeSummary.class private static final String rootdir = "/var/www/challenge/"; We'd like to have the challenge stats not saved to that location as the web server is not located there, or is this feature meant only for administrators? Any help or input from Code Club AB would be appreciated. If this is not the place for this discussion I understand but I didn't think it related to modding as it's something already in the game.
  4. [RELEASE] Wurm Skills Dump to CSV to SQL Tool

    Added the meditation path and level insertion (after much testing!!!) and concluded it works as intended. We have had no problems as of yet, we could level up on the paths and receive questions, and show up on the local leaders list and use abilities as normal. Marked the project as released and given access to the files for the tool. We hope someone can integrate this in to one of the admin tools or create a portable or offline version in Java or something.
  5. I've added more details and the maps for the servers. The 10 or so regulars in Freedom are peaceful folk (at the minute...), we only have a handful of people in the 2 PMKs so we're looking for more regular players to join them. We also need someone who isn't a GM or staff to take the crown for Dragonsteel Militia, so they're truly player run.
  6. The only way I've been able to achieve this is to disable the Home Server setting in the server settings and make sure I make villages Kingdom Spawns. This forces players to choose a Kingom when they first enter the server though, which is not what I wanted. If anyone knows or finds a way to make a portal change a players kingdom then teleport them to the Kingdom home village, please let me know. It'd be greatly appreciated.
  7. Currently 2 servers with 1 more in development/testing. Interactive maps, cluster info and a tutorial on how to install the maps for our servers in to your client can be found with this link. We've been running VWT Home since 23rd of October 2015. VWT Home - 2048x2048, landing server, 8000 creatures (30% hostile), altars VWT South - 4096x4096, 16000 creatures - will be increased once population rises (25% hostile), has a couple of no-PvP zones, altars All new players have the option of 3 kingdoms to join: Freedom Isles (Freedom), Dragonsteel Militia (Mol Rehan based PMK) or Tenebrous Exiles (HotS based PMK) all with their associated newbie villages which have most newbie resources close by. We're currently looking for more active players to join Tenebrous Exiles and Dragonsteel Militia so as to balance the three kingdoms. There is even a spot for an active player to become the King/Queen of Dragonsteel Militia as we already have a King for Tenebrous Exiles. Game mechanic settings: PvP - yes Skillgain - 1x Characteristics start at 20 Fighting starts at 5 All other skills start at 1 Combat rating - 1x Action timers - 1.4x (subject to change) Upkeep is enabled Free deeds are disabled Minimum mining actions - 40 Breeding modifier - 1x Field growth - 8 hours Tree spread - 1x More active players are also needed to become priests and meditation leaders. We're hosting events every month (with prizes or loot) which are decided by polls so the players get to choose what we do that month. Silver (and gold) coins can be made available along with skill dumps from your Wurm Online character should people find playing on our servers enjoyable and wish to donate to the running costs of the servers. If you didn't check out the cluster info link above: to connect to the servers search for "VWT Home" in the server list. The Violent Isles waits for you...
  8. [RELEASE] Wurm Skills Dump to CSV to SQL Tool

    Quick fix: Updated it to fix the titles. It was inserting the skill ID in to the database instead of the actual title ID. It wasn't breaking anything that we noticed but the titles weren't working either. Sorry about that! We've also made it so there is a comment in the SQL to tell you when it was generated for which character name. Also changed the filename of the download to Update_PlayerName_.sql as requested by those downloading multiple SQL files and having "UpdateSkills.sql", "UpdateSkills(1).sql","UpdateSkills(2).sql" etc in their Downloads directory for different characters. If anyone wants the date/time added to the file name I can do that too or add an option for it.
  9. Is there a way to set up a mission or something that when you use a portal (or examine a statue or whatever) will popup a dialog with information about the kingdom with a confirmation button that then sets you to a PMK (or FI, JK, MR or HotS for that matter) and teleports you to the kingdom capital? I know how to make a mission that teleports someone when examine a statue... but the guards annihilate whoever uses it because default kingdom is Fredom Isles. I'd like to also have an item or Portal that leads people to a clustered server should they just want to play PvE but it isn't essential right now. (linked server is already setup and working) I'm using the Creative database with a custom map. I thought it'd be much more fun starting a server from scratch but having KvK enabled. If I have to go in to the database to tinker with stuff that's fine. It'd be nice to have a hint at what data I'm looking for though. If anyone can help it'd be greatly appreciated!
  10. [RELEASE] Wurm Skills Dump to CSV to SQL Tool

    If you mean verify the SQL query is being executed then yes you can: Shut down the server. (If you're using an external host then also download the map folder so you have it locally).Open DB Browser. Click "Open Database" at the top, then navigate to the wurmplayers.db file and click OpenTo check the SQL query works:Click the "Execute SQL" tab at the top and paste in the SQL code generated by the tool.At the bottom of the DB Browser window (2 sections under where you pasted the SQL queries) there is an error box that will halt the queries and report any errors.Once it has finished and displays the last query it executed - click "Write Changes" at the top of the window.If you wish to make sure changes have been made and you understand how Structured Query databases work then you can navigate to the "Browse Data" tab and in the drop down choose PLAYERS and look for your player name.If you enabled the extended options and updated your Faith, Deity, money, sleep bonus or anything like that - you should see them changed in the table. If you didn't enable extended options then simply paste this code in to the "Execute SQL" box: SELECT * FROM `SKILLS` WHERE `OWNER` = (SELECT `WURMID` FROM `PLAYERS` WHERE 1=1 AND `NAME` = 'YOURNAME');Just change YOURNAME to your player name. If the skills are displaying correctly then they should be updated when you start up the server again.When you start the server make sure that the "Select database to use" matches the directory of the database you just updated. If you're using an external host - make sure the database is in the correct directory when you upload it. (Some hosts only support you to use one directory and you can't change it)I hope this helps.
  11. [RELEASE] Wurm Skills Dump to CSV to SQL Tool

    When you do the SQL queries make sure your server isn't running. I don't know why but I've not had any luck executing the queries while the server was running. If you're using the SQLite3.exe in the map directory you're using and you have placed the UpdateSkills.sql file along side the SQLite3.exe, then yes those commands should work. There should be a short pause when you execute .read then the sqlite> prompt should display again. We're having no problems using the provided SQLite3.exe program, using PHP nor injecting and writing changes via DB Browser for SQLite.
  12. [RELEASE] Wurm Skills Dump to CSV to SQL Tool

    Titles Update The tool now adds titles based on skills (and gender). It does not add Epic titles or any non-skill specific titles. If anyone wants the title data I've added a sheet on our Wurm Unlimited Database spreadsheet. It's on the "title_data" sheet. Still working on the meditation data!
  13. [RELEASE] Wurm Skills Dump to CSV to SQL Tool

    Yes this imports skills from a skills dump done on Wurm Online. No this does not to create a character. You must have first logged a character in to the server/map so it is recognised in the database before you can use this. If you understand SQLlite or know what to do with the SQL code - you need to run this on wurmplayers.db. I have also updated the tool to add affinity, reset skills, max all skills, and added extended options (GM Status, Faith, Favor, Alignment, which Deity they serve, which Kingdom they belong to, set bank balance in Irons, Priest status, how much sleep bonus they have, and Karma). Feedback is appreciated!
  14. [RELEASE] Wurm Skills Dump to CSV to SQL Tool

    Good call! We almost forgot about the meditation paths! Added to the to do.
  15. I made a spreadsheet with the skill NUMBERS for the SKILLS table. See my spreadsheet post.