rendered paste bodyCREATE PROCEDURE log_msg (Vchannel VARCHAR(30), Vserver VARCHAR(100), Vnickname varchar(40), Vmessage TEXT, Vbot_name VARCHAR(15)) BEGIN SELECT id AS Vnickname_int FROM nicknames WHERE nickname = Vnickname LIMIT 1; IF MYSQL_NUM_ROWS() < 1 THEN INSERT INTO nicknames (nickname) VALUES(Vnickname); SELECT LAST_INSERT_ID() AS Vnickname_int; END IF; INSERT INTO messages (channel, server, nickname, nickname_int, date_typed, message, logged_by) VALUES (Vchannel, Vserver, Vnickname, Vnickname_int, NOW() , Vmessage, Vbot_name); END;