Player Resource Consortium
Neverwinter Nights => Help => Topic started by: VikingenTor on July 15, 2010, 04:55:41 AM
-
So here is the deal.
After a looong time I actually managed to get this whole thing going, wich for a technically gifted man such as myself was nowhere near enough as easy as you made it seem. But enough about that *smiles*
Now I have one question and one problem (or that would mean two questions, cause I also like to know what I can do to help the problem)
The ConvoCC works, in a manner of speaking, but:
I can only choose male as sex, no matter what. And the reason for this is simple. When I created the out.sql (using mysql) it all went smooth, but when I restore the sql dump into the databse he suddenly gives me a error message saying
"Error occured at:2010-07-14 16:13:41
Line no.:666769
Error Code: 1146 - Table 'selune.prc_cached2da_item_to_ireq' doesn't exist
Query:
CREATE UNIQUE INDEX `refrindex` ON `prc_cached2da_item_to_ireq` (`L_RESREF`, `rowid`)"
What can I do about that. Tried making new out.sql files, changes nothing. Tried manually creating the table to no avail.
Aslo I would like to know. Is there a way to instead of right when you log on to the server you have a "lever" people can use to start ConvoCC should they wish to?
And two, since I plan to use dolls to adjust looks, how would I do to change what things are asked in the ConvoCC? I want to remove all "looksrelated" questions in short.
Well there we go, that is pretty much what I would like help with, and since I am not really skilled at this probably more later.
Oh and since I have no idea what you have or have not done with the sequel, I am talking about NWN 1 :)
-
So here is the deal.
After a looong time I actually managed to get this whole thing going, wich for a technically gifted man such as myself was nowhere near enough as easy as you made it seem. But enough about that *smiles*
Now I have one question and one problem (or that would mean two questions, cause I also like to know what I can do to help the problem)
The ConvoCC works, in a manner of speaking, but:
I can only choose male as sex, no matter what. And the reason for this is simple. When I created the out.sql (using mysql) it all went smooth, but when I restore the sql dump into the databse he suddenly gives me a error message saying
"Error occured at:2010-07-14 16:13:41
Line no.:666769
Error Code: 1146 - Table 'selune.prc_cached2da_item_to_ireq' doesn't exist
Query:
CREATE UNIQUE INDEX `refrindex` ON `prc_cached2da_item_to_ireq` (`L_RESREF`, `rowid`)"
What can I do about that. Tried making new out.sql files, changes nothing. Tried manually creating the table to no avail.
Could you please paste here the contents of your nwnx_odbc.txt file (in NWN\logs.0 dir). This should tell us if there are any problems with database.
Aslo I would like to know. Is there a way to instead of right when you log on to the server you have a "lever" people can use to start ConvoCC should they wish to?
And two, since I plan to use dolls to adjust looks, how would I do to change what things are asked in the ConvoCC? I want to remove all "looksrelated" questions in short.
Do not set PRC_CONVOCC_ENABLE switch and add 'prc_ccc_main' script to OnUsed event of yor lever.
To remove all appearance related options from ConvoCC you will have to edit ccc_inc_convo.nss file (in prc_include.hak) and set the conversation stages in correct order. After that you have to recompile prc_ccc_main.nss script.
-
That file was a rather long one. But I looked trough it, and it seems that it is just a load of got request and sent response. And looking trough it (wich I have never done before) it at least at no point say anything about any problems occuring.
So if that file is as nice as all the others I am assuming that there is no problem there.
I am curious if I may be missing some 2DA file, would that explain the problem? I am really at a loss here trying to figure it out. As I said I am new to all this so it is not like I changed any files so far (though I guess I am about to *smiles*) so shouldn't be that either, though who knows, might have fugded something up by misstake.
Anyway, thanks for a really speedy (and helpful of course) response, and if you still want to see the txt-file I can post it, just assuming it is not needed, cause as I said, it claims no faults
-
I would like to take a look though - just to be sure. Could you use pastebin.com or sth and post a link here?
I'm don't know how important that 2da is. Well... I don't have that file and everything works so *shrugs*. Still, it could be MySql problem.
-
Query:
CREATE UNIQUE INDEX `refrindex` ON `prc_cached2da_item_to_ireq` (`L_RESREF`, `rowid`)"
Delete the last line of your out.sql before you import it. It's not needed.
Aslo I would like to know. Is there a way to instead of right when you log on to the server you have a "lever" people can use to start ConvoCC should they wish to?
Yes.
From prc_inc_switch.nss:
/**
* When set, the convoCC NO LONGER STARTS AUTOMATICALLY on logging in. It must be called
* by a script in the module. This allows the module builder to start the convoCC from a
* particular area or trigger's On Enter event. The script should call the convoCC with
* ExecuteScript("prc_ccc_main", oPC) where oPC is the PC. It's advisable to check the
* entering object is a PC and not a NPC or DM.
*/
const string PRC_CONVOCC_CUSTOM_START_LOCATION = "PRC_CONVOCC_CUSTOM_START_LOCATION";
/**
* When set, this switch causes a custom script to be used to determine whether a PC should go
* through the convoCC or not.
* The script must:
* - be called "ccc_custom_enter"
* - set the local int "CONVOCC_LAST_STATUS" on the PC (OBJECT_SELF)
* - include prc_ccc_const (for the constants the local int can be set to)
* otherwise the PC will always be booted
*
* possible values for CONVOCC_LAST_STATUS:
* CONVOCC_ENTER_BOOT_PC (causes the PC to get kicked)
* CONVOCC_ENTER_NEW_PC (causes the PC to go through the convoCC)
* CONVOCC_ENTER_RETURNING_PC (causes the PC to skip the convoCC)
*
* This switch will completely bypass the convoCC methods for determining whether to run the
* convoCC on an entering PC, so if necessary, your custom marker for 'done' would be set
* in 'ccc_custom_exit'
* @see PRC_CONVOCC_CUSTOM_EXIT_SCRIPT
*/
const string PRC_CONVOCC_CUSTOM_ENTER_SCRIPT = "PRC_CONVOCC_CUSTOM_ENTER_SCRIPT";
-
Thanks, it worked fine just removing the last stuff :)
But the problem wich caused me to realise something is wrong (and I thought would sort itself once this was done) remains. I can only choose gender: Male
I have buttloads of classes and races, but I only get one sex... Enough for me but still *laughs* there is obviously something wrong there.
Again I like to thank you both for a suprisingly quick support on my noobiness :)
-
Thanks, it worked fine just removing the last stuff :)
But the problem wich caused me to realise something is wrong (and I thought would sort itself once this was done) remains. I can only choose gender: Male
I have buttloads of classes and races, but I only get one sex... Enough for me but still *laughs* there is obviously something wrong there.
Again I like to thank you both for a suprisingly quick support on my noobiness :)
Make sure your gender.2da file isn't damaged. It should be taken from bioware2da.7z file during precaching, so make sure it's not damaged & that you are using a recent version of the PRC Server Pack.
-
So if we assume that is damaged, what do I do then? I tried dl'ing the 2DA's from Biowares site and put it in the 2DAsourse file, tried re-precaching them and then run it trough the db again (after removing that last line :P) and exactly the same thing happens again.
-
So if we assume that is damaged, what do I do then? I tried dl'ing the 2DA's from Biowares site and put it in the 2DAsourse file, tried re-precaching them and then run it trough the db again (after removing that last line :P) and exactly the same thing happens again.
Then it's not damaged. Are all the base classes showing up correctly?
p.s. you should post that log that xwarren wanted to see.
-
Yeah, Xwarren, you shouldn't think I am ignoring your request. I just haven't spent more then a moment by the computer, so it was just that I didn't take the time to sort it... Untill now.
Never used pastebin before but http://pastebin.com/kCeX5skr this should take you to it as far as I understood it all :) Otherwise yell at me and I will fix it :)
-
For some reason FILE_END switch for gender.2da is not set correctly in your module. Try adding it manually. All you need to do is set in Toolset/Module Properties/Advanced Tab/Variables a local int called PRC_FILE_END_gender to 1. Hope this helps.
-
*sighs* Nufink, tried that, still just male :´(
-
*sighs* Nufink, tried that, still just male :´(
I *think* you need this one set too.
/**
* If this is set it will disable the defaults and the module builder must set
* the values manually.
* Otherwise it will set the automatically, and will take the PRC companion
* into account, including CEP if its the CEP/PRC companion.
*/
const string FILE_END_MANUAL = "FILE_END_MANUAL";
What I don't know is if you'll need to set a file_end for all of the other 2das that use them.
-
Back again, had some RL to deal with *smiles*
Now does this mean I should put this in variables as a string? Cause I tried that and nothing. Using both with and without the "'s
Or should I change within some script, in this case, what script would that be?
-
Could you try running ConvoCC on other module, ie Prelude (OC), first?
Maybe some scripts from your module are conflicting with PRC scripts?