vb.org Archive - Private Messages Enhancements

Page 12 of 27

« First

Last »

Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 3.6 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=194)

- - Private Messages Enhancements - User PM Search (https://vborg.vbsupport.ru/showthread.php?t=149609)

COBRAws

10-30-2007 03:22 PM

Quote:

Originally Posted by the Sandman (Post 1367875)

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

10-31-2007 03:04 AM

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

11-01-2007 01:06 PM

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

the Sandman

11-01-2007 01:45 PM

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

Thaliada

11-01-2007 02:02 PM

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

11-01-2007 02:22 PM

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

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

11-01-2007 02:40 PM

Quote:

Originally Posted by the Sandman (Post 1373472)

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

I guess thats the reason.

Code:

UPDATE usergroup SET pm_search = 1;

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

Acedeal

11-02-2007 10:23 AM

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

Code:

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

11-02-2007 11:51 AM

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

Acedeal

11-02-2007 12:49 PM

Quote:

Originally Posted by Thaliada (Post 1374130)

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!

All times are GMT. The time now is 09:01 PM.

Page 12 of 27

« First

Last »

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.02042 seconds Memory Usage 1,745KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (2)bbcode_code_printable (3)bbcode_php_printable (3)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (2)pagenav_pagelinkrel (1)post_thanks_navbar_search (1)printthread (10)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: