Pangya Life

Um outro estilo de vida!

Arrumando Caldron e Decoration – Querry

5 comentários

Bem ta ai são bem difíceis de achar mas ta ai pra galera…

Querry Caldron

USE [Pangya_S4_TH]
 GO
 /****** Object: StoredProcedure [dbo].[USP_ITEM_RECYCLE] Script Date: 03/05/2011 21:11:06 ******/
 SET ANSI_NULLS ON
 GO
 SET QUOTED_IDENTIFIER ON
 GO
ALTER PROC [dbo].[USP_ITEM_RECYCLE] (
 @UID AS INT ,
 @RECYCLEDATA VARCHAR(8000)
 ) -- WITH ENCRYPTION
 AS
 /*********************
 ADD, 20080219 AMY HAEJIN HYUN
 CARD V1.1 카드 붙은 의상: 마법상자
2009-05-26, GOMI97
 - @@IDENTITY 패치
295 SET @ITEM_ID_0 = @@IDENTITY
 307 SET @ITEM_ID_0 = @@IDENTITY
 315 SET @ITEM_ID_0 = @@IDENTITY
**********************/
 BEGIN
 SET NOCOUNT ON
-- 0. 카디에의 마법상자
 DECLARE @ITEMS INT
 DECLARE @ITEM_ID_1 bigint
 DECLARE @TYPEID_1 int
 DECLARE @C0_1 smallint
 DECLARE @ISPARTS_1 smallint
 DECLARE @ITEM_ID_2 bigint
 DECLARE @TYPEID_2 int
 DECLARE @C0_2 smallint
 DECLARE @ISPARTS_2 smallint
 DECLARE @ITEM_ID_3 bigint
 DECLARE @TYPEID_3 int
 DECLARE @C0_3 smallint
 DECLARE @ISPARTS_3 smallint
 DECLARE @ITEM_ID_4 bigint
 DECLARE @TYPEID_4 int
 DECLARE @C0_4 smallint
 DECLARE @ISPARTS_4 smallint
 DECLARE @ITEM_ID_0 bigint
 DECLARE @TYPEID_0 int
 DECLARE @C0_0 smallint
 DECLARE @ISPARTS_0 smallint
SET @C0_1 = 0
 SET @ISPARTS_1 = 0
 SET @ITEM_ID_1 = 0
 SET @TYPEID_1 = 0
 SET @C0_2 = 0
 SET @ISPARTS_2 = 0
 SET @ITEM_ID_2 = 0
 SET @TYPEID_2 = 0
 SET @C0_2 = 0
 SET @ISPARTS_3 = 0
 SET @ITEM_ID_3 = 0
 SET @TYPEID_3 = 0
 SET @C0_4 = 0
 SET @ISPARTS_4 = 0
 SET @ITEM_ID_4 = 0
 SET @TYPEID_4 = 0
DECLARE @hdlXmlDoc INT
 --DECLARE @Entry2 VARCHAR(1000)
exec sp_xml_preparedocument @hdlXmlDoc OUTPUT, @RECYCLEDATA
 SELECT @C0_1 = C0, @ISPARTS_1 = IsParts, @ITEM_ID_1 = Item_ID, @TYPEID_1 = TypeID FROM Openxml(@hdlXmlDoc,'/RECYCLE/MINUS')
 WITH (SEQ int '@SEQ',
 TypeID BIGINT '@TYPEID',
 Item_ID INT '@ITEM_ID',
 C0 int '@C0',
 IsParts int '@ISPARTS')
 WHERE SEQ = 1
 SELECT @C0_2 = C0, @ISPARTS_2 = IsParts, @ITEM_ID_2 = Item_ID, @TYPEID_2 = TypeID FROM Openxml(@hdlXmlDoc,'/RECYCLE/MINUS')
 WITH (SEQ int '@SEQ',
 TypeID BIGINT '@TYPEID',
 Item_ID INT '@ITEM_ID',
 C0 int '@C0',
 IsParts int '@ISPARTS')
 WHERE SEQ = 2
 SELECT @C0_3 = ISNULL(C0,0), @ISPARTS_3 = ISNULL(IsParts,0), @ITEM_ID_3 = ISNULL(Item_ID,0), @TYPEID_3 = ISNULL(TypeID,0) FROM Openxml(@hdlXmlDoc,'/RECYCLE/MINUS')
 WITH (SEQ int '@SEQ',
 TypeID BIGINT '@TYPEID',
 Item_ID INT '@ITEM_ID',
 C0 int '@C0',
 IsParts int '@ISPARTS')
 WHERE SEQ = 3
 SELECT @C0_4 = C0, @ISPARTS_4 = ISNULL(IsParts,0), @ITEM_ID_4 = ISNULL(Item_ID,0), @TYPEID_4 = ISNULL(TypeID,0) FROM Openxml(@hdlXmlDoc,'/RECYCLE/MINUS')
 WITH (SEQ int '@SEQ',
 TypeID BIGINT '@TYPEID',
 Item_ID INT '@ITEM_ID',
 C0 int '@C0',
 IsParts int '@ISPARTS')
 WHERE SEQ = 4
 SELECT @C0_0 = C0, @ISPARTS_0 = IsParts, @ITEM_ID_0 = Item_ID, @TYPEID_0 = TypeID FROM Openxml(@hdlXmlDoc,'/RECYCLE/PLUS')
 WITH (SEQ int '@SEQ',
 TypeID BIGINT '@TYPEID',
 Item_ID INT '@ITEM_ID',
 C0 int '@C0',
 IsParts int '@ISPARTS')
 WHERE SEQ = 1
 EXEC sp_xml_removedocument @hdlXmlDoc
DECLARE @C0_1_ORI SMALLINT
 , @C0_2_ORI SMALLINT
 , @C0_3_ORI SMALLINT
 , @C0_4_ORI SMALLINT
-- 0 : SUCCESS , 1 : FAILURE
 DECLARE @RET_1 TINYINT
 , @RET_2 TINYINT
 , @RET_3 TINYINT
 , @RET_4 TINYINT
DECLARE @CADDIECLEVEL TINYINT
 , @CADDIEEXP INT
DECLARE @RET_0 AS TINYINT
-- INITIALIZE - 초기화
 SET @RET_1 = 1
 SET @RET_2 = 1
 SET @RET_3 = 1
 SET @RET_4 = 1
 SET @RET_0 = 1
---- 1. CHECK THE ITEM CAN BE CONSUMED. ------------------------------------------------------------------------------
 IF (@ITEM_ID_1 > 0) BEGIN
 IF ( @ISPARTS_1 = 3 ) BEGIN
 SELECT TOP 1 @C0_1_ORI = 1
 , @CADDIECLEVEL = CLEVEL
 , @CADDIEEXP = [EXP]
 FROM DBO.PANGYA_CADDIE_INFO WITH(READUNCOMMITTED)
 WHERE UID = @UID
 AND ITEM_ID = @ITEM_ID_1
 AND TYPEID = @TYPEID_1
 AND VALID = 1
-- 아이템이 삭제할 개수만큼 있어야
 IF ( @@ROWCOUNT = 1 ) BEGIN
 SET @RET_1 = 0 -- 성공
 END ELSE BEGIN
 SET @RET_1 = 2 -- 실패
 END
END ELSE BEGIN
 SELECT TOP 1 @C0_1_ORI = C0
 FROM DBO.PANGYA_ITEM_WAREHOUSE WITH(READUNCOMMITTED)
 WHERE UID = @UID
 AND ITEM_ID = @ITEM_ID_1
 AND TYPEID = @TYPEID_1 AND VALID = 1
IF ( @@ROWCOUNT = 1 ) -- 아이템이 삭제할 개수만큼 있어야
 AND ( ( @C0_1_ORI >= @C0_1 AND @ISPARTS_1 = 0 ) OR ( @ISPARTS_1 = 1) ) BEGIN
 SET @RET_1 = 0 -- 성공
 END ELSE BEGIN
 SET @RET_1 = 2 -- 실패
 END
 END
 END
---- 2. CHECK THE ITEM CAN BE CONSUMED. ------------------------------------------------------------------------------
 IF (@ITEM_ID_2 > 0) BEGIN
 SELECT TOP 1 @C0_2_ORI = C0
 FROM DBO.PANGYA_ITEM_WAREHOUSE WITH(READUNCOMMITTED)
 WHERE UID = @UID
 AND ITEM_ID = @ITEM_ID_2
 AND TYPEID = @TYPEID_2
 AND VALID = 1
IF ( @@ROWCOUNT = 1 ) -- 아이템이 삭제할 개수만큼 있어야
 AND ( ( @C0_2_ORI >= @C0_2 AND @ISPARTS_2 = 0 ) OR ( @ISPARTS_2 = 1) ) BEGIN
 SET @RET_2 = 0 -- 성공
 END ELSE BEGIN
 SET @RET_2 = 2 -- 실패
 END
 END
---- 3. CHECK THE ITEM CAN BE CONSUMED. ------------------------------------------------------------------------------
 IF (@ITEM_ID_3 > 0) BEGIN
 SELECT TOP 1 @C0_3_ORI = C0
 FROM DBO.PANGYA_ITEM_WAREHOUSE WITH(READUNCOMMITTED)
 WHERE UID = @UID
 AND ITEM_ID = @ITEM_ID_3
 AND TYPEID = @TYPEID_3
 AND VALID = 1
IF ( @@ROWCOUNT = 1 ) -- 아이템이 삭제할 개수만큼 있어야
 AND ( ( @C0_3_ORI >= @C0_3 AND @ISPARTS_3 = 0 ) OR ( @ISPARTS_3 = 1) ) BEGIN
 SET @RET_3 = 0 -- 성공
 END ELSE BEGIN
 SET @RET_3 = 2 -- 실패
 END
 END
---- 4. CHECK THE ITEM CAN BE CONSUMED. ------------------------------------------------------------------------------
 IF (@ITEM_ID_4 > 0) BEGIN
 SELECT TOP 1 @C0_4_ORI = C0
 FROM DBO.PANGYA_ITEM_WAREHOUSE WITH(READUNCOMMITTED)
 WHERE UID = @UID
 AND ITEM_ID = @ITEM_ID_4
 AND TYPEID = @TYPEID_4
 AND VALID = 1
IF ( @@ROWCOUNT = 1 ) -- 아이템이 삭제할 개수만큼 있어야
 AND ( ( @C0_4_ORI >= @C0_4 AND @ISPARTS_4 = 0 ) OR ( @ISPARTS_4 = 1) ) BEGIN
 SET @RET_4 = 0 -- 성공
 END ELSE BEGIN
 SET @RET_4 = 2 -- 실패
 END
 END
IF ( ( @RET_1 IN (0, 1) )
 AND ( @RET_2 IN (0, 1) )
 AND ( @RET_3 IN (0, 1) )
 AND ( @RET_4 IN (0, 1) ) ) BEGIN
 -- 0.
 SET @RET_0 = 0
---- 1. CONSUME THE ITEM. ------------------------------------------------------------------------------
 IF ( @RET_1 = 0 ) BEGIN
 IF ( @ISPARTS_1 = 1 ) BEGIN
 UPDATE DBO.PANGYA_ITEM_WAREHOUSE
 SET VALID = 0
 WHERE UID = @UID
 AND TYPEID = @TYPEID_1
 AND VALID = 1
 AND ITEM_ID = @ITEM_ID_1
SET @C0_1 = 0
END ELSE IF ( @ISPARTS_1 = 3 ) BEGIN
 UPDATE DBO.PANGYA_CADDIE_INFO
 SET VALID = 0
 WHERE UID = @UID
 AND TYPEID = @TYPEID_1
 AND VALID = 1
 AND ITEM_ID = @ITEM_ID_1
SET @C0_1 = 0
END ELSE BEGIN
 UPDATE DBO.PANGYA_ITEM_WAREHOUSE
 SET C0 = C0 - @C0_1
 , VALID = CASE WHEN C0 <= @C0_1 THEN 0 ELSE 1 END
 WHERE UID = @UID
 AND TYPEID = @TYPEID_1
 AND VALID = 1
 AND ITEM_ID = @ITEM_ID_1
 AND C0 >= @C0_1
IF (@C0_1_ORI >= @C0_1) BEGIN --CODE BY 김종열 2007 08 09
 SET @C0_1 = @C0_1_ORI - @C0_1
 END ELSE BEGIN
 SET @C0_1 = 0
 END
END
 END
---- 2. CONSUME THE ITEM. ------------------------------------------------------------------------------
 IF ( @RET_2 = 0 ) BEGIN
 IF ( @ISPARTS_2 = 1 ) BEGIN
 UPDATE DBO.PANGYA_ITEM_WAREHOUSE
 SET VALID = 0
 WHERE UID = @UID
 AND TYPEID = @TYPEID_2
 AND VALID = 1
 AND ITEM_ID = @ITEM_ID_2
SET @C0_2 = 0
END ELSE BEGIN
 UPDATE DBO.PANGYA_ITEM_WAREHOUSE
 SET C0 = C0 - @C0_2
 , VALID = CASE WHEN C0 <= @C0_2 THEN 0 ELSE 1 END
 WHERE UID = @UID
 AND TYPEID = @TYPEID_2
 AND VALID = 1
 AND ITEM_ID = @ITEM_ID_2
 AND C0 >= @C0_2
IF (@C0_2_ORI >= @C0_2) BEGIN --CODE BY 김종열 2007 08 09
 SET @C0_2 = @C0_2_ORI - @C0_2
 END ELSE BEGIN
 SET @C0_2 = 0
 END
END
 END
---- 3. CONSUME THE ITEM. ------------------------------------------------------------------------------
 IF ( @RET_3 = 0 ) BEGIN
 IF ( @ISPARTS_3 = 1 ) BEGIN
 UPDATE DBO.PANGYA_ITEM_WAREHOUSE
 SET VALID = 0
 WHERE UID = @UID
 AND TYPEID = @TYPEID_3
 AND VALID = 1
 AND ITEM_ID = @ITEM_ID_3
SET @C0_3 = 0
END ELSE BEGIN
 UPDATE DBO.PANGYA_ITEM_WAREHOUSE
 SET C0 = C0 - @C0_3
 , VALID = CASE WHEN C0 <= @C0_3 THEN 0 ELSE 1 END
 WHERE UID = @UID
 AND TYPEID = @TYPEID_3
 AND VALID = 1
 AND ITEM_ID = @ITEM_ID_3
 AND C0 >= @C0_3
IF (@C0_3_ORI >= @C0_3) BEGIN --CODE BY 김종열 2007 08 09
 SET @C0_3 = @C0_3_ORI - @C0_3
 END ELSE BEGIN
 SET @C0_3 = 0
 END
 END
 END
---- 4. CONSUME THE ITEM. ------------------------------------------------------------------------------
 IF ( @RET_4 = 0 ) BEGIN
 IF ( @ISPARTS_4 = 1 ) BEGIN
 UPDATE DBO.PANGYA_ITEM_WAREHOUSE
 SET VALID = 0
 WHERE UID = @UID
 AND TYPEID = @TYPEID_4
 AND VALID = 1
 AND ITEM_ID = @ITEM_ID_4
SET @C0_4 = 0
 END ELSE BEGIN
 UPDATE DBO.PANGYA_ITEM_WAREHOUSE
 SET C0 = C0 - @C0_4
 , VALID = CASE WHEN C0 <= @C0_4 THEN 0 ELSE 1 END
 WHERE UID = @UID
 AND TYPEID = @TYPEID_4
 AND VALID = 1
 AND ITEM_ID = @ITEM_ID_4
 AND C0 >= @C0_4
IF (@C0_4_ORI >= @C0_4) BEGIN --CODE BY 김종열 2007 08 09
 SET @C0_4 = @C0_4_ORI - @C0_4
 END ELSE BEGIN
 SET @C0_4 = 0
 END
 END
 END
END ELSE BEGIN
 SET @RET_0 = 1 -- 0. 소모 실패
 END
IF (@RET_0 = 0 ) BEGIN -- 회수 성공시
 IF ( @ISPARTS_0 IN (1, 2) ) BEGIN
-- 패키지 아이템의 경우 구성물 들을 모두 지급한다.
 INSERT INTO DBO.PANGYA_ITEM_WAREHOUSE (UID,TYPEID,VALID,REGDATE,GIFT_FLAG,FLAG,APPLYTIME,ENDDATE,C0,C1,C2,C3,C4,PURCHASE,ITEMTYPE)
 VALUES(@UID,@TYPEID_0,1,GETDATE(),0,1,GETDATE(),GETDATE(),0,0,0,0,0,0,0)
SET @ITEM_ID_0 = SCOPE_IDENTITY()
 SET @C0_0 = 1
END ELSE IF ( @ISPARTS_0 = 3 ) BEGIN
-- 패키지 아이템의 경우 구성물 들을 모두 지급한다.
 SET @CADDIECLEVEL = ISNULL(@CADDIECLEVEL , 0)
 SET @CADDIEEXP = ISNULL(@CADDIEEXP , 0)
INSERT INTO DBO.PANGYA_CADDIE_INFO(UID,TYPEID,PARTS_TYPEID,GIFT_FLAG,PERIOD,ENDDATE,RENTFLAG,PURCHASE, CLEVEL ,[EXP] )
 VALUES(@UID,@TYPEID_0,0,0,0, DATEADD(DAY,0,GETDATE()),0,0, @CADDIECLEVEL, @CADDIEEXP)
SET @ITEM_ID_0 = SCOPE_IDENTITY()
 SET @C0_0 = 1
END ELSE BEGIN
 IF (@ITEM_ID_0 = 0 ) BEGIN
 INSERT INTO DBO.PANGYA_ITEM_WAREHOUSE(UID,TYPEID,VALID,REGDATE,GIFT_FLAG,FLAG,APPLYTIME,ENDDATE,C0,C1,C2,C3,C4,PURCHASE,ITEMTYPE)
 VALUES(@UID,@TYPEID_0,1,GETDATE(),0,1,GETDATE(),GETDATE(),@C0_0,0,0,0,0,0,0)
SET @ITEM_ID_0 = SCOPE_IDENTITY()
 END ELSE BEGIN
 UPDATE DBO.PANGYA_ITEM_WAREHOUSE
 SET C0 = C0 + @C0_0
 WHERE UID = @UID
 AND TYPEID = @TYPEID_0
 AND VALID = 1
 AND ITEM_ID = @ITEM_ID_0
SELECT TOP 1 @C0_0 = C0
 FROM DBO.PANGYA_ITEM_WAREHOUSE
 WHERE UID = @UID
 AND TYPEID = @TYPEID_0
 AND VALID = 1
 AND ITEM_ID = @ITEM_ID_0
 END
 END
/***********카드에 쓰려고 **********/
--DECLARE @JOIN_ITEMID_NEW BIGINT
 DECLARE @CARD_MAGICBOX TABLE (
 IDX TINYINT IDENTITY(1,1)
 , UID INT
 , JOIN_ITEMID BIGINT
 , JOIN_TYPEID INT
 , CARD_TYPEID INT
 , CARD_ITEMID BIGINT
 , CARD_TYPE TINYINT
 , SOKET_NUM TINYINT
 , IN_DATE DATETIME )
DECLARE @JOIN_IDX INT
SELECT TOP 1 @JOIN_IDX = JOIN_IDX
 FROM DBO.TD_CARD_JOIN2
 WHERE UID = @UID AND JOIN_TYPEID = @TYPEID_1 AND JOIN_ITEMID = @ITEM_ID_1 AND END_DT IS NULL AND USE_YN = 'Y'
IF (@JOIN_IDX IS NOT NULL) BEGIN
 UPDATE DBO.TD_CARD_JOIN2
 SET UID = @UID
 , JOIN_TYPEID = @TYPEID_0
 , JOIN_ITEMID = @ITEM_ID_0
 , USE_DT = GETDATE()
 WHERE UID = @UID
 AND JOIN_TYPEID = @TYPEID_1
 AND JOIN_ITEMID = @ITEM_ID_1
 AND USE_DT < GETDATE()
 AND END_DT IS NULL
 AND USE_YN = 'Y'
 END
 /*************************************/
SET @RET_0 = 0
END
ELSE BEGIN
 SET @ITEM_ID_1 = 0
 SET @TYPEID_1 = 0
 SET @C0_1 = 0
SET @ITEM_ID_2 = 0
 SET @TYPEID_2 = 0 SET @C0_2 = 0
SET @ITEM_ID_3 = 0
 SET @TYPEID_3 = 0
 SET @C0_3 = 0
SET @ITEM_ID_4 = 0
 SET @TYPEID_4 = 0
 SET @C0_4 = 0
SET @ITEM_ID_0 = 0
 SET @TYPEID_0 = 0
 SET @C0_0 = 0
SET @RET_0 = 1
 END
--SELECT @RET_0 AS RET ,
 -- @ITEM_ID_1 AS ITEM_ID_1 , @TYPEID_1 AS TYPEID_1 , @C0_1 AS C0_1 , @ISPARTS_1 AS ISPARTS_1 ,
 -- @ITEM_ID_2 AS ITEM_ID_2 , @TYPEID_2 AS TYPEID_2 , @C0_2 AS C0_2 , @ISPARTS_2 AS ISPARTS_2 ,
 -- @ITEM_ID_3 AS ITEM_ID_3 , @TYPEID_3 AS TYPEID_3 , @C0_3 AS C0_3 , @ISPARTS_3 AS ISPARTS_3 ,
 -- @ITEM_ID_4 AS ITEM_ID_4 , @TYPEID_4 AS TYPEID_4 , @C0_4 AS C0_4 , @ISPARTS_4 AS ISPARTS_4 ,
 -- @ITEM_ID_0 AS ITEM_ID_0 , @TYPEID_0 AS TYPEID_0 , @C0_0 AS C0_0 , @ISPARTS_0 AS ISPARTS_0
 /*
 IF @RET_1 = 0 BEGIN
 SELECT 1 AS RET_1, @ITEM_ID_1 AS ITEM_ID_1 , @TYPEID_1 AS TYPEID_1 , @C0_1 AS C0_1 , @ISPARTS_1 AS ISPARTS_1
 END
 IF @RET_2 = 0 BEGIN
 SELECT 2 AS RET_2, @ITEM_ID_2 AS ITEM_ID_2 , @TYPEID_2 AS TYPEID_2 , @C0_2 AS C0_2 , @ISPARTS_2 AS ISPARTS_2
 END
 IF @RET_3 = 0 BEGIN
 SELECT 3 AS RET_3, @ITEM_ID_3 AS ITEM_ID_3 , @TYPEID_3 AS TYPEID_3 , @C0_3 AS C0_3 , @ISPARTS_3 AS ISPARTS_3
 END
 IF @RET_4 = 0 BEGIN
 SELECT 4 AS RET_4, @ITEM_ID_4 AS ITEM_ID_4 , @TYPEID_4 AS TYPEID_4 , @C0_4 AS C0_4 , @ISPARTS_4 AS ISPARTS_4
 END
 IF @RET_0 = 0 BEGIN
 SELECT 0 AS RET_0, @ITEM_ID_0 AS ITEM_ID_0 , @TYPEID_0 AS TYPEID_0 , @C0_0 AS C0_0 , @ISPARTS_0 AS ISPARTS_0
 END
 SELECT 1 AS SEQ_1, ISNULL(@ITEM_ID_1,0) AS ITEM_ID_1 , ISNULL(@TYPEID_1,0) AS TYPEID_1 , ISNULL(@C0_1,0) AS C0_1 , ISNULL(@ISPARTS_1,0) AS ISPARTS_1
 SELECT 2 AS SEQ_2, ISNULL(@ITEM_ID_2,0) AS ITEM_ID_2 , ISNULL(@TYPEID_2,0) AS TYPEID_2 , ISNULL(@C0_2,0) AS C0_2 , ISNULL(@ISPARTS_2,0) AS ISPARTS_2
 SELECT 3 AS SEQ_3, ISNULL(@ITEM_ID_3,0) AS ITEM_ID_3 , ISNULL(@TYPEID_3,0) AS TYPEID_3 , ISNULL(@C0_3,0) AS C0_3 , ISNULL(@ISPARTS_3,0) AS ISPARTS_3
 SELECT 4 AS SEQ_4, ISNULL(@ITEM_ID_4,0) AS ITEM_ID_4 , ISNULL(@TYPEID_4,0) AS TYPEID_4 , ISNULL(@C0_4,0) AS C0_4 , ISNULL(@ISPARTS_4,0) AS ISPARTS_4
 SELECT 0 AS SEQ_0, @ITEM_ID_0 AS ITEM_ID_0, @TYPEID_0 AS TYPEID_0 , @C0_0 AS C0_0 , @ISPARTS_0 AS ISPARTS_0
 */
 IF @RET_0 = 0 BEGIN
 SELECT 1
 --SELECT @RET_0, @RET_1, @RET_2, @RET_3, @RET_4
 --SELECT @UID, @ITEM_ID_1 AS ITEM_ID_1 , @TYPEID_1 AS TYPEID_1, @ITEM_ID_2 AS ITEM_ID_2 , @TYPEID_2 AS TYPEID_2, @ITEM_ID_3 AS ITEM_ID_3 , @TYPEID_3 AS TYPEID_3, @ITEM_ID_4 AS ITEM_ID_4 , @TYPEID_4 AS TYPEID_4
 --SELECT @UID, @TYPEID_1 AS TYPEID, @ITEM_ID_1 AS ITEM_ID, @C0_1 AS C0, 0 , 0, 0
 --SELECT @UID, @TYPEID_2 AS TYPEID, @ITEM_ID_2 AS ITEM_ID, @C0_2, 0 , 0
 --SELECT 0, @ITEM_ID_2 AS ITEM_ID, @TYPEID_2 AS TYPEID_2
 --SELECT @UID, ISNULL(@ITEM_ID_3,0) AS ITEM_ID , ISNULL(@TYPEID_3,0) AS TYPEID_3, @C0_3, 0, 0
 --SELECT @UID, ISNULL(@ITEM_ID_4,0) AS ITEM_ID , ISNULL(@TYPEID_4,0) AS TYPEID_4, @C0_4, 0, 0
 --SELECT 1, @ITEM_ID_0 AS ITEM_ID_0, @TYPEID_0 AS TYPEID_0
 --SELECT 0 AS SEQ_0, @ITEM_ID_0 AS ITEM_ID_0, @TYPEID_0 AS TYPEID_0 , @C0_0 AS C0_0 , @ISPARTS_0 AS ISPARTS_0
 --SELECT @UID,@TYPEID_1,@ITEM_ID_1, @C0_1, @ITEM_ID_2 , 0, 0, 0
 --SELECT @UID, @TYPEID_1, @C0_1, @TYPEID_2, @C0_2, @TYPEID_3, @C0_3, @TYPEID_4, @C0_4, @TYPEID_0, @C0_0
 SELECT @RET_0, @ITEM_ID_1, @TYPEID_1, @C0_1,@ITEM_ID_2 ,@TYPEID_2, @C0_2, @ITEM_ID_3, @TYPEID_3, @C0_3, @ITEM_ID_4, @TYPEID_4, @C0_4, @ITEM_ID_0, @TYPEID_0, @C0_0, 0, 0
 --SELECT @RET_0, @ITEM_ID_1, @TYPEID_1, @C0_1,@ITEM_ID_2 ,@TYPEID_2, @C0_2, @ITEM_ID_3, @TYPEID_3, @C0_3, @ITEM_ID_4, @TYPEID_4, @C0_4, @ITEM_ID_0, @TYPEID_0, @C0_0, 0, GETDATE()
 /*
 ERR = 1
 ,SRC1_ITEMID = 0
 ,SRC1_TYPEID = 0
 ,SRC1_CNT = 0
 ,SRC2_ITEMID = 0
 ,SRC2_TYPEID = 0
 ,SRC2_CNT = 0
 ,SRC3_ITEMID = 0
 ,SRC3_TYPEID = 0
 ,SRC3_CNT = 0
 ,SRC4_ITEMID = 0
 ,SRC4_TYPEID = 0
 ,SRC4_CNT = 0
 , M_TYPEID = 0
 , M_ITEMID = 0
 , PERIOD =0
 , ENDDATE = 0*/
 END
 return @RET_0
 -- LEAVE LOG
 INSERT INTO PANGYA_RECYCLE_ITEM_LOG(UID,RET,TYPEID_1,C0_1,TYPEID_2,C0_2,TYPEID_3,C0_3,TYPEID_4,C0_4,TYPEID_0,C0_0,REGDATE)
 VALUES (@UID,@RET_0,@TYPEID_1,@C0_1,@TYPEID_2,@C0_2,@TYPEID_3,@C0_3,@TYPEID_4,@C0_4,@TYPEID_0,@C0_0,GETDATE())
SET NOCOUNT OFF
 END

Querry Decoration My Room

-- ----------------------------------------------- --
 -- SQL Furniture Definitions for the Pangya Server --
 --  Generated by the Pangya! TH Item Encyclopedia  --
 --     <http://pangya.tsukasa.eu/encyclopedia>     --
 --                                                 --
 -- If you redistribute this file, leave this head  --
 -- intact. It's not a hard thing to do, right?     --
 --                                                 --
 -- Generated from IFF file "Furniture.iff"         --
 -- Last update of the IFF: 2011-02-16 23:39:15     --
 -- ----------------------------------------------- --
USE [Pangya_S4_TH]
 GO
-- Furniture.iff contains 40 records.
BEGIN TRAN InsertFurniture
-- Furniture Name: ??
 -- Furniture ID:   1207959553
 IF EXISTS (SELECT [TYPEID] FROM TA_ROOM_ITEM WHERE [TYPEID] = 1207959553)
 DELETE FROM TA_ROOM_ITEM WHERE [TYPEID] = 1207959553
INSERT INTO TA_ROOM_ITEM
 ( [CANTUSEUP], [GROUP], [TYPE], [SERIAL], [NAME], [LEVEL], [IS_UNDERLVL], [ICON], [PRICE], [SALE_PRICE], [PURCHASE_PRICE], [IS_CASH], [IS_SALABLE], [IN_STOCK], [NEW], [HIT], [USE_YN], [COM0], [COM1], [COM2], [COM3], [COM4], [DATA], [IS_OWN], [NUM], [MOVE], [IS_FUNCTION], [ETC], [POS_X], [POS_Y], [POS_Z], [POS_R], TEX_0, TEX_1, TEX_2, ORGINAL_TEX_0, ORGINAL_TEX_1, ORGINAL_TEX_2 )
 VALUES
 ( 0, 0, 0, 1, N'??', 0, 0, N'item0_01', 0, 0, 0, 0, 0, 1, 0, 0, 'Y', 0, 0, 0, 0, 0, N'my_wall_01_02', 0, 0, 1, 0, 2, 0.73000001907349, 6.4000000953674, 15.5, 0, N'', N'', N'', N'', N'', N'' )
-- Furniture Name: Wooden Closet
 -- Furniture ID:   1207959572
 IF EXISTS (SELECT [TYPEID] FROM TA_ROOM_ITEM WHERE [TYPEID] = 1207959572)
 DELETE FROM TA_ROOM_ITEM WHERE [TYPEID] = 1207959572
INSERT INTO TA_ROOM_ITEM
 ( [CANTUSEUP], [GROUP], [TYPE], [SERIAL], [NAME], [LEVEL], [IS_UNDERLVL], [ICON], [PRICE], [SALE_PRICE], [PURCHASE_PRICE], [IS_CASH], [IS_SALABLE], [IN_STOCK], [NEW], [HIT], [USE_YN], [COM0], [COM1], [COM2], [COM3], [COM4], [DATA], [IS_OWN], [NUM], [MOVE], [IS_FUNCTION], [ETC], [POS_X], [POS_Y], [POS_Z], [POS_R], TEX_0, TEX_1, TEX_2, ORGINAL_TEX_0, ORGINAL_TEX_1, ORGINAL_TEX_2 )
 VALUES
 ( 0, 0, 0, 20, N'Wooden Closet', 0, 0, N'wardrobe00', 10000000, 0, 0, 0, 0, 1, 0, 0, 'Y', 0, 0, 0, 0, 0, N'wardrobe_a', 0, 0, 1, 0, 2, -0.66000002622604, 1, 15.159999847412, 0, N'', N'', N'', N'', N'', N'' )
-- Furniture Name: ??
 -- Furniture ID:   1207961600
 IF EXISTS (SELECT [TYPEID] FROM TA_ROOM_ITEM WHERE [TYPEID] = 1207961600)
 DELETE FROM TA_ROOM_ITEM WHERE [TYPEID] = 1207961600
INSERT INTO TA_ROOM_ITEM
 ( [CANTUSEUP], [GROUP], [TYPE], [SERIAL], [NAME], [LEVEL], [IS_UNDERLVL], [ICON], [PRICE], [SALE_PRICE], [PURCHASE_PRICE], [IS_CASH], [IS_SALABLE], [IN_STOCK], [NEW], [HIT], [USE_YN], [COM0], [COM1], [COM2], [COM3], [COM4], [DATA], [IS_OWN], [NUM], [MOVE], [IS_FUNCTION], [ETC], [POS_X], [POS_Y], [POS_Z], [POS_R], TEX_0, TEX_1, TEX_2, ORGINAL_TEX_0, ORGINAL_TEX_1, ORGINAL_TEX_2 )
 VALUES
 ( 0, 0, 0, 2048, N'??', 0, 0, N'item0_00', 0, 0, 0, 0, 0, 1, 0, 0, 'Y', 0, 0, 0, 0, 0, N'my_wall_01_01', 0, 0, 1, 0, 2, -7.8299999237061, 6.0999999046326, 15.5, 0, N'', N'', N'', N'', N'', N'' )
-- Furniture Name: Pink Bookshelf
 -- Furniture ID:   1207961621
 IF EXISTS (SELECT [TYPEID] FROM TA_ROOM_ITEM WHERE [TYPEID] = 1207961621)
 DELETE FROM TA_ROOM_ITEM WHERE [TYPEID] = 1207961621
INSERT INTO TA_ROOM_ITEM
 ( [CANTUSEUP], [GROUP], [TYPE], [SERIAL], [NAME], [LEVEL], [IS_UNDERLVL], [ICON], [PRICE], [SALE_PRICE], [PURCHASE_PRICE], [IS_CASH], [IS_SALABLE], [IN_STOCK], [NEW], [HIT], [USE_YN], [COM0], [COM1], [COM2], [COM3], [COM4], [DATA], [IS_OWN], [NUM], [MOVE], [IS_FUNCTION], [ETC], [POS_X], [POS_Y], [POS_Z], [POS_R], TEX_0, TEX_1, TEX_2, ORGINAL_TEX_0, ORGINAL_TEX_1, ORGINAL_TEX_2 )
 VALUES
 ( 0, 0, 0, 2069, N'Pink Bookshelf', 0, 0, N'furniture_a00', 2300, 0, 0, 0, 0, 1, 1, 0, 'Y', 0, 0, 0, 0, 0, N'furniture_a_01', 0, 0, 1, 0, 2, -10.470000267029, 1, 15.319999694824, 0, N'', N'', N'', N'', N'', N'' )
-- Furniture Name: ???
 -- Furniture ID:   1207963650
 IF EXISTS (SELECT [TYPEID] FROM TA_ROOM_ITEM WHERE [TYPEID] = 1207963650)
 DELETE FROM TA_ROOM_ITEM WHERE [TYPEID] = 1207963650
INSERT INTO TA_ROOM_ITEM
 ( [CANTUSEUP], [GROUP], [TYPE], [SERIAL], [NAME], [LEVEL], [IS_UNDERLVL], [ICON], [PRICE], [SALE_PRICE], [PURCHASE_PRICE], [IS_CASH], [IS_SALABLE], [IN_STOCK], [NEW], [HIT], [USE_YN], [COM0], [COM1], [COM2], [COM3], [COM4], [DATA], [IS_OWN], [NUM], [MOVE], [IS_FUNCTION], [ETC], [POS_X], [POS_Y], [POS_Z], [POS_R], TEX_0, TEX_1, TEX_2, ORGINAL_TEX_0, ORGINAL_TEX_1, ORGINAL_TEX_2 )
 VALUES
 ( 0, 0, 0, 4098, N'???', 0, 0, N'item0_02', 0, 0, 0, 0, 0, 1, 0, 0, 'Y', 0, 0, 0, 0, 0, N'my_wall_01_03', 0, 0, 1, 0, 2, 8.9499998092651, 6.0100002288818, 15.5, 0, N'', N'', N'', N'', N'', N'' )
-- Furniture Name: Pink Shelf
 -- Furniture ID:   1207963670
 IF EXISTS (SELECT [TYPEID] FROM TA_ROOM_ITEM WHERE [TYPEID] = 1207963670)
 DELETE FROM TA_ROOM_ITEM WHERE [TYPEID] = 1207963670
INSERT INTO TA_ROOM_ITEM
 ( [CANTUSEUP], [GROUP], [TYPE], [SERIAL], [NAME], [LEVEL], [IS_UNDERLVL], [ICON], [PRICE], [SALE_PRICE], [PURCHASE_PRICE], [IS_CASH], [IS_SALABLE], [IN_STOCK], [NEW], [HIT], [USE_YN], [COM0], [COM1], [COM2], [COM3], [COM4], [DATA], [IS_OWN], [NUM], [MOVE], [IS_FUNCTION], [ETC], [POS_X], [POS_Y], [POS_Z], [POS_R], TEX_0, TEX_1, TEX_2, ORGINAL_TEX_0, ORGINAL_TEX_1, ORGINAL_TEX_2 )
 VALUES
 ( 0, 0, 0, 4118, N'Pink Shelf', 0, 0, N'furniture_b00', 2200, 0, 0, 0, 0, 1, 1, 0, 'Y', 0, 0, 0, 0, 0, N'furniture_a_03', 0, 0, 1, 0, 2, 8.539999961853, 1, 15.310000419617, 0, N'', N'', N'', N'', N'', N'' )
-- Furniture Name: TV
 -- Furniture ID:   1207965699
 IF EXISTS (SELECT [TYPEID] FROM TA_ROOM_ITEM WHERE [TYPEID] = 1207965699)
 DELETE FROM TA_ROOM_ITEM WHERE [TYPEID] = 1207965699
INSERT INTO TA_ROOM_ITEM
 ( [CANTUSEUP], [GROUP], [TYPE], [SERIAL], [NAME], [LEVEL], [IS_UNDERLVL], [ICON], [PRICE], [SALE_PRICE], [PURCHASE_PRICE], [IS_CASH], [IS_SALABLE], [IN_STOCK], [NEW], [HIT], [USE_YN], [COM0], [COM1], [COM2], [COM3], [COM4], [DATA], [IS_OWN], [NUM], [MOVE], [IS_FUNCTION], [ETC], [POS_X], [POS_Y], [POS_Z], [POS_R], TEX_0, TEX_1, TEX_2, ORGINAL_TEX_0, ORGINAL_TEX_1, ORGINAL_TEX_2 )
 VALUES
 ( 0, 0, 0, 6147, N'TV', 0, 0, N'item0_03', 0, 0, 0, 0, 0, 1, 0, 0, 'Y', 0, 0, 0, 0, 0, N'my_wall_01_04', 0, 0, 1, 0, 2, 22, 3.3800001144409, 0.58999997377396, 270, N'', N'', N'', N'', N'', N'' )
-- Furniture Name: Pink TV
 -- Furniture ID:   1207965719
 IF EXISTS (SELECT [TYPEID] FROM TA_ROOM_ITEM WHERE [TYPEID] = 1207965719)
 DELETE FROM TA_ROOM_ITEM WHERE [TYPEID] = 1207965719
INSERT INTO TA_ROOM_ITEM
 ( [CANTUSEUP], [GROUP], [TYPE], [SERIAL], [NAME], [LEVEL], [IS_UNDERLVL], [ICON], [PRICE], [SALE_PRICE], [PURCHASE_PRICE], [IS_CASH], [IS_SALABLE], [IN_STOCK], [NEW], [HIT], [USE_YN], [COM0], [COM1], [COM2], [COM3], [COM4], [DATA], [IS_OWN], [NUM], [MOVE], [IS_FUNCTION], [ETC], [POS_X], [POS_Y], [POS_Z], [POS_R], TEX_0, TEX_1, TEX_2, ORGINAL_TEX_0, ORGINAL_TEX_1, ORGINAL_TEX_2 )
 VALUES
 ( 0, 0, 0, 6167, N'Pink TV', 0, 0, N'tv00', 3100, 0, 0, 0, 0, 1, 1, 0, 'Y', 0, 0, 0, 0, 0, N'tv_a', 0, 0, 1, 0, 2, 20.360000610352, 1, 4.8099999427795, 270, N'', N'', N'', N'', N'', N'' )
-- Furniture Name: ??
 -- Furniture ID:   1207967748
 IF EXISTS (SELECT [TYPEID] FROM TA_ROOM_ITEM WHERE [TYPEID] = 1207967748)
 DELETE FROM TA_ROOM_ITEM WHERE [TYPEID] = 1207967748
INSERT INTO TA_ROOM_ITEM
 ( [CANTUSEUP], [GROUP], [TYPE], [SERIAL], [NAME], [LEVEL], [IS_UNDERLVL], [ICON], [PRICE], [SALE_PRICE], [PURCHASE_PRICE], [IS_CASH], [IS_SALABLE], [IN_STOCK], [NEW], [HIT], [USE_YN], [COM0], [COM1], [COM2], [COM3], [COM4], [DATA], [IS_OWN], [NUM], [MOVE], [IS_FUNCTION], [ETC], [POS_X], [POS_Y], [POS_Z], [POS_R], TEX_0, TEX_1, TEX_2, ORGINAL_TEX_0, ORGINAL_TEX_1, ORGINAL_TEX_2 )
 VALUES
 ( 0, 0, 0, 8196, N'??', 0, 0, N'item0_04', 0, 0, 0, 0, 0, 1, 0, 0, 'Y', 0, 0, 0, 0, 0, N'my_wall_01_05', 0, 0, 1, 0, 2, -20.5, 3.039999961853, 0.80000001192093, 90, N'', N'', N'', N'', N'', N'' )
-- Furniture Name: Pink Sofa
 -- Furniture ID:   1207967768
 IF EXISTS (SELECT [TYPEID] FROM TA_ROOM_ITEM WHERE [TYPEID] = 1207967768)
 DELETE FROM TA_ROOM_ITEM WHERE [TYPEID] = 1207967768
INSERT INTO TA_ROOM_ITEM
 ( [CANTUSEUP], [GROUP], [TYPE], [SERIAL], [NAME], [LEVEL], [IS_UNDERLVL], [ICON], [PRICE], [SALE_PRICE], [PURCHASE_PRICE], [IS_CASH], [IS_SALABLE], [IN_STOCK], [NEW], [HIT], [USE_YN], [COM0], [COM1], [COM2], [COM3], [COM4], [DATA], [IS_OWN], [NUM], [MOVE], [IS_FUNCTION], [ETC], [POS_X], [POS_Y], [POS_Z], [POS_R], TEX_0, TEX_1, TEX_2, ORGINAL_TEX_0, ORGINAL_TEX_1, ORGINAL_TEX_2 )
 VALUES
 ( 0, 0, 0, 8216, N'Pink Sofa', 0, 0, N'sofa00', 4500, 0, 0, 0, 0, 1, 1, 0, 'Y', 0, 0, 0, 0, 0, N'sofa_a', 0, 0, 1, 0, 2, -18.719999313354, 1, 2.7599999904633, 90, N'', N'', N'', N'', N'', N'' )
-- Furniture Name: ?? ???
 -- Furniture ID:   1207969797
 IF EXISTS (SELECT [TYPEID] FROM TA_ROOM_ITEM WHERE [TYPEID] = 1207969797)
 DELETE FROM TA_ROOM_ITEM WHERE [TYPEID] = 1207969797
INSERT INTO TA_ROOM_ITEM
 ( [CANTUSEUP], [GROUP], [TYPE], [SERIAL], [NAME], [LEVEL], [IS_UNDERLVL], [ICON], [PRICE], [SALE_PRICE], [PURCHASE_PRICE], [IS_CASH], [IS_SALABLE], [IN_STOCK], [NEW], [HIT], [USE_YN], [COM0], [COM1], [COM2], [COM3], [COM4], [DATA], [IS_OWN], [NUM], [MOVE], [IS_FUNCTION], [ETC], [POS_X], [POS_Y], [POS_Z], [POS_R], TEX_0, TEX_1, TEX_2, ORGINAL_TEX_0, ORGINAL_TEX_1, ORGINAL_TEX_2 )
 VALUES
 ( 0, 0, 0, 10245, N'?? ???', 0, 0, N'item0_05', 0, 0, 0, 0, 0, 1, 0, 0, 'Y', 0, 0, 0, 0, 0, N'my_bottom_01_01', 0, 0, 1, 0, 2, -0.070000000298023, 1.5099999904633, 0, 0, N'', N'', N'', N'', N'', N'' )
-- Furniture Name: Pink Table
 -- Furniture ID:   1207969817
 IF EXISTS (SELECT [TYPEID] FROM TA_ROOM_ITEM WHERE [TYPEID] = 1207969817)
 DELETE FROM TA_ROOM_ITEM WHERE [TYPEID] = 1207969817
INSERT INTO TA_ROOM_ITEM
 ( [CANTUSEUP], [GROUP], [TYPE], [SERIAL], [NAME], [LEVEL], [IS_UNDERLVL], [ICON], [PRICE], [SALE_PRICE], [PURCHASE_PRICE], [IS_CASH], [IS_SALABLE], [IN_STOCK], [NEW], [HIT], [USE_YN], [COM0], [COM1], [COM2], [COM3], [COM4], [DATA], [IS_OWN], [NUM], [MOVE], [IS_FUNCTION], [ETC], [POS_X], [POS_Y], [POS_Z], [POS_R], TEX_0, TEX_1, TEX_2, ORGINAL_TEX_0, ORGINAL_TEX_1, ORGINAL_TEX_2 )
 VALUES
 ( 0, 0, 0, 10265, N'Pink Table', 0, 0, N'table00', 65, 0, 0, 1, 0, 1, 0, 0, 'Y', 0, 0, 0, 0, 0, N'table_a', 0, 0, 1, 0, 2, 0.93000000715256, 1.5, 2.460000038147, 0, N'', N'', N'', N'', N'', N'' )
-- Furniture Name: ??
 -- Furniture ID:   1207971846
 IF EXISTS (SELECT [TYPEID] FROM TA_ROOM_ITEM WHERE [TYPEID] = 1207971846)
 DELETE FROM TA_ROOM_ITEM WHERE [TYPEID] = 1207971846
INSERT INTO TA_ROOM_ITEM
 ( [CANTUSEUP], [GROUP], [TYPE], [SERIAL], [NAME], [LEVEL], [IS_UNDERLVL], [ICON], [PRICE], [SALE_PRICE], [PURCHASE_PRICE], [IS_CASH], [IS_SALABLE], [IN_STOCK], [NEW], [HIT], [USE_YN], [COM0], [COM1], [COM2], [COM3], [COM4], [DATA], [IS_OWN], [NUM], [MOVE], [IS_FUNCTION], [ETC], [POS_X], [POS_Y], [POS_Z], [POS_R], TEX_0, TEX_1, TEX_2, ORGINAL_TEX_0, ORGINAL_TEX_1, ORGINAL_TEX_2 )
 VALUES
 ( 0, 0, 0, 12294, N'??', 0, 0, N'item0_06', 0, 0, 0, 0, 0, 1, 0, 0, 'Y', 0, 0, 0, 0, 0, N'my_win_01_01', 0, 0, 1, 1, 5, 24.520000457764, 7.960000038147, 9.6800003051758, 270, N'', N'', N'', N'', N'', N'' )
-- Furniture Name: Pink Windows
 -- Furniture ID:   1207971866
 IF EXISTS (SELECT [TYPEID] FROM TA_ROOM_ITEM WHERE [TYPEID] = 1207971866)
 DELETE FROM TA_ROOM_ITEM WHERE [TYPEID] = 1207971866
INSERT INTO TA_ROOM_ITEM
 ( [CANTUSEUP], [GROUP], [TYPE], [SERIAL], [NAME], [LEVEL], [IS_UNDERLVL], [ICON], [PRICE], [SALE_PRICE], [PURCHASE_PRICE], [IS_CASH], [IS_SALABLE], [IN_STOCK], [NEW], [HIT], [USE_YN], [COM0], [COM1], [COM2], [COM3], [COM4], [DATA], [IS_OWN], [NUM], [MOVE], [IS_FUNCTION], [ETC], [POS_X], [POS_Y], [POS_Z], [POS_R], TEX_0, TEX_1, TEX_2, ORGINAL_TEX_0, ORGINAL_TEX_1, ORGINAL_TEX_2 )
 VALUES
 ( 0, 0, 0, 12314, N'Pink Windows', 0, 0, N'windows00', 8300, 0, 0, 0, 0, 1, 1, 0, 'Y', 0, 0, 0, 0, 0, N'window_a', 0, 0, 1, 0, 5, 17.239999771118, 8.1000003814697, 16.799999237061, 0, N'', N'', N'', N'', N'', N'' )
-- Furniture Name: ?? ??
 -- Furniture ID:   1207973895
 IF EXISTS (SELECT [TYPEID] FROM TA_ROOM_ITEM WHERE [TYPEID] = 1207973895)
 DELETE FROM TA_ROOM_ITEM WHERE [TYPEID] = 1207973895
INSERT INTO TA_ROOM_ITEM
 ( [CANTUSEUP], [GROUP], [TYPE], [SERIAL], [NAME], [LEVEL], [IS_UNDERLVL], [ICON], [PRICE], [SALE_PRICE], [PURCHASE_PRICE], [IS_CASH], [IS_SALABLE], [IN_STOCK], [NEW], [HIT], [USE_YN], [COM0], [COM1], [COM2], [COM3], [COM4], [DATA], [IS_OWN], [NUM], [MOVE], [IS_FUNCTION], [ETC], [POS_X], [POS_Y], [POS_Z], [POS_R], TEX_0, TEX_1, TEX_2, ORGINAL_TEX_0, ORGINAL_TEX_1, ORGINAL_TEX_2 )
 VALUES
 ( 0, 0, 0, 14343, N'?? ?? ', 0, 0, N'item0_07', 0, 0, 0, 0, 0, 1, 0, 0, 'Y', 0, 0, 0, 0, 0, N'my_roof_01_01', 0, 0, 1, 0, 6, -0.029999999329448, 18.290000915527, 0.49000000953674, 0, N'', N'', N'', N'', N'', N'' )
-- Furniture Name: Roof Curtain
 -- Furniture ID:   1207973915
 IF EXISTS (SELECT [TYPEID] FROM TA_ROOM_ITEM WHERE [TYPEID] = 1207973915)
 DELETE FROM TA_ROOM_ITEM WHERE [TYPEID] = 1207973915
INSERT INTO TA_ROOM_ITEM
 ( [CANTUSEUP], [GROUP], [TYPE], [SERIAL], [NAME], [LEVEL], [IS_UNDERLVL], [ICON], [PRICE], [SALE_PRICE], [PURCHASE_PRICE], [IS_CASH], [IS_SALABLE], [IN_STOCK], [NEW], [HIT], [USE_YN], [COM0], [COM1], [COM2], [COM3], [COM4], [DATA], [IS_OWN], [NUM], [MOVE], [IS_FUNCTION], [ETC], [POS_X], [POS_Y], [POS_Z], [POS_R], TEX_0, TEX_1, TEX_2, ORGINAL_TEX_0, ORGINAL_TEX_1, ORGINAL_TEX_2 )
 VALUES
 ( 0, 0, 0, 14363, N'Roof Curtain', 0, 0, N'item0_07', 0, 0, 0, 0, 0, 1, 0, 0, 'Y', 0, 0, 0, 0, 0, N'canopy_a', 0, 0, 1, 0, 6, 0.090000003576279, 20.129999160767, 1.6900000572205, 0, N'', N'', N'', N'', N'', N'' )
-- Furniture Name: Pink Roof Curtain
 -- Furniture ID:   1207973916
 IF EXISTS (SELECT [TYPEID] FROM TA_ROOM_ITEM WHERE [TYPEID] = 1207973916)
 DELETE FROM TA_ROOM_ITEM WHERE [TYPEID] = 1207973916
INSERT INTO TA_ROOM_ITEM
 ( [CANTUSEUP], [GROUP], [TYPE], [SERIAL], [NAME], [LEVEL], [IS_UNDERLVL], [ICON], [PRICE], [SALE_PRICE], [PURCHASE_PRICE], [IS_CASH], [IS_SALABLE], [IN_STOCK], [NEW], [HIT], [USE_YN], [COM0], [COM1], [COM2], [COM3], [COM4], [DATA], [IS_OWN], [NUM], [MOVE], [IS_FUNCTION], [ETC], [POS_X], [POS_Y], [POS_Z], [POS_R], TEX_0, TEX_1, TEX_2, ORGINAL_TEX_0, ORGINAL_TEX_1, ORGINAL_TEX_2 )
 VALUES
 ( 0, 0, 0, 14364, N'Pink Roof Curtain', 0, 0, N'canopy_a00', 14800, 0, 0, 0, 0, 1, 1, 0, 'Y', 0, 0, 0, 0, 0, N'canopy_a02', 0, 0, 1, 0, 6, 0.090000003576279, 20.129999160767, 1.6900000572205, 0, N'', N'', N'', N'', N'', N'' )
-- Furniture Name: Default Floor
 -- Furniture ID:   1207975944
 IF EXISTS (SELECT [TYPEID] FROM TA_ROOM_ITEM WHERE [TYPEID] = 1207975944)
 DELETE FROM TA_ROOM_ITEM WHERE [TYPEID] = 1207975944
INSERT INTO TA_ROOM_ITEM
 ( [CANTUSEUP], [GROUP], [TYPE], [SERIAL], [NAME], [LEVEL], [IS_UNDERLVL], [ICON], [PRICE], [SALE_PRICE], [PURCHASE_PRICE], [IS_CASH], [IS_SALABLE], [IN_STOCK], [NEW], [HIT], [USE_YN], [COM0], [COM1], [COM2], [COM3], [COM4], [DATA], [IS_OWN], [NUM], [MOVE], [IS_FUNCTION], [ETC], [POS_X], [POS_Y], [POS_Z], [POS_R], TEX_0, TEX_1, TEX_2, ORGINAL_TEX_0, ORGINAL_TEX_1, ORGINAL_TEX_2 )
 VALUES
 ( 0, 0, 0, 16392, N'Default Floor', 0, 0, N'item0_08', 0, 0, 0, 0, 0, 1, 0, 0, 'Y', 0, 0, 0, 0, 0, N'floortile_01', 0, 0, 1, 0, 0, 0, 0, 0, 0, N'floor_a', N'', N'', N'floor_a', N'', N'' )
-- Furniture Name: Light Wood Floor
 -- Furniture ID:   1207975945
 IF EXISTS (SELECT [TYPEID] FROM TA_ROOM_ITEM WHERE [TYPEID] = 1207975945)
 DELETE FROM TA_ROOM_ITEM WHERE [TYPEID] = 1207975945
INSERT INTO TA_ROOM_ITEM
 ( [CANTUSEUP], [GROUP], [TYPE], [SERIAL], [NAME], [LEVEL], [IS_UNDERLVL], [ICON], [PRICE], [SALE_PRICE], [PURCHASE_PRICE], [IS_CASH], [IS_SALABLE], [IN_STOCK], [NEW], [HIT], [USE_YN], [COM0], [COM1], [COM2], [COM3], [COM4], [DATA], [IS_OWN], [NUM], [MOVE], [IS_FUNCTION], [ETC], [POS_X], [POS_Y], [POS_Z], [POS_R], TEX_0, TEX_1, TEX_2, ORGINAL_TEX_0, ORGINAL_TEX_1, ORGINAL_TEX_2 )
 VALUES
 ( 0, 0, 0, 16393, N'Light Wood Floor', 0, 0, N'floor01', 1600, 0, 0, 0, 0, 1, 1, 0, 'Y', 0, 0, 0, 0, 0, N'floortile_02', 0, 0, 1, 0, 0, 0, 0, 0, 0, N'floor_hana', N'', N'', N'floor_a', N'', N'' )
-- Furniture Name: Green Square Floor
 -- Furniture ID:   1207975946
 IF EXISTS (SELECT [TYPEID] FROM TA_ROOM_ITEM WHERE [TYPEID] = 1207975946)
 DELETE FROM TA_ROOM_ITEM WHERE [TYPEID] = 1207975946
INSERT INTO TA_ROOM_ITEM
 ( [CANTUSEUP], [GROUP], [TYPE], [SERIAL], [NAME], [LEVEL], [IS_UNDERLVL], [ICON], [PRICE], [SALE_PRICE], [PURCHASE_PRICE], [IS_CASH], [IS_SALABLE], [IN_STOCK], [NEW], [HIT], [USE_YN], [COM0], [COM1], [COM2], [COM3], [COM4], [DATA], [IS_OWN], [NUM], [MOVE], [IS_FUNCTION], [ETC], [POS_X], [POS_Y], [POS_Z], [POS_R], TEX_0, TEX_1, TEX_2, ORGINAL_TEX_0, ORGINAL_TEX_1, ORGINAL_TEX_2 )
 VALUES
 ( 0, 0, 0, 16394, N'Green Square Floor', 0, 0, N'floor00', 1200, 0, 0, 0, 0, 1, 1, 0, 'Y', 0, 0, 0, 0, 0, N'floortile_03', 0, 0, 1, 0, 0, 0, 0, 0, 0, N'floor_c', N'', N'', N'floor_a', N'', N'' )
-- Furniture Name: ??? 4
 -- Furniture ID:   1207975947
 IF EXISTS (SELECT [TYPEID] FROM TA_ROOM_ITEM WHERE [TYPEID] = 1207975947)
 DELETE FROM TA_ROOM_ITEM WHERE [TYPEID] = 1207975947
INSERT INTO TA_ROOM_ITEM
 ( [CANTUSEUP], [GROUP], [TYPE], [SERIAL], [NAME], [LEVEL], [IS_UNDERLVL], [ICON], [PRICE], [SALE_PRICE], [PURCHASE_PRICE], [IS_CASH], [IS_SALABLE], [IN_STOCK], [NEW], [HIT], [USE_YN], [COM0], [COM1], [COM2], [COM3], [COM4], [DATA], [IS_OWN], [NUM], [MOVE], [IS_FUNCTION], [ETC], [POS_X], [POS_Y], [POS_Z], [POS_R], TEX_0, TEX_1, TEX_2, ORGINAL_TEX_0, ORGINAL_TEX_1, ORGINAL_TEX_2 )
 VALUES
 ( 0, 0, 0, 16395, N'??? 4', 0, 0, N'item0_11', 0, 0, 0, 0, 0, 1, 0, 0, 'Y', 0, 0, 0, 0, 0, N'floor_a', 0, 0, 1, 0, 0, 0, 0, 0, 0, N'', N'', N'', N'', N'', N'' )
-- Furniture Name: ??? 5
 -- Furniture ID:   1207975948
 IF EXISTS (SELECT [TYPEID] FROM TA_ROOM_ITEM WHERE [TYPEID] = 1207975948)
 DELETE FROM TA_ROOM_ITEM WHERE [TYPEID] = 1207975948
INSERT INTO TA_ROOM_ITEM
 ( [CANTUSEUP], [GROUP], [TYPE], [SERIAL], [NAME], [LEVEL], [IS_UNDERLVL], [ICON], [PRICE], [SALE_PRICE], [PURCHASE_PRICE], [IS_CASH], [IS_SALABLE], [IN_STOCK], [NEW], [HIT], [USE_YN], [COM0], [COM1], [COM2], [COM3], [COM4], [DATA], [IS_OWN], [NUM], [MOVE], [IS_FUNCTION], [ETC], [POS_X], [POS_Y], [POS_Z], [POS_R], TEX_0, TEX_1, TEX_2, ORGINAL_TEX_0, ORGINAL_TEX_1, ORGINAL_TEX_2 )
 VALUES
 ( 0, 0, 0, 16396, N'??? 5', 0, 0, N'item0_12', 0, 0, 0, 0, 0, 1, 0, 0, 'Y', 0, 0, 0, 0, 0, N'floor_a', 0, 0, 1, 0, 0, 0, 0, 0, 0, N'', N'', N'', N'', N'', N'' )
-- Furniture Name: ??? 6
 -- Furniture ID:   1207975949
 IF EXISTS (SELECT [TYPEID] FROM TA_ROOM_ITEM WHERE [TYPEID] = 1207975949)
 DELETE FROM TA_ROOM_ITEM WHERE [TYPEID] = 1207975949
INSERT INTO TA_ROOM_ITEM
 ( [CANTUSEUP], [GROUP], [TYPE], [SERIAL], [NAME], [LEVEL], [IS_UNDERLVL], [ICON], [PRICE], [SALE_PRICE], [PURCHASE_PRICE], [IS_CASH], [IS_SALABLE], [IN_STOCK], [NEW], [HIT], [USE_YN], [COM0], [COM1], [COM2], [COM3], [COM4], [DATA], [IS_OWN], [NUM], [MOVE], [IS_FUNCTION], [ETC], [POS_X], [POS_Y], [POS_Z], [POS_R], TEX_0, TEX_1, TEX_2, ORGINAL_TEX_0, ORGINAL_TEX_1, ORGINAL_TEX_2 )
 VALUES
 ( 0, 0, 0, 16397, N'??? 6', 0, 0, N'item0_13', 0, 0, 0, 0, 0, 1, 0, 0, 'Y', 0, 0, 0, 0, 0, N'floor_a', 0, 0, 1, 0, 0, 0, 0, 0, 0, N'', N'', N'', N'', N'', N'' )
-- Furniture Name: Default Wallpaper
 -- Furniture ID:   1207977998
 IF EXISTS (SELECT [TYPEID] FROM TA_ROOM_ITEM WHERE [TYPEID] = 1207977998)
 DELETE FROM TA_ROOM_ITEM WHERE [TYPEID] = 1207977998
INSERT INTO TA_ROOM_ITEM
 ( [CANTUSEUP], [GROUP], [TYPE], [SERIAL], [NAME], [LEVEL], [IS_UNDERLVL], [ICON], [PRICE], [SALE_PRICE], [PURCHASE_PRICE], [IS_CASH], [IS_SALABLE], [IN_STOCK], [NEW], [HIT], [USE_YN], [COM0], [COM1], [COM2], [COM3], [COM4], [DATA], [IS_OWN], [NUM], [MOVE], [IS_FUNCTION], [ETC], [POS_X], [POS_Y], [POS_Z], [POS_R], TEX_0, TEX_1, TEX_2, ORGINAL_TEX_0, ORGINAL_TEX_1, ORGINAL_TEX_2 )
 VALUES
 ( 0, 0, 0, 18446, N'Default Wallpaper', 0, 0, N'item0_14', 0, 0, 0, 0, 0, 1, 0, 0, 'Y', 0, 0, 0, 0, 0, N'wallpaper_01', 0, 0, 1, 0, 0, 0, 0, 0, 0, N'+wall_a', N'+wall_a_02', N'+roof_a', N'+wall_a', N'+wall_a_02', N'+roof_a' )
-- Furniture Name: Blue Dot Wallpaper
 -- Furniture ID:   1207977999
 IF EXISTS (SELECT [TYPEID] FROM TA_ROOM_ITEM WHERE [TYPEID] = 1207977999)
 DELETE FROM TA_ROOM_ITEM WHERE [TYPEID] = 1207977999
INSERT INTO TA_ROOM_ITEM
 ( [CANTUSEUP], [GROUP], [TYPE], [SERIAL], [NAME], [LEVEL], [IS_UNDERLVL], [ICON], [PRICE], [SALE_PRICE], [PURCHASE_PRICE], [IS_CASH], [IS_SALABLE], [IN_STOCK], [NEW], [HIT], [USE_YN], [COM0], [COM1], [COM2], [COM3], [COM4], [DATA], [IS_OWN], [NUM], [MOVE], [IS_FUNCTION], [ETC], [POS_X], [POS_Y], [POS_Z], [POS_R], TEX_0, TEX_1, TEX_2, ORGINAL_TEX_0, ORGINAL_TEX_1, ORGINAL_TEX_2 )
 VALUES
 ( 0, 0, 0, 18447, N'Blue Dot Wallpaper', 0, 0, N'wallpaper01', 1500, 0, 0, 0, 0, 1, 1, 0, 'Y', 0, 0, 0, 0, 0, N'wallpaper_03', 0, 0, 1, 0, 0, 0, 0, 0, 0, N'+wall_c', N'+wall_c_02', N'+roof_c', N'+wall_a', N'+wall_a_02', N'+roof_a' )
-- Furniture Name: Flower Wallpaper
 -- Furniture ID:   1207978000
 IF EXISTS (SELECT [TYPEID] FROM TA_ROOM_ITEM WHERE [TYPEID] = 1207978000)
 DELETE FROM TA_ROOM_ITEM WHERE [TYPEID] = 1207978000
INSERT INTO TA_ROOM_ITEM
 ( [CANTUSEUP], [GROUP], [TYPE], [SERIAL], [NAME], [LEVEL], [IS_UNDERLVL], [ICON], [PRICE], [SALE_PRICE], [PURCHASE_PRICE], [IS_CASH], [IS_SALABLE], [IN_STOCK], [NEW], [HIT], [USE_YN], [COM0], [COM1], [COM2], [COM3], [COM4], [DATA], [IS_OWN], [NUM], [MOVE], [IS_FUNCTION], [ETC], [POS_X], [POS_Y], [POS_Z], [POS_R], TEX_0, TEX_1, TEX_2, ORGINAL_TEX_0, ORGINAL_TEX_1, ORGINAL_TEX_2 )
 VALUES
 ( 0, 0, 0, 18448, N'Flower Wallpaper', 0, 0, N'wallpaper00', 2000, 0, 0, 0, 0, 1, 1, 0, 'Y', 0, 0, 0, 0, 0, N'wallpaper_02', 0, 0, 1, 0, 0, 0, 0, 0, 0, N'+wall_hana', N'+wall_hana_02', N'+roof_hana', N'+wall_a', N'+wall_a_02', N'+roof_a' )
-- Furniture Name: ??4
 -- Furniture ID:   1207978001
 IF EXISTS (SELECT [TYPEID] FROM TA_ROOM_ITEM WHERE [TYPEID] = 1207978001)
 DELETE FROM TA_ROOM_ITEM WHERE [TYPEID] = 1207978001
INSERT INTO TA_ROOM_ITEM
 ( [CANTUSEUP], [GROUP], [TYPE], [SERIAL], [NAME], [LEVEL], [IS_UNDERLVL], [ICON], [PRICE], [SALE_PRICE], [PURCHASE_PRICE], [IS_CASH], [IS_SALABLE], [IN_STOCK], [NEW], [HIT], [USE_YN], [COM0], [COM1], [COM2], [COM3], [COM4], [DATA], [IS_OWN], [NUM], [MOVE], [IS_FUNCTION], [ETC], [POS_X], [POS_Y], [POS_Z], [POS_R], TEX_0, TEX_1, TEX_2, ORGINAL_TEX_0, ORGINAL_TEX_1, ORGINAL_TEX_2 )
 VALUES
 ( 0, 0, 0, 18449, N'??4', 0, 0, N'item0_17', 0, 0, 0, 0, 0, 1, 0, 0, 'Y', 0, 0, 0, 0, 0, N'wall_a', 0, 0, 1, 0, 0, 0, 0, 0, 0, N'', N'', N'', N'', N'', N'' )
-- Furniture Name: ??5
 -- Furniture ID:   1207978002
 IF EXISTS (SELECT [TYPEID] FROM TA_ROOM_ITEM WHERE [TYPEID] = 1207978002)
 DELETE FROM TA_ROOM_ITEM WHERE [TYPEID] = 1207978002
INSERT INTO TA_ROOM_ITEM
 ( [CANTUSEUP], [GROUP], [TYPE], [SERIAL], [NAME], [LEVEL], [IS_UNDERLVL], [ICON], [PRICE], [SALE_PRICE], [PURCHASE_PRICE], [IS_CASH], [IS_SALABLE], [IN_STOCK], [NEW], [HIT], [USE_YN], [COM0], [COM1], [COM2], [COM3], [COM4], [DATA], [IS_OWN], [NUM], [MOVE], [IS_FUNCTION], [ETC], [POS_X], [POS_Y], [POS_Z], [POS_R], TEX_0, TEX_1, TEX_2, ORGINAL_TEX_0, ORGINAL_TEX_1, ORGINAL_TEX_2 )
 VALUES
 ( 0, 0, 0, 18450, N'??5', 0, 0, N'item0_18', 0, 0, 0, 0, 0, 1, 0, 0, 'Y', 0, 0, 0, 0, 0, N'wall_a', 0, 0, 1, 0, 0, 0, 0, 0, 0, N'', N'', N'', N'', N'', N'' )
-- Furniture Name: ??6
 -- Furniture ID:   1207978003
 IF EXISTS (SELECT [TYPEID] FROM TA_ROOM_ITEM WHERE [TYPEID] = 1207978003)
 DELETE FROM TA_ROOM_ITEM WHERE [TYPEID] = 1207978003
INSERT INTO TA_ROOM_ITEM
 ( [CANTUSEUP], [GROUP], [TYPE], [SERIAL], [NAME], [LEVEL], [IS_UNDERLVL], [ICON], [PRICE], [SALE_PRICE], [PURCHASE_PRICE], [IS_CASH], [IS_SALABLE], [IN_STOCK], [NEW], [HIT], [USE_YN], [COM0], [COM1], [COM2], [COM3], [COM4], [DATA], [IS_OWN], [NUM], [MOVE], [IS_FUNCTION], [ETC], [POS_X], [POS_Y], [POS_Z], [POS_R], TEX_0, TEX_1, TEX_2, ORGINAL_TEX_0, ORGINAL_TEX_1, ORGINAL_TEX_2 )
 VALUES
 ( 0, 0, 0, 18451, N'??6', 0, 0, N'item0_19', 0, 0, 0, 0, 0, 1, 0, 0, 'Y', 0, 0, 0, 0, 0, N'wall_a', 0, 0, 1, 0, 0, 0, 0, 0, 0, N'', N'', N'', N'', N'', N'' )
-- Furniture Name: Wood Postbox
 -- Furniture ID:   1207980061
 IF EXISTS (SELECT [TYPEID] FROM TA_ROOM_ITEM WHERE [TYPEID] = 1207980061)
 DELETE FROM TA_ROOM_ITEM WHERE [TYPEID] = 1207980061
INSERT INTO TA_ROOM_ITEM
 ( [CANTUSEUP], [GROUP], [TYPE], [SERIAL], [NAME], [LEVEL], [IS_UNDERLVL], [ICON], [PRICE], [SALE_PRICE], [PURCHASE_PRICE], [IS_CASH], [IS_SALABLE], [IN_STOCK], [NEW], [HIT], [USE_YN], [COM0], [COM1], [COM2], [COM3], [COM4], [DATA], [IS_OWN], [NUM], [MOVE], [IS_FUNCTION], [ETC], [POS_X], [POS_Y], [POS_Z], [POS_R], TEX_0, TEX_1, TEX_2, ORGINAL_TEX_0, ORGINAL_TEX_1, ORGINAL_TEX_2 )
 VALUES
 ( 0, 0, 0, 20509, N'Wood Postbox', 0, 0, N'mail_a00', 10000000, 0, 0, 0, 0, 1, 0, 0, 'Y', 0, 0, 0, 0, 0, N'mail_a', 0, 0, 1, 0, 2, 14.125, 1, 0.041000001132488, 0, N'', N'', N'', N'', N'', N'' )
-- Furniture Name: Shelves slot
 -- Furniture ID:   1207982111
 IF EXISTS (SELECT [TYPEID] FROM TA_ROOM_ITEM WHERE [TYPEID] = 1207982111)
 DELETE FROM TA_ROOM_ITEM WHERE [TYPEID] = 1207982111
INSERT INTO TA_ROOM_ITEM
 ( [CANTUSEUP], [GROUP], [TYPE], [SERIAL], [NAME], [LEVEL], [IS_UNDERLVL], [ICON], [PRICE], [SALE_PRICE], [PURCHASE_PRICE], [IS_CASH], [IS_SALABLE], [IN_STOCK], [NEW], [HIT], [USE_YN], [COM0], [COM1], [COM2], [COM3], [COM4], [DATA], [IS_OWN], [NUM], [MOVE], [IS_FUNCTION], [ETC], [POS_X], [POS_Y], [POS_Z], [POS_R], TEX_0, TEX_1, TEX_2, ORGINAL_TEX_0, ORGINAL_TEX_1, ORGINAL_TEX_2 )
 VALUES
 ( 0, 0, 0, 22559, N'Shelves slot ', 0, 0, N'mail_a00', 1000, 0, 0, 0, 0, 1, 0, 0, 'Y', 0, 0, 0, 0, 0, N'', 0, 0, 1, 0, 2, 0, 0, 0, 0, N'', N'', N'', N'', N'', N'' )
-- Furniture Name: Shelves slot
 -- Furniture ID:   1207984158
 IF EXISTS (SELECT [TYPEID] FROM TA_ROOM_ITEM WHERE [TYPEID] = 1207984158)
 DELETE FROM TA_ROOM_ITEM WHERE [TYPEID] = 1207984158
INSERT INTO TA_ROOM_ITEM
 ( [CANTUSEUP], [GROUP], [TYPE], [SERIAL], [NAME], [LEVEL], [IS_UNDERLVL], [ICON], [PRICE], [SALE_PRICE], [PURCHASE_PRICE], [IS_CASH], [IS_SALABLE], [IN_STOCK], [NEW], [HIT], [USE_YN], [COM0], [COM1], [COM2], [COM3], [COM4], [DATA], [IS_OWN], [NUM], [MOVE], [IS_FUNCTION], [ETC], [POS_X], [POS_Y], [POS_Z], [POS_R], TEX_0, TEX_1, TEX_2, ORGINAL_TEX_0, ORGINAL_TEX_1, ORGINAL_TEX_2 )
 VALUES
 ( 0, 0, 0, 24606, N'Shelves slot', 0, 0, N'mail_a00', 1000, 0, 0, 0, 0, 1, 0, 0, 'Y', 500, 3000, 0, 10000, 0, N'', 0, 0, 1, 0, 0, 0, 0, 0, 0, N'', N'', N'', N'', N'', N'' )
-- Furniture Name: Secret Safe
 -- Furniture ID:   1207986208
 IF EXISTS (SELECT [TYPEID] FROM TA_ROOM_ITEM WHERE [TYPEID] = 1207986208)
 DELETE FROM TA_ROOM_ITEM WHERE [TYPEID] = 1207986208
INSERT INTO TA_ROOM_ITEM
 ( [CANTUSEUP], [GROUP], [TYPE], [SERIAL], [NAME], [LEVEL], [IS_UNDERLVL], [ICON], [PRICE], [SALE_PRICE], [PURCHASE_PRICE], [IS_CASH], [IS_SALABLE], [IN_STOCK], [NEW], [HIT], [USE_YN], [COM0], [COM1], [COM2], [COM3], [COM4], [DATA], [IS_OWN], [NUM], [MOVE], [IS_FUNCTION], [ETC], [POS_X], [POS_Y], [POS_Z], [POS_R], TEX_0, TEX_1, TEX_2, ORGINAL_TEX_0, ORGINAL_TEX_1, ORGINAL_TEX_2 )
 VALUES
 ( 0, 0, 0, 26656, N'Secret Safe', 0, 0, N'pinkbag_00', 10000000, 0, 0, 0, 0, 1, 0, 0, 'Y', 0, 0, 0, 0, 0, N'pink bag', 0, 0, 1, 0, 2, 15.199999809265, 0, 12.5, 152, N'+bag_01', N'+2#_tag_01', N'', N'+bag_01', N'+2#_tag_01', N'' )
-- Furniture Name: Vintage Suitcase
 -- Furniture ID:   1207986209
 IF EXISTS (SELECT [TYPEID] FROM TA_ROOM_ITEM WHERE [TYPEID] = 1207986209)
 DELETE FROM TA_ROOM_ITEM WHERE [TYPEID] = 1207986209
INSERT INTO TA_ROOM_ITEM
 ( [CANTUSEUP], [GROUP], [TYPE], [SERIAL], [NAME], [LEVEL], [IS_UNDERLVL], [ICON], [PRICE], [SALE_PRICE], [PURCHASE_PRICE], [IS_CASH], [IS_SALABLE], [IN_STOCK], [NEW], [HIT], [USE_YN], [COM0], [COM1], [COM2], [COM3], [COM4], [DATA], [IS_OWN], [NUM], [MOVE], [IS_FUNCTION], [ETC], [POS_X], [POS_Y], [POS_Z], [POS_R], TEX_0, TEX_1, TEX_2, ORGINAL_TEX_0, ORGINAL_TEX_1, ORGINAL_TEX_2 )
 VALUES
 ( 0, 0, 0, 26657, N'Vintage Suitcase', 0, 0, N'canopy_a00', 10000000, 0, 0, 0, 0, 1, 0, 0, 'Y', 0, 0, 0, 0, 0, N'black bag', 0, 0, 1, 0, 2, 15.199999809265, 0, 12.5, 152, N'+bag_01', N'+2#_tag_01', N'', N'+bag_02', N'+2#_tag_02', N'' )
-- Furniture Name: เตาผิง
 -- Furniture ID:   1207986211
 IF EXISTS (SELECT [TYPEID] FROM TA_ROOM_ITEM WHERE [TYPEID] = 1207986211)
 DELETE FROM TA_ROOM_ITEM WHERE [TYPEID] = 1207986211
INSERT INTO TA_ROOM_ITEM
 ( [CANTUSEUP], [GROUP], [TYPE], [SERIAL], [NAME], [LEVEL], [IS_UNDERLVL], [ICON], [PRICE], [SALE_PRICE], [PURCHASE_PRICE], [IS_CASH], [IS_SALABLE], [IN_STOCK], [NEW], [HIT], [USE_YN], [COM0], [COM1], [COM2], [COM3], [COM4], [DATA], [IS_OWN], [NUM], [MOVE], [IS_FUNCTION], [ETC], [POS_X], [POS_Y], [POS_Z], [POS_R], TEX_0, TEX_1, TEX_2, ORGINAL_TEX_0, ORGINAL_TEX_1, ORGINAL_TEX_2 )
 VALUES
 ( 0, 0, 0, 26659, N'เตาผิง', 0, 0, N'stove_00', 50000, 0, 0, 0, 0, 1, 1, 0, 'Y', 0, 0, 0, 0, 0, N'stove', 0, 0, 1, 0, 2, 13, 0, 6, 30, N'', N'', N'', N'', N'', N'' )
-- Furniture Name: Hana Poster(Ver.1)
 -- Furniture ID:   1207988260
 IF EXISTS (SELECT [TYPEID] FROM TA_ROOM_ITEM WHERE [TYPEID] = 1207988260)
 DELETE FROM TA_ROOM_ITEM WHERE [TYPEID] = 1207988260
INSERT INTO TA_ROOM_ITEM
 ( [CANTUSEUP], [GROUP], [TYPE], [SERIAL], [NAME], [LEVEL], [IS_UNDERLVL], [ICON], [PRICE], [SALE_PRICE], [PURCHASE_PRICE], [IS_CASH], [IS_SALABLE], [IN_STOCK], [NEW], [HIT], [USE_YN], [COM0], [COM1], [COM2], [COM3], [COM4], [DATA], [IS_OWN], [NUM], [MOVE], [IS_FUNCTION], [ETC], [POS_X], [POS_Y], [POS_Z], [POS_R], TEX_0, TEX_1, TEX_2, ORGINAL_TEX_0, ORGINAL_TEX_1, ORGINAL_TEX_2 )
 VALUES
 ( 0, 0, 0, 28708, N'Hana Poster(Ver.1)', 0, 0, N'poster_a00', 10000000, 0, 0, 0, 0, 1, 0, 0, 'Y', 0, 0, 0, 0, 0, N'poster_a', 0, 0, 1, 1, 5, -21.940000534058, 7.6999998092651, 13, 90, N'+2#_poster_Hana', N'', N'', N'+2#_poster_Arin', N'', N'' )
-- Furniture Name: Cesillia Poster(Ver.1)
 -- Furniture ID:   1207988261
 IF EXISTS (SELECT [TYPEID] FROM TA_ROOM_ITEM WHERE [TYPEID] = 1207988261)
 DELETE FROM TA_ROOM_ITEM WHERE [TYPEID] = 1207988261
INSERT INTO TA_ROOM_ITEM
 ( [CANTUSEUP], [GROUP], [TYPE], [SERIAL], [NAME], [LEVEL], [IS_UNDERLVL], [ICON], [PRICE], [SALE_PRICE], [PURCHASE_PRICE], [IS_CASH], [IS_SALABLE], [IN_STOCK], [NEW], [HIT], [USE_YN], [COM0], [COM1], [COM2], [COM3], [COM4], [DATA], [IS_OWN], [NUM], [MOVE], [IS_FUNCTION], [ETC], [POS_X], [POS_Y], [POS_Z], [POS_R], TEX_0, TEX_1, TEX_2, ORGINAL_TEX_0, ORGINAL_TEX_1, ORGINAL_TEX_2 )
 VALUES
 ( 0, 0, 0, 28709, N'Cesillia Poster(Ver.1)', 0, 0, N'poster_a01', 10000000, 0, 0, 0, 0, 1, 0, 0, 'Y', 0, 0, 0, 0, 0, N'poster_a', 0, 0, 1, 1, 5, -21.940000534058, 7.6999998092651, 13, 90, N'+2#_poster_Cecilia', N'', N'', N'+2#_poster_Arin', N'', N'' )
-- Furniture Name: Arin Poster(Ver.1)
 -- Furniture ID:   1207988262
 IF EXISTS (SELECT [TYPEID] FROM TA_ROOM_ITEM WHERE [TYPEID] = 1207988262)
 DELETE FROM TA_ROOM_ITEM WHERE [TYPEID] = 1207988262
INSERT INTO TA_ROOM_ITEM
 ( [CANTUSEUP], [GROUP], [TYPE], [SERIAL], [NAME], [LEVEL], [IS_UNDERLVL], [ICON], [PRICE], [SALE_PRICE], [PURCHASE_PRICE], [IS_CASH], [IS_SALABLE], [IN_STOCK], [NEW], [HIT], [USE_YN], [COM0], [COM1], [COM2], [COM3], [COM4], [DATA], [IS_OWN], [NUM], [MOVE], [IS_FUNCTION], [ETC], [POS_X], [POS_Y], [POS_Z], [POS_R], TEX_0, TEX_1, TEX_2, ORGINAL_TEX_0, ORGINAL_TEX_1, ORGINAL_TEX_2 )
 VALUES
 ( 0, 0, 0, 28710, N'Arin Poster(Ver.1)', 0, 0, N'poster_a02', 10000000, 0, 0, 0, 0, 1, 0, 0, 'Y', 0, 0, 0, 0, 0, N'poster_a', 0, 0, 1, 1, 5, -21.940000534058, 7.6999998092651, 13, 90, N'+2#_poster_Arin', N'', N'', N'+2#_poster_Arin', N'', N'' )
-- Furniture Name: Kooh Poster(Ver.1)
 -- Furniture ID:   1207988263
 IF EXISTS (SELECT [TYPEID] FROM TA_ROOM_ITEM WHERE [TYPEID] = 1207988263)
 DELETE FROM TA_ROOM_ITEM WHERE [TYPEID] = 1207988263
INSERT INTO TA_ROOM_ITEM
 ( [CANTUSEUP], [GROUP], [TYPE], [SERIAL], [NAME], [LEVEL], [IS_UNDERLVL], [ICON], [PRICE], [SALE_PRICE], [PURCHASE_PRICE], [IS_CASH], [IS_SALABLE], [IN_STOCK], [NEW], [HIT], [USE_YN], [COM0], [COM1], [COM2], [COM3], [COM4], [DATA], [IS_OWN], [NUM], [MOVE], [IS_FUNCTION], [ETC], [POS_X], [POS_Y], [POS_Z], [POS_R], TEX_0, TEX_1, TEX_2, ORGINAL_TEX_0, ORGINAL_TEX_1, ORGINAL_TEX_2 )
 VALUES
 ( 0, 0, 0, 28711, N'Kooh Poster(Ver.1)', 0, 0, N'poster_a03', 10000000, 0, 0, 0, 0, 1, 0, 0, 'Y', 0, 0, 0, 0, 0, N'poster_a', 0, 0, 1, 1, 5, -21.940000534058, 7.6999998092651, 13, 90, N'+2#_poster_Kooh', N'', N'', N'+2#_poster_Arin', N'', N'' )
-- Furniture Name: Lucia Poster(Ver.1)
 -- Furniture ID:   1207988264
 IF EXISTS (SELECT [TYPEID] FROM TA_ROOM_ITEM WHERE [TYPEID] = 1207988264)
 DELETE FROM TA_ROOM_ITEM WHERE [TYPEID] = 1207988264
INSERT INTO TA_ROOM_ITEM
 ( [CANTUSEUP], [GROUP], [TYPE], [SERIAL], [NAME], [LEVEL], [IS_UNDERLVL], [ICON], [PRICE], [SALE_PRICE], [PURCHASE_PRICE], [IS_CASH], [IS_SALABLE], [IN_STOCK], [NEW], [HIT], [USE_YN], [COM0], [COM1], [COM2], [COM3], [COM4], [DATA], [IS_OWN], [NUM], [MOVE], [IS_FUNCTION], [ETC], [POS_X], [POS_Y], [POS_Z], [POS_R], TEX_0, TEX_1, TEX_2, ORGINAL_TEX_0, ORGINAL_TEX_1, ORGINAL_TEX_2 )
 VALUES
 ( 0, 0, 0, 28712, N'Lucia Poster(Ver.1)', 0, 0, N'poster_a04', 10000000, 0, 0, 0, 0, 1, 0, 0, 'Y', 0, 0, 0, 0, 0, N'poster_a', 0, 0, 1, 1, 5, -21.940000534058, 7.6999998092651, 13, 90, N'+2#_poster_Lucia', N'', N'', N'+2#_poster_Arin', N'', N'' )
COMMIT TRAN InsertFurniture
 GO
-- See you on http://pangya.tsukasa.eu/encyclopedia

5 thoughts on “Arrumando Caldron e Decoration – Querry

  1. isso e database?

  2. se não for pedir de+ tem cumo fazer 1 video ensinando?

  3. nice steal…

  4. Speed tem como deichar essa query para que o item venha sem relogar?

Deixe uma Resposta

Preencha os seus detalhes abaixo ou clique num ícone para iniciar sessão:

Logótipo da WordPress.com

Está a comentar usando a sua conta WordPress.com Terminar Sessão / Alterar )

Imagem do Twitter

Está a comentar usando a sua conta Twitter Terminar Sessão / Alterar )

Facebook photo

Está a comentar usando a sua conta Facebook Terminar Sessão / Alterar )

Google+ photo

Está a comentar usando a sua conta Google+ Terminar Sessão / Alterar )

Connecting to %s