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

[Thaliada]

Thx again, normaly this line should not be necessary, but some people seemed to have problems without it. Included it again.

@klaush
there is a 3.5 version on this board.

[Nathan2006]

Thanks for the update

[4x4 Mecca]

Did you ever change the name query? Or is that not planned? It was interfering with my other hack quick search in the navbar.

[SirFlash]

I installed this on vb3.6.4, made the template change included in the file, and it didn't work. The script appears in place, but when i enter a keyword on the pm search form, it returns an SQL error page with this message:

Database error in vBulletin 3.6.4:

Invalid SQL:

SELECT pm.*, pmtext.*
, icon.title AS icontitle, icon.iconpath
FROM pm AS pm
LEFT JOIN pmtext AS pmtext ON(pmtext.pmtextid = pm.pmtextid)
LEFT JOIN icon AS icon ON(icon.iconid = pmtext.iconid)
WHERE pm.userid=1
AND pm.folderid= AND MATCH(pmtext.title) AGAINST ('+testkeyword' IN BOOLEAN MODE)
ORDER BY pmtext.dateline DESC;

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND MATCH(pmtext.title) AGAINST ('+testkeyword' IN BOOLEAN MODE)
ORDER BY pmtext.d' at line 7
Error Number : 1064
Date : Thursday, June 28th 2007 @ 10:48:04 PM
Script : http://mywebsite.com/private.php?folderid=0
Referrer : http://mywebsite.com/private.php
IP Address : 192.168.1.1
Username : SirFlash
Classname : vB_Database_MySQLi

I thought maybe changing a line of code as Thaliada suggested may work, but i still get an error. The code below didn't fix the problem for me.

change <div><input type="text" class="bginput" name="query" size="35" value="$query" style="width:250px" />

to

<div><input type="text" class="bginput" name="query" size="35" value="" style="width:250px" />

I don't know if this has something to do with a conflict in value="$query" or what.

So for now i can't use this mod because it won't work, although the PM search is an excellent tool and i concur with others that this should absolutely be vb default in future versions. If anyone has any ideas on what i can do to get this to work, that would be much appreciated.

[Talking Poker]

Nice looking mod, but doesn't work for me either. I get the following:


Database error in vBulletin 3.6.7:

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=1
AND pm.folderid= AND MATCH(pmtext.title, pmtext.message) AGAINST ('+test' IN BOOLEAN MODE)
ORDER BY pmtext.dateline DESC;

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND MATCH(pmtext.title, pmtext.message) AGAINST ('+test' IN BOOLEAN MODE)
O' at line 7
Error Number : 1064
Date : Friday, June 29th 2007 @ 12:06:26 PM
Script : http://www.talkingpoker.com/forum/pr...php?folderid=0
Referrer : http://www.talkingpoker.com/forum/private.php
IP Address : 68.202.190.31
Username : Talking Poker
Classname : vB_Database_MySQLi

[Dark_Sirius]

Working just fine in 3.6.4 Thanks!

[Thaliada]

#Sit Flash & Talking Poker

does the first line of the php code of the plugin starts with

if(!isset($_GET['folderid']) || trim($_GET['folderid']) == '') $_GET['folderid'] = 0;

if not, replace it with this one.
if so, do you have any other pm plugins installed and does the problem still exists if you turn them off?

[rainyleaves]

Working great !! in 3.6.7LP1 Thanks!

Just one question.
Can I use wild cards?
How do I?

Thanks

[Thaliada]

Use * as wildcard.

[rainyleaves]

Thahks! Thaliada