read the log filesOriginally Posted by chiosin2
You must have some failed queries
read the log files
You must have some failed queries
Code:USE [Pangya_S4_TH] GO /****** Objet : StoredProcedure [dbo].[USP_CHAR_EQUIP_SAVE_S4] Date de génération du script : 12/04/2010 00:48:23 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO Create PROC [dbo].[USP_CHAR_EQUIP_SAVE_S4] ( @UID INT , @CHAR_ITEM_ID INT , @STR VARCHAR(8000) , @DEBUG TINYINT = 0 ) AS BEGIN -- '1^123456|2|3^1243^2214^1' -- @EQUIP_NUM^@TYPEID^@ITEMID^@UCCIDX^@SEQ| -- @EQUIP_NUM^@TYPEID^@ITEMID^@UCCIDX^@SEQ SET NOCOUNT ON DECLARE @RET INT SET @RET = 0 --INPUT 분석(1차 파싱 결과) IF OBJECT_ID('TEMPDB..#TD_SRC') IS NOT NULL DROP TABLE #TD_SRC CREATE TABLE #TD_SRC ( IDX SMALLINT IDENTITY(1,1) , DT VARCHAR(1000) ) --INPUT 분석(2차 파싱) 및 RESULT를 저장 IF OBJECT_ID('TEMPDB..#TD_CHAR') IS NOT NULL DROP TABLE #TD_CHAR CREATE TABLE #TD_CHAR ( IDX SMALLINT IDENTITY(1,1) , UID INT , CHAR_ITEMID INT , EQUIP_NUM INT -- 캐릭터 파트 번호 , TYPEID INT -- 아이템 , ITEMID INT -- ITEMID , UCCIDX VARCHAR(8) -- UCC인덱스 , SEQ SMALLINT -- UCC 시퀀스 ) DECLARE @SQL VARCHAR(8000) , @STR_SEP CHAR(1) , @INTLOOP INT SET @STR_SEP = '|' SET @SQL = '' SET @INTLOOP = 1 IF CHARINDEX('|', @STR) > 0 BEGIN SELECT @SQL= 'SELECT LTRIM(C) C FROM (SELECT ''' + REPLACE(CONT,@STR_SEP,''' C UNION ALL ' + CHAR(13) + 'SELECT ''') + ''') T' FROM ( SELECT CONT = @STR ) X END ELSE BEGIN SET @SQL = 'SELECT LTRIM(C) C FROM (SELECT ''' + @STR + ''' C) T' END INSERT INTO #TD_SRC (DT) EXEC(@SQL) DECLARE @EQUIP_NUM VARCHAR(20) , @TYPEID VARCHAR(20) , @ITEMID VARCHAR(20) , @UCCIDX VARCHAR(20) , @SEQ VARCHAR(20) WHILE EXISTS( SELECT 1 FROM #TD_SRC WHERE IDX = @INTLOOP ) BEGIN SELECT @SQL = REPLACE(DT, '^', ' ^') FROM #TD_SRC WHERE IDX = @INTLOOP EXEC MASTER..XP_SSCANF @SQL, '%s ^%s ^%s ^%s ^%s', @EQUIP_NUM OUTPUT, @TYPEID OUTPUT, @ITEMID OUTPUT, @UCCIDX OUTPUT, @SEQ OUTPUT INSERT INTO #TD_CHAR (UID, CHAR_ITEMID, EQUIP_NUM, TYPEID, ITEMID, UCCIDX, SEQ) SELECT @UID , @CHAR_ITEM_ID , EQUIP_NUM = CAST(@EQUIP_NUM AS INT) , TYPEID = CAST(@TYPEID AS INT) , ITEMID = CAST(@ITEMID AS INT) , UCCIDX = @UCCIDX , SEQ = CAST(@SEQ AS INT) SET @INTLOOP = @INTLOOP + 1 END CREATE CLUSTERED INDEX CIDX_TD_CHAR ON #TD_CHAR (EQUIP_NUM) -- 캐릭터 장착 정보 UPDATE문 생성 => !!! AD-HOC 하나라도 더 줄이기!!! BEGIN TRY BEGIN TRAN UPDATE B SET parts_1 = CASE WHEN A.parts_1 > 0 THEN A.parts_1 ELSE 0 END , parts_2 = CASE WHEN A.parts_2 > 0 THEN A.parts_2 ELSE 0 END , parts_3 = CASE WHEN A.parts_3 > 0 THEN A.parts_3 ELSE 0 END , parts_4 = CASE WHEN A.parts_4 > 0 THEN A.parts_4 ELSE 0 END , parts_5 = CASE WHEN A.parts_5 > 0 THEN A.parts_5 ELSE 0 END , parts_6 = CASE WHEN A.parts_6 > 0 THEN A.parts_6 ELSE 0 END , parts_7 = CASE WHEN A.parts_7 > 0 THEN A.parts_7 ELSE 0 END , parts_8 = CASE WHEN A.parts_8 > 0 THEN A.parts_8 ELSE 0 END , parts_9 = CASE WHEN A.parts_9 > 0 THEN A.parts_9 ELSE 0 END , parts_10 = CASE WHEN A.parts_10 > 0 THEN A.parts_10 ELSE 0 END , parts_11 = CASE WHEN A.parts_11 > 0 THEN A.parts_11 ELSE 0 END , parts_12 = CASE WHEN A.parts_12 > 0 THEN A.parts_12 ELSE 0 END , parts_13 = CASE WHEN A.parts_13 > 0 THEN A.parts_13 ELSE 0 END , parts_14 = CASE WHEN A.parts_14 > 0 THEN A.parts_14 ELSE 0 END , parts_15 = CASE WHEN A.parts_15 > 0 THEN A.parts_15 ELSE 0 END , parts_16 = CASE WHEN A.parts_16 > 0 THEN A.parts_16 ELSE 0 END , parts_17 = CASE WHEN A.parts_17 > 0 THEN A.parts_17 ELSE 0 END , parts_18 = CASE WHEN A.parts_18 > 0 THEN A.parts_18 ELSE 0 END , parts_19 = CASE WHEN A.parts_19 > 0 THEN A.parts_19 ELSE 0 END , parts_20 = CASE WHEN A.parts_20 > 0 THEN A.parts_20 ELSE 0 END , parts_21 = CASE WHEN A.parts_21 > 0 THEN A.parts_21 ELSE 0 END , parts_22 = CASE WHEN A.parts_22 > 0 THEN A.parts_22 ELSE 0 END , parts_23 = CASE WHEN A.parts_23 > 0 THEN A.parts_23 ELSE 0 END , parts_24 = CASE WHEN A.parts_24 > 0 THEN A.parts_24 ELSE 0 END FROM ( SELECT UID , CHAR_ITEMID = MAX(CHAR_ITEMID) , parts_1 = MAX(CASE WHEN EQUIP_NUM = 1 THEN TYPEID ELSE 0 END) , parts_2 = MAX(CASE WHEN EQUIP_NUM = 2 THEN TYPEID ELSE 0 END) , parts_3 = MAX(CASE WHEN EQUIP_NUM = 3 THEN TYPEID ELSE 0 END) , parts_4 = MAX(CASE WHEN EQUIP_NUM = 4 THEN TYPEID ELSE 0 END) , parts_5 = MAX(CASE WHEN EQUIP_NUM = 5 THEN TYPEID ELSE 0 END) , parts_6 = MAX(CASE WHEN EQUIP_NUM = 6 THEN TYPEID ELSE 0 END) , parts_7 = MAX(CASE WHEN EQUIP_NUM = 7 THEN TYPEID ELSE 0 END) , parts_8 = MAX(CASE WHEN EQUIP_NUM = 8 THEN TYPEID ELSE 0 END) , parts_9 = MAX(CASE WHEN EQUIP_NUM = 9 THEN TYPEID ELSE 0 END) , parts_10 = MAX(CASE WHEN EQUIP_NUM = 10 THEN TYPEID ELSE 0 END) , parts_11 = MAX(CASE WHEN EQUIP_NUM = 11 THEN TYPEID ELSE 0 END) , parts_12 = MAX(CASE WHEN EQUIP_NUM = 12 THEN TYPEID ELSE 0 END) , parts_13 = MAX(CASE WHEN EQUIP_NUM = 13 THEN TYPEID ELSE 0 END) , parts_14 = MAX(CASE WHEN EQUIP_NUM = 14 THEN TYPEID ELSE 0 END) , parts_15 = MAX(CASE WHEN EQUIP_NUM = 15 THEN TYPEID ELSE 0 END) , parts_16 = MAX(CASE WHEN EQUIP_NUM = 16 THEN TYPEID ELSE 0 END) , parts_17 = MAX(CASE WHEN EQUIP_NUM = 17 THEN TYPEID ELSE 0 END) , parts_18 = MAX(CASE WHEN EQUIP_NUM = 18 THEN TYPEID ELSE 0 END) , parts_19 = MAX(CASE WHEN EQUIP_NUM = 19 THEN TYPEID ELSE 0 END) , parts_20 = MAX(CASE WHEN EQUIP_NUM = 20 THEN TYPEID ELSE 0 END) , parts_21 = MAX(CASE WHEN EQUIP_NUM = 21 THEN TYPEID ELSE 0 END) , parts_22 = MAX(CASE WHEN EQUIP_NUM = 22 THEN TYPEID ELSE 0 END) , parts_23 = MAX(CASE WHEN EQUIP_NUM = 23 THEN TYPEID ELSE 0 END) , parts_24 = MAX(CASE WHEN EQUIP_NUM = 24 THEN TYPEID ELSE 0 END) FROM #TD_CHAR GROUP BY UID ) A INNER JOIN ( SELECT * FROM pangya_character_information WITH (NOLOCK) WHERE UID = @UID AND ITEM_ID = @CHAR_ITEM_ID ) B ON A.UID = B.UID AND A.CHAR_ITEMID = B.ITEM_ID /***************************************** 카드 장착정보 ITEM 추가: SELECT * FROM TD_CARD_EQUIP 했다고 주석에 나와있지만 무슨소린지 아무도 모른다.. 뭘 어쨌다는건지.... 알게 되면 주석을 추가해 주세요 ㅡ.ㅡ ******************************************/ UPDATE DBO.TD_CHAR_EQUIP_S4 SET USE_YN = 'N' WHERE UID = @UID INSERT INTO DBO.TD_CHAR_EQUIP_S4 ( UID, CHAR_ITEMID, ITEMID, TYPEID, EQUIP_NUM, UCC_IDX, USE_YN ) SELECT @UID , @CHAR_ITEM_ID , CASE ITEMID WHEN 0 THEN 0 ELSE ITEMID END , TYPEID , B.EQUIP_NUM , UCCIDX , 'Y' FROM ( SELECT * FROM #TD_CHAR WHERE ITEMID IS NOT NULL ) B COMMIT TRAN SELECT [RET] = @@ERROR IF ( @DEBUG = 1 ) BEGIN SELECT * FROM #TD_CHAR END END TRY BEGIN CATCH ROLLBACK TRAN SELECT [RET] = 1 END CATCH END
Code:USE [Pangya_S4_TH] GO /****** Objet : StoredProcedure [dbo].[USP_CHAR_EQUIP_SAVE_S4] Date de génération du script : 12/04/2010 00:48:23 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE PROC [dbo].[USP_CHAR_EQUIP_SAVE_S4] ( @UID INT , @CHAR_ITEM_ID INT , @STR VARCHAR(8000) , @DEBUG TINYINT = 0 ) AS BEGIN -- '1^123456|2|3^1243^2214^1' -- @EQUIP_NUM^@TYPEID^@ITEMID^@UCCIDX^@SEQ| -- @EQUIP_NUM^@TYPEID^@ITEMID^@UCCIDX^@SEQ SET NOCOUNT ON DECLARE @RET INT SET @RET = 0 --INPUT 분석(1차 파싱 결과) IF OBJECT_ID('TEMPDB..#TD_SRC') IS NOT NULL DROP TABLE #TD_SRC CREATE TABLE #TD_SRC ( IDX SMALLINT IDENTITY(1,1) , DT VARCHAR(1000) ) --INPUT 분석(2차 파싱) 및 RESULT를 저장 IF OBJECT_ID('TEMPDB..#TD_CHAR') IS NOT NULL DROP TABLE #TD_CHAR CREATE TABLE #TD_CHAR ( IDX SMALLINT IDENTITY(1,1) , UID INT , CHAR_ITEMID INT , EQUIP_NUM INT -- 캐릭터 파트 번호 , TYPEID INT -- 아이템 , ITEMID INT -- ITEMID , UCCIDX VARCHAR(8) -- UCC인덱스 , SEQ SMALLINT -- UCC 시퀀스 ) DECLARE @SQL VARCHAR(8000) , @STR_SEP CHAR(1) , @INTLOOP INT SET @STR_SEP = '|' SET @SQL = '' SET @INTLOOP = 1 IF CHARINDEX('|', @STR) > 0 BEGIN SELECT @SQL= 'SELECT LTRIM(C) C FROM (SELECT ''' + REPLACE(CONT,@STR_SEP,''' C UNION ALL ' + CHAR(13) + 'SELECT ''') + ''') T' FROM ( SELECT CONT = @STR ) X END ELSE BEGIN SET @SQL = 'SELECT LTRIM(C) C FROM (SELECT ''' + @STR + ''' C) T' END INSERT INTO #TD_SRC (DT) EXEC(@SQL) DECLARE @EQUIP_NUM VARCHAR(20) , @TYPEID VARCHAR(20) , @ITEMID VARCHAR(20) , @UCCIDX VARCHAR(20) , @SEQ VARCHAR(20) WHILE EXISTS( SELECT 1 FROM #TD_SRC WHERE IDX = @INTLOOP ) BEGIN SELECT @SQL = REPLACE(DT, '^', ' ^') FROM #TD_SRC WHERE IDX = @INTLOOP EXEC MASTER..XP_SSCANF @SQL, '%s ^%s ^%s ^%s ^%s', @EQUIP_NUM OUTPUT, @TYPEID OUTPUT, @ITEMID OUTPUT, @UCCIDX OUTPUT, @SEQ OUTPUT INSERT INTO #TD_CHAR (UID, CHAR_ITEMID, EQUIP_NUM, TYPEID, ITEMID, UCCIDX, SEQ) SELECT @UID , @CHAR_ITEM_ID , EQUIP_NUM = CAST(@EQUIP_NUM AS INT) , TYPEID = CAST(@TYPEID AS INT) , ITEMID = CAST(@ITEMID AS INT) , UCCIDX = @UCCIDX , SEQ = CAST(@SEQ AS INT) SET @INTLOOP = @INTLOOP + 1 END CREATE CLUSTERED INDEX CIDX_TD_CHAR ON #TD_CHAR (EQUIP_NUM) -- 캐릭터 장착 정보 UPDATE문 생성 => !!! AD-HOC 하나라도 더 줄이기!!! BEGIN TRY BEGIN TRAN UPDATE B SET parts_1 = CASE WHEN A.parts_1 > 0 THEN A.parts_1 ELSE 0 END , parts_2 = CASE WHEN A.parts_2 > 0 THEN A.parts_2 ELSE 0 END , parts_3 = CASE WHEN A.parts_3 > 0 THEN A.parts_3 ELSE 0 END , parts_4 = CASE WHEN A.parts_4 > 0 THEN A.parts_4 ELSE 0 END , parts_5 = CASE WHEN A.parts_5 > 0 THEN A.parts_5 ELSE 0 END , parts_6 = CASE WHEN A.parts_6 > 0 THEN A.parts_6 ELSE 0 END , parts_7 = CASE WHEN A.parts_7 > 0 THEN A.parts_7 ELSE 0 END , parts_8 = CASE WHEN A.parts_8 > 0 THEN A.parts_8 ELSE 0 END , parts_9 = CASE WHEN A.parts_9 > 0 THEN A.parts_9 ELSE 0 END , parts_10 = CASE WHEN A.parts_10 > 0 THEN A.parts_10 ELSE 0 END , parts_11 = CASE WHEN A.parts_11 > 0 THEN A.parts_11 ELSE 0 END , parts_12 = CASE WHEN A.parts_12 > 0 THEN A.parts_12 ELSE 0 END , parts_13 = CASE WHEN A.parts_13 > 0 THEN A.parts_13 ELSE 0 END , parts_14 = CASE WHEN A.parts_14 > 0 THEN A.parts_14 ELSE 0 END , parts_15 = CASE WHEN A.parts_15 > 0 THEN A.parts_15 ELSE 0 END , parts_16 = CASE WHEN A.parts_16 > 0 THEN A.parts_16 ELSE 0 END , parts_17 = CASE WHEN A.parts_17 > 0 THEN A.parts_17 ELSE 0 END , parts_18 = CASE WHEN A.parts_18 > 0 THEN A.parts_18 ELSE 0 END , parts_19 = CASE WHEN A.parts_19 > 0 THEN A.parts_19 ELSE 0 END , parts_20 = CASE WHEN A.parts_20 > 0 THEN A.parts_20 ELSE 0 END , parts_21 = CASE WHEN A.parts_21 > 0 THEN A.parts_21 ELSE 0 END , parts_22 = CASE WHEN A.parts_22 > 0 THEN A.parts_22 ELSE 0 END , parts_23 = CASE WHEN A.parts_23 > 0 THEN A.parts_23 ELSE 0 END , parts_24 = CASE WHEN A.parts_24 > 0 THEN A.parts_24 ELSE 0 END FROM ( SELECT UID , CHAR_ITEMID = MAX(CHAR_ITEMID) , parts_1 = MAX(CASE WHEN EQUIP_NUM = 1 THEN TYPEID ELSE 0 END) , parts_2 = MAX(CASE WHEN EQUIP_NUM = 2 THEN TYPEID ELSE 0 END) , parts_3 = MAX(CASE WHEN EQUIP_NUM = 3 THEN TYPEID ELSE 0 END) , parts_4 = MAX(CASE WHEN EQUIP_NUM = 4 THEN TYPEID ELSE 0 END) , parts_5 = MAX(CASE WHEN EQUIP_NUM = 5 THEN TYPEID ELSE 0 END) , parts_6 = MAX(CASE WHEN EQUIP_NUM = 6 THEN TYPEID ELSE 0 END) , parts_7 = MAX(CASE WHEN EQUIP_NUM = 7 THEN TYPEID ELSE 0 END) , parts_8 = MAX(CASE WHEN EQUIP_NUM = 8 THEN TYPEID ELSE 0 END) , parts_9 = MAX(CASE WHEN EQUIP_NUM = 9 THEN TYPEID ELSE 0 END) , parts_10 = MAX(CASE WHEN EQUIP_NUM = 10 THEN TYPEID ELSE 0 END) , parts_11 = MAX(CASE WHEN EQUIP_NUM = 11 THEN TYPEID ELSE 0 END) , parts_12 = MAX(CASE WHEN EQUIP_NUM = 12 THEN TYPEID ELSE 0 END) , parts_13 = MAX(CASE WHEN EQUIP_NUM = 13 THEN TYPEID ELSE 0 END) , parts_14 = MAX(CASE WHEN EQUIP_NUM = 14 THEN TYPEID ELSE 0 END) , parts_15 = MAX(CASE WHEN EQUIP_NUM = 15 THEN TYPEID ELSE 0 END) , parts_16 = MAX(CASE WHEN EQUIP_NUM = 16 THEN TYPEID ELSE 0 END) , parts_17 = MAX(CASE WHEN EQUIP_NUM = 17 THEN TYPEID ELSE 0 END) , parts_18 = MAX(CASE WHEN EQUIP_NUM = 18 THEN TYPEID ELSE 0 END) , parts_19 = MAX(CASE WHEN EQUIP_NUM = 19 THEN TYPEID ELSE 0 END) , parts_20 = MAX(CASE WHEN EQUIP_NUM = 20 THEN TYPEID ELSE 0 END) , parts_21 = MAX(CASE WHEN EQUIP_NUM = 21 THEN TYPEID ELSE 0 END) , parts_22 = MAX(CASE WHEN EQUIP_NUM = 22 THEN TYPEID ELSE 0 END) , parts_23 = MAX(CASE WHEN EQUIP_NUM = 23 THEN TYPEID ELSE 0 END) , parts_24 = MAX(CASE WHEN EQUIP_NUM = 24 THEN TYPEID ELSE 0 END) FROM #TD_CHAR GROUP BY UID ) A INNER JOIN ( SELECT * FROM pangya_character_information WITH (NOLOCK) WHERE UID = @UID AND ITEM_ID = @CHAR_ITEM_ID ) B ON A.UID = B.UID AND A.CHAR_ITEMID = B.ITEM_ID /***************************************** 카드 장착정보 ITEM 추가: SELECT * FROM TD_CARD_EQUIP 했다고 주석에 나와있지만 무슨소린지 아무도 모른다.. 뭘 어쨌다는건지.... 알게 되면 주석을 추가해 주세요 ㅡ.ㅡ ******************************************/ UPDATE DBO.TD_CHAR_EQUIP_S4 SET USE_YN = 'N' WHERE UID = @UID INSERT INTO DBO.TD_CHAR_EQUIP_S4 ( UID, CHAR_ITEMID, ITEMID, TYPEID, EQUIP_NUM, UCC_IDX, USE_YN ) SELECT @UID , @CHAR_ITEM_ID , CASE ITEMID WHEN 0 THEN 0 ELSE ITEMID END , TYPEID , B.EQUIP_NUM , UCCIDX , 'Y' FROM ( SELECT * FROM #TD_CHAR WHERE ITEMID IS NOT NULL ) B COMMIT TRAN SELECT [RET] = @@ERROR IF ( @DEBUG = 1 ) BEGIN SELECT * FROM #TD_CHAR END END TRY BEGIN CATCH ROLLBACK TRAN SELECT [RET] = 1 END CATCH END
Thanks for the pointers.
Studying the log files helped me.
If you have created the file groups, don't forget to assign a file to them (or vice versa). Assigning the file to the specific groups solved my problem.
I've attached a file containing a list of the available ICONINDEX values. Values >= 10 will also cause the server to "disappear" from the server list as it seems...
Last edited by Tsukasa; 18-03-11 at 08:01 AM.
bubbastic and fasa2008 , could you please release full db with content in it or release full server that not empty DB
hello.
anyone find, how change rate exp,pang?
anyone find, how change rate exp,pang?
fasa2008
I think you can not create that feature in projectg, correct?
Sorry to disturb
I could not find where I can exchange the IP of ProjectG.exe to the program communicate with the Database server. Can anyone help me??????
@revo12 download fasa2008's ProjectG.exe
Talk to me on msn ... You've got my just do not know
---------- Post added at 03:46 AM ---------- Previous post was at 03:44 AM ----------
Use my Projectg.exe
I ty to add
Msg 208, Level 16, State 6, Procedure USP_CHAR_EQUIP_LOAD_S4, Line 13
Invalid object name 'dbo.USP_CHAR_EQUIP_LOAD_S4'.
Code:USE [Pangya_S4_TH] GO /****** Objet : StoredProcedure [dbo].[USP_CHAR_EQUIP_LOAD_S4] ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER PROC [dbo].[USP_CHAR_EQUIP_LOAD_S4] ( @UID INT ) AS BEGIN SET NOCOUNT ON IF ( @UID > 0 ) BEGIN SELECT X.ITEM_ID , TYPEID /* new */ , ITEMID_PARTS_1 , ITEMID_PARTS_2 , ITEMID_PARTS_3 , ITEMID_PARTS_4 , ITEMID_PARTS_5 , ITEMID_PARTS_6 , ITEMID_PARTS_7 , ITEMID_PARTS_8 , ITEMID_PARTS_9 , ITEMID_PARTS_10 , ITEMID_PARTS_11 , ITEMID_PARTS_12 , ITEMID_PARTS_13 , ITEMID_PARTS_14 , ITEMID_PARTS_15 , ITEMID_PARTS_16 , ITEMID_PARTS_17 , ITEMID_PARTS_18 , ITEMID_PARTS_19 , ITEMID_PARTS_20 , ITEMID_PARTS_21 , ITEMID_PARTS_22 , ITEMID_PARTS_23 , ITEMID_PARTS_24 /* new */ , PARTS_1 , PARTS_2 , PARTS_3 , PARTS_4 , PARTS_5 , PARTS_6 , PARTS_7 , PARTS_8 , PARTS_9 , PARTS_10 , PARTS_11 , PARTS_12 , PARTS_13 , PARTS_14 , PARTS_15 , PARTS_16 , PARTS_17 , PARTS_18 , PARTS_19 , PARTS_20 , PARTS_21 , PARTS_22 , PARTS_23 , PARTS_24 , AUXPARTS_1 , AUXPARTS_2 , AUXPARTS_3 , AUXPARTS_4 , AUXPARTS_5 , DEFAULT_HAIR , DEFAULT_SHIRTS , GIFT_FLAG , PCL0 , PCL1 , PCL2 , PCL3 , PCL4 , PURCHASE FROM ( SELECT ITEM_ID , TYPEID , PARTS_1 , PARTS_2 , PARTS_3 , PARTS_4 , PARTS_5 , PARTS_6 , PARTS_7 , PARTS_8 , PARTS_9 , PARTS_10 , PARTS_11 , PARTS_12 , PARTS_13 , PARTS_14 , PARTS_15 , PARTS_16 , PARTS_17 , PARTS_18 , PARTS_19 , PARTS_20 , PARTS_21 , PARTS_22 , PARTS_23 , PARTS_24 , AUXPARTS_1 , AUXPARTS_2 , AUXPARTS_3 , AUXPARTS_4 , AUXPARTS_5 , DEFAULT_HAIR , DEFAULT_SHIRTS , GIFT_FLAG , PCL0 , PCL1 , PCL2 , PCL3 , PCL4 , PURCHASE FROM DBO.PANGYA_CHARACTER_INFORMATION WITH (NOLOCK) WHERE UID = @UID ) X INNER JOIN ( SELECT ITEM_ID , ITEMID_PARTS_1 = MAX(CASE WHEN EQUIP_NUM = 1 THEN ITEMID ELSE 0 END) , ITEMID_PARTS_2 = MAX(CASE WHEN EQUIP_NUM = 2 THEN ITEMID ELSE 0 END) , ITEMID_PARTS_3 = MAX(CASE WHEN EQUIP_NUM = 3 THEN ITEMID ELSE 0 END) , ITEMID_PARTS_4 = MAX(CASE WHEN EQUIP_NUM = 4 THEN ITEMID ELSE 0 END) , ITEMID_PARTS_5 = MAX(CASE WHEN EQUIP_NUM = 5 THEN ITEMID ELSE 0 END) , ITEMID_PARTS_6 = MAX(CASE WHEN EQUIP_NUM = 6 THEN ITEMID ELSE 0 END) , ITEMID_PARTS_7 = MAX(CASE WHEN EQUIP_NUM = 7 THEN ITEMID ELSE 0 END) , ITEMID_PARTS_8 = MAX(CASE WHEN EQUIP_NUM = 8 THEN ITEMID ELSE 0 END) , ITEMID_PARTS_9 = MAX(CASE WHEN EQUIP_NUM = 9 THEN ITEMID ELSE 0 END) , ITEMID_PARTS_10 = MAX(CASE WHEN EQUIP_NUM = 10 THEN ITEMID ELSE 0 END) , ITEMID_PARTS_11 = MAX(CASE WHEN EQUIP_NUM = 11 THEN ITEMID ELSE 0 END) , ITEMID_PARTS_12 = MAX(CASE WHEN EQUIP_NUM = 12 THEN ITEMID ELSE 0 END) , ITEMID_PARTS_13 = MAX(CASE WHEN EQUIP_NUM = 13 THEN ITEMID ELSE 0 END) , ITEMID_PARTS_14 = MAX(CASE WHEN EQUIP_NUM = 14 THEN ITEMID ELSE 0 END) , ITEMID_PARTS_15 = MAX(CASE WHEN EQUIP_NUM = 15 THEN ITEMID ELSE 0 END) , ITEMID_PARTS_16 = MAX(CASE WHEN EQUIP_NUM = 16 THEN ITEMID ELSE 0 END) , ITEMID_PARTS_17 = MAX(CASE WHEN EQUIP_NUM = 17 THEN ITEMID ELSE 0 END) , ITEMID_PARTS_18 = MAX(CASE WHEN EQUIP_NUM = 18 THEN ITEMID ELSE 0 END) , ITEMID_PARTS_19 = MAX(CASE WHEN EQUIP_NUM = 19 THEN ITEMID ELSE 0 END) , ITEMID_PARTS_20 = MAX(CASE WHEN EQUIP_NUM = 20 THEN ITEMID ELSE 0 END) , ITEMID_PARTS_21 = MAX(CASE WHEN EQUIP_NUM = 21 THEN ITEMID ELSE 0 END) , ITEMID_PARTS_22 = MAX(CASE WHEN EQUIP_NUM = 22 THEN ITEMID ELSE 0 END) , ITEMID_PARTS_23 = MAX(CASE WHEN EQUIP_NUM = 23 THEN ITEMID ELSE 0 END) , ITEMID_PARTS_24 = MAX(CASE WHEN EQUIP_NUM = 24 THEN ITEMID ELSE 0 END) FROM ( SELECT ITEM_ID , TYPEID , PARTS_1 , PARTS_2 , PARTS_3 , PARTS_4 , PARTS_5 , PARTS_6 , PARTS_7 , PARTS_8 , PARTS_9 , PARTS_10 , PARTS_11 , PARTS_12 , PARTS_13 , PARTS_14 , PARTS_15 , PARTS_16 , PARTS_17 , PARTS_18 , PARTS_19 , PARTS_20 , PARTS_21 , PARTS_22 , PARTS_23 , PARTS_24 FROM DBO.PANGYA_CHARACTER_INFORMATION WITH (NOLOCK) WHERE UID = @UID ) A LEFT OUTER JOIN ( SELECT CHAR_ITEMID, ITEMID, TYPEID, EQUIP_NUM FROM TD_CHAR_EQUIP_S4 WITH (NOLOCK) WHERE UID = @UID --AND ITEMID > 0 AND USE_YN = 'Y' ) B ON A.ITEM_ID = B.CHAR_ITEMID GROUP BY ITEM_ID ) Y ON X.ITEM_ID = Y.ITEM_ID END END
fasa2008
How to create file group?
another doubt, how to make accs in database in MS SQL 2005? I remember a little of the pangya s1 but this db is a little different ^^
Solved.
Now I just want to know how I add cookies/pangs in my acc? And what I have to do to my account be GameMaster Account?? TYvm!
Last edited by revo12; 04-12-10 at 07:29 AM. Reason: solved
Thanks! this helped. But i can't seem to find anything in the logs @___@ might take me some time. what specific files does it need?
