Go Back   EQEmulator Home > EQEmulator Forums > Development > Development::Database/World Building

Development::Database/World Building World Building forum, dedicated to the EQEmu MySQL Database. Post partial/complete databases for spawns, items, etc.

Reply
 
Thread Tools Display Modes
  #1  
Old 09-16-2013, 02:25 PM
rencro
Hill Giant
 
Join Date: Sep 2008
Location: So. California
Posts: 219
Default Peq_daily with Bots and Mercs

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...)
Reply With Quote
  #2  
Old 12-07-2013, 09:03 PM
SoltanHeatwave
Hill Giant
 
Join Date: Nov 2013
Location: Eastern US
Posts: 110
Default

Please delete this post.
Reply With Quote
  #3  
Old 01-22-2014, 03:13 PM
lordnivek1
Sarnak
 
Join Date: Feb 2013
Posts: 65
Default

you can delete this post as well lol
Reply With Quote
  #4  
Old 02-22-2014, 11:14 AM
rabbired1
Fire Beetle
 
Join Date: Feb 2007
Posts: 6
Default

maker..............
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

   

All times are GMT -4. The time now is 12:28 PM.


 

Everquest is a registered trademark of Daybreak Game Company LLC.
EQEmulator is not associated or affiliated in any way with Daybreak Game Company LLC.
Except where otherwise noted, this site is licensed under a Creative Commons License.
       
Powered by vBulletin®, Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3