[DanCanDo]

Sorry to hear your having these problems, but I'm not sure why you would with a clean
install. I just did a (test) sourcing with new database and it has no errors. But I'm not
dealing with an "old bot system" with the fresh install.
These are steps I do which, seriously only take me about 10 minutes to complete:
(from the mysql prompt)
mysql> source peq.sql (name of clean beta database)
mysql> source player_tables.sql
mysql> source load_login.sql
mysql> source bot_tables.sql (this is the name of the CUSTOM file I linked above)

I also had to source in the function table:

DELIMITER $$

CREATE FUNCTION `GetMobType` (mob_name VARCHAR(64)) RETURNS CHAR(1)
BEGIN
	DECLARE Result CHAR(1);
	
	SET Result = NULL;
	
	IF ((SELECT COUNT(*) FROM `character_data` WHERE `name` = mob_name) > 0) THEN
		SET Result = 'C';
	ELSEIF ((SELECT COUNT(*) FROM `bot_data` WHERE `name` = mob_name) > 0) THEN
		SET Result = 'B';
	END IF;
	
	RETURN Result;
END$$

CREATE FUNCTION `GetMobTypeById` (mob_id INTEGER UNSIGNED) RETURNS CHAR(1)
BEGIN
	DECLARE Result CHAR(1);
	
	SET Result = NULL;
	
	IF ((select `id` from `character_data` where `id` = mob_id) > 0) THEN
		SET Result = 'C';
	ELSEIF ((select `bot_id` from `bot_data` where `bot_id` = mob_id) > 0) THEN
		SET Result = 'B';
	END IF;
	
	RETURN Result;
END$$

DELIMITER ;

After that, I just run eqemu_update.pl and update everything from #3 to 10#
Everything works fine after boot up. (bots included)