Printable View
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?
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 XDQuote:
Originally Posted by KS212
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:Quote:
Originally Posted by bubbastic
Talk to Me ~ MPQuote:
Originally Posted by sandro_adm
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
Still not have permission to post MESSAGES private.Quote:
Originally Posted by fasa2008
Able to create this kind of feature?
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 )
Nice ;)Quote:
Originally Posted by crashbufao
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
^^ 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 XDQuote:
Originally Posted by bubbastic
Here, everything now work except room creation and cardpacks. When I click on "make room" in lobby, I have an error : "You need to update Pangya to the latest version."Quote:
Originally Posted by crashbufao
My version is updated to 582.05 :S
Any idea ?
i'm still stuck at the server list without any servers popping out .. did i do something wrong?..??
o__O i don't get error message on create room
-----edit------
hmm something wrong on db i can buy itens on pangya, but if i re-login, their desappear o__O and if i try to buy character again say: you already have this item
need fix something, viewing logs
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
Have fun XDCode:USE [Pangya_S4_TH]
GO
/****** Objet : StoredProcedure [dbo].[USP_CARD_GET_LIST] ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROC [dbo].[USP_CARD_GET_LIST] (
@UID INT
)
AS
BEGIN
SET NOCOUNT ON
SELECT CARD_TYPEID
, CARD_ITEMID
, QTY
, IS_USE_DT = 0
FROM DBO.TD_CARD_USRS WITH (NOLOCK)
WHERE UID = @UID
AND USE_YN = 'Y'
END
Some fixes by bubbastic people fixes.rar - 4shared.com - online file sharing and storage - download ^^ thank bubbastic