Profile Enhancements - Extra Profile Fields Page

IMPORTANT INSTRUCTIONS for those upgrading to vB 3.6.10!!!

https://vborg.vbsupport.ru/showpost....&postcount=269

EVERYONE: PLEASE BE CRYSTAL CLEAR IN WHAT ISSUES YOU ARE HAVING WITH THIS MOD IF YOU ARE USING IT IN 3.7.x! A 3.7.x version is already in the works.

------------------------------------------------------------

You can find the 3.5.x version of this hack here.

This hack will add an extra page to the User CP. This area can be used for extra profile fields that for one reason or another you would like to split from the main list.

Personally, I use this page for PC specs, but it can also be used for other specs as well (e.g. cars). I have the specs in a dropdown list under the user title in each user's post, as well as in their profile page, but that's another hack You'll see a link to it under Add-Ons to the right.

Here's some examples of how I use this hack (with the Add-On hack, Additional Section within Profile and Dropdown within Posts):
http://www.houseofhelp.com/forums/sh...ad.php?t=39826
http://www.houseofhelp.com/forums/member.php?u=15

# of plugin hooks: 1
# of php page edits: 3
# of new templates: 1
# of template edits: 1
# of new phrases: 2


To install, upload the product and then make the manual edits as listed in the text file.

Don't forget to hit INSTALL!

Support will only be given to people who have hit install.

[Lionel]

This is cool. Thanks for sharing. I have 2 questions.

1-How can I fix the drop down on the extreme right as per image?

2-I am using for boat specs. How do I handle the gut with 2 boats, or do you handle the guy with 2 pc with 2 different config?

[sheryarpatel]

does it work on 3.6.5 or 3.6.4

[calord]

I'd like to make use of this mod, but I admit ...the instructions have me absolutely lost with how to create different pages for different profiles. I simply don't understand the editing of vbphrases, variables, and other such.

It's a gaming site. I need to be able to create "Edit X Profile" pages in the UserCP for each game. For example, users need to be able to create a profile for EVE, VG, and WoW. Please help me accomplish that. I need very specific instructions.

I downloaded the instructions you posted in page 2 of this thread (page.zip) and that just made me more confused. I don't get it. What do I need to edit, where, and how to create these extra pages? Sorry I'm not so VB savvy, I try, but my experiments aren't producing any results. The whole "change the ### to a number" was ....lost on me.

Any help is appreciated, and thank you for your patience.

[Ted S]

Originally Posted by sheryarpatel

does it work on 3.6.5 or 3.6.4

Yes.

[OmniBuzz]

Hello Wired1, first thank you for this hack !
Everything is running fine (I have my extra page, the fields are there, etc.) but I have one simple issue : if I click on a user profile, I have an empty space with the extra page title, but nothing in it...
See the picture file attached if my english is not crystal clear (englsh is not my language)
How could I remove this ?
Thanks in advance for your help.

[Wired1]

Originally Posted by OmniBuzz

Hello Wired1, first thank you for this hack !
Everything is running fine (I have my extra page, the fields are there, etc.) but I have one simple issue : if I click on a user profile, I have an empty space with the extra page title, but nothing in it...
See the picture file attached if my english is not crystal clear (englsh is not my language)
How could I remove this ?
Thanks in advance for your help.

This hack does not touch that area, the Additional Section within Profile and Dropdown within Posts does that. I'd un/reinstall it.

[Tralala]

Originally Posted by Wired1

Read the 3.5.x hack instructions. There's BETA search code in there (which is really just vB's search code w/ one minor change). Search for the new code in 3.6.x (they changed like 1 minor thing in it IIRC), and it should work fine. A proper way to do this would involve a heavy rewrite, which I simply don't have the time for (hence why I haven't been around much).

To clarify, I just tried it... and found what worked for me. This is with this version of the hack, and vBulletin 3.6.5. And now the "extra" fields I choose are showing up in Members List and are searchable too.


All it took was changing two instances of form = 0 to form = 0 OR 6


In memberlist.php:


FIND:

PHP Code:

    $profilefields = $db->query_read_slave("
        SELECT *
        FROM " . TABLE_PREFIX . "profilefield
        WHERE searchable = 1
            WHERE form = 0 " 


REPLACE WITH:

PHP Code:

    $profilefields = $db->query_read_slave("
        SELECT *
        FROM " . TABLE_PREFIX . "profilefield
        WHERE searchable = 1
            WHERE form = 0 OR 6 " 


FIND:

PHP Code:

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


REPLACE WITH:

PHP Code:

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


The only downside is that right now I have three "regular" User Profile fields that I had designated as "not searchable" -- and now, as result of this edit, they appear in the "Members List: Advanced Search." These particular fields don't work, mind you (searching in those fields just ends up showing the entire member list.) Which is fine by me... I didn't want them to be searchable in the first place. But the fact that the fields show up in the Advanced Search might be a bit confusing, that's all.

This is a compromise I am willing to make, because I wanted to have many of the "Extra" Profile Fields I created with this hack to show up in my Member List, and be Searchable... and now they are.

Thanks!

/clicks install

[sross]

Originally Posted by Tralala

To clarify, I just tried it... and found what worked for me.

i tried that same thing and got an error i was hoping it would work.

Invalid SQL:

        SELECT *
        FROM profilefield
        WHERE searchable = 1
            WHERE form = 0 OR 6 
		ORDER BY displayorder;

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 'WHERE form = 0 OR 6 
		ORDER BY displayorder' at line 4
Error Number : 1064
Date         : Sunday, April 29th 2007 @ 06:41:25 PM
Script       : http://www.mysite.org/forums/memberlist.php
Referrer     :

Any ideas? I need these fields to be searchable, getting desperate..

[RedGTiVR6]

Thanks for posting the code.

I will give this a try on our forum and see if it works for us!

I'd really like these fields to be searchable as this would be invaluable market information for our site.

[RedGTiVR6]

has anyone tried this on 3.6.6 or 3.6.7?

I have just upgraded to 3.6.7PL1 and I'm having an issue with the page not showing up under the UserCP.

I'm not sure where to search for this solution.

When I go to the UserCP and click on the link to go to where I would enter in the information, it's the below image:

http://www.mj-garage.com/pics/UserCP.JPG

When I go to the memberinfo page I see the following (yes, other mods installed too, but they are working):

http://www.mj-garage.com/pics/memberinfo.JPG

Thanks for the help anyone can provide!