New Bot Group Based Raid System

[prickle]

I just noticed this line in the 1030_botzoningsupport.sql file

DROP TABLE IF EXISTS `botactives`;

The 1027_botactives.sql file creates this table, and then the 1030 update removes it. Is this correct? From looking at the bots.sql file, this seems correct too me, because the latest bots.sql file does not create the botactives table, but I thought I'd check to make sure this is correct.


I looked through the bot.cpp file and all of the bits of code that you mentioned are in there.


I was just digging through the diffs on the bots.sql file in SVN over the changes from 1027 to current and I noticed this was added to the bots.sql file but not to the 1027 update sql file:

75 	DELIMITER $$
	76
 	77 	DROP FUNCTION IF EXISTS `GetMobType` $$
  	78 	CREATE FUNCTION `GetMobType` (mobname VARCHAR(64)) RETURNS CHAR(1)
  	79	BEGIN
  	80 	    DECLARE Result CHAR(1);
  	81
 	82 	    SET Result = NULL;
 	83
 	84     IF (select count(*) from character_ where name = mobname) > 0 THEN
 	85 	      SET Result = 'C';
 	86 	    ELSEIF (select count(*) from bots where Name = mobname) > 0 THEN
 	87 	      SET Result = 'B';
 	88 	    END IF;
 	89
 	90 	    RETURN Result;
 	91 	END $$
 	92
 	93 	DELIMITER ;

Not sure if this this will have an effect or not, but since it's not in my Database (i didn't source bots.sql, I thought the incremental update sql files would get me there) and I can't find anything else different, I thought I'd mention it...

gonna source it in right now and see if there's any difference...