Need a Little Bit Help With ClanWar

Joined
Jan 9, 2007
Messages
1,622
Reaction score
104
Location
The Netherlands
Hey all,

i'm working on the clanwar procedures, i think i have the right procedure for WinTheClanGame but the score is not showing up in Gunz.

The GetClanInfo procedure i have is

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[spGetClanInfo]
@nCLID INT
AS
BEGIN
SET NOCOUNT ON;

SELECT CLID FROM Character
SELECT * FROM Clan
WHERE CLID = @nCLID
END

In gunz is only showing up The ClanName and the clanmaster name, but the score stays on zero.

Who can help me with it?

BTW: I put in some win and losses in the table manually but it wont showup
 
Hmm... I think you have to add more variables.. not only @nCLID.. Did you check bugga's wonderfull procs list?
 
Upvote 0
I've been trying for a while now to enable this feature.. no results.

Anyway, I used your proc, but my server still doesn't show points/rank/clan name/master name, nothing. Here's an screenshot:

Rotana - Need a Little Bit Help With ClanWar - RaGEZONE Forums


You did something else? What Match server are you using? Mine is 1.0 Translated by Pkedpker.
By the way, I know that this client displays that information, because I tested it on another server.
 
Upvote 0
For now this are mine results.

When i put in the procedure i posted in the first topic, the score want showup[better to say nothing]


I firured out that the matchserver support only

Select * From Character
Where CLID = @nCLID

or

Select * From Clan
Where CLID = @nCLID

Now i made an new storedprocedure

And the GetClanInFo runnes that one, but it still want show up
 
Upvote 0
When i put in the procedure i posted in the first topic, the score want showup[better to say nothing]

You mean that when you put that procedure the scores show up as 0?
Before that, you saw NOTHING like in my screenshot?

Can you post your updated procedure?
 
Upvote 0
Man it took me an entire day to figure out why clan war wasnt returning the right value, same thing with emblems but i finally did get them working. I'll post some of my code when i get home from school so you can take a look. I didn't write the complete Clan War procedure, so i am not able to post all the procedures without the content of the devs over at legacygamers.
 
Upvote 0
Man it took me an entire day to figure out why clan war wasnt returning the right value, same thing with emblems but i finally did get them working. I'll post some of my code when i get home from school so you can take a look. I didn't write the complete Clan War procedure, so i am not able to post all the procedures without the content of the devs over at legacygamers.

What did you do for the emblems? I could only get them working manually, but I couldn't get them to update with a set of online emblems. I tried hex-editing the URL in the exe for the clan emblems, but that didn't work for me, unless I just didn't have everything in the correct places on my FTP server.
 
Upvote 0
Now I've points, totalpoints and ranking (and the proc that updates de db to keep the information synched, ok, and ranking will be calculated by an external script or something, but it already shows). I'll clean the sql and post later if no one did, but I'm still missing Emblems too. Any help on that one?
 
Upvote 0
Man it took me an entire day to figure out why clan war wasnt returning the right value, same thing with emblems but i finally did get them working. I'll post some of my code when i get home from school so you can take a look. I didn't write the complete Clan War procedure, so i am not able to post all the procedures without the content of the devs over at legacygamers.

First thanks for helpinf us out.
And second can you post some usefull hints/tips or maybe an example.
 
Upvote 0
Now I've points, totalpoints and ranking (and the proc that updates de db to keep the information synched, ok, and ranking will be calculated by an external script or something, but it already shows). I'll clean the sql and post later if no one did, but I'm still missing Emblems too. Any help on that one?

I spoke to Mackintosh and I was right about the emblems. Search for "http://" in a hex-editor in Gunz.exe and it should show something like netmarble.com/cwfile or something. Just change that to your own FTP directory. The problem I was having when I did it was that my cw procs aren't done, so that's why the emblems didn't work for me when I tried it. But if your procs are done, it should work.
 
Upvote 0
How about the scores for the clanwar?

I got now this Procedure for GetClanInfo

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO

ALTER PROCEDURE [dbo].[spGetClanInfo]
@nCLID INT

AS
BEGIN
SET NOCOUNT ON;

SELECT CLID From Character
WHERE CLID = @nCLID
EXEC [dbo].[Test] @Return_value = @nCLID
END

And this is the test Procedure

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO

ALTER PROCEDURE [dbo].[Test]
@Return_value INT
AS
BEGIN




SELECT Ranking, Losses, Wins, Point, TotalPoint, EmblemUrl, Clanmaster FROM Clan
Where CLID = @Return_value
END

But the problem is in the game the clan score and other are empty
But when i execute the procedure GetClanInfo with 1 as value form CLID it will show the score. But not in the game?
 
Upvote 0
I spoke to Mackintosh and I was right about the emblems. Search for "http://" in a hex-editor in Gunz.exe and it should show something like netmarble.com/cwfile or something. Just change that to your own FTP directory. The problem I was having when I did it was that my cw procs aren't done, so that's why the emblems didn't work for me when I tried it. But if your procs are done, it should work.

Sweet. I'll try that when I get back home.
Thanks!
 
Upvote 0
Back