Bots Auto-Updater Option

[Uleat]

I 'think' the script is done except for tweaking against server run-time expectations.

Now, for the hard part..TESTING!


The 'bots_updater' branch has the script, as well as all other changes, committed to it..so, take a look if you're interested, give some feedback if you care!

https://github.com/EQEmu/Server/tree/bots_updater


EDIT: Updated script pushed to remote branch fixes special case column updates.

[rencro]

Sorry its taken me so long to look at this, there is an issue I ran into on a virgin DB.

I get an error "Your server binaries (world/zone) are not compiled for bots..."

The updater quits at this point. I tracked the error to line 845 of eqemu_update.pl

sub bots_db_management{
	#::: Main Binary Database version
	$bin_db_ver = trim($db_version[2);
	
	#::: If we have stale data from main db run
	if($db_run_stage > 0 && $bots_db_management == 0){
		clear_database_runs();
	}

	if($bin_db_ver == 0){
		print "Your server binaries (world/zone) are not compiled for bots...\n";
		return;
	}

I changed the 2 to a 1 and all works well as far as updating.

EDIT:: I deleted the manifest and 2015_9_30.bots sql from my db_update folder and the script now pulled the latest sql and now there are no views or functions being created. Was working fine with the old 2015_09_30_bos.sql from before the latest push.

Edit2: Started over, and all working this run, so only issue is the perl edit to point to the second element instead of non-existing third in db_version on clean db.

[Uleat]

$db_version[2

(missing bracket?)


There's an additional parameter being passed that will tell the script what the current 'bots' version is set to.

It's currently disabled so that the script will not apply what's in the 'master' branch due to its not being ready.

https://github.com/EQEmu/Server/blob...d/net.cpp#L124
https://github.com/EQEmu/Server/blob.../version.h#L35


There are a lot of changes that have to occur in the master branch before the 'conversion' will work properly.

I've got a backup db that I'm testing the conversion process on, as well as binaries from both master and bots_updater.

(Not sure why views and functions wouldn't be created, even with the current scripts, unless the script is erroring out.)


The 'bots_updater' branch has the most up-to-date code/scripts..but, it's still in testing phase.

[Uleat]

Speaking of testing...

I noticed with the current system that bot pets are not saving inventories or buffs.

In addition, bot groups are being saved..but, not bot group members...


Are these problems that other bots users are experiencing?


FINAL EDIT: 3 issues resolved

[rencro]

$db_version[2

Thats my lame attempt at making the 2 red, the bracket is there in the code.

[Uleat]

That's forgivable... You should have seen some of my lame attempts at making this script :P

[Akkadius]

Originally Posted by rencro

$db_version[2

Thats my lame attempt at making the 2 red, the bracket is there in the code.

The 2 is a good spot, I very hastily made the changes because I had to leave the house for the night but I wanted to get things ready for Uleat. It is supposed to be 1 on the split.

https://github.com/EQEmu/Server/comm...b3450d01265f2a

When Uleat is actually ready to make use of that portion of the update script, we'll push another binary and script update.

[Akkadius]

Cancel that, it was right originally. :P