Denthorn_

Yep, that did it. The specific .yml I ended up needing to edit was referenced in that one. Thanks for the help!

Ok so first off, thank you Paul for taking the time to help me troubleshoot this and for helping me get this up and running. Paul directed me towards this pre-packaged client made by another user here: Following his instructions I was able to get my client and server both up and running and have been playing for a bit now to verify there don't seem to be any issues. There's a video going over the database and server setup a little further down the page. Note that you won't want to actually play your characters on the admin account he has you set up as part of the process, as far as I can tell it locks you into having a pre-set appearance that doesn't change based on your job. I just created another account using the same command and changing the admin/admin fields to a different username and password and the field with the "99" to a "0" to make it a normal player account and its been working just fine. This all got me to the point I could actually play the game. That having been said I'm a stubborn idiot and, after poking around in the files in the prepackaged client Sapito provided in that thread, I can't actually tell what on earth he did that seems so different from what I'm doing that's causing these errors. I've identified where they're coming from (there are tables and functions defined in the game's data.grf that scripts in the translation.grf are reliant on, but it can't find them so it throws errors). I'm still curious as to what exactly I was doing wrong before so I'll probably revisit this a bit later and see if I can figure out what, specifically, was wrong with my setup, mostly just for curiosity's sake.

So I'm trying to modify the price of an item across all vendors (specifically fly wings, which as far as I'm aware is item id 601). I've modified the "price_buy" column for that entry in item_db_re using MySQL Workbench (and I've made other modifications to other tables unrelated to shop npcs that I know have worked, so it isn't a tool issue). I've also modified the same value in item_db, though I assume that table isn't used as my server is renewal, figured I'd try it just to be sure anyway. From looking through merchant .txt files, every merchant that sells item 601 lists it as using the price -1 (unless I'm terribly misreading the merchant .txt files, which is entirely possible I suppose), which if I'm not mistaken should mean they reference the database for the price. Yet, with my price_buy set at, say 10, all vendors continue to sell them at the price of 250, the original price. Do shop prices get cached somewhere that I need to modify or make it re-cache that data, am I misreading the txt files for merchants, or is there another database table I need to modify or what?

As of yet, no, I've made no further attempts since I posted it. I'll post back if/when I'm past this point. I've tried using the WARP profiles provided in that github, as I mentioned in step 10, I believe WARP calls them profiles instead? Regardless, using them hasn't fixed the issue for me and even patching without making any changes at all still creates an executable that spams errors... Sent you a friend request.

I'm trying to set up a simple local server and have been having a difficult time getting a client patched. So far, I've been cross referencing various guides I've found on forums and on youtube, since I haven't been able to find anything that seems entirely up to date. I'd greatly appreciate some help figuring out what I'm doing wrong. What I've done so far is as follows: 1. Downloaded a full client from http://nemo.herc.ws/downloads/. The specific one I downloaded was the one under Kro main/sakray for 2022-07-06. I then used that to install the game and copied the installed files off into a new folder. 2. I grabbed RO Patcher Lite from here: https://nn.ai4rei.net/dev/rsu/, dropped that into my copy of the install folder, and ran it to patch the game. I dropped a copy of OpenSetup into there as well, but have yet to actually open it and have tried removing it to no avail, so I'm assuming its not related to my issues. 3. Once that finished, I downloaded the 2022-04-06 executable from the same place I got the original client download and saved that off in a different folder. 4. I downloaded the files from this git repo for this translation project: https://github.com/llchrisll/ROenglishRE, then followed their instructions to use the bat file in the "Tools" folder to generate the necessary translation files for a 2022-04-06 client. I copied those files into my copied install directory such that the DATA.ini file is at the same level as the executable and the SystemEN file is at the same level as the System file. I've also tried additionally copying over the files in the "Additions" folder in the translation project as well on a different attempt, otherwise following the same steps. 5. I created a new .grf in a grf editor, file -> New -> Grf, then dragging the data folder in my copy of the install directory into the grf editor over the "new.grf" field on the left. This looks like it works, I see "book", "contentdata", "luafiles514", and "texture" folders appear under the "data" folder. 6. Saved that .grf off into a new file called data_en.grf in my copy of the install directory. 7. Opened DATA.ini and added a new entry such that 0=data_en.grf, 1=server.grf, 2=data.grf. I've noticed that some examples I've seen of this step in other sources have an rdata.grf here, I don't see that file anywhere in my installation directory and the line isn't in the DATA.ini file. No idea what the deal is there. 8. Opened up WARP and loaded the executable from step 3 into the "Source" field and clicked "Load Source", clicking through the confirmation prompts. 9. Clicked "Select Recommended", clicked OK through the path confirmation for "Inputs/Translations_EN.yml", set the path for ItemInfo to the similarly named file in SystemEN (SystemEN/itemInfo.lua), then clicked OK to confirm the ini file's name as DATA.ini, and set the window title to Ragnarok_Patched. 10. At this point I've tried several approaches. I tried loading the .yml session provided by the translation repo, I believe the latest was 2019-06_Translation.yml and the documentation on their wiki said to just use the latest one, so that's what I did. In a separate attempt (I've tried doing this whole process like 6 or so times now tweaking various things here and there hoping to figure out what the problem was) I just searched for all patches in WARP that included "lub" and manually pointed them to the correct files in SystemEN (at least I think they're the correct ones, many of the files are not identically named and some of them have the same names, just with different suffixes. I'm reasonably confident I got the right files at the very least I've also done this at least twice in the hopes of making sure I didn't just mess one of them up). I've generally also selected a few other patches, specifically the max zoom patch and increased hair style limit to ~65k. I've also tried with the remove movement lag patch and it automatically seems to select a few when clicking "Select Recommended" like the "@ Bug fix" patch. 11. Clicked "Apply Patches", dropped the generated executable into my copy of the install directory, and from here my understanding is that it should be executable successfully, in so far as the client will boot and the translation will be visible, or so it seems to be the case from the several video guides I've found going over this. At this point, trying to run it causes the executable to spew errors until I manually close it through the task manager. The errors are always the same and in the same order. Specifically: -- Title: ResetTheHotKey, Text: "attempt to call a nil value" -- The same error repeats once -- Title: "queryRegionInfo", Text: "attempt to call a nil value" -- This error now repeats every time I click through it, until force closing the process. At some point I tried just creating a patched client using WARP with no actual patches applied, if I recall correctly (its been a few days since I actually tried this, to be honest I threw my hands up in frustration and let it be for a few days after awhile, so my memory of every exact thing I tried isn't perfect) it also caused a number of errors to appear, but only a handful before the process successfully closed on its own. With that failing, I tried downloading NEMO and using that to patch instead, following the same process otherwise, which failed in the same way the WARP patch failed. Also tried doing a NEMO patch with no patches selected and had the same result as well. I've also tried using the 2022-03-30 executable instead of the 2022-04-06 one and saw the same results (I can't remember if the errors were identical or not, but the same pattern of them recurring indefinitely until force closing the process occurred). Trying to run the existing Ragnarok executable, it runs just fine in all cases with no errors, though obviously it is not translated. If anyone could help me figure out what on earth I'm doing wrong or point me in the right direction, I'd much appreciate it.