Pangya Season 4.9 Server Files and Database

[Tsukasa]

How does command this:

http://i52.tinypic.com/2ytuqo3.jpg


Nobody knows, or nobody can talk?

Would be easier for all of us if you could tell us which tables and procedures you have already tried or if you managed to become a GM and used /notice...

I was looking at ur login verifies that the account ini3_userlogin, but there is nothing on that table ... and whenever I try to add something in the error Visa_Ref

Open the ini3_py_account.sql file and in the CREATE statement for the table Ini3_UserLogin change VisaIDCard and Visa_Ref from NOT NULL to NULL, drop the table and create it again. Will work afterwards.

[KS212]

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

Excellent share! Thank you very much!

Wow, now the shop looks nice with all the items! :D

[bubbastic]

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

TYVM for this file.

Everything cost pangs lol Even fairy and elf ears ahahah.
Saved me a lot of time. Searching ID without tools takes too long to have 'em all.

[renato__mouse]

So this code:

CREATE TABLE [dbo].[Ini3_UserLogin](
[idx] [int] IDENTITY(1,1) NOT NULL,
[UserID] [varchar](32) NOT NULL,
[Password] [varchar](100) NOT NULL,
[IsDelete] [char](1) NOT NULL CONSTRAINT [DF_PY_UserLogin_IsDelete] DEFAULT ('N'),
[Birthday] [datetime] NOT NULL,
[Sex] [tinyint] NOT NULL,
[VisaIDCard] [char](13) NOT NULL,
[Confirm18] [tinyint] NOT NULL CONSTRAINT [DF_Ini3_UserLogin_Confirm18] DEFAULT ((0)),
[UserName] [varchar](32) NOT NULL,
[Zipcode] [char](5) NOT NULL,
[Item_Event] [tinyint] NOT NULL CONSTRAINT [DF_Ini3_UserLogin_ItemRate] DEFAULT ((1)),
[Exp_Event] [tinyint] NOT NULL CONSTRAINT [DF_Ini3_UserLogin_Exp_Event] DEFAULT ((1)),
[Visa_Ref] [int] NOT NULL,
CONSTRAINT [PK_Ini3_UserLogin] PRIMARY KEY CLUSTERED
(
[UserID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
END

have to be this way?

CREATE TABLE [dbo].[Ini3_UserLogin](
[idx] [int] IDENTITY(1,1) NOT NULL,
[UserID] [varchar](32) NOT NULL,
[Password] [varchar](100) NOT NULL,
[IsDelete] [char](1) NOT NULL CONSTRAINT [DF_PY_UserLogin_IsDelete] DEFAULT ('N'),
[Birthday] [datetime] NOT NULL,
[Sex] [tinyint] NOT NULL,
[VisaIDCard] [char](13) NULL,
[Confirm18] [tinyint] NOT NULL CONSTRAINT [DF_Ini3_UserLogin_Confirm18] DEFAULT ((0)),
[UserName] [varchar](32) NOT NULL,
[Zipcode] [char](5) NOT NULL,
[Item_Event] [tinyint] NOT NULL CONSTRAINT [DF_Ini3_UserLogin_ItemRate] DEFAULT ((1)),
[Exp_Event] [tinyint] NOT NULL CONSTRAINT [DF_Ini3_UserLogin_Exp_Event] DEFAULT ((1)),
[Visa_Ref] [int] NULL,
CONSTRAINT [PK_Ini3_UserLogin] PRIMARY KEY CLUSTERED
(
[UserID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
END

This is the error: http://img94.imageshack.us/img94/385/imagem1xd.jpg

[chiosin2]

can anyone tell me how to make a GM account?? the old way doesn't seem like its working LoL

[renato__mouse]

chiosin2 send pm me

[Tsukasa]

chiosin2, hexing the version number did the trick! Thanks a ton, mate .

renato__mouse, I've attached a working version of the .sql file. If you use this one, create and activate the account through the stored procedures and use the default server config (and using the command "alluseropen" in the login server) you should be able to login. Please be sure to drop the database ini3_py_account before using this file.

If that's not the case you should study the logs for messages prefixed with E_ or ODBC errors. Could be an issue of missing system-dsn entries or wrong database user/password :) .

For all the other people, here's a simple way to add cookies to your account. It creates a new stored procedure in INI3Bill_DB that requires the user-id (i.e. tsukasa) and the amount of cookies to be added.

Spoiler:

USE [INI3Bill_DB]
GO

CREATE PROC TSU_ADD_COOKIES (
	@UsrId varchar(32),
	@CookiesToAdd money
)
AS
BEGIN
	SET NOCOUNT ON

	DECLARE @UserName varchar(32)
	DECLARE @UserIdx int

	-- Static sitecode, is always 'ini3'
	DECLARE @siteCode varchar(5)
	SET @siteCode = N'ini3'

	-- Get the nickname and the idx for the specified user from the game-server database...
	SELECT @UserName = [nickname], @UserIdx = [UID] FROM [Pangya_S4_TH].[dbo].[Pangya_Member_Info]
	WHERE userid = @UsrId;
	
	-- Check whether we have previous records for this user...
	SELECT UserNo, UserID FROM [TAccountMst]
	WHERE UserNo = @UserIdx
	AND UserID = @UsrId
	
	IF @@ROWCOUNT = 0
		-- User never got cookies so we need to create a new row for him...
		INSERT INTO [TAccountMst] ([SiteCode], [UserNo], [UserID], [UserName], [CookieAmt])
		VALUES ( @siteCode, @UserIdx, @UsrId, @UserName, @CookiesToAdd)
	ELSE
		-- User has cookies so we can simply update the old value
		UPDATE [TAccountMst] SET [CookieAmt] = [CookieAmt] + @CookiesToAdd, [UpdDate] = CURRENT_TIMESTAMP
		WHERE [UserNo] = @UserIdx AND [UserID] = @UsrId
		
END

GO

Edit: You can also use the procedure hb_py_gp_apply_userinfo_in. Here's an example call:

USE [INI3Bill_DB]
GO

DECLARE	@return_value int

EXEC	@return_value = [dbo].[hb_py_gp_apply_userinfo_in]
		@iUser_No = 1,
		@iUser_ID = N'tsukasa',
		@iUser_ip = N'127.0.0.1',
		@iDB_id = NULL,
		@iItem_no = NULL,
		@iOrder_no = NULL,
		@iPersonal_no = NULL,
		@iApply_type = N'K0',
		@iAmount = 100000

SELECT	'Return Value' = @return_value

GO

[chiosin2]

no problem Tsukasa, now i have problems with Bongdari shop, make GM account, UCC, CARDS.. all that stuff. also i need to know how to edit the shop XD... a lot more, my websites almost done but the problem is i don't know how to add cookies/points. LoL XD

[renato__mouse]

More after establishing the account in PangYa_Member_Info we must do more to ensure that it can be accessed?

[Tsukasa]

For updating the cookies see my edited post above, added a simple procedure that should take care of it.

Game ranks can be adjusted using ProcUpdateUserLevel whereas game level has to be a value between 0 (Rookie F) and 65 (Legend A). game_points is the equivalent of the experience already earned for the next level.

As for GM... yeah, I'm curious too. I didn't find any procedure to elevate users yet (regrettably).

[KS212]

Wonder if there's an easy to update the actual shop with the new items from jhonzinbr123's file. The prospect of doing it by hand does not enthuse me x.x

[jhonzinbr123]

well, for enable the items into the ingame shop, you edit the .iff. The file ive attached is a sql script to add all items into the table PANGYA_ITEM_TYPELIST

[chiosin2]

hey jhon, how can i make them points instead of pang?

[jhonzinbr123]

editing the .iff 22 for pangs 21 for cookies/points

[chiosin2]

does anyone know how to fix the Tags? Like the ones you get for 's birthday or Nuri's Birthday?

@Jhon how do i edit the .iff i cant find any software for it. recommend one?