neofit

Members
  • Content Count

    288
  • Joined

  • Last visited

Everything posted by neofit

  1. Also, there may be a slight issue with the script. More like with my skill dump, but I don't see why I should be the only one. It appears that my last skill dump, skills.20140728.0748.txt, has this: Beverages: 10.771588 10.771588 0 Butchering: 31.264412 31.264412 0 Fighting: 73.43082 11.409132 0 Shield bashing: 1.2157669 1.2157669 0 Taunting: 2.5652437 2.5652437 0 Normal fighting: 55.522255 55.522255 0 Defensive fighting: 7.5168114 7.5168114 0 The previous one, skills.20140720.1428.txt, is OK: Beverages: 10.771588 10.771588 0 Butchering: 31.264412 31.264412 0 Fighting: 73.43082 73.43082 0 Shield bashing: 1.2157669 1.2157669 0 Taunting: 2.5652437 2.5652437 0 Normal fighting: 55.522255 55.522255 0 Defensive fighting: 7.5168114 7.5168114 0 I don't know why the game decided to bug my final skill dump, it was probably feeling something, anyway, the tool ended up generating a: INSERT INTO `SKILLS` [...] ),1023,11.409132,10,0); It is correct in assuming that the second row is usually the highest, but now my WU toon is d0med. Maybe there is a point in making it so it uses the max of the two columns?
  2. The SQL I provided will keep the highest skill in case of a dupe, which is slightly different than erasing everything. There is no reason for this on a totally new toon, but if someone raised something that isn't in the skill dump before using the import tool and wants to keep it, this is the way to do it. Up to you.
  3. You cannot use an "INSERT OR REPLACE" here. It decides to do a REPLACE based on a constraint violation by the INSERT. But the SKILLS table has been set up in such a way that the only constraint is the PK on ID, and there is no unicity constraint on ( OWNER, NUMBER), so technically the game allows one player to have multiple rows with the same skill in the database.
  4. Good job on the SQL. There is a problem though. The SKILLS table holds some skills for the player already, a row for each characteristic and one for each skill above 1.0. For example, my new toon Neofit on my private Adventure server already has 17 skills in the table. You generate an INSERT for each row that you find in the skill dump file, I understand that your web interface cannot know what rows I have in there, but it still makes duplicate rows in the table. For example I have the following duplicates in my table: NAME ID NUMBER name VALUE MINVALUE ------- --------------- ------- -------------- -------------------- --------------- Neofit 4363303829258 1 Body 20.000095833181 20.000095833181 Neofit 4466550816790 1 Body 42.934093 20.0 Neofit 4363320606474 2 Mind 20.0 20.0 Neofit 4466550816787 2 Mind 35.29857 20.0 Neofit 4363337383690 3 Soul 20.0000638888881 20.000063888888 Neofit 4466550816784 3 Soul 29.41831 20.0 Neofit 4363354160906 100 Mind logic 25.0002710597792 25.000271059779 Neofit 4466550816789 100 Mind logic 41.291218 20.0 Neofit 4363370938122 101 Mind speed 20.0 20.0 Neofit 4466550816788 101 Mind speed 21.702763 20.0 Neofit 4363387715338 102 Body strength 20.0003833333285 20.000383333328 Neofit 4466550816792 102 Body strength 38.959858 20.0 Neofit 4363404492554 103 Body stamina 20.0003833333285 20.000383333328 Neofit 4466550816791 103 Body stamina 31.986149 20.0 Neofit 4363421269770 104 Body control 25.0 25.0 Neofit 4466550816793 104 Body control 31.960886 20.0 Neofit 4363438046986 105 Soul strength 20.0 20.0 Neofit 4466550816785 105 Soul strength 29.671686 20.0 Neofit 4363454824202 106 Soul depth 20.0007666557779 20.000766655777 Neofit 4466550816786 106 Soul depth 27.605993 20.0 Neofit 4365686193930 1003 Axes 2.0 2.0 Neofit 4466550816699 1003 Axes 33.550133 1.0 Neofit 4365702971146 1007 Woodcutting 2.0 2.0 Neofit 4466550816711 1007 Woodcutting 59.77305 1.0 Neofit 4365652639498 1019 Nature 1.67294006374463 1.6729400637446 Neofit 4466550816722 1019 Nature 48.668163 1.0 Neofit 4363471601418 1023 Fighting 10.0 10.0 Neofit 4466550816740 1023 Fighting 11.409132 10.0 Neofit 4365669416714 10003 Hatchet 2.0 2.0 Neofit 4466550816702 10003 Hatchet 43.98583 1.0 Neofit 4365619085066 10018 Tracking 2.0 2.0 Neofit 4466550816660 10018 Tracking 22.13066 1.0 Neofit 4365635862282 10071 Foraging 2.0 2.0 Neofit 4466550816733 10071 Foraging 24.723238 1.0 The game is rather smart to only show the row holding the max value (or maybe it happens by accident), but I am not sure having dupe skills wouldn't break the game later on. You may want to add the following SQL to the .sql that you are generating: delete from SKILLSwhere ID in ( select id from ( -- easier to cut and paste to test this way select pl.NAME, s.ID, s.NUMBER, s.VALUE, s.MINVALUE from SKILLS s left outer join PLAYERS pl on ( pl.WURMID = s.OWNER) where pl.name = 'Neofit' ) d where d.NUMBER = SKILLS.NUMBER order by d.VALUE desc limit -1 offset 1);It will shamelessly delete the row with the lowest skill for every dupe detected. Tested and saw no problem in game.
  5. C'est bien, ça. I see the server browser is advertising it as "[PVE] Infinite Wurm | No GM |", and no password Really, what could go wrong .
  6. I feel silly, I am not at the office and this is not financial data. I'll update both columns with highest value from the dump and move on. Now, I wonder why the ID (primary key) in the SKILLS table is calculated with a BigInteger.valueOf(playerSkillsIdCounter).shiftLeft(24).longValue() + (Servers.localServer.id << 8) + 10L; instead of a simple autoincrement... SQLite had none 12 years ago?
  7. "Wurm Infinite" is the name of the server? Where is it located? Silly question (I've been drooling over WU since the announcement but got swamped by work the whole week, could barely log in for an hour to check some stuff so far): what does it mean "set breeding and field growth to 6 hours"? Pregnancies last 6 hours? We get a new crop every 6 hours?
  8. Hello, I am analyzing my last skill dump, and started wondering about the values in there. I always assumed, probably foolishly, that the columns were: col1: skill name | col2: current_value | col3: max_value | col4: affinity where current_value could be lower than the max after a death. But then I noticed something: for some skills I have col2 > col3, for others col3 < col2. For instance: name value value2 affinity---------- ---------- ---------- ----------Fighting 73.43082 11.409132 0Mauls 4.7904954 4.6951904 0and name value value2 value2-value affinity---------- ---------- ---------- ------------------ ----------Alchemy 32.96183 32.986828 0.0249980000000036 0Longsword 40.086407 40.140015 0.053607999999997 0Medium woo 6.7882595 7.063259 0.274999500000001 0Polearms 6.377887 6.627887 0.25 0Rake 53.640446 53.665447 0.0250010000000032 0Ropemaking 30.11274 30.13774 0.0250000000000021 0I vaguely remember dying before quitting and being upset to lose points in Ropemaking and the diff between the values seem to confirm the assumption that col3 is the max ever attained. But then, how is it possible to have col3 < col2? Also, in wurmplayers.db, the SKILLS table has the following columns: CREATE TABLE SKILLS( ID BIGINT NOT NULL PRIMARY KEY, OWNER BIGINT , NUMBER INT , VALUE DOUBLE , MINVALUE DOUBLE ,-- LASTUSED BIGINT , DAY1 FLOAT NOT NULL DEFAULT 0, DAY2 FLOAT NOT NULL DEFAULT 0, DAY3 FLOAT NOT NULL DEFAULT 0, DAY4 FLOAT NOT NULL DEFAULT 0, DAY5 FLOAT NOT NULL DEFAULT 0, DAY6 FLOAT NOT NULL DEFAULT 0, DAY7 FLOAT NOT NULL DEFAULT 0, WEEK2 FLOAT NOT NULL DEFAULT 0);Instead of what I am seeing in the skill dump, supposedly current_value|max_value, the database has value|minvalue. Is 'minvalue' misnamed? My goal is to map the skill dump to this table, I don't want to do something that will break the character after a couple of weeks or months. Thanks
  9. I spent 5 minutes to kill a pig and get some skillups, no skilldumps there.
  10. Hi, I looked into a way to import my toon's skills from WO into WU. In wurmplayers.db I have: CREATE TABLE PLAYERS( NAME VARCHAR(40) NOT NULL UNIQUE, [...] WURMID BIGINT NOT NULL PRIMARY KEY, [...] ); and CREATE TABLE SKILLS ( ID BIGINT NOT NULL PRIMARY KEY, OWNER BIGINT , NUMBER INT , VALUE DOUBLE , MINVALUE DOUBLE , LASTUSED BIGINT , [...] ); Joining players.wurmid to skills.owner is no problem. But the skilldump uses skill names and I cannot find a reference table with those. Are they hardcoded in the game executable? Any idea on how to map skill ids to skill names? There is the hard way: make a gm toon, increase every skill by something, then compare the skill dump with the db contents. But: 1. This is silly; 2. In WU I can find the chat channel logs, but can't find any skilldumps.txt . So, help please? Thanks.
  11. Thanks for the reply. So to play it in SP I just choose "PvP" off, "Home Server" off, then create a character in one of the three named kingdoms?
  12. Hi, I was wondering, how does one start an SP PvE Adventure mode game? I deselected PvP and assumed that realms won't exist, but apparently unless I choose "Hole Server" the game will still ask whether I want to create my toon in a realm, I don't even know what the purpose of a realm is on a PvE server. I don't want to break any quest of NPC scripts or anything then have to restart all over, so I have to ask: has Adventure mode been designed with realms in mind, or just one home server, or it doesn't matter? Thanks.
  13. No wait, don't close it . I want to make sure about one thing. The server came with "Skill Gain Rate Multiplier: 3.0". Does that mean: 1. It's the normal WO setting, 3.0x of something. To make it 10x faster than WO one should put 30.0 in there 2. It's 3.0x the WO settings, to make skill gain 10x faster than in WO one should put 10.0 in there? Also, how does "Epic Settings" factor into this? A 2x (or whatever it is now) on top of the "Skill Gain Rate Multiplier", or it's one or the other?
  14. It would be nice if you could add the location. It is likely to draw crowds from the same continent. I, from Europe, have played with folks from the AU/NZ and US timezones, and we barely saw each other. Also, I've paid my WO dues, and IMHO skill gain below x10 will be very hard to accept. Also², how about letting people import their old toons' skill dumps? When the tools are here and tested that is.
  15. The idea is sound, but Wrong move! Now they will implement this band aid and stop working on proper dual-boxing and we will never have bridges .
  16. Because of course that is the intent. Open Source will of course bring thousands, no, wait, tens of thousands of programmers willing to buy code and then, you know, compile things just for themselves.
  17. Technically, Warlander didn't shed any light on this issue. "WU will be available on Linux, hopefully soon after release. :)" doesn't say much. Whenever one of the devs posts about OSes, they never specify whether they are talking about the client or the server. Albin's post though in that same thread is a welcome exception: Finally, "Server" and "Linux" in the same sentence in a dev post! Yay!
  18. It's amusing how someone, in nearly every game's forums, has this idea to release stuff for free to "increase revenue".
  19. Your WU page has different information in the lower right "Info" corner whether I view it in English or in French. The English "100% Insurance of Exchange or Refund in case of defective product" are replaced by "Installation & Activation securisée" on the page in French, in other words, "Secure installation and activation". So what's the deal? Do we have to install another third-party DRM layer in order to install and activate the game online, or does it refer to Steam? Do we just pay, get a Steam key through the mail, and profit?
  20. Which does not mean that they will spend their own resources to write code to help other people monetize the hell out of private servers.
  21. Isn't the game still supposed to have a modicum of support at least for modding, at best for the wanted functions? Or are people going to reverse-engineer the game code then make some hacks on top of it that use account and financial information? Why even ask CC AB about modding support if everything is possible without?
  22. And buycraft will be able to interface seamlessly with WU and create stuff there with admin powers without any support from WU at all? Why would Rolf write extra code to enable a connection or plugin to securely manage such a service from the outside, and thus help other people earn money from WU? He wrote that it will be "tolerated", never said he'll help with that. And more importantly, why is it that Rolf hasn't himself set up a no-grind server?