Announcement
Collapse
No announcement yet.
User Profile
Collapse
-
Thanks for the help. Got me on the right track.
-
-
Here is what I ended up using
Code:[FONT=Courier New][URL="https://www.diecastwings.net:2087/3rdparty/phpMyAdmin/url.php?url=http%3A%2F%2Fdev.mysql.com%2Fdoc%2Frefman%2F5.1%2Fen%2Fselect.html&token=f8b10d0cc27fc6c2024241aedc72db16"]SELECT[/URL] [/FONT][FONT=Courier New]DISTINCT [/FONT][FONT=Courier New]user[/FONT][FONT=Courier New].[/FONT][FONT=Courier New]userid[/FONT][FONT=Courier New], [/FONT][FONT=Courier New]user[/FONT][FONT=Courier New].[/FONT][FONT=Courier New]username[/FONT][FONT=Courier New], [/FONT][FONT=Courier New]user[/FONT][FONT=Courier New].[/FONT][FONT=Courier New]email[/FONT][FONT=Courier New] [/FONT][FONT=Courier New]FROM [/FONT][FONT=Courier New]user[/FONT][FONT=Courier New] [/FONT][FONT=Courier New]JOIN [/FONT][FONT=Courier New]post [/FONT][FONT=Courier New]ON [/FONT][FONT=Courier New]( [/FONT][FONT=Courier New]user[/FONT][FONT=Courier New].[/FONT][FONT=Courier New]userid [/FONT][FONT=Courier New]= [/FONT][FONT=Courier New]post[/FONT][FONT=Courier New].[/FONT][FONT=Courier New]userid [/FONT][FONT=Courier New])[/FONT][FONT=Courier New] [/FONT][FONT=Courier New]JOIN [/FONT][FONT=Courier New]thread [/FONT][FONT=Courier New]ON [/FONT][FONT=Courier New]( [/FONT][FONT=Courier New]post[/FONT][FONT=Courier New].[/FONT][FONT=Courier New]threadid[/]
Leave a comment:
-
-
-
Query for users that post in a forum
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
-
-
-
Thanks, is there a way to get the forum's name instead of the ID number?
Leave a comment:
-
What is the name of this variable/tag?
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...
-
-
What is the name of this variable?
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...
-
-
Nope, it is set as me who is the admin and has posting permissions for all forums.
Leave a comment:
-
RSS Feed Poster Oddity
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...
-
Could be they are not checking that. I'll see if the ones that are doing that are checking it. Thanks.
Leave a comment:
-
AOL cookie problem?
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...
-
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...Last edited by hankster; Thu 7 Feb '08, 7:40pm.
Leave a comment:
-
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...
Leave a comment:
-
I am looking for the template that is used for the actual email that is sent.
Leave a comment:
No activity results to display
Show More
Leave a comment: