Issues Building a Local Server

[pfev1980]

Hey Yummy, I'm rebuilding right now on our server machine, I had been using my personal computer until I got everything right. I'll post exactly how to get the bots to work once I am done with that. The mercs didn't work so well. I can get them to show up at the vendors, but I can't get the mercs to actually spawn. I get the fabled "Merc failed to spawn" error. This is the reference I used to load them:

http://eqemulator.org/forums/showthr...ight=mercs.sql

I got a few errors when I tried to load the scripts into my database, but that probably has something to do with me trying some other stuff before I tried that. So, when I finish my clean install, I'll try again and see how it goes.

[Yummy]

Pfev,

You may have already moved on.. but if not.

I have mercs and bots working. Testing now and except for bots and zoning, they seem to behaving.

I used the following SQL files in the order listed after compiling from git, Feb 15 2014. One of the puzzling things for me is knowing which needs to be done first for bots.sql and mercs.sql. I simply followed someone else's post and hoped for the best.

Bots:
/utils/sql/svn/bots.sql
/utils/sql/svn/2087_required_bots_hp_and_mana_and_spell_updates.s ql
/utils/sql/svn/2107_required_bot_stances.sql
/utils/sql/svn/2164_require_bots_bottimers.sql

Mercs:
/utils/sql/svn/2383_required_group_ismerc_rule
/utils/sql/svn/2380_optional_merc_rules
/utils/sql/svn/2380_optional_merc_merchant_npctypes_update
/utils/sql/svn/2380_optional_merc_data
/utils/sql/svn/mercs.sql

/utils/sql/git/required/2013_02_18_Merc_Rules_and_Tables
/utils/sql/git/optional/2013_02_18_Merc_Spells
/utils/sql/git/required/2013_02_25_Impr_HT_LT
/utils/sql/git/required/2013_03_1_Merc_Rules_and_Equipment
/utils/sql/git/optional/2013_03_14_Merc_Spells
/utils/sql/git/optional/2013_03_18_Merc_Spells

Feel free to comment or make suggestions. No idea if I did it correctly, but working, mostly.

[Yummy]

Originally Posted by Yummy

Bots:
/utils/sql/svn/bots.sql
/utils/sql/svn/2087_required_bots_hp_and_mana_and_spell_updates.s ql
/utils/sql/svn/2107_required_bot_stances.sql
/utils/sql/svn/2164_require_bots_bottimers.sql

For the sake of not spreading misinformation, the above bots and *.sql is wrong or incomplete. I am still attempting to identify, install, and test.

There have been a number of posts regarding the current peqdb and bots but none that I have stumbled across give the complete details. For example, a couple posts cite folks are using bots.sql not load_bots.sql from the old peqdb svn. However, between the svn and git, what should follow?

I can figure it out by trial and error but I would rather be playing.
Guidance would be appreciated.