Version: 1.0.3, by Andreas
Developer Last Online: Jan 2023
Version: 3.5.4
Rating:
Released: 12-06-2005
Last Update: 02-19-2006
Installs: 43
Uses Plugins Template Edits
Is in Beta Stage
No support by the author.
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
Show Your Support
This modification may not be copied, reproduced or published elsewhere without author's permission.
SELECT user.*,usertextfield.*,userfield.*, user.userid, options,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
,avatar.avatarpath,NOT ISNULL(customavatar.userid) AS hascustomavatar,customavatar.dateline AS avatardateline, customavatar.width AS avwidth, customavatar.height AS avheight
,customprofilepic.userid AS profilepic, customprofilepic.dateline AS profilepicdateline, customprofilepic.width AS ppwidth, customprofilepic.height AS ppheight
, lastactivity AS lastvisittime
, journals.journal_id
FROM user AS user
LEFT JOIN usertextfield AS usertextfield ON(usertextfield.userid=user.userid)
LEFT JOIN userfield AS userfield ON(userfield.userid=user.userid)
LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON(customavatar.userid = user.userid)
LEFT JOIN customprofilepic AS customprofilepic ON (user.userid = customprofilepic.userid)
LEFT JOIN journals AS journals ON (journals.journalist_id=user.userid) LEFT JOIN customprofilepic AS customprofilepic ON (customprofilepic.userid=user.userid)
WHERE 1=1 AND user.showbirthday > 0 AND IFNULL(YEAR(FROM_DAYS(TO_DAYS(NOW())-TO_DAYS(user.birthday_search))), 0) >= 15 AND IFNULL(YEAR( FROM_DAYS(TO_DAYS(NOW())-TO_DAYS(user.birthday_search))), 0) <= 36 AND ISNULL(customprofilepic.userid)
AND user.usergroupid IN (-1,6,7,9,120,2,5,81,123)
ORDER BY user.username asc
LIMIT 0, 30;
MySQL Error : Not unique table/alias: 'customprofilepic'
Getting this error now...uninstalled the old product and reimported the new one
edit: get this error by email when installing
PHP Code:
Invalid SQL:
DELETE FROM productrequirement WHERE product=''
;
and when the product installs it gives these errors
PHP Code:
Warning: mysql_query(): 7 is not a valid MySQL-Link resource in /includes/class_core.php on line 395
Warning: mysql_error(): 7 is not a valid MySQL-Link resource in /includes/class_core.php on line 837
Warning: mysql_errno(): 7 is not a valid MySQL-Link resource in /includes/class_core.php on line 855
There seems
but the script redirects too fast to copy the whole error...
SELECT user.*,usertextfield.*,userfield.*, user.userid, options,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
,avatar.avatarpath,NOT ISNULL(customavatar.userid) AS hascustomavatar,customavatar.dateline AS avatardateline, customavatar.width AS avwidth, customavatar.height AS avheight
,customprofilepic.userid AS profilepic, customprofilepic.dateline AS profilepicdateline, customprofilepic.width AS ppwidth, customprofilepic.height AS ppheight
, lastactivity AS lastvisittime
, journals.journal_id
FROM user AS user
LEFT JOIN usertextfield AS usertextfield ON(usertextfield.userid=user.userid)
LEFT JOIN userfield AS userfield ON(userfield.userid=user.userid)
LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON(customavatar.userid = user.userid)
LEFT JOIN customprofilepic AS customprofilepic ON (user.userid = customprofilepic.userid)
LEFT JOIN journals AS journals ON (journals.journalist_id=user.userid) LEFT JOIN customprofilepic AS customprofilepic ON (customprofilepic.userid=user.userid)
WHERE 1=1 AND user.showbirthday > 0 AND IFNULL(YEAR(FROM_DAYS(TO_DAYS(NOW())-TO_DAYS(user.birthday_search))), 0) >= 15 AND IFNULL(YEAR( FROM_DAYS(TO_DAYS(NOW())-TO_DAYS(user.birthday_search))), 0) <= 36 AND ISNULL(customprofilepic.userid)
AND user.usergroupid IN (-1,6,7,9,120,2,5,81,123)
ORDER BY user.username asc
LIMIT 0, 30;
MySQL Error : Not unique table/alias: 'customprofilepic'
Getting this error now...uninstalled the old product and reimported the new one
edit: get this error by email when installing
PHP Code:
Invalid SQL:
DELETE FROM productrequirement WHERE product=''
;
and when the product installs it gives these errors
PHP Code:
Warning: mysql_query(): 7 is not a valid MySQL-Link resource in /includes/class_core.php on line 395
Warning: mysql_error(): 7 is not a valid MySQL-Link resource in /includes/class_core.php on line 837
Warning: mysql_errno(): 7 is not a valid MySQL-Link resource in /includes/class_core.php on line 855
There seems
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'
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
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
Advanced Memberlist Search Details »»
About Developer
Visit Web Site
Uses Plugins 
Is in Beta Stage 
12-27-2005, 03:21 PM
