|
|
Joined: May 2002
Posts: 153
Member
|
Member
Joined: May 2002
Posts: 153 |
is there a way to do a search for a word contained in stored pm messages? I mean using myphpadmin or any other program...
I have a problem with members using pm to promote and would like to find out sooner thna latter...
|
|
|
|
Joined: May 1999
Posts: 1,715
Addict
|
Addict
Joined: May 1999
Posts: 1,715 |
Using the SQL command from the admin page you could use this query:
SELECT * FROM w3t_Messages WHERE M_Message LIKE "%enterwordtosearchforhere%"
If you have change your database prefix, you will have to use that instead of "w3t_".
|
|
|
Donate to UBBDev today to help aid in Operational, Server and Script Maintenance, and Development costs.
Please also see our parent organization VNC Web Services if you're in the need of a new UBB.threads Install or Upgrade, Site/Server Migrations, or Security and Coding Services.
|
|
Posts: 1,157
Joined: July 2001
|
|
Forums63
Topics37,573
Posts293,925
Members13,849
|
Most Online5,166 Sep 15th, 2019
|
|
Currently Online
Topics Created
Posts Made
Users Online
Birthdays
|
|
|
|
|