Function: nornix_system.find_mime_type

Information
DTD identifierDeterministicData accessMode
int(11)NOREADS SQL DATA

Code

figure out mime type from browser

CREATE DEFINER=`root`@`localhost` FUNCTION `find_mime_type`(vType VARCHAR(128), vExt VARCHAR(32))
RETURNS int(11)
    READS SQL DATA
    COMMENT 'figure out mime type from browser'
BEGIN
 DECLARE result INTEGER DEFAULT 0;
 SELECT `No` INTO result FROM `mimetype` WHERE `Name` LIKE vType;
 IF result THEN
  RETURN result;
 END IF;
 SELECT `MimeTypeNo` INTO result FROM `mimeextension` WHERE `Extension` LIKE vExt;
 RETURN result;
END