New Server Issues

[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

[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]

Originally Posted by rencro

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..