How many edits have I made and how much more until I earn the badges?

0

Please login or register to vote for this query.

(click on this box to dismiss)

Determines how many edits a user has made as well as how many more edits until the `Editor`, `Strunk & White` and `Copy Editor` badges are earned.

English

Q&A for linguists, etymologists, and serious English language enthusiasts

-- How many edits have I made and how much more until I earn the badges?
-- Determines how many edits a user has made as well as how many more edits until the `Editor`, `Strunk & White` and `Copy Editor` badges are earned.

DECLARE @UserId int = ##UserId##     -- User id to search for

DECLARE @Badge1 int = 1              -- Editor edit count
DECLARE @Badge2 int = 80             -- Strunk & White edit count
DECLARE @Badge3 int = 500            -- Copy Editor edit count

DECLARE @EditCount int

SELECT @EditCount = COUNT(*)
    FROM Posts p
    JOIN PostHistory h ON p.Id = h.PostId
    WHERE p.OwnerUserId != @UserId AND h.UserId = @UserId

DECLARE @UntilBadge1 int = CASE WHEN (@Badge1 - @EditCount) < 0 THEN 0 ELSE @Badge1 - @EditCount END
DECLARE @UntilBadge2 int = CASE WHEN (@Badge2 - @EditCount) < 0 THEN 0 ELSE @Badge2 - @EditCount END
DECLARE @UntilBadge3 int = CASE WHEN (@Badge3 - @EditCount) < 0 THEN 0 ELSE @Badge3 - @EditCount END

SELECT @EditCount   AS "Edit count",
       @UntilBadge1 AS "Edits needed to earn 'Editor' badge",
       @UntilBadge2 AS "Edits needed to earn 'Strunk & White' badge",
       @UntilBadge3 AS "Edits needed to earn 'Copy Editor' badge"

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results