Pangya Season 4.9 Server Files and Database

[outlawzzbr]

HELP PLEASE!

I'm having problems with the databases(INI3Bill_DB, ini3_py_account, Pangya_S4_TH) I put the code in Query Analyzer, F5 Grip (to perform the task), and these errors:

http://img690.imageshack.us/img690/5870/erro1n.png

http://img263.imageshack.us/img263/2893/erro2u.png

http://img146.imageshack.us/img146/9426/erro3.png

PS : Sorry for English but I'm from Brazil and used Google translator! Please HELP

[Tsukasa]

HELP PLEASE!

I'm having problems with the databases(INI3Bill_DB, ini3_py_account, Pangya_S4_TH) I put the code in Query Analyzer, F5 Grip (to perform the task), and these errors:

http://img690.imageshack.us/img690/5870/erro1n.png

http://img263.imageshack.us/img263/2893/erro2u.png

http://img146.imageshack.us/img146/9426/erro3.png

PS : Sorry for English but I'm from Brazil and used Google translator! Please HELP

You're using SQL Server 2000, right?
The queries you're trying to execute were created using SQL Server 2005, some other queries in this thread even with SQL Server 2008.

So I would advise that you upgrade or install an additional SQL Server 2008 instance.

[outlawzzbr]

You're using SQL Server 2000, right?
The queries you're trying to execute were created using SQL Server 2005, some other queries in this thread even with SQL Server 2008.

So I would advise that you upgrade or install an additional SQL Server 2008 instance.

I will download the SQL Server 2008, then post results!

Thanks!

[wellan17]

is not adding friends and cards do not work any fix?

[fasa2008]

Well I bring to you the first tutorial on Unlock, change price and status of the items ...

Red - Price of Item in shop. IN hEX

Yellow – Item cokkies or pangs

Brown - Enabled in the shop with the tag = Hot > 21, New > 11, Normal > 01 or 03.




Thanks to all who thank me, gave work to do ... xD

[outlawzzbr]

PLEASE - Someone pass me a tutorial on how to install SQL SERVER 2008 R2 ?

[chiosin2]

@outlawzzbr i used SQL 2005 and it worked just fine.

i used monk's DB's added a user monk and then made it work.
i also used some fixes made by tsukasa/fasa2008/bubbastic

^^ though there are still unanswered questions out there. but its better than nothing.

[outlawzzbr]

@outlawzzbr i used SQL 2005 and it worked just fine.

i used monk's DB's added a user monk and then made it work.
i also used some fixes made by tsukasa/fasa2008/bubbastic

^^ though there are still unanswered questions out there. but its better than nothing.

The DBs ini3_py_account and INI3Bill_DB worked perfectly, but the DB Pangya_S4_TH still with this problem, look:

Spoiler:

Msg 15007, Level 16, State 1, Line 3
'payletter' is not a valid login or you do not have permission.
Msg 15007, Level 16, State 1, Line 3
'Pangya_TH' is not a valid login or you do not have permission.
Msg 15007, Level 16, State 1, Line 3
'ini3webstat' is not a valid login or you do not have permission.
Msg 15007, Level 16, State 1, Line 3
'ini3web' is not a valid login or you do not have permission.
Msg 1921, Level 16, State 1, Line 3
Invalid filegroup 'Pangya_S4_TH_Item' specified.
Msg 1921, Level 16, State 1, Line 3
Invalid filegroup 'Pangya_S4_TH_Item' specified.
Msg 1921, Level 16, State 1, Line 3
Invalid filegroup 'Pangya_S4_TH_Mail' specified.
Msg 1921, Level 16, State 1, Line 3
Invalid filegroup 'Pangya_S4_TH_Item' specified.
Msg 1921, Level 16, State 1, Line 3
Invalid filegroup 'Pangya_S4_TH_Mail' specified.
Msg 1921, Level 16, State 1, Line 3
Invalid filegroup 'Pangya_S4_TH_Mail' specified.
Msg 1921, Level 16, State 1, Line 3
Invalid filegroup 'Pangya_S4_TH_Mail' specified.
Msg 1921, Level 16, State 1, Line 3
Invalid filegroup 'Pangya_S4_TH_Mail' specified.
Msg 1921, Level 16, State 1, Line 3
Invalid filegroup 'Pangya_S4_TH_Mail' specified.
Msg 1921, Level 16, State 1, Line 3
Invalid filegroup 'Pangya_S4_TH_Mail' specified.
Msg 1921, Level 16, State 1, Line 3
Invalid filegroup 'Pangya_S4_TH_Mail' specified.
Msg 1921, Level 16, State 1, Line 3
Invalid filegroup 'Pangya_S4_TH_Mail' specified.
Msg 1921, Level 16, State 1, Line 3
Invalid filegroup 'Pangya_S4_TH_Mail' specified.
Msg 1921, Level 16, State 1, Line 3
Invalid filegroup 'Pangya_S4_TH_Mail' specified.
Msg 1921, Level 16, State 1, Line 3
Invalid filegroup 'Pangya_S4_TH_Mail' specified.
Msg 1921, Level 16, State 1, Line 3
Invalid filegroup 'Pangya_S4_TH_Mail' specified.
Msg 208, Level 16, State 1, Procedure UVW_USER_ITEM, Line 13
Invalid object name 'DBO.PangYa_Character_Information'.
Msg 208, Level 16, State 1, Procedure UVW_ENCHANT_PANG, Line 27
Invalid object name 'PANGYA_ITEM_WAREHOUSE'.
Msg 1767, Level 16, State 0, Line 3
Foreign key 'FK_TD_MAIL_LOG_RET_TA_MAIL_SENDERR_ACC_ERR_CD' references invalid table 'dbo.TA_MAIL_SENDERR_ACC'.
Msg 1750, Level 16, State 0, Line 3
Could not create constraint. See previous errors.
Msg 4917, Level 16, State 0, Line 1
Constraint 'FK_TD_MAIL_LOG_RET_TA_MAIL_SENDERR_ACC_ERR_CD' does not exist.
Msg 4916, Level 16, State 0, Line 1
Could not enable or disable the constraint. See previous errors.

PRINT : http://img826.imageshack.us/img826/7637/erro1h.png

HELP ME?

[chiosin2]

look a few pages back i posted the same problem.. ^^

first thing you do is this.

-create a new log in named Monk (i'm assuming your using Monk's Databases)
-create 3 new filegroups names Pangya_S4_Th_Card/Pangya_S4_Th_gLog/Pangya_S4_Th_Item

and then execute it again.. it should work fine now.. ^^

[outlawzzbr]

look a few pages back i posted the same problem.. ^^

first thing you do is this.

-create a new log in named Monk (i'm assuming your using Monk's Databases)
-create 3 new filegroups names Pangya_S4_Th_Card/Pangya_S4_Th_gLog/Pangya_S4_Th_Item

and then execute it again.. it should work fine now.. ^^

Forgive the ignorance but how do they create filegroups?

[MentaL]

look

[fasa2008]

Forgive the ignorance but how do they create filegroups?

sorry

[MentaL]

Are you Brazilian friend? Post your question in RZBR ... I resolve

How about do not POST on rzbr because its using my name ILLEGALLY. We do not support nor allow replica ragezone websites, especially ones who abuse my trademark.

[fasa2008]

How about do not POST on rzbr because its using my name ILLEGALLY. We do not support nor allow replica ragezone websites, especially ones who abuse my trademark.

The same topic is here has there. Since the User up there because it is Brazilian not get help there that would be easier for him to understand I'm not the owner of RZBR ... Sorry I did not post anything else ... xD

[Tsukasa]

Well I bring to you the first tutorial on Unlock, change price and status of the items ...

Red - Price of Item in shop. IN hEX

Yellow – Item cokkies or pangs

Brown - Enabled in the shop with the tag = Hot > 21, New > 11, Normal > 01 or 03.


Thanks to all who thank me, gave work to do ... xD

Thanks a lot for the guide. There are still a few things I'd like to understand. For instance in the blocks 6248-6251 (right after price value of the Zigzag Hairband) there is some value... any idea what that does? Same goes for 6264-6267, 6270 and the area 6280-6294... If anyone has any insight what these values do, I'd be most thankful for some feedback.

Just to add to the understanding of the file format: A record in Part.iff is always 512blocks long. First records starts at an offset of 8, preceeded by two uint32 values indicating the total number of items in the file and the iff version (I assume) that is always 11 decimal.