New Server Issues

[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