The problem is here:Quote:
Originally Posted by chiosin2
dbo.USP_CHAR_EQUIP_LOAD_S4
Somebody help me ?
Printable View
The problem is here:Quote:
Originally Posted by chiosin2
dbo.USP_CHAR_EQUIP_LOAD_S4
Somebody help me ?
@outlawzzbr
Like i said re-run the CHAR_EQUIP_LOAD_S4 <<-- Create that stored procedure.. it should be okay then.
@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
It worked
VERY VERY VERY VERY Thanks!!
http://img686.imageshack.us/img686/25/thanksvw.png :thumbup1:
------
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!
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_TESTQuote:
Originally Posted by mikumiku
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_THQuote:
Originally Posted by luizhill
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.Quote:
Originally Posted by outlawzzbr
http://img41.imageshack.us/img41/6752/66960400.th.jpg
P.S. Still don't know how to add servers/channels to the list.
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
Sql Native Client >>> Emu <<< Newbie.Quote:
Originally Posted by outlawzzbr
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.