Need a Little Bit Help With ClanWar

[Rotana]

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

[MentaL]

[mts]

Hmm... I think you have to add more variables.. not only @nCLID.. Did you check bugga's wonderfull procs list?

[Rotana]

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

[Rotana]

can someone help?

[k0ven]

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.

[Rotana]

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

[k0ven]

Well good luck, counting on you.

[alduath]

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:



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.

[Rotana]

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

[alduath]

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?

[Rotana]

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

[InnerDark]

maybe u need a new table? not under clans?

[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.

[RepublicOfAstra]

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.

[alduath]

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?

[Rotana]

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.

[RepublicOfAstra]

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.

[Rotana]

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?

[alduath]

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!

[InnerDark]

blargh, but how do u get checksum for embelm? >.<

[Rotana]

MackInTosh [or someone else ofcourse] can you help out with the score?

[Linear88]

Shouldn't it be create not alter?

[Rotana]

if you wanna create the procedures then it must be create,

dont need to make it, it wont work in the game :S

[alduath]

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.

Now it's working? I think my CW procs are done, since they show points and ranking, etc, and the points are being updated on the DB after a clanwar.

If I add emblems to emblem.xml manually, emblems show up in the game, but i can't get gunz to download emblems automatically.

I already hex-edited my runnable so it has as a base URL an URL of mine. And I have my emblems hosted there.

In the Clan table, at EmblemUrl field I tried both full URL and relative URL. No results. It just wont download the emblems.

A work-around may be to add emblems as part of the patches, and download it using gunzlauncher (mine is fully working), changing the path for emblems on the runnable and that's it. But that approach would be -disgusting-.

I think that my runnable and MatchServer.exe are not getting the EmblemChecksum field, and that's where the problem is, but no clue or how to fix it. Currently, in spGetClanInfo i'm fetching all clan fields (in a particular order to make it work), but if I add EmblemChecksum to the query, my MatchServer.exe gets an access violation -.-

So what i'm doing is a SELECT for EmblemChecksum on a second query on the same proc. And i guess that's wrong.. and that's why gunz won't download emblems.

If you have any clue on this, please -please- help me out.

For the topic starter: You just need to make spWinTheClanGame to update points, and btw, the info for that proc in Buga's release is wrong. (The # of parameters and types are ok, but the comments of what is every parameter is wrong, just make a spWinTheClanGame to log it's parameters to an auxiliary table and you will understand what does every parameter means).

[WhiteMoga]

Yur they were wrong, I just made guesses, as I dont have anyone to make ClanWar games with.

Anyways, if you look in the EXE, spGetClanInfo returns:

CLID
Level
Name
ClanMaster
EmblemUrl
TotalPoint
Point
Wins
Losses
MemberCount
Ranking
EmblemChecksum