Previous Thread
Next Thread
Print Thread
Hop To
#241619 02/09/2011 2:08 PM
Joined: Feb 2011
Posts: 36
T
newbie
newbie
T Offline
Joined: Feb 2011
Posts: 36
How do I view members PM boxes and the messages sent?
Thanks


I need all the help I can get.
Teal #241620 02/09/2011 2:26 PM
Joined: Apr 2007
Posts: 3,940
Likes: 1
SD Offline
Former Developer
Former Developer
Joined: Apr 2007
Posts: 3,940
Likes: 1
are you an admin?

Teal #241621 02/09/2011 2:31 PM
Joined: Feb 2011
Posts: 36
T
newbie
newbie
T Offline
Joined: Feb 2011
Posts: 36
yes I am. Not trying to invade privacy, just want the option to make sure a member is not spamming.


I need all the help I can get.
Teal #241622 02/09/2011 2:33 PM
Joined: Apr 2007
Posts: 3,940
Likes: 1
SD Offline
Former Developer
Former Developer
Joined: Apr 2007
Posts: 3,940
Likes: 1
you can 'become member' when you are editing them in the admin control panel

smile

Teal #241623 02/09/2011 2:44 PM
Joined: Feb 2011
Posts: 36
T
newbie
newbie
T Offline
Joined: Feb 2011
Posts: 36
Ok, but what if they are on line?


I need all the help I can get.
Teal #241624 02/09/2011 2:59 PM
Joined: Dec 2003
Posts: 6,562
Likes: 78
Joined: Dec 2003
Posts: 6,562
Likes: 78
Another way is to look at the post table in the database.
PRIVATE_MESSAGE_POSTS


Blue Man Group
There is no such thing as stupid questions. Just stupid answers
Ruben #241625 02/09/2011 3:07 PM
Joined: Feb 2011
Posts: 36
T
newbie
newbie
T Offline
Joined: Feb 2011
Posts: 36
Originally Posted by Ruben
Another way is to look at the post table in the database.
PRIVATE_MESSAGE_POSTS

can not find it. Can you walk me to it?


I need all the help I can get.
Teal #241626 02/09/2011 3:13 PM
Joined: Dec 2003
Posts: 6,562
Likes: 78
Joined: Dec 2003
Posts: 6,562
Likes: 78
It is a table in the ubb database.
For example if your host provides a control panel such as cpanel. You will usually have at least phpmyadmin.
select it.
Then select the ubb database.
You will have around 64 tables depending on your ubb version.
Scroll down to PRIVATE_MESSAGE_POSTS
select it.
Done.

Just fyi, I keep my nose out of it.
I for one would want to think that the pm system is totally private.
But beware you may find somebody talking about you. LOL.


Blue Man Group
There is no such thing as stupid questions. Just stupid answers
Teal #241628 02/09/2011 5:14 PM
Joined: Jun 2006
Posts: 16,299
Likes: 116
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,299
Likes: 116
I've always pushed for a "Report PT" option so users can report spam/abuse; a PT would then be readable by admin's in the CP to sort any "problems". Would keep PT's private except when a user involved wants to flag it abusive.


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Teal #241629 02/09/2011 5:19 PM
Joined: Dec 2003
Posts: 6,562
Likes: 78
Joined: Dec 2003
Posts: 6,562
Likes: 78
I have used some limited queries to just peek at how many pt's per user. But I will agree we should have some type of tools in the control panel. To manage them.

But a Notify button just like regular posts would be helpful also.
Then if a user gets spammed they can get relief from somebody.


Blue Man Group
There is no such thing as stupid questions. Just stupid answers
Teal #241630 02/09/2011 5:40 PM
Joined: Dec 2003
Posts: 6,562
Likes: 78
Joined: Dec 2003
Posts: 6,562
Likes: 78
Another way is you can access the database table from the ubb control panel also.
GOTO:
Control Panel » Database Tools
Select the SQL command tab.
Place this in the query box.
SELECT * FROM `ubbt_PRIVATE_MESSAGE_POSTS`
This is a simple query that just displays all the fields and rows.

Then click on the execute button.

You also have the option to save that query for future use.



Blue Man Group
There is no such thing as stupid questions. Just stupid answers
Gizmo #241631 02/09/2011 5:58 PM
Joined: Jun 2006
Posts: 1,344
G
veteran
veteran
G Offline
Joined: Jun 2006
Posts: 1,344
Originally Posted by Gizmo
I've always pushed for a "Report PT" option so users can report spam/abuse; a PT would then be readable by admin's in the CP to sort any "problems". Would keep PT's private except when a user involved wants to flag it abusive.


I agree, if someone says they are being spammed or harassed i ask them to set a temp password and than I login. I never become a member, only time I ever did was when people had issues resetting passwords but now I just create a md5 hash and change via phpmyadmin.

I hate the idea of login in as anyone without permission.

Teal #241632 02/09/2011 5:59 PM
Joined: Jan 2004
Posts: 2,474
Likes: 3
D
Pooh-Bah
Pooh-Bah
D Offline
Joined: Jan 2004
Posts: 2,474
Likes: 3
Woah, be careful there Ruben.

Even on a moderate size board like mine - that query is going to return a heck of a lot of rows.

driv #241633 02/09/2011 6:08 PM
Joined: Dec 2003
Posts: 6,562
Likes: 78
Joined: Dec 2003
Posts: 6,562
Likes: 78
Yes it will. That is why I posted:
Quote
This is a simple query that just displays all the fields and rows.

And I personally don't agree on using it. For the point of peering in on personal posts.


Blue Man Group
There is no such thing as stupid questions. Just stupid answers
Teal #241658 02/11/2011 1:30 PM
Joined: Feb 2011
Posts: 36
T
newbie
newbie
T Offline
Joined: Feb 2011
Posts: 36
I agree with you both. It is for protection of the site that is all. Thanks for your help.


I need all the help I can get.

Link Copied to Clipboard
ShoutChat
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
Bots
by Outdoorking - 04/13/2024 5:08 PM
Can you add html to language files?
by Baldeagle - 04/07/2024 2:41 PM
Do I need to rebuild my database?
by Baldeagle - 04/07/2024 2:58 AM
This is not a bug, but a suggestion
by Baldeagle - 04/05/2024 11:25 PM
Is UBB.threads still going?
by Aaron101 - 04/01/2022 8:18 AM
Who's Online Now
1 members (Nightcrawler), 887 guests, and 155 robots.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
Los Angeles
Los Angeles
by isaac, August 6
3D Creations
3D Creations
by JAISP, December 30
Artistic structures
Artistic structures
by isaac, August 29
Stones
Stones
by isaac, August 19
Powered by UBB.threads™ PHP Forum Software 8.0.0
(Preview build 20230217)