Все по PangYa Online!!!
Все по PangYa Online!!!
Файлы+сервер+клиент+гайды+скрипты
(все для создания приватника PangYa Online)
Сервер+клиент+ файы+ гайд:
All files for the server program and launcher files are from chikebum
Original thread from RaGEZONE:
http://forum.ragezone.com/pangya-online/i-...er-d-91951.html
Warning: This guide is for education ONLY and i don't take any responsibility for anything that you may have by reading this guides because i only gather the informations!
This is better guides from RZ by LGKeiz
(Thx to all who contributes in the guides):
QUOTE
:: Creating a Pangya server ::
To create a Pangya Server You would Need three things:
+MSSQL
++The Pangya Server
+++a brain
:: System Requirements ::
1.5GB of diskspace
1.5Mhz + Proccessor
atleast 512MB of RAM
and a system that handles SQL
:: What is Pangya ::
Pangya is a MMORPG Fantasy Anime type Golf Game, with lots of stuff lol... sorry I can't explain
it better but it's really fun ( to me anywas I got diff opinions )
:: Server files // Client // Requirements ::
Server files: http://mmorpg.ragezone.com/pangya/pangya-server.rar
Client:
http://legacygamers.deltaanime.net/PangYa.rar [UPDATED VER: 2.14g]
PangYa Translations: http://legacygamers.deltaanime.net/PangYa%20Translations.rar
MSSQL:
http://www.microsoft.com/downloads/info.as...3%2fSQLEVAL.exe
:: How to setup MSSQL ::
If You hosted MU you shouldn't of a problem making this server,
1] Install MSSQL
2] Open up MSSQL with Enterprise manager in your start menu program files
3] click Microsoft SQL Server > SQL Server Group > (local) Database > Database >
4] Right click database click New Database, and name it Bn_Game click ok do the same thing 2 more times and name them,
Bn_Account and,
PY_Billing
5] after making the three databases right click Bn_Game > go to all task > go to restore database >
After clicking Restore database There will be three selections Database, Filegroups or files, and From device, click from Device
6] after clicking from Device, You should get a new menu click Select Devices a new menu should popup click Add; Then a new menu will popup
click "..." Browse to your Pangya server files db folder ( should be in C:\ )
7] click on Id_Bn_Py_Game_test backup, click ok, click ok again, click ok yet again, then go to the "options" tab
8] Now where it saids "Move to physical file name" put in the location you want to restore the database such as mine would be
C:\Pangya-server\DB\, do the same for both fields
9] click ok, it should install the database
10] Repeat the 4 - 9 2 more times
with databases
PY_Billing with backup PY_Billing
Bn_Account with backup game_account_backup
11] After that, go to your pangya server files, go to GameServer, Change the IPs in the INI, Same with the rest of the INIs in each folder
Get your IP at http://whatismyip.com or if you wanna play on your own put in 127.0.0.1
12] then go back to Enterprise mananger open up the Bn_Game, click Tables > right click the table "Pangya Server List" click open table > click Return all rows
13] This is where you can change the server name pang and everything else, replace the ip that is there with your ip, close the table.
14] click the "security" folder click Logins, right click where it saids "sa" click New Login, a new menu should popup
15] put in a name that you like in the "Name:" field, click the SQL Server Authentication, put in a password, that isnt to easy to guess
( this will secure your sql server )
16] Click the Server Roles Tab > check the System Admin spot go to tab Database Access > Under Permit check the Bn_Game, Bn_Account, and By_Billing, now under each one
it'll say public and such, check mark "db_owner" on all 3, after that click ok, It'll want you to confirm your password retype your password in
17] now to setup your System DNS, go to Your Control Panel, click classic view in the menu > Administrive Tools icon > click the Data Sources (ODBC) icon
18] After that a new window should popup, click the System DSN Tab> click the add button, scroll down to the last option "SQL Server" click finish
19] a New window should popup Name put in Bn_Game, leave description blank, server localhost or 127.0.0.1, click Next
20] Make sure the With Windows NT authentication using Network login ID is checked click next
21] Click Change the default database too, select Bn_Game click Next, and click Finish.
22] repeat 17 ~ 21 with dns names
Bn_Account
PY_Billing
23] To create a account, go back to your Enterprise manager, click the Bn_Game Database > click tables select the "Pangya_Member_Info" table right click > Open table > return all rolls > select all the accounts in the database > delete them all ( selecting them all )
Create a new account ( it's pretty simple after that ) make the "First Set" is 0 and tutorial is 1 save, close enterprise manager
( Fixed it thanks to Tibalt )
24] Go to your Pangya Server Files, Open the servers
1] AuthServer
2] LoginServer
3] RankServer ( Fix is at the bottom of the post. )
4] GameServer
( when each is done loading type in "start" in the command promp ( without the " " ) and click enter )
25] Tada You have made your first pangya server!!
QUOTE
:: Client :: UPDATED !!
1] Install the Client in C:\Program Files\
2] Run, Run.reg ( edit the location of the Files in the run.reg ( open it with notepad to do so, ONLY if you dont use a C: drive )
3] Open the ProjectG.exe in your favorite HEX Editor, search for 127.0.0.1
4] Change all the IP's around it ( it should start with 172.*.*.* ( my server lol ))
5] After changing every IP go to the end of each IP, and HEX in 00 00 00 if the "." arn't 00 or if you have extra numbers
6] Run ProjectG.exe ( no need for -babo anymore ^^ )
7] Login and play!
QUOTE
:: Web Manager Translated / Uptodate
http://legacygamers.deltaanime.net/Pangya/...a%20Website.rar
:: Web Manager Cookie Bug Fix ::
http://legacygamers.deltaanime.net/Pangya/WBMNGRfix.rar
Thanks to Twillight
:: Addon for the Web Manager ::
http://legacygamers.deltaanime.net/Pangya/uonline.rar
Once again Thanks to Twillight :P
:: Fixes ::
QUOTE
:: Ranking Server ::
1] Open up rankserver.ini, Change RegionEvent = on to off, Set DBDSN to bn_game ( I think it was default just making sure ) set webDBDSN to bn_game ( WebDBDSN is for the Pangya website ( not needed but maybe in the future ) Set RegionDBDSN to bn_game ( the RegionDB ( Im building it ) is under contruction, i'll release it later ))
2] Open the server, type in buildrank, and there ya go
QUOTE
:: Wipping Your PangYa Database ::
USE Bn_Account
TRUNCATE table tbl_game_account
TRUNCATE table tmp_user_id
USE Bn_Game
TRUNCATE table Pangya_character_Information
TRUNCATE table pangya_daily_logincount
TRUNCATE table pangya_friend
TRUNCATE table pangya_Friend_Note
TRUNCATE table Pangya_Gift_Table
TRUNCATE table pangya_help_desc
TRUNCATE table pangya_item_warehouse
TRUNCATE table pangya_MacAddress_id
TRUNCATE table pangya_member_info
TRUNCATE table pangya_monthly_Logincount
TRUNCATE table pangya_map_statistics
TRUNCATE table pangya_nick_history
TRUNCATE table pangya_notice_list
TRUNCATE table pangya_server_history
TRUNCATE table pangya_title
TRUNCATE table pangya_Trophy_Stat
TRUNCATE table pangya_user_equip
TRUNCATE table pangya_User_information
TRUNCATE table pangya_user_ladder
TRUNCATE table pangya_user_statistics
TRUNCATE table PY_Nick_Log
USE PY_Billing
TRUNCATE table BX_TG_APPLYINFO
TRUNCATE table BX_TG_USERINFO
QUOTE
:: Adding Kooh to your server ::
1. Goto Pangya_Item_TypeList table (SQL Manager) -> Open Table -> Return all rows ->
Click SQL in toolbar menu and replace this command :
INSERT INTO Pangya_Item_TypeList (TypeId, Name, Icon, Price) VALUES(67108869, 'Kooh','e_def', 29000)
then click '!' in toolbar menu.
2. Right Click on 'Stored Procedures' -> Click 'New Stored Procedure...' then replace all text to textbox area :
CREATE Proc AddKoohAndItemTo
@userid varchar(32)
as
DECLARE @UID int
select @UID = UID from Pangya_Member_Info where userid = @userid
IF @UID > 0
BEGIN
INSERT INTO PangYa_Character_Information (uid, typeid) VALUES(@UID,67108869)
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID, 135544832, 1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID, 135544833, 1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID, 135544834, 1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID, 135569408, 1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID, 135569409, 1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID, 135585792, 1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID, 135585793, 1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID, 135585794, 1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID, 135634944, 1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID, 135634945, 1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID, 135528449, 1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID, 135561217, 1, getdate());
RETURN
END
GO
3. Go to sql command to execute procedure name 'AddKoohAndItemTo' with parameter userid :
example : AddKoohAndItemTo 'yourloginname'
then click '!'
QUOTE
:: Make Skin and Ball to Pangya_Item_Typelist table. ::
INSERT INTO Pangya_Item_TypeList (TypeId, Name, Price) VALUES(952107015,'Green Bag Slot',5000)
INSERT INTO Pangya_Item_TypeList (TypeId, Name, Price) VALUES(952107014,'Blue Bag Slot',5)
INSERT INTO Pangya_Item_TypeList (TypeId, Name, Price) VALUES(952107013,'Pink Bag Slot',5)
INSERT INTO Pangya_Item_TypeList (TypeId, Name, Price) VALUES(947912722,'Lolo Sticker',9)
INSERT INTO Pangya_Item_TypeList (TypeId, Name, Price) VALUES(947912721,'Pipin Sticker',9)
INSERT INTO Pangya_Item_TypeList (TypeId, Name, Price) VALUES(947912720,'Tiki Sticker',9)
INSERT INTO Pangya_Item_TypeList (TypeId, Name, Price) VALUES(947912719,'Titang Boo Sticker',9)
INSERT INTO Pangya_Item_TypeList (TypeId, Name, Price) VALUES(943718411,'Flower Garden Frame',5)
INSERT INTO Pangya_Item_TypeList (TypeId, Name, Price) VALUES(943718410,'Green Water Drop Frame',7)
INSERT INTO Pangya_Item_TypeList (TypeId, Name, Price) VALUES(943718409,'Pink Water Drop Frame',7)
INSERT INTO Pangya_Item_TypeList (TypeId, Name, Price) VALUES(943718408,'Tangled Bronze Frame',5)
INSERT INTO Pangya_Item_TypeList (TypeId, Name, Price) VALUES(939524103,'Green Tiki PangYa',7)
INSERT INTO Pangya_Item_TypeList (TypeId, Name, Price) VALUES(939524102,'Purple Tiki PangYa',7)
INSERT INTO Pangya_Item_TypeList (TypeId, Name, Price) VALUES(939524101,'Ivy Vines',5)
INSERT INTO Pangya_Item_TypeList (TypeId, Name, Price) VALUES(939524100,'The Best Rice',7)
INSERT INTO Pangya_Item_TypeList (TypeId, Name, Price) VALUES(335544330,'Chistmas Aztec (50)',12)
#----- Make Procedures to add Skin, Chistmas Ball, House Club -----
CREATE Proc AddSkinItemTo
@userid varchar(32)
as
DECLARE @UID int
select @UID = UID from Pangya_Member_Info where userid = @userid
IF @UID > 0
BEGIN
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID, 952107015, 1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID, 952107014, 1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID, 952107013, 1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID, 947912722, 1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID, 947912721, 1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID, 947912720, 1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID, 947912719, 1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID, 943718411, 1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID, 943718410, 1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID, 943718409, 1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID, 943718408, 1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID, 939524103, 1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID, 939524103, 1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID, 939524102, 1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID, 939524101, 1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID, 939524100, 1, getdate());
RETURN
END
GO
#----- Add Club and Status PWR,CTL,ACC,SPN,CRV -----
CREATE Proc AddHClubTo
@userid varchar(32)
as
DECLARE @UID int
select @UID = UID from Pangya_Member_Info where userid = @userid
IF @UID > 0
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate,C0,C1,C2,C3,C4) VALUES (@UID, 268435459, 1, getdate(), 3, 6, 4, 2, 2);
GO
#----- Add Chismas Aztech ball to player ------
CREATE Proc AddCMBallTo
@userid varchar(32),
@ball int
as
DECLARE @UID int
select @UID = UID from Pangya_Member_Info where userid = @userid
IF @UID > 0 and @ball > 0
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate,C0) VALUES (@UID, 335544330, 1, getdate(), @ball);
GO
#------ Example to use procedures -----
AddSkinItemTo 'yourloginname'
AddHClubTo 'yourloginname'
AddCMBallTo 'yourloginname', 100
Thanks to attagorn Again, very good job.
QUOTE
:: Hexing the Client Files for Private Server Usage
Target Version: 2.14c
Target IP: 192.168.0.1 / 127.0.0.1
Step 1. Unpacking ProjectG.exe with PEID(Attached)
Step 2. Open unpacked.exe from your HEX Editor such as UE32, HE
Step 3. Change IP's
[Auth Server]
FIND: 32 30 32 2E 31 30 2E 33 32 2E 32 31 - 202.10.32.21
CHANGE: 31 39 32 2E 31 36 38 2E 30 2E 31 00 - 192.168.0.1
If you change ip's to 127.0.0.1 than this is a code for it.
31 32 37 2E 30 2E 30 2E 31 00 00 00
[Login Server]
FIND: 32 31 31 2E 34 33 2E 31 39 34 2E 32 32 - 211.43.194.2
CHANGE: 31 39 32 2E 31 36 38 2E 30 2E 31 00 00 - 192.168.0.1
If you change ip's to 127.0.0.1 than this is a code for it.
31 32 37 2E 30 2E 30 2E 31 00 00 00 00
[Game Server]
FIND: 36 31 2E 33 33 2E 36 35 2E 31 36 31 - 61.33.65.161
CHANGE: 31 39 32 2E 31 36 38 2E 30 2E 31 00 - 192.168.0.1
If you change ip's to 127.0.0.1 than this is a code for it.
31 32 37 2E 30 2E 30 2E 31 00 00 00
Step 4. Change Client Version
FIND: 32 2E 31 34 63 5F 74 65 73 74 5F 30 30 - 2.14c_test_00
CHANGE: 32 2E 31 34 63 00 00 00 00 00 00 00 00 - 2.14c
Step 5. Disable Hack Shield
FIND: 8D50055783C9FF33C08BFAF2AEF7D1490F84
CHANGE: 8D50055783C9FF33C08BFAF2AEF7D14990E9
Step 6. Disable update routine
FIND: C0752353
CHANGE: C0EB2353
Step 7. Save and change file name from unpacked.exe to whatever you like such as ProjectG.exe or update.exe
Thanks to advenire
QUOTE
:: Web Rank ::
1. Create database Web
2. Create system DSN link from rankserver.ini:
WebDBDSN = rank
WebDBUser = yourdbuser
WebDBPassword = yourdbpasswd
3.Open Query Analyzer and select db Web
insert text from CreateTables.txt(attach) and run for create tables.
4. Enter "updaterank" in Rankserver window for filling the tables.
5. Use asp scripts for stats (attach)
Have Fun.
- Attachment: http://forum.ragezone.com/attachments/2330...ar?d=1139083106
Thanks to Twillight.
QUOTE
:: Optional - Setting up IIS And PangYa Web Manager ::
- Firt you must have IIS (Internet Information Services) installed on your PC (IIS can you get at WinXP CD Installation.)
- You must have Pangya Web Manager Pack (Find your self at this forum).
1. Delete all file on "wwwroot" folder.
Where you can find these folder ?
C:\Inetpub\wwwroot
2. Extrack your pangya web manager to wwwroot folder.
3. Open "Config.asp" with your fav. text editor (ex. notepad)
you can find :
SAPassword="??" <-- fill ?? with your MSSQL password
ServerName="??" <-- fill ?? with your Server Name
GivePangAtReg="1000" <-- config for add "Pang" for a new user.
GiveCookieAtReg="50" <-- config for add "Cookie" for a new user.
CookieExchangeRate="1000" <-- config how much pang needed for 1 Cookie (Im not sure about this :P)
edit and save !
4. Go to IIS control panel ! (Control Panel> Administrative Tools > Internet Information Services !
Left klick! your "website" > properties !
5. Go to "Home Directory" Tab, on Execute Permision change to "Scripts Only" (I think these config who makes asp file cannot execute by IIS, first I have error on pangya web manager, but after I change this config to Scripts Only, my pangya web manager can work
6. Testing
7. on your fav. Browser (IE) go to addres //localhost or //(your IP)
8. Trata!!! Wellcome to -Pangya Friendly Server
If you still have error, post again here
sorry for my bad English
Thanks to neo151285
:: EXP Changing :: - NOT SURE IF ITS WORKING.
CREATE Proc ProcUpdatePang
@UID int,
@Pang int
as
Update pangya_user_statistics set pang = @Pang *3 where uid = @UID
GO
CREATE proc ProcUpdateUserStatistics
@UID int,
@drive int,
@putt int,
@playtime int,
@longest real,
@distance int,
@pangya int,
@hole int,
@TeamHole int,
@holeinone int,
@ob int,
@bunker int,
@fairway int,
@Albatross int,
@holein int,
@pang int,
@timeout int,
@game_level smallint,
@game_point smallint,
@PuttIn int,
@LongestPuttIn real,
@LongestChipIn real,
@GameCount int,
@DisconnectGames int,
@wTeamWin int,
@wTeamGames int,
@LadderPoint int,
@LadderWin int,
@LadderLose int,
@LadderDraw int,
@ComboCount smallint,
@MaxComboCount smallint,
@NoMannerGameCount int,
@TotalScore int,
@BestScore0 smallint,
@BestScore1 smallint,
@BestScore2 smallint,
@BestScore3 smallint,
@ShotTime int,
@MaxPang0 int,
@MaxPang1 int,
@MaxPang2 int,
@MaxPang3 int
as
update PangYa_User_Statistics
set drive = @drive,
putt = @putt ,
playtime = @playtime,
longest = @longest,
distance = @distance,
pangya = @pangya,
hole = @hole ,
TeamHole = @TeamHole,
holeinone = @holeinone,
ob = @ob,
bunker = @bunker,
fairway = @fairway,
Albatross = @Albatross,
holein = @holein,
pang = @pang * 3,
timeout = @timeout,
game_level= @game_level ,
game_point = @game_point,
PuttIn = @PuttIn,
LongestPuttIn = @LongestPuttIn,
LongestChipIn = @LongestChipIn,
NoMannerGameCount = @NoMannerGameCount,
GameCount = @GameCount,
DisconnectGames = @DisconnectGames,
wTeamWin = @wTeamWin,
wTeamGames = @wTeamGames,
LadderPoint = @LadderPoint,
LadderWin = @LadderWin,
LadderLose = @LadderLose,
LadderDraw = @LadderDraw,
ComboCount = @ComboCount,
MaxComboCount = @MaxComboCount,
TotalScore = @TotalScore,
BestScore0 = @BestScore0,
BestScore1 = @BestScore1,
BestScore2 = @BestScore2,
BestScore3 = @BestScore3,
ShotTime = @ShotTime,
MaxPang0 = @MaxPang0,
MaxPang1 = @MaxPang1,
MaxPang2 = @MaxPang2,
MaxPang3 = @MaxPang3
where UID = @UID
GO
CREATE proc ProcUpdateUserLevel
@UID int,
@game_level smallint,
@game_point smallint
as
update PangYa_User_Statistics set game_level= @game_level , game_point = @game_point * 100
where UID = @UID
GO
thanks to iostream.
так же клиент можно скачать тут:
You can download by bittorrent. PangyaIndonesia+Patch
In link
http://www.mininova.org/tor/129459
You can download program bittorrent in link.
http://www.bitcomet.com/doc/download.htm
Обязательно указание:
http://community.livejournal.com/ragnaforce/
Файлы+сервер+клиент+гайды+скрипты
(все для создания приватника PangYa Online)
Сервер+клиент+ файы+ гайд:
All files for the server program and launcher files are from chikebum
Original thread from RaGEZONE:
http://forum.ragezone.com/pangya-online/i-...er-d-91951.html
Warning: This guide is for education ONLY and i don't take any responsibility for anything that you may have by reading this guides because i only gather the informations!
This is better guides from RZ by LGKeiz
(Thx to all who contributes in the guides):
QUOTE
:: Creating a Pangya server ::
To create a Pangya Server You would Need three things:
+MSSQL
++The Pangya Server
+++a brain
:: System Requirements ::
1.5GB of diskspace
1.5Mhz + Proccessor
atleast 512MB of RAM
and a system that handles SQL
:: What is Pangya ::
Pangya is a MMORPG Fantasy Anime type Golf Game, with lots of stuff lol... sorry I can't explain
it better but it's really fun ( to me anywas I got diff opinions )
:: Server files // Client // Requirements ::
Server files: http://mmorpg.ragezone.com/pangya/pangya-server.rar
Client:
http://legacygamers.deltaanime.net/PangYa.rar [UPDATED VER: 2.14g]
PangYa Translations: http://legacygamers.deltaanime.net/PangYa%20Translations.rar
MSSQL:
http://www.microsoft.com/downloads/info.as...3%2fSQLEVAL.exe
:: How to setup MSSQL ::
If You hosted MU you shouldn't of a problem making this server,
1] Install MSSQL
2] Open up MSSQL with Enterprise manager in your start menu program files
3] click Microsoft SQL Server > SQL Server Group > (local) Database > Database >
4] Right click database click New Database, and name it Bn_Game click ok do the same thing 2 more times and name them,
Bn_Account and,
PY_Billing
5] after making the three databases right click Bn_Game > go to all task > go to restore database >
After clicking Restore database There will be three selections Database, Filegroups or files, and From device, click from Device
6] after clicking from Device, You should get a new menu click Select Devices a new menu should popup click Add; Then a new menu will popup
click "..." Browse to your Pangya server files db folder ( should be in C:\ )
7] click on Id_Bn_Py_Game_test backup, click ok, click ok again, click ok yet again, then go to the "options" tab
8] Now where it saids "Move to physical file name" put in the location you want to restore the database such as mine would be
C:\Pangya-server\DB\, do the same for both fields
9] click ok, it should install the database
10] Repeat the 4 - 9 2 more times
with databases
PY_Billing with backup PY_Billing
Bn_Account with backup game_account_backup
11] After that, go to your pangya server files, go to GameServer, Change the IPs in the INI, Same with the rest of the INIs in each folder
Get your IP at http://whatismyip.com or if you wanna play on your own put in 127.0.0.1
12] then go back to Enterprise mananger open up the Bn_Game, click Tables > right click the table "Pangya Server List" click open table > click Return all rows
13] This is where you can change the server name pang and everything else, replace the ip that is there with your ip, close the table.
14] click the "security" folder click Logins, right click where it saids "sa" click New Login, a new menu should popup
15] put in a name that you like in the "Name:" field, click the SQL Server Authentication, put in a password, that isnt to easy to guess
( this will secure your sql server )
16] Click the Server Roles Tab > check the System Admin spot go to tab Database Access > Under Permit check the Bn_Game, Bn_Account, and By_Billing, now under each one
it'll say public and such, check mark "db_owner" on all 3, after that click ok, It'll want you to confirm your password retype your password in
17] now to setup your System DNS, go to Your Control Panel, click classic view in the menu > Administrive Tools icon > click the Data Sources (ODBC) icon
18] After that a new window should popup, click the System DSN Tab> click the add button, scroll down to the last option "SQL Server" click finish
19] a New window should popup Name put in Bn_Game, leave description blank, server localhost or 127.0.0.1, click Next
20] Make sure the With Windows NT authentication using Network login ID is checked click next
21] Click Change the default database too, select Bn_Game click Next, and click Finish.
22] repeat 17 ~ 21 with dns names
Bn_Account
PY_Billing
23] To create a account, go back to your Enterprise manager, click the Bn_Game Database > click tables select the "Pangya_Member_Info" table right click > Open table > return all rolls > select all the accounts in the database > delete them all ( selecting them all )
Create a new account ( it's pretty simple after that ) make the "First Set" is 0 and tutorial is 1 save, close enterprise manager
( Fixed it thanks to Tibalt )
24] Go to your Pangya Server Files, Open the servers
1] AuthServer
2] LoginServer
3] RankServer ( Fix is at the bottom of the post. )
4] GameServer
( when each is done loading type in "start" in the command promp ( without the " " ) and click enter )
25] Tada You have made your first pangya server!!
QUOTE
:: Client :: UPDATED !!
1] Install the Client in C:\Program Files\
2] Run, Run.reg ( edit the location of the Files in the run.reg ( open it with notepad to do so, ONLY if you dont use a C: drive )
3] Open the ProjectG.exe in your favorite HEX Editor, search for 127.0.0.1
4] Change all the IP's around it ( it should start with 172.*.*.* ( my server lol ))
5] After changing every IP go to the end of each IP, and HEX in 00 00 00 if the "." arn't 00 or if you have extra numbers
6] Run ProjectG.exe ( no need for -babo anymore ^^ )
7] Login and play!
QUOTE
:: Web Manager Translated / Uptodate
http://legacygamers.deltaanime.net/Pangya/...a%20Website.rar
:: Web Manager Cookie Bug Fix ::
http://legacygamers.deltaanime.net/Pangya/WBMNGRfix.rar
Thanks to Twillight
:: Addon for the Web Manager ::
http://legacygamers.deltaanime.net/Pangya/uonline.rar
Once again Thanks to Twillight :P
:: Fixes ::
QUOTE
:: Ranking Server ::
1] Open up rankserver.ini, Change RegionEvent = on to off, Set DBDSN to bn_game ( I think it was default just making sure ) set webDBDSN to bn_game ( WebDBDSN is for the Pangya website ( not needed but maybe in the future ) Set RegionDBDSN to bn_game ( the RegionDB ( Im building it ) is under contruction, i'll release it later ))
2] Open the server, type in buildrank, and there ya go
QUOTE
:: Wipping Your PangYa Database ::
USE Bn_Account
TRUNCATE table tbl_game_account
TRUNCATE table tmp_user_id
USE Bn_Game
TRUNCATE table Pangya_character_Information
TRUNCATE table pangya_daily_logincount
TRUNCATE table pangya_friend
TRUNCATE table pangya_Friend_Note
TRUNCATE table Pangya_Gift_Table
TRUNCATE table pangya_help_desc
TRUNCATE table pangya_item_warehouse
TRUNCATE table pangya_MacAddress_id
TRUNCATE table pangya_member_info
TRUNCATE table pangya_monthly_Logincount
TRUNCATE table pangya_map_statistics
TRUNCATE table pangya_nick_history
TRUNCATE table pangya_notice_list
TRUNCATE table pangya_server_history
TRUNCATE table pangya_title
TRUNCATE table pangya_Trophy_Stat
TRUNCATE table pangya_user_equip
TRUNCATE table pangya_User_information
TRUNCATE table pangya_user_ladder
TRUNCATE table pangya_user_statistics
TRUNCATE table PY_Nick_Log
USE PY_Billing
TRUNCATE table BX_TG_APPLYINFO
TRUNCATE table BX_TG_USERINFO
QUOTE
:: Adding Kooh to your server ::
1. Goto Pangya_Item_TypeList table (SQL Manager) -> Open Table -> Return all rows ->
Click SQL in toolbar menu and replace this command :
INSERT INTO Pangya_Item_TypeList (TypeId, Name, Icon, Price) VALUES(67108869, 'Kooh','e_def', 29000)
then click '!' in toolbar menu.
2. Right Click on 'Stored Procedures' -> Click 'New Stored Procedure...' then replace all text to textbox area :
CREATE Proc AddKoohAndItemTo
@userid varchar(32)
as
DECLARE @UID int
select @UID = UID from Pangya_Member_Info where userid = @userid
IF @UID > 0
BEGIN
INSERT INTO PangYa_Character_Information (uid, typeid) VALUES(@UID,67108869)
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID, 135544832, 1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID, 135544833, 1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID, 135544834, 1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID, 135569408, 1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID, 135569409, 1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID, 135585792, 1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID, 135585793, 1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID, 135585794, 1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID, 135634944, 1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID, 135634945, 1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID, 135528449, 1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID, 135561217, 1, getdate());
RETURN
END
GO
3. Go to sql command to execute procedure name 'AddKoohAndItemTo' with parameter userid :
example : AddKoohAndItemTo 'yourloginname'
then click '!'
QUOTE
:: Make Skin and Ball to Pangya_Item_Typelist table. ::
INSERT INTO Pangya_Item_TypeList (TypeId, Name, Price) VALUES(952107015,'Green Bag Slot',5000)
INSERT INTO Pangya_Item_TypeList (TypeId, Name, Price) VALUES(952107014,'Blue Bag Slot',5)
INSERT INTO Pangya_Item_TypeList (TypeId, Name, Price) VALUES(952107013,'Pink Bag Slot',5)
INSERT INTO Pangya_Item_TypeList (TypeId, Name, Price) VALUES(947912722,'Lolo Sticker',9)
INSERT INTO Pangya_Item_TypeList (TypeId, Name, Price) VALUES(947912721,'Pipin Sticker',9)
INSERT INTO Pangya_Item_TypeList (TypeId, Name, Price) VALUES(947912720,'Tiki Sticker',9)
INSERT INTO Pangya_Item_TypeList (TypeId, Name, Price) VALUES(947912719,'Titang Boo Sticker',9)
INSERT INTO Pangya_Item_TypeList (TypeId, Name, Price) VALUES(943718411,'Flower Garden Frame',5)
INSERT INTO Pangya_Item_TypeList (TypeId, Name, Price) VALUES(943718410,'Green Water Drop Frame',7)
INSERT INTO Pangya_Item_TypeList (TypeId, Name, Price) VALUES(943718409,'Pink Water Drop Frame',7)
INSERT INTO Pangya_Item_TypeList (TypeId, Name, Price) VALUES(943718408,'Tangled Bronze Frame',5)
INSERT INTO Pangya_Item_TypeList (TypeId, Name, Price) VALUES(939524103,'Green Tiki PangYa',7)
INSERT INTO Pangya_Item_TypeList (TypeId, Name, Price) VALUES(939524102,'Purple Tiki PangYa',7)
INSERT INTO Pangya_Item_TypeList (TypeId, Name, Price) VALUES(939524101,'Ivy Vines',5)
INSERT INTO Pangya_Item_TypeList (TypeId, Name, Price) VALUES(939524100,'The Best Rice',7)
INSERT INTO Pangya_Item_TypeList (TypeId, Name, Price) VALUES(335544330,'Chistmas Aztec (50)',12)
#----- Make Procedures to add Skin, Chistmas Ball, House Club -----
CREATE Proc AddSkinItemTo
@userid varchar(32)
as
DECLARE @UID int
select @UID = UID from Pangya_Member_Info where userid = @userid
IF @UID > 0
BEGIN
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID, 952107015, 1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID, 952107014, 1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID, 952107013, 1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID, 947912722, 1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID, 947912721, 1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID, 947912720, 1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID, 947912719, 1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID, 943718411, 1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID, 943718410, 1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID, 943718409, 1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID, 943718408, 1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID, 939524103, 1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID, 939524103, 1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID, 939524102, 1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID, 939524101, 1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID, 939524100, 1, getdate());
RETURN
END
GO
#----- Add Club and Status PWR,CTL,ACC,SPN,CRV -----
CREATE Proc AddHClubTo
@userid varchar(32)
as
DECLARE @UID int
select @UID = UID from Pangya_Member_Info where userid = @userid
IF @UID > 0
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate,C0,C1,C2,C3,C4) VALUES (@UID, 268435459, 1, getdate(), 3, 6, 4, 2, 2);
GO
#----- Add Chismas Aztech ball to player ------
CREATE Proc AddCMBallTo
@userid varchar(32),
@ball int
as
DECLARE @UID int
select @UID = UID from Pangya_Member_Info where userid = @userid
IF @UID > 0 and @ball > 0
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate,C0) VALUES (@UID, 335544330, 1, getdate(), @ball);
GO
#------ Example to use procedures -----
AddSkinItemTo 'yourloginname'
AddHClubTo 'yourloginname'
AddCMBallTo 'yourloginname', 100
Thanks to attagorn Again, very good job.
QUOTE
:: Hexing the Client Files for Private Server Usage
Target Version: 2.14c
Target IP: 192.168.0.1 / 127.0.0.1
Step 1. Unpacking ProjectG.exe with PEID(Attached)
Step 2. Open unpacked.exe from your HEX Editor such as UE32, HE
Step 3. Change IP's
[Auth Server]
FIND: 32 30 32 2E 31 30 2E 33 32 2E 32 31 - 202.10.32.21
CHANGE: 31 39 32 2E 31 36 38 2E 30 2E 31 00 - 192.168.0.1
If you change ip's to 127.0.0.1 than this is a code for it.
31 32 37 2E 30 2E 30 2E 31 00 00 00
[Login Server]
FIND: 32 31 31 2E 34 33 2E 31 39 34 2E 32 32 - 211.43.194.2
CHANGE: 31 39 32 2E 31 36 38 2E 30 2E 31 00 00 - 192.168.0.1
If you change ip's to 127.0.0.1 than this is a code for it.
31 32 37 2E 30 2E 30 2E 31 00 00 00 00
[Game Server]
FIND: 36 31 2E 33 33 2E 36 35 2E 31 36 31 - 61.33.65.161
CHANGE: 31 39 32 2E 31 36 38 2E 30 2E 31 00 - 192.168.0.1
If you change ip's to 127.0.0.1 than this is a code for it.
31 32 37 2E 30 2E 30 2E 31 00 00 00
Step 4. Change Client Version
FIND: 32 2E 31 34 63 5F 74 65 73 74 5F 30 30 - 2.14c_test_00
CHANGE: 32 2E 31 34 63 00 00 00 00 00 00 00 00 - 2.14c
Step 5. Disable Hack Shield
FIND: 8D50055783C9FF33C08BFAF2AEF7D1490F84
CHANGE: 8D50055783C9FF33C08BFAF2AEF7D14990E9
Step 6. Disable update routine
FIND: C0752353
CHANGE: C0EB2353
Step 7. Save and change file name from unpacked.exe to whatever you like such as ProjectG.exe or update.exe
Thanks to advenire
QUOTE
:: Web Rank ::
1. Create database Web
2. Create system DSN link from rankserver.ini:
WebDBDSN = rank
WebDBUser = yourdbuser
WebDBPassword = yourdbpasswd
3.Open Query Analyzer and select db Web
insert text from CreateTables.txt(attach) and run for create tables.
4. Enter "updaterank" in Rankserver window for filling the tables.
5. Use asp scripts for stats (attach)
Have Fun.
- Attachment: http://forum.ragezone.com/attachments/2330...ar?d=1139083106
Thanks to Twillight.
QUOTE
:: Optional - Setting up IIS And PangYa Web Manager ::
- Firt you must have IIS (Internet Information Services) installed on your PC (IIS can you get at WinXP CD Installation.)
- You must have Pangya Web Manager Pack (Find your self at this forum).
1. Delete all file on "wwwroot" folder.
Where you can find these folder ?
C:\Inetpub\wwwroot
2. Extrack your pangya web manager to wwwroot folder.
3. Open "Config.asp" with your fav. text editor (ex. notepad)
you can find :
SAPassword="??" <-- fill ?? with your MSSQL password
ServerName="??" <-- fill ?? with your Server Name
GivePangAtReg="1000" <-- config for add "Pang" for a new user.
GiveCookieAtReg="50" <-- config for add "Cookie" for a new user.
CookieExchangeRate="1000" <-- config how much pang needed for 1 Cookie (Im not sure about this :P)
edit and save !
4. Go to IIS control panel ! (Control Panel> Administrative Tools > Internet Information Services !
Left klick! your "website" > properties !
5. Go to "Home Directory" Tab, on Execute Permision change to "Scripts Only" (I think these config who makes asp file cannot execute by IIS, first I have error on pangya web manager, but after I change this config to Scripts Only, my pangya web manager can work
6. Testing
7. on your fav. Browser (IE) go to addres //localhost or //(your IP)
8. Trata!!! Wellcome to -Pangya Friendly Server
If you still have error, post again here
sorry for my bad English
Thanks to neo151285
:: EXP Changing :: - NOT SURE IF ITS WORKING.
CREATE Proc ProcUpdatePang
@UID int,
@Pang int
as
Update pangya_user_statistics set pang = @Pang *3 where uid = @UID
GO
CREATE proc ProcUpdateUserStatistics
@UID int,
@drive int,
@putt int,
@playtime int,
@longest real,
@distance int,
@pangya int,
@hole int,
@TeamHole int,
@holeinone int,
@ob int,
@bunker int,
@fairway int,
@Albatross int,
@holein int,
@pang int,
@timeout int,
@game_level smallint,
@game_point smallint,
@PuttIn int,
@LongestPuttIn real,
@LongestChipIn real,
@GameCount int,
@DisconnectGames int,
@wTeamWin int,
@wTeamGames int,
@LadderPoint int,
@LadderWin int,
@LadderLose int,
@LadderDraw int,
@ComboCount smallint,
@MaxComboCount smallint,
@NoMannerGameCount int,
@TotalScore int,
@BestScore0 smallint,
@BestScore1 smallint,
@BestScore2 smallint,
@BestScore3 smallint,
@ShotTime int,
@MaxPang0 int,
@MaxPang1 int,
@MaxPang2 int,
@MaxPang3 int
as
update PangYa_User_Statistics
set drive = @drive,
putt = @putt ,
playtime = @playtime,
longest = @longest,
distance = @distance,
pangya = @pangya,
hole = @hole ,
TeamHole = @TeamHole,
holeinone = @holeinone,
ob = @ob,
bunker = @bunker,
fairway = @fairway,
Albatross = @Albatross,
holein = @holein,
pang = @pang * 3,
timeout = @timeout,
game_level= @game_level ,
game_point = @game_point,
PuttIn = @PuttIn,
LongestPuttIn = @LongestPuttIn,
LongestChipIn = @LongestChipIn,
NoMannerGameCount = @NoMannerGameCount,
GameCount = @GameCount,
DisconnectGames = @DisconnectGames,
wTeamWin = @wTeamWin,
wTeamGames = @wTeamGames,
LadderPoint = @LadderPoint,
LadderWin = @LadderWin,
LadderLose = @LadderLose,
LadderDraw = @LadderDraw,
ComboCount = @ComboCount,
MaxComboCount = @MaxComboCount,
TotalScore = @TotalScore,
BestScore0 = @BestScore0,
BestScore1 = @BestScore1,
BestScore2 = @BestScore2,
BestScore3 = @BestScore3,
ShotTime = @ShotTime,
MaxPang0 = @MaxPang0,
MaxPang1 = @MaxPang1,
MaxPang2 = @MaxPang2,
MaxPang3 = @MaxPang3
where UID = @UID
GO
CREATE proc ProcUpdateUserLevel
@UID int,
@game_level smallint,
@game_point smallint
as
update PangYa_User_Statistics set game_level= @game_level , game_point = @game_point * 100
where UID = @UID
GO
thanks to iostream.
так же клиент можно скачать тут:
You can download by bittorrent. PangyaIndonesia+Patch
In link
http://www.mininova.org/tor/129459
You can download program bittorrent in link.
http://www.bitcomet.com/doc/download.htm
Обязательно указание:
http://community.livejournal.com/ragnaforce/