Thread: Profile Enhancements - Extra Profile Fields Page
View Single Post
  #157  
Old 01-28-2009, 09:36 AM
GHC Webmaster GHC Webmaster is offline
 
Join Date: Aug 2008
Posts: 57
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by GHC Webmaster View Post
I notice one thing however. Using this code all profile fields from the extra page show on the advanced search form, even if they are set to not be searchable. Anyone an idea why?
Solved this myself, put brackets around the "form = 0 OR form = 6" bit, which makes the complete code edit of memberlist.php for the search function:

FIND line 233 (vB 3.8.1)

Code:
    // Process Custom Fields..
    $userfields = '';
    $profilefields = $db->query_read_slave("
        SELECT profilefieldid, type, data, optional, memberlist, searchable
        FROM " . TABLE_PREFIX . "profilefield
        WHERE form = 0 "
REPLACE WITH

Code:
    // Process Custom Fields.. EDITED
    $userfields = '';
    $profilefields = $db->query_read_slave("
        SELECT profilefieldid, type, data, optional, memberlist, searchable
        FROM " . TABLE_PREFIX . "profilefield
        WHERE form = 0 OR form = 6"
FIND line 905 (vB 3.8.1)

Code:
    // get extra profile fields
    $profilefields = $db->query_read_slave("
        SELECT *
        FROM " . TABLE_PREFIX . "profilefield
        WHERE searchable = 1
            AND form = 0
REPLACE WITH

Code:
    // get extra profile fields.. Edited
    $profilefields = $db->query_read_slave("
        SELECT *
        FROM " . TABLE_PREFIX . "profilefield
        WHERE searchable = 1
            AND (form = 0 OR form = 6)
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01314 seconds
  • Memory Usage 1,765KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD_SHOWPOST
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (4)bbcode_code
  • (1)bbcode_quote
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_box
  • (1)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit_info
  • (1)postbit
  • (1)postbit_onlinestatus
  • (1)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • reputationlevel
  • showthread
Included Files:
  • ./showpost.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showpost_start
  • bbcode_fetch_tags
  • bbcode_create
  • postbit_factory
  • showpost_post
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • showpost_complete