Need a Little Bit Help With ClanWar

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

Quote:

---

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?

I select CLID from character and then the rest from Clan, but for a wierd reason it wont load the winn and losses and other information

can someone help?

Hope you figure it out soon, but people no longer care to do it, instead of 4 or 5 competent coders get together and code that crap.

I do mine best to figure it out.

The problem is when there more then 1 variable in the GetClanInfo procedure the matchserver will show up an error.

But i'm working on it :D

Btw i'm not the best SQL writer but someone has to do it :D

Well good luck, counting on you.

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:

http://img240.imageshack.us/img240/2804/gunz153jl6.jpg

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.

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

Quote:

---

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

Quote:

---

Originally Posted by Rotana

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?

I can posted it but you need also an modded Matchserver.exe, other wise it want work

maybe u need a new table? not under clans?

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.

Quote:

---

Originally Posted by MackInTosh

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.

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?