Pangya Season 4.9 Server Files and Database

[gigok]

SO its useless to share this pangya server. OMG....

 

[darkknight]

not imposible to complet server

 

[chiosin2]

for the .dat files i just used the files from ntreev, and changed some things in projectG_TH_NO_GG thanks fasa2008.

I Used Monk666's database for Pangya.. thats it.. download his DB

@darkknight i used the code but nothing works
i get this
Msg 208, Level 16, State 6, Procedure USP_NICKNAME_UPDATE, Line 10
Invalid object name 'dbo.USP_NICKNAME_UPDATE'.

 

[bubbastic]

for the .dat files i just used the files from ntreev, and changed some things in projectG_TH_NO_GG thanks fasa2008.

I Used Monk666's database for Pangya.. thats it.. download his DB

@darkknight i used the code but nothing works
i get this
Msg 208, Level 16, State 6, Procedure USP_NICKNAME_UPDATE, Line 10
Invalid object name 'dbo.USP_NICKNAME_UPDATE'.

try this in a query window:

USE [Pangya_S4_TH]
GO

DECLARE @return_value int

EXEC @return_value = [dbo].[USP_NICKNAME_UPDATE]
@UID = YOURIDHERE,
@NEWNICKNAME = N'YOUR NICKNAME HERE',
@GM = 1

SELECT 'Return Value' = @return_value

GO

-----
What did you change in projectg to get english language ?

 

[Tsukasa]

To patch the game to English (at least partially) replace the files from the game's directory (make sure it's updated to the version from my initial post on page 1!) with these files:

You must be registered to see links

These files come straight from ntreev USA's (now SG Entertainment...) client. Since item descriptions are contained within the *.pak files we need to do some unpacking/editing later on... after getting the server to work

--

Just for your convenience: To alter the stored procedure it has to be created first.

Here's a full, somewhat working version of darkknight's query:

USE [Pangya_S4_TH]
GO

/****** Object:  StoredProcedure [dbo].[USP_NICKNAME_UPDATE]    Script Date: 11/30/2010 19:44:43 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

 CREATE PROCEDURE [dbo].[USP_NICKNAME_UPDATE]
@x int,
@y varchar(20)
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;

select 0
END
GO

You can also copy the ProcUpdateNickname procedure (which this one seems to base on), it does the same but can also report back errors.

 

[sandro_adm]

Unfortunately I am having problems in choosing the channel.
caught at this stage

 

[bubbastic]

To patch the game to English (at least partially) replace the files from the game's directory (make sure it's updated to the version from my initial post on page 1!) with these files:

You must be registered to see links

These files come straight from ntreev USA's (now SG Entertainment...) client. Since item descriptions are contained within the *.pak files we need to do some unpacking/editing later on... after getting the server to work

Thank you for that

I wish I could do that myself but I did not found any updated tutorial

 

[chiosin2]

you need pangya unpaker. tools are already provided here. so the only thing needed is your time.

 

[darkknight]

Some body can create new StoredProcedure it missing when select Channel server

USP_TUTORIAL_GET_STATUS
USP_CARD_GET_LIST
USP_CHAR_EQUIP_LOAD_S4

 

[sandro_adm]

Had this occurred,
prucedures unfortunately these are only possible to try to win them a complete Db.

Otherwise someone could tell me where or help me?

 

[gigok]

Need ProjectG.exe with IP 127.0.0.1. I always fail to unpack it....

 

[bubbastic]

Missing parts

USE [Pangya_S4_TH]
GO
/******  StoredProcedure [dbo].[USP_TUTORIAL_GET_STATUS]  ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER PROCEDURE [dbo].[USP_TUTORIAL_GET_STATUS] (  
	@UID	INT
) AS  

BEGIN  
  
SET NOCOUNT ON  

	SELECT	 A.USER_LEVEL  
			,[QUEST] = SUM(A.STEP)  
	FROM	DBO.TA_TUTORIAL_ACC A  WITH (NOLOCK)
			INNER JOIN  
			(
				SELECT	SEQ  
				FROM	DBO.TD_TUTORIAL WITH (NOLOCK)   
				WHERE	UID = @UID  
				GROUP BY SEQ 
			) B  
	ON		A.SEQ = B.SEQ  
	GROUP BY A.USER_LEVEL
	
END

 

[sandro_adm]

great,
Very good friend, had to make a small correction in the code, but nothing
beyond what has already been mentioned by you.

Thanks anyway ...
now I'm looking for the other two procedure


Edit:
I obtained an advance in the choice of channel, but still can not choose it. Lock in a way that does not allow me to continue =)

believe this is the path. =)

 

[Tsukasa]

Need ProjectG.exe with IP 127.0.0.1. I always fail to unpack it....

See this link for an already modified client. It requires the client version 582.04 or higher. If you get errors about nonexistent functions right when starting the client, you need to run the updater.

 

[fasa2008]

comands Gm season 4~

/giveitem [nick][typeid][num]
/notice [msg]
/identity [type]
/weather [type] 'fine', 'rain', 'snow', 'cloud'
/wind [spd][dir]
/destroy [num]
/disconnect [nick]
/kick [nick][op]
/close [nick]
/list
/channel [on/off]
/whisper [on/off]
/status
/command
/help [cmd]

 

[softnet]

where down the server pangya season 4?

 

[suneka]

Can someone help me change the exp rate and pang?

How do you define a GM?

 

[bubbastic]

Can someone help me change the exp rate and pang?

How do you define a GM?

Does that mean you have a working version ?

 

[chiosin2]

great job bubbastic! thanks for that. i have a question.. will the client run even if the client is not included in the registry?

 

[bubbastic]

Found a new missing part

USE [Pangya_S4_TH]
GO
/****** StoredProcedure [dbo].[USP_CARD_LIST] ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER PROC [dbo].[USP_CARD_LIST] (  
        @UID    INT  
)
AS  

BEGIN  

    SET NOCOUNT ON  
  
    SELECT    UID  
              , CARD_TYPEID  
              , CARD_ITEMID  
              , CARD_TYPE  
              , QTY
              , IS_USE_DT = 0
    FROM    DBO.TD_CARD_USRS WITH (NOLOCK)  
    WHERE    UID =  @UID   
    AND        USE_YN = 'Y'
    
   
END

Please share a tutorial to patch projectg and remove GG and update thx