Home » Other » Suggestions & Feedback » Site statistics
Re: Site statistics [message #661975 is a reply to message #661974] Mon, 10 April 2017 02:05 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Oh, yes! Decision to enforce moderators' approval for Forum newbies was absolutely marvelous. I don't think that any of "serious" posters had to wait for long before his/her message was approved, but it drastically affected spammers. Congratulations to everyone!
Re: Site statistics [message #662001 is a reply to message #661975] Tue, 11 April 2017 11:50 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

They found a new way: the first message is something like "thanks for the question" which is something we can't not approve, then come the spam.
So if you have such message as first one, do not approve it until OP post another one (which will then also be waiting for approval).

Re: Site statistics [message #662004 is a reply to message #662001] Tue, 11 April 2017 15:31 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
the spammer is/was jeremyc1720; so avoid approving any future posts from him.
Re: Site statistics [message #662006 is a reply to message #662004] Wed, 12 April 2017 00:24 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

He is banned, as the other previous ones.

Re: Site statistics [message #664854 is a reply to message #661974] Tue, 08 August 2017 11:26 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Forum statistics have been updated with the last quarter figures.
Sorry for the delay but I made some internal modifications to crunch the data:

1/ IP ranges allocated to countries are temporary so all along these almost 20 years they move and I had to reconstruct the IP database for the previous quarters and when not available I used the data from the closest quarter I have. An example is some IP ranges that were allocated to South Africa are now to Sudan, the consequence, if I have used the current database, is that the first users of this site were from Sudan, I think some would be surprised to know they are Sudaneses. Smile

2/ Some IP are located to a whole continent and not a specific country and so are ignored for statistics about countries. In these cases I now set the country from the location of the greatest number of messages. For instance, John Watson registered with an IP located in Europe, no specific country, most of his messages are posted from United Kingdom so I located him in this country (but not his messages, messages that are clearly located in a country still belongs to this country).

3/ The IP database saw its format changed; from (simplifying) a "FromIP;toIP;country" format it has changed to a CIDR notation so I had to change the way I crunch it.

About the spammers:
/forum/fa/13596/0/
  • Attachment: MemBan2G.JPG
    (Size: 101.52KB, Downloaded 4048 times)
Re: Site statistics [message #666077 is a reply to message #664854] Thu, 12 October 2017 03:42 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Forum statistics have been updated with the last quarter figures.

Re: Site statistics [message #667763 is a reply to message #666077] Sun, 14 January 2018 13:11 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Forum statistics have been updated with the last quarter figures.

Re: Site statistics [message #667764 is a reply to message #667763] Sun, 14 January 2018 14:16 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Thank you, Michel!

Tragically, almost 90% of members posted up to 3 messages (while almost 50% of registered members didn't post a single message). This is turning into a moderators only club; now and then someone posts something, but vast majority of messages is posted by only a few active members (read: moderators, with honorable exceptions of Ed who didn't turn 1000 messages and flyboy who declined the offer (as far as I remember)).

Now, what does that mean? That people find answers simply by Googling, or do they prefer other forums over OraFAQ (I can't tell; OTN Forums are probably well-visited. dBforums shut down a week or two ago. You might know some others), or ...?

As of spammers: there aren't many of them recently, are they? I downloaded statistics ZIP file but it doesn't contain that info.
Re: Site statistics [message #667765 is a reply to message #667764] Sun, 14 January 2018 14:52 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Many (most of?) "occidental" forum have seen their number of posters decrease since Indians were able to create their own blog for free 10 years ago. Many of our former Indian posters who were beginners have now their blogs. The content of these blogs is for most part FAQs, starting from an error or a question found in other forum (like OraFAQ) and explaining how to solve. The advantage of these blogs is to directly provide the solution for a problem, and in the words of their culture; nothing to ask, nothing to explain, and more suitable to their mind. Some of them are listed in our blogs page, have a look to them.
The number of regulars is quite stable, some go others come.

I posted banned accounts when there was a problem now it is quite stable. Here's the chart:
/forum/fa/13735/0/
  • Attachment: MemBan2G.JPG
    (Size: 86.03KB, Downloaded 3977 times)

[Updated on: Sun, 14 January 2018 14:52]

Report message to a moderator

Re: Site statistics [message #667766 is a reply to message #667765] Sun, 14 January 2018 15:17 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
OK, I understood the explanation, thank you.

Spammers: that looks exactly like graph you posted in August 2017, doesn't it?
Re: Site statistics [message #667767 is a reply to message #667766] Sun, 14 January 2018 15:24 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Oops, did not update it, here's the current one:
/forum/fa/13736/0/
  • Attachment: MemBan2G.JPG
    (Size: 86.28KB, Downloaded 3722 times)
Re: Site statistics [message #667769 is a reply to message #667767] Sun, 14 January 2018 23:54 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Nice. Spammer-free zone Smile
Re: Site statistics [message #669658 is a reply to message #667769] Sun, 06 May 2018 13:37 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Forum statistics have been updated with the last quarter figures.

Spammers statistics:

/forum/fa/13823/0/
  • Attachment: MemBan2G.JPG
    (Size: 86.68KB, Downloaded 3477 times)

[Updated on: Sun, 06 May 2018 13:37]

Report message to a moderator

Re: Site statistics [message #670590 is a reply to message #669658] Sun, 15 July 2018 03:41 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Forum statistics have been updated with the last quarter figures.

Spammers statistics:

/forum/fa/13872/0/

Re: Site statistics [message #672392 is a reply to message #670590] Sat, 13 October 2018 00:50 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Forum statistics have been updated with the last quarter figures.

Spammers statistics:

/forum/fa/13951/0/
  • Attachment: MemBan2G.JPG
    (Size: 85.09KB, Downloaded 3481 times)

[Updated on: Sat, 13 October 2018 00:51]

Report message to a moderator

Re: Site statistics [message #674178 is a reply to message #672392] Wed, 09 January 2019 03:02 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Forum statistics have been updated with the last quarter figures.

Spammers statistics:
/forum/fa/13997/0/

  • Attachment: MemBan2G.JPG
    (Size: 88.17KB, Downloaded 3306 times)
Re: Site statistics [message #674224 is a reply to message #667764] Fri, 11 January 2019 12:18 Go to previous messageGo to next message
joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA
Senior Member
dbforums shut down? I didn't know this. I use it very rarely, but I didn't know that happened.
Re: Site statistics [message #674225 is a reply to message #674224] Fri, 11 January 2019 13:34 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Oh, yes - months ago! I tried to contact Pat Phelan (who was one of the moderator/administrator staff there, no luck. I met Tony Andrews on one of other forums; he didn't even know it is down, and doesn't know why it happened. A mystery.
Re: Site statistics [message #674226 is a reply to message #674225] Fri, 11 January 2019 13:50 Go to previous messageGo to next message
Frank Naude
Messages: 4579
Registered: April 1998
Senior Member
Pity. If you (by some miracle) manage to make contact, please ask for a backup of their forum so we can import it here.
Re: Site statistics [message #675856 is a reply to message #674178] Thu, 25 April 2019 03:24 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Forum statistics have been updated with the last quarter figures.

Spammers statistics:
/forum/fa/14098/0/
  • Attachment: MemBan2G.JPG
    (Size: 85.62KB, Downloaded 3327 times)
Re: Site statistics [message #676745 is a reply to message #675856] Thu, 11 July 2019 03:11 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Forum statistics have been updated with the last quarter figures.

Spammers statistics:

/forum/fa/14138/0/

Re: Site statistics [message #676834 is a reply to message #676745] Sat, 20 July 2019 10:22 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

There were a bug in some queries when some countries have the same number of posts.
Queries have been fixed and pictures updated (number of posts per country for the last 12 or 6 months).

I improved the picture of banned members splitting it in 2:

/forum/fa/14143/0/

  • Attachment: MemBan2G2.JPG
    (Size: 120.82KB, Downloaded 1453 times)

[Updated on: Sat, 20 July 2019 10:38]

Report message to a moderator

Re: Site statistics [message #677864 is a reply to message #676834] Thu, 17 October 2019 04:17 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Forum statistics have been updated with the last quarter figures.

Spammers statistics:

/forum/fa/14204/0/
  • Attachment: MemBan2G2.JPG
    (Size: 121.14KB, Downloaded 2921 times)
Re: Site statistics [message #678758 is a reply to message #677864] Tue, 07 January 2020 12:16 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Forum statistics have been updated with the last quarter figures.

Spammers statistics:

/forum/fa/14250/0/

  • Attachment: MemBan2G2.JPG
    (Size: 121.04KB, Downloaded 2776 times)
Re: Site statistics [message #680181 is a reply to message #678758] Mon, 27 April 2020 01:02 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Forum statistics have been updated with the last quarter figures.

Spammers statistics:

/forum/fa/14311/0/
  • Attachment: MemBan2G2.JPG
    (Size: 121.76KB, Downloaded 2819 times)
Re: Site statistics [message #682454 is a reply to message #680181] Sat, 24 October 2020 12:13 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Forum statistics have been updated with the last six months figures.

Spammers statistics:
/forum/fa/14410/0/

  • Attachment: MemBan2G2.JPG
    (Size: 118.88KB, Downloaded 2577 times)
Re: Site statistics [message #683414 is a reply to message #682454] Sun, 10 January 2021 11:31 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Forum statistics have been updated with the last six months figures.

Spammers statistics:

/forum/fa/14460/0/

  • Attachment: MemBan2G2.JPG
    (Size: 123.94KB, Downloaded 2408 times)
Re: Site statistics [message #683415 is a reply to message #683414] Sun, 10 January 2021 11:51 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
What's that? Rise of the spammers 4? Covid forces them to stay home and spam around?
Re: Site statistics [message #683416 is a reply to message #683415] Sun, 10 January 2021 12:25 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

For Pakistan ones (yellow line), this is just 1 guy who wanted to promote himself with (about) the same post under several accounts (I banned him once, he created a new account and so on).

For Indian ones (red line), it is the usual adverts for known false e-learning but true illegal dumps sites ("new" sites with same IP or within the same range of IPs of old ones). Indeed they seem to have more time to create these ones. But, with our moderator approval system, I don't think this will last long.

Re: Site statistics [message #683417 is a reply to message #683416] Mon, 11 January 2021 02:06 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Right; something like what we had at the beginning of 2017.
Re: Site statistics [message #684093 is a reply to message #683417] Tue, 06 April 2021 03:11 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Forum statistics have been updated with the last quarter figures.

Spammers statistics:

/forum/fa/14512/0/

As expected, the rise of spammers ended as fast as it appeared. Wink

  • Attachment: MemBan2G2.JPG
    (Size: 124.72KB, Downloaded 2120 times)

[Updated on: Tue, 06 April 2021 03:12]

Report message to a moderator

Re: Site statistics [message #684121 is a reply to message #684093] Wed, 07 April 2021 14:32 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
The Empire strikes back Smile
Re: Site statistics [message #684125 is a reply to message #684093] Thu, 08 April 2021 03:18 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Following the talk in topic "Member's profile: number of average messages per day", pages 3 and 4 of forum statistics in wiki have been updated and now give 2 average numbers of messages per day: 1) between join and last visit dates and 2) between first and last posts.
They also give the join, first post, last post and last visit dates of members.

"orafaq_poster.txt" file in the statistics zip file has also been updated in this way.

Re: Site statistics [message #684141 is a reply to message #684125] Thu, 08 April 2021 14:38 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Excellent, Michel!
Re: Site statistics [message #684599 is a reply to message #684141] Mon, 05 July 2021 03:05 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Forum statistics have been updated with the last quarter figures.

Spammers statistics:

/forum/fa/14539/0/
  • Attachment: MemBan2G2.JPG
    (Size: 122.13KB, Downloaded 1640 times)
Re: Site statistics [message #684963 is a reply to message #684599] Sun, 03 October 2021 03:59 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Forum statistics have been updated with the last quarter figures.

Spammers statistics:

/forum/fa/14552/0/
  • Attachment: MemBan2G2.JPG
    (Size: 122.75KB, Downloaded 1357 times)
Re: Site statistics [message #685428 is a reply to message #684963] Wed, 05 January 2022 05:51 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Forum statistics have been updated with the last quarter figures.

Spammers statistics:

/forum/fa/14582/0/
  • Attachment: MemBan2G2.JPG
    (Size: 125.63KB, Downloaded 1201 times)
Re: Site statistics [message #685894 is a reply to message #685428] Sat, 16 April 2022 12:07 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Forum statistics have been updated with the last quarter figures.

Spammers statistics:

/forum/fa/14616/0/

  • Attachment: MemBan2G2.JPG
    (Size: 128.38KB, Downloaded 999 times)
Re: Site statistics [message #686135 is a reply to message #685894] Wed, 22 June 2022 10:19 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Banned spammers aren't a problem any more, I think. We've got ... what? 10 spammers quarterly now?

Maybe it would be interesting if you posted number of messages instead. That's what worries me.
Re: Site statistics [message #686136 is a reply to message #686135] Wed, 22 June 2022 11:40 Go to previous messageGo to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Posts statistics are in our Forum statistics wiki pages.
Which new one do you want?

Previous Topic: Login issue
Next Topic: Email notifications of new comments - broken links
Goto Forum:
  


Current Time: Thu Mar 28 18:48:33 CDT 2024