New Server Issues

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

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

Originally Posted by 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..

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.