Skilled Illusionist
- Joined
- Sep 15, 2005
- Messages
- 301
- Reaction score
- 3
SO its useless to share this pangya server. OMG....
Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature currently requires accessing the site using the built-in Safari browser.
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'.
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
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
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
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
Need ProjectG.exe with IP 127.0.0.1. I always fail to unpack it....
Can someone help me change the exp rate and pang?
How do you define a GM?
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