- Joined
- Dec 17, 2011
- Messages
- 470
- Reaction score
- 245
Many servers have problems with forbid tables when a gm bans a player it wont display the gm id this procedure will fix that.
Code:
DROP PROCEDURE `addForbid`//
CREATE DEFINER=`root`@`localhost` 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, gmroleid1);
END IF;
COMMIT;
END
Last edited: