-
2 Attachment(s)
Pangya Season 4.9 Server Files and Database
Hi Ragezone,
Here you can find the Pangya Season 4.9 Server Files and Database , for the Server you need the Thai Client from Ini3
-> PangYa : ŹẺΌҫ
But its needs more as this client , you will see it ;)
Please read the Rules !!!
Password:
~Noah~
Mirrors
Picture/s:
Attachment 82547
Running Servers
Attachment 82541
Rules for the use of this Files:
1. I don't give any Support
2. It isn't allowed to create new Mirror (Send me a PN if you want a new Mirror)
3. NO Flame or Spam Posts
Credits
All Credits goes to
~Noah~
Thanks for Reading :thumbup1:
-
Re: Pangya Season 4.9 Server Files and Database
ok you give up and release them o___O not really cool XD
ppl will be happy
-
Re: Pangya Season 4.9 Server Files and Database
very coll *--------------*
-
Re: Pangya Season 4.9 Server Files and Database
Alternate client download, since INI3's servers are pretty slow...
Partial English translation for 582.04:
-
Re: Pangya Season 4.9 Server Files and Database
Quote:
Originally Posted by
Turion123456
Hi Ragezone,
Here you can find the Pangya Season 4.9 Server Files and Database , for the Server you need the Thai Client from Ini3
-> PangYa : ŹẺΌҫ
But its needs more as this client , you will see it ;)
Please read the Rules !!!
Password:
~Noah~
Mirrors
Picture/s:
Attachment 82547
Running Servers
Attachment 82541
Rules for the use of this Files:
1. I don't give any Support
2. It isn't allowed to create new Mirror (Send me a PN if you want a new Mirror)
3. NO Flame or Spam Posts
Credits
All Credits goes to
~Noah~
Thanks for Reading :thumbup1:
which sql what should I use? I tried with sql server 2000 but not working.
-
Re: Pangya Season 4.9 Server Files and Database
-
Re: Pangya Season 4.9 Server Files and Database
how to I put an account as game master?
-
Re: Pangya Season 4.9 Server Files and Database
Noah, can you get the missing parts of the database as some stored procedures are missing. The gameserver won't let me in after the account creation. I see the server and nothing happen when I click on it. Can you please post the missing procedures ?
Thx for the files :thumbup:
-
Re: Pangya Season 4.9 Server Files and Database
Quote:
Originally Posted by
bubbastic
Noah, can you get the missing parts of the database as some stored procedures are missing. The gameserver won't let me in after the account creation. I see the server and nothing happen when I click on it. Can you please post the missing procedures ?
Thx for the files :thumbup:
i have same problem :$:
-
Re: Pangya Season 4.9 Server Files and Database
-
Re: Pangya Season 4.9 Server Files and Database
-
Re: Pangya Season 4.9 Server Files and Database
Quote:
Originally Posted by
bubbastic
Great work Diovanne :thumbup1:
Can you share the corrected database with us please ?
Isn't hard. Good luck.
You just need to fix some syntaxes.
-
Re: Pangya Season 4.9 Server Files and Database
Quote:
Originally Posted by
Diovannel2
Isn't hard. Good luck.
You just need to fix some syntaxes.
:ehh: I fixed a lot of them already but can't enter in the server yet. I don't find what is wrong.
Login and account creation works then nothing
-
Re: Pangya Season 4.9 Server Files and Database
what content do you have ? all S4 ? can u add season 4.5 features ?
-
Re: Pangya Season 4.9 Server Files and Database
FFFF awesums... Finally a proper S4 server. Now... how to fix the DB...
-
Re: Pangya Season 4.9 Server Files and Database
Quote:
Originally Posted by
KS212
FFFF awesums... Finally a proper S4 server. Now... how to fix the DB...
You won't find any help here at the moment.
Only thing you can do is to install sql2005 and install the procedures yourself. Read the error messages and try to fix them. Or wait for someone who knows sql well to help.
-
Re: Pangya Season 4.9 Server Files and Database
Yeah. Well the server 'release' is quite recent... barely a week old. News hasn't widely spread so I say give it a bit of time. I'm trying to find the other needed stuff like gameguard removal for the client and how to bypass the patcher.
-
Re: Pangya Season 4.9 Server Files and Database
Someone try that DBs --> Databases <--
SeeYa!
PS: It needs the following things:
1- create an user called "Monk" in your SQL Server.
2- create the following databases:
ini3_py_account
INI3Bill_DB
Pangya_S4_TH
SeeYa!
-
Re: Pangya Season 4.9 Server Files and Database
Quote:
Originally Posted by
Monks666
Someone try that DBs -->
Databases <--
SeeYa!
PS: It needs the following things:
1- create an user called "Monk" in your SQL Server.
2- create the following databases:
ini3_py_account
INI3Bill_DB
Pangya_S4_TH
SeeYa!
Hello, I face problem with the databases, to create them in the sql I'll put in new detabase the name and the ok to restore more of an error: (
Could you help?
-
Re: Pangya Season 4.9 Server Files and Database
@ Liphe_Xd
1- You may not restore databases. You just might to use that. Just open it in SQL Server Management Studio.
2- You may use SQL Server 2005.
SeeYa!
-
Re: Pangya Season 4.9 Server Files and Database
Quote:
Originally Posted by
Monks666
@ Liphe_Xd
1- You may not restore databases. You just might to use that. Just open it in SQL Server Management Studio.
2- You may use SQL Server 2005.
SeeYa!
I ran the databases, Pangya_S4_TH enough errors in red, INI3_PY_ACCOUNT no errors, and Pangya_S4_TH with fewer errors.
I could run the login server without any errors.
gameserver no longer connects.
-
Re: Pangya Season 4.9 Server Files and Database
What do you guys use to bypass/remove Gameguard and allow the client to connect to another IP?
-
Re: Pangya Season 4.9 Server Files and Database
The login to the game cannot be done.
Login\log
CMD_REQUEST_LOGIN : ErrorCode 15
-
Re: Pangya Season 4.9 Server Files and Database
Quote:
Originally Posted by
KS212
What do you guys use to bypass/remove Gameguard and allow the client to connect to another IP?
i use ollydbg
EDIT: logged in successfully
http://i56.tinypic.com/24w924j.jpg
http://i51.tinypic.com/2d00ry8.jpg
Gameserver Almost Working :
http://i55.tinypic.com/2ylafe1.jpg
-
Re: Pangya Season 4.9 Server Files and Database
Hello everyone! Bring to you that does not have the ProjectG TH:
Unpacked
No-GG
Removed from the Loader GameGuard
GameGuard Fixed
IP: 127.0.0.1
Multi Client
Removed Error Message PAK
Removed Error Message ProjectG.exe
Removed Error Message GameGuard
Link:
http://download.adrive.com/public/vi...ed1d406dc.html
-
Re: Pangya Season 4.9 Server Files and Database
so how can i change ip use hex editor
-
Re: Pangya Season 4.9 Server Files and Database
Quote:
Originally Posted by
o800920
so how can i change ip use hex editor
download projectg provided that our friend up =)
-
Re: Pangya Season 4.9 Server Files and Database
I fixed the database as it much as it was possible and I can't select a channel. I think that with this database, we can't run the game.
Correct me if I'm wrong but I think it is impossible to run the game without the missing procedures. right ?
-
Re: Pangya Season 4.9 Server Files and Database
It really does not like entering the game server. The channels are not listed ...
= /
-
Re: Pangya Season 4.9 Server Files and Database
the server fully work for me! GM actions UCC design etc... and english translation.
but my Galaxy server is better because i can create special stuff and can have more control (like Bongdari shop by exemple)!
good luck everyone
http://i52.tinypic.com/2ytuqo3.jpg
-
Re: Pangya Season 4.9 Server Files and Database
good luck ? .... i don't need luck , the plan has worked. ;)
-
Re: Pangya Season 4.9 Server Files and Database
The guys who've gotten it working, can you share your fixed db's?
-
Re: Pangya Season 4.9 Server Files and Database
What plan ? o..O
Finding someone to patch the exe for you? XD
C'mon please. We'd like to make a server too
@ KZ212 : it is not a "fixed' database, he got the COMPLETE base from Noah!
-
Re: Pangya Season 4.9 Server Files and Database
i want some instruction on how to make one please?
-
Re: Pangya Season 4.9 Server Files and Database
Quote:
Originally Posted by
bubbastic
@ KZ212 : it is not a "fixed' database, he got the COMPLETE base from Noah!
Right, so basically unless he shares that database this won't work? What about that guy a couple posts back who also go it working? There are obviously some who have a working db.
Would be nice if they'd share it. Ah well, whatever really.
-
Re: Pangya Season 4.9 Server Files and Database
Quote:
Originally Posted by
Turion123456
good luck ? .... i don't need luck , the plan has worked. ;)
Ow I understand now XD! maybe I'll release what I have o_O! But I'm waiting for see your job for now.
-
Re: Pangya Season 4.9 Server Files and Database
Pardon my ignorance, but I have tried to analyze the database of season 1 .... to check the tables of channels ... but without success. I've tried everything so far and no more ideas ... anyone have ...?
-
Re: Pangya Season 4.9 Server Files and Database
Guess DBs need some tables or procedures that's missing...
I just beg for all those that have an 100% server to tell us what exactly the tables and procedures that's missing on DB...
If they don't tell it for us... what remains is wait for someone that makes it works and share...
SeeYa!
-
Re: Pangya Season 4.9 Server Files and Database
I said hello as I picked up Season 1 of the BD and analyzed and compared with some things season 4 ... and got this result .... attempts to load. Is an advance right?
PS: I think I've exhausted my ideas can help someone else? Reina Please?.... Thanks for all.
-
Re: Pangya Season 4.9 Server Files and Database
*checks back*
Wh0rders still wh0rding the DB? Yep, still being whores.
*leaves*
-
Re: Pangya Season 4.9 Server Files and Database
This is practically a gift so for those leechers out there that don't know how to make their own stuff GTFO! but if your a developer like all others here, you'll understand how long we've waited for this. So THANKS!]
EDIT: and btw hey hsreina! its me Bluemania from the hontoshado forums ^^ now i can test some of my items in this server. just need to know how to add items LoL!
-
Re: Pangya Season 4.9 Server Files and Database
Quote:
Originally Posted by
chiosin2
This is practically a gift so for those leechers out there that don't know how to make their own stuff GTFO! but if your a developer like all others here, you'll understand how long we've waited for this. So THANKS!]
Developper or not, you can't play with this database so you have 2 options : you ask for a complete version or you forget about it! :cool:
edit : and hmm it's not a gift (or poisened one) for leechers since the DB has been voluntary truncated before it was posted here. Otherwise ppl could NOT start the game
-
Re: Pangya Season 4.9 Server Files and Database
Quote:
Originally Posted by
chiosin2
This is practically a gift so for those leechers out there that don't know how to make their own stuff GTFO! but if your a developer like all others here, you'll understand how long we've waited for this. So THANKS!]
EDIT: and btw hey hsreina! its me Bluemania from the hontoshado forums ^^ now i can test some of my items in this server. just need to know how to add items LoL!
if you're developer you don't need this compiled server! I don't know what you mean by developper @___@
and for add items on this server you can use gm commands
or a gm_tool exist for do this kind of stuff.
-
Re: Pangya Season 4.9 Server Files and Database
I am what I am trying to work on hand, I'm not a developer. I'm trying everything I have available and within my reach. Unfortunately I do not have much capacity to begin at the beginning.
-
Re: Pangya Season 4.9 Server Files and Database
Quote:
Originally Posted by
fasa2008
I am what I am trying to work on hand, I'm not a developer. I'm trying everything I have available and within my reach. Unfortunately I do not have much capacity to begin at the beginning.
Unfortunately, I'm in the same situation as you
-
Re: Pangya Season 4.9 Server Files and Database
Quote:
Originally Posted by
hontoshadow
if you're developer you don't need this compiled server! I don't know what you mean by developper @___@
and for add items on this server you can use gm commands
or a gm_tool exist for do this kind of stuff.
i Wasn't starting flaming or anything. but yeah, i agree i'd rather have the source than a compiled version. but making one won't be so easy since you need a lot of time and that i don't have. that's why i said this was a gift. i'm sorry if it all came out wrong.
And i meant creating new items not adding one in the account. we already talked about this HSreina. Editing the clubset won't change the stats right? anyways i'm sorry if i offended anyone.:*:
-
Re: Pangya Season 4.9 Server Files and Database
Quote:
Originally Posted by
chiosin2
i Wasn't starting flaming or anything. but yeah, i agree i'd rather have the source than a compiled version. but making one won't be so easy since you need a lot of time and that i don't have. that's why i said this was a gift. i'm sorry if it all came out wrong.
And i meant creating new items not adding one in the account. we already talked about this HSreina. Editing the clubset won't change the stats right? anyways i'm sorry if i offended anyone.:*:
Create, edit, delete items are easy things to do.
-
Re: Pangya Season 4.9 Server Files and Database
Quote:
Originally Posted by
Diovannel2
Create, edit, delete items are easy things to do.
looks like sharing more infos or the complete DB is much harder...
Putting an incomplete DB to have some ppl giving a helping hand and finaly just share with very few ppl, well thats not the spirit of the internet and of this forum.
lets face it:
my old Kr account is out of use.
my jp account: still on but can be ban anytime
my Eu account: serv is closing
dont have an account on pangya_th
pangya US sucks a lot.
the best way to keep on going with pangya is having a private serv and play it with some friends.
-
Re: Pangya Season 4.9 Server Files and Database
DBs please....? More fixed
-
Re: Pangya Season 4.9 Server Files and Database
Some people can share fix database please
-
Re: Pangya Season 4.9 Server Files and Database
-
Re: Pangya Season 4.9 Server Files and Database
-
Re: Pangya Season 4.9 Server Files and Database
nope... im still stuck @ where most people are... can't seem to see channels
-
Re: Pangya Season 4.9 Server Files and Database
some dbo has missing
Pang-CB Server 1 [E_ODBC] ErrCode(42000) ErrMsg([Microsoft][ODBC SQL Server Driver][SQL Server]Could not find stored procedure 'dbo.USP_TUTORIAL_GET_STATUS'.)
Pang-CB Server 1 [E_ODBC] ErrCode(42000) ErrMsg([Microsoft][ODBC SQL Server Driver][SQL Server]Could not find stored procedure 'dbo.USP_CARD_GET_LIST'.)
Pang-CB Server 1 [E_ODBC] ErrCode(42000) ErrMsg([Microsoft][ODBC SQL Server Driver][SQL Server]Could not find stored procedure 'dbo.USP_CHAR_EQUIP_LOAD_S4'.)
-
Re: Pangya Season 4.9 Server Files and Database
Quote:
Originally Posted by
darkknight
some dbo has missing
Pang-CB Server 1 [E_ODBC] ErrCode(42000) ErrMsg([Microsoft][ODBC SQL Server Driver][SQL Server]Could not find stored procedure 'dbo.USP_TUTORIAL_GET_STATUS'.)
Pang-CB Server 1 [E_ODBC] ErrCode(42000) ErrMsg([Microsoft][ODBC SQL Server Driver][SQL Server]Could not find stored procedure 'dbo.USP_CARD_GET_LIST'.)
Pang-CB Server 1 [E_ODBC] ErrCode(42000) ErrMsg([Microsoft][ODBC SQL Server Driver][SQL Server]Could not find stored procedure 'dbo.USP_CHAR_EQUIP_LOAD_S4'.)
Configure .INI Files ?
-
Re: Pangya Season 4.9 Server Files and Database
I open game server log
show error that I can't find stored procedure in Pangya_S4_TH.sql
-
1 Attachment(s)
Re: Pangya Season 4.9 Server Files and Database
i can connect to the server just fine, im having problems when creating a nick name...
-
Re: Pangya Season 4.9 Server Files and Database
Quote:
Originally Posted by
chiosin2
i can connect to the server just fine, im having problems when creating a nick name...
Use code credit by advance
Code:
USE [Pangya_S4_TH]
GO
/****** Object: StoredProcedure [dbo].[USP_NICKNAME_UPDATE] Script Date: 11/29/2010 18:42:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[USP_NICKNAME_UPDATE]
@x int,
@y varchar(20)
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
select 0
END
In database has missing StoredProcedure
USP_TUTORIAL_GET_STATUS
USP_CARD_GET_LIST
USP_CHAR_EQUIP_LOAD_S4
can't select gameserver chanal
-
Re: Pangya Season 4.9 Server Files and Database
Quote:
Originally Posted by
chiosin2
i can connect to the server just fine, im having problems when creating a nick name...
Try with more letters :P:
Chiosin can you share your .dat files so I can have text in english too please ?
Does anyone know GM commands like how to make rain, server up, server down, and so on?
And another question : where can we find ItemID references to add them in ITEMWAREHOUSE ?
Darkknight, with this db files here, you can't get better than that. You'll need a complete version but I think they don't share it because they plan to make a private server online soon
-
Re: Pangya Season 4.9 Server Files and Database
chiosin2 you can share backup database Pangya_S4_TH just work can select server
-
Re: Pangya Season 4.9 Server Files and Database
SO its useless to share this pangya server. OMG....
-
Re: Pangya Season 4.9 Server Files and Database
not imposible to complet server
-
Re: Pangya Season 4.9 Server Files and Database
for the .dat files i just used the files from ntreev, and changed some things in projectG_TH_NO_GG thanks fasa2008.
I Used Monk666's database for Pangya.. thats it.. download his DB
@darkknight i used the code but nothing works
i get this
Msg 208, Level 16, State 6, Procedure USP_NICKNAME_UPDATE, Line 10
Invalid object name 'dbo.USP_NICKNAME_UPDATE'.
-
Re: Pangya Season 4.9 Server Files and Database
Quote:
Originally Posted by
chiosin2
for the .dat files i just used the files from ntreev, and changed some things in projectG_TH_NO_GG thanks fasa2008.
I Used Monk666's database for Pangya.. thats it.. download his DB
@darkknight i used the code but nothing works
i get this
Msg 208, Level 16, State 6, Procedure USP_NICKNAME_UPDATE, Line 10
Invalid object name 'dbo.USP_NICKNAME_UPDATE'.
try this in a query window:
Quote:
USE [Pangya_S4_TH]
GO
DECLARE @return_value int
EXEC @return_value = [dbo].[USP_NICKNAME_UPDATE]
@UID = YOURIDHERE,
@NEWNICKNAME = N'YOUR NICKNAME HERE',
@GM = 1
SELECT 'Return Value' = @return_value
GO
-----
What did you change in projectg to get english language ?
-
Re: Pangya Season 4.9 Server Files and Database
To patch the game to English (at least partially) replace the files from the game's directory (make sure it's updated to the version from my initial post on page 1!) with these files:
Engrish Pangya
These files come straight from ntreev USA's (now SG Entertainment...) client. Since item descriptions are contained within the *.pak files we need to do some unpacking/editing later on... after getting the server to work :)
--
Just for your convenience: To alter the stored procedure it has to be created first.
Here's a full, somewhat working version of darkknight's query:
Code:
USE [Pangya_S4_TH]
GO
/****** Object: StoredProcedure [dbo].[USP_NICKNAME_UPDATE] Script Date: 11/30/2010 19:44:43 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[USP_NICKNAME_UPDATE]
@x int,
@y varchar(20)
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
select 0
END
GO
You can also copy the ProcUpdateNickname procedure (which this one seems to base on), it does the same but can also report back errors.
-
Re: Pangya Season 4.9 Server Files and Database
Unfortunately I am having problems in choosing the channel.
caught at this stage
-
Re: Pangya Season 4.9 Server Files and Database
Quote:
Originally Posted by
Tsukasa
To patch the game to English (at least partially) replace the files from the game's directory (make sure it's updated to the version from my initial post on page 1!) with these files:
Engrish Pangya
These files come straight from ntreev USA's (now SG Entertainment...) client. Since item descriptions are contained within the *.pak files we need to do some unpacking/editing later on... after getting the server to work :)
Thank you for that
I wish I could do that myself but I did not found any updated tutorial
-
Re: Pangya Season 4.9 Server Files and Database
you need pangya unpaker. tools are already provided here. so the only thing needed is your time.
-
Re: Pangya Season 4.9 Server Files and Database
Some body can create new StoredProcedure it missing when select Channel server
USP_TUTORIAL_GET_STATUS
USP_CARD_GET_LIST
USP_CHAR_EQUIP_LOAD_S4
-
Re: Pangya Season 4.9 Server Files and Database
Had this occurred,
prucedures unfortunately these are only possible to try to win them a complete Db.
Otherwise someone could tell me where or help me?
-
Re: Pangya Season 4.9 Server Files and Database
Need ProjectG.exe with IP 127.0.0.1. I always fail to unpack it....
-
Missing parts
Code:
USE [Pangya_S4_TH]
GO
/****** StoredProcedure [dbo].[USP_TUTORIAL_GET_STATUS] ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[USP_TUTORIAL_GET_STATUS] (
@UID INT
) AS
BEGIN
SET NOCOUNT ON
SELECT A.USER_LEVEL
,[QUEST] = SUM(A.STEP)
FROM DBO.TA_TUTORIAL_ACC A WITH (NOLOCK)
INNER JOIN
(
SELECT SEQ
FROM DBO.TD_TUTORIAL WITH (NOLOCK)
WHERE UID = @UID
GROUP BY SEQ
) B
ON A.SEQ = B.SEQ
GROUP BY A.USER_LEVEL
END
-
Re: Pangya Season 4.9 Server Files and Database
great,
Very good friend, had to make a small correction in the code, but nothing
beyond what has already been mentioned by you.
Thanks anyway ...
now I'm looking for the other two procedure
Edit:
I obtained an advance in the choice of channel, but still can not choose it. Lock in a way that does not allow me to continue =)
believe this is the path. =)
-
Re: Pangya Season 4.9 Server Files and Database
Quote:
Originally Posted by
gigok
Need ProjectG.exe with IP 127.0.0.1. I always fail to unpack it....
See this link for an already modified client. It requires the client version 582.04 or higher. If you get errors about nonexistent functions right when starting the client, you need to run the updater.
-
Re: Pangya Season 4.9 Server Files and Database
comands Gm season 4~
/giveitem [nick][typeid][num]
/notice [msg]
/identity [type]
/weather [type] 'fine', 'rain', 'snow', 'cloud'
/wind [spd][dir]
/destroy [num]
/disconnect [nick]
/kick [nick][op]
/close [nick]
/list
/channel [on/off]
/whisper [on/off]
/status
/command
/help [cmd]
-
Re: Pangya Season 4.9 Server Files and Database
where down the server pangya season 4?:drool:
-
Re: Pangya Season 4.9 Server Files and Database
Can someone help me change the exp rate and pang?
How do you define a GM?
-
Re: Pangya Season 4.9 Server Files and Database
Quote:
Originally Posted by
suneka
Can someone help me change the exp rate and pang?
How do you define a GM?
Does that mean you have a working version ?
-
Re: Pangya Season 4.9 Server Files and Database
great job bubbastic! thanks for that. i have a question.. will the client run even if the client is not included in the registry?
-
Found a new missing part
Code:
USE [Pangya_S4_TH]
GO
/****** StoredProcedure [dbo].[USP_CARD_LIST] ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROC [dbo].[USP_CARD_LIST] (
@UID INT
)
AS
BEGIN
SET NOCOUNT ON
SELECT UID
, CARD_TYPEID
, CARD_ITEMID
, CARD_TYPE
, QTY
, IS_USE_DT = 0
FROM DBO.TD_CARD_USRS WITH (NOLOCK)
WHERE UID = @UID
AND USE_YN = 'Y'
END
Please share a tutorial to patch projectg and remove GG and update thx
-
Re: Pangya Season 4.9 Server Files and Database
Perfect friend.
I see that you have all the queries to create the procedure.
Thanks again.
I'll try to get the tutorials you want.
-
Re: Pangya Season 4.9 Server Files and Database
Hello, could someone help me add GM to Server
Or some GM_Tool
Thanks
-
Re: Found a new missing part
Quote:
Originally Posted by
bubbastic
Code:
USE [Pangya_S4_TH]
GO
/****** StoredProcedure [dbo].[USP_CARD_LIST] ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROC [dbo].[USP_CARD_LIST] (
@UID INT
)
AS
BEGIN
SET NOCOUNT ON
SELECT UID
, CARD_TYPEID
, CARD_ITEMID
, CARD_TYPE
, QTY
, IS_USE_DT = 0
FROM DBO.TD_CARD_USRS WITH (NOLOCK)
WHERE UID = @UID
AND USE_YN = 'Y'
END
Please share a tutorial to patch projectg and remove GG and update thx
1º - Open ProjectG.exe for OllyDBG...
2º - Search for MOV EAX,262 >> replace MOV EAX,755.
3º - In the CreateProcessA function, search PUSH 1 >>> Modify "0".
4º - Save All Modifications....
5º - GG Removed...
-
Re: Found a new missing part
Quote:
Originally Posted by
fasa2008
1º - Open ProjectG.exe for OllyDBG...
2º - Search for MOV EAX,262 >> replace MOV EAX,755.
3º - In the CreateProcessA function, search PUSH 1 >>> Modify "0".
4º - Save All Modifications....
5º - GG Removed...
tyvm ;)
And how to remove update and setting client version ?
-
Re: Found a new missing part
Quote:
Originally Posted by
bubbastic
tyvm ;)
And how to remove update and setting client version ?
I've posted the second page of a topic ProjectG with everything removed and running ... The evening will remove some more errors. PAK..
PS: In GetcurrentProcessID function, just set aside the:
Ex: Modify JNZ for JMP = Update removed.
-
Re: Found a new missing part
Quote:
Originally Posted by
fasa2008
I've posted the second page of a topic ProjectG with everything removed and running ... The evening will remove some more errors. PAK..
PS: In GetcurrentProcessID function, just set aside the:
Ex: Modify JNZ for JMP = Update removed.
Not working T.T
I changed MOV EAX,262 to MOV EAX,755 (Assemble)
I changed JNZ to JMP in the 4 GetcurrentProcessID (Assemble)
copied to exe all mods
saved to file
and projectg is still asking for update T.T
Can someone please post a complete tutorial there? ===> TUTORIAL
So we can stay on topic and find infos easily :) ty
-
Re: Pangya Season 4.9 Server Files and Database
I have following error on gameserver console: Update Server State Query Failed
'-' but the procedure ProcUpdateServerState appears all fine o__O
-
Re: Pangya Season 4.9 Server Files and Database
-
Re: Pangya Season 4.9 Server Files and Database
Problem fixed channel =)
advance in the system
-
Re: Pangya Season 4.9 Server Files and Database
Quote:
Originally Posted by
sandro_adm
Problem fixed channel =)
advance in the system
what?
-
Re: Pangya Season 4.9 Server Files and Database
My joy did not last long =)
I could barely access the channel comes another problem
As the character was created directly in the database, just
now discovering a problem at the time of character creation.
Suggestion / request to fasa?
Could create a projectg that uses a. INI for
declaration of IP?
-
Re: Pangya Season 4.9 Server Files and Database
Seems we're getting some progress, nice. Are you guys all using the DB that monk uploaded earlier and just running the queries posted on the last few pages?
If not, can someone share the base db that's being used to get this far?
-
Re: Pangya Season 4.9 Server Files and Database
Quote:
Originally Posted by
KS212
Seems we're getting some progress, nice. Are you guys all using the DB that monk uploaded earlier and just running the queries posted on the last few pages?
If not, can someone share the base db that's being used to get this far?
I used the base on 1st page and got 2 more procedures that I posted here. It seems that there are a lot more procedures missing so be patient :). It's hard to get XD
-
Re: Pangya Season 4.9 Server Files and Database
Quote:
Originally Posted by
bubbastic
I used the base on 1st page and got 2 more procedures that I posted here. It seems that there are a lot more procedures missing so be patient :). It's hard to get XD
Hehe, I'm waiting, I'm waiting! I'm a nub at shit like this so just waiting for ppl like you who can work this sort of stuff out to do it. :drool:
-
Re: Pangya Season 4.9 Server Files and Database
Quote:
Originally Posted by
sandro_adm
My joy did not last long =)
I could barely access the channel comes another problem
As the character was created directly in the database, just
now discovering a problem at the time of character creation.
Suggestion / request to fasa?
Could create a projectg that uses a. INI for
declaration of IP?
Talk to Me ~ MP
-
Re: Pangya Season 4.9 Server Files and Database
Hello Ragezone ^^ i have fixed but are more things to fix ¬¬'
here some screenshots ^^
Channels list :ott:
http://img190.imageshack.us/img190/1881/69764522.jpg
In Channel :thumbup:
http://img408.imageshack.us/img408/6084/96709560.jpg
But i need fix some bugs for buy things and etc ^^
the blank character, club and caddie is because i edited db and put wrong item code XD
*Update
Now i fixed the buy items and bongdari shop ^^ i have good progress @_@ i think much things already work - Soon more screenshots
-
Re: Pangya Season 4.9 Server Files and Database
Quote:
Originally Posted by
fasa2008
Talk to Me ~ MP
Still not have permission to post MESSAGES private.
Able to create this kind of feature?
-
Re: Pangya Season 4.9 Server Files and Database
error when select server
2010-12-02 22:41:07 1 Pang-CB Server 7 [N_ITEM] TotalCNT : Parts(0), Clubset(1)
2010-12-02 22:41:07 1 Pang-CB Server -1 [N_LOGIN] LogInProcess : OUTPUT : GUID(10), isSuccess(1), Count(7), CmdID(16)
2010-12-02 22:41:07 1 Pang-CB Server -1 [N_LOGIN] LogInProcess : OUTPUT : GUID(10), isSuccess(1), Count(8), CmdID(13)
2010-12-02 22:41:07 1 Pang-CB Server -1 [N_LOGIN] LogInProcess : OUTPUT : GUID(10), isSuccess(1), Count(9), CmdID(4)
2010-12-02 22:41:07 1 Pang-CB Server 7 [N_CARD] Query { call dbo.USP_CARD_GET_LIST (7) }
2010-12-02 22:41:07 0 Pang-CB Server 1 [E_CARD] Query Fail : { call dbo.USP_CARD_GET_LIST (7) }
2010-12-02 22:41:07 1 Pang-CB Server -1 [N_LOGIN] LogInProcess : OUTPUT : GUID(10), isSuccess(1), Count(10), CmdID(17)
2010-12-02 22:41:07 1 Pang-CB Server -1 [N_LOGIN] LogInProcess : OUTPUT : GUID(10), isSuccess(1), Count(11), CmdID(11)
2010-12-02 22:41:07 1 Pang-CB Server -1 [N_LOGIN] LogInProcess : OUTPUT : GUID(10), isSuccess(1), Count(12), CmdID(3)
2010-12-02 22:41:07 1 Pang-CB Server -1 [N_LOGIN] LogInProcess : OUTPUT : GUID(10), isSuccess(1), Count(13), CmdID(9)
2010-12-02 22:41:07 1 Pang-CB Server -1 [N_LOGIN] LogInProcess : OUTPUT : GUID(10), isSuccess(1), Count(14), CmdID(15)
2010-12-02 22:41:07 0 Pang-CB Server 1 exec dbo.ProcGetCaddieInfo 7
2010-12-02 22:41:07 1 Pang-CB Server 7 [N_CARD] Query { call dbo.USP_CARD_GET_LIST (7) }
2010-12-02 22:41:07 0 Pang-CB Server 1 [E_CARD] Query Fail : { call dbo.USP_CARD_GET_LIST (7) }
2010-12-02 22:41:07 0 Pang-CB Server 1 exec dbo.ProcGetCaddieInfo 7
2010-12-02 22:41:07 1 Pang-CB Server -1 [N_LOGIN] LogInProcess : OUTPUT : GUID(10), isSuccess(1), Count(15), CmdID(14)
2010-12-02 22:41:07 1 Pang-CB Server 7 [N_CARD] Query { call dbo.USP_CARD_GET_LIST (7) }
2010-12-02 22:41:07 0 Pang-CB Server 1 [E_CARD] Query Fail : { call dbo.USP_CARD_GET_LIST (7) }
2010-12-02 22:41:07 1 Pang-CB Server 7 [N_LOGIN] Disconnect : Pang( 3000 )
-
Re: Pangya Season 4.9 Server Files and Database
Quote:
Originally Posted by
crashbufao
Now i fixed the buy items and bongdari shop ^^ i have good progress @_@ i think much things already work - Soon more screenshots
Nice ;)
Here a small list of items you can add in your warehouse :)
;Fairy wings(cecilia)
135145472
;Fairy wings (Nuri)
134309893
;Fairy wings (Arin)
135923712
;MYSTIC RING
1879113739
;Magical Clubs
268435468
Look at the IDs in AutoSelectEvent.ini ;)
some of them will give you elf ears XD
You can easily find Black Papel
-
Re: Pangya Season 4.9 Server Files and Database
Quote:
Originally Posted by
bubbastic
Nice ;)
Here a small list of items you can add in your warehouse :)
;Fairy wings(cecilia)
135145472
;Fairy wings (Nuri)
134309893
;Fairy wings (Arin)
135923712
;MYSTIC RING
1879113739
;Magical Clubs
268435468
Look at the IDs in AutoSelectEvent.ini ;)
some of them will give you elf ears XD
You can easily find Balck Papel
^^ thanx for help i already fixed shop... tested chatroom, tested sell on chatroom ... i think i can do all, now is only make tests... and tests... and tests XD