sellbuff_procedures

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Procedure structure for `sellbuff_restoreSellerData`
-- ----------------------------
DROP PROCEDURE IF EXISTS `sellbuff_restoreSellerData`;
DELIMITER ;;
CREATE DEFINER=`root`@`localhost` PROCEDURE `sellbuff_restoreSellerData`(IN `p_obj_id` int)
BEGIN
/* Procedure save old seller title, title_color, name_color */

	/* Get current title, title/name color */
	DECLARE lastTitle VARCHAR(16);
	DECLARE lastTitleColor VARCHAR(8);
	DECLARE lastNameColor VARCHAR(8);
  SELECT sellbuff_seller_data.lastTitle, sellbuff_seller_data.lastTitleColor, sellbuff_seller_data.lastNameColor INTO lastTitle, lastTitleColor, lastNameColor FROM sellbuff_seller_data WHERE char_obj_id = p_obj_id LIMIT 1;

	/* Remove old data from sellbuff_seller_data */
	DELETE FROM sellbuff_seller_data WHERE char_obj_id = p_obj_id;

	SELECT lastTitle, lastTitleColor, lastNameColor;
	/* Update character data, after load this procedure need broadcast seller data in Java code */
	/*UPDATE characters SET title=lastTitle, title_color=lastTitleColor, name_color=lastNameColor WHERE obj_Id=p_obj_id;*/

END
;;
DELIMITER ;

-- ----------------------------
-- Procedure structure for `sellbuff_saveSellerData`
-- ----------------------------
DROP PROCEDURE IF EXISTS `sellbuff_saveSellerData`;
DELIMITER ;;
CREATE DEFINER=`root`@`localhost` PROCEDURE `sellbuff_saveSellerData`(IN `p_obj_id` int,IN `p_title` VARCHAR(16),IN `p_title_color` VARCHAR(8),IN `p_name_color` VARCHAR(8))
BEGIN
/* Procedure save old seller title, title_color, name_color */

	/* Remove old data from sellbuff_seller_data */
	DELETE FROM sellbuff_seller_data WHERE char_obj_id = p_obj_id;

	/* Store new data in sellbuff_seller_data */
	INSERT INTO sellbuff_seller_data (char_obj_id, lastTitle, lastTitleColor, lastNameColor)
	VALUES (p_obj_id, p_title, p_title_color, p_name_color);

END
;;
DELIMITER ;