Printable View
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
chiosin2 you can share backup database please
Is anybody else getting a virus warning (Avira detects code of Win32.Alman.BB) in the exe files from the archive in the first post? It's in all three executables. The virus warning may be fake because Avira can't fix it, saying that the file is locked/in use even though I can delete it manually without any problems.
I checked for the signs of Alman.BB infection and I don't have them, but I haven't run the programs yet.
Sorry but can anyone help me with this? i've been stuck here for weeks... Not really good with Sql..Code:Msg 1921, Level 16, State 1, Line 3
Invalid filegroup 'Pangya_S4_TH_Item' specified.
Msg 1921, Level 16, State 1, Line 3
Invalid filegroup 'Pangya_S4_TH_Item' specified.
Msg 1921, Level 16, State 1, Line 3
Invalid filegroup 'Pangya_S4_TH_Mail' specified.
Msg 1921, Level 16, State 1, Line 3
Invalid filegroup 'Pangya_S4_TH_Item' specified.
Msg 1921, Level 16, State 1, Line 3
Invalid filegroup 'Pangya_S4_TH_Mail' specified.
Msg 1921, Level 16, State 1, Line 3
Invalid filegroup 'Pangya_S4_TH_Mail' specified.
Msg 1921, Level 16, State 1, Line 3
Invalid filegroup 'Pangya_S4_TH_Mail' specified.
Msg 1921, Level 16, State 1, Line 3
Invalid filegroup 'Pangya_S4_TH_Mail' specified.
Msg 1921, Level 16, State 1, Line 3
Invalid filegroup 'Pangya_S4_TH_Mail' specified.
Msg 1921, Level 16, State 1, Line 3
Invalid filegroup 'Pangya_S4_TH_Mail' specified.
Msg 1921, Level 16, State 1, Line 3
Invalid filegroup 'Pangya_S4_TH_Mail' specified.
Msg 1921, Level 16, State 1, Line 3
Invalid filegroup 'Pangya_S4_TH_Mail' specified.
Msg 1921, Level 16, State 1, Line 3
Invalid filegroup 'Pangya_S4_TH_Mail' specified.
Msg 1921, Level 16, State 1, Line 3
Invalid filegroup 'Pangya_S4_TH_Mail' specified.
Msg 1921, Level 16, State 1, Line 3
Invalid filegroup 'Pangya_S4_TH_Mail' specified.
Msg 1921, Level 16, State 1, Line 3
Invalid filegroup 'Pangya_S4_TH_Mail' specified.
Msg 208, Level 16, State 1, Procedure UVW_USER_ITEM, Line 6
Invalid object name 'DBO.PangYa_Character_Information'.
Msg 208, Level 16, State 1, Procedure UVW_ENCHANT_PANG, Line 5
Invalid object name 'PANGYA_ITEM_WAREHOUSE'.
Msg 1767, Level 16, State 0, Line 3
Foreign key 'FK_TD_MAIL_LOG_RET_TA_MAIL_SENDERR_ACC_ERR_CD' references invalid table 'dbo.TA_MAIL_SENDERR_ACC'.
Msg 1750, Level 16, State 0, Line 3
Could not create constraint. See previous errors.
Msg 4917, Level 16, State 0, Line 1
Constraint 'FK_TD_MAIL_LOG_RET_TA_MAIL_SENDERR_ACC_ERR_CD' does not exist.
Msg 4916, Level 16, State 0, Line 1
Could not enable or disable the constraint. See previous errors.
@bubbletastic
Can you post the queries required to CREATE the procedures that your fixed use? Thanks.
(Or better, just dump your Pangya_S4_TH to and .sql for us, lol)
Can someone patch properly this exe please ?
need to remove gg and all update request and allow multi client.
Previous exe posted here still contacting the server and say that I need to update the game.
link
thx
I wish I knew more programming than basic high school stuff. After getting banned from PangyaUS after 5 years with them, I have absolutely no motivation to continue playing any official servers. Hell, I don't even want to actually "play" anymore. All I want is access to whatever characters and outfits I want, and the Lounge; like a glorified chatroom.
Since I try to use the fasa2008?Quote:
Originally Posted by bubbastic
I could not find where I can exchange the IP of ProjectG.exe to the program communicate with the Database server. Can anyone help me? :*:
----------------------------------------------Quote:
Originally Posted by chiosin2
I created the follow four filegroups she asks: " Table Pangya_S4_TH...
Pangya_S4_TH_Item
Pangya_S4_TH_Mail
Pangya_S4_TH_gLog
Pangya_S4_TH_Card
Problem solved xD
-------------------------------------------------
*Update
Unpacked
No-GG
Removed from the Loader GameGuard
GameGuard Fixed
IP: 127.0.0.1 Version ~ ProjectG_582.05.
Multi Client
Removed Error Message PAK
Removed Error Message ProjectG.exe
Removed Error Message GameGuard
Removed All Erros Messages ...xD
Version Finally...xD
Download
I have the same issue, server registers fine to the database but won't show up for some reason...Quote:
Originally Posted by chiosin2
is it in the config files? i can log in just fine but the server list is still empty. Can anyone tell me if the problem is in the config file or somewhere else?Quote:
Originally Posted by Tsukasa
My nickname in RZBR is Fernando.xDQuote:
Originally Posted by sandro_adm
You'll need to be able to send 15 posts to PM here
so... I went in lobby and got a lot of things working : bongdari, family mode, shop. I'm working on fixing the cardpacks. I can't create a room at the moment tho. It says I need to update the game each time I click on MAKE ROOM. I added some fairy wings, elf ears and mystic ring in ITEM WAREHOUSE. I unlocked all upgraded caddies and Black papel.
I don't know how to find the ITEMIDs so it's a lot of guess shots XD
I hope I can create a VS room in a near future.
err forum bug :/ sorry for the double post
Btw fasa2008, check your MPs :p
read the log filesQuote:
Originally Posted by chiosin2
You must have some failed queries
Code:USE [Pangya_S4_TH]
GO
/****** Objet : StoredProcedure [dbo].[USP_CHAR_EQUIP_SAVE_S4] Date de génération du script : 12/04/2010 00:48:23 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
Create PROC [dbo].[USP_CHAR_EQUIP_SAVE_S4] (
@UID INT
, @CHAR_ITEM_ID INT
, @STR VARCHAR(8000)
, @DEBUG TINYINT = 0
)
AS
BEGIN
-- '1^123456|2|3^1243^2214^1'
-- @EQUIP_NUM^@TYPEID^@ITEMID^@UCCIDX^@SEQ|
-- @EQUIP_NUM^@TYPEID^@ITEMID^@UCCIDX^@SEQ
SET NOCOUNT ON
DECLARE @RET INT
SET @RET = 0
--INPUT 분석(1차 파싱 결과)
IF OBJECT_ID('TEMPDB..#TD_SRC') IS NOT NULL
DROP TABLE #TD_SRC
CREATE TABLE #TD_SRC (
IDX SMALLINT IDENTITY(1,1)
, DT VARCHAR(1000)
)
--INPUT 분석(2차 파싱) 및 RESULT를 저장
IF OBJECT_ID('TEMPDB..#TD_CHAR') IS NOT NULL
DROP TABLE #TD_CHAR
CREATE TABLE #TD_CHAR (
IDX SMALLINT IDENTITY(1,1)
, UID INT
, CHAR_ITEMID INT
, EQUIP_NUM INT -- 캐릭터 파트 번호
, TYPEID INT -- 아이템
, ITEMID INT -- ITEMID
, UCCIDX VARCHAR(8) -- UCC인덱스
, SEQ SMALLINT -- UCC 시퀀스
)
DECLARE @SQL VARCHAR(8000)
, @STR_SEP CHAR(1)
, @INTLOOP INT
SET @STR_SEP = '|'
SET @SQL = ''
SET @INTLOOP = 1
IF CHARINDEX('|', @STR) > 0 BEGIN
SELECT @SQL= 'SELECT LTRIM(C) C FROM (SELECT '''
+ REPLACE(CONT,@STR_SEP,''' C UNION ALL ' + CHAR(13) + 'SELECT ''') + ''') T'
FROM ( SELECT CONT = @STR ) X
END ELSE BEGIN
SET @SQL = 'SELECT LTRIM(C) C FROM (SELECT ''' + @STR + ''' C) T'
END
INSERT INTO #TD_SRC (DT)
EXEC(@SQL)
DECLARE @EQUIP_NUM VARCHAR(20)
, @TYPEID VARCHAR(20)
, @ITEMID VARCHAR(20)
, @UCCIDX VARCHAR(20)
, @SEQ VARCHAR(20)
WHILE EXISTS( SELECT 1 FROM #TD_SRC WHERE IDX = @INTLOOP ) BEGIN
SELECT @SQL = REPLACE(DT, '^', ' ^') FROM #TD_SRC WHERE IDX = @INTLOOP
EXEC MASTER..XP_SSCANF @SQL, '%s ^%s ^%s ^%s ^%s',
@EQUIP_NUM OUTPUT, @TYPEID OUTPUT, @ITEMID OUTPUT, @UCCIDX OUTPUT, @SEQ OUTPUT
INSERT INTO #TD_CHAR (UID, CHAR_ITEMID, EQUIP_NUM, TYPEID, ITEMID, UCCIDX, SEQ)
SELECT @UID
, @CHAR_ITEM_ID
, EQUIP_NUM = CAST(@EQUIP_NUM AS INT)
, TYPEID = CAST(@TYPEID AS INT)
, ITEMID = CAST(@ITEMID AS INT)
, UCCIDX = @UCCIDX
, SEQ = CAST(@SEQ AS INT)
SET @INTLOOP = @INTLOOP + 1
END
CREATE CLUSTERED INDEX CIDX_TD_CHAR
ON #TD_CHAR (EQUIP_NUM)
-- 캐릭터 장착 정보 UPDATE문 생성 => !!! AD-HOC 하나라도 더 줄이기!!!
BEGIN TRY
BEGIN TRAN
UPDATE B
SET
parts_1 = CASE WHEN A.parts_1 > 0 THEN A.parts_1 ELSE 0 END
, parts_2 = CASE WHEN A.parts_2 > 0 THEN A.parts_2 ELSE 0 END
, parts_3 = CASE WHEN A.parts_3 > 0 THEN A.parts_3 ELSE 0 END
, parts_4 = CASE WHEN A.parts_4 > 0 THEN A.parts_4 ELSE 0 END
, parts_5 = CASE WHEN A.parts_5 > 0 THEN A.parts_5 ELSE 0 END
, parts_6 = CASE WHEN A.parts_6 > 0 THEN A.parts_6 ELSE 0 END
, parts_7 = CASE WHEN A.parts_7 > 0 THEN A.parts_7 ELSE 0 END
, parts_8 = CASE WHEN A.parts_8 > 0 THEN A.parts_8 ELSE 0 END
, parts_9 = CASE WHEN A.parts_9 > 0 THEN A.parts_9 ELSE 0 END
, parts_10 = CASE WHEN A.parts_10 > 0 THEN A.parts_10 ELSE 0 END
, parts_11 = CASE WHEN A.parts_11 > 0 THEN A.parts_11 ELSE 0 END
, parts_12 = CASE WHEN A.parts_12 > 0 THEN A.parts_12 ELSE 0 END
, parts_13 = CASE WHEN A.parts_13 > 0 THEN A.parts_13 ELSE 0 END
, parts_14 = CASE WHEN A.parts_14 > 0 THEN A.parts_14 ELSE 0 END
, parts_15 = CASE WHEN A.parts_15 > 0 THEN A.parts_15 ELSE 0 END
, parts_16 = CASE WHEN A.parts_16 > 0 THEN A.parts_16 ELSE 0 END
, parts_17 = CASE WHEN A.parts_17 > 0 THEN A.parts_17 ELSE 0 END
, parts_18 = CASE WHEN A.parts_18 > 0 THEN A.parts_18 ELSE 0 END
, parts_19 = CASE WHEN A.parts_19 > 0 THEN A.parts_19 ELSE 0 END
, parts_20 = CASE WHEN A.parts_20 > 0 THEN A.parts_20 ELSE 0 END
, parts_21 = CASE WHEN A.parts_21 > 0 THEN A.parts_21 ELSE 0 END
, parts_22 = CASE WHEN A.parts_22 > 0 THEN A.parts_22 ELSE 0 END
, parts_23 = CASE WHEN A.parts_23 > 0 THEN A.parts_23 ELSE 0 END
, parts_24 = CASE WHEN A.parts_24 > 0 THEN A.parts_24 ELSE 0 END
FROM
(
SELECT UID
, CHAR_ITEMID = MAX(CHAR_ITEMID)
, parts_1 = MAX(CASE WHEN EQUIP_NUM = 1 THEN TYPEID ELSE 0 END)
, parts_2 = MAX(CASE WHEN EQUIP_NUM = 2 THEN TYPEID ELSE 0 END)
, parts_3 = MAX(CASE WHEN EQUIP_NUM = 3 THEN TYPEID ELSE 0 END)
, parts_4 = MAX(CASE WHEN EQUIP_NUM = 4 THEN TYPEID ELSE 0 END)
, parts_5 = MAX(CASE WHEN EQUIP_NUM = 5 THEN TYPEID ELSE 0 END)
, parts_6 = MAX(CASE WHEN EQUIP_NUM = 6 THEN TYPEID ELSE 0 END)
, parts_7 = MAX(CASE WHEN EQUIP_NUM = 7 THEN TYPEID ELSE 0 END)
, parts_8 = MAX(CASE WHEN EQUIP_NUM = 8 THEN TYPEID ELSE 0 END)
, parts_9 = MAX(CASE WHEN EQUIP_NUM = 9 THEN TYPEID ELSE 0 END)
, parts_10 = MAX(CASE WHEN EQUIP_NUM = 10 THEN TYPEID ELSE 0 END)
, parts_11 = MAX(CASE WHEN EQUIP_NUM = 11 THEN TYPEID ELSE 0 END)
, parts_12 = MAX(CASE WHEN EQUIP_NUM = 12 THEN TYPEID ELSE 0 END)
, parts_13 = MAX(CASE WHEN EQUIP_NUM = 13 THEN TYPEID ELSE 0 END)
, parts_14 = MAX(CASE WHEN EQUIP_NUM = 14 THEN TYPEID ELSE 0 END)
, parts_15 = MAX(CASE WHEN EQUIP_NUM = 15 THEN TYPEID ELSE 0 END)
, parts_16 = MAX(CASE WHEN EQUIP_NUM = 16 THEN TYPEID ELSE 0 END)
, parts_17 = MAX(CASE WHEN EQUIP_NUM = 17 THEN TYPEID ELSE 0 END)
, parts_18 = MAX(CASE WHEN EQUIP_NUM = 18 THEN TYPEID ELSE 0 END)
, parts_19 = MAX(CASE WHEN EQUIP_NUM = 19 THEN TYPEID ELSE 0 END)
, parts_20 = MAX(CASE WHEN EQUIP_NUM = 20 THEN TYPEID ELSE 0 END)
, parts_21 = MAX(CASE WHEN EQUIP_NUM = 21 THEN TYPEID ELSE 0 END)
, parts_22 = MAX(CASE WHEN EQUIP_NUM = 22 THEN TYPEID ELSE 0 END)
, parts_23 = MAX(CASE WHEN EQUIP_NUM = 23 THEN TYPEID ELSE 0 END)
, parts_24 = MAX(CASE WHEN EQUIP_NUM = 24 THEN TYPEID ELSE 0 END)
FROM #TD_CHAR
GROUP BY UID
) A
INNER JOIN
(
SELECT *
FROM pangya_character_information WITH (NOLOCK)
WHERE UID = @UID
AND ITEM_ID = @CHAR_ITEM_ID
) B
ON A.UID = B.UID
AND A.CHAR_ITEMID = B.ITEM_ID
/*****************************************
카드 장착정보 ITEM 추가: SELECT * FROM TD_CARD_EQUIP
했다고 주석에 나와있지만 무슨소린지 아무도 모른다..
뭘 어쨌다는건지....
알게 되면 주석을 추가해 주세요 ㅡ.ㅡ
******************************************/
UPDATE DBO.TD_CHAR_EQUIP_S4
SET USE_YN = 'N'
WHERE UID = @UID
INSERT INTO DBO.TD_CHAR_EQUIP_S4 ( UID, CHAR_ITEMID, ITEMID, TYPEID, EQUIP_NUM, UCC_IDX, USE_YN )
SELECT
@UID
, @CHAR_ITEM_ID
, CASE ITEMID WHEN 0 THEN 0 ELSE ITEMID END
, TYPEID
, B.EQUIP_NUM
, UCCIDX
, 'Y'
FROM (
SELECT *
FROM #TD_CHAR
WHERE ITEMID IS NOT NULL
) B
COMMIT TRAN
SELECT [RET] = @@ERROR
IF ( @DEBUG = 1 ) BEGIN
SELECT *
FROM #TD_CHAR
END
END TRY
BEGIN CATCH
ROLLBACK TRAN
SELECT [RET] = 1
END CATCH
END
Code:USE [Pangya_S4_TH]
GO
/****** Objet : StoredProcedure [dbo].[USP_CHAR_EQUIP_SAVE_S4] Date de génération du script : 12/04/2010 00:48:23 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROC [dbo].[USP_CHAR_EQUIP_SAVE_S4] (
@UID INT
, @CHAR_ITEM_ID INT
, @STR VARCHAR(8000)
, @DEBUG TINYINT = 0
)
AS
BEGIN
-- '1^123456|2|3^1243^2214^1'
-- @EQUIP_NUM^@TYPEID^@ITEMID^@UCCIDX^@SEQ|
-- @EQUIP_NUM^@TYPEID^@ITEMID^@UCCIDX^@SEQ
SET NOCOUNT ON
DECLARE @RET INT
SET @RET = 0
--INPUT 분석(1차 파싱 결과)
IF OBJECT_ID('TEMPDB..#TD_SRC') IS NOT NULL
DROP TABLE #TD_SRC
CREATE TABLE #TD_SRC (
IDX SMALLINT IDENTITY(1,1)
, DT VARCHAR(1000)
)
--INPUT 분석(2차 파싱) 및 RESULT를 저장
IF OBJECT_ID('TEMPDB..#TD_CHAR') IS NOT NULL
DROP TABLE #TD_CHAR
CREATE TABLE #TD_CHAR (
IDX SMALLINT IDENTITY(1,1)
, UID INT
, CHAR_ITEMID INT
, EQUIP_NUM INT -- 캐릭터 파트 번호
, TYPEID INT -- 아이템
, ITEMID INT -- ITEMID
, UCCIDX VARCHAR(8) -- UCC인덱스
, SEQ SMALLINT -- UCC 시퀀스
)
DECLARE @SQL VARCHAR(8000)
, @STR_SEP CHAR(1)
, @INTLOOP INT
SET @STR_SEP = '|'
SET @SQL = ''
SET @INTLOOP = 1
IF CHARINDEX('|', @STR) > 0 BEGIN
SELECT @SQL= 'SELECT LTRIM(C) C FROM (SELECT '''
+ REPLACE(CONT,@STR_SEP,''' C UNION ALL ' + CHAR(13) + 'SELECT ''') + ''') T'
FROM ( SELECT CONT = @STR ) X
END ELSE BEGIN
SET @SQL = 'SELECT LTRIM(C) C FROM (SELECT ''' + @STR + ''' C) T'
END
INSERT INTO #TD_SRC (DT)
EXEC(@SQL)
DECLARE @EQUIP_NUM VARCHAR(20)
, @TYPEID VARCHAR(20)
, @ITEMID VARCHAR(20)
, @UCCIDX VARCHAR(20)
, @SEQ VARCHAR(20)
WHILE EXISTS( SELECT 1 FROM #TD_SRC WHERE IDX = @INTLOOP ) BEGIN
SELECT @SQL = REPLACE(DT, '^', ' ^') FROM #TD_SRC WHERE IDX = @INTLOOP
EXEC MASTER..XP_SSCANF @SQL, '%s ^%s ^%s ^%s ^%s',
@EQUIP_NUM OUTPUT, @TYPEID OUTPUT, @ITEMID OUTPUT, @UCCIDX OUTPUT, @SEQ OUTPUT
INSERT INTO #TD_CHAR (UID, CHAR_ITEMID, EQUIP_NUM, TYPEID, ITEMID, UCCIDX, SEQ)
SELECT @UID
, @CHAR_ITEM_ID
, EQUIP_NUM = CAST(@EQUIP_NUM AS INT)
, TYPEID = CAST(@TYPEID AS INT)
, ITEMID = CAST(@ITEMID AS INT)
, UCCIDX = @UCCIDX
, SEQ = CAST(@SEQ AS INT)
SET @INTLOOP = @INTLOOP + 1
END
CREATE CLUSTERED INDEX CIDX_TD_CHAR
ON #TD_CHAR (EQUIP_NUM)
-- 캐릭터 장착 정보 UPDATE문 생성 => !!! AD-HOC 하나라도 더 줄이기!!!
BEGIN TRY
BEGIN TRAN
UPDATE B
SET
parts_1 = CASE WHEN A.parts_1 > 0 THEN A.parts_1 ELSE 0 END
, parts_2 = CASE WHEN A.parts_2 > 0 THEN A.parts_2 ELSE 0 END
, parts_3 = CASE WHEN A.parts_3 > 0 THEN A.parts_3 ELSE 0 END
, parts_4 = CASE WHEN A.parts_4 > 0 THEN A.parts_4 ELSE 0 END
, parts_5 = CASE WHEN A.parts_5 > 0 THEN A.parts_5 ELSE 0 END
, parts_6 = CASE WHEN A.parts_6 > 0 THEN A.parts_6 ELSE 0 END
, parts_7 = CASE WHEN A.parts_7 > 0 THEN A.parts_7 ELSE 0 END
, parts_8 = CASE WHEN A.parts_8 > 0 THEN A.parts_8 ELSE 0 END
, parts_9 = CASE WHEN A.parts_9 > 0 THEN A.parts_9 ELSE 0 END
, parts_10 = CASE WHEN A.parts_10 > 0 THEN A.parts_10 ELSE 0 END
, parts_11 = CASE WHEN A.parts_11 > 0 THEN A.parts_11 ELSE 0 END
, parts_12 = CASE WHEN A.parts_12 > 0 THEN A.parts_12 ELSE 0 END
, parts_13 = CASE WHEN A.parts_13 > 0 THEN A.parts_13 ELSE 0 END
, parts_14 = CASE WHEN A.parts_14 > 0 THEN A.parts_14 ELSE 0 END
, parts_15 = CASE WHEN A.parts_15 > 0 THEN A.parts_15 ELSE 0 END
, parts_16 = CASE WHEN A.parts_16 > 0 THEN A.parts_16 ELSE 0 END
, parts_17 = CASE WHEN A.parts_17 > 0 THEN A.parts_17 ELSE 0 END
, parts_18 = CASE WHEN A.parts_18 > 0 THEN A.parts_18 ELSE 0 END
, parts_19 = CASE WHEN A.parts_19 > 0 THEN A.parts_19 ELSE 0 END
, parts_20 = CASE WHEN A.parts_20 > 0 THEN A.parts_20 ELSE 0 END
, parts_21 = CASE WHEN A.parts_21 > 0 THEN A.parts_21 ELSE 0 END
, parts_22 = CASE WHEN A.parts_22 > 0 THEN A.parts_22 ELSE 0 END
, parts_23 = CASE WHEN A.parts_23 > 0 THEN A.parts_23 ELSE 0 END
, parts_24 = CASE WHEN A.parts_24 > 0 THEN A.parts_24 ELSE 0 END
FROM
(
SELECT UID
, CHAR_ITEMID = MAX(CHAR_ITEMID)
, parts_1 = MAX(CASE WHEN EQUIP_NUM = 1 THEN TYPEID ELSE 0 END)
, parts_2 = MAX(CASE WHEN EQUIP_NUM = 2 THEN TYPEID ELSE 0 END)
, parts_3 = MAX(CASE WHEN EQUIP_NUM = 3 THEN TYPEID ELSE 0 END)
, parts_4 = MAX(CASE WHEN EQUIP_NUM = 4 THEN TYPEID ELSE 0 END)
, parts_5 = MAX(CASE WHEN EQUIP_NUM = 5 THEN TYPEID ELSE 0 END)
, parts_6 = MAX(CASE WHEN EQUIP_NUM = 6 THEN TYPEID ELSE 0 END)
, parts_7 = MAX(CASE WHEN EQUIP_NUM = 7 THEN TYPEID ELSE 0 END)
, parts_8 = MAX(CASE WHEN EQUIP_NUM = 8 THEN TYPEID ELSE 0 END)
, parts_9 = MAX(CASE WHEN EQUIP_NUM = 9 THEN TYPEID ELSE 0 END)
, parts_10 = MAX(CASE WHEN EQUIP_NUM = 10 THEN TYPEID ELSE 0 END)
, parts_11 = MAX(CASE WHEN EQUIP_NUM = 11 THEN TYPEID ELSE 0 END)
, parts_12 = MAX(CASE WHEN EQUIP_NUM = 12 THEN TYPEID ELSE 0 END)
, parts_13 = MAX(CASE WHEN EQUIP_NUM = 13 THEN TYPEID ELSE 0 END)
, parts_14 = MAX(CASE WHEN EQUIP_NUM = 14 THEN TYPEID ELSE 0 END)
, parts_15 = MAX(CASE WHEN EQUIP_NUM = 15 THEN TYPEID ELSE 0 END)
, parts_16 = MAX(CASE WHEN EQUIP_NUM = 16 THEN TYPEID ELSE 0 END)
, parts_17 = MAX(CASE WHEN EQUIP_NUM = 17 THEN TYPEID ELSE 0 END)
, parts_18 = MAX(CASE WHEN EQUIP_NUM = 18 THEN TYPEID ELSE 0 END)
, parts_19 = MAX(CASE WHEN EQUIP_NUM = 19 THEN TYPEID ELSE 0 END)
, parts_20 = MAX(CASE WHEN EQUIP_NUM = 20 THEN TYPEID ELSE 0 END)
, parts_21 = MAX(CASE WHEN EQUIP_NUM = 21 THEN TYPEID ELSE 0 END)
, parts_22 = MAX(CASE WHEN EQUIP_NUM = 22 THEN TYPEID ELSE 0 END)
, parts_23 = MAX(CASE WHEN EQUIP_NUM = 23 THEN TYPEID ELSE 0 END)
, parts_24 = MAX(CASE WHEN EQUIP_NUM = 24 THEN TYPEID ELSE 0 END)
FROM #TD_CHAR
GROUP BY UID
) A
INNER JOIN
(
SELECT *
FROM pangya_character_information WITH (NOLOCK)
WHERE UID = @UID
AND ITEM_ID = @CHAR_ITEM_ID
) B
ON A.UID = B.UID
AND A.CHAR_ITEMID = B.ITEM_ID
/*****************************************
카드 장착정보 ITEM 추가: SELECT * FROM TD_CARD_EQUIP
했다고 주석에 나와있지만 무슨소린지 아무도 모른다..
뭘 어쨌다는건지....
알게 되면 주석을 추가해 주세요 ㅡ.ㅡ
******************************************/
UPDATE DBO.TD_CHAR_EQUIP_S4
SET USE_YN = 'N'
WHERE UID = @UID
INSERT INTO DBO.TD_CHAR_EQUIP_S4 ( UID, CHAR_ITEMID, ITEMID, TYPEID, EQUIP_NUM, UCC_IDX, USE_YN )
SELECT
@UID
, @CHAR_ITEM_ID
, CASE ITEMID WHEN 0 THEN 0 ELSE ITEMID END
, TYPEID
, B.EQUIP_NUM
, UCCIDX
, 'Y'
FROM (
SELECT *
FROM #TD_CHAR
WHERE ITEMID IS NOT NULL
) B
COMMIT TRAN
SELECT [RET] = @@ERROR
IF ( @DEBUG = 1 ) BEGIN
SELECT *
FROM #TD_CHAR
END
END TRY
BEGIN CATCH
ROLLBACK TRAN
SELECT [RET] = 1
END CATCH
END
Thanks for the pointers.
Studying the log files helped me.
If you have created the file groups, don't forget to assign a file to them (or vice versa). Assigning the file to the specific groups solved my problem.
I've attached a file containing a list of the available ICONINDEX values. Values >= 10 will also cause the server to "disappear" from the server list as it seems...
bubbastic and fasa2008 , could you please release full db with content in it or release full server that not empty DB
hello.
anyone find, how change rate exp,pang?
anyone find, how change rate exp,pang?
fasa2008
I think you can not create that feature in projectg, correct?
Sorry to disturb
I could not find where I can exchange the IP of ProjectG.exe to the program communicate with the Database server. Can anyone help me??????
@revo12 download fasa2008's ProjectG.exe
Talk to me on msn ... You've got my just do not knowQuote:
Originally Posted by sandro_adm
---------- Post added at 03:46 AM ---------- Previous post was at 03:44 AM ----------
Use my Projectg.exeQuote:
Originally Posted by revo12
I ty to add
Msg 208, Level 16, State 6, Procedure USP_CHAR_EQUIP_LOAD_S4, Line 13
Invalid object name 'dbo.USP_CHAR_EQUIP_LOAD_S4'.
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
fasa2008
How to create file group?
another doubt, how to make accs in database in MS SQL 2005? I remember a little of the pangya s1 but this db is a little different ^^
:thumbup:
Solved.
Now I just want to know how I add cookies/pangs in my acc? And what I have to do to my account be GameMaster Account?? TYvm!
Thanks! this helped. But i can't seem to find anything in the logs @___@ might take me some time. what specific files does it need?Quote:
Originally Posted by Tsukasa
@Darkknight you have to have the procedure first before you can alter it.
can anyone help me with my Server list? i can't seem to see any servers on it.Code:USE [Pangya_S4_TH]
GO
/****** Objet : StoredProcedure [dbo].[USP_CHAR_EQUIP_LOAD_S4] ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE 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
I don't know about log when select loading server
2010-12-03 21:27:33 1 Pang-CB Server 7 [N_ITEM] TotalCNT : Parts(0), Clubset(1)
2010-12-03 21:27:33 0 Pang-CB Server 1 exec dbo.ProcGetCaddieInfo 7
2010-12-03 21:27:33 1 Pang-CB Server -1 [N_LOGIN] LogInProcess : OUTPUT : GUID(9), isSuccess(1), Count(9), CmdID(3)
2010-12-03 21:27:33 1 Pang-CB Server -1 [N_LOGIN] LogInProcess : OUTPUT : GUID(9), isSuccess(1), Count(10), CmdID(4)
2010-12-03 21:27:33 1 Pang-CB Server -1 [N_LOGIN] LogInProcess : OUTPUT : GUID(9), isSuccess(1), Count(11), CmdID(10)
2010-12-03 21:27:33 0 Pang-CB Server 1 exec dbo.ProcGetCaddieInfo 7
2010-12-03 21:27:33 1 Pang-CB Server -1 [N_LOGIN] LogInProcess : OUTPUT : GUID(9), isSuccess(1), Count(12), CmdID(11)
2010-12-03 21:27:33 1 Pang-CB Server -1 [N_LOGIN] LogInProcess : OUTPUT : GUID(9), isSuccess(1), Count(13), CmdID(9)
2010-12-03 21:27:33 1 Pang-CB Server -1 [N_LOGIN] LogInProcess : OUTPUT : GUID(9), isSuccess(1), Count(14), CmdID(15)
2010-12-03 21:27:33 1 Pang-CB Server -1 [N_LOGIN] LogInProcess : OUTPUT : GUID(9), isSuccess(1), Count(15), CmdID(17)
2010-12-03 21:27:33 1 Pang-CB Server -1 [N_LOGIN] LogInProcess : OUTPUT : GUID(9), isSuccess(1), Count(16), CmdID(14)
2010-12-03 21:27:33 0 Pang-CB Server 1 exec dbo.ProcGetCaddieInfo 7
2010-12-03 21:27:33 0 Pang-CB Server 1 exec dbo.ProcGetCaddieInfo 7
2010-12-03 21:27:33 0 Pang-CB Server 1 exec dbo.ProcGetCaddieInfo 7
2010-12-03 21:27:33 0 Pang-CB Server 1 exec dbo.ProcGetCaddieInfo 7
2010-12-03 21:27:33 1 Pang-CB Server 7 [N_LOGIN] Disconnect : Pang( 3000 )
Unfortunately I have your msn fasa2008.Quote:
Originally Posted by fasa2008
I had some personal problems and a lack of time ended up doing some things with it, I just losing touch with everyone.
I believe that there can be no transfer of emails here at the forum.
I would like to get back in touch with you.
Manda by Mp in Rzbr?
Users = ShadowGames
@darkknight use this
can anyone help with the files to add to the file group? Anyone need Item Database?Code:USE Pangya_S4_TH;
GO
ALTER DATABASE Pangya_S4_DB
ADD FILEGROUP filegroup name here
GO
Sure thing!Quote:
Originally Posted by chiosin2
Fire up your enterprise console or management studio, open the properties window of your Pangya_S4_TH database and select files.
Since I am assuming you already have created the file groups the procedure is pretty simple. Add three new entries by clicking "Add".
The names of the entries should correspond with the name of the file groups you added earlier (Pangya_S4_TH_Card, Pangya_S4_TH_gLog, Pangya_S4_TH_Item), scroll to the last column "Filename" and set the value to Pangya_S4_TH_Card.mdf, Pangya_S4_TH_gLog.mdf and Pangya_S4_TH_Item.mdf. Assign the correct filegroup by using the File Group column.
Close the dialog by clicking OK, the tool will probably complain about the files already existing - doesn't matter though. If you want to make sure you get up to par open up the Pangya_S4_TH.sql query again and re-run it to get the missing parts. That should allow you to at least see the server.
If that's not the case check the gameserver logs for any E_ messages, it's likely you're still missing critical stored procedures.
Doesn't work for me. i have created the file groups by in the query, but does this have a script or something? i cant even edit the values for "Filename"
EDIT:
no i don't have any E_ in the gameserver logs..
@ Fasa2008
Personal message sent in the Br
@ Topic
Desconbriu where someone already adds and changes:
- Cookies
- Rates
- Experience
- And other
i got it to connect ^^ thanks.. Tsukasa. hmm now for the channels..
chiosin2, glad to hear it works!
I was just in the middle of wiring up a bootstrapper query for you. Since I believe it may be of interest to other people as well, here it is:
The query will create the users, the databases, file groups and files. You'll have to run it before the 3 original queries coming with the server package.Code:USE [master]
GO
/*******************************************
* Pangya Server 4.9 Database Bootstrapper *
* *
* Use at your own risk! *
* *
* Please edit the @DBUSER_PASSWORD for *
* your server. Leaving the default simply *
* isn't cool. *
* *
* USAGE: *
* 1. Run this query *
* 2. Run INI3_BILLDB.sql *
* 3. Run INI3_PY_ACCOUNT.sql *
* 4. Run Pangya_S4_TH.sql *
* 5. ??? (Add/Alter procedures, etc.) *
*******************************************/
DECLARE @DBUSER_PASSWORD VARCHAR(256)
DECLARE @DBUSER_CREATE_SQL NVARCHAR(256)
SET @DBUSER_PASSWORD = N'Password'
/* =========== Create users =========== */
IF NOT EXISTS (SELECT loginname FROM dbo.syslogins WHERE name = N'ini3web')
BEGIN
SELECT @DBUSER_CREATE_SQL = 'CREATE LOGIN [ini3web] WITH PASSWORD=''' + @DBUSER_PASSWORD + ''', DEFAULT_DATABASE=[master], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF'
EXEC sp_executesql @DBUSER_CREATE_SQL
END
ELSE
PRINT 'User ini3web already exists, skipping creation...'
IF NOT EXISTS (SELECT loginname FROM dbo.syslogins WHERE name = N'ini3gamebr')
BEGIN
SELECT @DBUSER_CREATE_SQL = 'CREATE LOGIN [ini3gamebr] WITH PASSWORD=''' + @DBUSER_PASSWORD + ''', DEFAULT_DATABASE=[master], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF'
EXEC sp_executesql @DBUSER_CREATE_SQL
END
ELSE
PRINT 'User ini3gamebr already exists, skipping creation...'
IF NOT EXISTS (SELECT loginname FROM dbo.syslogins WHERE name = N'ini3webstat')
BEGIN
SELECT @DBUSER_CREATE_SQL = 'CREATE LOGIN [ini3webstat] WITH PASSWORD=''' + @DBUSER_PASSWORD + ''', DEFAULT_DATABASE=[master], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF'
EXEC sp_executesql @DBUSER_CREATE_SQL
END
ELSE
PRINT 'User ini3webstat already exists, skipping creation...'
IF NOT EXISTS (SELECT loginname FROM dbo.syslogins WHERE name = N'pangya')
BEGIN
SELECT @DBUSER_CREATE_SQL = 'CREATE LOGIN [pangya] WITH PASSWORD=''' + @DBUSER_PASSWORD + ''', DEFAULT_DATABASE=[master], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF'
EXEC sp_executesql @DBUSER_CREATE_SQL
END
ELSE
PRINT 'User pangya already exists, skipping creation...'
IF NOT EXISTS (SELECT loginname FROM dbo.syslogins WHERE name = N'Pangya_TH')
BEGIN
SELECT @DBUSER_CREATE_SQL = 'CREATE LOGIN [Pangya_TH] WITH PASSWORD=''' + @DBUSER_PASSWORD + ''', DEFAULT_DATABASE=[master], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF'
EXEC sp_executesql @DBUSER_CREATE_SQL
END
ELSE
PRINT 'User Pangya_TH already exists, skipping creation...'
IF NOT EXISTS (SELECT loginname FROM dbo.syslogins WHERE name = N'Biller')
BEGIN
SELECT @DBUSER_CREATE_SQL = 'CREATE LOGIN [Biller] WITH PASSWORD=''' + @DBUSER_PASSWORD + ''', DEFAULT_DATABASE=[master], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF'
EXEC sp_executesql @DBUSER_CREATE_SQL
END
ELSE
PRINT 'User Biller already exists, skipping creation...'
IF NOT EXISTS (SELECT loginname FROM dbo.syslogins WHERE name = N'pangyaclub')
BEGIN
SELECT @DBUSER_CREATE_SQL = 'CREATE LOGIN [pangyaclub] WITH PASSWORD=''' + @DBUSER_PASSWORD + ''', DEFAULT_DATABASE=[master], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF'
EXEC sp_executesql @DBUSER_CREATE_SQL
END
ELSE
PRINT 'User pangyaclub already exists, skipping creation...'
IF NOT EXISTS (SELECT loginname FROM dbo.syslogins WHERE name = N'payletter')
BEGIN
SELECT @DBUSER_CREATE_SQL = 'CREATE LOGIN [payletter] WITH PASSWORD=''' + @DBUSER_PASSWORD + ''', DEFAULT_DATABASE=[master], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF'
EXEC sp_executesql @DBUSER_CREATE_SQL
END
ELSE
PRINT 'User payletter already exists, skipping creation...'
IF NOT EXISTS (SELECT loginname FROM dbo.syslogins WHERE name = N'yogurting')
BEGIN
SELECT @DBUSER_CREATE_SQL = 'CREATE LOGIN [yogurting] WITH PASSWORD=''' + @DBUSER_PASSWORD + ''', DEFAULT_DATABASE=[master], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF'
EXEC sp_executesql @DBUSER_CREATE_SQL
END
ELSE
PRINT 'User yogurting already exists, skipping creation...'
/* For people using the modified database we need a user Monk */
IF NOT EXISTS (SELECT loginname FROM dbo.syslogins WHERE name = N'Monk')
BEGIN
SELECT @DBUSER_CREATE_SQL = 'CREATE LOGIN [Monk] WITH PASSWORD=''' + @DBUSER_PASSWORD + ''', DEFAULT_DATABASE=[master], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF'
EXEC sp_executesql @DBUSER_CREATE_SQL
END
ELSE
PRINT 'User Monk already exists, skipping creation...'
/* =========== ini3_py_account =========== */
IF EXISTS (SELECT name FROM sys.databases WHERE name = N'ini3_py_account')
BEGIN
ALTER DATABASE [ini3_py_account] SET OFFLINE WITH ROLLBACK IMMEDIATE
ALTER DATABASE [ini3_py_account] SET ONLINE
DROP DATABASE [ini3_py_account]
END
/* -- Recreate Database -- */
CREATE DATABASE [ini3_py_account]
GO
/* =========== INI3Bill_DB =========== */
IF EXISTS (SELECT name FROM sys.databases WHERE name = N'INI3Bill_DB')
BEGIN
ALTER DATABASE [INI3Bill_DB] SET OFFLINE WITH ROLLBACK IMMEDIATE
ALTER DATABASE [INI3Bill_DB] SET ONLINE
DROP DATABASE [INI3Bill_DB]
END
/* -- Recreate Database -- */
CREATE DATABASE [INI3Bill_DB]
GO
/* =========== Pangya_S4_TH =========== */
IF EXISTS (SELECT name FROM sys.databases WHERE name = N'Pangya_S4_TH')
BEGIN
/* -- Close all connections and drop the database -- */
ALTER DATABASE [Pangya_S4_TH] SET OFFLINE WITH ROLLBACK IMMEDIATE
ALTER DATABASE [Pangya_S4_TH] SET ONLINE
DROP DATABASE [Pangya_S4_TH]
END
/* -- Recreate Database -- */
CREATE DATABASE [Pangya_S4_TH]
DECLARE @DATABASE_PATH VARCHAR(256)
SELECT @DATABASE_PATH = physical_name
FROM sys.master_files
WHERE name = N'Pangya_S4_TH'
SET @DATABASE_PATH = REPLACE(@DATABASE_PATH, 'Pangya_S4_TH.mdf', '')
PRINT 'Pangya_S4_TH database resides at: ' + @DATABASE_PATH
/* --- Add File Groups and Files to the database Pangya_S4_TH --- */
DECLARE @ADDFILE_CARD_SQL varchar(256)
DECLARE @ADDFILE_GLOG_SQL varchar(256)
DECLARE @ADDFILE_ITEM_SQL varchar(256)
DECLARE @ADDFILE_MAIL_SQL varchar(256)
SET @ADDFILE_CARD_SQL = 'ALTER DATABASE [Pangya_S4_TH] ADD File ( NAME = Pangya_S4_TH_Card, FILENAME = N''' + @DATABASE_PATH + '\Pangya_S4_TH_Card.mdf'', SIZE = 1MB ) TO FILEGROUP Pangya_S4_TH_Card'
SET @ADDFILE_GLOG_SQL = 'ALTER DATABASE [Pangya_S4_TH] ADD File ( NAME = Pangya_S4_TH_gLog, FILENAME = N''' + @DATABASE_PATH + '\Pangya_S4_TH_gLog.mdf'', SIZE = 1MB ) TO FILEGROUP Pangya_S4_TH_gLog'
SET @ADDFILE_ITEM_SQL = 'ALTER DATABASE [Pangya_S4_TH] ADD File ( NAME = Pangya_S4_TH_Item, FILENAME = N''' + @DATABASE_PATH + '\Pangya_S4_TH_Item.mdf'', SIZE = 1MB ) TO FILEGROUP Pangya_S4_TH_Item'
SET @ADDFILE_MAIL_SQL = 'ALTER DATABASE [Pangya_S4_TH] ADD File ( NAME = Pangya_S4_TH_Mail, FILENAME = N''' + @DATABASE_PATH + '\Pangya_S4_TH_Mail.mdf'', SIZE = 1MB ) TO FILEGROUP Pangya_S4_TH_Mail'
ALTER DATABASE [Pangya_S4_TH] ADD FILEGROUP Pangya_S4_TH_Card;
ALTER DATABASE [Pangya_S4_TH] ADD FILEGROUP Pangya_S4_TH_gLog;
ALTER DATABASE [Pangya_S4_TH] ADD FILEGROUP Pangya_S4_TH_Item;
ALTER DATABASE [Pangya_S4_TH] ADD FILEGROUP Pangya_S4_TH_Mail;
EXEC(@ADDFILE_CARD_SQL)
EXEC(@ADDFILE_GLOG_SQL)
EXEC(@ADDFILE_ITEM_SQL)
EXEC(@ADDFILE_MAIL_SQL)
GO
some1 know where add Gm?
Thank Tsukasa
some question
Please edit the @DBUSER_PASSWORD for *
* your server. Leaving the default simply *
* isn't cool.
@DBUSER_PASSWORD do you mean sa password ?
Nope, simply replace 'Password' in the line SET @DBUSER_PASSWORD = N'Password' with your own password. Doesn't really matter, though. You can also leave it as 'Password' since you'll most likely use the 'sa' user for access to the database anyway. Basically we only create these users to satisfy the queries from the server package, not to actually use them :laugh: .Quote:
Originally Posted by darkknight
A word of warning here: If you already have a running setup, executing this will throw you back to the very beginning since it drops databases! It is, however, very useful if you played around too much and want to start off clean or if you are setting up the server for the first time.
anyone fixed the channel log in yet?
@Tsukasa
About your bootstrapper query... Everytime I run the query, I always got "Incorrect syntax near 'LOGIN'."
I used MSSQL 2005 btw.
@Tsukasa
If not bothered, could you please post a copy of its databases, for which I am not able to login here.
I'm using MSSQL 2008, so maybe there have been some subtle changes to what's acceptable. I'll look into it.Quote:
Originally Posted by tulang3587
If you registered and activated the account through ini3_py_account's stored procedures SP_PANGYA_REGIST and SP_PANGYA_ACTIVATE and it shows up in the database you might simply have to type the command "alluseropen" into the login server window.Quote:
Originally Posted by ragezonersonexa
--
The query hidden in the spoiler will update your vanilla database to the latest version in terms of tables and procedures. It's a collection of everything posted so far... If any of the procedures or tables already exist in your setup the query will simply notify you, skip the item in question and go on.
Attention: For some reason the procedure [dbo].[USP_CHAR_EQUIP_LOAD_S4] won't be created. Simply copy the [dbo].[USP_CHAR_EQUIP_LOAD] procedure, that should do the trick.
Spoiler:
@Tsukasa
No problem, I have the 2008 too
@Tsukasa
aww man you beat mo to it, yours is more organized than mine. LoL. why not just release it in .sql format?
Is anyone using Monk's DBs? are you getting Log in errors?
Oh man It missing
dbo.USP_CHAR_EQUIP_UCC_S4
2010-12-05 01:50:14 107 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_UCC_S4'.)
2010-12-05 01:50:14 107 Pang-CB Server 1 [F_QUERY] LastSuccQuery({ call dbo.USP_CHAR_EQUIP_LOAD_S4 (1) }), CurrQuery({ call dbo.USP_CHAR_EQUIP_UCC_S4 (1) })
I think queries are easier to update and a bit more flexible. Wouldn't want to post the entire database every time someone gets something done.Quote:
Originally Posted by chiosin2
Monks database works just as fine as the vanilla one from the server-package. The only differences are in the usernames and some minor edits methinks.Quote:
Originally Posted by chiosin2
When running the INI3BILL_DB.SQL you will encounter a few problems but it's safe to ignore them.
I've updated my previous post, it now contains all methods (see the attention note) to log into a channel. There isn't much to see or do there in the current state, though.
Tsukasa you has missing dbo.USP_CHAR_EQUIP_UCC_S4 ?
I search in Pangya_S4_TH.sql not found .
Quote:
Originally Posted by darkknight
Here you go, mate.Code:USE [Pangya_S4_TH]
GO
/****** Object: StoredProcedure [dbo].[USP_CHAR_EQUIP_UCC_S4] Script Date: 12/04/2010 20:10:02 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROC [dbo].[USP_CHAR_EQUIP_UCC_S4] (
@UID INT
) -- WITH ENCRYPTION
AS
/***********************
DESCRIPTION : GET CHARINFO OF USER EQUIP CHARACTER
??? ??? ???? ??? ????.
??. ??4. ????
OBJECT NAME : USP_CHAR_USER_EQUIP
CREATED BY : JAE WOONG LEE
LAST UPDATE : 2008-02-04
RETURN VALUES : SEQ(TINYINT 0:NONE)
EXCUTE : EXEC DBO.USP_EVENT_SEQ_S 123, 1
***********************/
BEGIN
SET NOCOUNT ON
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
DECLARE @CHAR_TYPEID INT
SELECT
@CHAR_TYPEID = TYPEID
FROM
DBO.PANGYA_USER_EQUIP A (NOLOCK)
INNER JOIN
DBO.PANGYA_CHARACTER_INFORMATION B (NOLOCK)
ON A.UID = B.UID
AND A.CHARACTER_ID = B.ITEM_ID
WHERE
A.UID = @UID
IF (@CHAR_TYPEID IS NOT NULL) BEGIN
EXEC DBO.USP_CHAR_EQUIP_LOAD @UID, @CHAR_TYPEID
END
SET NOCOUNT OFF
END
oh thankyou so much I can play in family mode
can't make room or quick mach
game has not lasted version:lol:
@Tsukasa mind i ask did you make this?
It seems that a lot of the procedures in S4 are just copies of "previous" methods already present in the database (just take a look at many other procedures previously posted in this thread, they can often be found all over the place in the database). So no, it's just a rebrand of another procedure that does the same but is called different.Quote:
Originally Posted by chiosin2
Since we have no insight into the inner workings (i.e. there's a procedure missing that's calling another missing procedure...) we better hope that we won't be running out of spares anytime soon
@Yup, exactly my thought. I'm not good at SQL but i do understand how it works, somewhat. but it will take some time to finish.
Hello, does anyone know which command does this:
http://i52.tinypic.com/2ytuqo3.jpg
The /notice does not do that
chiosin2 you can restore database
if this work for you - -
Pangya_S4_TH.rar
I managed to log in, most could not complete the tutorial.
For those not able to login, just open the server.ini and change the number of channels to 1, the GameServer will stay as it should.
Does anyone have a solution to the tutorial?
@darkknight thanks!
Edit: nope it doesn't restore properly i get Error: 3241
So the database is now complete? I see all can play the game now...^_^
I still can't see the channels.. the logs don't show any errors and i've configured the crap out of the server files. @_@ i'm really lost right now.
@darkknight
i use your .bak also get Error: 3241
I see, I've tried the queries using 2000, then 2005 with no avail...Quote:
Originally Posted by Tsukasa
I'll download the 2008 version first then, hopefully I'll be able to contribute to this thread.
The media family on device 'xxxx.BAK' is incorrectly formed. SQL Server cannot process this media family.
RESTORE HEADERONLY is terminating abnormally. (Microsoft SQL Server, Error: 3241)
The SQL server version is different. backups are not backward compatible. For example if the backup is created using SQL2008, you cannot restore it on SQL2005. You get SQL error 3241 - Restore Headeronly is terminating abnormally.
Well i cant see Final Database...
That's because there is no final database yet (unfortunately).Quote:
Originally Posted by gigok
The main screen is as far as you get. If you are lucky you can play Family Mode. Maybe chat a little. But that's about it.
Since all the "it's so easy to fix, here's a screenshot but no word on how to do it" guys are silent and won't share any information except "it's so easy" it will probably still take a while to get a somewhat usable server configuration (if we're so lucky as to ever get this to run).
As I'm not good with the database, I am starting the process of translating the client, I'll post soon a translation patch.
If you discover something, a procedure query, post it here, I believe that if all able to work together :D
http://img703.imageshack.us/img703/8647/pangya000u.jpg
http://img809.imageshack.us/img809/365/pangya001.jpg
http://img34.imageshack.us/img34/8751/pangya002k.jpg
http://img690.imageshack.us/img690/8376/pangya003r.jpg
http://img200.imageshack.us/img200/7251/pangya004l.jpg
http://img818.imageshack.us/img818/612/pangya006n.jpg
http://img535.imageshack.us/img535/5231/pangya007t.jpg
http://img707.imageshack.us/img707/5500/pangya008o.jpg
http://img823.imageshack.us/img823/3259/pangya000e.jpg
http://img716.imageshack.us/img716/5095/pangya001v.jpg
http://img6.imageshack.us/img6/7491/pangya001x.jpg
Updated...
* TD_CHAR_EQUIP_S4 by crashbufao *
* USP_CHAR_EQUIP_SAVE_S4 by crashbufao
Those procedures are from me!!
Everything works for me except cardpacks (for the moment) and cauldron (missing procedure).
http://img404.imageshack.us/img404/8...ngya043.th.jpg
Ah sorry, wouldn't know that from reading the posts - will correct it right away.Quote:
Originally Posted by bubbastic
Edit for your edit: Incredible progress and work judging from your screenshot. Did you have to create a lot of original procedures to achieve this? How did you work around the client version issue? I'd be thrilled to know more about the way you tackled this project (for educational reasons).
ragezonersonexa, very nice job so far :w00t:
@Tsukasa:
1 more post and you can send MP XD
Please contact me. I need your help to correct the cardpacks. And I can help for missing procedures ;)
@Fasa2008 can you contact me please. I want to talk to you about hexing the projectG
@ragezonersonexa : nice work so far ^^ How did you switch to scratch N°1 instead of cardremovers ?
Hey guys... I'm getting a problem after picking the server, it doesn't go any further. There are no errors on the server windows at all, it just doesn't do anything after picking server. On the gameserver window it does show connection from 127.0.0.1 but that's all, no error.
What's the workaround for this?
read the logfiles in log folders and look for query failedQuote:
Originally Posted by KS212
edited
I'll contact you right away.
By the way: For those who are interested in knowing specific item ids the Pangya EU encyclopedia has the item ids embedded in the page source (look for ItemID).
15 posts - yay.
Log for which server? And to clarify it's the channel bug. Pick the server and no channels listed, rather than just hang. I only just noticed that it does bring up the server name at the top.Quote:
Originally Posted by bubbastic
IDS are not the same for GG and TH. It depends on each versionQuote:
Originally Posted by Tsukasa
---------- Post added at 12:06 PM ---------- Previous post was at 12:02 PM ----------
It should be the gameserver logs. You'll see a query failed. Just open them all in notepad and read themQuote:
Originally Posted by KS212
That means that you miss a stored procedure that we have posted in this forum.
@bubbastic
Got it, thanks! I can get in now. Now i have your old problem... the 'you need to update pangya to the latest version' when trying to make a room.
How did you get around that? I'm using the 'final' projectg hex that fasa2008 did. The only update patch I applied to the client was the one pangya_patch_580.05_to_582.04.exe
Which one did you use?
Go in table Pangya_Server_ConfigQuote:
Originally Posted by KS212
Server version = 1.00
Client Version = 582.05 (or you version if you didn't updated to 582.05)
Client Version = 582.05
how to check verstion client
I 'am download lasted patch in th server
can't make room .
If you got the client and patch from Tsukasa's post on the first page you will be on 582.04
download this: http://download.ini3.co.th/pangya/ga..._to_582.05.exe
And you will be on 582.05.
Some of you know what's this?:
http://58.64.24.162:8090/upload/ucc/
Ok, room problem fixed.
More stupid questions... how do i:
1) add cookies/cash points
2) add more characters to play as (they're not listed in the shop to buy)
3) set account as GM
Sorry for my noobishness, I can't make head or tail of most of the tables.
an uploading system of seldesigns but as you can see you need a key that only the server can create for youQuote:
Originally Posted by TheLost
bubbastic, I would ask some of their database, so I can continue the work of translation. could you pass me?
I'm having a problem at the login, whenever I try to log in ID or PW incorrect, as the account PangYa_Member_Info signed up and nothing, can someone help me?
Did you activate your account? (Can be done by executing the stored procedure SP_PANGYA_ACTIVATE from ini3_py_account)Quote:
Originally Posted by renato__mouse
Did you open up the server? (Can be done by entering the command "alluseropen" in the login server window)
I'm having a similar issue. Even tried uninstalling Pangya, deleting the registry entries and manually patching it up to the 582.05 patch linked a few posts above. Am I missing some crucial point here?Quote:
Originally Posted by darkknight
Yes I applied the command Alluseropen, the problem is, and also the procedure already exists in ini3_py_account, but when I put 0 in NOIDCheck login.ini log normal, but with no password can be accessed accounts
wow i've been out for a while and i guess its still not a fully functional Server. anyways, i've made some progress of my own. might share it too.
How does command this:
http://i52.tinypic.com/2ytuqo3.jpg
I know /notice is not
In the server config (forgot exactly what table) is a column for client version. I put 582.05 in all 3 columns as well as the spot bubbastic said to put it in and it let me make a room. Can't do anything IN the room tho, can't start game... but it lets you make a room!
Oddly, I also had to change the noidcheck = 1 to let me log into the server.
[2] ME too! D:Quote:
Originally Posted by TheLost
Problems with making a room? download HEX editor
use fas2008's Pangya Final.
open EXE with hex editor
Find "582.00" Change to 582.05.
now you can make rooms.
How to create account?? @_@
Can you start game AFTER making room? I try setting the server.ini to allow ONEMANPLAY = 1 but it won't start.Quote:
Originally Posted by chiosin2