MyBB

snowusa · 2013-02-04, 01:22 PM

So I was wondering is there any way I can find out who posted post # 1000 for example...

Figured I'd give them a free sticker... Smile

Euan T · 2013-02-04, 01:45 PM

You could run this via phpmyadmin:

SELECT p.*, u.uid, u.username FROM mybb_posts p LEFT JOIN mybb_users u ON (p.uid = u.uid) WHERE p.pid = 100;

I think that should work, though I've written it off the top of my head.

snowusa · 2013-02-04, 02:06 PM

i'm guessing that should read = 1000 ?

Euan T · 2013-02-04, 02:19 PM

Oops. Yes, it should. Sorry about that!

snowusa · (This post was last modified: 2013-02-04, 02:24 PM by snowusa.)

no problem, thanks for your assistance Smile

it worked... only problem is 1000'th post is me!

Euan T · 2013-02-04, 02:41 PM

There goes that plan then. Maybe just give it to 1001?

snowusa · 2013-02-04, 02:46 PM

that's what I decided Smile

Euan T · 2013-02-04, 04:11 PM

Glad you've got it all sorted now then. In the future, please mark completed support requests as solved please. I've done it this time though Smile

snowusa · 2013-02-04, 05:47 PM

gotcha, thanks