Pangya Season 4.9 Server Files and Database

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

not imposible to complet server

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'.

Quote:

---

Originally Posted by 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'.

---

try this in a query window:

Quote:

---

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 ?

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:

Engrish Pangya

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:

Code:

---

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.

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

Quote:

---

Originally Posted by 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:

Engrish Pangya

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

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

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

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?

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

Code:

---

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

---

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. =)

Quote:

---

Originally Posted by gigok

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.

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]