Pangya Season 4.9 Server Files and Database

Can someone help me with this error ?

http://img577.imageshack.us/img577/4855/erro1d.png

Quote:

---

Originally Posted by jhonzinbr123

i finally finished my tool.
heres a SQL script for all shop items,
just run it on sql and have fun :)

---

What change do you exist when the value of ISCASH, TYPE, and IS_SALABLE is changed?

uwaaaa~~~ That's Cool guy I have waiting for this

Quote:

---

Originally Posted by o800920

use USP_NICKNAME_UPDATE :thumbup1:

---

already moved all in: USP_NICKNAME_UPDATE .. and still the same problem ..
what should I change here ?????? help please:?:

bourne user query

USE [Pangya_S4_TH]
GO
/****** Object: StoredProcedure [dbo].[USP_NICKNAME_UPDATE] Script Date: 11/29/2010 18:42:13 ******/
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

Quote:

---

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. :*:

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?

http://img194.imageshack.us/img194/7...ngya127.th.jpg

Now search by yourself on how to add the title XD

Where do I download the file ClubSet.iff?

How do i add Clubset and balls ?

Quote:

---

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

Quote:

---

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?

http://img194.imageshack.us/img194/7...ngya127.th.jpg

Now search by yourself on how to add the title XD

---

@bubbastic

thanks you very much

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

---

Quote:

---

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 :thumbup1:

Quote:

---

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 ?

Quote:

---

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?

Quote:

---

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

Quote:

---

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?

Quote:

---

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

Quote:

---

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.

Quote:

---

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

Quote:

---

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.

Quote:

---

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

Quote:

---

Originally Posted by josiel

bourne user query

USE [Pangya_S4_TH]
GO
/****** Object: StoredProcedure [dbo].[USP_NICKNAME_UPDATE] Script Date: 11/29/2010 18:42:13 ******/
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

---

I still have the same problem ....:grr:

I extract the pangya_Th in the folder login and gameserver most no appears nothing in the shop ... HELP PLEASE.

Finally managed to figure out exactly what to do when editing the shop. If I'm wrong anywhere, I hope someone who has already done this properly will tell me what needs to be changed.

Here's my tutorial on Item Shop editing:

1. What you need: WinRAR, A hex editing program, and a Pangya PAK unpacker/repacker. I will NOT tell you where to find these. Just do a Google search to find them.
2. Using a Pangya .pak unpacking program, unpack the most recent PAK file in the PangyaTH game folder.
   IN CASE YOU MAKE ANY MISTAKES, MAKE A BACKUP OF THE PAK FILE BEFORE CHANGING IT.
3. In the 'data' folder that was extracted, look for pangya_th.iff. Change the file extension from .iff to .zip. Ignore the warning and hit Yes.
4. You will see that there are a bunch of smaller IFF files in the IFF you changed. Extract the ZIP with WinRAR.
5. Use a hex editor to edit the appropriate values in the appropriate extracted IFF files. Don't forget to save your progress.
   Which ones you have to change and how to edit them were explained earlier in the thread. DO NOT ASK ME.
6. When you're done editing, repack all of the files with WinRAR into another ZIP called pangya_th.
7. Change the file extension from .zip to .iff. Again, ignore the warning and hit Yes.
8. Overwrite the old pangya_th.iff in the 'data' folder with the new one.
9. Make a copy of the pangya_th.iff outside of the 'data' folder.
10. Repack the data folder into a PAK file.
11. Rename the new PAK to the PAK file that you originally unpacked.
12. Replace the old PAK file in the PangyaTH game folder with your new PAK.
13. Go into the PANGYA_SRV>Login folder and replace the pangya_th.iff there with the new one.
14. Repeat #13 for the Py_GameServer#01 folder.

And that should be it. If there are any errors in my tutorial, please let me know ASAP.

EDIT: Thank you for the tips, Tsukasa. Tutorial edited.

1.) It's a zip file, not a rar file. That's important for the later packing process
2.) You should always repack the latest pak, not some very old one.
3.) You should always use the latest pangya_th.iff from the latest pak you can fine. It contains additional items.

as changes in wind gm?

I try to put /wind 1

or /wind 1 1

does not change more ...

Can someone help?

@Tsukasa
@mikumiku

Very Thanks! :thumbup1:

Quote:

---

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?

http://img194.imageshack.us/img194/7...ngya127.th.jpg

Now search by yourself on how to add the title XD

---

Thx Very Much :love:

@all
any1 know how solve ticker?
i have some ploblem
see
http://img232.imageshack.us/img232/9125/pangya001n.jpg

If not Asking Too Much, Can someone share your edited pangya_th.iff ? :*:

PLEASE

TH Items don't have most items we like in the US/EU/JP/KR clients ^^' so you have to make your own pak files ^^ or just make use of your whatever resources and add it yourself ^^

Hm... I don't know where I went wrong.

I copied all of the TH PAK files to a separate folder to unpack them. I unpacked each PAK file to look for textures that I wanted to edit. When I reached projectg583th.pak, I edited the IFF file in there. After editing it, I copied it over to the login and game server folders, then repacked 583. Tried to start the game, but it crashed before it even reached the login screen. Then some gibberish error appeared in the login server window, and there was beeping.

Did I screw up the IFF? Or perhaps the repacking process?

i need interface in english? Anyone have the files for clien side?

Okay, I figured out what the problem was. Something went wrong with the repacking, but I don't know if it's the repacker or the method that I'm using to repack. The beeping and gibberish coming from the login server was because I had SQL Server off. -_-

EDIT: Yeah, I'm an idiot. I didn't know the repacker was supposed to close on its own. I kept closing the EXE before it finalized the packing.

---------- Post added at 11:53 PM ---------- Previous post was at 10:42 PM ----------

Okay, this isn't good. After I edited the PAK files, I ran my game. Everything was running smoothly. Even my Nell problem was fixed.

...

But I can't make rooms again. I checked the server version through the PangyaTH updater, and it's still at 583.01. No changes were made to my ProjectG EXE or the Pangya_Server_Config table (i.e. they both say 583.01). Now what's wrong?

EDIT: I replaced the edited PAK files with the orignal ones, and I'm still getting the room error. That means the version number changed, even though it still says 583.01. I have no idea how to check what it actually is, though.

EDIT2: Okay, it seems to have fixed itself. But for some reason, I'm not allowed to use certain courses.

• Courses that work: Eastern Valley, West Wiz, Wiz Wiz, Ice Spa, Deep Inferno, and Shining Sand
• Courses that don't work: all Blue courses, all Wind courses, Lost Seaway, Ice Cannon, White Wiz, and Silvia Cannon

Whenever I try to use any of the courses I listed as not working, my game crashes. All I see in the logs is "CODE: 0 ERROR REPORTED: Exception", and nothing else. What does this mean?

Sorry for my first question in this board.

I open progectg_private_FINAL.exe

BUT

PLEASE LOOK THIS PICTURE!

It mean no file from server,but I opened server.

PS.THIS picture isn't my picture but when I open server it have some problem!
PS2.I live in thailand.

:?:

anyone know solve problem with ticker?
i send 1 message ,ex : Welcome.
but dont show the menssage correct , just <> :s

i have a fair client english translated. around 600-700mb(compressed) i deleted some of the pak files that don't really mean anything.. compressed most of it and i got it to work easily.

Note: you don't have to replace all of the textures you can simple make a new pak file name it ProjectG583tha.pak or what ever letter you want. then use the ui folder and add what ever it is that's english there ^^ and there you go. but if you really want to be sure just check the other folders to know which file goes where ^^

Quote:

---

Originally Posted by gorn3029

Sorry for my first question in this board.

I open progectg_private_FINAL.exe

BUT

PLEASE LOOK THIS PICTURE!

It mean no file from server,but I opened server.

PS.THIS picture isn't my picture but when I open server it have some problem!
PS2.I live in thailand.

:?:

---

Use my projectG. What are you using in this image is not mine ... xD

Hello ..

Cards I've added manually, but not for the team on clothes

ImageShack&#174; - Online Photo and Video Hosting
Imageshack - pangya275.jpg
ImageShack&#174; - Online Photo and Video Hosting

could someone help?

I don't even know what's going on with my client anymore.

My edited PAK files are the reason why certain courses crash the game.
But if I DON'T use the edited PAKs, I can't make any rooms.

I have used some fixes from tsukasa and bubbastic
a nickname for them and save and load character and some others.
more when I change my nick, Ex : loginid: "swdl" for Nickname "swedlow" and when relog, my old nick back = my loginid "swdl"

Anyone know how I fix it?

Quote:

---

Originally Posted by mikumiku

I don't even know what's going on with my client anymore.

My edited PAK files are the reason why certain courses crash the game.
But if I DON'T use the edited PAKs, I can't make any rooms.

---

If your installation is correct, yuo should be able to play without changing any pak. If not, there are some problems in your procedures.

Paks add/replace content in game. So original paks won't make the game crash. You should try to fix your server before editing pak files. When it works fine with original paks, add yours ;)

BTW great work on CHAR EQUIP (just nell is still undressed and rings) :thumbup1:

Quote:

---

Originally Posted by bubbastic

If your installation is correct, yuo should be able to play without changing any pak. If not, there are some problems in your procedures.

Paks add/replace content in game. So original paks won't make the game crash. You should try to fix your server before editing pak files. When it works fine with original paks, add yours ;)

BTW great work on CHAR EQUIP (just nell is still undressed and rings) :thumbup1:

---

My edited PAKs crashed the game, though, not the originals. And the original PAKs don't allow me to make rooms, as if I'm having the 'update your server' problem (though I'm not completely sure, since my client isn't translated). And again, I checked PangyaTH version number, compared it with the EXE and server_config table, and they're the same version.

And about Nell, you need to replace the pangya_th.iff files in the login and game server folders with the newest IFF in the latest PAK file. The default ones in the server folders are outdated, it seems. Dunno about rings, though.

1. I can only see a few item in my shop. and where can i buy new character? Do I need to use the latest pangya_th.iff of my game pak to put in my gameserver? I'm noob at this game ^-^

2. How to change my level to highest (Legend). I can't buy alot item caz i'm only Rookie

3. and can someone gimme the Pangya unpaker? I can't find it.

Quote:

---

Originally Posted by mikumiku

My editedI checked PangyaTH version number, compared it with the EXE and server_config table, and they're the same version.

---

If you havent updated to 583 yet, the client will say that you need to update it because it is checking patch.pangya.in.th/patch_S4/updatelist to know the last version.
As Tsukasa said, ProjectG is looking for updates too. There is a solution for that (XAMPP and put the updatelist in patch_S4 folder)

I would launch the updater then replace the thailand.dat and korea.dat to get the messages in english (made by Tsukasa) then retry with hexed client 583.01 (made by fasa2008) and server config set to 1.00, client set to 583.01 in db, server set to 1 in server.ini file (gameserver folder). This worked fine for me.
Then I add some UI translation paks and my modded pangya_th.iff (I already use the last version XD of pangya_th.iff lol)

EDIT: Alright, disregard my nonsense from before. The crashing problem was fixed when I packed the edited texture files in the projectg583th.pak, yes. But what truly fixed my update problem was the MSG server. Before the 583.01 update, I was able to make rooms fine without it running. Now it has to be on in order to be able to make rooms.

(I don't know why it let me double-post, sorry)
On another note, is anyone good with texture/.*pet editing?

Arin's Valkyrie/Crystal/Mirage shoes have 2 parts: g_ft_29.mpet, and g_ft_29_sub_lg.mpet, where the first is the shoes, and the sub is the leggings. For some reason, the Mirage shoes sub calls the Crystal shoes sub, so instead of being black like it's supposed to be, it's bluish-white as if it's Mirage and Crystal shoes mixed together. Anyone know where I can go to fix this?

Quote:

---

Originally Posted by fasa2008

Use my projectG. What are you using in this image is not mine ... xD

---

Sorry fasa2008
This is my picture
Anyone know how to fix it?
PLEASE LOOK AGAIN

For whom who use Client version 583.01
1. Download ProjectG.exe version 583.00 from fasa2008. Then open with hex editor and find 583.00 change it to 583.01
2. Change client_version in Pangya_Server_config Table to 583.01
3. And you must Change ClientVersion of second line in Pangya_Server_list Table(GameServer "Original is Pang-CB Server) to 583.01
Try it
I'm using 583.01 version but

1. I can only see a few item in my shop. and where can i buy new character? Do I need to use the latest pangya_th.iff of my game pak to put in my gameserver? I'm noob at this game ^-^

2. How to change my level to highest (Legend). I can't buy alot item caz i'm only Rookie

3. and can someone gimme the Pangya unpaker? I can't find it.

Even if I log in and choose a server, a channel doesn't appear... Is it why? ...:?:
I don't understand it even if I read a former sentence.
help me...:*:

Quote:

---

Originally Posted by paoza

and can someone gimme the Pangya unpaker? I can't find it.

---

Seriously? You did NOT really search then oo;

Here is Pangya Unpaker with the all the mpet tools :
Pangya Unpaker with mpet editing tools

Does anyone know how to implement outfits from PangyaUS? I know Tsukasa said it was possible, but I'd like to know how.
I want those PSP Pangya outfits. @_@

cannot download flie anonym.to - free dereferer service ????

Quote:

---

Originally Posted by yodmanu

cannot download flie anonym.to - free dereferer service ????

---

ah same link through anonym.to o.O

Quote:

---

Originally Posted by mikumiku

Does anyone know how to implement outfits from PangyaUS? I know Tsukasa said it was possible, but I'd like to know how.
I want those PSP Pangya outfits. @_@

---

Let me correct my statement. It's possible and it's very easy, too (at least if you copy from the US version).

For the lulz I've implemented Miku's DX dress. It's not an edited item but an entirely new one. No old items have been replaced for this one to work. :ott1:

Just read the thread pages about IFF values and recordset lengths again, think about what those 40 byte long text passages could mean, look into the avatar and ui folders of PAK files and you'll be fine. Really. You don't need a tutorial for that - a little understanding of the game's files is already enough.

Ok guys ive did everything written here on the forum.

I use SQL 2008

I vehexed the ProjectG from fasa to 583.01

Ive implented all the procedures here on the forum.

Ive changed Server in ProcUpdateServerState into 1.0

and Client into 583.01

And ive still got the log Update Server State Query failed.

Pls can anyone help me finally cause im still not able to see chanells.

Quote:

---

Originally Posted by Noobya

Ok guys ive did everything written here on the forum.

I use SQL 2008

I vehexed the ProjectG from fasa to 583.01

Ive implented all the procedures here on the forum.

Ive changed Server in ProcUpdateServerState into 1.0

and Client into 583.01

And ive still got the log Update Server State Query failed.

Pls can anyone help me finally cause im still not able to see chanells.

---

you need to set server to 1.00 and client to 583.01 in pangya_server_config not in ProcUpdateServerState

If you don't see the channels you miss some procedures that I posted here in this thread. Without them you can't see the channels. And don't modify original ProcUpdateServerState. It's works fine without any change

staff helps me, I'm 6 days trying to put cookies, plus I'm not
getting ..
I've tried everything, more so is Q: 999,999,999 c: 0: (
already performed the db
CREATE PROC TSU_ADD_COOKIES
and
USE [INI3Bill_DB]
GO

DECLARE @ return_value int

EXEC @ return_value = [dbo]. [hb_py_gp_apply_userinfo_in]
iUser_No @ = 1,
iUser_ID N'josiel = @ ',
@ = iUser_ip N'127 .0.0.1 ',
@ iDB_id = NULL,
@ iItem_no = NULL,
@ iOrder_no = NULL,
@ iPersonal_no = NULL,
iApply_type N'K0 = @ ',
@ iAmount = 10000

SELECT 'Return Value' = @ return_value

GO
but whenever I run them is c: 0 help me please = x

Quote:

---

Originally Posted by josiel

staff helps me, I'm 6 days trying to put cookies

---

You searched at the wrong place :/
Cookies are added in ini3bill_db base, dbo.TAccountmst : put the cookies in "CookieAmt" row :blink:

I have a problem and keep getting an error message from the game server

[F_QUERY] LastSuccQuery({ call dbo.USP_MANAGER_SERVER_AUTH_STATE (20201,1,1,0,1) }), CurrQuery({ call dbo.ProcUpdateServerState (20201,0,0,100,'2010022400','',0,0,100,1,1,0,9,10,1,0,55, 0, 0) })

Could someone help me because

---------- Post added at 09:53 PM ---------- Previous post was at 09:49 PM ----------

Here is a picture from the game server

http://www.abload.de/img/errorou2s.jpg

Closed due to spam, If you have a support question please ask in the support section. or read the stickies.