File indexing completed on 2024-03-24 06:03:43
0001 0002 DROP FUNCTION IF EXISTS `laplace_score`; 0003 0004 DELIMITER $$ 0005 USE `pling`$$ 0006 CREATE 0007 DEFINER = CURRENT_USER FUNCTION `laplace_score`(`upvotes` INT, `downvotes` INT) RETURNS int(11) DETERMINISTIC 0008 BEGIN 0009 DECLARE `score` INT(10); 0010 SET `score` = (round(((`upvotes` + 6) / ((`upvotes` + `downvotes`) + 12)), 2) * 100); 0011 RETURN `score`; 0012 END$$ 0013 0014 DELIMITER ;