Adding more fields to the 'register_user" module

Cave_Dweller · Joined: 27 Oct 2008 Posts: 40

I need to collect more information from users who register so I need to add more input fields to the register_user module. Fields: company; city, state, zip; phone; web address, general info about events posted.

This would also mean redoing the template so the the input fields are arranged in a columns vertical format as I want to keep the width to its current dimension.

Adding the fields to the DB using phpMyAdmin is already done and I've tried to modify the fields with no luck.

esoft_ian · Joined: 12 Sep 2005 Posts: 5275

Hi,

RE: Adding the fields to the DB using phpMyAdmin is already done and I've tried to modify the fields with no luck.

Did you add them to a specific table in the database or did you create a new one? How have you tried to modify the fields exactly?

Cave_Dweller · Joined: 27 Oct 2008 Posts: 40

I used phpMyAdmin to add about half dozen new fields to the 'user' table. I did not modify any of the existing fields, just added new ones. The calendar and registration module still function as designed, no problem.

Now I need to change the registration input form, template and subsequent query so it inserts those extra form inputs into the table fields. I added about 6 extra form fields, so the template needs to be changed to a vertical, two column format with the label on the left and input box on the right. The horizontal format will be too wide to fit into my page border.

I tried making changes on a copy of the files in question, but couldn't make anything work. (BTW- I'm a senior citizen who self taught php when I was 65--I get by, but the elegance of your code is beyond me)

(FYI-- I am building a couple of external admin pages that query that table and another new one I just created and list the information from them, They will have no connection or not modify the calendar code in any way.)

esoft_ian · Joined: 12 Sep 2005 Posts: 5275

Hi,

To get the table to be vertical, edit modules/user_registration/reg.php around line 131 and change this part:

Cave_Dweller · Joined: 27 Oct 2008 Posts: 40

Great, that works perfect so far!
Thanks,
John

esoft_ian · Joined: 12 Sep 2005 Posts: 5275

This is no small task.

It looks like next you'd have to change this part of the JavaScript:

Cave_Dweller · Joined: 27 Oct 2008 Posts: 40

I've been through it umpteen times verifying the changes, but when I click the submit button nothing happens.
The table labels are odd, too.

esoft_ian · Joined: 12 Sep 2005 Posts: 5275

Hi,

Do both of the files involved pass PHP validation?

Cave_Dweller · Joined: 27 Oct 2008 Posts: 40

I retyped it with fresh files this morning and found that now the system actually functions in terms of action when the button is pushed and the verification email is sent, but the data from the extra fields was not inserted into the database.

I believe the error that I had up until now was found in the class.userreg_record.php:

list($userid, $password, $email, $name) = explode('|', $ses['session_data'], 4);

Now the new line is

list($userid, $password, $email, $name, $company, $city, $state, $phone, $website, $comments) = explode('|', $ses['session_data'], 10);

I had not changed the number at the end to 10 from 4, which represents the number of variables being insterted into the session,

--AND-- this line
$this->_init($userid, $password, $name, $email);
Needs to be this:
$this->_init($userid, $password, $name, $email, $company, $city, $state, $phone, $website, $comments);

Close, but no cigar.

esoft_ian · Joined: 12 Sep 2005 Posts: 5275

Hi,

So it's getting lost somewhere. When a user registers, before they actually click on the link in the e-mail to activate their account, do you see a record in the thyme_Sessions table with their information in it? A query like this should find it:

select * from thyme_Sessions where session_data like '%userid%';

Where userid is the userid they registered for. Does this line contain the additional information?

esoft_ian · Joined: 12 Sep 2005 Posts: 5275

Ahh... also, I forgot that the user class has its fields assigned in the script rather than reading them from the table. In modules/user_registration/reg.php, you should see a line that looks like this around line 97:

Cave_Dweller · Joined: 27 Oct 2008 Posts: 40

I really appreciate all the time you're spending on this.
Changed that section to

$nuser = new _cal_user($_cal_userreg_record->userid, $_cal_userreg_record->password);
$nuser->userid = $_cal_userreg_record->userid;
$nuser->fields[] = 'pass'; // why? This is done in user module, but why?
$nuser->pass = $_cal_userreg_record->password;
$nuser->access_lvl = 0; // JC Sets PERMISSIONS
$nuser->name = $_cal_userreg_record->name;
$nuser->email = $_cal_userreg_record->email;
$nuser->fields[] = 'company'; //JC adds
$nuser->fields[] = 'city'; //JC adds
$nuser->fields[] = 'state'; //JC adds
$nuser->fields[] = 'phone'; //JC adds
$nuser->fields[] = 'website'; //JC adds
$nuser->fields[] = 'comments'; //JC adds
$nuser->save();

I had it as this, following the convention of the lines right above it.

$nuser = new _cal_user($_cal_userreg_record->userid, $_cal_userreg_record->password);
$nuser->userid = $_cal_userreg_record->userid;
$nuser->fields[] = 'pass'; // why? This is done in user module, but why?
$nuser->pass = $_cal_userreg_record->password;
$nuser->access_lvl = 0; // JC Sets PERMISSIONS
$nuser->name = $_cal_userreg_record->name;
$nuser->company = $_cal_userreg_record->company; //JC adds
$nuser->city = $_cal_userreg_record->city; //JC adds
$nuser->state = $_cal_userreg_record->state; //JC adds
$nuser->phone = $_cal_userreg_record->phone; //JC adds
$nuser->website = $_cal_userreg_record->website; //JC adds
$nuser->comments = $_cal_userreg_record->comments; //JC adds
$nuser->save();

The process is working again, but the new extra fields are not being loaded in. The all show as null in the table.

Please take a look at the form
http://www.meetingsandmixers.com/events/calendar/index.php?module=user_registration

Note that there must be some reference table somewhere on another page that converts some of the form element names to upper and lower case and some don't convert. Again, I followed the convention of the existing lines and 'Phone' was changed to upper and lower case while the other new ones weren't.

$_cal_table = new _cal_table();
$_cal_table->vertical = true;
$_cal_table->print_header(array());
$_cal_table->col_count = 2;

$_cal_table->print_row(array (_USERNAME_,
$form->textbox('new_user', 20, " maxlength=32")));

$_cal_table->print_row(array (_NAME_,$form->textbox('new_name', 20, " maxlength=128")));

$_cal_table->print_row(array (_EMAIL_,$form->textbox('new_email', 20, " maxlength=128")));

$_cal_table->print_row(array (_PASSWORD_,$form->textbox('new_pass', Cool

));

$_cal_table->print_row(array (_COMPANY_,$form->textbox('new_company', 20, " maxlength=128")));

$_cal_table->print_row(array (_CITY_,$form->textbox('new_city', 20, " maxlength=128")));

$_cal_table->print_row(array (_STATE_,$form->textbox('new_state', 20, " maxlength=128")));

$_cal_table->print_row(array (_PHONE_,$form->textbox('new_phone', 20, " maxlength=14")));

$_cal_table->print_row(array (_WEBSITE_,$form->textbox('new_website', 20, " maxlength=128")));

$_cal_table->print_row(array (_COMMENTS_,$form->textbox('new_comments', 20, " maxlength=256")));

$_cal_table->print_row(array("<input type='button' class='button' value='" . _USERREG_REGISTER_ . "' onClick='load()'>"), true);

$_cal_table->print_footer();

esoft_ian · Joined: 12 Sep 2005 Posts: 5275

Instead of using _PHONE_, you can just use "Phone" ..etc.. Change _COMPANY_ to "Company" like so:

esoft_ian · Joined: 12 Sep 2005 Posts: 5275

Actually, if that doesn't work, change this line:

Cave_Dweller · Joined: 27 Oct 2008 Posts: 40

Didn't work, but changing the line to
$nuser->comments = "Test field add";

added Test field add to the comments field in the table. so the data is getting there, it's just not getting collected. All the other new cells were null

Where is this defined?
$_cal_userreg_record