Newbie Spellweaver
- Joined
- Dec 10, 2010
- Messages
- 30
- Reaction score
- 0
Can someone help me with this error ?
Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!
Join Today!What change do you exist when the value of ISCASH, TYPE, and IS_SALABLE is changed?i finally finished my tool.
heres a SQL script for all shop items,
just run it on sql and have fun
use USP_NICKNAME_UPDATE
Hey Guys can someone help me solve this problem
You must be registered to see links
I can log in i see the server but i cant see any channels would be great if someone can help me pls.
No one got a clue?
Where do I download the file ClubSet.iff?
How do i add Clubset and balls ?
As a lot of you asked how to set a GM account here is the answer :
in Pangya_member_info table, just put 4 in capability and there you are a GM .
It was not difficult eh?
Now search by yourself on how to add the title XD
USE [Pangya_S4_TH]
GO
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go
ALTER 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
AND CHAR_ITEMID = @CHAR_ITEM_ID
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
Here's the query fix:
Code:USE [Pangya_S4_TH] GO set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go ALTER 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 AND CHAR_ITEMID = @CHAR_ITEM_ID 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
Hello All !
* ProjectG 583.00
* Unpacked
* IP: 127.0.0.1 ~hohoho
* Game Guard Removed
* Loader's Game Guard Removed
* ProjectG Multi-Client
* Exclusive RageZone
* New Features
* No Erro's
* More Support Paks
Credits: Fasa2008 <<<
You must be registered to see links
open the pangya_th.iff and you will get it
I did not understand what I have to do in pangya_th.iff?
open it use rar and you will get it
This actually happened to me once, but I don't think your case is the same. Are you sure sqlservr.exe is running? I remember needing to turn it off once, then I forgot to turn it back on.
Of course, I'm 99% sure that isn't the problem. A quick google search of that error code will help you, though.
Do i need to set it one somwhere? cause i noticed it is indeed not running, but when i try and use the RUN command it comes up with this errorYou must be registered to see links
Run the SQL Server Configuration Manager; you can control what SQL services are running from there. If for some reason it doesn't work, reboot your computer, and use the config manager to turn off the server from now on if you ever want to.
Well the config manager says everythings running but the sql server Browser and sql server agent, so idk if those are the issue, but im confused on why i can access the databases with Pangya, but not ms sql. and ive restarted my comp several times now with no results
This is where Google is your friend. Search for the error code you posted, and look around for answers.