Query for users that post in a forum

[hankster]

Thanks for the help. Got me on the right track.

[hankster]

Running 5.1.56

[hankster]

Here is what I ended up using

SELECT DISTINCT user.userid, user.username, user.email
FROM user
JOIN post ON ( user.userid = post.userid )
JOIN thread ON ( post.threadid

...

[hankster]

That is what I thought but I'm not getting any results.

[hankster]

Thanks Wayne,

Can I use that through the vB QSL Query admin?

[hankster]

I am trying to get a list of the members (and email address) that posted in a forum within the past 30 days. Does anyone know what query would be used to get that information. TIA

[hankster]

[hankster]

Thanks Jake, the number will work.

[hankster]

Thanks, is there a way to get the forum's name instead of the ID number?

[hankster]

I am looking to tie some conditionals to the forum name but am not sure what variable/tag is used to define the forum name? I want to display an advertisment only in posts for a single forum but need...

[hankster]

Anyone?

[hankster]

I am looking to tie some conditionals to the forum name but am not sure what variable is used to define the forum name? See below attachments. TIA...

[hankster]

Yes it is.

[hankster]

Nope, it is set as me who is the admin and has posting permissions for all forums.

[hankster]

I have a number of RSS feeds set up to post eBay auctions in our Auction Links forums. Two of them work fine. For the 3rd one it will not post to that forum. The feed is fine as it will post if I set...

[hankster]

Could be they are not checking that. I'll see if the ones that are doing that are checking it. Thanks.

[hankster]

I suspect this is a problem with cookies but not sure what it is. I recently upgraded from 3.0.x to 3.6.8. With 3.0.x I never had this problem. When some people using AOL's browser log in, it shows them...

[hankster]

Yep, that's it.... of course people never read the DO NOT REPLY.

What template is that?

[Added] Ahhh..... found it from searching using your example.... it was a phrase, t...

[hankster]

I am looking for the template that is used to make the actual email that someone receives. I want to eliminate the contents of the PM from the email to make people go to their PMs on the forum to read...

[hankster]

I am looking for the template that is used for the actual email that is sent.