View Single Post
  #4  
Old 12-07-2013, 09:10 PM
SoltanHeatwave
Hill Giant
 
Join Date: Nov 2013
Location: Eastern US
Posts: 120
Default

Quote:
Originally Posted by rencro View Post
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

Code:
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.
Reply With Quote