Go Back   EQEmulator Home > EQEmulator Forums > Development > Development::Bots

Development::Bots Forum for bots.

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 10-12-2015, 06:22 PM
Uleat's Avatar
Uleat
Developer
 
Join Date: Apr 2012
Location: North Carolina
Posts: 2,815
Default Bots DB Versioning

Bots now have a database versioning system!


To access this feature, you MUST have compiled binaries with the cmake 'BOTS' enabled option.


Adding/updating your database schema for bots is simple:

1) Run the eqemu_update.pl script

** It is recommended that you backup your database using one of the backup options before proceeding **

2) Select the "4) [EQEmu DB Bots Schema] Check for Bot REQUIRED database updates... (Must have bots enabled)" option

3) Select the option again if there are PENDING updates


That's all there is to it!


Notes on what will occur:

- For non-bots databases, all required schema will be applied

- For databases with existing schema:

--> The new schema will be created

--> A required conversion will be applied

--> The original tables will be renamed to <table_name>##'_old'


For administrators who run an active 'bots' server, I recommend letting this settle for a day or two so that anything I may
have missed can be addressed.

As currently implemented, bots must be updated by running the script. The methodology of the 'world' process call is not setup
to handle the 'bots' integration.

I have tested this pretty thoroughly and Akkadius tested the changes to the eqemu_update.pl script prior.


Hopefully, this will be a move in the right direction for keeping bots active and not side-lined!


================================================== ================================================== ===


Changes:

- Bot database schema now more closely reflects the Player Profile conversion schema

- Some new fields have been added to a few tables for near-future implementations

- Bot time is now the int-based UNIX_TIMESTAMP standard - matching current character fields

- Default rules have been renamed to address 'naming oddities' in contextual reference

- A few broken processes have been fixed and are working properly


================================================== ================================================== ===


Special note on restoring bots database backups: http://www.eqemulator.org/forums/sho...d.php?p=244321
__________________
Uleat of Bertoxxulous

Compilin' Dirty

Last edited by Uleat; 10-13-2015 at 05:42 PM..
Reply With Quote
 

Thread Tools
Display Modes

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:42 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