Mysql error Deleting characters

[Nightrider84]

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]

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

[Taleason]

Try this


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 ;

[Nightrider84]

just at the character select screen, it pops up on my world.exe. I'll try that taleason and get back to ya

[Nightrider84]

That did the trick taleason, I've never been very good with code im glad that you figured it out. What was the issue btw?

[Taleason]

[MySQL Error] 1305: FUNCTION peq.GetMobTypeById does not exist


Your DB was missing that particular function.

Happy it fixed it for you.

[Nightrider84]

what does the function actually do so I have a reference for it

[NatedogEZ]

The function is called when deleting members from a guild

[Nightrider84]

Thank you nate