Can anyone figure out why my trigger doesn't work??

[xKnightmarex]

CREATE DEFINER=`root`@`127.0.0.1`
TRIGGER `guildhall_invite`
AFTER UPDATE ON `players`
FOR EACH ROW
BEGIN
if( rank_id = 1 OR rank_id = 2 OR rank_id = 3 )
{ INSERT INTO `house_lists` (`house_id`, `listid`, `list`) VALUES ('113', NEW.`id`, 'name'); }
ELSE{ INSERT INTO `house_lists` (`house_id`, `listid`, `list`) VALUES ('114', NEW.`id`, 'name'); }
END



any ideas why this doesn't work?

I'm trying to make it so that when you join a guild your automatically allowed to enter the guildhall