Bots SQL

[cubber]

Trying to load bots into a clean DB and getting the following:

If I use the load_bots.sql supplied with PEQ SVN 1038 I get the following error:

 ERROR 1418 (HY000) at line 4 in file: 'player_tables/botadventuring.sql': This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable)

if I use the bots.sql file in the EQEMU SVN util/sql/svn folder I get the following error:

ERROR 1064 (42000) at line 74: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IF NOT EXISTS `GetMobTypeByName` (mobname VARCHAR(64)) RETURNS CHAR(1)
BEGIN
   ' at line 1

Anyone know I can correct the PEQ one so I can source it in and get my new server rolling?

Thanks!