« TV & movies
Post count fever
Happy Birthday Nao! »

live627

  • Should five per cent appear too small / Be thankful I don't take it all / 'Cause I'm the taxman, yeah I'm the taxman
  • Posts: 1,670
Re: Post count fever
« Reply #165, on September 26th, 2011, 07:50 AM »
* live627 goes and edits the database "look I am the top spammer with 501k posts"

Oops... I'm [not] a geek. Pout. Puts the number back.
A confident man keeps quiet.whereas a frightened man keeps talking, hiding his fear.

Arantor

  • As powerful as possible, as complex as necessary.
  • Posts: 14,278
Re: Post count fever
« Reply #166, on September 26th, 2011, 08:50 AM »
No, that easter egg was removed in Wedge. Don't know about here though :P
When we unite against a common enemy that attacks our ethos, it nurtures group solidarity. Trolls are sensational, yes, but we keep everyone honest. | Game Memorial

Nao

  • Dadman with a boy
  • Posts: 16,082
Re: Post count fever
« Reply #167, on September 26th, 2011, 09:28 AM »
I think I removed it manually.

Arantor

  • As powerful as possible, as complex as necessary.
  • Posts: 14,278
Re: Post count fever
« Reply #168, on September 26th, 2011, 09:34 AM »
Wouldn't surprise me :P

Nao

  • Dadman with a boy
  • Posts: 16,082
Re: Post count fever
« Reply #169, on September 28th, 2011, 06:07 PM »
And... 7000 posts :P

These last 1000 were a bit faster than the ones before them. However, Pete was in a rage last week and managed to start catching up big time. He sent something like 100 posts more than I did this month ;)
So I would estimate that I will be first to 7500, but I definitely no longer have a shot at 10k... And possibly even at 8k, eheh.

MultiformeIngegno

  • Posts: 1,337
Re: Post count fever
« Reply #170, on September 28th, 2011, 07:08 PM »
You crazy spammers... :whistle:

Arantor

  • As powerful as possible, as complex as necessary.
  • Posts: 14,278
Re: Post count fever
« Reply #171, on September 28th, 2011, 07:16 PM »
You'll beat me to 7500 and probably to 8k but 10k is anyone's guess :P

Nao

  • Dadman with a boy
  • Posts: 16,082
Re: Post count fever
« Reply #172, on September 28th, 2011, 07:53 PM »
If you don't beat me to 9k, I'll be mad at you! :P

Arantor

  • As powerful as possible, as complex as necessary.
  • Posts: 14,278
Re: Post count fever
« Reply #173, on September 28th, 2011, 07:56 PM »
I think the race to 9k is going to be close and that 10k is totally open :P
Re: Post count fever
« Reply #174, on September 30th, 2011, 03:47 PM »
OK, I'm curious. I know that post count is one thing, but what happens if you factor in total length of posts in to the equation?

Nao

  • Dadman with a boy
  • Posts: 16,082
Re: Post count fever
« Reply #175, on September 30th, 2011, 04:26 PM »
Oh, you're a clear winner then...!

Let me try it...

SELECT e.real_name, sum( length( m.body ) ) AS woot
FROM {db_prefix}messages AS m, {db_prefix}members AS e
WHERE e.id_member = m.id_member
GROUP BY e.id_member
ORDER BY woot DESC
LIMIT 0, 30

Nao        5320884
Arantor    4350826
Dragooon    444021
Bloc        242177
[Unknown]   215976
~DS~        201932
live627     142454
snoopy-virtual   142245
MultiformeIngegno   102646
Aaron   75351
TE   73382
DirtRider   73004
spoogs   60875
dannbass   54347
Norodo   52533
Clara Listensprechen   44839
texasman1979   43416
CJ Jackson   40739
spuds   37685
billy2   33713
DoctorMalboro   33105
mforum   30462
YogiBear   29728
Road Rash   29556
Cassiel   28643
Nightwish   28612
Adonis   27529
dorje   25504
dazed   24767
hadesflames   23886

Err... What?! I must have made a mistake in my query :lol:

Arantor

  • As powerful as possible, as complex as necessary.
  • Posts: 14,278
Re: Post count fever
« Reply #176, on September 30th, 2011, 04:36 PM »
It's the change logs that do it, I'm sure...

Nao

  • Dadman with a boy
  • Posts: 16,082
Re: Post count fever
« Reply #177, on September 30th, 2011, 04:47 PM »
I don't know, my changelogs are usually smaller than yours.. :P

No, I'd suspect it's due to the amount of quoting I do. Obviously, quotes are taken into account. And I'm not going to create a new table, copy all messages into it, remove quotes recursively and restart the count... I won't! Will I? :P

Arantor

  • As powerful as possible, as complex as necessary.
  • Posts: 14,278
Re: Post count fever
« Reply #178, on September 30th, 2011, 04:48 PM »
I don't know, are you? :P Certainly that's a project for a rainy day if that's something you want to pursue...

Nao

  • Dadman with a boy
  • Posts: 16,082
Re: Post count fever
« Reply #179, on September 30th, 2011, 06:15 PM »
Hmm I doubt Mysql has ?R in its regex list...
« TV & movies
Happy Birthday Nao! »