SQL-запрос:

CREATE PROCEDURE `addForbid` ( IN userid1 INTEGER, IN type1 INTEGER, IN forbid_time1 INTEGER, IN reason1 BINARY( 255 ) , IN gmroleid1 INTEGER ) BEGIN DECLARE rowcount INTEGER;

START TRANSACTION;

UPDATE forbid SET ctime = now( ) ,
forbid_time = forbid_time1,
reason = reason1,
gmroleid = gmroleid1 WHERE userid = userid1 AND TYPE = type1;

SET rowcount = ROW_COUNT( ) ;

IF rowcount =0 THEN INSERT INTO forbid
VALUES (
userid1, type1, now( ) , forbid_time1, reason1, gmroleid
);

END IF ;

COMMIT ;

END$$

Ответ MySQL: Документация
#1304 - PROCEDURE addForbid already exists