vb.org Archive
Page 3 of 27 12 3 4513 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)

testebr 06-14-2007 05:39 AM
I love you with all my power!

The amazing mod! I want this resource by default in vbulletin next build.

Please send suggestion to Jelsoft team.

sross 06-14-2007 05:53 AM
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

Thaliada 06-14-2007 06:19 AM
Quote:
Originally Posted by 4x4 Mecca (Post 1268198)
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 (Post 1268205)
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.

Makc666 06-14-2007 08:02 AM
Good modification!
But here are some notes and bug.

1. After you made a search a bug appears.
There are two down arrows appeare https://vborg.vbsupport.ru/external/2010/06/3.gif after phrase:
Search Results In Folder: Inbox https://vborg.vbsupport.ru/external/2010/06/3.gifhttps://vborg.vbsupport.ru/external/2010/06/3.gif

And after phrase Private Messages in Folder: Inbox the down arrow disappear.

Better to see screenshots:
Attachment 65638
Attachment 65639

P.S. This is a clean install of 3.6.7 PL1

The Fix for this is to change this code from ReadMe.txt:
Code:
$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 this one:
Code:
$vbphrase[search_results_in_folder]<span class="normal">: $foldername</span>

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!

jluerken 06-14-2007 08:18 AM
Very nice. Should become a default for one of the future vb versions

jderouen 06-14-2007 01:44 PM
Still curious why it ignores the word "wonder."

Subah 06-14-2007 02:17 PM
Cool Thanks :)

Thaliada 06-14-2007 02:21 PM
Quote:
Originally Posted by Makc666 (Post 1268271)
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 (Post 1268392)
Still curious why it ignores the word "wonder."
Dunno, maybe it's in your ignore list for the standard search?

NolF 06-14-2007 02:25 PM
Quote:
Originally Posted by sross
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
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

Thaliada 06-14-2007 02:36 PM
AND pm.folderid=

is the problem, when does this error occure?
Do you have any other pm mods installed?

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

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


All times are GMT. The time now is 09:39 AM.
Page 3 of 27 12 3 4513 Last »
Show 40 post(s) from this thread on one page

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01512 seconds
  • Memory Usage 1,751KB
  • 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
  • (6)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)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