User PM Search

[TAIFUN_T]

Description:
This modification allows your users to search thru their pms.
Original Add-on https://vborg.vbsupport.ru/showthread.php?t=149609 (for vB 3.6)

Autor: Thaliada
Rewrited by TAIFUN.

Installation:
All the installation information is in the package.

Upgrade
* To update the version of the hack below v.3.0:
- uninstall the old version
- install the new version v.3.0

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

Changelog
01.12.2016
* Fixed XSS vulnerability
* Other minor fixes

**.**.2012 - v.3.1
* Deleted option "Move to the folder..." (delete condition)
* Fixed SQL request for User Group "6" (Administrators)
* Other minor fixes

08.11.2012 - v.3.0
* Changed productID
* Changed the link to check for new versions
* Changed the link threads leading to the official forum

10.07.2012 - v.2.1
- Delete one SQL request
$db->query_write("UPDATE ". TABLE_PREFIX ."usergroup SET pm_search=1 WHERE usergroupid=6");
- Fixed change the background color (for vB 3.8.X)
- Fixed security token errors
- Fixed search if not entered the search criteria
- Added a missing phrase (Usergroup Permission)

Archive contains English and Russian versions!

P.S. I created a theme for the reason that the author of the Add-on does not appear on the forum for over four years and does not endorse Add-on on this forum, as well as to administrators vBulletin 3.8 which looking for Add-on`s in the section vBulletin 3.8

[TAIFUN_T]

- Fixed search if not entered the search criteria

[vijayninel]

I wish you had done this sometime back. I managed to get the 3.8.6 version working on my forum with some difficulty.

Anyway this is a very useful mod and should be a default feature in vB.

[fortforum]

Installed and seems to work fine. Very handy toll. Thanx!

Would like to see it included in master search, with the other searches, search.php.
Nominated MOTM.

[EddyMaxx]

Great mod! Thx. Working on 3.8.7. P3.

[TAIFUN_T]

Thanks to all!

UPD
- corrected errors in the words (Only in Readme)

[TAIFUN_T]

08.11.2012 - v.3.0
* Changed productID
* Changed the link to check for new versions
* Changed the link threads leading to the official forum

Upgrade
* To update the version of the hack below v.3.0:
- uninstall the old version
- install the new version v.3.0

[CoffeeLovesYou]

I am getting a database error after uninstalling this.. Ugh...

[TAIFUN_T]

I am getting a database error after uninstalling this.. Ugh...

You sure? How version of the product? Show me code of database error pls.

[sergio00]

I get "Database Error" too:

my Vbulletin version: 3.8.5


Database error in vBulletin 3.8.5:

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

MySQL Error : The used table type doesn't support FULLTEXT indexes
Error Number : 1214
Request Date : Thursday, May 16th 2013 @ 04:12:35 PM
Error Date : Thursday, May 16th 2013 @ 04:12:35 PM
Script : http://www.aeromodelismovirtual.com/private.php?pmsearch=1
Referrer : http://www.aeromodelismovirtual.com/private.php?pmsearch=1
IP Address : 80.36.255.96
Username : sergio00
Classname : vB_Database
MySQL Version : 5.0.96-community-log


Can any help me?

BEst Regards for the support!!

[TAIFUN_T]

I get "Database Error" too:

my Vbulletin version: 3.8.5


Database error in vBulletin 3.8.5:

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

MySQL Error : The used table type doesn't support FULLTEXT indexes
Error Number : 1214
Request Date : Thursday, May 16th 2013 @ 04:12:35 PM
Error Date : Thursday, May 16th 2013 @ 04:12:35 PM
Script : http://www.aeromodelismovirtual.com/private.php?pmsearch=1
Referrer : http://www.aeromodelismovirtual.com/private.php?pmsearch=1
IP Address : 80.36.255.96
Username : sergio00
Classname : vB_Database
MySQL Version : 5.0.96-community-log


Can any help me?

BEst Regards for the support!!

The used table type doesn't support FULLTEXT indexes

Which version MySQL is installed on the server?
Type tables: MyISAM or InnoDB?

[sergio00]

Which version MySQL is installed on the server?
Type tables: MyISAM or InnoDB?

Thanks for the fast Support!
I will ask it to my hosting and I will answer you soon!

Thanks!
Sergio

[sergio00]

Which version MySQL is installed on the server?
Type tables: MyISAM or InnoDB?


The mysql version used in the server is 5.0.96 and the table are MyISAM

Thanks for the Support

[TAIFUN_T]

The mysql version used in the server is 5.0.96 and the table are MyISAM

Thanks for the Support

The used table type doesn't support FULLTEXT indexes

You hosting can solve this problem.

[blackberry]

hmm nice..

[sergio00]

You hosting can solve this problem.
But what exactly I should I tell to my hosting? What's the problem? Can you be more precise?
My hosting is URLJET ( one of the best Vbulleting hosting ).

Thanks fot the support

[TAIFUN_T]

But what exactly I should I tell to my hosting? What's the problem? Can you be more precise?
My hosting is URLJET ( one of the best Vbulleting hosting ).

Thanks fot the support

Show them the error text DB:

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

MySQL Error : The used table type doesn't support FULLTEXT indexes
Error Number : 1214
Request Date : Thursday, May 16th 2013 @ 04:12:35 PM
Error Date : Thursday, May 16th 2013 @ 04:12:35 PM
Script : http://www.aeromodelismovirtual.com/private.php?pmsearch=1
Referrer : http://www.aeromodelismovirtual.com/private.php?pmsearch=1
IP Address : 80.36.255.96
Username : sergio00
Classname : vB_Database
MySQL Version : 5.0.96-community-log

Because the problem is not the plugin. This problem of database tables.

[TAIFUN_T]

sergio00, go to http://YourDomain/admincp/options.php?do=searchtype

What you see?
Search type:
Your forum is currently using the Fulltext search engine. Blablabla... ?

[sergio00]

sergio00, go to http://YourDomain/admincp/options.php?do=searchtype

What you see?
Search type:
Your forum is currently using the Fulltext search engine. Blablabla... ?
Your Cpanel URL is different in my host......
I send a ticket support to my Hosting with this issue.
I keep you informed.

Best Regards!
Sergio

[TAIFUN_T]

Your Cpanel URL is different in my host......
I send a ticket support to my Hosting with this issue.
I keep you informed.

Best Regards!
Sergio

This not Cpanel. Look carefully.
---
http://www.aeromodelismovirtual.com/admincp/options.php?do=searchtype

[sergio00]

sergio00, go to http://YourDomain/admincp/options.php?do=searchtype

What you see?
Search type:
Your forum is currently using the Fulltext search engine. Blablabla... ?

Sorry :P

Yes,,, with your link http://www.mydomain/admincp/options.php?do=searchtype

The system say me that my forum is using FullText search engine........

And at the bottom there is an option to Delete the fulltext index

[sergio00]

The system say me that my forum is using "FullText" search engine........

And at the bottom there is an option to Delete the fulltext index

Any help to resolve this issue??

Best Regards

[Tobin Frost]

PM Search Turkish version.
TR Language pack.

https://vborg.vbsupport.ru/external/2014/06/58.png

[TAIFUN_T]

Attention!

Fixed XSS vulnerability