CREATE PROCEDURE [dbo].[select_battleResults] 
	(
	 @userID int
	 )
AS SET NOCOUNT ON 

SELECT challenger_userID,opponent_userID, challenger_totalWins (not sure best way to get this value), challenger_winPercentage (again?), opponent_winPercentage (or this one) FROM tblBattles

WHERE challenger_userID = @userID OR opponent_userID = @userID 


CREATE TABLE [dbo].[tblBattles](
	[battleID] [int] IDENTITY(1,1) NOT NULL,
	[challenger_userID] [int] NOT NULL,
	[opponent_userID] [int] NOT NULL
) ON [PRIMARY]



CREATE TABLE [dbo].[tblBattle_Votes](
	[voteID] [int] IDENTITY(1,1) NOT NULL,
	[battleID] [int] NOT NULL,
	[voter_userID] [int] NOT NULL,
	[winner_userID] [int] NOT NULL,
	[voteDate] [datetime] NOT NULL
) ON [PRIMARY]

SELECT		b.BattleID,
		CASE
			WHEN @UserID = b.challenger_userID THEN 'Challenger'
			ELSE 'Opponent'
		END AS BattleType,
		SUM(CASE
			WHEN @UserID = bv.winner_userID THEN 1.0
			ELSE 0.0
		END) / COUNT(*) AS WinningPercentage
FROM		tblBattles AS b
INNER JOIN	tblBattle_Votes AS bv ON bv.BattleID = b.BattleID
WHERE		@UserID IN (b.challenger_userID, b.opponent_userID)
GROUP BY	b.BattleID,
		CASE
			WHEN @UserID = b.challenger_userID THEN 'Challenger'
			ELSE 'Opponent'
		END

quote:

---

Originally posted by Peso

How do you know if it is a "win"?

---

E 12°55'05.25"
N 56°04'39.16"

---

quote:

---

Originally posted by Peso

Is this system available online?
If so, please add me so I can see the system where I have suggested at least 50% of the "hard code"

---

E 12°55'05.25"
N 56°04'39.16"

---