Add a select field to the profile

Hey there

I'm still trying to learn all of this and damn this is cool ****. Anyway, I installed the gender hack and was going to use it to install another profile select box. Then I saw the very cool CP tool for adding a field to the profile. It currently only allows you to add a input box. I decieded to modify it so I could add my select box from there. It wasn't very hard and the hack is pretty short.


Here it is in a nutshell
I added a textarea field to the add/edit profile field
if you want the new field to be a dropdown, you enter the dropdown values. each line represents a new option tag.

Ex. you want a new field called "sex" that is a drop down with
the choices male,female, and other.

Make the new field as usual.
Set Field Length. (1 would be a standard dropdown)
Set Maximum Input (I'd leave it at 250)
In the Select Box Items text area type

Male
Female
Other

each on it's own line.


UPDATED for v224 with vbHacker
Click thru for the updated version

[Nomb]

I have this hack installed and it's working great!! I have the code for the admin cp but not in front of me right now. I?ll post a new text file with the corrections.

EDIT Erwin helped me solve my form issues, unrealted to this hack.

[Nomb]

I got my form problems worked out thanks to Erwin in the php forum.

Anyway, if you want your newly created fields to show up in the admin cp correctly, aka, dropdowns and radios actually come up that way instead of plain old text boxes I've got the code.

See my attachment below. I updated Mutt's second revision to the hack. The one that stores everything in the database, the way it should be done. The new text file shows how to alter your admin/user.php file to reflect your new fields.

Also, I made the small addition that mayja pointed out so the fields are saved. It was a minor query error.

I think you can call it final now, no more bugs. Course, I'm working on adding checkboxes. :banana:

BTW, all this is working for me on 2.2.8

[Nomb]

I found one more small bug that wasn't displaying the type dropdown correctly when editting a field in the admin cp. It's fixed and the attachment in the above post has been updated.

Doing these checkboxes isn't easy! I'm close though.

I wonder if they're including this in vB3. Hope so!

[boutwell]

Hmmm....I just (re)installed this on version 2.3.0 and everythign is working fine except for none of the cutom fields are showing up in the user's control panel where they edit their profiles. They are showing up on the registration pages and in the admin CP...anyone know what may be the problem?

Would that be an error in member.php or a template of some sort?

[TheComputerGuy]

Look in the "modifyprofile" edit "$customfields" with $customfield I believe...not tested yet...

[Nomb]

Originally posted by boutwell
Hmmm....I just (re)installed this on version 2.3.0 and everythign is working fine except for none of the cutom fields are showing up in the user's control panel where they edit their profiles. They are showing up on the registration pages and in the admin CP...anyone know what may be the problem?

Would that be an error in member.php or a template of some sort?

That would be an error in member.php, not sure what though.

This could all be part of a small change they made in 2.3.0, not sure because I'm using 2.2.8. Post what you edited and then also post the query that updates the mysql with the custom fields.

[007]

Hey Nomb did you get the checkboxes code working yet?

[danglick]

The user.php code has a couple of errors. In both the 'add user' and the 'edit user' code, the fields are pre-filled with the values of the administrator's profile fields, rather than the user's (or blank in the case of a new record).

Nomb, I'm sure you can figure out how to fix it; but if you'd like me to send you the corrected code I'm using on my site, let me know.

[DigitalDesktops]

i'm still having problems with this. The custom field options won't show up in the User CP. I'm using 2.3.0. The Only thing that was different in the readme was this:

User.php

In my User.php(Line 295) :

PHP Code:

  maketableheader("Custom Profile Fields");
  $userfield=$DB_site->query_first("SELECT * FROM userfield WHERE userid=$userid");

  $profilefields=$DB_site->query("SELECT profilefieldid,title FROM profilefield");
  while ($profilefield=$DB_site->fetch_array($profilefields)) {
    $varname="field$profilefield[profilefieldid]";
    makeinputcode($profilefield[title],"field".$profilefield[profilefieldid],$userfield[$varname]);
  }

  doformfooter("Save Changes");

}

// ###################### Start do update ####################### 


In customfileds.txt posted by Nomb it says to replace this code:

PHP Code:

  maketableheader("Custom Profile Fields");
  $profilefields=$DB_site->query("SELECT profilefieldid,title FROM profilefield");
  while ($profilefield=$DB_site->fetch_array($profilefields)) {
    makeinputcode($profilefield[title],"field".$profilefield[profilefieldid]);
  } 


with this code

PHP Code:

    // new options
    
    maketableheader("Custom Profile Fields");
    $profilefields=$DB_site->query("SELECT *
                                    FROM profilefield
                                    WHERE editable = 1
                                    ORDER BY displayorder");
    while ($profilefield=$DB_site->fetch_array($profilefields)) {
      $profilefieldname="field$profilefield[profilefieldid]";
      if ($bgcolor=="#13486D") {
        $bgcolor="#1C5780";
      } else {
        $bgcolor="#13486D";
      }
      // new options
      $TheField="";
      $optionlines = explode(',', $profilefield[options]);
      $option_bit=$optionlines[0];
      if ($profilefield[type]==1) {
          // radio
          while ($option_bit) {
              $option_bit=trim($option_bit);
              if ($option_bit == $bbuserinfo[$profilefieldname]) { $LocOn = "checked"; } else { $LocOn = ""; }
              $TheField .= "<input type=\"radio\" name=\"$profilefieldname\" value=\"$option_bit\" $LocOn> $option_bit ";
              $option_bit=next($optionlines);
          }
      } elseif ($profilefield[type]==2) {
          // select
          $TheField = "<select size=\"$profilefield[size]\" name=\"$profilefieldname\">";
          while ($option_bit) {
              $option_bit=trim($option_bit);
              if ($option_bit == $bbuserinfo[$profilefieldname]) { $LocOn = "selected"; } else { $LocOn = ""; }
              $TheField .= "<option value=\"$option_bit\" $LocOn>$option_bit</option>";
              $option_bit=next($optionlines);
          }
          $TheField .= "</select>";
      } elseif ($profilefield[type]==3) {
          // textarea
          $bbuserinfo[$profilefieldname]=htmlspecialchars($bbuserinfo[$profilefieldname] );
          $TheField = "<textarea name=\"$profilefieldname\" rows=\"6\" cols=\"40\" wrap=\"physical\">$bbuserinfo[$profilefieldname]</textarea>";
      } else {
          $TheField="<input type=\"text\" class=\"bginput\" name=\"$profilefieldname\" value=\"$bbuserinfo[$profilefieldname]\" size=\"$profilefield[size]\" maxlength=\"$profilefield[maxlength]\">";
       }
    makelabelcode($profilefield[title],$TheField);
    }
    
    // new options 


Can anyone help me with this?

[TMM]

Looks very interesting

Has anyone tried Nomb's latest in 2.2.9? Danglick, maybe you could post the corrected code here...?

Also, could this be made to work with Firefly's lite registration hack?

Thanks,

TMM