Pangya Season 4.9 Server Files and Database

[Keith]

great! time to get pangya running again

[outlawzzbr]

Someone teaches me how to create game account?

PLEASEEE

[Tsukasa]

Someone teaches me how to create game account?

PLEASEEE

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]

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 :

http://img529.imageshack.us/img529/3163/errohq.png

http://img153.imageshack.us/img153/5286/erro2ew.png

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

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 ???????

[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/attachment...-gameerror.jpg

Help please ..!

[wellan17]

there is already a fix for the error of friends?
and cards
design and self?
how to make new account comes with 100 items of exp?
someone can tell if some event work? what if it works and where to set it up?
Excuse the many questions

[chiosin2]

@outlawzzbr look at your logs.. you might be missing some stored procedure. Don't panic.. its all here.. it might be EQUIP_LOAD_S4 or something like that..

@Tsukasa here's the pic for the clubset.iff



@fasa2008 Thanks for the tips!

[Tsukasa]

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

Thanks a lot for your time .
I've attached an image with the values in question. They are not set for every item, so my best guess is that they might alter effects.

@chiosin2: Yeah thanks, I'll work on the clubs as soon as I'm done with Part.iff and fixed all outstanding issues. :)

@wellan17: Yes, there is a fix for friends, you need to add the missing stored procedure. Cards - dunno. Self-design requires you to have a webservice to host and retrieve images - so nope, does not work yet. If you want to increase the game rank (like Rookie F or Beginner C) simply edit the game_rank value in Pangya_User_Statistics.

[outlawzzbr]

PLEASE - Can someone take a look at my logs? Here is the latest :

MEGAUPLOAD - The leading online storage and file delivery service

[chiosin2]

@outlawzzbr just post it.. i won't take the time to download it.