Good call. It worked with just the PRC installed, using the same database I built for the other mod. So, it must be something or other on my end. I really don't have a lot of scripts installed in the top hak, and yours should be overriding the lesser scripts...hmmmm. When I figure it out, I'll be certain to let you know. Maybe somebody else can benefit from the knowledge. Thanks for all your assistance.


EDIT: Solved it! I didn't catch your packages custom entry for the EquipableSlots column in baseitems.2da, for creature skin. The change made all the difference. It was one of the last files I yanked from the package, I hadn't even imagined that could be the issue. I guess I was more concerned with dealing with other baseitem.2da conflicts between packages, I didn't even look up top. That can be the lesson to you the rest, to learn from my mistakes. Always check all entries between 2da's, even Bioware's, with a comparison software.

Thanks again for all your help. I can't wait to see a bit more of this, now that I got it working.

I''m having the same problem as this poster, except the vote of 1 part. A fellow designer wouldn't do that to another.

I've got debug code from a warmage I just made after getting the convo to work and the databases set up. It looks like it's reading from the cache just fine, only it's not creating an array or giving any actual spell uses.

I posted a log here so you could see what was going on. I haven't dissected your systems sufficiently, to tell what I've done wrong sorry. I have the switches set in module for anything database related, and personal_switch.2da for module (which also isn't being recognized according to the dyn_convo when called on to set values, but that's a different tale). If I've done something wrong, I'm not seeing it. Nor have I seen any other threads about it, so I have to ask.

Is it of note, that I didn't see a single entry in nwnx-odbc log about any of the data in the server log above? Or is the MySQL database being used exclusively for the ConvoCC, and the campaign database for everything else?

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.

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.