File indexing completed on 2024-05-05 10:25:48
0001 0002 0003 DROP FUNCTION IF EXISTS `laplace_score_with_plings`; 0004 0005 DELIMITER $$ 0006 CREATE FUNCTION `laplace_score_with_plings`(`upvotes` INT, `downvotes` INT, `plings` INT) RETURNS int(3) 0007 DETERMINISTIC 0008 BEGIN 0009 DECLARE `score` INT(4); 0010 SET `score` = round((`upvotes` * 8 + `downvotes` * 3 + 2 * 5 + `plings` * 11) / 0011 (`upvotes` + `downvotes` + 2 + `plings`), 2) * 100; 0012 RETURN `score`; 0013 0014 END$$ 0015 DELIMITER ;