Pangya Season 4.9 Server Files and Database

**Noobya** · 18-12-10

Hey Guys can someone help me solve this problem

http://img3.fotos-hochladen.net/uplo...lgjs2bnkcr.jpg

I can log in i see the server but i cant see any channels would be great if someone can help me pls.

No one got a clue?

I have asked for help cause i dont know what to do now sure i saw the faults in the log but thats all i only saw them but cant fix it i read all these threads here 5-10 times and this problem others had before too but no one posted a fix.

All i am asking for is a lil help to solve this problem.

**bubbastic** · 18-12-10

As a lot of you asked how to set a GM account here is the answer :
in Pangya_member_info table, just put 4 in capability and there you are a GM o.O.
It was not difficult eh?

Now search by yourself on how to add the title XD

**outlawzzbr** · 18-12-10

Where do I download the file ClubSet.iff?

How do i add Clubset and balls ?

**o800920** · 18-12-10

Originally Posted by outlawzzbr

Where do I download the file ClubSet.iff?

How do i add Clubset and balls ?

open the pangya_th.iff and you will get it

Originally Posted by bubbastic

As a lot of you asked how to set a GM account here is the answer :
in Pangya_member_info table, just put 4 in capability and there you are a GM o.O.
It was not difficult eh?

Now search by yourself on how to add the title XD

@bubbastic

thanks you very much

**mikumiku** · 18-12-10

I found out yesterday that the USP_CHAR_EQUIP_SAVE_S4 procedure was a little incomplete. When it checks for clothing that's equipped, it only checks the UID, and ignores the CHAR_ITEMID, meaning if you have multiple characters that are dressed up on one account, it will only save equipment for one character.

Here's the query fix:

Spoiler:

Code:

USE [Pangya_S4_TH]
GO

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go


	ALTER 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
		AND		CHAR_ITEMID = @CHAR_ITEM_ID

		 
		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

**o800920** · 18-12-10

Originally Posted by mikumiku

Here's the query fix:

Spoiler:

Code:

USE [Pangya_S4_TH]
GO

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go


	ALTER 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
		AND		CHAR_ITEMID = @CHAR_ITEM_ID

		 
		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

Good work !! thank alot

**Mouquette** · 18-12-10

Originally Posted by fasa2008

Hello All !

* ProjectG 583.00
* Unpacked
* IP: 127.0.0.1 ~hohoho
* Game Guard Removed
* Loader's Game Guard Removed
* ProjectG Multi-Client
* Exclusive RageZone
* New Features
* No Erro's
* More Support Paks

Credits: Fasa2008 <<<
Download

Is it work only for 583.00 ? or it work with older version too ?

**outlawzzbr** · 18-12-10

Originally Posted by o800920

open the pangya_th.iff and you will get it

I did not understand what I have to do in pangya_th.iff?

**o800920** · 18-12-10

Originally Posted by outlawzzbr

I did not understand what I have to do in pangya_th.iff?

open it use rar and you will get it

**outlawzzbr** · 18-12-10

Originally Posted by o800920

open it use rar and you will get it

I Got It, Thanks.

@EDIT : After I extract the ClubSet.iff What do I do?

**G0dzilla2000** · 18-12-10

Originally Posted by mikumiku

This actually happened to me once, but I don't think your case is the same. Are you sure sqlservr.exe is running? I remember needing to turn it off once, then I forgot to turn it back on.

Of course, I'm 99% sure that isn't the problem. A quick google search of that error code will help you, though.

Do i need to set it one somwhere? cause i noticed it is indeed not running, but when i try and use the RUN command it comes up with this error http://i94.photobucket.com/albums/l9...g?t=1292697141

Found out i have 2 sqlservr.exe's and i think that last one was from my old server, when i run the new one i get this error

http://i94.photobucket.com/albums/l9...006/error2.jpg

**mikumiku** · 18-12-10

Originally Posted by G0dzilla2000

Do i need to set it one somwhere? cause i noticed it is indeed not running, but when i try and use the RUN command it comes up with this error http://i94.photobucket.com/albums/l9...g?t=1292697141

Run the SQL Server Configuration Manager; you can control what SQL services are running from there. If for some reason it doesn't work, reboot your computer, and use the config manager to turn off the server from now on if you ever want to.

**G0dzilla2000** · 18-12-10

Originally Posted by mikumiku

Run the SQL Server Configuration Manager; you can control what SQL services are running from there. If for some reason it doesn't work, reboot your computer, and use the config manager to turn off the server from now on if you ever want to.

Well the config manager says everythings running but the sql server Browser and sql server agent, so idk if those are the issue, but im confused on why i can access the databases with Pangya, but not ms sql. and ive restarted my comp several times now with no results

**mikumiku** · 18-12-10

Originally Posted by G0dzilla2000

Well the config manager says everythings running but the sql server Browser and sql server agent, so idk if those are the issue, but im confused on why i can access the databases with Pangya, but not ms sql. and ive restarted my comp several times now with no results

This is where Google is your friend. Search for the error code you posted, and look around for answers.

**G0dzilla2000** · 18-12-10

Originally Posted by mikumiku

This is where Google is your friend. Search for the error code you posted, and look around for answers.

Fixed, turns out it was trying to connect to my router IP and not my local IP so i had to change the Alias of my local IP back to the alias name and now it works >.<

Pangya Season 4.9 Server Files and Database

Thread Tools

Re: Pangya Season 4.9 Server Files and Database

GM Account

Re: Pangya Season 4.9 Server Files and Database

Re: Pangya Season 4.9 Server Files and Database

Re: Pangya Season 4.9 Server Files and Database

Re: Pangya Season 4.9 Server Files and Database

Re: Pangya Season 4.9 Server Files and Database

Re: Pangya Season 4.9 Server Files and Database

Re: Pangya Season 4.9 Server Files and Database

Re: Pangya Season 4.9 Server Files and Database

Re: Pangya Season 4.9 Server Files and Database

Re: Pangya Season 4.9 Server Files and Database

Re: Pangya Season 4.9 Server Files and Database

Re: Pangya Season 4.9 Server Files and Database

Re: Pangya Season 4.9 Server Files and Database

Advertisement