Pangya Season 4.9 Server Files and Database

[wellan17]

there is already a fix for the error of friends?
and cards
design and self?
how to make new account comes with 100 items of exp?
someone can tell if some event work? what if it works and where to set it up?
Excuse the many questions

 

[chiosin2]

@outlawzzbr look at your logs.. you might be missing some stored procedure. Don't panic.. its all here.. it might be EQUIP_LOAD_S4 or something like that..

@Tsukasa here's the pic for the clubset.iff

@fasa2008 Thanks for the tips!

 

[Tsukasa]

Yes my friend always the beginning of the code. IFF tells us how many items are added within the file ... usually the first 2 values ...
Ex: In my case I have 480 items Part.IFF of it in HEX think that's>>> 52 11.
If I have not seen the picture show me where is your doubt ... and I tell you ... xD

Thanks a lot for your time .
I've attached an image with the values in question. They are not set for every item, so my best guess is that they might alter effects.

@chiosin2: Yeah thanks, I'll work on the clubs as soon as I'm done with Part.iff and fixed all outstanding issues.

@wellan17: Yes, there is a fix for friends, you need to add the missing stored procedure. Cards - dunno. Self-design requires you to have a webservice to host and retrieve images - so nope, does not work yet. If you want to increase the game rank (like Rookie F or Beginner C) simply edit the game_rank value in Pangya_User_Statistics.

 

[outlawzzbr]

Heelp

PLEASE - Can someone take a look at my logs? Here is the latest :

You must be registered to see links

:*:

 

[chiosin2]

@outlawzzbr just post it.. i won't take the time to download it.

 

[outlawzzbr]

@outlawzzbr just post it.. i won't take the time to download it.

The problem is here:

dbo.USP_CHAR_EQUIP_LOAD_S4

Somebody help me ?

 

[chiosin2]

@outlawzzbr
Like i said re-run the CHAR_EQUIP_LOAD_S4 <<-- Create that stored procedure.. it should be okay then.

 

[outlawzzbr]

@chiosin2

PLEASE - Pass me the query to create the stored procedure (dbo.USP_CHAR_EQUIP_LOAD_S4)

 

[chiosin2]

Here ya go.

Credit: bubbastic

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

 

[outlawzzbr]

It worked

VERY VERY VERY VERY Thanks!!

------

I have two doubts :

1° How do I add new items ?
2° How to solve this :

OBS: It happens when opening the packs!

 

[mikumiku]

So I went for another run-through of this thread to see if I could get an at-least partially working server (All I want is a working Item Shop, MyRoom, and PSQ, nothing more). I have no idea what I'm missing. I successfully made an account, but I can't even login with it. But for some reason, when I close the loginserver window, a message in Thai pops up in the Pangya window, and then I get to the server list... which is empty. No idea how to add a server.
Another note, the gameserver isn't working either. Why is there more than one? Which one am I supposed to use? When I try to run any of them, I get:

XXXX-XX-XX XX:XX:XX     0 Log Create Failed
XXXX-XX-XX XX:XX:XX     LogSystem Create Failed
XXXX-XX-XX XX:XX:XX     Server Start Have Some Problem

 

[outlawzzbr]

So I went for another run-through of this thread to see if I could get an at-least partially working server (All I want is a working Item Shop, MyRoom, and PSQ, nothing more). I have no idea what I'm missing. I successfully made an account, but I can't even login with it. But for some reason, when I close the loginserver window, a message in Thai pops up in the Pangya window, and then I get to the server list... which is empty. No idea how to add a server.
Another note, the gameserver isn't working either. Why is there more than one? Which one am I supposed to use? When I try to run any of them, I get:

XXXX-XX-XX XX:XX:XX     0 Log Create Failed
XXXX-XX-XX XX:XX:XX     LogSystem Create Failed
XXXX-XX-XX XX:XX:XX     Server Start Have Some Problem

rename the folder PANGYA_SRV for PANGYA_TEST

 

[chiosin2]

LOL no that's not it.

open your server.ini in game server and edit

Log=(change to where you put your gameserver log folder is)

 

[luizhill]

Can someone help me. I can not connect the channel

 

[outlawzzbr]

Can someone help me. I can not connect the channel

You have to create three ODBC (ini3_py_account, INI3Bill_DB and Pangya_S4_TH

Control Panel > Administrative Tools > Data Sources (ODBC)

In the window that opened click System DSN > ADD

Go down the list until the option "SQL Server" and click "Finish".

In the opened window fill in the fields as follows:

Name: ini3_py_account
Description: Leave blank
Server: Enter your internal IP (127.0.0.1) or your external IP.

Click NEXT

In the next part, make sure that the options are satisfied as shown in picture below.

You must be registered to see links

Click NEXT

Click "Change the default database to" then click the down arrow to open a list and choose "ini3_py_account."

Click NEXT and then "Finish".

Open a window, you can click OK.

Now repeat everything in the DBs INI3Bill_DB and Pangya_S4_TH

credits: casadostutoriais

 

[gigok]

Still cant see the CHANNEL LIST? How to fix it

 

[mikumiku]

You have to create three ODBC (ini3_py_account, INI3Bill_DB and Pangya_S4_TH

Control Panel > Administrative Tools > Data Sources (ODBC)

In the window that opened click System DSN > ADD

Go down the list until the option "SQL Server" and click "Finish".

In the opened window fill in the fields as follows:

Name: ini3_py_account
Description: Leave blank
Server: Enter your internal IP (127.0.0.1) or your external IP.

Click NEXT

In the next part, make sure that the options are satisfied as shown in picture below.

You must be registered to see links

Click NEXT

Click "Change the default database to" then click the down arrow to open a list and choose "ini3_py_account."

Click NEXT and then "Finish".

Open a window, you can click OK.

Now repeat everything in the DBs INI3Bill_DB and Pangya_S4_TH

credits: casadostutoriais

I'm not the same person who you told to do this, but I get this error when I reach the part that I bolded and underlined in the quote.

P.S. Still don't know how to add servers/channels to the list.

 

[G0dzilla2000]

Hey, Ive been reading through this form for a while now downloading and preparing all the files, but I don't think i set up my SQL database right, can anyone give me a little direction on setting it up?

Also i am having the same error as mikumiku


EDIT: also when i try to Patch the files from 580.05 to 582.04 it loads the launcher and starts to install 582.06, is this ok? or should i not update it to that client

 

[fasa2008]

You have to create three ODBC (ini3_py_account, INI3Bill_DB and Pangya_S4_TH

Control Panel > Administrative Tools > Data Sources (ODBC)

In the window that opened click System DSN > ADD

Go down the list until the option "SQL Server" and click "Finish".

In the opened window fill in the fields as follows:

Name: ini3_py_account
Description: Leave blank
Server: Enter your internal IP (127.0.0.1) or your external IP.

Click NEXT

In the next part, make sure that the options are satisfied as shown in picture below.

You must be registered to see links

Click NEXT

Click "Change the default database to" then click the down arrow to open a list and choose "ini3_py_account."

Click NEXT and then "Finish".

Open a window, you can click OK.

Now repeat everything in the DBs INI3Bill_DB and Pangya_S4_TH

credits: casadostutoriais

Sql Native Client >>> Emu <<< Newbie.

 

[GroGro]

I was screwed over by both Pangya GG and Pangya Ntreev and I would like to make a private server but, Wow. This looks really hard, I have read every page twice over and still have no idea where to start if anyone could give me their MSN to talk me over it with I would be extremely grateful.