Pangya Season 4.9 Server Files and Database

[hh23162378]

May I here there is no way to read the channel to obtain channel information
May I ask how to resolve ~ attached to the two pictures greatly help please
thx

Went to the game server log that does occur, how to solve this problem
[E_ODBC] ErrCode(42000) ErrMsg([Microsoft][ODBC SQL Server Driver][SQL Server]找不到預存程序 'dbo.USP_CHAR_EQUIP_LOAD_S4'。)
2010-12-16 00:11:23 107 Pang-CB Server 1 [F_QUERY] LastSuccQuery(exec dbo.ProcGetUserInfo_th 2), CurrQuery({ call dbo.USP_CHAR_EQUIP_LOAD_S4 (2) })
2010-12-16 00:11:23 102 Pang-CB Server 2 LOGIN QUERY REPEAT TRY(CMD:7)(ID:test)
2010-12-16 00:11:23 107 Pang-CB Server 1 [E_ODBC] ErrCode(42000) ErrMsg([Microsoft][ODBC SQL Server Driver][SQL Server]找不到預存程序 'dbo.USP_CHAR_EQUIP_LOAD_S4'。)
2010-12-16 00:11:23 107 Pang-CB Server 1 [F_QUERY] LastSuccQuery({ call dbo.USP_CARD_SPCL_AFTER (2) }), CurrQuery({ call dbo.USP_CHAR_EQUIP_LOAD_S4 (2) })
2010-12-16 00:11:23 102 Pang-CB Server 2 LOGIN QUERY REPEAT TRY(CMD:7)(ID:test)
2010-12-16 00:11:23 107 Pang-CB Server 1 [E_ODBC] ErrCode(42000) ErrMsg([Microsoft][ODBC SQL Server Driver][SQL Server]找不到預存程序 'dbo.USP_CHAR_EQUIP_LOAD_S4'。)
2010-12-16 00:11:23 107 Pang-CB Server 1 [F_QUERY] LastSuccQuery({ call dbo.USP_TUTORIAL_GET_STATUS (2) }), CurrQuery({ call dbo.USP_CHAR_EQUIP_LOAD_S4 (2) })
2010-12-16 00:11:23 102 Pang-CB Server 2 LOGIN QUERY REPEAT TRY(CMD:7)(ID:test)
2010-12-16 00:11:23 107 Pang-CB Server 1 [E_ODBC] ErrCode(42000) ErrMsg([Microsoft][ODBC SQL Server Driver][SQL Server]找不到預存程序 'dbo.USP_CHAR_EQUIP_LOAD_S4'。)
2010-12-16 00:11:23 107 Pang-CB Server 1 [F_QUERY] LastSuccQuery({ call dbo.USP_GetMapStatistics (2, 2) }), CurrQuery({ call dbo.USP_CHAR_EQUIP_LOAD_S4 (2) })
2010-12-16 00:11:23 102 Pang-CB Server 2 LOGIN QUERY REPEAT TRY(CMD:7)(ID:test)
2010-12-16 00:11:23 107 Pang-CB Server 1 [E_ODBC] ErrCode(42000) ErrMsg([Microsoft][ODBC SQL Server Driver][SQL Server]找不到預存程序 'dbo.USP_CHAR_EQUIP_LOAD_S4'。)
2010-12-16 00:11:23 107 Pang-CB Server 1 [F_QUERY] LastSuccQuery({ call dbo.USP_CARD_SPCL_AFTER (2) }), CurrQuery({ call dbo.USP_CHAR_EQUIP_LOAD_S4 (2) })
2010-12-16 00:11:23 102 Pang-CB Server 2 LOGIN QUERY REPEAT TRY(CMD:7)(ID:test)
2010-12-16 00:11:23 107 Pang-CB Server 1 [E_ODBC] ErrCode(42000) ErrMsg([Microsoft][ODBC SQL Server Driver][SQL Server]找不到預存程序 'dbo.USP_CHAR_EQUIP_LOAD_S4'。)
2010-12-16 00:11:23 107 Pang-CB Server 1 [F_QUERY] LastSuccQuery({ call dbo.USP_GetMapStatistics (2, 4) }), CurrQuery({ call dbo.USP_CHAR_EQUIP_LOAD_S4 (2) })
2010-12-16 00:11:23 102 Pang-CB Server 2 LOGIN QUERY REPEAT TRY(CMD:7)(ID:test)
2010-12-16 00:11:23 107 Pang-CB Server 1 [E_ODBC] ErrCode(42000) ErrMsg([Microsoft][ODBC SQL Server Driver][SQL Server]找不到預存程序 'dbo.USP_CHAR_EQUIP_LOAD_S4'。)
2010-12-16 00:11:23 107 Pang-CB Server 1 [F_QUERY] LastSuccQuery({ call dbo.USP_TUTORIAL_GET_STATUS (2) }), CurrQuery({ call dbo.USP_CHAR_EQUIP_LOAD_S4 (2) })
2010-12-16 00:11:23 102 Pang-CB Server 2 LOGIN QUERY REPEAT TRY(CMD:7)(ID:test)
2010-12-16 00:11:23 107 Pang-CB Server 1 [E_ODBC] ErrCode(42000) ErrMsg([Microsoft][ODBC SQL Server Driver][SQL Server]找不到預存程序 'dbo.USP_CHAR_EQUIP_LOAD_S4'。)
2010-12-16 00:11:23 107 Pang-CB Server 1 [F_QUERY] LastSuccQuery({ call dbo.USP_GetMapStatistics (2, 2) }), CurrQuery({ call dbo.USP_CHAR_EQUIP_LOAD_S4 (2) })
2010-12-16 00:11:23 102 Pang-CB Server 2 LOGIN QUERY REPEAT TRY(CMD:7)(ID:test)
2010-12-16 00:11:23 107 Pang-CB Server 1 [E_ODBC] ErrCode(42000) ErrMsg([Microsoft][ODBC SQL Server Driver][SQL Server]找不到預存程序 'dbo.USP_CHAR_EQUIP_LOAD_S4'。)
2010-12-16 00:11:23 107 Pang-CB Server 1 [F_QUERY] LastSuccQuery({ call dbo.USP_CARD_JOIN_AFTER (2) }), CurrQuery({ call dbo.USP_CHAR_EQUIP_LOAD_S4 (2) })
2010-12-16 00:11:23 102 Pang-CB Server 2 LOGIN QUERY REPEAT TRY(CMD:7)(ID:test)
2010-12-16 00:11:23 107 Pang-CB Server 1 [E_ODBC] ErrCode(42000) ErrMsg([Microsoft][ODBC SQL Server Driver][SQL Server]找不到預存程序 'dbo.USP_CHAR_EQUIP_LOAD_S4'。)
2010-12-16 00:11:23 107 Pang-CB Server 1 [F_QUERY] LastSuccQuery({ call dbo.USP_CARD_SPCL_AFTER (2) }), CurrQuery({ call dbo.USP_CHAR_EQUIP_LOAD_S4 (2) })
2010-12-16 00:11:23 100 Pang-CB Server 2 [A_FRAMEWORK] Invalid Connected User Disconnection UID(2)
2010-12-16 00:11:54 102 Pang-CB Server 2 OVERLAP LOGIN TASK
2010-12-16 00:11:54 107 Pang-CB Server 1 [E_ODBC] ErrCode(42000) ErrMsg([Microsoft][ODBC SQL Server Driver][SQL Server]找不到預存程序 'dbo.USP_CHAR_EQUIP_LOAD_S4'。)
2010-12-16 00:11:54 107 Pang-CB Server 1 [F_QUERY] LastSuccQuery(exec dbo.ProcGetUserInfo_th 1), CurrQuery({ call dbo.USP_CHAR_EQUIP_LOAD_S4 (1) })
2010-12-16 00:11:54 102 Pang-CB Server 2 LOGIN QUERY REPEAT TRY(CMD:7)(ID:hh23162378)
2010-12-16 00:11:54 107 Pang-CB Server 1 [E_ODBC] ErrCode(42000) ErrMsg([Microsoft][ODBC SQL Server Driver][SQL Server]找不到預存程序 'dbo.USP_CHAR_EQUIP_LOAD_S4'。)
2010-12-16 00:11:54 107 Pang-CB Server 1 [F_QUERY] LastSuccQuery({ call dbo.USP_TUTORIAL_GET_STATUS (1) }), CurrQuery({ call dbo.USP_CHAR_EQUIP_LOAD_S4 (1) })
2010-12-16 00:11:54 102 Pang-CB Server 2 LOGIN QUERY REPEAT TRY(CMD:7)(ID:hh23162378)
2010-12-16 00:11:54 107 Pang-CB Server 1 [E_ODBC] ErrCode(42000) ErrMsg([Microsoft][ODBC SQL Server Driver][SQL Server]找不到預存程序 'dbo.USP_CHAR_EQUIP_LOAD_S4'。)
2010-12-16 00:11:54 107 Pang-CB Server 1 [F_QUERY] LastSuccQuery({ call dbo.USP_GetMapStatistics (1, 2) }), CurrQuery({ call dbo.USP_CHAR_EQUIP_LOAD_S4 (1) })
2010-12-16 00:11:54 102 Pang-CB Server 2 LOGIN QUERY REPEAT TRY(CMD:7)(ID:hh23162378)
2010-12-16 00:11:54 107 Pang-CB Server 1 [E_ODBC] ErrCode(42000) ErrMsg([Microsoft][ODBC SQL Server Driver][SQL Server]找不到預存程序 'dbo.USP_CHAR_EQUIP_LOAD_S4'。)
2010-12-16 00:11:54 107 Pang-CB Server 1 [F_QUERY] LastSuccQuery({ call dbo.USP_GetMapStatistics (1, 3) }), CurrQuery({ call dbo.USP_CHAR_EQUIP_LOAD_S4 (1) })
2010-12-16 00:11:54 102 Pang-CB Server 2 LOGIN QUERY REPEAT TRY(CMD:7)(ID:hh23162378)
2010-12-16 00:11:54 107 Pang-CB Server 1 [E_ODBC] ErrCode(42000) ErrMsg([Microsoft][ODBC SQL Server Driver][SQL Server]找不到預存程序 'dbo.USP_CHAR_EQUIP_LOAD_S4'。)
2010-12-16 00:11:54 107 Pang-CB Server 1 [F_QUERY] LastSuccQuery({ call dbo.USP_GetMapStatistics (1, 4) }), CurrQuery({ call dbo.USP_CHAR_EQUIP_LOAD_S4 (1) })
2010-12-16 00:11:54 102 Pang-CB Server 2 LOGIN QUERY REPEAT TRY(CMD:7)(ID:hh23162378)
2010-12-16 00:11:54 107 Pang-CB Server 1 [E_ODBC] ErrCode(42000) ErrMsg([Microsoft][ODBC SQL Server Driver][SQL Server]找不到預存程序 'dbo.USP_CHAR_EQUIP_LOAD_S4'。)
2010-12-16 00:11:54 107 Pang-CB Server 1 [F_QUERY] LastSuccQuery({ call dbo.USP_CARD_JOIN_AFTER (1) }), CurrQuery({ call dbo.USP_CHAR_EQUIP_LOAD_S4 (1) })
2010-12-16 00:11:54 102 Pang-CB Server 2 LOGIN QUERY REPEAT TRY(CMD:7)(ID:hh23162378)
2010-12-16 00:11:54 107 Pang-CB Server 1 [E_ODBC] ErrCode(42000) ErrMsg([Microsoft][ODBC SQL Server Driver][SQL Server]找不到預存程序 'dbo.USP_CHAR_EQUIP_LOAD_S4'。)
2010-12-16 00:11:54 107 Pang-CB Server 1 [F_QUERY] LastSuccQuery({ call dbo.USP_TUTORIAL_GET_STATUS (1) }), CurrQuery({ call dbo.USP_CHAR_EQUIP_LOAD_S4 (1) })
2010-12-16 00:11:54 102 Pang-CB Server 2 LOGIN QUERY REPEAT TRY(CMD:7)(ID:hh23162378)
2010-12-16 00:11:54 107 Pang-CB Server 1 [E_ODBC] ErrCode(42000) ErrMsg([Microsoft][ODBC SQL Server Driver][SQL Server]找不到預存程序 'dbo.USP_CHAR_EQUIP_LOAD_S4'。)
2010-12-16 00:11:54 107 Pang-CB Server 1 [F_QUERY] LastSuccQuery({ call dbo.USP_GetMapStatistics (1, 2) }), CurrQuery({ call dbo.USP_CHAR_EQUIP_LOAD_S4 (1) })
2010-12-16 00:11:54 102 Pang-CB Server 2 LOGIN QUERY REPEAT TRY(CMD:7)(ID:hh23162378)
2010-12-16 00:11:54 107 Pang-CB Server 1 [E_ODBC] ErrCode(42000) ErrMsg([Microsoft][ODBC SQL Server Driver][SQL Server]找不到預存程序 'dbo.USP_CHAR_EQUIP_LOAD_S4'。)
2010-12-16 00:11:54 107 Pang-CB Server 1 [F_QUERY] LastSuccQuery({ call dbo.USP_GetMapStatistics (1, 3) }), CurrQuery({ call dbo.USP_CHAR_EQUIP_LOAD_S4 (1) })
2010-12-16 00:11:54 102 Pang-CB Server 2 LOGIN QUERY REPEAT TRY(CMD:7)(ID:hh23162378)
2010-12-16 00:11:54 107 Pang-CB Server 1 [E_ODBC] ErrCode(42000) ErrMsg([Microsoft][ODBC SQL Server Driver][SQL Server]找不到預存程序 'dbo.USP_CHAR_EQUIP_LOAD_S4'。)
2010-12-16 00:11:54 107 Pang-CB Server 1 [F_QUERY] LastSuccQuery({ call dbo.USP_GetMapStatistics (1, 4) }), CurrQuery({ call dbo.USP_CHAR_EQUIP_LOAD_S4 (1) })
2010-12-16 00:11:55 100 Pang-CB Server 2 [A_FRAMEWORK] Invalid Connected User Disconnection UID(1)

 

[o800920]

@hh23162378
你少了dbo.USP_CHAR_EQUIP_LOAD_S4 去前面找找吧他們有貼

 

[outlawzzbr]

all the item can't buy??

I can only buy cards

 

[hh23162378]

May I ask how to solve this problem to?? thx

2010-12-16 02:51:09 107 Pang-CB Server 1 [DB PROFILE ODBC GET RESULT] ThreadNo (5) 1123ms [exec dbo.ProcGetPreviouosServerCmd 20201, 24]
2010-12-16 02:51:09 107 Pang-CB Server 1 [DB PROFILE METHOD] ThreadNo (5) 1123ms (QueryTime 0ms) [Diff: 1123ms] [exec dbo.ProcGetPreviouosServerCmd 20201, 24]
2010-12-16 02:51:09 107 Pang-CB Server 1 [DB PROFILE COMMAND] ThreadNo (5) 1123ms CMD [CMD_REQUEST_PREVIOUS_SERVER_CONFIGURE (166)]
2010-12-16 02:51:09 107 Pang-CB Server 1 [DB PROFILE QUEUE SIZE] ThreadNo (5) 1123ms Size (1 -> 1) CMD [CMD_REQUEST_PREVIOUS_SERVER_CONFIGURE (166)]
2010-12-16 02:51:09 107 Pang-CB Server 1 [DB PROFILE ODBC GET RESULT] ThreadNo (0) 1248ms [{call dbo.USP_USER_LOBBY (0, 20201, 0, 0, 1, 2)}]
2010-12-16 02:51:09 107 Pang-CB Server 1 [DB PROFILE METHOD] ThreadNo (0) 1248ms (QueryTime 125ms) [Diff: 1123ms] [{call dbo.USP_USER_LOBBY (0, 20201, 0, 0, 1, 2)}]
2010-12-16 02:51:09 107 Pang-CB Server 1 [DB PROFILE COMMAND] ThreadNo (0) 1248ms CMD [CmdUpdateUserPlace (0)]
2010-12-16 02:51:09 107 Pang-CB Server 1 [DB PROFILE QUEUE SIZE] ThreadNo (0) 1248ms Size (1 -> 2) CMD [CmdUpdateUserPlace (0)]
2010-12-16 02:51:09 102 Pang-CB Server 2 GHOST DATA VERSION: 1000

 

[G0dzilla2000]

Hello I am full of doubts here.
I'll post some link's and if someone can look and say what's wrong with me since I already thank you ...

Ok well did you try running the Bootstrapper that tsukasa posted earlier in the forum? and for the filegroup error, go into th Pangya_S4_TH properties click file groups and add the 4 or so groups it says are missing

@hh23162378 did you add the databases in the Data sources (ODCB) through windows?

---------- Post added at 08:42 PM ---------- Previous post was at 07:11 PM ----------

When editing the .iff files do you just put them back into the Pangya_TH.iff? or do you also put it in the pangya_th_28102010.iff as well?

Or do i have to put it into a whole new .pak file?

And do they go in both the Pangya_TEST/Login and Pangya_TEST/Py_GameServer#01

cause im having trouble getting items like arins fairy wings or putting special clubs into the shop.

 

[mikumiku]

EDIT: Disregard what I put here earlier. For some reason, the maxuser was set really low. Don't remember doing that at any point.

In any case, I'm getting that same problem other people had where you click on the server, and kinda just hangs. I know for sure that was talked about, so I'll just skim through the thread again.

EDIT2: Okay uh... Server's disappearing and channels not showing up were issues that were addressed and fixed, but I didn't actually see anything about servers just hanging (showing the loading bar, but not actually loading channels). What do I do here?

 

[kaokoaoo]

Please someone help me? I'm the last step, just get presciso
add cookies, already got the rest.

PLEASE!!

 

[chiosin2]

@mikumiku Just take a look at your logs usually it shows errors like this

[E_"something here"] then shows you what stored procedure isn't functioning or you might not have added it yet. the basics are all in the thread i made if your unsure just execute all of it again and there you go ^^

 

[mikumiku]

@mikumiku Just take a look at your logs usually it shows errors like this

[E_"something here"] then shows you what stored procedure isn't functioning or you might not have added it yet. the basics are all in the thread i made if your unsure just execute all of it again and there you go ^^

I'm looking at the gameserver logs as I click on the server... I don't see any [E_xxxxxx] in the logs. I see [DB PROFILE CONNECT], [DB PROFILE ODBC GET RESULT], and [DB PROFILE METHOD] repeated for different procedures that are loaded, but that's it.

 

[G0dzilla2000]

Does anyone know of a way, that allows friends to connect? whether is LAN or through the internet im not picky, but id prefer through the internet if its free -_-

 

[chiosin2]

@ mikumiku then i can't help you what your saying normally happens... if there's no errors there's no problems.. it's that easy.

 

[mikumiku]

So I've got some real grunt work to do this time, huh?
I hope it's something easy so I don't have to rely on this forum so much.

 

[BoUrnE]

Ok well did you try running the Bootstrapper that tsukasa posted earlier in the forum? and for the filegroup error, go into th Pangya_S4_TH properties click file groups and add the 4 or so groups it says are missing

@hh23162378 did you add the databases in the Data sources (ODCB) through windows?

---------- Post added at 08:42 PM ---------- Previous post was at 07:11 PM ----------

When editing the .iff files do you just put them back into the Pangya_TH.iff? or do you also put it in the pangya_th_28102010.iff as well?

Or do i have to put it into a whole new .pak file?

And do they go in both the Pangya_TEST/Login and Pangya_TEST/Py_GameServer#01

cause im having trouble getting items like arins fairy wings or putting special clubs into the shop.

os 4 grupos são esses:
Pangya_S4_TH_gLog
Pangya_S4_Item
Pangya_S4_Mail
Pangya_S4_TH_Card
ok? já estão criados.
por favor como corrijo isso?

 

[mikumiku]

Go in table Pangya_Server_Config
Server version = 1.00
Client Version = 582.05 (or you version if you didn't updated to 582.05)

Need to confirm something, as I'm pretty much running blind, here (still complete newb to SQL). I go into the Pangya_Server_Config table, and am I supposed to edit the 'Default Value or Binding' under 'General' in 'Colum Properties', right? Or am I missing something?

EDIT: Going through the older files in the thread, I ran the 582.04 to 582.05 patcher... and the official TH update patcher now says 583.01... am I going to need to switch to that, or is it just lying to me?

 

[outlawzzbr]

Somebody help me? I did everything right yet still can not create rooms.

:*:

 

[G0dzilla2000]

Somebody help me? I did everything right yet still can not create rooms.

:*:

Hey you gotta flip the server version and client version
soooo

Server version = 1.00
Client version= 582.05

and BTW how did you get the Special club set?

@MikuMiku you need to (in mssql 2008at least) right click the Pangya_Server_Config table and what i did was chose "edit top 200 rows" and then 2 boxes pop up and you enter the information in there, and i beleive you should make it

Server version= 1.00
Client version= 583.01

then Hex the projectg.exe to 583.01

 

[mikumiku]

Somebody help me? I did everything right yet still can not create rooms.

:*:

Switch the values for server and client version. You had them mixed up.

On a related note, I was able to fix the room-making problem on my side thanks to this post. I also had to use the 583.01 version number (This should not apply to you, outlawzzbr, unless your official TH update patcher is also on the same version number). Now I just need to change the Item Shop list to have all the items listed in the query that jhon posted, and edit my pang, then I'm set!

P.S. Where can I find/Is it possible to edit the PSQ character animation commands?

EDIT: @G0dzilla2000; Aw, you beat me to it. I was still in reply mode when you posted that. But yeah, like I just said, it's fixed now. I'm using MSSQL '05, by the way.

 

[G0dzilla2000]

Now I just need to change the Item Shop list to have all the items listed in the query that jhon posted, and edit my pang, then I'm set!

Where do you edit the Item shop list?

 

[Mouquette]

Hello everyone

Good job for all work you did

Just asking if someone know a tutorial to make a pangya server. I didn't find something like this on Internet.

Please someone can help me ?
I'll be able to help you in the database, I have some contact who knows database and can help me.

I just need to know all things before database, and how to install and test pangya server and client.

 

[Tsukasa]

Where do you edit the Item shop list?

Editing shop items (like in: the items displayed in the shop) requires you to edit the appropriate IFF file and store it in the login server, game server directory, update your ITEM_TYPELIST table with the new prices and put the file in a pak for use with your local client.

Hello everyone

Good job for all work you did

Just asking if someone know a tutorial to make a pangya server. I didn't find something like this on Internet.

Please someone can help me ?
I'll be able to help you in the database, I have some contact who knows database and can help me.

I just need to know all things before database, and how to install and test pangya server and client.

Read the thread. It's long but it answers all the questions you could possibly have. Or, crazy idea, read the thread and write a tutorial yourself