Pangya Season 4.9 Server Repack v.2 + Setup Guide

[vergil250493]

# Custom TH Pangya S4.9 English UI Edition - 582.05-R1 (MegaUpload - 602MB RAR)

You must be registered to see links

You must be registered to see links

You must be registered to see links

You must be registered to see links

Mirror Download / Credit to terrorofdeath (Thanks)

You must be registered to see links

> PyClient_Update-1.1 Patch:
http://forum.ragezone.com/6112431-post45.html

Special Thanks fasa2008 for the ProjectG, and there are few bugs that are not resolved but won't cause any issue, client is 100% ready for localhost play, private LAN/WAN play need to hex edit the IP on ProjectG. I might release pak patches regard the remaining bugs and maybe add new official items if i have sufficient motivation to do it. Right now this is as far i go due to the server status i'm having.

# Py S4.9 Server + Database Repack v.2-R1

You must be registered to see links

Cleaned off the logs and removed the files that we possibly never need. That downsized from original 120MB to repack 14MB to now amazing 3MB. Mind you this release fixed much bugs and errors from previous release but still contain some. The rest counts on the communities to put their rawr power and make it work.

# Download: MS SQL 2008R2 Express 'Database with Management Tools'

You must be registered to see links

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

LET'S BEGIN! HO~HO~HO~! aka GUIDE
A much more detailed guide (with pictures) by terror here!
http://forum.ragezone.com/f514/complete-pangya-setup-guide-v1-719617/​

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

MS SQL Server Installation:
1. Launch MSSQL installation with default settings or custom settings is fine.
2. When prompt for Authentication Option choose "Mixed Mode" that uses 'sa' account and type your SQL Server password.
3. Continue and finish the installation with default settings or custom settings is fine.

Game SQL Database Installation: (Make sure the SQL Server is running)
1. Launch 'SQL Server Management Studio' from StartMenu. Connect using:

- Server Type: Database Engine
- Server Name: 127.0.0.1 or localhost or (local) or If you use custom name for the database stance then type example 'James-PC\YourDBStanceName'
- Authentication: Windows Authentication​

2. Go 'Database Repack.v2' folder > Execute the .sql files in numberic order and done. (You can ignore the grey or black text about missing procedures)

Open up ODBC Database:
1. Go StartMenu > Control Panel > All Control Panel Items > Administrative Tools > launch 'Data Sources (ODBC)'
2. ODBC > 'System DNS' tab > Add > Scroll down to 'SQL Server Native Client 10.0' > Finish

Register Connections to ODBC Database:
1. Name: ini3_py_account

- Put the name of the database ODBC should connect to; which you need 'ini3_py_account', 'INI3Bill_DB' and 'Pangya_S4_TH'. Create the connections ONE BY ONE!​

2. Description: Put whatever you want or leave it emty

- A personal note for that connection, is not important anyway.​

3. Server: 127.0.0.1

- If you install MSSQL using Default database stance name then 127.0.0.1 / localhost / (local) / or your PC name are fine. If you use custom name for the database stance then type example 'James-PC\YourDBStanceName'​

4. Next page, use Windows Authentication is fine and 'Next'.
5. Change Default Database to the same name as your connection name and leave the rest, go 'Next'.
6. Make sure your Windows is using English language or you can change SQL Server system messages to English. Now press 'Finish' and 'Test Data Sources', you should get 'TESTS COMPLETED SUCCESSFULLY!', press OK to add to ODBC.
7. Now repeat add rest of the connections until you have 'ini3_py_account', 'INI3Bill_DB' and 'Pangya_S4_TH' in OBDC and DONE!

FINAL - Server INI Edits and Done:
1. Open 'PANGYA_SRV Repack.v2' Folder. In there edit following .ini files with your own SQL Server password.
- Auth\Auth.ini
- Login\Login.ini
- Py_GameServer\Server.ini
* Ranking and MSG Servers are optional if you don't use it. BINDSERVER use with MSG Server only.
2. Ready to launch servers! Auth, Login, GameServer! Enjoy and Have fun! (Dont forget to create account )

Please read Tsukasa's Guide for account creation and other troubleshoots:
http://forum.ragezone.com/f200/common-beginner-questions-715711/

hontoshadow gonna think very uncool of me now :8:

hello man can you help me ?? when i try excute my client its say for update the client :S i already use patch updates

 

[hvdaedalus]

Read this:

http://forum.ragezone.com/f200/common-beginner-questions-715711/

 

[kisserz]

good

 

[amok10]

why you can not invent such a Pangya emulator because the sql I am not clear is always login server down with me even though I have done everything as it was in the Alexandrine description but I have win XP and 7 and not with the ip setting in network I can not do because otherwise I have no internet anymore because someone help me I can not so good english but I do not know what I should do yet

Assistance would be TeamViewer not bad but maybe I do not know what to do with the sql server express 2008 R2

 

[codyx]

I have a win7 64 and a win XP, I am a noob in SQL. I installed Teamviewer.
Could someone make me a Pangya server?

mmmmh! I think you can try to read all sections of the forum, if english is difficult you can try with google translate, I think it's good enough.

And how can you expect to make a server without any SQL knowledge. Read other's code, try to understand and copy the structure to make your own features.

 

[pippox]

great work!!!

one question:

what's the difference between ProjectG.exe and ProjectG_Offline.exe?

 

[Morpheous]

Hello guys,

I'm currently downloading the files. I am really looking forward to make my own private server.
However, I have 0 experience in any kind of programming whatsoever.
Could anyone tell me if this guide would be sufficient for me?
And how long it would probably take me before I get it up and running?

Thanks for your reply!

Morpheous

 

[Tsukasa]

Hello guys,

I'm currently downloading the files. I am really looking forward to make my own private server.
However, I have 0 experience in any kind of programming whatsoever.
Could anyone tell me if this guide would be sufficient for me?
And how long it would probably take me before I get it up and running?

Thanks for your reply!

Morpheous

For the basic operation you should familiarize yourself with SQL. I can't recommend any resource for that - playing around with Management Studio, exploring the databases/tables/procedures by yourself and setting yourself small goals (like: "I want to set the money for account X" or "I want to make myself GM by using a SQL query") as step-stones to learn the basic SQL syntax will do just fine. For a small, private (as in: you and some friends) server this should suffice.

The reason you should know your basic SQL is simple: Most of the fixes in here shouldn't just get applied without any background knowledge.

If you want to get into item modification, you best start reading through the old release thread for the original server files (not the repack!), there's a bunch of cool stuff in that thread. chreadie's IFF thread in the Development forum is also a nice resource.

So yeah... kind of depends what level of customization you're after. Again, for a normal game with friends, just downloading, following the guide and some basic SQL is enough.

 

[Dark_Panico]

Tsukasa...

My client loads and closes suddenly : .. why ?

 

[ponk123]

Thanks man.. i miss this game ^_^

 

[xpang]

Have the possibility to change the level of experience?
Example: Rookie to Amateur.

 

[Levis0o0]

I can't connect to

You must be registered to see links

So Who can give me the files in updatelist ! Thanks alot!

 

[DazhXII]

I've become to interested in making my own Pangya Land. I think this thread would help out. Thanks

PS. I didn't notice I'm long gone here :tongue:

 

[castrolanda]

HElp? i got an error in all the files in steo 5c: F_ODBC CONNECT 2: ID {PANGYA_S4;_YH}, Account{sa}, Password {xxxxxxxxx).And dont remember creating an account with the "sa" tag. and a saw that when u said to creat to creata apassword at Intalation Steps of SQL Server u didnt showed where to put this sa..
plz help
EDIT: And in installation guide on the Database Engine Configuration, didnt appear anything at Specify SQL Server administrators.. why?

Sorry about my english.. its really bad, i am brazilian.
Oh, and last thing: How to use that projectG online? because i just want a server to edit maps and test my dunk, tomahawk, to improve it.

 

[iskono]

getting XML error , what shall i do ?

 

[hvdaedalus]

Set up your own Updater and create your own Updatelist.

 

[neben007]

I have a problem on installing sql server 2008 r2 in my vista ultimate..
I encountered a problem on installing a windows powershell .. It always says " the update does not apply to your system " pla help sir..

 

[marcus665]

please anyone can create a server to me ? in localhost . *-*
thankyou .

 

[hvdaedalus]

Please create it yourself. There is this tutorial, the Common Beginner Questions thread and a lot stuff in the releases section. There is at least one more tutorial about creating this server. Why don't you give it a try?

 

[X_Sarah_X]

please anyone can create a server to me ? in localhost . *-*
thankyou .

I'd suggest to at least learn about the server files yourself.
Imagine IF someone is crazy enough to make a server for you, how will you maintain it? Fix bugs? Add extra content?
If you don't understand the server files at least a bit, you shouldn't be hosting a server to public yet.

No offense intended.