Custom Fields for User Info and Registration

Posted: Fri Feb 25, 2011 12:28 pm

This isn't really an issue, but I couldn't find a features or other type of forum related to RN2.40.1, so I'll post it here.

Mods can move it if necessary:

Here's what I am trying to do. I want to add a custom field to registration that is required. The field is Your Location. The problem is there is already a Your Location field in the User Info area after registering.

If I add a Custom Field in RNYA called Location and make it required for registration it works fine. HOWEVER, once you login and then go to Edit your Profile, there are now two Location Fields. However, when saving your User Info after logging in, it keeps saying Location field is required. I have not made it required for saving info, I've only made it required for registration.

Should I do this:

DEACTIVATE the OLD Location field under RNYA? Then use the new one I made required? That's fine and I can do that, but I'm a little confused as to why the field becomes required for saving info and not just for registration...

or is there a way to make the default Location field that is already there required for registration?

hmm..in the end, I guess this is kind of an ISSUE...lol
Embarassed

EDIT: Now that I think abotu it. I think I would have problems trying to move existing users that have populated the original Location(user_from) field and moving their info to the new Location field.
It would be more practical to make the original location field required for registration and saving info.

Posted: Fri Feb 25, 2011 5:16 pm

The first question I would have is why would you require a field during registration, and then allow them to blank it out when editing there profile?

I can look into making the original required, but I need to know how you have registration set up. Do you require email validation?

Posted: Fri Feb 25, 2011 6:26 pm

Palbin wrote:

The first question I would have is why would you require a field during registration, and then allow them to blank it out when editing there profile?

I can look into making the original required, but I need to know how you have registration set up. Do you require email validation?

First Question: Good one. Makes sense. I didn't think about it until you put it that way. My feeble mind sometimes thinks narrowly. Wink

Second: I have registration setup with Admin Approval. I then approve their registration which sends them an activation email. I only do this as I have had a few spam registrations in the past. This has been alleviated somewhat be requiring Security code upon registration.

I think making the original Location field required for both user registration and editing profile in my case would work best for my site.

P.S. The reason I am doing this is to add a feature in the future to search for users by location or use the sort memberlist by location feature. It's a nice feature I'd like my users to utilize when trying to find other members in their area or in areas they may be visiting in the future.

Posted: Tue Mar 01, 2011 12:23 pm

I notice in the YA Admin the Default Fields have options to be Active or Deactivated. The only Default Field that has the option to be Required is "Use Real Name". What would be great is if all Default Fields had the options to be Active, Deactivated, Required or otherwise.
I'm sure some savvy PHP/MySQL person out there could figure that out.

Posted: Tue Mar 01, 2011 5:13 pm

myrtletrees wrote:

I notice in the YA Admin the Default Fields have options to be Active or Deactivated. The only Default Field that has the option to be Required is "Use Real Name". What would be great is if all Default Fields had the options to be Active, Deactivated, Required or otherwise.
I'm sure some savvy PHP/MySQL person out there could figure that out.

I would be interested in this also, that would be a good feature to have

registered · Site Admin Joined: Jun 04, 2004 Posts: 6437

I am looking into this (the ability to configure all default fields as display in registration, required for registration, etc.

Posted: Tue Mar 08, 2011 8:46 am

Quote:

I think making the original Location field required for both user registration and editing profile in my case would work best for my site.

P.S. The reason I am doing this is to add a feature in the future to search for users by location or use the sort memberlist by location feature. It's a nice feature I'd like my users to utilize when trying to find other members in their area or in areas they may be visiting in the future.

Don't know if this might be of interest re. location but way back when Gremmie released a member map module based on Google Maps. I have it running on my bike club site and it's very popular. See this thread:

Only registered users can see links on this board! Get registered or login!

and follow the links there to Sourceforge to download. Do your own due diligence first as I doubt that you will get any support for the product.

Probably, worth noting that on the site where I use it, I have a separate bike club membership table where I have actual street addresses of the members that I could geo-code into the Map module. Without that information the module might not be very useful.[/url]

Posted: Tue Mar 08, 2011 9:35 am

fkelly wrote:

Quote:

I think making the original Location field required for both user registration and editing profile in my case would work best for my site.

P.S. The reason I am doing this is to add a feature in the future to search for users by location or use the sort memberlist by location feature. It's a nice feature I'd like my users to utilize when trying to find other members in their area or in areas they may be visiting in the future.

Don't know if this might be of interest re. location but way back when Gremmie released a member map module based on Google Maps. I have it running on my bike club site and it's very popular. See this thread:

[/url]http://www.ravenphpscripts.com/posts14985-highlight-map.html[url]

and follow the links there to Sourceforge to download. Do your own due diligence first as I doubt that you will get any support for the product.

Probably, worth noting that on the site where I use it, I have a separate bike club membership table where I have actual street addresses of the members that I could geo-code into the Map module. Without that information the module might not be very useful.[/url]

Wow! that is awesome. I've installed it on my site and am testing it now.

can you explain what you mean by this?

Quote:

Probably, worth noting that on the site where I use it, I have a separate bike club membership table where I have actual street addresses of the members that I could geo-code into the Map module. Without that information the module might not be very useful

That is totally greek to me...

Posted: Tue Mar 08, 2011 9:58 am

I've used the module for some time, very nice Smile

I think he may be referring to the how the map module works, each user has to go there and select a location, it is not populated from the user location field.

Posted: Tue Mar 08, 2011 11:02 am

spasticdonkey wrote:

I've used the module for some time, very nice Smile

I think he may be referring to the how the map module works, each user has to go there and select a location, it is not populated from the user location field.

OKAY, Gotcha. I've added it to our site. So far it seems to be working great. I plan to notify all members to add their location to the Map. I may add a message on the registration pages of the site so users are notified during registration to update their location on the Map module.

Very cool add-on by the way. I'll have to send Gremmie a big kudos for that one!

Posted: Thu Mar 10, 2011 12:51 pm

Got an issue with the new user registration.

For some reason, every new user that registers is being input into the database with the value user_allow_viewonline of 0. This hides their online status Mad

which I do not want.

I changed the Hide Online Status for the default field in the User Admin to DEACTIVATED a long time ago because I do not want users to have the ability to hide their online status. Why then would the system be saving the new user with user_allow_viewonline a value of 0 ?? Question

The only thing I could find after searching through files was in modules/Your Account/public/new_finish.ph on line 127 was this:

Code:

$user_allow_viewonline = (isset($user_allow_viewonline)) ? intval($user_allow_viewonline) : 0;

I tried changing the 1 to a 0 but that made no difference.

Posted: Thu Mar 10, 2011 2:54 pm

Change it to:

Code:




//$user_allow_viewonline = (isset($user_allow_viewonline)) ? intval($user_allow_viewonline) : 0;


$user_allow_viewonline = 1;

You will have to update all previously registered users via phpmyadmin.

Posted: Thu Mar 10, 2011 5:05 pm

Palbin wrote:

Change it to:

Code:




//$user_allow_viewonline = (isset($user_allow_viewonline)) ? intval($user_allow_viewonline) : 0;


$user_allow_viewonline = 1;

You will have to update all previously registered users via phpmyadmin.

Haven't tried that yet, but the problem just got deeper. I had an already registered user modify/save his profile settings. After he did, it changed his Hide Online status to a default of 0 in the DB even though I have that default field deactivated in YA Admin. Question

Posted: Fri Mar 11, 2011 8:18 pm

Quote:

I think he may be referring to the how the map module works, each user has to go there and select a location, it is not populated from the user location field.

Sorry I'm traveling (actually out on the left coast but safe from the tsunami) so I didn't see the earlier posts. What I was referring to was that you can geo-code the Maps module if you have a file with street addresses in it. I did this on my site when I first set up the module. Of course, RNYA tables don't have street addresses in their natural state but on my site I had separate membership tables that I could link to the RN tables and run through a geo-coding program and thus populate the map tables. I don't recall the exact details, sorry. If I had time I'd probably go back and rerun the geo-coding after several years but instead I rely on users who want to to update the Map module. I'm pretty sure the geo-coding program takes your street address and looks up a latitude / longitude set of coordinates and plugs that in. I also vaguely recall that somehow I suppressed street address information from going into the map module because I didn't want to provide that information on a public web site. We have a separate membership module where club members can see each other's addresses but since they have to actually pay money to join it kind of tends to keep hackers out.

Posted: Sat Apr 02, 2011 10:54 am

Still having same issue.

All new registered users are being saved in the database with Hide Online status = ON!

I have that option/field DEACTIVATED in CNYA, yet they are still being put in the DB with the value of ON for hiding online status.

How do I fix this??

I have my user registration set to Activate by Email. Once they click activation link it takes them to their profile page to save their settings. Once they save, the status is being saved as HIDDEN.

Posted: Mon Apr 11, 2011 10:27 am

myrtletrees wrote:

Still having same issue.

All new registered users are being saved in the database with Hide Online status = ON!

I have that option/field DEACTIVATED in CNYA, yet they are still being put in the DB with the value of ON for hiding online status.

How do I fix this??

I have my user registration set to Activate by Email. Once they click activation link it takes them to their profile page to save their settings. Once they save, the status is being saved as HIDDEN.

yup still same issue. Had a few people register and then save their info.

Site Admin/Owner Joined: Aug 27, 2002 Posts: 17088

The `users` table is set to default to 1. I don't know why but I would not agree with that. Here is a portion of the schema:

Field Name: user_allow_viewonline
Default Value: 1

Try changing the Default Value to zero using phpMyAdmin or a similar tool. That should `fix` the new user issue. If that works we can then address the profile update issue.

Posted: Tue Apr 12, 2011 5:48 am

Raven wrote:

The `users` table is set to default to 1. I don't know why but I would not agree with that. Here is a portion of the schema:

Field Name: user_allow_viewonline
Default Value: 1

Try changing the Default Value to zero using phpMyAdmin or a similar tool. That should `fix` the new user issue. If that works we can then address the profile update issue.

I can change the value in the users table all day long and that works fine.

What is not working fine is user registration/activation. No matter what values you save on the profile screen when a new user activates, the values are NOT what they are saved as. I've tested this about 10 times now with new user accounts.

Example:
View Online Status is ALWAYS saved with a value of 0
Allow HTML, BBCODE and Smilies, ALWAYS saves as 1
Allow News Letter, Signature, PM notify, Notify on reply, POPup PM, ALWAYS save with a value of 0.

Those above examples ALWAYS save with those values no matter what you select when you activate/save your profile settings for the first time when activating. And I have no idea why.

Posted: Tue Apr 12, 2011 6:27 am

OKAY everyone. I just tested this again. This is exactly what is happening.

When you click the activation link in the email, it takes you to a page to save your profile. Here are the default values that show up.

Receive Newsletter by Email?: NO
Allow other users to view my email address: NO
Allow your online status to be shown:YES
Always notify me of replies: NO
Notify on new Private Message by Email: NO
Pop up window on new Private Message: NO
Always attach my signature: NO
Always allow BBCode: NO
Always allow HTML: NO
Always enable Smilies: NO

Now, no matter what you change those values to, they ALWAYS end up saving as this:

Receive Newsletter by Email?: NO
Allow other users to view my email address: NO
Allow your online status to be shown:NO
Always notify me of replies:NO
Notify on new Private Message by Email:NO
Pop up window on new Private Message:NO
Always attach my signature:NO
Always allow BBCode: YES
Always allow HTML: YES
Always enable Smilies: YES

This is even after I have replaced the entire Your Account module with a fresh copy from a newly downloaded Raven Package. I only did this to be sure I have not tweaked anything wrong in the original Your account module I had been using.

I'm starting to wonder if there is something wrong with my users table. But if that were the case then wouldn't saving your profile be jacked up all the time? Because after the initial activation save, you can go to your Profile, change those values and then they save fine.

Posted: Tue Apr 12, 2011 9:02 am

Myrtletrees ... I can confirm part of what you posted. I just went into my own system and registered a user and did prints of the before and after. Before being when the user responded to the activation email (after admin approval) and "after" being when the user was activated and went to review his information (aka profile) in YA. Two fields appear to be problematic:

Allow your online status to be shown: BEFORE=Yes, After=NO
Always allow BBCode: Before=No, After = Yes

On my system, in YA configuration, default fields I normally have the "Display Option to Hide Online Status" deactivated. IMHO it is just too much of a PITA to turn on. We researched this a couple of years back and the field has opposite meanings semantically in Forums and YA (if I recall correctly) so I just turn it off. But you are correct: if we have the option set to YES before they save their registration it should stay that way after. Someone will need to dig into the code and see exactly what's going on.

I suspect that the problems you are seeing with Always allow HTML and Always Enable Smilies might be related to your Forums / Administration / Configuration. In mine I have HTML and Smilies turned ON and a new user thus sees YES in those fields both before and after activation. But the BBCODE field is strange. I have that turned on in forums admin and yet a new user sees NO in the "before" situation and YES after. We will need to look into that ... I just checked RNYA registration settings and there is nothing in there that would seem like it contradicts the Forums configuration settings for BBCode.

I will put a link to this thread in our internal tracking system for 2.5. Hopefully, someone will have the time to take a good look at the waiting users area because there are some other changes that it would be beneficial to make also.

Posted: Tue Apr 12, 2011 9:09 am

Oh thank Goodness. I'm not crazy. Well, then again I think the jury may still be out on that one.

Posted: Tue Apr 12, 2011 9:27 am

No, you aren't crazy and I'd love it if they could hang the jury but that's not an option. I have just posted this into our issue tracking. I hope everyone realizes how complicated some of this can be ... I spent a full hour going back and forth between being a user and being an admin and setting and unsetting various options in RNYA and responding the activation emails as a new user and printing the results and comparing and I just touched the surface. It will take many more hours to dig through the code and tables that produce all this and figure out and code and test the appropriate solution.

Posted: Tue Apr 12, 2011 9:45 am

myrtletrees wrote:

I can change the value in the users table all day long and that works fine.

Just to be sure we're on the same page, I'm talking about the schema default value and not the user record value. You only need to change the default value once, not all day Wink

Posted: Tue Apr 12, 2011 9:54 am

fkelly wrote:

No, you aren't crazy and I'd love it if they could hang the jury but that's not an option. I have just posted this into our issue tracking. I hope everyone realizes how complicated some of this can be ... I spent a full hour going back and forth between being a user and being an admin and setting and unsetting various options in RNYA and responding the activation emails as a new user and printing the results and comparing and I just touched the surface. It will take many more hours to dig through the code and tables that produce all this and figure out and code and test the appropriate solution.

True. I've spent many hours on this as well. For now my only solution is to modify each new users account info after they activate and make the changes myself as Admin. Tedious, but not life changing.

Future: As for the Default Fields etc. I'd definitely like to see an option to make any of the default fields required too rather than just Active/Deactivated.

Posted: Tue Apr 12, 2011 9:59 am

Raven wrote:

myrtletrees wrote:

I can change the value in the users table all day long and that works fine.

Just to be sure we're on the same page, I'm talking about the schema default value and not the user record value. You only need to change the default value once, not all day Wink

oooooooh. OK. I gotcha. I didn't make the connection. I'll check that.

EDIT:
That worked Raven. I did not test changing those values on the activation yet, but as default values on activation without changing them, now the values are what they should be as indicated on the screen when you click Save. Confusing?

I'm going to test another new account and try changing those values then save on the activation and see what happens.