Need a Little Bit Help With ClanWar

[alduath]

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. :(

[WhiteMoga]

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

[alduath]

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.

[WhiteMoga]

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

[alduath]

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

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

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.

[WhiteMoga]

Ill see if I can fiddle with it

EDIT: It works fine for me on the following table, even without the two selects.

And for those who need it, heres the table, I had to make this myself, being as I never got the one we had on LGGunz at the time.

USE [GunzDB]
GO
/****** Object:  Table [dbo].[Clans]    Script Date: 03/09/2007 20:19:28 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Clans](
	[CLID] [int] IDENTITY(1,1) NOT NULL,
	[Level] [int] NULL,
	[Name] [varchar](50) NULL,
	[ClanMaster] [varchar](50) NULL,
	[EmblemUrl] [varchar](50) NOT NULL,
	[TotalPoint] [int] NULL,
	[Point] [int] NULL,
	[Wins] [int] NULL,
	[Losses] [int] NULL,
	[MemberCount] [int] NULL,
	[Ranking] [int] NULL,
	[EmblemChecksum] [int] NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF

[alduath]

Omg, my table had the incorrect type for EmblemChecksum, it was varchar(200) (i downloaded it from the "full clan without clanwars" post that is somewhere near here).

I'll try the Emblems thingy now, thanks a lot!.

[WhiteMoga]

Yeah, I made full clans today off of the table in GetClanInfo, and I spent a while getting them the right type to work.