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.