Register Members List Search Today's Posts Mark Forums Read

Reply
 
Mod Options
Advanced Memberlist Search Details »
Advanced Memberlist Search
Mod Version: 1.0.3, by Andreas (Coder) Andreas is offline
Developer Last Online: Mar 2019 I like it Show Printable Version Email this Page

This modification is in the archives.
vB Version: 3.5.4 Rating: (1 vote - 5.00 average) Installs: 43
Released: 07 Dec 2005 Last Update: 20 Feb 2006 Downloads: 55
Not Supported Uses Plugins Template Edits Is in Beta Stage  

Advanced Memberlist Searching

Description
This Hack adds the criteria "Profile Picture" (Only Users with/Only users without/Don't care) and "Age" (From/To) for memberlist searching.
Of course it does take care of birthday privacy settings: Only users who do allow their age to be displayed will be found if you search for age.

Details
1 Product XML (2 Plugins, 3 Phrases)

Important
This Hack requires at least vBulletin 3.5.2

This Hack is unsupported! All support requests except proven bugs will be ignored

Download Now

Only licensed members can download files, Click Here for more information.

Show Your Support

  • To receive notifications regarding updates -> Click to Mark as Installed.
  • If you like this modification support the author by donating.
  • This modification may not be copied, reproduced or published elsewhere without author's permission.
Similar Mod
Mod Developer Type Replies Last Post
Integration with vBulletin Google/Adsense Site Search Integrated into Advanced Search Page markbolyard vBulletin 3.6 Template Modifications 19 21 Sep 2010 15:16
Miscellaneous Hacks Redline's Advanced Memberlist Options HMBeaty Modification Graveyard 19 03 May 2008 02:50
Advanced Search (search by exact date range) why-not vBulletin 3.0 Beta Releases 0 17 Jan 2005 22:50

  #16  
Old 25 Dec 2005, 13:11
mskgr mskgr is offline
 
Join Date: Jun 2003
Lightbulb

Originally Posted by Andreas
Reinstalled the product from the ZIP here - still works fine?
Hello Andreas,

It doesnt work.

I went through debugging your code, in order to find out whats wrong. After the installation of the script, Advanced Memberlist Searching adds itself as a plugin to Hook Location : memberlist_query_userscount .

All the variables are passed correctly into the memberlist.php.

Let's say we want to search for users with profile pic enabled


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

The script runs, and we have the following variables populated:

$hook_query_joins and $hook_query_where

Thats fine. The membercount of users with enabled avatars, appears correctly. But, what happens with the results in the list?

The results have nothing to do with the... truth.

On line 520 of memberlist.php we have the following line:


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

As you can see, $hook_query_joins equals to NULL.

The query after that line gets "$hook_query_joins" and "$condition".

In the case of your script, $hook_query_joins pass as empty, and $condition doesnt contain our specific needs.

That's the problem.

I have added another plugin at Hook Location : memberlist_fetch,


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

Guess what? Now, everything works fine!

The above code is for searching on database with no profile pic hack installed. I am not using Andrea's other script It needs modification to cover both situations, but the purpose of posting this thing is to let Andrea's understand what was going wrong with his excellent plugin: Installed!
Reply With Quote
  #17  
Old 25 Dec 2005, 18:00
Andreas's Avatar
Andreas Andreas is offline
 
Join Date: Jan 2004
Real name: Andreas
Aaah! That's why it is working on my dev box, it does not have


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

but


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

I remember experimenting with hooks before memberlist_query_userscount was avialable ...

Gonna update the code, thanks.
Reply With Quote
  #18  
Old 26 Dec 2005, 12:12
ahmed-samara's Avatar
ahmed-samara ahmed-samara is offline
 
Join Date: Dec 2004
Real name: Ahmed Mohamed
Thanks.. good feature to have
__________________
Please don't PM me , Send request or enquiry to the Forum

support vBulletin Arabic, vBulletin Manual , vBulletin API
Reply With Quote
  #19  
Old 27 Dec 2005, 01:35
mskgr mskgr is offline
 
Join Date: Jun 2003
Post

Originally Posted by Andreas
Gonna update the code, thanks.
Not a problem at all Andreas, thanks for such a useful plugin
Reply With Quote
  #20  
Old 27 Dec 2005, 01:45
akanevsky akanevsky is offline
 
Join Date: Apr 2005
Real name: Anton Kanevsky
Screenshot, please.
__________________
I can no longer support any of my hacks. Please do not contact me for that. Feel free to create and post new versions of my hacks, as long as you give me credit for the original work.
Reply With Quote
  #21  
Old 27 Dec 2005, 16:21
Andreas's Avatar
Andreas Andreas is offline
 
Join Date: Jan 2004
Real name: Andreas
I don't have a screenshot and I am not going to take one
http://kirbydemos.ath.cx/forum/memberlist.php?do=search
Reply With Quote
  #22  
Old 27 Dec 2005, 19:28
PennylessZ28 PennylessZ28 is offline
 
Join Date: Mar 2002
Real name: Mike
I still can't make it work for all the tea in china
Reply With Quote
  #23  
Old 28 Dec 2005, 12:27
Nordinho Nordinho is offline
 
Join Date: Aug 2004

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

Getting this error now...uninstalled the old product and reimported the new one

edit: get this error by email when installing


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

;

and when the product installs it gives these errors


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

but the script redirects too fast to copy the whole error...

Last edited by Nordinho; 28 Dec 2005 at 12:34.
Reply With Quote
  #24  
Old 29 Dec 2005, 21:10
Nordinho Nordinho is offline
 
Join Date: Aug 2004
Originally Posted by Nordinho
Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

Getting this error now...uninstalled the old product and reimported the new one

edit: get this error by email when installing


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

;

and when the product installs it gives these errors


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

but the script redirects too fast to copy the whole error...
any idea's about this one...also receiving dberrors now

'mysql_connect(): Too many connections
/mydir/includes/class_core.php on
line 273'
Reply With Quote
  #25  
Old 16 Jan 2006, 03:08
moonclamp's Avatar
moonclamp moonclamp is offline
 
Join Date: May 2004
Real name: Paul
It's working for me now.

However, I'm cheating. I can't get the time to upgrade from 3.5.0 so I just uploaded the memberlist.php from 3.5.3 ... not sure if I messed anything else up but it works just fine now
Reply With Quote
  #26  
Old 19 Jan 2006, 07:28
sensimilla sensimilla is offline
 
Join Date: Dec 2004
Real name: Eric Estrada
Invalid SQL:

SELECT COUNT(*) AS users
FROM user AS user
LEFT JOIN userfield AS userfield USING (userid)

WHERE 1=1 AND field12 LIKE 'Female' AND field8 & 128
AND user.usergroupid IN (-1,10,6,7,12,2,5)
AND user.showbirthday > 0 AND IFNULL(YEAR(FROM_DAYS(TO_DAYS(NOW())-TO_DAYS(user.birthday_search))), 0) >= 25 AND IFNULL(YEAR( FROM_DAYS(TO_DAYS(NOW())-TO_DAYS(user.birthday_search))), 0) <= 35 AND NOT ISNULL(customprofilepic.userid);

MySQL Error : Unknown table 'customprofilepic' in where clause Error Number : 1109
any ideas ?
Reply With Quote
  #27  
Old 19 Feb 2006, 23:38
Rukas Rukas is offline
 
Join Date: Aug 2004
^^ Same exact problem, running 3.5.3, clean install.
Reply With Quote
  #28  
Old 22 Feb 2006, 19:25
quanvo81's Avatar
quanvo81 quanvo81 is offline
 
Join Date: Apr 2004
nice shot, nice hack, clicked installed
Reply With Quote
  #29  
Old 22 Feb 2006, 19:27
quanvo81's Avatar
quanvo81 quanvo81 is offline
 
Join Date: Apr 2004
Originally Posted by Rukas
^^ Same exact problem, running 3.5.3, clean install.
I have no problem running it, I am running 3.5.3
Reply With Quote
  #30  
Old 01 Mar 2006, 00:44
Rukas Rukas is offline
 
Join Date: Aug 2004
^^ What other hacks do you have installed?

Everything works fine apart from searching by profile pic.
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Mod Options

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


New To Site? Need Help?

All times are GMT. The time now is 08:44.

Layout Options | Width: Wide Color: