The problem is here:Originally Posted by chiosin2
dbo.USP_CHAR_EQUIP_LOAD_S4
Somebody help me ?
The problem is here:
dbo.USP_CHAR_EQUIP_LOAD_S4
Somebody help me ?
Last edited by outlawzzbr; 12-12-10 at 06:28 PM. Reason: ERROR
@outlawzzbr
Like i said re-run the CHAR_EQUIP_LOAD_S4 <<-- Create that stored procedure.. it should be okay then.
Re: Pangya Season 4.9 Server Files and Database
@chiosin2
PLEASE - Pass me the query to create the stored procedure (dbo.USP_CHAR_EQUIP_LOAD_S4)
Here ya go.
Credit: bubbastic
Code:USE [Pangya_S4_TH] GO /****** Objet : StoredProcedure [dbo].[USP_CHAR_EQUIP_LOAD_S4] ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER PROC [dbo].[USP_CHAR_EQUIP_LOAD_S4] ( @UID INT ) AS BEGIN SET NOCOUNT ON IF ( @UID > 0 ) BEGIN SELECT X.ITEM_ID , TYPEID /* new */ , ITEMID_PARTS_1 , ITEMID_PARTS_2 , ITEMID_PARTS_3 , ITEMID_PARTS_4 , ITEMID_PARTS_5 , ITEMID_PARTS_6 , ITEMID_PARTS_7 , ITEMID_PARTS_8 , ITEMID_PARTS_9 , ITEMID_PARTS_10 , ITEMID_PARTS_11 , ITEMID_PARTS_12 , ITEMID_PARTS_13 , ITEMID_PARTS_14 , ITEMID_PARTS_15 , ITEMID_PARTS_16 , ITEMID_PARTS_17 , ITEMID_PARTS_18 , ITEMID_PARTS_19 , ITEMID_PARTS_20 , ITEMID_PARTS_21 , ITEMID_PARTS_22 , ITEMID_PARTS_23 , ITEMID_PARTS_24 /* new */ , PARTS_1 , PARTS_2 , PARTS_3 , PARTS_4 , PARTS_5 , PARTS_6 , PARTS_7 , PARTS_8 , PARTS_9 , PARTS_10 , PARTS_11 , PARTS_12 , PARTS_13 , PARTS_14 , PARTS_15 , PARTS_16 , PARTS_17 , PARTS_18 , PARTS_19 , PARTS_20 , PARTS_21 , PARTS_22 , PARTS_23 , PARTS_24 , AUXPARTS_1 , AUXPARTS_2 , AUXPARTS_3 , AUXPARTS_4 , AUXPARTS_5 , DEFAULT_HAIR , DEFAULT_SHIRTS , GIFT_FLAG , PCL0 , PCL1 , PCL2 , PCL3 , PCL4 , PURCHASE FROM ( SELECT ITEM_ID , TYPEID , PARTS_1 , PARTS_2 , PARTS_3 , PARTS_4 , PARTS_5 , PARTS_6 , PARTS_7 , PARTS_8 , PARTS_9 , PARTS_10 , PARTS_11 , PARTS_12 , PARTS_13 , PARTS_14 , PARTS_15 , PARTS_16 , PARTS_17 , PARTS_18 , PARTS_19 , PARTS_20 , PARTS_21 , PARTS_22 , PARTS_23 , PARTS_24 , AUXPARTS_1 , AUXPARTS_2 , AUXPARTS_3 , AUXPARTS_4 , AUXPARTS_5 , DEFAULT_HAIR , DEFAULT_SHIRTS , GIFT_FLAG , PCL0 , PCL1 , PCL2 , PCL3 , PCL4 , PURCHASE FROM DBO.PANGYA_CHARACTER_INFORMATION WITH (NOLOCK) WHERE UID = @UID ) X INNER JOIN ( SELECT ITEM_ID , ITEMID_PARTS_1 = MAX(CASE WHEN EQUIP_NUM = 1 THEN ITEMID ELSE 0 END) , ITEMID_PARTS_2 = MAX(CASE WHEN EQUIP_NUM = 2 THEN ITEMID ELSE 0 END) , ITEMID_PARTS_3 = MAX(CASE WHEN EQUIP_NUM = 3 THEN ITEMID ELSE 0 END) , ITEMID_PARTS_4 = MAX(CASE WHEN EQUIP_NUM = 4 THEN ITEMID ELSE 0 END) , ITEMID_PARTS_5 = MAX(CASE WHEN EQUIP_NUM = 5 THEN ITEMID ELSE 0 END) , ITEMID_PARTS_6 = MAX(CASE WHEN EQUIP_NUM = 6 THEN ITEMID ELSE 0 END) , ITEMID_PARTS_7 = MAX(CASE WHEN EQUIP_NUM = 7 THEN ITEMID ELSE 0 END) , ITEMID_PARTS_8 = MAX(CASE WHEN EQUIP_NUM = 8 THEN ITEMID ELSE 0 END) , ITEMID_PARTS_9 = MAX(CASE WHEN EQUIP_NUM = 9 THEN ITEMID ELSE 0 END) , ITEMID_PARTS_10 = MAX(CASE WHEN EQUIP_NUM = 10 THEN ITEMID ELSE 0 END) , ITEMID_PARTS_11 = MAX(CASE WHEN EQUIP_NUM = 11 THEN ITEMID ELSE 0 END) , ITEMID_PARTS_12 = MAX(CASE WHEN EQUIP_NUM = 12 THEN ITEMID ELSE 0 END) , ITEMID_PARTS_13 = MAX(CASE WHEN EQUIP_NUM = 13 THEN ITEMID ELSE 0 END) , ITEMID_PARTS_14 = MAX(CASE WHEN EQUIP_NUM = 14 THEN ITEMID ELSE 0 END) , ITEMID_PARTS_15 = MAX(CASE WHEN EQUIP_NUM = 15 THEN ITEMID ELSE 0 END) , ITEMID_PARTS_16 = MAX(CASE WHEN EQUIP_NUM = 16 THEN ITEMID ELSE 0 END) , ITEMID_PARTS_17 = MAX(CASE WHEN EQUIP_NUM = 17 THEN ITEMID ELSE 0 END) , ITEMID_PARTS_18 = MAX(CASE WHEN EQUIP_NUM = 18 THEN ITEMID ELSE 0 END) , ITEMID_PARTS_19 = MAX(CASE WHEN EQUIP_NUM = 19 THEN ITEMID ELSE 0 END) , ITEMID_PARTS_20 = MAX(CASE WHEN EQUIP_NUM = 20 THEN ITEMID ELSE 0 END) , ITEMID_PARTS_21 = MAX(CASE WHEN EQUIP_NUM = 21 THEN ITEMID ELSE 0 END) , ITEMID_PARTS_22 = MAX(CASE WHEN EQUIP_NUM = 22 THEN ITEMID ELSE 0 END) , ITEMID_PARTS_23 = MAX(CASE WHEN EQUIP_NUM = 23 THEN ITEMID ELSE 0 END) , ITEMID_PARTS_24 = MAX(CASE WHEN EQUIP_NUM = 24 THEN ITEMID ELSE 0 END) FROM ( SELECT ITEM_ID , TYPEID , PARTS_1 , PARTS_2 , PARTS_3 , PARTS_4 , PARTS_5 , PARTS_6 , PARTS_7 , PARTS_8 , PARTS_9 , PARTS_10 , PARTS_11 , PARTS_12 , PARTS_13 , PARTS_14 , PARTS_15 , PARTS_16 , PARTS_17 , PARTS_18 , PARTS_19 , PARTS_20 , PARTS_21 , PARTS_22 , PARTS_23 , PARTS_24 FROM DBO.PANGYA_CHARACTER_INFORMATION WITH (NOLOCK) WHERE UID = @UID ) A LEFT OUTER JOIN ( SELECT CHAR_ITEMID, ITEMID, TYPEID, EQUIP_NUM FROM TD_CHAR_EQUIP_S4 WITH (NOLOCK) WHERE UID = @UID --AND ITEMID > 0 AND USE_YN = 'Y' ) B ON A.ITEM_ID = B.CHAR_ITEMID GROUP BY ITEM_ID ) Y ON X.ITEM_ID = Y.ITEM_ID END END
Re: Pangya Season 4.9 Server Files and Database
It worked
VERY VERY VERY VERY Thanks!!
http://img686.imageshack.us/img686/25/thanksvw.png
------
I have two doubts :
1° How do I add new items ?
2° How to solve this : http://img710.imageshack.us/img710/6591/helpx.png
OBS: It happens when opening the packs!
Last edited by outlawzzbr; 12-12-10 at 09:18 PM. Reason: Questions
So I went for another run-through of this thread to see if I could get an at-least partially working server (All I want is a working Item Shop, MyRoom, and PSQ, nothing more). I have no idea what I'm missing. I successfully made an account, but I can't even login with it. But for some reason, when I close the loginserver window, a message in Thai pops up in the Pangya window, and then I get to the server list... which is empty. No idea how to add a server.
Another note, the gameserver isn't working either. Why is there more than one? Which one am I supposed to use? When I try to run any of them, I get:
Code:XXXX-XX-XX XX:XX:XX 0 Log Create Failed XXXX-XX-XX XX:XX:XX LogSystem Create Failed XXXX-XX-XX XX:XX:XX Server Start Have Some Problem
rename the folder PANGYA_SRV for PANGYA_TEST
LOL no that's not it.
open your server.ini in game server and edit
Code:Log=(change to where you put your gameserver log folder is)
Can someone help me. I can not connect the channel
http://img545.imageshack.us/img545/8632/imagemiy.jpg
http://img585.imageshack.us/img585/5413/pangya313.jpg
You have to create three ODBC (ini3_py_account, INI3Bill_DB and Pangya_S4_TH
Control Panel > Administrative Tools > Data Sources (ODBC)
In the window that opened click System DSN > ADD
Go down the list until the option "SQL Server" and click "Finish".
In the opened window fill in the fields as follows:
Name: ini3_py_account
Description: Leave blank
Server: Enter your internal IP (127.0.0.1) or your external IP.
Click NEXT
In the next part, make sure that the options are satisfied as shown in picture below.
http://img.photobucket.com/albums/v5...a/Pangya07.jpg
Click NEXT
Click "Change the default database to" then click the down arrow to open a list and choose "ini3_py_account."
Click NEXT and then "Finish".
Open a window, you can click OK.
Now repeat everything in the DBs INI3Bill_DB and Pangya_S4_TH
credits: casadostutoriais
Still cant see the CHANNEL LIST? How to fix it
I'm not the same person who you told to do this, but I get this error when I reach the part that I bolded and underlined in the quote.
P.S. Still don't know how to add servers/channels to the list.
Last edited by mikumiku; 13-12-10 at 04:58 AM.
Hey, Ive been reading through this form for a while now downloading and preparing all the files, but I don't think i set up my SQL database right, can anyone give me a little direction on setting it up?
Also i am having the same error as mikumiku
EDIT: also when i try to Patch the files from 580.05 to 582.04 it loads the launcher and starts to install 582.06, is this ok? or should i not update it to that client
Last edited by G0dzilla2000; 13-12-10 at 06:05 AM.
Sql Native Client >>> Emu <<< Newbie.
I was screwed over by both Pangya GG and Pangya Ntreev and I would like to make a private server but, Wow. This looks really hard, I have read every page twice over and still have no idea where to start if anyone could give me their MSN to talk me over it with I would be extremely grateful.
