Interesting stuff, probably more to respond to than the below I was going to post in zultar's thread but didn't want to take that back off the rails..
I can say we can rule out going back to a wild-west approach, that's one thing I think we're unanimous on.
jamesa7171 wrote: ↑Sat Mar 11, 2023 11:42 pm
Out of curiosity, do you have stats on how many people view the forum, but don't post? It is a well-known Internet phenomenon that the vast majority of a site's users will typically never comment or contribute even if they are constantly consuming and observing others' contributions (see
here for a Wiki page on this, or
here for an example as applied to Reddit).
If there are 5 people commenting on a "drama situation" but 50 people reading it without commenting on it, then it is a bigger deal than it would first appear. (This is even more true when considering causal factors, i.e. maybe those people aren't contributing precisely because of the drama situations.)
I did look at some stats but didn't want to post as I think bot games cause some wonkyness in the numbers recently, so here are some stats but take them with a pinch of salt:
Main thing is the orange line, forum users, vs the green line, logged on users, and the blue dashed line, forum messages, vs the grey dashed line, game messages, and also the steady decline of the orange.
I don't have forum views, at least not for people viewing the home page.. I could look at the number of views on threads but that wouldn't be unique users rather total hits. I don't buy the whole "5 people said they were offended, so in reality 50,000 were offended", or the even desire to prevent anyone from being offended in any way.
Jamiet99uk wrote: ↑Fri Mar 10, 2023 11:05 pm
I was banned from the site for saying it's ok to violently stand up to Nazis.
My position was clear: You're a an outright Nazi, you give up the right to be treated sensibly and without violence. People have the right to kill you because you are a fucking Nazi.
Wanna ban me again?
Seems weird reading this and yet you're saying I should've thought twice before making a joke in your thread about IWD. (That was intended to be read in favor of IWD)
A ban for either seems a bit much to me, though I can imagine someone could get offended by either. (Or by a red brick)
aarodactyl wrote: ↑Sat Mar 11, 2023 4:13 am
This Kestas guy is giving me Elon Musk vibes tbh.
Oof.. Elon Musk after putting a Tesla into space on a Falcon Heavy, or Elon Musk after he took over Twitter?
Either way I don't think I deserve that comparison..
If the latter I am offended btw, and therefore 10,000 people are offended. (*j/k*)
Chaqa wrote: ↑Sat Mar 11, 2023 12:18 am
We should put ChatGPT in charge of moderating the forum
Ah wouldn't that be nice .. It could have a dial for sensitivity and list of okay and not okay topics.. I bet we'll see something like that available as a service before long, then we can all blame the machine.
I do like the thoughts about having a Discord/moving elsewhere instead.. Backstabbr does fine without a forum etc, and I think the future of Diplomacy sites is to be more decentralized and have users go from site to site depending on which is best for a certain type of game
Edit: Stashing the sql to generate stats here in case it comes up again:
Code: Select all
SELECT CONCAT(Y,'-',m) ym ,SUM(b) forummsgs, SUM(u) forumusers, SUM(gb) gamemsgs, SUM(gu) gameusers, SUM(gg) games, SUM(ausers) ausers, SUM(ahits) ahits
FROM (
SELECT Y, m, SUM(b) b, SUM(u) u
FROM (
SELECT YEAR(FROM_UNIXTIME(timeSent)) y, MONTH(FROM_UNIXTIME(timeSent)) m, COUNT(*) b, COUNT(DISTINCT fromUserID) u
FROM wd_forummessages
GROUP BY YEAR(FROM_UNIXTIME(timeSent)), MONTH(FROM_UNIXTIME(timeSent))
UNION ALL
SELECT YEAR(FROM_UNIXTIME(post_time)) y, MONTH(FROM_UNIXTIME(post_time)) m, COUNT(*) b, COUNT(DISTINCT poster_id) u
FROM phpbb_posts
GROUP BY YEAR(FROM_UNIXTIME(post_time)), MONTH(FROM_UNIXTIME(post_time))
) s
GROUP BY Y, m
) x
INNER JOIN (
SELECT YEAR(FROM_UNIXTIME(timeSent)) gy, MONTH(FROM_UNIXTIME(timeSent)) gm, COUNT(*) gb, COUNT(DISTINCT m.userID) gu, COUNT(DISTINCT m.gameID) gg
FROM wd_gamemessages gm
INNER JOIN wd_members m ON m.gameID = gm.gameID AND m.countryID = gm.fromCountryID
WHERE gm.fromCountryID <> 0 OR gm.toCountryID <> 0
GROUP BY YEAR(FROM_UNIXTIME(timeSent)), MONTH(FROM_UNIXTIME(timeSent))
) z ON z.gy = x.y AND z.gm = x.m
INNER JOIN (
SELECT YEAR(lastRequest) ay, MONTH(lastRequest) am, COUNT(DISTINCT userID) ausers, SUM(hits) ahits
FROM wd_accesslog gm
GROUP BY YEAR(lastRequest), MONTH(lastRequest)
) q ON q.ay = x.y AND q.am = x.m
GROUP BY y,m
ORDER BY Y,m;