New Server Issues

[demonstar55]

http://www.eqemulator.net/wiki/wikka...ssingFilesList

If you want to do a bunch of work you can have post GoD zones working. (Basically they need db/quest work done)

[SoltanHeatwave]

Originally Posted by demonstar55

http://www.eqemulator.net/wiki/wikka...ssingFilesList

If you want to do a bunch of work you can have post GoD zones working. (Basically they need db/quest work done)

Thank you demonstar, I looked at that a while ago and didn't do it because I used a different version of the client. As a test I reinstalled an old version of EQ (Everquest Trilogy), I have older versions, but that seemed to fix the UI problems I was having in Freeport. There is a minor detail though, I had to copy all of the Freeport files from the older client to the new one to get it to work. When I selected the files he pointed out I still had the same problem so I just copied everything that said Freport on it. That worked. Still looking around in the forums to find solutions to my other problems. Thank you for your help.

[SoltanHeatwave]

I got everything on the server side running except for the Mercenaries. I attempted to follow some suggestions on this forum for incorporating them, but the files they mention don't appear in any of my server, sql, or source folders.

Instead I think I will just give up on the idea of Mercs on the server and re configure the whole thing without the bots. Thank you for your help guys.

[rencro]

Mercs and bots are two different things...

[SoltanHeatwave]

Originally Posted by rencro

Mercs and bots are two different things...

The misunderstanding is my fault, sometimes when I get a little frustrated, I write about two things at the same time, like the bots and mercs. Bots, are programs that people use, primarily, to control their PC's while they are afk or to farm an area. Mercs, are the in game items that follow you in group and act like PC's and take a PC slot. I have been thinking about disabling them both. I have been having some real problems so far that I believe are server side, particularly with my server.

Merc merchants don't hail and you can't click on them. I have been looking at some of the remedies on the boards, but some of the files they mention ie.. the .sql files for the mercs aren't anywhere in the download/source section, or anywhere in any of my sql folders. Other quest npcs like the exterminator NPC's located in each beginning cities don't respond to hails or give out their quests. Other quest NPC's in PoK for example will not answer hails, no matter how close you are to them, unless you speed click 15 or 20 times, others it doesn't matter how many times you click they won't respond, they just stand there with their name and armor quests or what ever quests appear over their name. The wayfarer brother hood NPC in Freeport doesn't respond to hails, the one in RatheMountains does. These are things I don't even know where to start to try and fix.

Quest mobs: Some of the Quest npc's answer hails and give their quests. Others don't. For example The Karanna mob in Bastion of Thunder won't answer hails after he spawns so you can't leave the tower.

The seeker mob in Temple of Ro, for the cleric epic 1.0 quest, doesn't respond or is listed as existing when he does spawn. I attempted to hail him and didn't get a response. When I attempted to despawn him I got you need to target an npc to use this command. When I depopped the whole zone he was still there. I logged out, restarted the server and logged back in. When he finally did respawn I still couldn't target him or get any response, or indication, from gm commands that he was even there.

Again, I am not experienced in perl, or sql programming, but I would like to get these problems solved. I am thinking maybe redoing the entire server with the newest sql database might resolve some of these, but they have been issues since I started doing this. I have only been doing this though, for a few weeks when I first found out about this site and these programs. So I am an extreme newbie both to this site and to running this server, but I am learning a lot from doing it, and I do know my way around a computer. Are there any .pdf guides that can help run and administer the server?

Thanks so very much all your help.

[rencro]

Actually mercs are now built into the code, just need to activate them via sql queries to enable them as they are not enabled in the deafult peq db, bots, in reference to EQEMU, are an optional build, when you run cmake, there is an option to build "bots", but, unfortunately the process of building "bots" is not enough to enable them.

So they are, in eqemu terms two different but similar entities..The bots and mercs function almost exactly alike, with the exception the bots can be used to build whole raids, but they act almost like mercs, as they have similar code. But with bots you can give them gear as you acquire it...

I wrote about this a while back, in this thread:

http://www.eqemulator.org/forums/showthread.php?t=37295

[SoltanHeatwave]

Originally Posted by rencro

Actually mercs are now built into the code, just need to activate them via sql queries to enable them as they are not enabled in the deafult peq db, bots, in reference to EQEMU, are an optional build, when you run cmake, there is an option to build "bots", but, unfortunately the process of building "bots" is not enough to enable them.

So they are, in eqemu terms two different but similar entities..The bots and mercs function almost exactly alike, with the exception the bots can be used to build whole raids, but they act almost like mercs, as they have similar code. But with bots you can give them gear as you acquire it...

I wrote about this a while back, in this thread:

http://www.eqemulator.org/forums/showthread.php?t=37295

I did as this thread instructed and received this error

uery OK, 0 rows affected (0.00 sec)

Query OK, 21 rows affected (0.00 sec)
Records: 21 Duplicates: 0 Warnings: 0

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.03 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 3 rows affected (0.00 sec)
Records: 3 Duplicates: 0 Warnings: 0

mysql> source source_views.sql
Query OK, 0 rows affected (0.02 sec)

mysql> UPDATE 'npc_types' SET 'class' = 71 WHERE 'lastname' LIKE '%Mercenary Liaison%';

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near ''npc_
types' SET 'class' = 71 WHERE 'lastname' LIKE '%Mercenary Liaison%'' at line 1
mysql>

Am I using the correct version? The version of SQL, that I am currently using is 5.1.68