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)
got an error in 3.6.4 so guess i need to upgradet to 3.6.7 to ue it
Quote:
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=8
AND pm.folderid= AND MATCH(pmtext.title, pmtext.message) AGAINST ('+joey' 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 ('+joey' IN BOOLEAN MODE)
' at line 7
Error Number : 1064
Date : Thursday, June 14th 2007 @ 01:45:38 AM
Script : http://www.mysite.org/forums/private.php?folderid=0
Referrer : http://www.mysite.org/forums/private.php
IP Address : 121.72.6.223
Username : Me
Classname : vb_database
in my search box on the page, this text is in there by default.
"SELECT id, link FROM #__menu WHERE menutype = 'mainmenu' AND published = 1 ORDER BY parent, ordering"
I deleted it, searched for the word "please" and when the results came back, I clicked on one, and the word please as not in the PM... I don't have any ideas why.
I'm on 3.6.4 of that matters.
Seems like you have another plugin installed which uses a var named $query somewhere before the searchplugin is included. In the Template 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" /> and you should be fine. I'll rename it a next version.
Quote:
Originally Posted by sross
got an error in 3.6.4 so guess i need to upgradet to 3.6.7 to ue it
Just installed 3.6.4 and can't replicate your error, worked fine, sry :/
You could copy and paste the query into phpmyadmin for a more detailed error msg, maybe that helps
Edit: Ah ok i see your problem. somehow the folderid isn't passed along. Do you have any other pm hacks installed? because on a fresh install it works.
2. A littile note.
Why you didn't include templates modification in MOD file, so we have no need to edit template. Just Install.
As I looked throw I think it can be done so.
For example you can take a look how it works in this mod: https://vborg.vbsupport.ru/showthread.php?t=122592
2. A littile note.
Why you didn't include templates modification in MOD file, so we have no need to edit template. Just Install.
As I looked throw I think it can be done so.
For example you can take a look how it works in this mod: https://vborg.vbsupport.ru/showthread.php?t=122592
And once again Thanks for you work!
Didn't knew this is possible, i'll have a look at.
Quote:
Originally Posted by jderouen
Still curious why it ignores the word "wonder."
Dunno, maybe it's in your ignore list for the standard search?
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=8
AND pm.folderid= AND MATCH(pmtext.title, pmtext.message) AGAINST ('+joey' 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 ('+joey' IN BOOLEAN MODE)
' at line 7
Error Number : 1064
Date : Thursday, June 14th 2007 @ 01:45:38 AM
Script : http://www.mysite.org/forums/private.php?folderid=0
Referrer : http://www.mysite.org/forums/private.php
IP Address : 121.72.6.223
Username : Me
Classname : vb_database
I have the same error on 3.6.7 pl1.
PS this mod is designed to implement template changes easily ^^ should make it easier to learn how to use this function this way :P
at the beginning should deal with it. You can try replacing it with if(!isset($_GET['folderid']) || trim($_GET['folderid']) == '') $_GET['folderid'] = 0;
otherwise i don't have a clue what could cause this problem.
i've updated the archiv accordingly
User PM Search Details »»
About Developer
Visit Web Site
DB Changes 
No support by the author.
06-14-2007, 05:53 AM
after phrase: 
