Now NPCs wont talk

[CruelCahal]

Ok, I'm obviously missing something here because the NPCs are not responding to hails anymore.
I don't know if it's a Perl problem or a Lua problem and I don't know if I have everything configured properly. I can build, run the build, etc. with no problem there are just no responses from the NPCs. I get this problem with the PEQ daily build as well as my older PEQ. Prior to the Lua switch, everything was fine.

Here is how cmake is set up pathwise.


I did actually install Lua on my system in addition to downloading the dependencies. Is there anything additional that needs to be done? Like with running the PPM command line stuff for Perl, is there something like that for Lua? Do we require the "quests" download from the PEQ daily build as well?
I apologize for being completely stupid, I just know next to nothing about scripting, how it is supposed to work, and how to troubleshoot it.

[CruelCahal]

Looks like mercs wont spawn either. I can select one and click Hire, but then get the message "Mercenary failed to spawn!" I can still buy from merchants and interact with bankers.

[KLS]

Do you use PEQ's quests or do you have custom ones?

[Robregen]

The mercenaries are set at warrior or '1'. Due to a bug with Merc on PEQ, we had to switch the class to warrior. You will need to set class to '71" which is the mercenary liason. At least that from the daily dump.

did you download the latest quest? There were some changes made to the quest system in order for Lua system to work.

[CruelCahal]

I've been using the PEQ quests from the SVN but started using quests from the daily build download. I've been messing around with the Lua paths having cmake use the files from my the Lua install on harddrive and also having it set to use the dependencies folder in the source directory. Neither seems to work.
I'm using the daily build from today and the PEQ already has the liasons set to class type "71". I've been using the PoK soulbinder and quest giver opposite her to test for NPC dialog, just FYI, but no one will speak to me anymore.
Am I missing some files or are my paths not setup properly in cmake?
I don't see any kind of errors during build or in the logs but there is clearly a problem.
I've been at this for hours and can't figure out why NPCs won't talk anymore.

[KLS]

In game hail someone, then run the #questerrors command and tell me if you get any errors.

[cavedude]

Originally Posted by CruelCahal

I'm using the daily build from today and the PEQ already has the liasons set to class type "71".

Check to make sure you sourced your database correctly, because PEQ has no NPCs with class 71 in the database, and hasn't for a while.

mysql> select count(*) from npc_types where class = 71;
+----------+
| count(*) |
+----------+
|        0 |
+----------+
1 row in set (0.26 sec)

That's right from the gameserver which is what dumps the daily database.

[CruelCahal]

@KLS

Ok, I did that and got a heap of errors. It looks like it's telling me some .dlls are missing from the server folder. I don't know how you log chat windows output to a text file so here is a screen capture of the errors. It looks like I don't have Lua setup properly or the right files in the right place.


@cavedude

Ok, I did that and got 37 count back. Now, I used the daily build from yesterday but I guess I'm sourcing or not sourcing the right SQls. I don't know exactly what is different about the daily build compared to the last 2506 SVN build. Are there SQLs I shouldn't be sourcing that I normally would source with the old SVN build? I want to have mercs and I've been sourcing the following, perhaps the error lies with this.
I got this from another post when mercs weren't working right and before the Lua switch.
In order...
/utils/sql/svn/2380_optional_merc_data
/utils/sql/svn/2380_optional_merc_merchant_npctypes_update
/utils/sql/svn/2380_optional_merc_rules

/utils/sql/svn/mercs.sql
/utils/sql/git/required/2013_02_18_Merc_Rules_and_Tables
/utils/sql/git/optional/2013_02_18_Merc_Spells
/utils/sql/git/required/2013_02_25_Impr_HT_LT
/utils/sql/git/required/2013_03_1_Merc_Rules_and_Equipment
/utils/sql/git/optional/2013_03_14_Merc_Spells
/utils/sql/git/optional/2013_03_18_Merc_Spells


#questerrors

[KLS]

You wouldn't happen to have the perl512.dll in your server's directory would you? The times I've personally seen &main::eval_file fail it's when the perl install has been messed up like that.

Also, right now the lua_modules directory works like plugins does for perl and needs to be in the root of the server directory.

[CruelCahal]

Ah, yes there was a perl512.dll hanging out in the server folder. I threw it away, then copied the lua_modules over from the quests folder into the serverroot, went into the game, and bam, the NPCs are talking again. Ran #questerrors and it came back with nothing, no errors at all.
YOU are the man! Thank you much!

Now I just need to fix the "Mercenary failed to spawn!" problem. So I'll start over with today's daily PEQ build. Hopefully cavedude can help me figure out what I screwed up, since mercs were working fine with the previous SVN PEQ build I was using. Obviously a sourcing issue.

[sorvani]

Make sure that when you extract the .tar.gz file that you are actually extracting everything.
Assuming you have 7 zip,
Right click on .gz choose 7zip extract here.
Now you have a .tar file.
Right click on .tar and choose 7zip extract here
This will extract the peqbetaxxxxxxxxx and drop_system SQL files.

Open a command prompt.
cd \eq\sql
mysql -uroot -ppassword peq
source drop_system.sql
source peqbetaxxxxxxxxx.sql
exit
exit

Launch your start.bat

[CruelCahal]

Originally Posted by sorvani

Make sure that when you extract the .tar.gz file that you are actually extracting everything.
Assuming you have 7 zip,
Right click on .gz choose 7zip extract here.
Now you have a .tar file.
Right click on .tar and choose 7zip extract here
This will extract the peqbetaxxxxxxxxx and drop_system SQL files.

Open a command prompt.
cd \eq\sql
mysql -uroot -ppassword peq
source drop_system.sql
source peqbetaxxxxxxxxx.sql
exit
exit

Launch your start.bat

I've done that Sorvani, many times. I've even manually dropped all merc tables, sourced in the daily build and the specialabilites.sql so the NPCs show up, and sourcing nothing else at all, and then launch. Still, none of the merc liasons will pop the merc hire window at all. If I set their class_id back to "71" like it was in the previous SVN DB, then the merc hire window pops but then I get the merc failed to spawn message. Do mercs work for you?

[Robregen]

yeah I just enabled the mercenary and set class to 71. I too get the message "mercenary failed to spawn". I have no idea why.

[Fatmaneric]

Originally Posted by KLS

In game hail someone, then run the #questerrors command and tell me if you get any errors.

I'm running into this problem as well. I did have the problem with the DLL but I've fixed it. Now I don't get any errors when I do #questerrors, but the NPCs still don't respond. I do not have Lua running as it was not part of the setup guide stickied to the top of the forum, and I have't really seen anything that tells me what it is.

Sorry if the answers are obvious and in front of my face, but it's well after 4AM, I should have been in bed yesterday, but this is sucking me in too much.