Bungie.net Community
This topic has moved here: Subject: Question about post counts.
  • Subject: Question about post counts.
Subject: Question about post counts.

It's Pokémon, not Pokemon!

Is it possible to see how many posts you have made in your account's lifetime?

Just wanted to know.

  • 07.15.2012 8:18 PM PDT

Key

Nope. Not unless you've been counting.

Though, for the record, I calculated the other day that it takes roughly between 7,300 and 9,100 posts to get to Intrepid.

Just an interesting note.

[Edited on 07.15.2012 8:24 PM PDT]

  • 07.15.2012 8:21 PM PDT

Theres no accurate way of knowing your accounts lifetime total.

  • 07.15.2012 8:21 PM PDT

Now, in the quantum moment before the closure, when all become one. One moment left. One point of space and time.

I know who you are.

You are Destiny.

That information is hidden exclusively by the Webteam. Only they (probably) know.

  • 07.15.2012 8:26 PM PDT

Xbox LIVE gamertag: Dat3lessNutella
Steam username: TopWargamer
To look up my Halo stats...search for the gamertag TopWargamer.
SAVED THREAD PAGES: 283
One does not simply get rid of TopWargamer so easily.
You know this to be true.
ALL HAIL GABEN


Posted by: CrazzySnipe55
Nope. Not unless you've been counting.

Though, for the record, I calculated the other day that it takes roughly between 7,300 and 9,100 posts to get to Intrepid.

Just an interesting note.

Damn...and I reached Fabled...

o.0

  • 07.15.2012 8:41 PM PDT

select count(p.*) as post_count
from posts p
where p.uid = (select uid from users where username = 'EclipsePalix400');

That should do it!

  • 07.15.2012 8:51 PM PDT

Does anyone have lotion?
*Raises hand*
Is mayonnaise a lotion?


Posted by: dazarobbo
select count(p.*) as post_count
from posts p
where p.uid = (select uid from users where username = 'EclipsePalix400');

That should do it!


wat

  • 07.15.2012 8:53 PM PDT

Xbox LIVE gamertag: Dat3lessNutella
Steam username: TopWargamer
To look up my Halo stats...search for the gamertag TopWargamer.
SAVED THREAD PAGES: 283
One does not simply get rid of TopWargamer so easily.
You know this to be true.
ALL HAIL GABEN


Posted by: dazarobbo
select count(p.*) as post_count
from posts p
where p.uid = (select uid from users where username = 'EclipsePalix400');

That should do it!

He's speaking in mod!

  • 07.15.2012 9:02 PM PDT

Posted by: borrowedchief
We aren't here to ruin your experience (Well Qbix is).


Posted by: CrazzySnipe55
Nope. Not unless you've been counting.

Though, for the record, I calculated the other day that it takes roughly between 7,300 and 9,100 posts to get to Intrepid.

Just an interesting note.
I still have a chance to keep my Exalted title :')

  • 07.15.2012 9:11 PM PDT

lulz


Posted by: dazarobbo
select count(p.*) as post_count
from posts p
where p.uid = (select uid from users where username = 'EclipsePalix400');

That should do it!



I don't speak Spanish :(

  • 07.15.2012 9:16 PM PDT
  • gamertag: [none]
  • user homepage:

:)


Posted by: CrazzySnipe55
Nope. Not unless you've been counting.

Though, for the record, I calculated the other day that it takes roughly between 7,300 and 9,100 posts to get to Intrepid.

Just an interesting note.

ew

  • 07.15.2012 9:44 PM PDT

Key


Posted by: jross1993

Posted by: CrazzySnipe55
Nope. Not unless you've been counting.

Though, for the record, I calculated the other day that it takes roughly between 7,300 and 9,100 posts to get to Intrepid.

Just an interesting note.

ew
That's just based on the fact that I started posting last July, I got intrepid this July, and I'd guess that my average PPD over the past year has been 20-25 (7,300 to 9,100)

  • 07.15.2012 9:47 PM PDT

Hey I am a big Bungie fan ever since I played Halo 2. I love the series, I love Bungie. I have made a few Bungie logos in my metal shop.

That would be a nice feature

  • 07.15.2012 9:47 PM PDT
  • gamertag: [none]
  • user homepage:

Posted by: evilcam
Bobcast is paid in MILF blind dates.

There's a script which shows your PPD so you could figure it out using that. (Not sure how accurate it is)

  • 07.15.2012 9:55 PM PDT

Have you seen my mind anywhere? I seem to have lost it...

0x0 x0x 0x0 000 000 x0x 000
x0x 0x0 0x0 0xx 000 0x0 000
x0x x0x x00 0xx 0x0 x0x 0x0

I have seen you future

Posted by: Thrasher Fan
There's a script which shows your PPD so you could figure it out using that. (Not sure how accurate it is)

I'm pretty sure the script just uses your last 300 main forum posts to calculate PPD, so it wouldn't be very accurate.

  • 07.16.2012 6:38 AM PDT

*´¨)---––•(-• Dutchy •-)•–--–-(¨´*
¸.•´¸.•*´¨) ¸.•*¨)••(¨*•.¸ (¨´*•.¸´•.¸
(¸.•´ (¸.•Everything fails•.¸) ´•.¸)


Posted by: dazarobbo
select count(p.*) as post_count
from posts p
where p.uid = (select uid from users where username = 'EclipsePalix400');

That should do it!
Not all of us are wizards with this kind of stuff. Make an example by posting each step in action.

  • 07.16.2012 7:06 AM PDT

Check out my Soundcloud account to hear some of my music.
Here's my twitter, in the off-chance you want that too.

Community Joe Interview: defnop552
Bye.

Posted by: King Dutchy
Not all of us are wizards with this kind of stuff. Make an example by posting each step in action.
It's a joke. It's an example of code that would find posts by "EclipsePalix400". I don't think it works here.

Also, Daza. Wouldn't it be better to search by member ID numbers?
where p.uid = (select uid from users where memberID = '8013399');

  • 07.16.2012 10:37 AM PDT

Posted by: defnop552
Also, Daza. Wouldn't it be better to search by member ID numbers?
where p.uid = (select uid from users where memberID = '8013399');
Assuming you knew it, sure, but memberIDs don't really mean anything.

One of the other problems I've realised is that if you look back at some of the older posts you'll notice some deleted users' usernames are the same as those that currently exist. That is to say, there can be multiple users with the same username, just not "active" (or "non-deleted"), which rules out the possibility of the username being a primary key. So with that in mind, selecting the uid based on the username could potentially return more than one row, which would break that query.

A better query (assuming the site continues to store "deleted" users) would be to make the subquery something like SELECT uid FROM Users WHERE username = 'dazarobbo' AND deleted = 0, which would return only one row since you can't sign up a new account with the same username as an existing one (a non-deleted one).

Of course, maybe this is wrong and the posts table (assuming there is one) actually stores the literal username of user making the post instead of referring to it with a foreign key back to the users table (again, assuming that exists too).

Though that wouldn't account for when we've seen someone's username changed, because when it is, all usernames attached to the posts that user has made also change, which would more likely point to there being a foreign key for the user in the posts table, probably referring back to the memberID/uID for the user. While that could be the case, it could also be as simple as running an UPDATE to change each username on a post as well, hence no referencing at all.

The last thing to figure out would be what exactly the primary key is for each user. It could be a number of things, but it could be a combination of things, which makes it difficult.

Given the naming of memberID and uID, it would likely point to either of them, or the combination of them, but it's far too difficult to tell, especially with the way they seem to be used interchangeably to refer to the same profile (eg. username link vs. groups link). So I'll just go with what Achronos says.

Trying to infer things about how the site is structured (especially on the backend) is a really interesting challenge ;).

  • 07.16.2012 10:47 PM PDT

The Song Of Nephilim

Xenoblade <3

Nope. It is impossible to know.

  • 07.16.2012 10:54 PM PDT

Twitter | Raptr | Facebook
------------------------------------------
Let me change my username! Pwease, I'd do anything! :'(
------------------------------------------
Xbox Ambassador

Yes.
Here's what you do:
-Click on your profile.
-Click on "Last Forum Post".
-Go to page 12.
-Go back, because you realize you're there for no reason
-Facepalm at the fact you didn't start tallying your posts on day 1.

  • 07.17.2012 12:03 AM PDT

Halo: CE Anniversary Achievement Idea
C-C-C-CANNON BREAKER!
Let Sgt. Johnson die on Halo.

Posted by: CrazzySnipe55
Nope. Not unless you've been counting.

Though, for the record, I calculated the other day that it takes roughly between 7,300 and 9,100 posts to get to Intrepid.

Just an interesting note.


Dear God, what have I been doing with my life...

  • 07.17.2012 1:58 AM PDT