DECLARE cnt int(10) DEFAULT 0;
SELECT count(*) INTO @cnt FROM news WHERE MsgID = @MsgID;

DECLARE @cnt int(10) DEFAULT 0;
SELECT count(*) INTO @cnt FROM news WHERE MsgID = @MsgID;

set @MsgID := ExtractValue(NEW.xmlData,'//Ident');

SELECT * FROM news WHERE MsgID = @MsgID;
SELECT FOUND_ROWS() INTO @cnt;

insert into replicate_table (xmlData) Values ('<Root><Type>Message</Type><Action>delete</Action><Ident>55363</Ident><Deleted>0</Deleted><Mm_Sender_Id>782</Mm_Sender_Id><Mm_Sender_Name>mobus</Mm_Sender_Name><Mm_Date>2014-08-18T16:08:02</Mm_Date><Mm_Subject>1116</Mm_Subject><Msg_Text>1116</Msg_Text><Mm_Importance>N</Mm_Importance></Root>');

BEGIN
DECLARE randName varchar(20);
DECLARE ShortName varchar(50);
DECLARE ElementPath varchar(100);
DECLARE ElementScript varchar(100);
DECLARE ElementName varchar(250);
DECLARE lastID varchar(10);
DECLARE ParentID varchar(10);
DECLARE is_virtual varchar(2);
DECLARE ItemID varchar(10);
DECLARE ItemName varchar(30);
DECLARE TypeItem varchar(50);
DECLARE SQLAction varchar(50);
SET @lastID := 0;
SET @TypeItem := ExtractValue(NEW.xmlData,'//Type');
SET @randName := ROUND(RAND()*(10000-1000)+1000,0);
set @ShortName :=  CONCAT(DATE_FORMAT(NOW(),'%Y%m%d%H%i%s'),'-',@randName);
CASE @TypeItem
	WHEN 'message'
	THEN
		BEGIN
			DECLARE MsgID varchar(20);
			DECLARE isDeleted int(2);
			set @MsgID := ExtractValue(NEW.xmlData,'//Ident');
			set @SQLAction := ExtractValue(NEW.xmlData,'//Action');
			
			set @ElementPath := CONCAT('/news/',@ShortName,'.html');
			set @ItemID := '12';
			set @is_virtual := '2';
			set @ParentID := '38';
			set @ItemName := 'wr_item_news';
			set @ElementScript := 'news/item';
			SET @ElementName := ExtractValue(NEW.xmlData,'//Mm_Subject');
			SET @isDeleted := ExtractValue(NEW.xmlData,'//Deleted');
			
		
			SELECT Count(MsgID) INTO @MsgCount FROM wr_item_news WHERE MsgID = @MsgID;
			IF(@MsgCount = 0)
			THEN
				INSERT INTO wr_main (
					ParentID,
					ElementName, 
					ItemID, 
					ItemName,
					isNode, 
					ElementOrder, 
					ElementPath, 
					ElementScript, 
					ShortName, 
					is_virtual, 
					HostName) 
		
				VALUES( 
					@ParentID, 
					@ElementName, 
					@ItemID,  
					@ItemName, 
					'2', 
					'0',  
					@ElementPath, 
					@ElementScript, 
					@ShortName, 
					@is_virtual,
					'*'
				);

				SET @lastID := LAST_INSERT_ID();
				INSERT INTO wr_item_news (
					ElementID,
					ParentID,
					ElementName,
					created,
					modified,
					dat,
					Sender,
					descr,
					Importance,
					`hash`,
					MsgID
				) 
				VALUES( 
					@lastID,
					@ParentID,
					@ElementName,
					UNIX_TIMESTAMP(),
					UNIX_TIMESTAMP(),
					UNIX_TIMESTAMP(STR_TO_DATE(ExtractValue(NEW.xmlData,'//Mm_Date'),'%Y-%m-%dT%H:%i:%s')),
					ExtractValue(NEW.xmlData,'//Mm_Sender_Name'),
					ExtractValue(NEW.xmlData,'//Msg_Text'),
					IF (ExtractValue(NEW.xmlData,'//Mm_Importance') = 'Y' ,'1', '0' ),
					MD5(@MsgID),
					@MsgID
					) ON DUPLICATE KEY UPDATE modified=UNIX_TIMESTAMP();
			ELSE
				IF(@isDeleted = 1 OR @SQLAction = 'delete')
				THEN
					DELETE FROM wr_main WHERE ElementID = ( SELECT ElementID FROM wr_item_news WHERE MsgID = @MsgID);
					DELETE FROM wr_item_newsrecipients WHERE MsgID = @MsgID;
					DELETE FROM wr_item_news WHERE MsgID = @MsgID;
				END IF; 
			END IF;
				
		END;
	WHEN 'Message_Ref'
	THEN
		BEGIN
		
		INSERT INTO wr_item_newsrecipients (
				ParentID,
				Recipient,
				IsRead,
				MsgID
			) 
			SELECT 
				@lastID,
				ExtractValue(NEW.xmlData,'//Mf_Receiver_Name'),
				IF (ExtractValue(NEW.xmlData,'//Mf_Message_Read') = 'Y' ,'1', '0' ),
				ExtractValue(NEW.xmlData,'//Mf_Message_Id')
				;
				
		END;
	END CASE;
END