restoring navicat backup.

[lockjaws]

You can manually add the sql part, make sure to check and change the root and localhost parts to your username and host if you need too.

DROP FUNCTION IF EXISTS `GetMobTypeByName`;
DELIMITER ;;
CREATE DEFINER=`root`@`localhost` FUNCTION `GetMobTypeByName`(mobname VARCHAR(64)) RETURNS char(1) CHARSET latin1
BEGIN
    DECLARE Result CHAR(1);

    SET Result = NULL;

    IF (select id from character_ where name = mobname) > 0 THEN
      SET Result = 'C';
    ELSEIF (select BotID from bots where Name = mobname) > 0 THEN
      SET Result = 'B';
    END IF;

    RETURN Result;
END;;
DELIMITER ;