Pangya Season 4.9 Server Files and Database

[outlawzzbr]

Help - SQL SERVER 2008 R2

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]

DB Pangya_S4_TH with problem

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

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]

You must be registered to see links

 

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

 

[Keith]

great! time to get pangya running again

 

[outlawzzbr]

Create Account

Someone teaches me how to create game account?

PLEASEEE :huh:

 

[Tsukasa]

Re: Create Account

Someone teaches me how to create game account?

PLEASEEE :huh:

Execute ini3_py_account's stored procedure SP_PANGYA_REGIST and SP_PANGYA_ACTIVATE.

Please note that you probably need to alter the table Ini3_User_Login first to allow NULL values in Visa_Ref and VisaIDCard.

 

[outlawzzbr]

Re: Create Account

Execute ini3_py_account's stored procedure SP_PANGYA_REGIST and SP_PANGYA_ACTIVATE.

Please note that you probably need to alter the table Ini3_User_Login first to allow NULL values in Visa_Ref and VisaIDCard.

Sorry but I do not understand! :*:

 

[chiosin2]

@outlawzzbr
just expand your database (INI3_Py_Account>Tables) right click on Ini3_UserLogin then click properties.

Add a check on the null column for the visa_ref. then go to stored procedures and exevute SP_PANGYA_REGIST, then SP_Pangya_Activate.

(just write what ever in your SP pangya regist then when activating just write in the ID you used)

Your done ^^

 

[outlawzzbr]

@outlawzzbr
just expand your database (INI3_Py_Account>Tables) right click on Ini3_UserLogin then click properties.

Add a check on the null column for the visa_ref. then go to stored procedures and exevute SP_PANGYA_REGIST, then SP_Pangya_Activate.

(just write what ever in your SP pangya regist then when activating just write in the ID you used)

Your done ^^

I marked the box and went where you had to go and look what happens :

NOTE: It happens when I run both (SP_PANGYA_REGISTER e SP_PANGYA_ACTIVATE)

 

[chiosin2]

@outlawzzbr

ok so here's how it's done.

Step 1 execute the stored procedure
Step 2 Input Data
Step 3 Account Created

for
SP_PANGYA_ACTIVATE

just execute the stored procedure and write the id of the account you created. and that's it.

 

[outlawzzbr]

@outlawzzbr

ok so here's how it's done.

Step 1 execute the stored procedure
Step 2 Input Data
Step 3 Account Created

for
SP_PANGYA_ACTIVATE

just execute the stored procedure and write the id of the account you created. and that's it.

Thank you!! but ....
now I need help with this here:.

dbo.ProcGetServerList

Someone pass me the code ???????
:grr:

 

[fasa2008]

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.

Yes my friend always the beginning of the code. IFF tells us how many items are added within the file ... usually the first 2 values ...
Ex: In my case I have 480 items Part.IFF of it in HEX think that's>>> 52 11.
If I have not seen the picture show me where is your doubt ... and I tell you ... xD

 

[outlawzzbr]

I'm having the same problem:

http://forum.ragezone.com/attachments/f513/83066d1291488089-pangya-season-4-9-server-gameerror.jpg

Help please ..! :*: