Need a Little Bit Help With ClanWar

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.

---

First thanks for helpinf us out.
And second can you post some usefull hints/tips or maybe an example.

Quote:

---

Originally Posted by 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?

---

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.

How about the scores for the clanwar?

I got now this Procedure for GetClanInfo

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
WHERE CLID = @nCLID
EXEC [dbo].[Test] @Return_value = @nCLID
END

---

And this is the test Procedure

Quote:

---

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?

Quote:

---

Originally Posted by RepublicOfAstra

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!

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

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

Shouldn't it be create not alter?

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

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

Quote:

---

Originally Posted by RepublicOfAstra

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

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:

Quote:

---

Originally Posted by return

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

---

Yup, but not in that order. I went into the exe too and if I use that order, it wont show up even the points. :(

Didn't you say you got it to work though?

Yeah, with a different order, not the same in the .exe file. Anyway, if I add EmblemChecksum on the SELECT statment,, my matchserver gets an access violation exception. No matter where I add it. :S

I'll keep debugging it, probably the real order is hidden somewhere.

What order do you have? In reality the order should just be what I listed backwards.

Not really, If I use that order, It crashes.

My current spGetClanInfo (do not use it unless you don't care about emblems):

Code:

---

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

    SELECT CLID, Level, Name, ClanMaster, TotalPoint, Point, Wins, Losses, MemberCount, Ranking, EmblemUrl FROM Clan WHERE CLID=@nCLID
    SELECT EmblemChecksum FROM Clan WHERE CLID=@nCLID
END

---

Everything works but not checksum. If I add checksum anywhere, access violation happens. :S

Oh and BTW, if you remove the second SELECT, not even points show up, and a getClanInfo::Invalid Descriptor Index is logged.