Posts: 3,700
Threads: 144
Joined: Aug 2009
Staff roles: Server Manager Coding Dev Moderator
(01-15-2018, 01:10 AM)Thunderer Wrote: Gallia is the 2nd least mentioned word on the list, [...]? Might be because it didn't exist from the very start.
That'll be at least part of it. Gallia probably did not publicly exist until around 2009-03-08 (and even that would only be the Gallic Border Worlds), and at least 3.75 years worth of posts before that.
If we only include posts from on or after that date (excluding about 15.9% of posts, which were made before it), the main things look more like this:
liberty - 173723
rheinland - 102785
kusari - 97632
zoner - 74384
bretonia - 59934
zoners - 59000
omicron - 48542
gallia - 45996
outfcast - 40666
admins - 38052
nomads - 37977
outcasts - 33628
(01-15-2018, 01:10 AM)Thunderer Wrote: I'm quite surprised there is no word "gank" on the list, though. Legitimately surprised. I expected it to be somewhere near the top.
gank - 4942
ganked - 3033
ganking - 2690
'gank' as a string appears at least once in 9107 different posts (so this doesn't account for it appearing multiple times in the same post), so on average probably in about 2 posts per day
incoming - 42548
transmission - 122397
interesting
Might be related to some bug I have in my code... A lot of 'incoming transmission' on the forums would appear right next to BBCode which probably trips it up.
A least some of it seems legitimate though:
Code:
MariaDB [dgcforum]> select count(1) from mybb_dgc_posts where lower(message) like '%incoming%';
+----------+
| count(1) |
+----------+
| 98281 |
+----------+
1 row in set (29.16 sec)
MariaDB [dgcforum]> select count(1) from mybb_dgc_posts where lower(message) like '%transmission%';
+----------+
| count(1) |
+----------+
| 144977 |
+----------+
1 row in set (29.16 sec)
(01-15-2018, 01:12 PM)Shikizumi Wrote: @Alex.
Make up a queary for rp sections only. Would be interesting too.
Top 20 for RP sections (subforums of 9 and 60, forum 67) using select message from mybb_dgc_posts join mybb_dgc_forums on (mybb_dgc_posts.fid = mybb_dgc_forums.fid) where find_in_set('9', mybb_dgc_forums.parentlist) or find_in_set('60', mybb_dgc_forums.parentlist) or mybb_dgc_forums.fid = 67
the - 3742378
to - 2443918
and - 1832360
of - 1717181
a - 1616395
i - 1481568
in - 1055736
you - 1012231
that - 784626
for - 725079
it - 716595
is - 660971
was - 626812
we - 586883
as - 579825
with - 567459
on - 534496
be - 515422
he - 498545
this - 481534
lel. So many broken links leading to deleted images.
I'm quite surprised there is no word "gank" on the list, though. Legitimately surprised. I expected it to be somewhere near the top.
Also surprised that Bretonia is the least mentioned House (not counting Gallia, #delete). It's almost twice less mentioned than the next least mentioned House, Kusari. Interestingly, the House whose faction is the most active on the server (and has a history of decent activity) is less mentioned than the least active House on the server. Maybe because there's just been less problems with Bretonia, so there's been less need to mention it. However, Gallia is the 2nd least mentioned word on the list, although it's the main problem of Discovery? Might be because it didn't exist from the very start.