Player Resource Consortium
Neverwinter Nights => General Discussion => Topic started by: DM Heatstroke on December 18, 2009, 01:32:55 PM
-
Since no one else has mentioned it, the next RC for PRC v3.3 is up on the NWVault.
http://nwvault.ign.com/View.php?view=Hakpaks.Detail&id=7870
-
Freakin SWEET!
-
Very Nice. You all do great things, and a great job.
One question, do we know if the 3.3h merge pack listed at the link above include Fluffy's updated .tlk file? I checked the dates and I don't think it does. Since I know pretty much nothing about such things, I'm just curious if the 3.3h merge .hak and .hif files will work with the Fluffy's .tlk file created for the 3.3g merge.
Sorry if that doesn't make sense, I'm not the most tech savvy person out there. :-)
Again, thank you all for the hard work you put in--it adds incredibly to the fun.
Rev
-
Thanks for asking. I would have never noticed that I've used old (3.3g) tlk file to do the merges. Uploaded new versions to the Vault.
3.3h merge tlk (new one) will not work with PRC 3.3g.
-
I have about 7 people on my server all having a hard time with this update. Missing inventory items { base items2da change} quickbars empty and the wrong spells in place. This may be a isiolated instance or some failure on my part to have updated the server right but I would love to hear if anyone else has similar issues or you may wanna hold up if you run a PW and test before implementing more than normal. this was updating from 3.3g to 3.3hrc1
this is liekly a issue with the merge hak as opposed to a vanilla prc install as base items 2da has had some kinda changes it seems.
-
I have also noticed that 3.3h RC 1 doesn't install as easily in some modules, Endless Nights 4, for example. When I try to use the module installer, I get an error message that the content cannot be merged. I went through the time-consuming process of installing all the haks by hand in the toolset, using a successful automatic install of a different module as a way of figuring out the correct order and then placing the appropriate merge hak at the top (since EN 4 uses CEP 1.5 or so) and switching to the appropriate merge tlk. This process worked...sort of. In just a few moments of play, I noticed that the PNP weapon proficiency system isn't working (weapons can't be equipped without the right proficiency anymore), and that my level 1 bard has 99 bard songs! I like EN 4 very much but am reluctant to keep playing in a mod where something game stopping could go wrong later.
I have been able to automatically install PRC in EN 4 before without incident.
-
I have fixed some spells and updated almost all new spell books. Some characters (especially spontaneous spellcasters) may have problems with this - those would need to reselect their spells. It is always a risk when editing new spell books. New characters won't have any problems like this.
Which items are missing? Baseitems.2da haven't changed that much - i have added some more lines form CEP 2.3 and edited DefaultModel section (<.< this might have cause some problems, the models are present in CEP 2.3, but I'm not sure about older versions). I'll post a merge version without that modifications as soon as possible (this evening maybe) and write you a script which will allow your old characters to reselect their spells.
Does the module updater displays any other messages? Abut PnP weapon proficiencies, and 99 bard song uses - the PRC was not installed correctly - merge hak should go on top of all haks (will fix PnP proficiencies) and prc_rest should be added to OnPlayerRest event (fixes bard song uses).
-
AH my server has not updated to cep 2.3 we were using 2.2c previously. I can try updating to 2.3 and see what this corrects.It would seem some gems are missing models or gem bags as players opening gem bags are crashing when it tries to display items without 2d images associated.
Thanks!
-
Ok, I've attached the item+script to fix characters with new spell books without releveling (the item is called rod of wonder, just cast it's special power on players with broken spell book and wait a few seconds - quite big loops, no vfx, sorry. After rest the character should get option to select her spells again).
And here is the link for merge hak without modifications I mentioned, but still with new lines from CEP 2.3
http://www.sendspace.com/file/yokcdi
Hope this will help, and sorry I made new problems :<
-
Does the module updater displays any other messages? Abut PnP weapon proficiencies, and 99 bard song uses - the PRC was not installed correctly - merge hak should go on top of all haks (will fix PnP proficiencies) and prc_rest should be added to OnPlayerRest event (fixes bard song uses).
I don't have computer with NWN in front of me, but the updater stops relatively early. When it starts to build a merge tlk, it announces that the custom content (PRC) and the module contain content that can't be merged, and the operation aborts.
The merge is #1 in the hak list, but weapon proficiences are broken anyway. (I agree that in theory that should solve the problem, but it doesn't in this case.)
Before the updater always worked, even in installations where it builds its own merge hak instead of using the official one. However, when the updater does that, I have to install the newest PRC on a fresh copy of EN 4 each time a new version comes out to get the new material to work properly. I assume that has somethsing to do wtih the way the installer creates custom tlks and haks, but it is a real pain. I'd like to just be able to use the official merge hak and tlk, though at this point I would settle for anything, cumbersome or not, that worked.
Thanks as always for your help. And by the way, thanks for getting sublime chord done!
-
Does the module updater displays any other messages?
I don't have computer with NWN in front of me, but the updater stops relatively early. When it starts to build a merge tlk, it announces that the custom content (PRC) and the module contain content that can't be merged, and the operation aborts.
xwarren: I had a similar problem with a module (I forget which) and found it was due to item 30000 in prc_consortium.tlk.xml. This item only exists to document CEP reserved areas, but the id of the item falls within the area it's reserving. Changing the id to 29999 fixed the problem for me.
-
Thanks for the info CapnQ. I'll check this out.
-
I am having troubles with the precacher and version 3.3rc1 and the cepmerge for 2.3. My first few attempts resulted in mysql shutting down after increasing the maximum packet size i get a new error when importing the out file.
Error 1064 {42000} at line 1444373 { this is the same line that previously died to being too large}
You have a error in your sql syntax check the manual that corrospondsto your versions to use near 's_feast'; Insert into "prc_cached2da VALUES { cls+spct_healer', "level' 55 at line 1.
Now i dont know what that means but it sounds painful for healers : }
has anyone been able to precache on mysql yet?
-
Ok, I've attached the item+script to fix characters with new spell books without releveling (the item is called rod of wonder, just cast it's special power on players with broken spell book and wait a few seconds - quite big loops, no vfx, sorry. After rest the character should get option to select her spells again).
And here is the link for merge hak without modifications I mentioned, but still with new lines from CEP 2.3
http://www.sendspace.com/file/yokcdi
Hope this will help, and sorry I made new problems :<
Im seeing every PRC spell book caster as having problems when newly made. Entry in bug reports for specifics to it. THough I came across this, these are new characters having the issue not preexisting vault entries for my part, just wanted to clarify here as these issues seem similar to the ones i posted in bug reports on.
-
hope this is the right spot.
Just installed the3.3h, started a new game, now all armors look like human torso's. how do I fix this?
-
One thing I've noticed, and would ask for future versions, is that you would use the function: SQLEncodeSpecialChars(sString) to get rid of all the extra ['] apostrophes in names that cause this program to break when you try combining 2da's from other mods (CEP2, e.g.). It's a hunt and peck nightmare, on the receiving end. And of course, SQLDecodeSpecialChars(sString) when finished. Otherwise, the SQL caching and the batch file (the editted version I'm using to add other haks' data) seem to work just fine. Note that I can't say for sure, I'm only at line 3500 in apostrophe hunting after a good 90 minutes.
-
One thing I've noticed, and would ask for future versions, is that you would use the function: SQLEncodeSpecialChars(sString) to get rid of all the extra ['] apostrophes in names that cause this program to break when you try combining 2da's from other mods (CEP2, e.g.). It's a hunt and peck nightmare, on the receiving end. And of course, SQLDecodeSpecialChars(sString) when finished. Otherwise, the SQL caching and the batch file (the editted version I'm using to add other haks' data) seem to work just fine. Note that I can't say for sure, I'm only at line 3500 in apostrophe hunting after a good 90 minutes.
How are you going to use that function outside of NWN?
Here is how I do it.
1.) Download PSPad (http://www.pspad.com/).
2.) Open all the 2DAs you want to look through. On a semi-modern PC you can open 100s of text files with no problems.
3.) Search -> Find & Replace in files
4.) Replace all instances of ' with `, the symbol below the tilde (~).
5.) Save any changes. Should only be placables.2da & appearance.2da really.
That's 200+ 2DAs in about 5 minutes. :Dhttp://
-
Thanks DM Heatstroke, I really should have thought of that trick on my own. My opinion was really more a question of not knowing the sql writer's program's capabilities and limitations; if it could be done automatically, it should be i.e. If it can't, well that's it & that's that.
Now that I have this mostly installed, I would add the criticism that the straight prc_cached2da is a bit (well, a lot) excessive in size. 830,000 rows and counting. I can't report on the in-game SQL reads and the subsequent runtime deltas yet, but gut instinct tells me they might be a bit large and laggy--even on a pretty decent machine. I'll happily be proven wrong on this, btw.
Are there any plans to break down some of the individual 2da's into seperate tables, in a future edition? Some of these could be accessed quite a bit during game play, unless I am misunderstanding the purpose of these cached 2da's. Are they used soley for the CCC, or do the scripts make calls to them for other data during gameplay as well instead of Get2DAString and its kin? If the former, I would then further assert that their full potential is not being yet exploited.
Ooo, here's a question. I notice spells.2da in its own seperate file prc_cached_spells.2da, and also broken down into 200k or so lines of prc_cached.2da. Can the prc_cached.2da entries be deleted, or are both being used by the PRC system at this point?
PS: EDIT -- Before my criticisms are miscontrued, let me say that I've enjoyed the work of the PRC crew for many years; you people do a fine job here. I'm merely offering suggestions to try and help make a great thing even better if possible, as I'm unfortunately way too swamped to offer any real-time assistance.
-
Now that I have this mostly installed, I would add the criticism that the straight prc_cached2da is a bit (well, a lot) excessive in size. 830,000 rows and counting. I can't report on the in-game SQL reads and the subsequent runtime deltas yet, but gut instinct tells me they might be a bit large and laggy--even on a pretty decent machine. I'll happily be proven wrong on this, btw.
You don't need to precache every single 2DA. If you are using MySQL, try this precacher bat file instead. xwarren saved me a lot of time & CPU cycles with this.
del precacher2das\*.2da
mkdir precacher2das
7za x bioware2das.7z -oprecacher2das
erf -x -v hak\prc_2das.hak
erf -x -v hak\prc_race.hak
copy cls_feat*.2da precacher2das\*.2da
copy cls_skill*.2da precacher2das\*.2da
copy race_feat*.2da precacher2das\*.2da
copy spells.2da precacher2das\*.2da
copy racialappear.2da precacher2das\*.2da
copy racialtypes.2da precacher2das\*.2da
copy classes.2da precacher2das\*.2da
copy feat.2da precacher2das\*.2da
copy domains.2da precacher2das\*.2da
copy appearance.2da precacher2das\*.2da
copy portraits.2da precacher2das\*.2da
copy soundset.2da precacher2das\*.2da
copy wingmodel.2da precacher2das\*.2da
copy tailmodel.2da precacher2das\*.2da
copy gender.2da precacher2das\*.2da
copy hen_companion.2da precacher2das\*.2da
copy hen_familiar.2da precacher2das\*.2da
copy custom2das\*.2da precacher2das\*.2da
del *.2da
del *.nss
del *.ncs
java -Xmx1024m -jar prc.jar 2datosql precacher2das MySQL
The custom2das folder would be where you placed any 2DA modifications.
-
Thank you, both of you. :) That was such a neat clean list, I decided to use your batch file and do it again, instead of all those DELETE FROM queries on the tables I just built.
I still think this sql caching of 2da's could have broader scope, as long as benchmarks agree with my theory--though I understand it's not your responsibility to do so. Thanks again for all the help, and for all the work you guys do here.
-
A bit of a problem, and I've had it with two different installs of this (one by the batch file above, one from a manual collection of the 2da files). The convo locks up after choosing race, before class. I can see the initial data from the class SQL read in nwnx-odbc, it stops right at 254>CLAS_PRES_BRAWL. This means it completed at least the first read, AFAIK. But after that, nothing. Even after relaxing, and having two Slurms.
Also, there is an empty table prc_cached2da_ireq and no item_to_ireq is even created. Are these outdated tables by chance? I don't know what data would be going in them, to check against--the names don't resemble any 2da's in any mod or original campaign file I've checked.
-
There is a typing error in classes.2da, at line 190 (archivist class). Insert 'CLS_PRES_ARCHV' instead of 'cls_pers_archv', rebuild the database and ConvoCC will work again. Sorry for trouble.
-
A bit of a problem, and I've had it with two different installs of this (one by the batch file above, one from a manual collection of the 2da files). The convo locks up after choosing race, before class. I can see the initial data from the class SQL read in nwnx-odbc, it stops right at 254>CLAS_PRES_BRAWL. This means it completed at least the first read, AFAIK. But after that, nothing. Even after relaxing, and having two Slurms.
Double check that your 2DAs haven't got corrupted somehow or have an extra formatting character snuck in there. That is what happened when I was seeing a similar error.
Also, there is an empty table prc_cached2da_ireq and no item_to_ireq is even created. Are these outdated tables by chance? I don't know what data would be going in them, to check against--the names don't resemble any 2da's in any mod or original campaign file I've checked.
I know item_to_ireq is outdated. I usually remove the indexing of it at the bottom of the out.sql before importing it.
-
There is a typing error in classes.2da, at line 190 (archivist class). Insert 'CLS_PRES_ARCHV' instead of 'cls_pers_archv', rebuild the database and ConvoCC will work again. Sorry for trouble.
Oh yeah, that too. :D
-
Lol, no problem, glad it wasn't on my end cause I couldn't figure out what I was doing wrong. 2da's weren't corrupted, as I had checked them all for replacing ' with `. I'll delete that ref to item_to_req in good faith then.
I just remembered another issue I had with the letoscript setting NWN_DIR. My computer is 100% backslashes, so I had to recreate the path all the way down to the client folder. Maybe consider a NWN_SERVERVAULT_DIR setting, and an NWN_SLASH_LAST string "\" (for the last folder)? Most of us using the PRC probably have the skills to edit the script, and put it in the top hak--but for those that don't, this would be a saving grace.
EDIT: One more question: there is spells data in both prc_cached2da and in the prc_cached2da_spells tables. Are both necessary, or is the prc_cached2da's spell data a leftover from a previous version, in the prc.jar file?
EDIT PS: Deeper research shows it's a custom 2da called prc_spells.2da, and it ends at entry 4071. Considering the length of the 3.3h spells.2da, I'm going to guess obsolete. It's in the prc_2das.hak.