Printable View
Yeah H1GH that's the error I got.
The perfect english for it is:
How to fix: see my post below.Code:MMatchDBMgr::WinTheClanGame - Cannot find either column "dbo" or the user-defined function or aggregate "dbo.fnGetMax", or the name is ambiguous.
Transaction count after EXECUTE indicates that a COMMIT or ROLLBACK TRANSACTION statement is missing. Previous count = 0, current count = 1.
lol this is funny i had this in my old iGunz DB xD
Ok, finished.
spWinTheClanGame:
fnGetMaxCode:USE [GunzDB]
GO
/****** Object: StoredProcedure [dbo].[spWinTheClanGame] Script Date: 12/11/2007 14:40:03 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
/****** Object: Stored Procedure dbo.spWinTheClanGame Script Date: 5/10/2007 3:42:10 PM ******/
-- 클랜전 결과 업데이트
ALTER PROC [dbo].[spWinTheClanGame]
@WinnerCLID int,
@LoserCLID int,
@IsDrawGame tinyint,
@WinnerPoint int,
@LoserPoint int,
@WinnerClanName varchar(24),
@LoserClanName varchar(24),
@RoundWins tinyint,
@RoundLosses tinyint,
@MapID tinyint,
@GameType tinyint,
@WinnerMembers varchar(110),
@LoserMembers varchar(110)
AS
SET NOCOUNT ON -- 추가.
IF @IsDrawGame = 0
BEGIN
BEGIN TRAN
-- 이긴팀 Wins+1
UPDATE Clan SET Wins=Wins+1, Point=Point+@WinnerPoint, TotalPoint=TotalPoint+@WinnerPoint WHERE CLID=@WinnerCLID
IF 0 = @@ROWCOUNT BEGIN -- 여기 추가.
ROLLBACK TRAN
RETURN
END
-- 진팀 Losses+1
UPDATE Clan SET Losses=Losses+1, Point= dbo.fnGetMax(0, Point+(@LoserPoint)) WHERE CLID=@LoserCLID
IF 0 = @@ROWCOUNT BEGIN -- 여기 추가.
ROLLBACK TRAN
RETURN
END
-- UPDATE Clan SET Point=0 WHERE CLID=@LoserCLID AND Point<0
-- 전적 로그를 남긴다.
INSERT INTO ClanGameLog(WinnerCLID, LoserCLID, WinnerClanName, LoserClanName, RoundWins, RoundLosses, MapID, GameType, RegDate, WinnerMembers, LoserMembers, WinnerPoint, LoserPoint)
VALUES (@WinnerCLID, @LoserCLID, @WinnerClanName, @LoserClanName, @RoundWins, @RoundLosses, @MapID, @GameType, GETDATE(), @WinnerMembers, @LoserMembers, @WinnerPoint, @LoserPoint)
IF 0 <> @@ERROR BEGIN -- 여기 추가.
ROLLBACK TRAN
RETURN
END
COMMIT TRAN
END
ELSE
BEGIN
UPDATE Clan SET Draws=Draws+1 WHERE CLID=@WinnerCLID OR CLID=@LoserCLID
END
How to use: Copy and paste that spWinTheClanGame in place of your old spWinTheClanGame, and Execute.Code:if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[fnGetMax]') and xtype in (N'FN', N'IF', N'TF'))
drop function [dbo].[fnGetMax]
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
/****** Object: Function fnGetMax by tester001 Script Date: 12/11/2007 14:40:03 ******/
-- Function to return the highest of two numbers
CREATE function [dbo].[fnGetMax] (@num1 int, @num2 int)
returns int
as
begin
if @num1 > @num2
begin
return @num1
end
return @num2
end
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
Right click at "GunzDB" and click "New Query". Paste fnGetMax, right click and click Execute.
Backup first, as always.
Thanks to tester001.
Now let's get quest to work >:D
well well...
i found one fnGetMax funcion... i came here to show you... but... seens that you doesn't need... XD
H1GHL4ND3R did you get quests to work?
Mansion works 100% but Dungeon and Prison crash my server =/
i didn't tried anything yetQuote:
Originally Posted by Hakurah
but here i tested and the mansion and Dungeon worked fine...
just the Prison is Crashing the server...
i'm using the lastest xmls from Brazilian Server, i was thinking about to move all Prison quests to Mansion trying to find out what is happening...
well i tried to add you in the Msn Messenger but no sing if you don't mind PM me with your msn address...
we can talk better there....
After rechecking the crcs I got Dungeon to work, but Prison is still crashing just as it happens to you.
And, my Skeletons don't show up, they're all invisible. But I'm on my way :s
@Hakurah good for you keep at it!, thanks for the fix!
i belive that i found the problem with the Prison Quests...
these server files are from the begin of the year... at that time, theres no Prison quest in Brazilian server
the problem shoud be the NPCSET.XML that is a server site ONLY
so with the latests xmls files from brazilian client had calls for an inexistent npcset (the KXX used in prison)
i will try to merge some old npcset that i have with the brazilian server and test out...
but i'll only had time more later...
EDIT: i tested its working i just copy the dungeon npcset and changed to make an Prison... isn't crashing the server anymore...
i'll edit a bit more to fix some things...
an screenshot in my server when i'm testing the Prison Boss (Golem)
ImageShack - Hosting :: gunz213sn7.jpg
one of the "bugs" that i made is the other isn't minions they are also bosses so there in these SS is about the Golem + 5 Gigant Lizardman (boss)
i'll share the npcset.xml when i fix it...
um...NPCSET.XML id in system.mrs...
Great Post.
you suck or what why you dont ant to help me i did every thing i can't use the lactor becuase i didnt make hte password how i can fix it?
@sari4ever well thats a first...i think you need to learn to read better... or try my video TUT(not on this thread)
well, it is far way to be accuracy but is enough to server don't crash...
put the code below in your npcset.xml
later i will try make a code more accuracy based on Brazilian Server...Code:<!-- Prison QL 0 -->
<NPCSET id="10201" name="K01" basenpc="21">
<ADDNPC npc_id="21" min_rate="30" max_rate="30" />
</NPCSET>
<NPCSET id="10202" name="K02" basenpc="21">
<ADDNPC npc_id="21" min_rate="20" max_rate="20" />
<ADDNPC npc_id="22" min_rate="30" max_rate="30" />
</NPCSET>
<NPCSET id="10203" name="K03" basenpc="21">
<ADDNPC npc_id="21" min_rate="20" max_rate="20" />
<ADDNPC npc_id="22" min_rate="50" max_rate="50" />
</NPCSET>
<!-- Prison QL 1 -->
<NPCSET id="10211" name="K11" basenpc="21">
<ADDNPC npc_id="21" min_rate="30" max_rate="30" />
</NPCSET>
<NPCSET id="10212" name="K12" basenpc="21">
<ADDNPC npc_id="21" min_rate="20" max_rate="20" />
<ADDNPC npc_id="22" min_rate="30" max_rate="30" />
</NPCSET>
<NPCSET id="10213" name="K13" basenpc="21">
<ADDNPC npc_id="21" min_rate="20" max_rate="20" />
<ADDNPC npc_id="22" min_rate="50" max_rate="50" />
</NPCSET>
<NPCSET id="10214" name="K14" basenpc="22">
<ADDNPC npc_id="23" min_rate="30" max_rate="30" />
</NPCSET>
<!-- Prison QL 2 -->
<NPCSET id="10221" name="K21" basenpc="21">
<ADDNPC npc_id="21" min_rate="20" max_rate="20" />
<ADDNPC npc_id="22" min_rate="30" max_rate="30" />
</NPCSET>
<NPCSET id="10222" name="K22" basenpc="21">
<ADDNPC npc_id="21" min_rate="20" max_rate="20" />
<ADDNPC npc_id="22" min_rate="50" max_rate="50" />
</NPCSET>
<NPCSET id="10223" name="K23" basenpc="22">
<ADDNPC npc_id="23" min_rate="30" max_rate="30" />
</NPCSET>
<NPCSET id="10224" name="K24" basenpc="21">
<ADDNPC npc_id="21" min_rate="5" max_rate="5" />
<ADDNPC npc_id="22" min_rate="50" max_rate="50" />
<ADDNPC npc_id="23" min_rate="30" max_rate="30" />
</NPCSET>
<NPCSET id="10225" name="K25" basenpc="21">
<ADDNPC npc_id="21" min_rate="5" max_rate="5" />
<ADDNPC npc_id="22" min_rate="40" max_rate="40" />
<ADDNPC npc_id="23" min_rate="40" max_rate="40" />
<ADDNPC npc_id="24" min_rate="10" max_rate="10" />
</NPCSET>
<!-- Prison QL 3 -->
<NPCSET id="10231" name="K31" basenpc="21">
<ADDNPC npc_id="21" min_rate="20" max_rate="20" />
<ADDNPC npc_id="22" min_rate="50" max_rate="50" />
</NPCSET>
<NPCSET id="10232" name="K32" basenpc="22">
<ADDNPC npc_id="23" min_rate="30" max_rate="30" />
</NPCSET>
<NPCSET id="10233" name="K33" basenpc="21">
<ADDNPC npc_id="21" min_rate="5" max_rate="5" />
<ADDNPC npc_id="22" min_rate="20" max_rate="20" />
<ADDNPC npc_id="23" min_rate="30" max_rate="30" />
</NPCSET>
<NPCSET id="10234" name="K34" basenpc="21">
<ADDNPC npc_id="21" min_rate="5" max_rate="5" />
<ADDNPC npc_id="22" min_rate="20" max_rate="20" />
<ADDNPC npc_id="23" min_rate="40" max_rate="40" />
</NPCSET>
<NPCSET id="10235" name="K35" basenpc="23">
<ADDNPC npc_id="22" min_rate="20" max_rate="20" />
<ADDNPC npc_id="24" min_rate="50" max_rate="50" />
</NPCSET>
<!-- Prison QL 4 -->
<NPCSET id="10241" name="K41" basenpc="22">
<ADDNPC npc_id="23" min_rate="30" max_rate="30" />
</NPCSET>
<NPCSET id="10242" name="K42" basenpc="21">
<ADDNPC npc_id="21" min_rate="5" max_rate="5" />
<ADDNPC npc_id="22" min_rate="20" max_rate="20" />
<ADDNPC npc_id="23" min_rate="30" max_rate="30" />
</NPCSET>
<NPCSET id="10243" name="K43" basenpc="21">
<ADDNPC npc_id="21" min_rate="5" max_rate="5" />
<ADDNPC npc_id="22" min_rate="15" max_rate="15" />
<ADDNPC npc_id="23" min_rate="40" max_rate="40" />
</NPCSET>
<NPCSET id="10244" name="K44" basenpc="23">
<ADDNPC npc_id="23" min_rate="40" max_rate="40" />
<ADDNPC npc_id="24" min_rate="10" max_rate="10" />
</NPCSET>
<NPCSET id="10245" name="K45" basenpc="22">
<ADDNPC npc_id="23" min_rate="40" max_rate="40" />
<ADDNPC npc_id="24" min_rate="8" max_rate="8" />
</NPCSET>
<!-- Prison QL 5 -->
<NPCSET id="10251" name="K51" basenpc="21">
<ADDNPC npc_id="21" min_rate="15" max_rate="15" />
<ADDNPC npc_id="22" min_rate="10" max_rate="10" />
<ADDNPC npc_id="23" min_rate="40" max_rate="40" />
</NPCSET>
<NPCSET id="10252" name="K52" basenpc="21">
<ADDNPC npc_id="21" min_rate="10" max_rate="10" />
<ADDNPC npc_id="22" min_rate="10" max_rate="10" />
<ADDNPC npc_id="23" min_rate="50" max_rate="50" />
</NPCSET>
<NPCSET id="10253" name="K53" basenpc="23">
<ADDNPC npc_id="23" min_rate="40" max_rate="40" />
<ADDNPC npc_id="24" min_rate="5" max_rate="5" />
</NPCSET>
<NPCSET id="10254" name="K54" basenpc="22">
<ADDNPC npc_id="23" min_rate="40" max_rate="40" />
<ADDNPC npc_id="24" min_rate="8" max_rate="8" />
</NPCSET>
<NPCSET id="10255" name="K55" basenpc="22">
<ADDNPC npc_id="23" min_rate="30" max_rate="30" />
<ADDNPC npc_id="24" min_rate="15" max_rate="15" />
</NPCSET>
<!-- Prison QL 6 -->
<NPCSET id="10261" name="K61" basenpc="21">
<ADDNPC npc_id="22" min_rate="10" max_rate="10" />
<ADDNPC npc_id="23" min_rate="40" max_rate="40" />
</NPCSET>
<NPCSET id="10262" name="K62" basenpc="22">
<ADDNPC npc_id="23" min_rate="30" max_rate="30" />
</NPCSET>
<NPCSET id="10263" name="K63" basenpc="21">
<ADDNPC npc_id="22" min_rate="40" max_rate="40" />
<ADDNPC npc_id="23" min_rate="40" max_rate="40" />
</NPCSET>
<!-- Prison QL 6 -->
<NPCSET id="10271" name="K71" basenpc="21">
<ADDNPC npc_id="21" min_rate="20" max_rate="20" />
<ADDNPC npc_id="24" min_rate="30" max_rate="30" />
</NPCSET>
Hi.
I need a little help here...
I set up the server - evrything went just great.
Server works and i have no questions about it.
My question is about client... When i replaced files from english client my ingame cursor disappeared :-) It was in BR ver of client... If you can help me to deal with this problem... Or if you can`t just tell me what files are cursor files and i`ll try to set up cursor files from BR client. There are some files named cursor1....10 in default folder, but all of them are 0.0b ...
Help me if you can, please )