## Alternative Reputation Breakdown

1

(click on this box to dismiss)

Q&A for people studying math at any level and professionals in related fields

``````-- Does not currently include:
--   - Bounties paid
--   - Rep loss from downvoting others people's answers
--   - Reputation loss from Spam or Rude/Abusive flags

-- UserId: User ID
DECLARE @UserId int = ##UserId:int##;
-- AssociationBonus: Association bonus
DECLARE @AssociationBonus int = ##AssociationBonus:int?100##;
DECLARE @VoteCutoff1 int = ##VoteCutoff1:int?10##;
-- RepValue1: are worth:
DECLARE @RepValue1 int = ##RepValue1:int?10##;
DECLARE @VoteCutoff2 int = ##VoteCutoff2:int?10##;
-- RepValue2: are worth:
DECLARE @RepValue2 int = ##RepValue2:int?5##;
DECLARE @VoteCutoff3 int = ##VoteCutoff3:int?20##;
-- RepValue3: are worth:
DECLARE @RepValue3 int = ##RepValue3:int?2##;
-- RepValue4: Last votes are worth:
DECLARE @RepValue4 int = ##RepValue4:int?1##;
-- AcceptedEditRep: Accepted edit rep:
DECLARE @AcceptedEditRep int = ##AcceptedEditRep:int?2##;

DECLARE @Offset1 int = @VoteCutoff1 * @RepValue1;
DECLARE @Offset2 int = @Offset1 + @VoteCutoff2 * @RepValue2;
DECLARE @Offset3 int = @Offset2 + @VoteCutoff3 * @RepValue3;

WITH myposts AS (
SELECT
p.Id as Id,
sum(case when v.VoteTypeId = 2 then 1 else 0 end) as Upvotes,
sum(case when v.VoteTypeId = 3 then 1 else 0 end) as Downvotes,
sum(case when v.VoteTypeId = 1 then 1 else 0 end) as Accepts,
sum(case when v.VoteTypeId = 9 then v.BountyAmount else 0 end) as Bounty
FROM
Posts p
INNER JOIN Votes as v ON
p.OwnerUserId = @UserID AND
v.PostId = p.Id
LEFT JOIN Posts as mine ON -- Filter accepts of self-answers
mine.OwnerUserId = @UserID AND
v.VoteTypeId = 1 AND -- Accepted answer
p.ParentId = mine.Id
WHERE
mine.Id IS NULL
GROUP BY
p.Id
),

scorecomp AS (
SELECT
Id,
Accepts,
Bounty,
FROM
(VALUES
(0,                                          @RepValue1, 0),
(@VoteCutoff1,                               @RepValue2, @Offset1),
(@VoteCutoff1 + @VoteCutoff2,                @RepValue3, @Offset2),
(@VoteCutoff1 + @VoteCutoff2 + @VoteCutoff3, @RepValue4, @Offset3)
ORDER BY Mapping.Votes DESC) + myposts.Accepts * 15 + myposts.Bounty as RepCap,
Upvotes * 10 - Downvotes * 2 + Accepts * 15 + Bounty as CurrentRep
FROM
myposts
)

SELECT
Bounty as [Bounty],
IIF(RepCap >= CurrentRep, CurrentRep, RepCap) as [New Reputation],
CurrentRep as [Current Reputation]
FROM
scorecomp
ORDER BY
CurrentRep DESC``````

### Enter Parameters

Options:
-
Switch sites:
Hold tight while we fetch your results
:records returned in :time ms:cached