New Server Issues

[SoltanHeatwave]

I just built my EQEmu server and am experiencing some perplexing issues. I am a complete newb at running this server. I am just glad that I got it up and can login to it.
I followed the guide located here (http://www.eqemulator.net/wiki/wikka.php?wakka=WindowsServerSetupGuide) and was able to get the server up and running and was able to login to my server. When I used CMake there were no reported errors and when compiled with VB 2012 express I didn't get any errors. I have found and attempted fixes that I found on the forums, but nothing yet seems to work. The problems I am experiencing are:
1. When I click anywhere on the client, while zoning I crash to desktop. As long as I don't click anywhere inside the client interface while zoning the zone will load.
2. I downloaded and used the peqbeta_2013-11-22-02_01.sql database. Primarily because I couldn't locate and download any other. The database, user files and bot sql files loaded without any errors. When I attempted to import the required sql files located in the source\utils\sql\git\required folder I get tables not found errors. So I redid my database without importing these files.
3. The gates of discord will not load. I keep getting that "the plane of discord is closed to me" from the priest in PoK, but when I guilded myself and went into the guild hall I got the walls of slaughter item for the transporter, and when I stepped into the transporter nothing happened. My client is a SoF retail version that I purchased years ago. That version does have the Gates expansion on it.
4. When in the guild hall, I cannot exit back into the GL, because the exit door is missing. The door is replaced by a sky graphic that cannot be clicked.
5. When I click on the freeport stone I get an option to zone into the old style Freeport, which I really like, but when I do the graphics are wrong, all the npc humans and mobs look like regular unarmored humans. The mobs aggro correctly in this zone. When I zone into the new Freeport the graphics are correct, but none of the mobs aggro at all. This is reversed in the new Ak-Anon zone. In the new zone the graphics are good, in the old zone they are wrong. In both instances how ever the new zones mobs will not aggro at all. I have tried reloading maps, even deleting the map folders and redoing them from scratch. In the new Ak-Anon zone the PoK pedestal is missing.
6. I do not get any kind of aggro from any mob at all in any expansion after the Omens of War expansion. This includes the new Commonlands and Steamfont zones. I can't check Omens since I cannot get to the zones.
7. I cannot get bots at all. When I compiled the server with CMake, I ensured that I checked the Bots box. I even redid the make and recompiled it in VB 12. I ensured that the Load_bots sql script was loaded. I don't get any response from the Bot merchants.
8. Quests don't work. When I hail a quest agent I get no response from them at all. I was able, after spending some time in the game zoning around and checking out mobs, I went back to PoK and started to get the "A mysterious stranger" tells from the wayfairers, so I went to the quest NPC standing next to the PoK binder and was able to get a quest. I zoned to a number of other zones and even though I was getting the wayfairers recruitment tells I wasn't able to get any of the quest NPC's to respond. In fact I am not getting a response from most NPC's when I hail the.
8. I attempted to use admin tool 5.9, but keep getting can not load database. I have checked the ini file and have tried different configurations for the locations of the path values, and ensured that the user name and password were correct.
9. The portal to Jagged Pine Forest is missing in the Glade.

Steps I have taken: I have totally deleted all folders and started from scratch, I have redownloaded the maps, deleted the maps directory and reloaded again. I have tried numerous solutions posted on the forums. So far nothing has worked.
I don't know anything at all about the sql database, but when I loaded it, I didn't get any errors.

Thank you in advance for any help you can give to me.

[SoltanHeatwave]

Thanks to HnathBST I got the Priest of Discord working, and the mobs there do aggro. Still can't get the guild portal to send me to Walls of Slaughter.
Guild Hall Door, inside the Guild Hall is still broken. The quests are intermittent I have to zone out and rezone back in to get some quest mobs to respond to me, including the Priest of Discord.

[SoltanHeatwave]

I just also noticed that when my character falls he doesn't take damage from falling he gets a message "You have taken 8 points of type 252 environmental damage"

[Kingly_Krab]

I just also noticed that when my character falls he doesn't take damage from falling he gets a message "You have taken 8 points of type 252 environmental damage"
If you have your Gamemaster flag on, you will take no fall damage, turn it off with '#gm off'.

[SoltanHeatwave]

Ok, that worked. Thank you. I have to get used to not being a PC on my server. I am going to keep it on and the server locked until I get the issues I am having with it resolved. It might be the way I am doing my searches, but I am showing no results whenever I search for the issues that I am having. Maybe I don't know even enough about what is going on with the server to ask good questions about. Are there any guides for running the server, and maybe resolving these kinds of issues. I have been downloading the new database files, but I am not sure whether I should source them in or redo the database from scratch. I also don't know how to resolve the issues I am having. A lot of the posts are rather old and when I try some of them, they don't work, or there are files that they reference, but either don't exist anymore or I didn't get with my downloads. Thanks for your help.

[sorvani]

Having the GM flag on has nothing to do with having the status to login when the server is locked. those are different things.

Yes, you have no clue what you are doing, but at least you asked.

# commands are tied to the account status and have nothing to do with being flagged as a GM in the client. Aside from the fact that someone with high enough status has to use the #gm on command on a character in the first place. You do not have to be flagged as a GM to use all the # commands your status gives you access to.

Just being a GM does not grant anything other than the green name really. Mobs will not aggro by default and no falling damage is about it. This is not live.

[SoltanHeatwave]

I lowered my account to status 0 and unlocked the world. I went back into my server and I am still having the same aggro issues in the same zones. So I don't think that being a GM, at least on this server has anything to do with obtaining aggro. I have tried redownloading the maps several times already and copying them into the maps folder. I even deleted the maps folder a couple of times and reinstalled them fresh, with each version of the maps I downloaded. Nothing at this time seems to resolve the issue. Thanks for your help though.

[joligario]

Are you putting them like "/eqemu/Maps/{zone}.map" or in "/eqemu/Maps/Maps/{zone}.map"?

[lerxst2112]

You don't need to change the status of your account, you need to type "#gm off".

[SoltanHeatwave]

Are you putting them like "/eqemu/Maps/{zone}.map" or in "/eqemu/Maps/Maps/{zone}.map"?
I am putting them in the Maps folder. I don't have a maps sub folder in the maps folder. The full address is C:\EQ\EQEmuServer\Maps.

[SoltanHeatwave]

You don't need to change the status of your account, you need to type "#gm off".
Ok, thank you for the information. I really am learning from this. I hope to one day be able to actually be of some help to another newbie like me.

[SoltanHeatwave]

I really want to get my server up and operational. Any help would be greatly appreciated. Thank you for your help.

[joligario]

What are your current issues? Delete your old log files and start your server again. Stop the server when you encounter errors and post the new log files.

[sorvani]

His current issue is that he does not understand the difference between status and the GM flag, even thigh it was explained already.
Also he calls the OoW zones GoD.
As the OoW zones a re basically untested by any experienced did yet, who know what condition they are in..

[SoltanHeatwave]

I do know the difference between having the GM flag enabled and disabled. I only enabled the GM flag once, and after reading the boards took it off and have never enabled the GM flag since then. I am going through my error logs now. I'll post them later. Yes I did made one mistake in referring to the OoW zones, frustration can sometimes be very annoying, but that doesn't explain why I can't use the guild teleporter to get to Wall of Slaughter when I can use it to get to other zones. That is zones prior to Planes of Power. None of the zones after Planes of can be accessed by the Teleporter nor do any of the mobs agro there, irregardless if I am GM flagged or not. I even created a new account that has 0 for it's capabilities and none of the mobs there agro. There are no subdirectories in my Maps folder, I downloaded the newest maps I could find and so far nothing works. I may be very inexperienced as far as the EQEmu server is concerned, but I do know my way around a computer. I am sorry that I am not an expert Perl or SQL programmer, but that is why I am asking for some help.

[Mariomario]

Most zones post GoD are rather incomplete in regards to faction setting and stats. You can make changes to the NPCs in OoW and any other zone you choose through the npc_types table. I would highly recommend taking a look into georges tools though. The interfaces make editing the database very user friendly. To make NPCs aggro however you will want to edit their faction id. An ID of 79 is a general KOS faction.

As far as getting to WoS through the guild porter, I believe your normal accounts cant get their because OoW+ zones have a minimum status setting by default since PEQ has not reached those stages, so they keep those zones off limits to their players. You can change these settings in the zone table of the database by editing the min_status to 0.

[SoltanHeatwave]

Here are the only errors that were reported in any of the logs.

---------------------------------------------
[11.30. - 22:08:09] Starting Log: logs/eqemu_error_zone_3992.log
[11.30. - 22:08:09] Path File ./Maps/steamfontmts.path not found.
[11.30. - 22:11:08] Path File ./Maps/steamfontmts.path not found.
[11.30. - 22:13:43] Path File ./Maps/steamfontmts.path not found.
[11.30. - 22:17:58] Path File ./Maps/gfaydark.path not found.
[11.30. - 22:19:25] Path File ./Maps/guildlobby.path not found.
[11.30. - 22:21:10] Path File ./Maps/ecommons.path not found.
[11.30. - 22:24:23] Path File ./Maps/guildhall.path not found.

---------------------------------------------
[11.30. - 22:09:26] Starting Log: logs/eqemu_error_zone_3184.log
[11.30. - 22:09:26] Path File ./Maps/dragonscale.path not found.
[11.30. - 22:11:41] Path File ./Maps/lopingplains.path not found.
[11.30. - 22:14:01] Path File ./Maps/lopingplains.path not found.
[11.30. - 22:17:17] Path File ./Maps/lfaydark.path not found.
[11.30. - 22:19:45] Path File ./Maps/guildhall.path not found.
[11.30. - 22:22:29] Path File ./Maps/freportw.path not found.
[11.30. - 22:24:02] Path File ./Maps/guildlobby.path not found.
[11.30. - 22:26:42] Path File ./Maps/iceclad.path not found.


I have redownloaded and redone the server a few times already, and I have not found these .path files in any folder or subfolder. I don't know if these missing files would cause quest npc's to intermittently answer hails, or seeing incorrect graphics for particular mobs, or having an incorrect image in the guild hall or not.

Thank you MarioMario. I tried it with my 250 flagged account and the guild portal still didn't work. I can only go to pre pop zones. I can set the teleporter to another zone like dragonscale hills, but when I step into the porter nothing happens. Again that is with a 250 flagged account, not gm flagged and xp and level set to 65. I found the gm commands and leveled the character up to 65, without being gm flagged, just to try the porter as a level 65 toon.

[Mariomario]

Inside of the guild hall quest folder, the player.pl is where your problem lies. This is where the answer for the pop up occurs.

sub EVENT_POPUPRESPONSE {
if ($popupid == 666) { #hateplaneb
quest::movepc(186,-393,656,3);
}
if ($popupid == 674) { #airplane
quest::movepc(71,539,1384,-664);
}
if ($popupid == 15891) { #dragonscale
#quest::movepc(442,-1954,3916,19);
}
if ($popupid == 2708) { #northkarana
quest::movepc(13,1209,-3685,-5);
}
if ($popupid == 4176) { #ecommons
quest::movepc(22,-140,-1520,3);
}
if ($popupid == 534) { #lavastorm
quest::movepc(27,460,460,-86);
}
if ($popupid == 2707) { #tox
quest::movepc(38,-916,-1510,-33);
}
if ($popupid == 2706) { #gfaydark
quest::movepc(54,-441,-2023,4);
}
if ($popupid == 2709) { #dreadlands
quest::movepc(86,9658,3047,1052);
}
if ($popupid == 2284) { #iceclad
quest::movepc(110,385,5321,-17);
}
if ($popupid == 2031) { #coboltscar
quest::movepc(117,-1634,-1065,299);
}
if ($popupid == 3615) { #twilight
quest::movepc(170,-1028,1338,39);
}
if ($popupid == 3794) { #stonebrunt
quest::movepc(100,673,-4531,0);
}
if ($popupid == 6180) { #wallofslaughter
#quest::movepc(300,-943,13,130);
}
if ($popupid == 5733) { #barindu
quest::movepc(283,209,-515,-119);
}
if ($popupid == 8237) { #eastkorlach
#quest::movepc(362,-750,-1002,48);
}
if ($popupid == 8967) { #arcstone
#quest::movepc(369,1630,-279,5);
}
if ($popupid == 999) { #mesa
#quest::movepc(397,-85,-2050,19);
}
if ($popupid == 1000) { #guild banner
#not implemented yet
}
if ($popupid == 416) { #kattacastrum
#quest::movepc(416,-2,-425,-19);
}
if ($popupid == 20543) { #potimea
quest::movepc(219,0,110,8);
}
if ($popupid == 21986) { #brellsrest
#quest::movepc(480,-23,-619,36);
}
}

The # before some of those quest::movepc means that line is commented out so perl wont execute those particular lines. This is why the porter wont send you to those zones.

[joligario]

Here are the only errors that were reported in any of the logs.

---------------------------------------------
[11.30. - 22:08:09] Starting Log: logs/eqemu_error_zone_3992.log
[11.30. - 22:08:09] Path File ./Maps/steamfontmts.path not found.
[11.30. - 22:11:08] Path File ./Maps/steamfontmts.path not found.
[11.30. - 22:13:43] Path File ./Maps/steamfontmts.path not found.
[11.30. - 22:17:58] Path File ./Maps/gfaydark.path not found.
[11.30. - 22:19:25] Path File ./Maps/guildlobby.path not found.
[11.30. - 22:21:10] Path File ./Maps/ecommons.path not found.
[11.30. - 22:24:23] Path File ./Maps/guildhall.path not found.

---------------------------------------------
[11.30. - 22:09:26] Starting Log: logs/eqemu_error_zone_3184.log
[11.30. - 22:09:26] Path File ./Maps/dragonscale.path not found.
[11.30. - 22:11:41] Path File ./Maps/lopingplains.path not found.
[11.30. - 22:14:01] Path File ./Maps/lopingplains.path not found.
[11.30. - 22:17:17] Path File ./Maps/lfaydark.path not found.
[11.30. - 22:19:45] Path File ./Maps/guildhall.path not found.
[11.30. - 22:22:29] Path File ./Maps/freportw.path not found.
[11.30. - 22:24:02] Path File ./Maps/guildlobby.path not found.
[11.30. - 22:26:42] Path File ./Maps/iceclad.path not found.


I have redownloaded and redone the server a few times already, and I have not found these .path files in any folder or subfolder. I don't know if these missing files would cause quest npc's to intermittently answer hails, or seeing incorrect graphics for particular mobs, or having an incorrect image in the guild hall or not.

Thank you MarioMario. I tried it with my 250 flagged account and the guild portal still didn't work. I can only go to pre pop zones. I can set the teleporter to another zone like dragonscale hills, but when I step into the porter nothing happens. Again that is with a 250 flagged account, not gm flagged and xp and level set to 65. I found the gm commands and leveled the character up to 65, without being gm flagged, just to try the porter as a level 65 toon.

Don't worry about the .path files. The .map files are the important ones.

When you say intermittently respond to hails, I assume that you are not standing close enough to the NPCs.

Incorrect graphics for mobs may be the client for the era of zone you are going into. Not all zones are complete.

[SoltanHeatwave]

Inside of the guild hall quest folder, the player.pl is where your problem lies. This is where the answer for the pop up occurs.

sub EVENT_POPUPRESPONSE {
if ($popupid == 666) { #hateplaneb
quest::movepc(186,-393,656,3);
}
if ($popupid == 674) { #airplane
quest::movepc(71,539,1384,-664);
}
if ($popupid == 15891) { #dragonscale
#quest::movepc(442,-1954,3916,19);
}
if ($popupid == 2708) { #northkarana
quest::movepc(13,1209,-3685,-5);
}
if ($popupid == 4176) { #ecommons
quest::movepc(22,-140,-1520,3);
}
if ($popupid == 534) { #lavastorm
quest::movepc(27,460,460,-86);
}
if ($popupid == 2707) { #tox
quest::movepc(38,-916,-1510,-33);
}
if ($popupid == 2706) { #gfaydark
quest::movepc(54,-441,-2023,4);
}
if ($popupid == 2709) { #dreadlands
quest::movepc(86,9658,3047,1052);
}
if ($popupid == 2284) { #iceclad
quest::movepc(110,385,5321,-17);
}
if ($popupid == 2031) { #coboltscar
quest::movepc(117,-1634,-1065,299);
}
if ($popupid == 3615) { #twilight
quest::movepc(170,-1028,1338,39);
}
if ($popupid == 3794) { #stonebrunt
quest::movepc(100,673,-4531,0);
}
if ($popupid == 6180) { #wallofslaughter
#quest::movepc(300,-943,13,130);
}
if ($popupid == 5733) { #barindu
quest::movepc(283,209,-515,-119);
}
if ($popupid == 8237) { #eastkorlach
#quest::movepc(362,-750,-1002,48);
}
if ($popupid == 8967) { #arcstone
#quest::movepc(369,1630,-279,5);
}
if ($popupid == 999) { #mesa
#quest::movepc(397,-85,-2050,19);
}
if ($popupid == 1000) { #guild banner
#not implemented yet
}
if ($popupid == 416) { #kattacastrum
#quest::movepc(416,-2,-425,-19);
}
if ($popupid == 20543) { #potimea
quest::movepc(219,0,110,8);
}
if ($popupid == 21986) { #brellsrest
#quest::movepc(480,-23,-619,36);
}
}

The # before some of those quest::movepc means that line is commented out so perl wont execute those particular lines. This is why the porter wont send you to those zones.

I will remove the comment's from the lines. Thank you for your help.

[SoltanHeatwave]

Don't worry about the .path files. The .map files are the important ones.

When you say intermittently respond to hails, I assume that you are not standing close enough to the NPCs.

Incorrect graphics for mobs may be the client for the era of zone you are going into. Not all zones are complete.

I am standing close enough. I will go to the npc, and hit the H key to hail it, and nothing will happen. I will then rapidly hit the H key a number of times and after 15 to 20 hails will get a response. This happens to the npc standing near the soulbinder in PoK. None of the other NPC's in any of the other zones will respond at all, no matter how close I stand to them.

[SoltanHeatwave]

Don't worry about the .path files. The .map files are the important ones.

When you say intermittently respond to hails, I assume that you are not standing close enough to the NPCs.

Incorrect graphics for mobs may be the client for the era of zone you are going into. Not all zones are complete.

I am using Secrets of Faydwer Client, not updated. I believe that one has all of the updates to the new zones. The old Freeport West doesn't have the correct graphics, which I can understand, since the SoF client has the new graphics, but the new Steamfont zone doesn't have its graphics correct, the old zone does.

[sorvani]

a little slower then.

no. content. after. GoD. is. ready. to. be. used.

end of discussion.

[SoltanHeatwave]

a little slower then.

no. content. after. GoD. is. ready. to. be. used.

end of discussion.

Ok, that is fine with me. If it can't be used, then it can't be used. I still have issues with a missing guild hall door, which came out with PoP, the clicky portal to Jagged Pine Forest, located in the cave in Surefall Glade. I believe that came out before GoD. Also with bad graphics in old Feeport West. All the mobs there look human. Outside of Freeport west things seem to be pretty normal except with a few quest NPC's that don't respond to Hails, like the exterminator in Queynos. Again, thank you for your help.

[demonstar55]

http://www.eqemulator.net/wiki/wikka.php?wakka=UFMissingFilesList

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

[SoltanHeatwave]

http://www.eqemulator.net/wiki/wikka.php?wakka=UFMissingFilesList

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]

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]

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

[rencro]

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

not:

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

The ` and ' have different uses. You could just not use the ` at all and would still work, but anyways..

[SoltanHeatwave]

For people that want both mercs and bots in a new server :
The new peq db daily dumps do not have bots and mercs enabled when you aquire it. Enabling the mercs and merc vendors is a simple two query process, but getting the bots is another matter..To get bots, you will need the old peqdb from svn, and make a few modifications.

Aquire the “old” svn peqdatabase from:
http://projecteqdb.googlecode.com/svn/trunk/peqdatabase

Aquire the daily dump peq database from:
http://peqtgc.com/releases the peqbeta_201#-##-##-##:##.tar.gz
Extract peqbeta_201#-##-##-##:##.tar.gz to the same directory that the old peq svn db is in

On windows command prompt, change directory into the peqdb svn folder..ex cd c:\peqdb or wherever you have the svn at.

Run mysql command prompt.. mysql -uroot -p


create database peq;

use peq;

source peqbeta_2013-xx-xx-xx_xx.sql;

source user_tables_2013-xx-xx-xx_xx.sql;

source source_views.sql;

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

DELETE FROM `rule_values` WHERE `rule_name` LIKE '%bot%';

UPDATE `rule_values` SET `rule_value` = 'true' WHERE `rule_name` = 'Mercs:AllowMercs';

drop table commands;

source player_tables/commands.sql;

source load_bots.sql;

exit



You now have a db with bots and mercs both enabled, as well as commented commands table for the newbies (load_bots will fail on old commands table due to missing description column, easier to use old commands with the decsriptions than to modify the bots command sql...)
Now I get this error

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.44 sec)

mysql> UPDATE `npc_types` SET `class` = 71 WHERE `lastname` LIKE `%Mercenary Liaison%`;
ERROR 1054 (42S22): Unknown column 'Mercenary Liaison%' in 'where clause'
mysql>

I did try it with a space after the ` before %Mercanary Liaison%` and without it. Also without the tildes. I get the same error. The database I downloaded from SVN was version 70.

[rencro]

Hehe, you did it again.... ` '

The "like" portion of the query uses the ' (single quotes), unlike my previous comments about the ` (tildes) not being needed, the ' (single quotes) are needed at that position...

Try copy pasting into mysql command prompt..

[SoltanHeatwave]

I finally got everything in sql without any errors. I still can't get the merc merchants to respond or to buy a merc. I deleted and redid the database a couple of times to make sure that any prior errors didn't affect anything in the database, and to make sure I did it right. I checked my logs and didn't see any errors.

[rencro]

Could you post the results of these queries?


SELECT short_name,ruleset FROM zone WHERE zoneidnumber = 202;

SELECT * FROM rule_values WHERE rule_name like 'Mercs:%';

SELECT name,class FROM npc_types WHERE class = 71 LIMIT 2;

[SoltanHeatwave]

Here it is.

mysql> use peq
Database changed
mysql> SELECT short_name,ruleset FROM zone WHERE zoneidnumber = 202;
+-------------+---------+
| short_name | ruleset |
+-------------+---------+
| poknowledge | 2 |
+-------------+---------+
1 row in set (0.00 sec)

mysql>



mysql> SELECT * FROM rule_values WHERE rule_name like 'Mercs:%';
+------------+------------------------------+------------+----------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
-----------------------------------------------------------------+
| ruleset_id | rule_name | rule_value | notes


|
+------------+------------------------------+------------+----------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
-----------------------------------------------------------------+
| 3 | Mercs:AllowMercs | true |


|
| 2 | Mercs:AllowMercs | true | Turns mercs on for th
e server - will not load merc data if set to false.

|
| 2 | Mercs:SuspendIntervalMS | 10000 | Time interval for sus
pend command in milliseconds.

|
| 2 | Mercs:UpkeepIntervalMS | 180000 | Time interval for mer
c upkeep in milliseconds.

|
| 2 | Mercs:SuspendIntervalS | 10 | Time interval for sus
pend command in seconds.

|
| 2 | Mercs:UpkeepIntervalS | 180 | Time interval for mer
c upkeep in seconds.

|
| 2 | Mercs:ScaleRate | 100 | Allows scaling of mer
c stats vs livelike values.

|
| 2 | Mercs:AggroRadius | 100 | Determines the distan
ce from which a merc will aggro target(also used to determine the distance at wh
ich a healer merc will begin healing a group member)
|
| 2 | Mercs:AggroRadiusPuller | 25 | Determines the distan
ce from which a merc will aggro target, if they have the group role of puller (a
lso used to determine the distance at which a healer merc will begin healing a g
roup member, if they have the group role of puller) |
| 1 | Mercs:AllowMercs | true | Turns mercs on for th
e server - will not load merc data if set to false.

|
| 1 | Mercs:SuspendIntervalMS | 10000 | Time interval for sus
pend command in milliseconds.

|
| 1 | Mercs:UpkeepIntervalMS | 180000 | Time interval for mer
c upkeep in milliseconds.

|
| 1 | Mercs:SuspendIntervalS | 10 | Time interval for sus
pend command in seconds.

|
| 1 | Mercs:UpkeepIntervalS | 180 | Time interval for mer
c upkeep in seconds.

|
| 1 | Mercs:ScaleRate | 100 | Allows scaling of mer
c stats vs livelike values.

|
| 1 | Mercs:AggroRadius | 100 | Determines the distan
ce from which a merc will aggro target(also used to determine the distance at wh
ich a healer merc will begin healing a group member)
|
| 1 | Mercs:AggroRadiusPuller | 25 | Determines the distan
ce from which a merc will aggro target, if they have the group role of puller (a
lso used to determine the distance at which a healer merc will begin healing a g
roup member, if they have the group role of puller) |
| 10 | Mercs:SuspendIntervalMS | 10000 |


|
| 10 | Mercs:UpkeepIntervalMS | 180000 |


|
| 10 | Mercs:SuspendIntervalS | 10 |


|
| 10 | Mercs:UpkeepIntervalS | 180 |


|
| 10 | Mercs:AllowMercs | true |


|
| 10 | Mercs:AggroRadius | 100 | Determines the distan
ce from which a merc will aggro group member's target(also used to determine the
distance at which a healer merc will begin healing a group member)
|
| 10 | Mercs:AggroRadiusPuller | 25 | Determines the distan
ce from which a merc will aggro group member's target,if they have the group rol
e of puller (also used to determine the distance at which a healer merc will beg
in healing a group member,if they have the group role of puller) |
| 10 | Mercs:ScaleRate | 100 |


|
| 1 | Mercs:ResurrectRadius | 50 | Determines the distan
ce from which a healer merc will attempt to resurrect a corpse

|
| 1 | Mercs:ChargeMercPurchaseCost | false | Turns Mercenary purch
ase costs on or off.

|
| 1 | Mercs:ChargeMercUpkeepCost | false | Turns Mercenary upkee
p costs on or off.

|
+------------+------------------------------+------------+----------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
-----------------------------------------------------------------+
28 rows in set (0.00 sec)


mysql> SELECT name,class FROM npc_types WHERE class = 71 LIMIT 2;
+-------------------+-------+
| name | class |
+-------------------+-------+
| Guardian_Vaehan | 71 |
| Guardian_Adiasean | 71 |
+-------------------+-------+
2 rows in set (0.00 sec)

And again thank you very much for your help.

[rencro]

That all looks good, but looking over this thread I noticed you said you are using SOF client, sadly, mercs only work with SoD and later clients...But anyone logging into your server with SoD or later should be ok. If you also followed the instructions for "bots" then you would have bots available to you..

try typing

#bot help

and

#bot help create

[SoltanHeatwave]

Ok, thank you very much. I really appreciate the time you took to help me. I didn't know that SoD or later clients worked with EQEmulator. I was under the impression that you couldn't really use anything later than Underfoot.

[rencro]

Actually Underfoot came after SoD, and is what I use, as I prefer it..RoF, after underfoot, works if you had acquired the last Steam version from Dec 2012...Things may change in the future..

[SoltanHeatwave]

Actually Underfoot came after SoD, and is what I use, as I prefer it..RoF, after underfoot, works if you had acquired the last Steam version from Dec 2012...Things may change in the future..

Thank you very much for the help rencro. Now all I need to do is find out why my quests and quest mobs aren't working.