Mysql error Deleting characters

Nightrider84 · #1 07-15-2015, 03:23 AM

This is the error I get whenever I delete a character.

[MySQL Error] 1305: FUNCTION peq.GetMobTypeById does not exist
DELETE FROM `guild_members` WHERE `char_id` = '634' AND GetMobTypeById(1070934671) = 'C'

any info for this would be great, It doesn't seem to effect anything that I can see but its an error non the less that I wan't to go away =P

**joligario** · #2 07-15-2015, 06:51 AM

How are you deleting the character? What tool, cmd, etc.?

Taleason · #3 07-15-2015, 08:07 AM

Try this

Code:

DROP FUNCTION IF EXISTS `GetMobTypeById`;
DELIMITER ;;
CREATE DEFINER=`root`@`localhost` FUNCTION `GetMobTypeById`(mobid INTEGER UNSIGNED) RETURNS char(1) CHARSET latin1
BEGIN
    DECLARE Result CHAR(1);

    SET Result = NULL;

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

    RETURN Result;
END;;
DELIMITER ;