Pangya Season 4.9 Server Files and Database

**o800920** · 14-12-10

Originally Posted by G0dzilla2000

Does this work with the latest version of pangya TH? (582.06 i think it is)

582.06 work

@Tsukasa

i use your TSU_ADD_COOKIES and hb_py_gp_apply_userinfo_in to add cookies but not work

**G0dzilla2000** · 14-12-10

Originally Posted by o800920

582.06 work

@Tsukasa

i use your TSU_ADD_COOKIES and hb_py_gp_apply_userinfo_in to add cookies but not work

OK cool thanks for the answer, but anyone have a code that lets you add Gm/Users? Because im having problems figuring out how to login with a user account, is there default ones in the database?(I used the bootstrapper posted earlier and most fixes posted on the forums if thats an issue)

Also im getting a : CMD_GET_REMAINED_POINT_ITEM Process Time 0 in my gameserver cmd window. Is this a concern? and is there a certain way to run all the server exe's to get it physically working?

P.S sorry for all the questions, im new to SQL.

**Tsukasa** · 14-12-10

Originally Posted by gigok

Question 1 : Can i make room and start the game in one player only?

Question 2 : This server and client works without internet connection? Cuz when i shutdown the internet connection, client wont start.

Answer 1: As far as I know - no, you need at least 2 players for every game type. The only feature that works with 1 player is a chat-room. Better go family mode if you want to play single-player.

Answer 2: That's because the client is connecting to a remote site to check for updates (yes, the client itself does check for updates as well). You can avoid this by hexing the address patch.pangya.in.th to i.e. 127.0.0.1, install XAMPP (there's a portable version that works great for this!), create a "patch_S4" folder in your htdocs and unpack the attached file into it.

Originally Posted by o800920

582.06 work

@Tsukasa

i use your TSU_ADD_COOKIES and hb_py_gp_apply_userinfo_in to add cookies but not work

That's odd. Did you try logging out and in again?

Originally Posted by G0dzilla2000

OK cool thanks for the answer, but anyone have a code that lets you add Gm/Users? Because im having problems figuring out how to login with a user account, is there default ones in the database?(I used the bootstrapper posted earlier and most fixes posted on the forums if thats an issue)

Also im getting a : CMD_GET_REMAINED_POINT_ITEM Process Time 0 in my gameserver cmd window. Is this a concern? and is there a certain way to run all the server exe's to get it physically working?

P.S sorry for all the questions, im new to SQL.

In ini3_py_account there are two stored procedures... SP_PANGYA_REGIST and SP_PANGYA_ACTIVATE. Use these. If they don't work because you get a Visa_Ref or VisaIDCard error you need to alter your Ini3_User_Login table to allow NULL values for these fields.

To get the game up and running just change all the servers' ini files to match your settings, start the servers and type the command "alluseropen" into the login server window. You'll notice a hang on first login at the server chooser. Simply exit the client and login again, it'll work from this time on.

You'll get the hang of SQL soon :)

**o800920** · 14-12-10

@Tsukasa
yes i have logout and login but th cookies also no change

http://img574.imageshack.us/i/73082077.jpg/
http://img535.imageshack.us/i/98990004.jpg/
http://img208.imageshack.us/i/73092403.jpg/

how can i fix

**gigok** · 14-12-10

Any clue how to be GM?

**G0dzilla2000** · 14-12-10

Alright thank you so much Tsukasa, i got everything working now,but

1. when i try to make a room it tells me that i need to update the game, now i think i read earlier i need to hex my project G exe but what values do i search for and what do i change them too, im using the latest pangya TH 582.06

2.when i logoff and back on my clothes do not stay equipped

3.tutorials dont complete

4. how to i add Pangs

5. how to i upgrade accounts to GM state

**Tsukasa** · 15-12-10

Originally Posted by G0dzilla2000

Alright thank you so much Tsukasa, i got everything working now,but

1. when i try to make a room it tells me that i need to update the game, now i think i read earlier i need to hex my project G exe but what values do i search for and what do i change them too, im using the latest pangya TH 582.06

2.when i logoff and back on my clothes do not stay equipped

3.tutorials dont complete

4. how to i add Pangs

5. how to i upgrade accounts to GM state

1. Search for 582.00 and replace with 582.05. Also set the value 582.05 in the Server_Config table. See earlier pages for more detail.

2. Seems to be a glitch and doesn't necessary happen always

3. You just found yourself something to do for the weekend. Tell us if you manage to fix it :)

4. There's a stored procedure called Ini3AddPang. More details on how to add items, pang and cookies are located on earlier pages of this thread.

**outlawzzbr** · 15-12-10

Please help me, I got this error:

http://img819.imageshack.us/img819/4971/imagemxj.png

Everytime I try to buy something at the shop, is loading and nothing happens.

Someone help?

LOG:

Spoiler:

**G0dzilla2000** · 15-12-10

Originally Posted by Tsukasa

1. Search for 582.00 and replace with 582.05. Also set the value 582.05 in the Server_Config table. See earlier pages for more detail.

2. Seems to be a glitch and doesn't necessary happen always

3. You just found yourself something to do for the weekend. Tell us if you manage to fix it :)

4. There's a stored procedure called Ini3AddPang. More details on how to add items, pang and cookies are located on earlier pages of this thread.

thanks again for the reply, im glad someone is willing enough to help me and the sql noobies

1.FIXED

2.FIXED

3.if you put a monkey at a computer to fix it, he will probably have a better chance of fixing it, but ill let ya know if i do ;D

4.and for the items thing is that done using the GMtools? And where do i find the .iff files that allow me to add items into the shop? i looked back and found info on how to do it, but not where to find the actual files

(i don't want you to waste your time flipping through pages for me, but if you have a general idea of where they are that would be great)

**outlawzzbr** · 15-12-10

Please help me, I got this error:

http://img819.imageshack.us/img819/4971/imagemxj.png

Everytime I try to buy something at the shop, is loading and nothing happens.

Someone help?

**G0dzilla2000** · 15-12-10

Originally Posted by outlawzzbr

Please help me, I got this error:

http://img819.imageshack.us/img819/4971/imagemxj.png

Everytime I try to buy something at the shop, is loading and nothing happens.

Someone help?

I'm no expert, but did you try running all the fixes posted in the earlier pages? cause that always helped me when my database was acting up.( sorry for the very broad reply just trying to help from the best of my abilities even though its not really help, just more of a suggestion)

Oh btw, what .iff file do i have to edit? cause everyone seems to just automatically know what and where the .iff file is

and could this procedure potentially create GM level users or am i misinterpreting it

Code:

USE [INI3Bill_DB]
GO
/****** Object:  StoredProcedure [dbo].[UP_TX_MB_ADMIN_INS]    Script Date: 12/14/2010 23:53:49 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO





-----------------------------------------------------------------
-- ProcedureName   : UP_TX_MB_ADMIN_INS
-- Description     : ADMIN INSERT
-- Inner SP        : NONE
-- Return Value    : =0->Success, <>0->Fail
-- Copyright ? 2004 by PayLetter Inc. All rights reserved.
-- Author          : sk1004@payletter.com, 2004-08-24
-- Modify History  : Just Created
-----------------------------------------------------------------
ALTER       PROCEDURE [dbo].[UP_TX_MB_ADMIN_INS]
@pi_strAdminID      VARCHAR(20),
@pi_strAdminPass    VARCHAR(256),
@pi_strAdminName    VARCHAR(50),
@pi_strDepartment   VARCHAR(20)=NULL,
@pi_strPosition     VARCHAR(20)=NULL,
@pi_strEmail        VARCHAR(50)=NULL,
@pi_strOfficeTelNo  VARCHAR(20)=NULL,
@pi_strMobileTelNo  VARCHAR(20)=NULL,
@pi_strCPList       VARCHAR(256),
@pi_intGrade        TINYINT,
@pi_intUseState     TINYINT,
@pi_strHAdminID     VARCHAR(20),

@po_strErrMsg       VARCHAR(256) OUTPUT,
@po_intRetVal       INT OUTPUT
AS

SET NOCOUNT ON

BEGIN TRAN

INSERT INTO TADMINMST (ADMINID
                      ,ADMINPASS
                      ,ADMINNAME
                      ,DEPARTMENT
                      ,POSITION
                      ,EMAIL
                      ,OFFICETELNO
                      ,MOBILETELNO
                      ,GRADE
                      ,USESTATE
                      ,HADMINID)
               VALUES (@pi_strAdminID
                      ,@pi_strAdminPass
                      ,@pi_strAdminName
                      ,@pi_strDepartment
                      ,@pi_strPosition
                      ,@pi_strEmail
                      ,@pi_strOfficeTelNo
                      ,@pi_strMobileTelNo
                      ,@pi_intGrade
                      ,@pi_intUseState
                      ,@pi_strHAdminID)
IF @@ERROR <> 0 BEGIN
    ROLLBACK TRAN
    SET @po_strErrMsg = 'TADMINMST INSERT FAIL'
    SET @po_intRetVal = 3081
    RETURN
END

--TADMINMANAGECP INSERT
INSERT INTO TADMINMANAGECP (ADMINID, CPID)
                     SELECT @pi_strAdminID
                           ,CAST(VALUE AS INT)
                     FROM   dbo.UF_GET_SPLIT(@pi_strCPList,',')
IF @@ERROR <> 0 BEGIN
    ROLLBACK TRAN
    SET @po_strErrMsg = 'TADMINMANAGECP INSERT FAIL(EXCEPTION ERROR)'
    SET @po_intRetVal = 2475
    RETURN
END

COMMIT TRAN

SET @po_intRetVal = 0

RETURN

**mikumiku** · 15-12-10

Not sure what's going on here, let alone how to fix it. I've also seen that [F_ODBC] line in the authserver (though only once; it doesn't repeat).

**o800920** · 15-12-10

Originally Posted by mikumiku

Not sure what's going on here, let alone how to fix it. I've also seen that [F_ODBC] line in the authserver (though only once; it doesn't repeat).

do you create ODBC ??

**Tsukasa** · 15-12-10

Originally Posted by mikumiku

Not sure what's going on here, let alone how to fix it. I've also seen that [F_ODBC] line in the authserver (though only once; it doesn't repeat).

Additionally to 0800920's question:
Is this the 32bit or 64bit version of Windows?

**mikumiku** · 15-12-10

Originally Posted by o800920

do you create ODBC ??

I don't know how. If the tutorial that outlawzzbr posted is how you do it, I already said I got an error trying to do that.

Originally Posted by Tsukasa

Additionally to 0800920's question:
Is this the 32bit or 64bit version of Windows?

32-bit, Win7 Ultimate.

Pangya Season 4.9 Server Files and Database

Thread Tools

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

Re: Pangya Season 4.9 Server Files and Database

Re: Pangya Season 4.9 Server Files and Database

Advertisement