Private Messages Enhancements - User PM Search

Description:
This modification allows your users to search thru their pms

Installation:
All the installation information is in the package.

Changes/Adds:
7 Plugins
19 Phrases
1 Template
1 Template change

Changelog
2.0
Rewrote some parts and included (hopefully) all feature requests
- Search is now on a single page
- Usergroup permission added
- (Little to) no template changes necessary
- Should hopefully work with other pm addons like pm preview etc without additional template changes (not tested)

1.0.2
Fixed a template bug, thx Makc666

Change

$vbphrase[search_results_in_folder]<span class="normal">: <span id="nav_pmfolders.messagelist">$foldername<script type="text/javascript"> vbmenu_register("nav_pmfolders.messagelist"); </script></span></span>

to

$vbphrase[search_results_in_folder]<span class="normal">: $foldername</span>

1.0.1
Fixed some minor problems

[COBRAws]

Originally Posted by the Sandman

It took me a while, but I figured out how to get this to work with MySQLi. It will also still work with MySQL, so it probably should be substituted into the plug-in for all users.

Find:

PHP Code:

AND pm.folderid=" . mysql_real_escape_string($_GET['folderid']) . " "; 


or, if you've already made the change mentioned in Post #103:

PHP Code:

AND pm.folderid=" . mysql_real_escape_string($search_folderid) . " "; 


And replace it with:

PHP Code:

AND pm.folderid=" . $db->escape_string($search_folderid) . " "; 


Thanks! Now it works

[Head Roller]

Fantastic mod. I cant tell you how many times i have actually gone to the database to run a query because i couldnt find a PM in my mailbox!!!

THANK YOU!

[Thaliada]

Version 2.0 released. Rewrote some parts and added all(?) requested features.
Updating is recommended.

[the Sandman]

Upgraded to 2.0 as instructed and the PM Search box shows up but searching yields no visible results.

[Thaliada]

Hello the Sandman,

I registered at the admin zone forums. Could you please put me into a user group that is allowed to search their pms. Also the old search field is still in place. Have you completely removed the old version?

[the Sandman]

Ahh - I forgot that the v1 template change had been done manually, and I removed it.

I also figured out why it wasn't working for me - it doesn't seem to obey the permissions of a user's additonal groups - only the primary group. Is this intended behavior? Or perhaps due to "Allow Users to have Member Groups" to 'No' in my primary usergroup?

Do you have a query to enable PM Search for all usergroups?

[Thaliada]

Originally Posted by the Sandman

Or perhaps due to "Allow Users to have Member Groups" to 'No' in my primary usergroup?

I guess thats the reason.

UPDATE usergroup SET pm_search = 1;

If you use table prefixes, add the prefix before "usergroup"

[Acedeal]

Applied the update, and it still does not support mysql with full text searches enabled

Any ideas on how to get this to work with mysql and full text ??
MySQL Error : The used table type doesn't support FULLTEXT indexes

Database error in vBulletin :

Invalid SQL:

			SELECT pm.*, pmtext.*
				, icon.title AS icontitle, icon.iconpath
			FROM vb3_pm AS pm
			LEFT JOIN vb3_pmtext AS pmtext ON(pmtext.pmtextid = pm.pmtextid)
			LEFT JOIN vb3_icon AS icon ON(icon.iconid = pmtext.iconid)
			WHERE pm.userid=94
			  AND MATCH(pmtext.title, pmtext.message) AGAINST ('+Larry' IN BOOLEAN MODE) 
			ORDER BY pmtext.dateline DESC;

MySQL Error  : The used table type doesn't support FULLTEXT indexes
Error Number : 1214
Date         : Friday, November 2nd 2007 @ 06:13:13 AM
Script       : http://forum.xxxx.com/private.php?pmsearch=1
Referrer     : http://forum.xxxx.com/private.php?pmsearch=1
IP Address   : 97.100.1.1
Username     : ntbxxx
Classname    : vB_Database

thanks!.. Looks like a great mod, just can not get it to work when forums uses fulltext instead of the default vb search.

[Thaliada]

You have to use MyISAM as your MySQL storage engine. It's the only one that supports full text search.

[Acedeal]

Originally Posted by Thaliada

You have to use MyISAM as your MySQL storage engine. It's the only one that supports full text search.

Ahh, I changed the table storage type and it works great!! thanks!